Create a class mark book using a spreadsheet

Video transcript

1. Select a class to be digitalised. In cell A1 write the class code e.g. F9Y
2. Use Row 2 as a heading row and insert the labels you require to remind you what the figures in each column are
3. In A2 write Surname. A3 Initial. A4 Test 1, A5 Test 2 etc.
4. Insert as many headings as you know exist at this stage of the year
5. You will be able to insert new headings as the year progresses
6. In Row 3 insert the value of each test e.g. total 50 etc.
7. Then list all the class members' surnames in column A, initial in column B and test results, if you have any, in columns C, D etc.
8. Alternatively, should you not have any test results, insert fictitious figures for the purposes of this tutorial
9. Your page should look something like the one below: