Manage Grades in the Report Cards Module

TABLE OF CONTENTS

The topics in this chapter describe tasks for manually entering grades, calculating averages, and updating GPAs and credits. 


Manually Enter Course Grades

You can efficiently enter students' grades for a course by specifying which report card columns you want to fill and setting keyboard shortcuts.

  1. On the Shortcut bar, click Report Cards > Ent. Grades.
  2. In the Enter Grades  dialog box, click 1. Enter grades manually, and then click Next.
  3. Refer to the following table to set the specifications on Page 1  of the Specifications: Enter Grades dialog box.

Specifications Page 1

1. Use Which Roster

Do one of the following:

  • To use the current roster, select Current Roster.
  • To use the roster from the day entry forms were printed and disregard any changes made to students' schedules since then, select When Entry Forms Printed.

2. Erase Comments

Do one of the following:

  • To keep comments that were imported during the previous marking period, click No.
  • To erase comments that were imported during the previous marking period, click Yes.

Specifications 3-F

Click Yes for each report card column whose grades you want to enter. When you type a grade into a column and press Enter, the cursor moves to the next chosen column.

  1. Click Page 2 and refer to the following table to set the specifications.

Specifications Page 2

A. Use Re-Defined Number Keys

To use number keys to enter the grades you specify in specifications 1-9, click Yes. Otherwise, click No.

B. Follow New Files spec for student name length

Select the check box if you want to print a report of students' grades for a course using the student name length set in the Specifications: New Files dialog box (Data Base  > New Files  > Specs [Alt+S]).

Specifications 1-9

If you clicked Yes  for A. Use Re-Defined Number Keys, type the grade you want to correspond with the number key. For example, if you type A+ for 1. Assign To Key #1, when you are entering grades and press 1 on your keyboard, A+ is entered.

Note: In a report card column defined as a comment or an absence column, the number keys enter numbers.

  1. Click Done.

The Enter Grades Manually dialog box opens.

  1. For Enter CRS or CRS/SC, type the course number (and section number, if there are multiple sections) of the course whose grades you want to enter.

Note: To search for a course, click . Click the course, and then click Select.

  1. Double-click in a cell, and enter the student's grade.
  2. Press Enter to move your cursor to the next column you chose, indicated by  above it.

Note: To move your cursor back a column, press the Shift and Tab keys at the same time. To move between rows, click the up and down arrow keys

  1. In a comment column, press F6 on your keyboard or click Lookup [F6] on the left of the Enter Grades Manually dialog box to select a comment.
  2. After entering grades, do either of the following:
  • To save your changes, click Accept [F10].
  • To undo your changes, click Abort [Esc].
  1. Click Done.

 


Calculate Averages

Calculate report card column averages through the Calc Avg feature in the Report Card module. You can assign column weights to individual columns after you choose which columns to calculate the average of.

How are averages calculated?

Averages are calculated according to the following:

  • Any column with a weight of 0 isn't included in the calculation.
  • Any column that already has a grade is skipped, unless the Replace Existing Grade option is set to Yes, in which case the grade is overwritten.
  • If any grade is in the Final column, and the Final average isn't the desired average being calculated, the column is skipped.
  • If a grade of I, W, WP, or WF appears in a weighted column, that grade becomes the average.
  • If any user-defined grade is in an Exam column, the exam grade isn't included in the calculation, and the remaining columns are weighted against each other when the average is calculated.
  • If any user-defined grade is in a weighted column, other than an Exam column, an average can't be calculated for this course because the system doesn't know how to process these grades.
  • If a blank entry is found in a weighted column, that column is skipped, and the remaining columns are weighted against each other.
  • When calculating number grade averages, the quality points table isn't used and the value used is equal to the number. Averages are calculated to six decimal places, and then rounded to the closest grade. Fives are always rounded up. For example, a grade of 89.5 becomes a 90, and a grade of 89.49 or 89.499999 becomes an 89. Also, number grades below the minimum grade are raised to the minimum grade when calculating averages.
  • If you choose to calculate averages using Administrator's Plus, averages are calculated to six decimal places using weights in the same manner as number grades. Then the grades are converted back to letter grades based on the following table, which comes programmed into Administrator's Plus and can't be edited:

A+

4.16

B+

3.16

C+

2.16

D+

1.16

F

0.00

A

3.83

B

2.83

C

1.83

D

0.83



A-

3.50

B-

2.50

C-

1.50

D-

0.50



  • Warning: It's not advisable to calculate letter grade averages using Administrator's Plus, and teachers should manually calculate averages

Calculate Averages

  1. In Report Cards, click Calc Avg.
  2. Click 1. Calculate averages, and click Next.
  3. Click next to the Calculate Which Column drop-down list, click a column to calculate, and click Select.

  1. Choose whether or not to replace existing grades by clicking Yes or No for the Replace Existing Grades specification.
  2. Choose which type of grades to calculate by clicking Letter or Number for the Calculate Letter Or Number Grades specification, and click Done.

  1. Enter the weight for each of your columns, and click Done.

Tip: Enter column weights in the following format: 20% =020.00.

Note: The column for which you're calculating an average displays THIS COLUMN BEING CALCULATED.

  1. Click 1. All sections, and click Done.
  2. Optional: To view a report with students' averages for each marking period, click 6. View log, and then click Next.

 


Update GPAs and Credits

You can update GPAs and credits for all students in a grade or for individual students. When you update, you can choose to generate a summary report that lists students’ previous and new GPAs and credits or a detailed report that shows a breakdown of how the GPAs and credits were calculated.

Important: If your school does not have a midyear or semester report card column, the process for updating at the midyear or after the third quarter is different. See Update GPAs and Credits at the Midyear Without a Midyear or Semester Report Card Column or Update GPAs and Credits After the Third Quarter Without a Midyear or Semester Report Card Column.

Warning: We recommend creating a backup of your data before proceeding. See Create and Schedule a Backup.

  1. On the Shortcut bar, click Report Cards > Stat Reps.
  2. Click 2. Grade point averages, and then click Next.
  3. Click 4. Update/un-update GPA’s/credits, and then click Next.
  4. Click 1. Update GPA’s & credits, and then click Next.
    The Specifications dialog box appears.
  5. Next to 1. Update Based On Which Columns, click .
  6. Refer to the following table to select the correct column for the update you want to perform:

To update

Do this

An archival year

Select All Credit Columns, and then click Select.

After the first quarter

Select your first quarter report card column, and then click Select.

At the midyear

Select your midyear or first semester report card column, and then click Select.

After the third quarter

If you have to redo a third quarter update, perform a midyear update first. If you perform a third quarter update more than once in a row, students' GPA data will be lost and you will have to restore data from a backup.

Select your third quarter report card column, and then click Select.

At the end of the year

Select All Credit Columns, and then click Select.

  1. Next to 2. Which Years, click .
  2. Select the year you want to update, and then click Select. If you select an archival year, read the Warning message, and then click Done.

Example

A student transferred to your school for their third year of high school. You have entered their courses for the current year and their courses and grades for their first and second year of high school. To calculate this student's GPAs and credits, you would select Archival Year: -2 to -1 , because there are two previous years. Once there are grades in the current year, this student's GPAs and credits can be updated by selecting Current Year: Year 0 .

  1. For 3. Report Detail, do either of the following:
  • To generate a report of students' previous and new GPAs and credits, click Summary Report.
  • To generate a report that breaks down how students' GPAs and credits were calculated, click Detailed Report.

Note: Because the detailed report can be lengthy, we suggest only generating it if you are verifying how the calculations were done.

  1. If you are updating based on one credit column, for specifications 4-7, type the percentage of the course that has been completed. Refer to the following table.

Note: For third quarter updates, when you set specification 8 to Yes , Administrator's Plus automatically sets specifications 4-7. If you are updating based on All Credit Columns , Administrator's Plus ignores specifications 4-7.

Type of Update

Percentage of Course Completed

First Quarter Update

Full year courses: 25.00

Semester 1 courses: 50.00

Semester 2 courses: 0.00

Quarter courses: 100.00

Midyear Update

Full year courses: 50.00

Semester 1 courses: 100.00

Semester 2 courses: 0.00

Quarter courses: 100.00

  1. For 8. Third Quarter Update, if you are updating after the third quarter, click Yes. Read the Warning  message, and if you want to proceed, click Yes. For all other updates, click No.
  2. Click Done.

Important: If you did an end-of-year update, we recommend transferring this year’s data to the upcoming year. For information, see Transfer Report Cards Data .

 


Update GPAs and Credits at the Midyear Without a Midyear or Semester Report Card Column

If you want to update GPAs and credits at the midyear but your school does not have a midyear or semester report card column, you first need to calculate the average of all quarter grades into an empty report card column, such as the final grade column. Next, you update GPAs and credits using the grades in that column. When you are finished printing reports with the updated GPAs and credits, you clear the grades in the final grade column.

Warning: We recommend creating a backup of your data before proceeding. See Create and Schedule a Backup.

Step 1: Calculate the Average of All Quarter Grades

To calculate the average of all quarter grades into an empty report card column, follow these steps:

  1. On the Shortcut bar, click Report Cards  > Calc Avg.
  2. Click 1. Calculate averages, and then click Next.
    The Specifications dialog box appears.
  3. Set the following specifications:

Specifications for Calculating the Average of Quarter Grades

1. Calculate Which Column

Select your final grade report card column.

2. Replace Existing Grades

Click No.

3. Calculate Letter Or Number Grades

Choose the type of grade your school calculates.

4. Use Minus If Letter Grades

If you chose Letter for specification 3, choose whether to show letter grades with minuses.

5. Use Plus If Letter Grades

If you chose Letter for specification 3, choose whether to show letter grades with pluses.

6. Include Which Sections

Select All Sections.

7. Omit Courses Numbered Lower Than

Enter the lowest numbered course you want to include in the calculation.

8. Omit Courses Numbered Greater Than

Enter the highest numbered course you want to include in the calculation.

9. Start Grade

Select the lowest grade you want to include when calculating averages.

A. End Grade

Select the highest grade you want to include when calculating averages.

B. Minimum Numeric Grade

If you chose Number for specification 3, enter the lowest grade a student can receive regardless of the average the program calculates.

  1. Click Done.

The Enter The Weight For Each Column dialog box appears.

  1. Enter ratios for how 1. First Marking Period and 2. Second Marking Period should be weighted when calculating averages. Set all other report card columns to 0.
  2. Click Done.
  3. In the Final Grade  dialog box, click 1. All sections, and then click Next.
  4. Read the Calculate Average Warning message. If you backed up your data, click Yes.
  5. In the Final Grade  dialog box, click Quit.

Step 2: Update GPAs and Credits at the Midyear

After calculating the average of your quarter grades, update GPAs and credits at the midyear by following these steps:

  1. On the Shortcut bar, click Report Cards  > Stat Reps.
  2. Click 2. Grade point averages, and then click Next.
  3. Click 4. Update/un-update GPA’s/credits, and then click Next.
  4. Click 1. Update GPA’s & credits, and then click Next.
    The Specifications dialog box appears.
  5. Set the following specifications:

Specifications for Updating GPAs and Credits

1. Update Based On Which Columns

  1. Click .
  2. Select your final grade report card column, and then click Select.

2. Which Years

  1. Click .
  2. Select Current Year: Year 0, and then click Select.

3. Report Detail

Do either of the following:

  • To generate a report of students’ previous and new GPAs and credits, click Summary Report.
  • To generate a report that breaks down how students’ GPAs and credits were calculated, click Detailed Report.

Note: Because the detailed report can be lengthy, we suggest only generating it if you are verifying how the calculations were done.

4-7. Percent To Weight [Course Length] Courses

Type the percentage of the course that has been completed:

  • Full year courses: 50.00
  • Semester 1 courses: 100.00
  • Semester 2 courses: 0.00
  • Quarter courses: 100.00

8. Third Quarter Update

Click No. This specification is only used for updating after the third quarter if your report card has a midyear or semester column.

  1. Click Done.

Step: 3 Clear the Final Grade Column

When you are done printing reports with midyear GPAs and credits, clear the final grade column of the averaged grades.

  1. On the Shortcut bar, click Report Cards > Calc Avg.
  2. Select 2. Blank report card column(s), and then click Next.
    The Specifications dialog box appears.
  3. Set the following specifications:

Specifications for Clearing the Final Grade Column

1. First Column To Blank (Erase)

Select your final grade report card column.

2. Second Column To Blank (Erase)

Select Not Selected.

3. Include Which Sections

Select All Sections.

4. Omit Courses Numbered Lower Than

Enter the lowest course number you included when calculating the average of your quarter grades.

5. Omit Courses Numbered Greater Than

Enter the highest course number you included when calculating the average of your quarter grades.

6. Start Grade

Select the lowest grade you included when calculating the average of your quarter grades.

7. End Grade

Select the highest grade you included when calculating the average of your quarter grades.

8. Include Withdrawn Students

Choose whether to clear the final grade columns of withdrawn students.

Important: If you click Yes, all students that are withdrawn from courses between the range you set in specifications 4 and 5 will be re-activated.

9. Include Inactive Students

Choose whether to clear the final grade columns of inactive students.

  1. Click Done.
  2. In the Blank Columns for Which Sections  dialog box, click 1. All sections, and then click Next.
  3. Read the Blank Column(s) Warning message. If you want to proceed, click Yes.

 


Update GPAs and Credits After the Third Quarter Without a Midyear or Semester Report Card Column

If you want to update GPAs and credits after the third quarter but your school does not have a midyear or semester report card column, you first need to calculate the average of all quarter grades into an empty report card column, such as the final grade column. Next, you update GPAs and credits using the grades in that column. When you are finished printing reports with the updated GPAs and credits, you clear the grades in the final grade column.

