Create a space on the spreadsheet to add values for your project grades, quizzes, midterm grade, and final exam.

For this assignment you will be making a gradebook that will keep your average calculated throughout the semester. You will make this project in Microsoft Excel and will be graded on not only accuracy, but also formatting.
⦁ We will be using two “sheets” on this assignment. Label sheet one as “Gradebook” create a second sheet and name it “GPA”.

⦁ 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.