Skip to end of metadata
Go to start of metadata

Contribute

Gradebook Specification

ATutor Gradebook

A Gradebook have been created for instructors to manage test and assignment marks. It allows instructors to automatically gather marks from tests and quizzes taken through the ATutor Test Manager, and allow them to define external tests or assignments or add ATutor assignments into gradebook and manually record marks for those. It allows students to view their marks for completed tests or assignments, list tests or assignments yet to be completed or yet to be marked, and print out a report of their marks. Reports will be course specific.

Student Gradebook

Marks stored in the Gradebook will be available to individual students for viewing as a progress report displaying marks for marked tests or assignments, and a listing of tests or assignments yet to be marked or yet to be submitted for marking.

[Note: any underlined value in the tables below indicates that the value is clickable. When results are available for a ATutor test, the test title becomes a link to the completed test.]

Students Gradebook Screen

-------

John Smith

Title

Your Mark

Class Avg

Date Due

Date Completed

Duration

Test 1 (AT)

45/50

42.5

2008-03-12

2008-03-12 17:21

102m

Test 2 (AT)

A

B+

2008-04-12

2008-04-12 12:35

34m

Assignment 1

Pass

NA

2008-06-12

pending

NA

Exam 1

82%

74.5%

2008-05-12

2008-05-12 15:24

106m

Assignment 2

NA

NA

2008-07-12

pending

NA

Test 3 (AT)

NA

NA

2008-08-12

pending

NA

Assignment 3

NA

NA

2008-09-12

pending

NA

-----

Students can review a marked ATutor test submission by clicking on the test Title. Students can also print their marks by using the browser's print function, which will strip away the ATutor interface and display a plain table display like that above.

The Student GradeBook table above will be generated by retrieving a list of tests currently defined in gradebook for this course from the "tests" table, providing the list of tests for the course whether completed or not. 

Question: Should Due date be the start_date or end_date from the tests table?

Answer: Due date is the end_date in tests table.

Instructor Gradebook

All students' marks stored in the Gradebook will be available to instructors. Please note that the instructor's mark, if the instructor takes test for testing purpose, is not recorded in Gradebook as it will affect the class average mark etc. The Gradebook tools will allow an instructor to add ATutor Tests/Assignments, External Tests/Assignments, Add or Edit Marks for ATutor assignments and external tests/assignments, Export a Report in a comma separated data file that can be viewed in a spreadsheet application, or Print a Report by extracting the data from the Gradebook into a plain page.

Instructor Gradebook Screen

[Add Tests/Assignments] [Update ATutor Marks] [External Marks] [Edit Marks] [Grade Scales]

Grade Scales

1. Grade Scales

Preset Grade Scales

In addition to a default set of standard grade scales described below, the ATutor instructors are able to edit these scales to adjust for organizational differences, and define custom grade scales specific to a particular organization. Once custom grade scales are defined, the instructor can use it across all courses that are created by his/her own. Instructors can choose from these grade scales when adding a test or assignment to the Gradebook. All default and custom grade scales will be based on percentage of answers correct. Default scales will include the following:

Letter Grades

Competency 1

Competency 2

A+ = 90 to 100%

Pass = 75 to 100%

Excellent = 80 to 100%

A = 80 to 89%

Fail = 0 to 74%

Good = 70 to 79%

B = 70 to 79%

-

Adequate = 60 to 69%

C = 60 to 69%

-

Inadequate = 0 to 59%

D = 50 to 59%

-

F = 0 to 49%

-

If a grade scale is not selected, display will default to the raw mark. For ATutor tests, raw mark is the final score from Tests/Surveys module. For ATutor assignments or external tests/assignments, raw mark are the raw imported by instructor without any conversion.

Custom Grade Scales

Custom grade scales can be created on a course-by-course basis (See how this works for custom likert scales).

2. Add Custom Scale

------

Scale Name _______________

Scale Value    Percentage From    Percentage To

_________    ________   ______

_________    ________   ______

_________    ________   ______

_________    ________   ______

_________    ________   ______

_________    ________   ______

_________    ________   ______

_________    ________   ______

_________    ________   ______

_________    ________   ______

                                                [Save]

---------

Once saved, the scale becomes available, along with the other default scales, to the instructors across all courses.

Add Tests/Assignments

------

Instructors are able to add ATutor or external tests/assignments into gradebook via this page. There are 2 sections on this page: Add ATutor Tests/Assignments, Add External Tests/Assignments.

1. Add ATutor Tests/Assignments
Title     choose one___ 

Grade Scale     __choose one__V

ATutor tests that have been created using the ATutor Test & Survey Manager can be added to the gradebook if:

1. The test's Attempts Allowed property has been set to 1 attempt;

2. Not Surveys. Surveys are technically tests in the Test & Survey Manager that do not have any "weight" or mark assigned to questions;

3. Haven't been added into gradebook.

Once an ATutor test has been added to the gradebook, marks can be updated via Update ATutor Marks.

ATutor assignments that have been created using the ATutor Assignment Manager can be added to the gradebook too.

2. Add External Tests/Assignments

Title     _____________ 

Grade Scale     __choose one__V

Due Date    

  • None
  • Date YYYY MM DD at HH MM

Once an external test or assignment has been added to the gradebook, marks are entered via External Marks. Marks may be entered either as a percentage mark or a scale mark. If percentage is used, the gradebook will attempt to convert those percentage marks to a scale mark.

Update ATutor Marks

This page is to import marks from ATutor tests or combine different ATutor generated tests can be combined into a single gradebook entry. It has 2 sections: Update ATutor Marks, Combine ATutor Tests.

1. Update ATutor Marks
Title     choose one___ 

Students     __choose one__V

Marks are imported from ATutor tests, rather than displaying them live from the Test & Surveys Manager. Therefore, when marks are updated in the Test & Surveys Manager, the Gradebook needs to be updated to reimport the modified marks. You may choose to update all ATutor tests at once, or choose only to update a single test at a time. Or, you may choose to update only marks for a single student, on all test or a single test.

2. Combine ATutor Tests

ATutor Test Combine Into     choose one___ 

ATutor Test Combine From     __choose one__V

Different ATutor generated tests can be combined into a single gradebook entry, if for instance you needed to combine marks from a term test, and marks from a make up test for students who happened to miss the term test. As many tests as required can be combined into a single parent test listed in the Combine Into menu. Select the test to be combined from the Combined From select menu, then press the Combine button to import the marks from that test. Be sure to run Update ATutor Marks on the Combined Into test at least once before combining marks from other tests. When combining marks from multiple tests, should you encounter a conflict such as a mark that already exists for a particular student, you will be given the option to overwrite the old mark with the new one, use the old mark, use the higher mark, or use the lower mark.

External Marks

Instructors are able to export marks of any test/assignment defined in gradebook and import marks for ATutor assignments, external tests/assignments. Marks of ATutor tests are generated in ATutor internally and can not be modified.

This tool can also be used to export marks from the Gradebook to import those marks back into another application such as a spreadsheet, or another database.

This page has 2 sections: export, import

1. Export
What to Export     choose one___ 

Marks are imported from ATutor tests, rather than displaying them live from the Test & Surveys Manager. Therefore, when marks are updated in the Test & Surveys Manager, the Gradebook needs to be updated to reimport the modified marks. You may choose to update all ATutor tests at once, or choose only to update a single test at a time. Or, you may choose to update only marks for a single student, on all test or a single test.

2. Import
Import Into     choose one___ 

Upload     choose a csv format file___ [Browse...]

Marks from an external assignment or test can be imported in a Comma Separated Values (CSV) file in the form "firstname", "lastname", "email", "grade" with one student per line. The mark can either be a scale mark such "A" or "Pass", or a percentage mark such as 78%. Select the test or assignment previously defined through <a href="gradebook_add.php" >Add Tests/Assignment</a> The first line of the imported file should contain the field names "First Name, Last Name, Email, Grade" If it is not included the first line will be removed when the marks are imported.

