View list of workshops & events

Generate Master Marksheet and Report Sheets using MS Excel

Workshop
3.30 – 5.30pm

During this 2–hour workshop, participants will learn to:

  • Apply basic math and statistical Excel functions such as sum, mean, median, mode, minimum and maximum.
  • Use the COUNT and COUNTIF functions to determine the number sat and number passed.
  • Apply the RANK function to determine positions, and IF function to grade marks.
  • Generate report sheets from a master marksheet.

Workshop schedule:

Date Day Time (FJT)
10 November Thursday 3.30–5.30pm
17 November Thursday 3.30–5.30pm