Designing Your Grading System Overview

Final (overall) semester or year grades appear in the spreadsheet in the final right column titled Grade. They are letter grades, unless you choose the option Use Numeric Grades, and are assigned to each student based on the calculated average in each student's Avg column that appears on the far right of the screen. Unless you choose alternative averaging methods, the computer calculated number Avg is the average of the percent correct on all tests included in the gradebook. If you set GradeQuick to calculate semester grades, they can be shown as the final grade in the far right column in place of the year grade.

 

Grades, letter or numeric, are also assigned to Term Subtotals (marking periods within the semester or year) and to special scores, such as a Final Exam, if the Term row is blank. The term grades appear in the subtotal column for each Term, and can be seen by clicking View > Subtotals, and then selecting Term in the dialog box. 

 

Note    Remember, in this help file, the words "assign grades" or "assigned letter grades" refer to grades that are assigned to calculated averages based on your grade scale. They do not refer to letter grades (non-numeric symbols) that you can enter instead of numbers as student scores on a particular test. For schools that do not assign letter grades at all, the words “Assign Grades” mean the numeric grades assigned in place of letter grades, not the numeric calculated averages.

 

The scale you select or design determines the letter or numeric grade that will be assigned to these number averages. The Auto-Assign mode you select determines whether those grades are automatically updated to reflect calculated averages, or whether they remain unchanged until you request an update.

 

Any changes you make in the Grading menu defaults, such as check marking Auto-Assign items or not, are considered essential to the class data and are saved as part of the gradebook. They will not overwrite your choices in previously created gradebooks unless you copy them using Gradebook to Gradebook Copy.

 

Related topics

Customizing Grade Scales

Auto-Assign Grades

Using Grade Symbols

Numeric Grades

Averaging Grades

Creating Semester Subtotals in Gradebooks

 

Customizing Grade Scales

Grading Scales in GradeQuick use “cutoff” values to determine which grades will be assigned to which averages. Cutoff values refer to the minimum value to which each grade will be assigned. You may choose to use the standard grading scales built into GradeQuick, or you may wish to modify them or create your own grades and cutoff values.

 

Related topics

Using Standard Grade Scales

Modifying Standard Grade Scales

Using a 12 point or 4 point (or similar type) grading system

Customizing Grade Scale Names

Using & Defining New & Long Grade Names

Using Pass/Fail Grading

Multiple Grade Scales

Assigning a Different Grading Scale to a Student

 

Using Standard Grade Scales

Unless you change the scale, GradeQuick assigns letter grades to calculated averages for semesters or terms using the pre-set default A-F, Standard A,B,C,D,F Without +/- scale. The cutoff values, in percent, for the standard scale are A=90-100, B=80-89, C=70-79, D=60-69, and F=0-59. This means that if a student has an overall cumulative average of 80%, GradeQuick will assign a B for the final grade.

 

By selecting Standard A,B,C,D,F with +/- in the Grading >Set Grading Scale dialog box and clicking OK, you can switch to the scale which assigns grades based on the following cut-off values: A+=97-100; A=93-96, A-=90-92; B+=87-89, B=83-86, B-=80-82, etc. Using this scale, the same student with an overall average of 80% would receive a B-, not a B, for his final grade.

 

Modifying Standard Grade Scales

To switch or modify either of the two scales:

  1. Click Grading > Set Grading Scale. A dialog box with the current grading scale will be displayed.

     

    Set grade scale options

     

  2. You may select Standard A,B,C,D,F with +/- or Standard A,B,C,D,F without +/- for display in the dialog box.

  3. The Set Grading Scale dialog box displays the grades and cutoff values. The letter grades assigned can actually be letters, numbers or words. Whatever scale appears in the dialog box is the scale that will be used to assign grades for students where Gscale is equal to 1 unless you change it. 

 

