Statistical Analysis of Examination and Other Numerical Data
This one-day course follows on from Statistics for University Administrators, and considers the statistical analysis of numerical data.
The course provides participants with hands-on experience of analysing numerical data, with a focus on examination data, and how to report and interpret results to committees. Starting with the notion of summarising numerical data using summary statistics and exploratory graphics, the course continues with a number of basic statistical methods oriented around the use of means, finishing with the use of simple linear regression for exploring trends.
Presentations, demonstrations and hands-on computer practicals will be based around Microsoft Excel. The course will make use of our Excel Add-In SSC-Stat, which provides some statistical features that are not available in standard Excel. The Add-In is freely available to course participants.
Formulae are kept to a minimum, instead, we concentrate on results, their interpretation and on reporting in plain language.
Who Should Attend?
Those involved in exploring and intepreting examination performance, and in reporting and presenting to committees. Also, those involved in Policy and Planning units who are required to draw and report conclusions from numerical data.
Participants are assumed to have knowledge of basic formulae and functions in Excel. Ideally, participants will have previously attended our short course Statistics for University Administrators, or have equivalent knowledge.
How You Will Benefit
By the end of the course you will be familiar with basic statistical methods for making sound assessment of numerical examination, or other data, using Excel.
What Do We Cover?
Practical work will be done in: Excel
Note: For practical work, participants must bring their own laptop with a fully licensed version of the software.
Participants will also need to pre-install our Excel Add-In, SSC-Stat.
Related Courses: This course is part of a series of short courses for HE professionals working in administrative, planning and support roles: