Sort, Task view v. Syllabus view, Raw and adjusted values
Print options
Export to Excel
Use simple functions
Assessment functions – Count / Average / St. DEV / Median / Min / Max
Student functions – Rank
Assessment group functions – CountA / Countblank / CountIf
Conditional formatting
Create a chart
*Microsoft Excel is required
Please note that dependent on the operating system you use (i.e. PC or MAC) you may not have all available Excel options. This webinar is delivered through Excel 2016 on a windows platform (PC).
Recommendation
Teachers, Curriculum Deputies, Heads of Department, Head of Learning Areas
Benefit
The aim of this session is to show users how to effectively analyse marks Book data in Excel