If test scores have been entered for the gradebook you are accessing, you will notice two columns to the right of each grade titled Number and % of Class. In Auto-Assign mode, the numbers in these columns reflect the distribution of the overall averages. If you are assigning grades with the Auto-Assign mode off, the numbers reflect the distribution for the column to which the current grade scale applies.

·         The first column, titled Number, indicates how many students in that particular class fall within each grade range.

·         The second column, titled % of Class, shows the percent of the class falling within that range.

·         If you change the grade cutoff values for any grade, the numbers instantly change, showing you the effect your scale has on the grade distribution. For example, if you change the lowest score needed for an A grade from 90 to 87, you will immediately see how many more students will receive an A with that new scale.

 

To change the minimum value of a current grade on the scale:

1.      Click any grade or the Cutoff value (minimum score) needed to earn it.

2.      If, for example, you are changing the value of B, but keeping the B itself, then click the Cutoff value for B, which is pre-set for 80%. The 80% will appear in the text box next to the Make Change button.

3.      Enter the lowest score for which you want to assign the grade you’ve selected. For example, if you now want the B grades given to scores of 75%-90%, then type 75. Press the Enter key to enter the new cutoff value and simultaneously move the selection down in the list, tab to enter the new cutoff value and move the selection sideways or click the Make Change button to keep the selection stationary. You can also change the letters A, B etc. to numbers like 3 or 4 if your school uses that type of scale.

4.      Check the list of Grades and Cutoff values and be sure that the grading scale has been modified to your satisfaction, then click OK to return to the spreadsheet. Click Cancel if you do not want to change the scale from the way it appeared when the dialog box first opened. Click OK if you want to accept the changes you made.

 

Note     

·         You may use the Grade Scale to round your grades. In other words, if you want an 89.6 to round to an A, set the cut-off for the A at 89.5, not 90.

·         The lowest grade (by default, ‘F’) must have 0 as the minimum cutoff value or your grades will be assigned incorrectly or not at all.

 

Using a 12 point or 4 point (or similar type) grading system

You may use scales other than the standard ones in the dialog box. For example, you may prefer to use a 12 point scale or a 1 to 4 scale. This is easily done in one of two ways, depending on how you want to enter scores and how you want your averages to appear.

 

Caution

Do not click either of the scale buttons after you have modified any values unless you want to replace your modified custom scale with one of the standard scales. Remember that whatever scale appears in the Set Grading Scale dialog list is the one that will be used when you assign grades. If you want to use your grade scale in other gradebooks, you can use the Gradebook to Gradebook Copy.

 

Customizing Grade Scale Names

Grading scales in GradeQuick have default names of Grading Scale1, Grading Scale2, etc. If you wish, you can change these to something more meaningful to you (e.g., Academic Core Scale, 4th Grade Scale, etc.). To add a custom name to a grading scale:

 

  1. Click Grading > Set Grading Scale.

    2.      Select the scale you want (e.g. Scale 1) from the pull-down list. 

  2. Click the Change Scale Name button.

  3. In the Edit Scale Name pop-up, enter the new scale name in the field.

  4. Click OK to save the new name.
    The new name appears in the pull-down list, with the original scale number preceding it. Modify the scale values, as needed.

 

Using & Defining New & Long Grade Names

You may wish to define another grade that is not on the scale at all. For example, instead of 0-60=F, you may wish to establish 46-60=Unsatisfactory, and 0-45=F.

 

To add another grade to the grade scale:

  1. Click Grading > Set Grading Scale.

  2. In the grade list, scroll down to New Grade and highlight it.

  3. Enter the name or mark for the new grade in the Grade text box.

  4. Enter a minimum numeric score for the grade in the Cutoff box.

  5. Click the Make Change button to add the new grade to the grade list.

  6. Click OK to exit. 

 

Note    New grade names may be long names and may contain 20 characters. Only three characters will be displayed in the spreadsheet, but you may choose to print the long grade name. In this way, you may create as many new grades as you wish for your special scale.

 

