Project 2 Grade-book
For this assignment, make 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.
(5 pts) We will be using two “sheets” on this assignment. Label sheet one as “Gradebook” create a second sheet and name it “GPA”.
(10 pts) Read through the syllabus to find the weights for each of the grade categories we have. (Because the midterm and final are both at 15% you can average both of them and use 30%) Record these values with a description somewhere on your spreadsheet.
(15 pts) Make a column that lists each homework assignment for the semester (you’ll have to gather this information from the MathLab homework titles and Excel homework titles) and fill in values for your current grades. Calculate the average for this column (Use a formula so that each time a grade is added the average changes as needed.)
(5 pts) Create a space on the spreadsheet to add values for your project grades, quizzes, midterm grade, and final exam.
(30 pts) Calculate your average using the weighted values (Use your actual current grades). Note that your average should change as any grade is changed throughout the spreadsheet.
(10 pts) 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 (Note that at Germanna we only have letter grades A, B, C, D, F. There are no + or – points available.)
On this table create a full credit schedule by assuming a student is taking English 111 (3 credits), MTH 154 (3 credits), BIO 101 (4 credits), ITE 115 (3 credits), and PED 116 (2 credits). Calculate this student’s GPA with grades of A in MTH 154, B in ENG 111 and ITE 115, and C in BIO 101 and PED 116.
For a grade of A, simply multiply by 4, B x 3, etc. You do not need to try to create any fancy formulas here.
(15 pts) Your GPA table should have columns for Class Name, Number of Credits, Grade, Points, GPA (similar to what is shown on the website linked above).
(10 pts) Make sure this table is formatted with borders and/or colors and that the final GPA is clearly distinguishable.
