Importing Marks & Targets

When marks already exist in a spreadsheet, you do not have to type them again. MarkBook has two imports, and both start from the same place: Configuration → Assessment → Markbook Templates, open a template, and go to the Grades import tab.

You need the permission Import marks (and Set target grades for target imports). Both imports write like a typed mark: every value is versioned, the cell history records it, and a locked period refuses it.

Pick the import that matches your sheet

The tab shows two cards. Choose by the shape of your spreadsheet: what runs across the columns.

	Marks for one class and one subject	Targets for every class and subject
Columns are	The columns of this template (Term 1, Term 2, Effort…)	Subjects
Rows are	Pupils of one class	Pupils of every class
Writes into	One markbook: the class and subject you choose	The target column of every subject, in every class of the template
Button	Import marks	Import targets
Pupils found by	Kinderpedia ID	ID, student number, or name (see below)

Comment columns, calculated columns and text columns are never imported.

Import marks for one class and one subject

Files can be .xlsx or .csv, up to 2,000 pupils.

Start from the sample file

Press Download a class sheet. Pick a form group and a subject. The file you get has:

• the headers from this template's columns,
• one row per pupil of the class,
• the current marks already filled in.

Example file for 9B Mathematics:

student_kp_id	student_name	T1A · RG	T1A · EF	T2A · RG
1048213	Alex Popescu	B	Good
1048214	Maria Ene	A	Excellent
1048215	Radu Stan	C	Satisfactory

A header is the period code, a dot, and the column's short label. Do not change the student_kp_id column. It is how each row finds its pupil. Names are never used to match, so a pupil who changed name still gets the marks.

Run the import

The wizard has six steps.

1. Upload. Drop the file or click to upload.
2. Context. Choose the Form group and Subject. The Academic year comes from the template.
3. Mapping. MarkBook matches your file's columns to the grid. Files made from the sample match by themselves. Anything unmatched is simply not imported. Check "Which column holds the Kinderpedia ID?".
4. Preview. "Review before anything is written". Nothing is saved yet. You see counts for will be written, already match, replace an existing value and problems, and a table with Student, Column, Current and New.
5. Import. Press Import N marks.
6. Results. "N marks written · N already matched · N problems".

If every value in the file is the same as the grid, the preview says "Nothing to import — the file and the grid already agree". This is what an unedited workbook looks like.

Typical problems in the preview: a value that is not on the scale, a number out of range, a pupil that is not in the class, a column that is calculated, and a locked period.

Import targets for every class and subject

Use this when a target-setting system gives you one sheet for the whole year group: a row per pupil, a column per subject. The sheet can have extra columns and lines of text above the table.

Example sheet from a statistics system:

Surname	Forename	Date of birth	Class	Maths Target	English Target	Biology Target
Popescu	Alex	14/03/2012	9B	7	6	6
Ene	Maria	02/11/2011	9A	8	8	7

The wizard has five steps: File, Students, Subjects, Review, Done.

1. File. Upload your sheet. Or press Download the sheet for ours: every pupil of the template's classes, one column per subject, a drop-down of allowed grades in each cell, and the targets already entered. The template must have a target column (for example PTG). If it does not, the wizard says so.
2. Students. MarkBook picks the row that holds the column names and finds the identity columns. Check them. A pupil is found by Kinderpedia ID, then student number, then name. When two pupils share a name, the date of birth and then the class decide. MarkBook never guesses: two pupils that survive every check are listed for you to resolve.
3. Subjects. For each subject of the template, choose the column that feeds its Target from. Use If empty, use for a fallback, for example Economics from Business when the statistics have no Economics estimate. Only the subjects each pupil takes on this template get a target.
4. Review. Nothing is saved yet. You see students found, targets to save, already the same, rows not matched and values not on the scale. Pupils in classes outside the template are skipped, not errors. Choose how to treat Targets already entered in MarkBook:
   • Keep them. Only empty targets are filled. Safe to run again.
   • Replace them. Your sheet wins. Every change stays in the cell history.
5. Done. "N targets saved". Press Save N targets in the review step to run it.

WARNING

You can import only into classes you may edit. Targets in other classes are skipped and counted as "targets in classes you cannot edit". A subject shown only in another kind of class (Display in) is also skipped.

Year-level profile: SEN, EAL, FFT

SEN, EAL and FFT are not per-subject marks. They are set on the pupil's yearly profile and have their own import under Configuration → Students → Student targets. See Student Targets.

Import history

The Grades import tab lists every import: File, Into, Status (Validated or Completed), Rows, Results, Date and By. The eye button shows what an import wrote.

See what an import wrote

The detail window is titled "What file name imported". It shows pupils against the columns the run wrote. For each cell you see the value now, what was there before ("Was B before the import") and whether it changed since. Filter by class, subject or pupil. Download (XLSX) saves the table plus one line per change: Before, Imported, Now.

Revert an import

Press Revert this import. MarkBook tells you what will happen before you confirm:

• Each value goes back to what it was before the import. A cell that was empty becomes empty again.
• Values changed after the import stay as they are now.
• Values in a locked period stay as they are.
• Values in classes you cannot edit stay as they are.
• Each value put back is recorded in its cell history, with the source Import.

Only the person who ran the import, or a manager, can revert it. An import can be reverted once. An import that ran before MarkBook began to link values to imports cannot be shown or reverted. The values are still in each cell's history.

TIP

Not sure about a file? Run it, look at the detail window, and revert if it is wrong. Check one class first before you run a whole year group.

Removing a history row

The bin icon removes the record from the list. "the imported marks stay". It is not a revert.

Was this helpful?