UNIVERSITY OF CISC 200 St.Thomas Introduction to Computer Technology and Business Applications Final Exam May 2024 1. We want to analyze Formula One team budget. Download the file CISC 200 Spring Final Exam Template.xlsx where you have the 2024 Budget and 2023 points got for every Formula 1 Team. You have to: a. Create in Data Sheet, a Pie chart showing Team budget percentage in 2024. Example: 31% Budget 3% 3% 4% 6% 11% 14% 3% 11% 14% b. In the same sheet calculate budget and points and a Column chart showing points got by each team. 1000 900 800 700 600 500 400 300 200 100 0 ■ ALPINE ■ ASTON MARTIN ■ FERRARI ■ HASS ■ MERCEDES ■RED BULL ■ STAKE Points 2023 ■ MCLAREN ■ VISA CASH APP RB ■ WILLIAMS Points2023 ■ALPINE ■MERCEDES ■ASTON MARTIN ■FERRARI ■RED BULL HASS ■STAKE ■MCLAREN ■VISA CASH APP RB WILLIAMS c. In the Sheet Payment, we want to create a table to show the monthly payment that one Team must done to pay its budget depending on the team and the time for payment (1 to 5 years in 1 years interval). Annual interest rate will be 2% for teams that got more points than average in 2023 and 5% for the others. d. In the Year, we want to calculate how many years will the ASTON MARTIN team need for paying its budget if they want to pay $150,000 each month. UNIVERSITY OF CISC 200 St.Thomas Introduction to Computer Technology and Business Applications 2. Access exercise. Note. This exercise is optional for those who got a low score in the MidTerm exam. If you submit it, I will replace your midterm grade by this exercise grade (no matter if this is higher or lower, so think your decision). a) Import from the Team.xlsx file a table named Team having Formula1 Teams. b) Import from the Driver.xlsx file a table named Driver having Formula1 Drivers. c) Create a Table named DriverByTeam to have Teams where any driver is driving. Create relationships you think you have to, adding data shown in the table on the right. d) Create a query to show team name, driver name and points got for all drivers from one country given by parameter. e) Create a Report showing driver name and points group by Teams and total team points like: DriverByTeam 00 ID_Driver ID_Team 1 7 2 7 3 6 4 2 5 3 6 5 7 3 8 6 9 5 10 2 11 1 12 1 13 10 14 6 NAME Driver Points 15 8 ALPINE 16 E. Ocon 58 17 67 49 P. Gasly 62 Team Points 18 8 Sum 120 19 4 ASTON MARTIN F. Alonso 206 L. Stroll 74 Team Points Sum FERRARI 222 20 9 21 10 Team 280 6 C. Leclerc 206 C. Sainz Jr. 200 Team Points Sum 406