Another project for the LTEC 3440 course is the creation of an Excel-based grade book. Building a web-based grade book was also an option, but I preferred the Excel approach. Here’s a partial screenshot of the gradebook:
It takes into account quizzes, exams and assignments. Each of those three categories is weighted as a percentage of the total grade. Those weights are entered into the box at the bottom. Also at the bottom, is a field where the total number of available points for each category can be entered. For my example, I used four quizzes, four exams and eight assignments. Based on grades input for each, the weighted formula calculates a final grade and automatically assigns a letter grade to the student. Below the student list is a listing of class statistics including high grade, low grade and average grade for the class overall.
I may tinker with it here and there between now and the time it’s due in order to see what other interesting functions I can add to it.
Of course it had to be green, right?
Looks fantastic!
Yes, it has to be green. Mine uses the green color as well. I don’t know why I should really.
Your gradebook looks really good! I used 4 Exams, 3 Quizzes, Paper, Group Project and 4 Assignments. I didn’t use green
I should of!