Support > Storing Student Marks in Excel

An important labour-saving option in Marker's Black Box is the ability to:

(1) insert the name or student ID from a list already created in Excel,
(2) store the marks awarded into Excel,
(3) store the name of the marker against each student,
(4) record the marks given for each criterion and for each student, and
(5) open the Excel file at any time to examine or print the marks.

An Excel file can be used by selecting Tools > Create Offline Marking Sheet (Figure 1). When marking a student, select their name (or ID) from the drop down list.

Figure 1. Interaction between Marker's Black Box and Excel.

After the item has been marked, selecting "Create the Feedback Report" will cause Marker's Black Box to record the marks in Excel automatically. However, this can also be done manually by selecting "Save Mark in Excel".

To see the list in Excel, select Student Data > View Student Marks in EXCEL (which can also be seen in Figure 1).

The Excel file should be in the following format:

Column A: Last name
Column B: First name
Column C: Student ID

Each of these is optional (for example, if marking anonymously then first and last names will not be required). If either name or ID is not required these columns should still be created, but left blank. The file may contain a header or other information in the first few rows and Marker's Black Box will ask you for the row number where student names/IDs begin.

Marker's Black Box will then use the following columns:

Column D: Actual mark awarded
Column E: Marker's name
Columns F onwards: Marks awarded for each criterion (optional).

Next >>