13: Basic ICT skills: Use a spreadsheet for marks

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: