The Scores Spreadsheet screen is the sixth step/screen used in the 5 steps taken
by most teachers when they create a new class. You can also score By Assignment and by
This screen displays and allows you to update all of the scores students have received for assignments
that are due within the date range you specify.
Using the Category Drop Down Box
Using the Show Drop Down Box
Using the Show Grades For Drop Down Box
Using the Show Assignments From and Through fields
Using the Columns and Rows Fields
Using the Update All links
Background Colors Used For Scores
Notes for Elementary Classes
If you want to change the category of scores being displayed, use the Category drop down box to
select a specific category or "All Categories". Your screen is refreshed as soon as you make a different
selection in the Category drop down box with scores in the selected category and any of its sub categories.
If you want to change the type of students being displayed, use the Show drop down box.
Your screen is refreshed as soon as you make a different selection in the Show drop down box.
Show Grades For
If your class uses grading periods, you can use the Show Grades For drop down to control
which grade and percentage is displayed next to each students name. Using the Show Grades For drop down, automatically changes the
start and end date that is used to determine which assignments are displayed. After you select a grading period, you can optionally use the
Show Assignments From and Through fields to for finer control over which assignments are being displayed.
The Elementary Format checkbox in the Class screen controls the
which grade and percentage you see. Click here to learn more about the Elementary Format checkbox.
Show Assignments From and Through fields
The Show Assignments From and Through fields controls which are assignments are displayed by restricting the output to
only those assignments that are due within the specified date range. You can modify the default date range that is used
to determine which assignments are displayed by entering new dates and clicking the Save button.
If your class has grading periods and you use the Show Grades For drop down, the date range used for the Show Assignments
From and Through fields is automatically adjusted based on the selected grading period. After you select a grading period,
you can optionally use the Show Assignments From and Through fields for finer control over which
assignments are being displayed.
Columns and Rows
The columns field indicates how many assignments you want to display per page. The rows field indicates
how many students you want to display before repeating the column headers.
If you want to adjust the number of columns and rows being displayed,
alter the columns and rows fields and click the Save button.
The columns field must be greater than zero and less than 11. You are restricted to showing at most ten assignments
on a single page so your pages load more quickly. However, you can click the PAGE links to go to other
pages of assignments that match the selection criteria you specify. If you want to see all of the
scores in a class, try using one of the Reports.
Clicking an Update All link updates all of the scores in the assignment that have the
default scoring code
based on the score in the first row. As always, you must click the Save to
record your changes.
Background Colors Used For Scores
The background color of the scores is a visual clue indicating what type of
score is in the cell.
White indicates that the score has been entered and it is not over the
maximum allowed by the assignment.
Yellow indicates that no scores have been recorded.
Red indicates that the score recorded is higher than the maximum allowed
by the assignment. You can legitimately give more the maximum defined by the
assignment and some teachers give more points than possible as a form of
extra credit. The red background for scores over the maximum is just a warning.
Once you have placed the cursor in any field, you can use Arrow keys, Enter, TAB, and Shift-TAB to quickly move the cursor from field to field.
NOTE 1 - Arrow keys are not supported with Firefox 2 browsers on Macintosh computers.
NOTE 2 - Macintosh Safari users should use the down arrow key or the Return key above the Shift key when they want to go down one field because the Enter key on the Numeric Keypad will submit the form.
You can use the Enter key on the numeric keypad or the regular Enter key to move quickly from score to
score within a column. You can use the Tab key to move from score to score across a row.
Typical example of updating scores:
Scoring Tip: Teachers normally enter Points Earned in the score fields. However, you can type the percentage a student received and the
screen will automatically convert it to points for you. When you type a score followed by the "%" sign, the screen will
automatically convert the percentage to points for you.
- Click in the first score you want to update.
- Type in the score you want to give.
- Press the Enter key on the numeric keypad or the or Down Arrow to move to the next score in the assignment or click the
Right Arrow or Tab key for the next score for the student.
- Repeat steps 2 and 3 until you have entered all of the scores.
- To save your updates, click the Save button.
If you do not want to save your changes, click the Cancel button.
Each score has a small "C" link next to its input field. If a score has a scoring comment, the "C" link has a yellow background color.
If a score does not have a scoring comment, the "C" link has a white background color.
If you want to add or edit a Scoring Comment, click on the small "C" link to the right of the score and a small window will appear.
When you click the save button in the small window, the comment is automatically saved and the "C" in the main window
will have its background color modified to reflect whether or not there is a comment.
Notes for Elementary Classes
In elementary classes, the grade and percentage for each student are only displayed when the
the selected category or one of its master categories has been flagged to report grades in the
If grades and percentages are shown, you will see a Grade/Percentage In Reporting Category
header followed by the name of the category the grades and percentages are for.