Snapshot Comparison

Tool Search: Snapshot Comparison

The Snapshot Comparison Report generates a CSV file that allows users to compare a student's posted grade and/or in-progress grade against a snapshot grade calculated on what the student's grade would have been if it was calculated based only the assignments due between the entered Snapshot Start and Snapshot End dates.

screenshot of the snapshot comparison report

Report Logic

Only Grading Tasks are used in this report; Standards are not included.

Assignments BEFORE the entered Snapshot Start Date and AFTER the entered Snapshot End Date are ignored.

Grade Calculations Examples

An accurate snapshot reports for the following grading scenarios:

  • Simple points-based grading
  • Composite Grading, including: Posted, Not Posted, Blended Posted and In-Progress, Multi-tier (quarters/semesters/final), Cumulative Grading Tasks
  • Weighted Categories
  • Unweighted Categories
  • Cumulative Grading
  • Standards Rollup to Task
  • Drop Lowest Category Configuration
  • Missing Flagged Assignments, including:  Calendar-defined Percentage and No grading impact
  • Cheated Flagged Assignments
  • Exempt Flagged Assignments
  • Individualized Assignment Due Dates
  • Assignment Mark-Scored Assignments

One-Time Grading Tasks do not produce a snapshot grade.

The following table identifies common grade calculations and what the expected report output is for that combination.

Report ExamplesReport Output

Generating the snapshot for a grading task that is the parent of a composite calculation. 


In this scenario, all of the child tasks in the composite calculation have posted grades as of the date the report is generated.

When the report is generated for the parent task of a composite grade, the posted grades for the child tasks are always used in the composite calculation no matter what the in-progress grade is in the snapshot date range. 



Generating the snapshot for a grading task that is the parent of a composite calculation. 


In this scenario, some of the child tasks in the composite calculation have posted grades and others have in-progress grades only.

When the report is generated for the parent task of a composite grade, the posted grades for the child task(s) are always used in the composite calculation when they exist. If there is no posted grade for the child task(s), the in-progress grade from the snaphot date range is used in the calculation.
A grading task that has no assignments associated with it.A snapshot grade IS NOT reported.

Category configuration to drop the lowest assignment

When the lowest scored assignment falls within the entered date range for snapshot, it is dropped.


When the student's lowest grade does not fall within the snapshot range, the lowest score in the date range is found and that assignment is dropped for the snapshot grade.

Grading Task has exempt assignmentsExempt assignments are excluded from snapshot grade calculation.

Grading Task has assignments with a CH (cheated) flag

The assignment score is 0 and is used in the snapshot grade calculation.
Grading Task has assignments with an X (exempt) flagThe assignment is excluded from snapshot grade calculation.
Grading Task has assignments with a Dr (dropped) flagThe assignment is excluded from snapshot grade calculation.
Grading Task has assignments with an M (missing) flagThe assignment score percentage is controlled by the preferences for the missing score value. This assignment is used in the snapshot grade calculation.
Grading Task with no grade calculation in a termThis does not provide a snapshot grade for the grading task for the specific term.

In-Progress Grade Calculation, grading scale choice

The returned score and percentage matches the chosen grading scale.
In-Progress Grade Calculation with weight categoriesThe assignment percentage represents the weight factor in the snapshot grade calculation.
In-Progress Grade Calculation using the score percent value checkboxThe assignment percent earned is used instead of the points earned in the snapshot calculation.
In-Progress Grade Calculation, limit assignments to last X

This recalculates to find the last X assignments in the snapshot date range.

In-Progress grade Calculation, cumulative grading starting in X Term


Several results could occur with this situation. The following captures some of the options available.

