Search Tips
Account Management Apps Attendance Call Alerts Classroom Data Imports Data Security Directory Services Google Classroom Integration Grade Export Gradebook Groups Implementation
Lockers LoopMail Mobile School Loop Partner Gradebooks Portals Publishing Registration Sections School Settings Student Record Student Tracker Unification Webmaster Websites
Frequently Asked Questions Document Library Design Services Gallery of Sample Sites Help & Support
Course Outlines On-Site Training Website Training
Account Management Grade Submission Gradebook LoopMail Trackers Miscellaneous

Scenario V - Final Average From Multiple Gradebooks

Goal: Create two or more term gradebooks and a final average gradebook consisting of the averages of the individual term gradebooks. Each term average is equally counted in the final average.

Example: I teach a year long course but need individual term gradebooks. The final grade is the average of the individual term grades.

Note: The example below using quarters as the term.

Create Your Gradebooks

In this scenario you will need to create five gradebooks:four quarter gradebooks and a final average gradebook.. This image illustrates how these gradebooks should be created:

Gradebook Setup.png

1. From the Gradebooks menu on the navigation bar of your Portal homepage, choose Add/Edit Gradebook for one of

your courses.


2. Click the Edit link next the name of the default year long gradebook.


3. Add "Quarter 1" to the name of the gradebook and the term label.


4. Set the end date to be the last day of Quarter 1.


5. Click Submit.


6. Back on the Add/Edit page, click the Add New Gradebook button.


7. Add "Quarter 2" to the name of the gradebook and the term label.


8. Set the start date and end dates to correspond to the start and end dates of Quarter 2.


9. Click Submit.


10. Repeat steps 6-9 for the remaining quarter gradebooks.


10. Click the Add New Gradebook button to create the Final Average gradebook.


11. Add "Final Average" to the name of the gradebook and the term label.


12. Se 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.


13. Click Submit.


Helpful hints:

1The Final Average gradebook will be used to import the averages for each student from all 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 it does not overlap other gradebooks.

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

3, Be sure to give each gradebook an appropriate name and be careful that the start and end dates are accurate for each term.

4. If you have already published grades in a gradebook, remember to republish after editing the date range.

Final Average

1. In the Final Average gradebook, create four assignments named Q1 Grade, Q2 Grade, Q3 Grade and Q4 Grade and make each worth 100 points.


2. Click the Q1 Grade assignment in the Semester 1 gradebook to access the assignment scoresheet.


3. Click the Import Gradebook Scores drop menu and select the Q1 gradebook.


4. Click Save & Exit.


5. Repeat steps 2 and 3 for each quarter assignment.


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 (100 point maximum X 0.75).


Q: How do I go back to view previous term gradebooks?

A: You can always get back to previous gradebooks by going to Add/Edit Gradebook from the Gradebooks menu.


Q: Are gradebook settings unique for each gradebook?

A: Yes, each gradebook has its own unique settings so it is important that you check the settings for each gradebook created. These include weighting, custom codes, grade scales, rounding, and default scores.


Q: What do parents and students see when I publish progress reports?

A: Parents and students will only see the grades you publish. When publishing from multiple gradebooks over the course of a term, students and parents will see a "Current Grades" progress report, which consists of the grades you publish from the current gradebook. If you had published grades from other gradebooks, those progress reports are available to students, parents and teachers via the All Progress Reports menu when viewing the current progress report.


Q: Can I choose which gradebook to use when submitting grades for grade export?

A: Yes. For those using School Loop's Grade Export (an optional feature in School Loop Plus), you should  keep in mind that you will have the option to choose any of your gradebooks as the source of grades to submit. When submitting grades for second semester, for example, be sure to select your second semester gradebook as the source of grades. Some schools require multiple grades per student for certain marking periods (e.g. a second quarter grade and a semester grade). Multiple gradebooks makes such submissions a snap since our system allows you to choose different gradebooks as the source for the various grades you need to submit.