You may also wish to define new grades for your entire scale rather than merely modifying standard scales or adding a few new grades. For example, you may want to build a scale such that SS=90-100, GD=70-89, NH=0-69. (SS=Shows Strength, GD=Good, NH=Needs Help), so that GradeQuick will assign a GD, not a B, to a student whose average is 80.

 

  1. Click Grading > Set Grading Scale.

  2.  Click Clear Grading Scale in the dialog box that appears. This will clear all the grades from the scale.

  3. Click New Grade as explained in the above paragraph to create each grade in your new scale.

 

Using Pass/Fail Grading

For classes where you want to give all Pass/Fail grades, select Clear Grading Scale and then modify the grading scale as described above. Define your new grade as P and assign its lowest value, for example, to be 60. Then define F with a value of 0. All students receiving 60 or above would receive a P and the rest an F.

 

If only some students are taking the class Pass/Fail, use the Multiple Grading Scales feature to set up both your main grading scale and a Pass/Fail system.

 

Multiple Grade Scales

If you have students in your classes who must be judged on a grade scale different from the rest of the class, such as students who are taking a class pass-fail, or students who are in alternative programs, you can set up one or more grade scales for such situations. The grade scale you choose for the student will be used to assign grades for all term subtotals and the final grade. You can set up to 30 grade scales for each class, and decide which students to assign to which scale. For example, most students with a 95% would receive an A, but students with a different scale might be assigned a Pass or an A+ for that same average.

 

To set up multiple grading scales:

·     Click Grading > Set Grading Scale. The grading scale that is already set will be Scale Number 1. You can change this scale, or leave it as your default. If you do not set any additional scales, or if you do not assign a new scale to a specific student, this scale will be used.

·     To set a second grading scale, select Scale Number 2 at the top of the dialog box. Enter a new grade and its cutoff value. Create as many grade scales are you need. You can use the same grades in multiple grade scales, assigning them new values, or you can use new grades. Remember to click OK before exiting to save your changes.

·     To assign a grading scale to a student, enter the scale number in the student information field GScale. For example, if a student is being graded using Scale Number 3, enter a 3 next to GScale. If you enter a number in a student’s information field for a grade scale that has not yet been set, the student will no longer have a final grade. If you delete the Gscale number, GradeQuick will default to Scale Number 1. To enter Grading Scale Numbers for each student quickly, you can choose to display a column for GScale on your gradebook spreadsheet by selecting the field GScale in the ViewàStudent Info dialog box.

 

 

If you have set GradeQuick to calculate final grades by averaging term grades, you will have to set a grade equivalent scale for each grade scale that you set.

 

If you click the Standard A,B,C,D,F with/without +/- buttons, your current scale will be replaced, whether or not you are currently using grades of A-F. If you have inadvertently chosen one of these buttons, click cancel to exit the dialog box, instead of OK, to drop any changes you have made since entering the Grading Scale dialog.

 

Note    If your school has a site license, your grading scales may already be set for you, so you would not have to set them at all! However, you will still have to follow step 3 above to assign grading scales to your students, or all students will use Grade Scale 1.

 

Assigning a Different Grading Scale to a Student

Grading Scale 1 is the default scale used to calculate all student grades in the gradebook. If you have defined multiple grading scales, you can use multiple scales within the same gradebook. If you grade certain students differently, simply assign the appropriate scale to them. To assign a new scale to a student:

 

GScale number identifies grade scale used for each student

 

1.      Click View > Student Info. The Information About Each Student dialog will display.

2.      Under Data Fields to show, click GScale, and then click OK. A GScale column will be added to the main spreadsheet.

3.      Find the student you want and click the “1” in the GScale column, then right-click.

4.      From the pop-up menu, move to Select Grade Scale and click the grade scale you want to use for the selected student. The new scale ID will appear in the cell and the student’s grade will be calculated using the new scale.

 

Overwriting Grades

You may overwrite any test or assignment score you have previously entered in your gradebook. You may also overwrite any letter or numeric grade that has been assigned to a calculated average for a Term, special score or overall average in your gradebook. For example, you may want to overwrite a grade if a student has not completed all their work and needs a grade of ‘incomplete until the work is completed. Or, you may want to raise or lower a grade based on behavior or other work that has not been calculated in the average.

 

To overwrite a grade, click the grade you want to change, and type in the revised grade. The overwritten grade will be displayed in green, alerting you to the fact that the grade was overwritten. When a grade is overwritten, the average for the marking period will continue to re-calculate should you add other scores, but the grade itself will no longer be automatically assigned or updated. The overwritten grade will remain until you decide to change it or remove its overwritten designation. 

 

If you want to use overwritten grades in calculating final averages, select Average Term Grades to Calculate Final Grades from the Grading Preferences dialog.

 

To restore an overwritten grade, double-click the grade and press Delete, then the Enter key. The grade will then be automatically assigned based on the grade scale, if grades for this column are being automatically assigned. If grades have been frozen, the grade will remain blank until those grades are re-assigned or Auto-Assign Grades is again checked for this column.

 

Auto-Assign Grades

The program default is pre-set for grades to be automatically assigned to the calculated numeric averages. By keeping Auto-Assign on, GradeQuick will keep updating the grades assigned to the computer-calculated averages whenever you change a grade or grading option in the gradebook spreadsheet. There are two main reasons you may want to turn off Auto-Assign.

 

 

If you want to turn off the Auto-Assign function for any term or semester, please read the sections on Auto-Assigning in their entirety. If you prefer to leave all your grades to be automatically assigned, you may skip the sections regarding Auto-Assign.

 

Notes About Auto-Assigning

·         Regardless of whether or not you choose to use the Auto-Assign mode, numeric averages for semesters, terms and the final are always recalculated and immediately updated whenever a test score is entered. 

·         Only assigned letter grades (and assigned numeric grades) are affected by checking or un-checking items on the Auto-Assign Grades drop-down list. 

·         Any grade that has been individually overwritten will not be re-assigned unless you remove its overwritten designation. 

 

Turning Auto-Assign Off and On

When you first choose Grading > Auto-Assign Grades, you will see a checkmark next to each item listed, e.g., Final Averages, terms, semesters or special scores.

 

All grades are auto-assigned

 

This means those items will automatically be assigned grades. Since the Auto-Assign Grades menu behaves as a toggle, whenever you select, or uncheck, a term, semester, special score or final average, Auto-Assign is turned off and grades for the unchecked item are not automatically assigned. When it is selected, or checked again, Auto-Assign is turned back on and grades are again automatically assigned for that item.

 

When Auto-Assign is On

When terms, semesters, special scores or the final average are checked on the Auto-Assign Grades menu, GradeQuick automatically assigns letter grades (or numeric grades if checked in the Grading Preferences dialog box) for each student, for each of the checked items. Grades will be updated, just like the average is updated, whenever you enter a test score for a student, or whenever you change the grade scale upon which the grade is based. You will see the grades to the right of the calculated averages in the overall grade, terms or semester average columns. The assigned grade for special scores is displayed next to the raw score in the special score’s column.

 

By default, all items in the Grading > Auto-Assign Grades menu are checked when you create a new gradebook. As new terms or special scores are created during the school year, they will be in auto-assign mode and appear checked-marked on the sub-menu. If you do not want the new grades automatically assigned using Auto-Assign, go to the drop-down list as you create new terms or special scores and uncheck any item you don’t want to be auto-assigned.

 

When Auto-Assign is Off

When terms, semesters, special scores or the final average are unchecked on the Auto-Assign Grades menu, the calculated averages are still updated when new scores are added. Even though the averages change, if the letter grades (or numeric grades if that option is checked in the Grading Preferences dialog box) that are assigned to the averages are no longer automatically re-assigned or updated. You can choose to keep or “freeze” them at the time the item is unchecked, or to remove them and replace them with asterisks (**). They will not be re-assigned again until you either select Grading > Assign Grades or restore a check next to the appropriate item in the Grading > Auto-Assign Grades menu.

 

To turn off Auto-Assign, click Grading > Auto-Assign Grades, and uncheck any item from the drop down list. You will then be given two choices about how to turn off Auto-Assign.

·         You can Clear Grades which replaces grades with asterisks (**).

·         You can Keep Grades or “freeze” that are in the column.

 

Clear or keep (freeze) grades

 

Assigning Letter Grades When Auto-Assign is Off

1.      Click Grading > Assign Grades. This menu will be gray until you have unchecked the item on the Grading > Auto-Assign Grades menu.

2.      In the list that appears, select the item for which you wish to assign grades. Only those items that have been unchecked on the Grading > Auto-Assign Grades menu will be available on the Grading > Assign Grades menu.

 

Final average is not auto-assigned

 

3.      A dialog box will appear with the grade scale displayed. You can choose from any grade scales you have already created, along with the two grade scales already set up for you, or you can set up a unique grade scale.

 

If you want to assign letter grades for the item you have selected in the Assign Grades sub-menu, click the Assign Letter Grades Now to Chosen Column button at the bottom of the dialog box. Those letter grades will remain permanent even if you later enter more test scores for that term. If you want them to reflect additional scores, you must repeat this process. No overwritten grade will be re-assigned at any time until the grade’s overwritten designation is removed.

 

Click to auto-assign after changes are made here

 

4.      Click OK to leave the dialog box. 

5.      You will be asked if you want the grade scale you just created to be used as the overall grade scale and assigned to any term, semester, special score or the final average that is checked on the Auto-Assign Grades list. If you choose Yes, the grade scale will be assigned to the current item and to all others that are being automatically assigned. If you choose No, the grade scale will be assigned only to the item for which you created the grade scale.

 

 

Assigning Numeric Grades When Auto-Assign is Off

If you have chosen to use numeric grades in the Grading Preferences dialog box, you will not have to set up a grading scale when you choose Assign Grades.

 

  1. Click Grading > Assign Grades.

  2. In the list that appears, choose the item, such as Term 1 or Final Exam, for which you wish to assign grades. Only those items that are unchecked on the Auto-Assign Grades menu will be available.

 

You will notice that the assigned numeric grade now appears next to the computer calculated average for the item. Those grades will remain permanent even if you later enter more test scores for that term. If you want them to reflect additional scores, you must select Assign Grades for that item again. No overwritten grade will be re-assigned at any time until the grade’s overwritten designation is removed.

 

Using Grade Symbols

Instead of entering a number for a student's test score, you may wish to enter a letter, word or symbol, such as ‘Pass’ or a checkmark. Before GradeQuick will accept non-number symbols as test scores, however, they must be defined and given a numeric value so the program can correctly evaluate those symbols when computing the student's overall averages.

 

GradeQuick defaults are set to allow you to enter the grades of S, N, U, Pass and Fail with the values in percent, that is, S = 90%, N = 70%, U = 50%, Pass = 85% and Fail = 50%.These percentages will determine what percent of the possible points on the assignment each student receives. This means that if you enter a Pass for an essay written by a student worth a possible 40 points, GradeQuick will count that as 85% correct, or 34 points, in tabulating his final grade.

To see the default grade symbols and their value, or to modify them:

 

  1. Click Grading > Set Grading Symbols.

  2. Double-click the symbol you wish to change, such as S.

  3. Type a new value to replace the percent value, such as 90%, in the second text box. 

  4. Click Change Now to make revisions.

  5. Click OK when are satisfied that all of your changes are acceptable.

 

Grading symbols options

 

Related topics

Creating New Grade Symbols

 

Creating New Grade Symbols

If you wish to define your own symbols, (such as OK, Good, A, B, C, etc.), select Undefined. You may define up to 20 different symbols with which to assign non-numeric grades. If you have already entered 20 symbols, Undefined will not be an option, and you will have to replace one of your existing symbols in order to create others. Change the symbols name to whatever symbol you want to use. The symbol may contain only four characters. After entering the symbols name, assign its numeric cutoff value.

 

For example, if you wish to grade a set of lab reports only as satisfactory or unsatisfactory, you must create the symbols "SAT" and "UN" and give them values such as SAT = 100% and UN = 70%. Be sure to assign an appropriate number on the maximum possible point’s line in this lab assignment column.

 

Using the Check Mark as a Grade

If you wish to enter the checkmark for a test score, you must add the symbol in Grading > Set Grading Symbols. To type the check mark, press Ctrl+C. A check-plus or check-minus can be created by typing a plus or a minus sign after the check. To enter the check mark as a grade, place the highlight bar in the test column and student row where you wish the check mark to appear and type Ctrl+C, making certain that the number of possible points for the assignment has already been entered.

 

Check mark is defined as a grading symbol

 

Printing checkmarks on reports

To print the checkmark on your reports, you must be sure that the special GradeQuick fonts remain chosen for the Score column. The font can be changed freely on other sections of the report. To verify the font that has been chosen for a particular column in a report, drag a box around that column in the Print Preview and click Options  >  Fonts. The fonts which must be chosen in order for the checkmarks to display are called GRADEQUICK (proportional) and GQMONO (mono-spaced).

 

Symbols for Selective Exempts or Zero Credit

Without putting a symbol for exempt on the grade symbol chart, you may always use the fixed symbols, X, NC, and ** for incomplete work or work not handed in. An X grade exempts the student and will not count against him in his average; an NC (No Credit or Not Complete) counts as a 0, and the asterisk (**) may count either way depending on which you choose and X scores appear on missing work lists. Since they all represent work not done, they are not included in computations for test statistics, e.g. mean, median, regardless of how they are computed in student averages.

 

You can also set your own symbol to indicate exempt by creating a new grading symbol.

1.      Click Grading >Set Grading Symbols.

2.      Type X for the value. For example, if your new symbol was ‘XMPT’, the line would read XMPT=X.

 

If you want to exempt only a few students for certain work not turned in, enter an exempt symbol (either X or one you have set) in their column. Then you can quickly toggle the rest of the ** grades to zero and the exempt symbols will remain as exempt. If you want to penalize only a few students for work not handed in, enter an NC in their column. It will count as a 0. Then you can keep the rest of the ** grades as exempt.

 

Numeric Grades

 

Use numeric grades option instead of letter grades

 

If your school uses Numeric grades only and does not record letter (A,B,C) or word (EXCELLENT, etc.) grades for your student's averages, you may want to choose the Use Numeric Grades Instead of Grade Scale option. This option is necessary if you need to export number grades instead of letter grades, or if you want to overwrite the calculated averages of certain students.

 

You should use this option if you want to assign another number as a student’s final grade by overwriting the calculated average. Since computer-calculated averages are designed to be an accurate record of the students’ scores, you cannot change this data in the Avg or Subtotal columns; however, you can overwrite this data when it is placed in the assigned grade column. Choosing Use Numeric Grades Instead of Grade Scale puts the numeric grade in the columns that allow you to overwrite them.

 

Instead of assigning a letter grade to the computer-calculated averages, the Use Numeric Grades Instead of Grade Scale option uses the computer-calculated average as the grade for every term (marking period) and for the overall final or semester grade. The average will be rounded before it is displayed in the Grade column. If you choose this option, a numeric grade will appear in the Grade column next to the computer calculated average at the far right of the gradebook. Unless you choose to change, or overwrite that number, it will be the same number as the computer calculated average. Likewise, a numeric grade, instead of a letter grade, appears next to each term average. (To see the term grades, click View > Subtotals and select Term Subtotals. A column displaying the score for each term appears.) You will also notice that the Set Grading Scale menu option becomes gray and unavailable on the Grading menu because there is no grade scale to set. The numeric average has become the grade.

 

