Problem
Design a spreadsheet to maintain a grade sheet for a set of students. Include tests and projects, given various weights to each in the calculation of the final grade for each student. Compute the average grade per test and project for the whole class.