Overview
This is a guide on how to create two or more term Gradebooks and a final average Gradebook combining the averages of the individual term Gradebooks. Each term average weighs equally in the final average.
This is useful, for example, when individual Gradebooks are required for each term (e.g., each quarter).
In this scenario you will need to create five Gradebooks - one for each quarter and a final average Gradebook. The following image illustrates how these Gradebooks will appear:
Step-by-Step Guide
- From the Gradebooks menu on the navigation bar of your Portal homepage, choose Add/Edit Gradebook for one of your courses.
- Click the Edit link next to the name of the default year-long Gradebook.
- Add "Quarter 1" to the name of the Gradebook and the term label.
- Set the end date to be the last day of Quarter 1.
- Click Submit.
- Back on the Add/Edit page, click the Add New Gradebook button.
- Add "Quarter 2" to the name of the Gradebook and the term label.
- Set the start date and end dates to correspond to the start and end dates of Quarter 2.
- Click Submit.
- Repeat steps 6-9 for the remaining quarter Gradebooks.
- Click the Add New Gradebook button to create the Final Average Gradebook.
- Add Final Average to the name of the Gradebook and the term label.
- Set the Start date to the day after the last day of Quarter 4. Set the end date to two days after the last day of Quarter 4.
- Click Submit.
Helpful hints:
- The Final Average Gradebook will be used to import the averages for each student from each of the quarter Gradebooks. As such, its date span only needs to be the minimum possible of 2 days, but you may choose to set the dates as you please as long as there is no overlap with other Gradebooks.
- We recommend that you run your Gradebooks back-to-back without any days between Gradebooks. For example, if the 2nd Semester starts on January 12, you should end the previous Gradebook on January 11.
- Be sure to give each Gradebook an appropriate name and ensure that the start and end dates are accurate for each term.
- If you have already published grades in a Gradebook, remember to republish after editing the date range.
Final Average
- In the Final Average Gradebook, create four assignments named Q1 Grade, Q2 Grade, Q3 Grade and Q4 Grade and make each worth 100 points.
- Click the Q1 Grade assignment in the Semester 1 Gradebook to access the assignment scoresheet.
- Click the Import Gradebook Scores drop menu and select the Q1 Gradebook.
- Click Save & Exit.
- Repeat steps 2 and 3 for each quarter assignment.
Note: When you import the scores from another Gradebook, the cell value will equal the student's percent score from the imported Gradebook times the maximum value of the assignment. For example, the Q1 Grade assignment in our example is worth 100 points and let's assume the student's average from the Quarter 1 Gradebook is 75%. In this case, importing scores from Quarter 1 will cause the cell to populate with a value of 75 points (a maximum of 100 points multiplied by 0.75).
Confirmation
After the completion of Final Average Gradebook steps, the final average is available for all the imported quarter Gradebooks.