Calculate your average using the weighted values . Note that your average should change as any grade is changed throughout the spreadsheet.

Project 2 Gradebook

⦁ Read through the syllabus to find the weights for each of the grade categories we have.Record these values with a description somewhere on your spreadsheet.
⦁ Make a column that lists each homework assignment for the semester and fill in values for your current grades. Calculate the average for this column
⦁ Create a space on the spreadsheet to add values for your project grades, quizzes, midterm grade, and final exam.
⦁ Calculate your average using the weighted values . Note that your average should change as any grade is changed throughout the spreadsheet.
⦁Format the information as needed to make it “reader friendly”. Use various colors, borders, etc so that your sheet isn’t just a table of numbers. Make sure the final average is easy to find and distinguishable from the other data.
On the second sheet, you are to make a table of values that calculates a student’s GPA. See this website for a brief description on calculating GPA: http://www.back2college.com/gpa.htm