Reporting - Excel Analysis - Pastoral Only
Course overview
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.
NOTE: We have recently updated our course names to better support our customers in finding the course they need, the course content has not changed only the name has been updated. This course was previously titled Advanced Reporting with Excel Analysis - Pastoral.
Benefits of attending
To learn advanced reporting and analysis techniques, including automating the process.
What you will learn
• how to automate data analysis in SIMS reports using Excel across the SEN, attendance, behaviour and personnel areas.
• Excel formulas, pivot tables and macros.
• Analysing data using Excel.
• Designing more complex SIMS Reports.
Who is it for?
Staff who wish to extend their ability to analyse data using SIMS and Excel.
You will need some basic knowledge and experience of SIMS, including the SEN, attendance, behaviour, personnel and reporting areas, and an understanding of Excel.
Also Consider:
Reporting - Excel Analysis - Complete
Reporting - Power BI for Analysis
Learning Pathway: #Reporting #Independent
Course details
- Phase of education
-
- Secondary
- Delivery Type
- Remote
- Areas of responsibility
- Administrative StaffPastoralData Manager
- Course code
- AREAP-1-05
- Duration
- Multiple Sessions
- Categories
- Core
Upcoming scheduled courses
-
DateVenue
Remote