Should you want to switch back to a letter grade scale, uncheck Use Numeric Grades Instead of Grade Scale and you will return to the last grade scale you used before changing to numeric grades.

 

Related topics

Averaging Grades

 

Averaging Grades

When you are using term weighting in your gradebook, you have the option to use the assigned term grades instead of the calculated averages to compute the final grade. This option allows overwritten grades to be used in computing the final grade. You can use this option whether you are using numeric or letter grades.

 

To set up grade averaging:

  1. Click Grading > Weighting and choose Term Weighting so GradeQuick will know how much weight to give each term grade.

  2. Click Grading > Grading Preferences and check the box next to Average Term Grades to Calculate Final Grades.
  3. Select a radio button.

 

 

·    Selecting GradeQuick Tie-breakers lets the program decide how to handle averages that fall between grades. 

·    Assign Cutoff Values lets you input values that determine how the program will break a ‘tie’ between grades. 

For example: A student’s two-term average is 3.50, which falls exactly between an ‘A’ and a ‘B’. GradeQuick Tiebreakers let the user set the program to round-up to the next grade, or to use the grade of a selected term to determine the final grade. If you assign cutoff values, you decide at what average value a grade is awarded. 

4.  Click OK.

·         Numeric Grades. If you are using numeric grades, the final grade will be calculated by averaging the numeric grades. In this case, you’re finished setting up the Average Term Grades option.

·         Letter Grades. If you are using letter grades, a warning will display explaining that you need to set a Grade Equivalent Scale in order for final grades to be calculated from your term grades. The steps to set the scale follow.

 

 

5.  Click Grading > Set Grade Equivalent Scale. This option will not appear on the Grading menu until you select Average Term Grades to Calculate Final Grades as discussed above. In the Set Grade Equivalent Scale dialog box, the grades you have entered in your grade scale will be listed, and you will be prompted to set values for these grades. If you are setting multiple grade scales, you should set a grade equivalent scale for each grade scale. 

 

6.  Select how the program will handle ‘ties’, grades that are exactly half-way between two grades, (e.g., 3.5, halfway between B=4.0 and C=3.0). The options available in the Set Grade Equivalents dialog depend on what you selected in Grading Preferences (Step 3 above)--GradeQuick Tiebreakers or Assign Cutoff Values.

 

·       If you selected GradeQuick Tiebreakers, choose a Grading Tiebreaker for final and semester grades from the drop-down list.

 

Grade scale equivalent tiebreaker option

 

When using tiebreakers, your choices are either Round Up or Term n Grade, where n represents the term number in the gradebook. If you choose Round Up, in the event of a tie GradeQuick will round up to the next highest grade. If you choose Term n Grade, GradeQuick will use the grade from Term n to determine which grade the student will receive.

 

Refer to the example where there are 2 terms in a gradebook. The student receives a 90, or an A, for Term 1 and an 80, or a B, for Term 2. The average is 3.5. With Round Up chosen, the student would receive the grade A. If Term 2 Grade was chosen, the student would receive grade B, the grade for Term 2.

 

·       If you selected Assign Cutoff Values, set numeric cutoff values for letter grades by typing in the Minimum Value fields. 

 

Grade scale equivalent cutoff values option

 

When using Grade Cutoff Values, you must set the cutoff value, usually with the number that should be rounded up to the next grade.

 

Refer to the example where there are 2 terms in a gradebook. The student receives a 90, or an A, for Term 1 and an 80, or a B, for Term 2. The average is 3.5. With Grade Cutoff Values, the student would receive the grade B. An average of 3.6 was required for A.

 

7.  Click OK to save changes and exit.

 

Note     If you are calculating semester subtotals and averaging grades, the final grade will be calculated using evenly weighted semester subtotals. If you do this, you will not have the option to weight your semesters unevenly. If you have no special scores assigned to the year, the year grade will be the average of the two semester grades. If you do have special scores assigned to the year, GradeQuick will assign a weight of 1 to each semester grade, and you will have to weight the special score accordingly. If you weight the final exam which is not part of either semester, you must weight it relative to the 2 semesters.

 

Related topics

Numeric Grades

 

Globally Changing Asterisk (**) Scores To 0

The program default treats the asterisk (**) score as exempt, meaning not counted in student averages, but you can switch it to count as a zero. In the Grading Preferences dialog box, click Zero for In Gradebook Spreadsheet ** indicates. The ** will remain visible in the gradebook to indicate incomplete work, but it will count as 0 in student averages. You can switch back by checking Exempt. Because you can switch back and forth with a mouse click, you can easily print both results and show each student the effect on his or her average.

 

 

Creating Semester Subtotals in Gradebooks

GradeQuick allows you to calculate semester subtotals within gradebooks that are used for an entire year. A semester is a grading increment that includes more than one term (marking period). Two semesters are combined to make up the final grade for a class.

 

Create semester subtotals:

1.      Click the Calculate Semester Subtotals option to add semester subtotals to the gradebook spreadsheet. Two semesters will be created in your gradebook.

 

2.      Indicate the number of terms that are contained in each semester, from 1 to 4.

 

Averages in your gradebook will not be calculated correctly if you mistakenly create more terms in your gradebook than the number of semesters multiplied by the number of terms (e.g., you designated 2 terms per semester in the dialog box, but you have created 6 terms in your gradebook). You will receive a warning that the extra terms will not be calculated in any semester’s subtotals but will be included in the final average and grade.

 

3.      If you are using special scores, such as midterms or finals, you will need to assign them to one of your semesters.

 

Note    When you are calculating semester subtotals, you can still choose how to weight your terms, so that semester 1 and semester 2 do not have to be weighted equally to calculate the final average. For example, you may want semester 2 to weight more heavily in the final average to account for student progress.

 

Related topics

Assigning a Special Score to a Semester

Displaying Subtotals for Semesters

 

Extra Credit

Following these procedures will raise the average of a student who earns extra credit, but will maintain (not reduce) the final average of a student who does not earn extra credit.

 

 

 

Student's score is greater than possible points

 

·         Enter an extra credit assignment as its own test column. You may count an entire assignment as extra credit only if you are not weighting individual test or assignment columns. Do this by assigning it 0 possible points and then entering the scores earned. You may use this method if you are weighting categories or terms, but only if you have other columns that have possible points in the same category and/or term as the extra-credit column. You may not have an extra credit column with 0 possible points if it is the only assignment in a category and you are weighting categories because it will not affect students’ averages.

 

 

Averaging Percentiles or Normalized Scores

The Grading Preferences dialog box has three options for Averaging Method: Scores, Percentile and Normalized. By default, GradeQuick uses Scores as the averaging method. You can choose to average percentiles or normalized scores instead, although this is not recommended unless you are familiar with the mathematics involved.

 

Scores

Using Scores calculates any averages using the raw scores you enter. Scores will also take into account any weighting you have selected. Scores is by far the most commonly used procedure among teachers.

 

 

Percentiles

Use Percentiles if you want GradeQuick to compute student averages based on the percentage of the class that scored lower than each student on each test item. (Note this is percentile, not percent.).

 

Normalized scores

Use Normalized scores if you want GradeQuick to normalize each test score to a certain mean and standard deviation and use these scores to compute student averages (this will not change the scores you have entered). By default, GradeQuick will normalize to a mean of 75 and a standard deviation of 10, but you can change these. Just type the Mean or Standard Deviation you desire. A linear transformation is used to compute normalized scores.

 

 

If you decide to average your scores in these less common ways, you should select the student statistic Normalized or Percentiles to be displayed next to the raw scores in each column to see the numbers being used to compute the averages. Also, remember to re-set your grade scale accordingly.