Edit Marks

Instructors will be able to generate reports by choosing the Filter or Export CSV of Resutls function that will produce a downloadable CSV file that can be opened in any common spreadsheet application. This function will allow an instructor to generate reports for:

  1. A single student on a single test or assignment
  2. All students on a single test or assignment
  3. A single student on all tests and assignments
  4. All students on all tests and assignments

Instructors are able to use browser's print function to print the filtered marks. A print displays the same layout and formatting as that used to display the Gradebook when editting marks in ATutor, but without the surrounding ATutor interface.

------------ 

Select Student                         __choose or All__V 

Select Test or Assignment         __choose or All__V

[Filter] [Reset Filter] [Download CSV of Results]

-------------

                                  Previous | 1 |2 |3 |4 | Next

Name

Test 1 (AT)

Test 2 (AT)

Assignment 1

Exam 1

Assignment 2

Test 3 (AT)

Assignment 3

 

 

 

 

Edit

Edit

Edit

Edit

Edit

 

John Smith

45

A

Pass

A

NA

NA

NA

Edit

Bob White

38

B+

Fail

NA

NA

NA

NA

Edit

Jane Brown

46

C

Pass

NA

NA

NA

NA

Edit

[ Save ]

                                  Previous | 1 |2 |3 |4 | Next

--------

Each column will be sortable except the edit column

Pages will be displayed in groups of 50 rows

Filter queries will be maintained from page to page when editing a column 

Export class list with mark field, to be imported through column header link.

Filter Results

The following represents potential output from a filtering of all students for Exam 1, followed by clicking the Edit link at the top of the column. Each cell in the column becomes a text fild into which marks can be entered. The instructor can click on Save to save the entered values and return to display mode, or click on Next to move to the next page in the sequence.

--------

                                   Previous | 1 |2 |3 |4 | Next

Name

Exam 1

 

Edit

John Smith

____

Edit

Bob White

____

Edit

Jane Brown

____

Edit

Bill Blair

____

Edit

Ron Black

____

Edit

Kathy Jones

____

Edit

Cheryl Little

____

Edit

....

....

Edit

[ Save ]

                                  Previous | 1 |2 |3 |4 | Next

--------
 

The instructor's Gradebook default screen will list enrolled students down the left of the screen, and test/assignment titles across the top. Cells within the Gradebook table will display a number grade out of the total mark for a test or assignment by default (see Test 1) , or a percentage, a letter grade, a pass/fail grade, or another competency grade as selected from the default or custom preset marking schemes available on a system.

Marks for ATutor tests (signified with "AT") can not be altered through this page. They can be altered manually through the Test Manager if required.

Marks for ATutor assignments and external tests/assignments can be altered through this page. Clicking on Edit will turn each cell in the row into a text box, into which the currently assigned marks are listed. Instructors can edit the marks for that particular student. Marks entered for ATutor assignments or external tests/assignments are stored in a separate external_scores table.

Potential Issues

How do we handle instructors' marks on ATutor tests?

Right now, instuctors' marks are not calculated or converted into gradebook because these marks will affect class average mark. But instructors may take their own tests to do testing on gradebook. In this case, they will see empty gradebook. One solution is to bring instructors' marks into gradebook but ignore them at other places in gradebook, for instance, calculation on class average. The shortcoming of this way is the confusion we brought in together: some places instructors' marks are included and some places not.

  • No labels

4 Comments

  1. Anonymous

    Great to see some movement toward a grade book. Are there any estimates on when it might be incorporated?

  2. We're still waiting for a funder. We're hoping before the fall released.

  3. Anonymous

    I know things have to be paid for, not that I really understand that in the open source world, but the lack of a gradebook is what always kept me from seriously considering atutor.

  4. There are funds now, and the gradebook is coming together. It'll be available in a couple months.