Education

Student Gradebook

You teach class 10B. Term marks for 30 students are in: two homeworks, a project and an exam, each out of 100. The weights are in row 33 and the grade boundaries in M1:N6. Produce final scores, grades and ranks, a class summary and a grade distribution chart for the parents’ evening.

Deliverable: Weighted final scores, letter grades, ranks, class statistics, a grade distribution with chart, failing scores highlighted, and the list sorted best first.

1. 1Weighted final score15 pts
2. 2Letter grade15 pts
3. 3Class rank10 pts
4. 4Class summary15 pts
5. 5Grade distribution10 pts
6. 6Who needs support?10 pts
7. 7Distribution chart10 pts
8. 8Best first15 pts