ScenarioReport Example
Term 4 in-progress grade calculation is set up to be cumulative starting in Term 3. The report looks at Term 4 and the date range looks at dates that fall within Term 4.Assignments within the date range are recalculated and then combined with the previous term's in-progress grade as the grade calculation is set to still be cumulative starting in the previous term.
Term 4 in-progress grade calculation is set up to be cumulative starting in Term 3. The report looks at Term 3 and Term 4 and the date range looks at dates that fall within Term 4.Assignments within the date range are recalculated to make a snapshot grade for the last term, while combined with the previous term's in-progress grade as the grade calculation is set to still be cumulative starting in the previous term. The previous term does not have assignments in this date range so the snapshot grade does not have any scores from Term 3. A snapshot score is still calculated.
Term 4 in-progress grade calculation is set up to be cumulative starting in Term 3. The report looks at Term 3 and 4 and the date range looks at dates that fall within Term 3 and Term 4.Terms 3 and 4 each have their own snapshot grade calculated. Term 3 calculates on assignments in the task in Term 3 for the given date range and depending on grade calculations, populated a snapshot score. Term 4 calculates on assignments in the task in Term 3 and Term 4 for assignments due in the given date range.
Term 4 in-progress grade calculation is set up to be cumulative starting in Term 3. The report looks at Term 3 and the date range looks at dates that fall within Term 3 and Term 4.A snapshot grade is calculated only for the Term 3 Grading Task with the assignments for that term and task within the range. No snapshot is calculated for Term 4.
Standards roll up into a Grading TaskSnapshot grade calculation is based off of percent based grades. If there is no percent for the end Grading Task, there is no snapshot grade.
Weighted categoriesThis assignment percentage put into the snapshot grade calculator represents the weight factor in the snapshot grade calculation.
Weighted categories with composite gradesEach assignment percentage put into the snapshot grade calculator represents the weight factor in the snapshot grade calculation.

Category Excluded from Grade Calculation, last X calculation

Category total is not calculated when category is marked Exclude from Calculation and Last X Assignments is used for the term/task. Assignments in that category are ignored when determining the snapshot grade.

Category Excluded from Grade Calculation, not last X calculation

Any assignments in this category are not used in the snapshot grade calculator.

Assignment Excluded from Grade Calculation

Any assignments marked to be excluded are not used in the snapshot grade calculator.

Rolling up multiple child standards into a parent standardStandards are not included in the report.
Rolling up multiple child standards into a parent standard and then rolling those into a Grading TaskSnapshot grade calculation is based off of percent based grades. If there is no percent for the end Grading Task, there is no snapshot grade. If there is a percentage, the snapshot grade is calculated.
Snapshot start date or end date in a different term then selected on report

Expected result would vary based on grade calculation options and what is marked as preferences for the report.

A Snapshot Grade reports for any assignment due dates that fall within the snapshot date range for the selected term/task combination.

Snapshot date range in a different term then selected on reportNo Snapshot Grade is reported.
Snapshot start date or end date in the previous year (2019) of calendar end date (2020)

A Snapshot Grade reports for any assignment due dates that fall within the snapshot date range for the selected term/task combination.

Assignment has individualized dates for studentsAssignments being fed to the Snapshot Grade Calculator respect an individualized date off the assignment if it exists for the student.


Report Editor

FieldDescription
Which Courses/Teachers would you like to include in the Report?

Selected teachers AND courses are included in the report. Only those teachers considered Primary are listed. Only active courses are available for selection.


If all teachers are selected but only one math class is selected, for example, the report generates snapshot grades for the one teacher who teaches the math class.


All teachers and all courses can be selected, but because of the complexity of the report, it is suggested that the selection be limited. If a large amount of teachers and courses are selected, use the Submit to Batch option, instead of the Generate Report option.

Which Grading Tasks and Terms would you like to include in the Report? 

Selected terms AND grading task are included in the report.


If all terms are selected, but only one grading task is selected, for example, the report generates snapshot grades for the grading task graded in the terms.


A term and grading task must be selected in order to generate the report.

Which Assignments would you like to include in the Report? 

Snapshot Dates are entered to help narrow assignments to compare the snapshot score for the snapshot range against the student's posted and in-progress grades they have today.


Only one date needs to be entered. Dates are entered in mmddyy format or use the calendar icon to select a date.

