MGSLG ICTCFT. (2017). How to create a class mark book (CC BY-SA)

معاينة

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:


آخر تعديل: Wednesday، 28 September 2022، 10:21 AM