Explore the use of SIMS to extract and analyse data, including how to automate reporting and analysis, enabling your school to generate the reports whenever necessary.
Let us help you find the right course
Benefits of attending
To learn time saving, advanced reporting in SIMS using sub reports and filters and analysis techniques using a combination of SIMS and Excel, including automating the process for formula calculations, conditional formatting and pivot tables using macros.
What you will learn
• how to link a SIMS report to a custom Excel template
• Excel formulas including Count-If / Count-Ifs, Sum If / Sum Ifs, IFERROR and others
• designing more complex SIMS reports
• Excel conditional formatting
• Excel pivot tables
• Excel macros.
Who is it for?
Staff who wish to extend their ability to analyse data using SIMS and Excel. Some basic knowledge of SIMS, including the Assessment, Attendance and Behaviour Management areas is required to get the best from this course. Experience creating SIMS reports would also be beneficial. Some understanding of formulas and functions in Excel 2007 or later would be advantageous but is not essential. This course has a key focus on assessment and does not follow on from the Advanced Reporting with Excel Analysis – Pastoral course.
- Phase of education
- Delivery Type
- Face to face
- Areas of responsibility
- PastoralAdministrative Staff
- Course code
- Multiple Sessions