In the top section of test columns, you will enter five facts (or six facts if you weight tests) about each test or assignment column you create. These facts, or test descriptions, are needed for GradeQuick to compute averages, percent statistics, graph or print reports. It will identify each assignment, assign it to the appropriate Category and Term, and may be used if you choose to reorder test columns to group them by date or type of assignment. Once you have entered the descriptive information, you can choose whether you want to display the information.
Enter the information using the mouse or arrow keys to select the desired cell and type in the data.
When you have finished entering the test description for the new column, you may copy the same test column descriptions to another gradebook in one of two ways:
- Use the Gradebook to Gradebook Copy option.
- Right-click, choose Copy Test.
- In the first row of the test column, replace the asterisks (**) with the short name of that specific assignment or test.
- Space is limited to 8 characters, so you may need to abbreviate titles, such as Chap 6.1.
- Each test or assignment name should be unique.
- Use the Category row (described later in this section) to give a common label to group individual assignments by types, such as labs, tests, projects, etc.
Directly below the Name of the test or assignment, in the header of the test column is a second row where you may enter a longer name or description of the assignment, up to 40 characters. As you begin to type in that field (or by pressing the Enter key), a text box will appear where you enter the full name.
Click OK or press the Enter key when done. Only the first 8 characters appear in the spreadsheet, (or 4 if you are in Thin Column Mode) unless you scroll through the field with the cursor. However, you may print the full name on reports.
Term in GradeQuick refers to a grading interval or marking period within an overall semester or year. These marking periods may be referred to as quarters, 9-week periods, etc. The term number in the header of each test column indicates to which term each specific test is assigned. If you have set term dates in your gradebook, the term number will be assigned automatically based on these dates when you create a test column. If you want to edit the term number for a specific test, highlight and type over it.
The GradeQuick administrator may have customized the marking period name for your school. Instructions in this manual will continue to refer to term but you may see Quarter or Trimester in your gradebooks.
Categories provide a way of grouping individual tests or assignments by types, such as quiz, homework, test, etc. This is an excellent way to analyze a student’s performance by comparing subtotal scores in different categories, such as Tests vs. Homework. To compare category scores or to weight categories differently as components in determining final grades, it is necessary to enter the Category title in theCategory row; you may create any category title you want, up to 8 characters in length. Each gradebook may contain up to 32 categories.
Entering a new category
When you enter a new category name, it will be added to the drop-down list of categories that will appear when you click in the category row. If you are using a category name that has already been entered, you can select it from this list, instead of typing it in again. If you begin typing the name of a category that already exists in your gradebook, GradeQuick will suggest the name of the existing category. This insures that your category names are all the same, so that category subtotals and weighting will work properly.
Do not confuse the assignment name with the assignment category. If you have five homework assignments, the title in the Category row should be the same for each of the five individual assignments, but the test Name should reflect the specific assignment names.
Should you forget to type or select the category for one assignment, asterisks (**) will appear as the category name and as a subtotal column. You can always go back and select the appropriate category so the scores can be calculated in the correct category.
The current date will automatically appear in the Date row. If you want the date to reflect the date the assignment was given or turned in and that is not the current date, use the calendar to select the appropriate date. The date is also the basis for reordering tests if you choose to sort them by date, or to print by date. Be sure the date in the form MM/DD/YY, such as 03/21/09. If you need to change the date, double-click the date field and click the arrow to display the calendar. Scroll through the calendar and click the date you wish to enter in the date field. You can also use the arrow keys to change month, day, or year in the date field.
You must enter the maximum number of points possible for any test in the Possible row before you will be able to enter scores for that test.