MyGradeBook Help Menu

Scores Spreadsheet

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 By Student.

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.

Contents
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
Updating Scores
Scoring Comments
Non-Numeric Scores
Notes for Elementary Classes



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


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


Update All
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.


Updating Scores
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:

  1. Click in the first score you want to update.
  2. Type in the score you want to give.
  3. 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.
  4. Repeat steps 2 and 3 until you have entered all of the scores.
  5. To save your updates, click the Save button. If you do not want to save your changes, click the Cancel button.
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.




Scoring Comments
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 Category Screen. 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.

























Privacy | Terms of Use | Link To Us | Help | Contact Us
© 1999 - 2017 KMKVGK Inc. All rights reserved
Ver 11.66 - GB - Page generated in 0 seconds