Report GenerationUse the Generate Report option to display the results of the report immediately. Use the Submit to Batch option to generate the report at a specified time. This option is helpful when there are many selected teachers and courses.

Generate the Report

A year, school, calendar and schedule structure must be selected in order to generate the report.

  1. Select a Primary Teacher and a Course for the Which Courses/Teachers would you like to include in the Report? section.
  2. Select a Grading Term and a Grading Task for the Which Grading Tasks and Terms would you like to include in the Report? section.
  3. Enter a Snapshot Start Date and/or Snapshot End Date for the Which Assignments would you like to include in the Snapshot? section.
  4. Click the Generate Report button to display the results of the report immediately, or click the Submit to Batch button to choose when the report generates. The report displays in CSV format. Expand the column sizes as needed to show the full text of the report data.

Screenshot of an example of the report.Snapshot Comparison Report

Snapshot Comparison Report Layout

Data ElementDescriptionType, Format and LengthCampus DatabaseCampus Interface
Teacher NameReports the primary teacher's first and last name.Alphanumeric, 50 characters

Section.teacherDisplay

SectionStaffHistory. staffType


Scheduling > Courses > Course > Section > Staff History > Primary Teacher
Course NumberReports the number assigned to the course.Numeric,Course.numberScheduling > Courses > Course > Number
Course NameReports the name of the course.AlphanumericCourse.nameScheduling > Courses > Course > Name
Section NumberReports the section number of the course.Numeric,Section.numberScheduling > Courses > Course > Section > Section Number
Student NumberReports the district-assigned student identification number.Numeric,Person.studentNumberCensus > People >Demographics > Person Identifiers > Local Student Number
Student Last NameReports the student's legal last name.Alphanumeric, 50 charactersIdentity.lastNameCensus > People >Demographics > Person Information > Last Name
Student First NameReports the student's legal first name.Alphanumeric, 50 charactersIdentity.firstNameCensus > People >Demographics > Person Information > First Name
TermReports the selected Grading Term chosen on the report editor.Alphanumeric, 10 charactersTerm.nameSystem Administration > Calendar > Calendar > Terms > Name
TaskReports the selected Grading Tasks chosen on the report editor that are assigned to the course.Alphanumeric, 2000 charactersGradingTask.nameScheduling > Courses > Course > Grading Tasks
Posted Date

Lists the date of the posted score, if it exists.

Date field, 10 charactersGradingScore.dateStudent Information> General > Grades
Posted PercentLists the percentage of the posted grade, if it exists.Numeric, 6 digitsGradingScore.percentStudent Information> General > Grades
Posted ScoreLists the posted score, if it exists.Alphanumeric, 10 charactersGradingScore.scoreStudent Information > General > Grades
Progress PercentLists the percentage of the in-progress grade, if it exists.Numeric, 6 digitsGradingScore. progressPercentStudent Information > General > Grades
Progress ScoreLists the score of the in-progress grade, if it exists.Alphanumeric, 10 charactersGradingScore. progressScoreStudent Information > General > Grades
Snapshot Start DateLists the start date of the snapshot comparison entered on the report editor.Date field, 10 charactersData not storedData not stored
Snapshot End DateLists the end date of the snapshot comparison entered on the report editor.Date field, 10 charactersData not storedData not stored
Snapshot Percent

Lists the percentage of the snapshot grade.


This value is found by only including assignments due on or after the entered Snapshot Start Date and on or before the entered Snapshot End Date.


A blank value reports when there would not have been a calculated in-progress percent for the selected term and task on the Snapshot Date. This is due to there being no assignments, or no evidence to calculate a percent, or the entered date is before the selected term.

Numeric, 6 digitsData not storedData not stored
Snapshot Score

Lists the score of the snapshot grade.


This value is found by only including assignments due on or after the entered Snapshot Start Date and on or before the Snapshot End Date.


A blank value reports when there would not have been a calculated in-progress grade for the selected term and task on the Snapshot Date. This is due to there being no assignments, or no evidence to calculate a percent, or the entered date is before the selected term.

Alphanumeric, 10 charactersData not storedData not stored