Project

ITP100 Project: Part 1

Create a spreadsheet file that calculates the grade for a class based on the following grading

schema:

The spreadsheet should have one column with all perfect grades and one column with different

points for each assignment. The purpose of this project part is to make sure you know how to

calculate the score before you try to create a software solution for it.

Example of calculating the final exam grade: the student scores 85, 83, 86, 90 on the

exams. These grades sum up to 344 out of 400. The final percentage of the exam score is 60%.

The final grade for exams for this student = 344/400 * 60 = 51.6

Note: This ITP100 class has almost the same grading schema as this project, except Exams 1, 2

& 3 are each 10% of the final grade and Exam 4, which is cumulative, is worth 30% of the final

grade.