Let's do some data for reals.
Let's do some data for reals.
Embedded Files
Here's some real, actual, made up data! Here are two classes of genuine, hardworking, fictional students who are anxious for their final grades. You also want to quickly identify any students with low scores, so that you can give them extra help.Â
You need to:
Make a copy of the spreadsheet
Look over the data for any likely problems. Keep an eye out for typos or problems with names. If you find an issue, make your best guess on how to solve it.
Add 2 columns to the right of Name, and use the Split() function to separate first and last names
Use conditional formatting to highlight any scores below 50 in red
Make a column labeled Quiz Average, and create a formula to average all 3 quiz grades
Make a column labeled Final Grade, and create a formula that computes 60% Quiz Average plus 40% Exam
Below the data, find the average Final Grade for 7th grade and the average for 8th grade. You can use the AVERAGEIF function.
Page updated
Report abuse