Intro to Electrical Controls Semester Scores Posted: Students Exam 1 Exam 2 79 Grade % Top Five Overall Scores Final Exam Total 85 80 Exam 3 100 93 89 89 73 55 56 47 65 95 91 93 94 83 82 76 77 52 66 61 53 85 94 94 91 87 89 78 80 92 87 89 97 74 75 47 64 96 82 91 96 69 81 74 Student Scores Student ID 656-120-2 656-267-4 656-299-8 656-354-3 656-423-5 656-433-8 656-452-0 656-485-7 656-648-6 656-699-6 223-260-8 223-273-8 223-315-1 223-373-1 223-383-6 223-500-8 223-642-7 223-865-0 223-926-7 223-928-5 203-248-7 203-302-1 203-363-7 203-475-2 203-539-3 203-709-8 74 89 87 70 82 94 86 93 90 95 80 100 93 78 74 89 81 88 81 83 86 88 71 84 81 94 97 97 90 71 83 62 87 72 70 88 77 83 76 81 80 89 77 73 72 96 100 90 99 95 96 91 85 72 49 60 51 207 70 70 C Download the CLASS TEST SCORES data file from Canvas. Save the file with your name and the words mid-term exam in the file name. This is a spreadsheet of grades for exam scores. You will be completing the statistics, finish calculating the grades, and figure out who is on the Dean's List (honor roll). You also need to format the spreadsheet to make it look nice and put the numbers in proper formatting. 1. After you open the file, add another sheet and name it "documentation". Add labels for the name of the course you are completing the spreadsheet for, your name, date, and purpose. Then fill in adjacent cells with your name, today's date, and write a brief description of the purpose of the spreadsheet. For the date, use a function that will show both the current date and time in the same cell) when the file is opened. Add the file name to the center footer. 2. The rest of your work will be on the Scores sheet. In rows 1 and 2, merge/center and format the titles nicely. Use merge and center, change the fonts, colors, use cell styles. 3. In B3, add a date function (you choose) and format the date to show 22-Sep-21. 4. In B5, count (using a function) how many students are in this class. 5. Under the row with the count, add 6 or 7 new rows and create the Class Summary statistics as shown below. Use functions for the columns that show Average, Highest scores, and Lowest score. Format with one decimal place. Add the "class summary" label, format with merged cells, rotate the text, add color or use styles. (you may use any colors and styles you want) Average Maximum Minimum Class Summary Exam Exam 1 Exam 2 Exam 3 Final Exam 6. Add borders somewhere on the sheet. You may also add any additional formatting on the sheet as you like. 7. In the Student Scores section of your sheet, you have student ID numbers, their test scores for three exams, and a final exam. For the total in column F, calculate (use a formula) the total for the scores, but the final exam is worth triple (3x) the points shown in column E. Format the total column with two decimal places