Warning: We recommend creating a backup of your data before proceeding. See Create and Schedule a Backup.

Step 1: Calculate the Average of All Quarter Grades

To calculate the average of all quarter grades into an empty report card column, follow these steps:

  1. On the Shortcut bar, click Report Cards > Calc Avg.
  2. Click 1. Calculate averages, and then click Next.
    The Specifications dialog box appears.
  3. Set the following specifications:

Specifications for Calculating the Average of Quarter Grades

1. Calculate Which Column

Select your final grade report card column.

2. Replace Existing Grades

Click No.

3. Calculate Letter Or Number Grades

Choose the type of grade your school calculates.

4. Use Minus If Letter Grades

If you chose Letter for specification 3, choose whether to show letter grades with minuses.

5. Use Plus If Letter Grades

If you chose Letter for specification 3, choose whether to show letter grades with pluses.

6. Include Which Sections

Select All Sections.

7. Omit Courses Numbered Lower Than

Enter the lowest numbered course you want to include in the calculation.

8. Omit Courses Numbered Greater Than

Enter the highest numbered course you want to include in the calculation.

9. Start Grade

Select the lowest grade you want to include when calculating averages.

A. End Grade

Select the highest grade you want to include when calculating averages.

B. Minimum Numeric Grade

If you chose Number for specification 3, enter the lowest grade a student can receive regardless of the average the program calculates.

  1. Click Done.
    The Enter The Weight For Each Column dialog box appears.
  2. Enter ratios for how 1. First Marking Period, 2. Second Marking Period, and 5. Third Marking Period should be weighted when calculating averages. Set all other report card columns to 0.
  3. Click Done.
  4. In the Final Grade dialog box, click 1. All sections, and then click Next.
  5. Read the Calculate Average Warning message. If you backed up your data, click Yes.
  6. In the Final Grade dialog box, click Quit.

Step 2: Update GPAs and Credits After the Third Quarter

After calculating the average of your quarter grades, update GPAs and credits after the third quarter by following these steps:

  1. On the Shortcut bar, click Report Cards > Stat Reps.
  2. Click 2. Grade point averages, and then click Next.
  3. Click 4. Update/un-update GPA’s/credits, and then click Next.
  4. Click 1. Update GPA’s & credits, and then click Next.
    The Specifications dialog box appears.
  5. Set the following specifications:

Specifications for Updating GPAs and Credits

1. Update Based On Which Columns

  1. Click .
  2. Select your final grade report card column, and then click Select.

2. Which Years

  1. Click .
  2. Select Current Year: Year 0, and then click Select.

3. Report Detail

Do either of the following:

  • To generate a report of students’ previous and new GPAs and credits, click Summary Report.
  • To generate a report that breaks down how students’ GPAs and credits were calculated, click Detailed Report.

Because the detailed report can be lengthy, we suggest only generating it if you are verifying how the calculations were done.

4-7. Percent To Weight [Course Length] Courses

Type the percentage of the course that has been completed:

  • Full year courses: 75.00
  • Semester 1 courses: 100.00
  • Semester 2 courses: 50.00
  • Quarter courses: 100.00

8. Third Quarter Update

Click No. This specification is only used for updating after the third quarter if your report card has a midyear or semester column.

  1. Click Done.

Step 3: Clear the Final Grade Column

When you are done printing reports with third quarter GPAs and credits, clear the final grade column of the averaged grades.

  1. On the Shortcut bar, click Report Cards > Calc Avg.
  2. Select 2. Blank report card column(s), and then click Next.

The Specifications dialog box appears.

  1. Set the following specifications:

Specifications for Clearing the Final Grade Column

1. First Column To Blank (Erase)

Select your final grade report card column.

2. Second Column To Blank (Erase)

Select Not Selected.

3. Include Which Sections

Select All Sections.

4. Omit Courses Numbered Lower Than

Enter the lowest course number you included when calculating the average of your quarter grades.

5. Omit Courses Numbered Greater Than

Enter the highest course number you included when calculating the average of your quarter grades.

6. Start Grade

Select the lowest grade you included when calculating the average of your quarter grades.

7. End Grade

Select the highest grade you included when calculating the average of your quarter grades.

8. Include Withdrawn Students

Choose whether to clear the final grade columns of withdrawn students.

Important: If you click Yes, all students that are withdrawn from courses between the range you set in specifications 4 and 5 will be re-activated.

9. Include Inactive Students

Choose whether to clear the final grade columns of inactive students.

  1. Click Done.
  2. In the Blank Columns for Which Sections dialog box, click 1. All sections, and then click Next.
  3. Read the Blank Column(s) Warning message. If you want to proceed, click Yes.

 

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.