Weighted Average from Multiple Gradebooks and Final Exam
Goal: Create two or more separate gradebooks and generate a cumulative grade that consists of the weighted averages from the separate gradebooks, including a final exam grade.
Example: I teach a semester-long class with two quarters. The final grade for the class is the weighted average of two quarter grades at 40% each and 20% for the final exam. I also need to submit the final exam grade using School Loop's Grade Export Feature.
Note: If you are not required to submit a final exam grade separately or do not use School Loop's Grade Export feature, see the final exam variation of Scenario III.
Create Your Gradebooks
In this scenario you will need to create four gradebooks: two quarter-long gradebooks, a final exam gradebook, and one special gradebook for calculating the first semester grade. This image illustrates how these gradebooks should be created:
The Semester 1 gradebook will be used to import the averages for each student from the other gradebooks: Quarter 1, Quarter 2, and Final Exam. In this example, the both the Final Exam and Semester 1 gradebooks are set with the minimum date range of two days each.
To create these gradebooks, hover over the Course Center menu on the navigation bar of your Portal homepage and choose one of your courses from the pull-down menu that appears.
Since School Loop starts you off with a default gradebook, it's easiest to make this the first of your separate gradebooks by simply editing the name and date range. Click the Edit link next the name of the default gradebook in the Course Center.
To create additional gradebooks:
- In the Gradebooks section click the Add New Gradebook button.
- On the next page, enter a name for your gradebook. We recommend that you include the term (e.g. "Algebra I Q2").
- Set the start and end dates to correspond to the first and last day of the grading period.
- Click Submit.
Be sure to give each gradebook an appropriate name and be careful that the start and end dates are accurate for each term.
Hint: We recommend that you run your gradebooks back-to-back without any days between gradebooks. For example, if the 2nd quarter starts on October 16, you should end the previous gradebook on October 15. If there are gaps between gradebooks, assignments due on those dates will not show in appear in any of your gradebooks.
Cumulative Grade Setup
Since the requirements for this scenario are 40% for each quarter and 20% for the final exam, we'll create three new categories. You may name these categories as you please, but for this example we'll use "Q1," "Q2," and "Final Exam." After creating these categories, turn weighting on for the Semester 1 gradebook with Q1 and Q2 set to 40% each and Final Exam set to 20%. Use these hyperlinks to go to the relevant help pages for creating categories and setting weighting.
Create Assignments and Import Gradebook Scores
The Semester 1 gradebook will have three assignments -- one for each of the two quarter gradebooks and one for the final exam. To keep it simple, we'll make all the assignments worth 100 points each. Just be sure to assign the proper category to each of these assignments.
After creating the three assignments -- let's call them Q1 Grade, Q2 Grade and Final Exam -- click the assignment titles in the gradebook to access the Assignment Scoresheet. Use the Import Gradebook Scores drop menu to select the appropriate gradebook as the source. When you import the scores from another gradebook, the cells will populate with the value equal to the student's percentage score from the imported gradebook multiplied by the maximum value of the assignment. For example, the Q1 Grade assignment in our example is worth 100 points; let's assume the student's average from the Quarter 1 gradebook is 75%. In this case, the cell value would be 75 points (100 point maximum X 0.75).
Keep in mind that each gradebook can have its own unique settings so it is important that you check the settings for each gradebook created.
For those using School Loop's Grade Export (an optional feature in School Loop Plus), you should also 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 quarter, for example, be sure to select your second quarter 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.
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.