Advanced Excel for Students' Records Administrators
Do you have to replicate faculty descriptors at the school level, or department descriptors at the student level?
Do you have to aggregate module results at the student level?
Do you have to compute average marks per student for taught modules only?
This one-day training event provides delegates with hands-on experience of analysing student records efficiently by confidently using Excel as a relational database.
Who Should Attend?
Administrators in Educational establishments dealing with student records data; those involved in linking tables of students data at different levels and anyone involved in producing returns to the HESA will likely benefit from this course.
Participants are assumed to be able to use Excel formulae, obtain summary figures (counts, totals, percentages) using Excel, and be familiar with the storage of data in lists to enable the use of filters and Pivot Tables.
How You Will Benefit
By the end of the course you will be familiar with basic methods for fast, efficient and dynamic data crunching.
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.
Related Courses: This is part of a series of short courses for HE professionals working in administrative, planning and support roles: