Explore the use of SIMS to extract data and analyse it using Excel®, including how to automate reporting and analysis, enabling your school to generate the reports whenever necessary.
Using examples from all areas of SIMS, the course focuses on advanced reporting and analysis techniques within Excel, including how to automate the process.
Who should attend?
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 assessment, attendance, behaviour and reporting design areas as well as a working knowledge of Excel.
How will I benefit?
You will be able to create more complex reports in SIMS using the power of Excel to automatically carry out the analysis required.
What will I learn?
By the end of the course, you should be familiar with:
- the process of automating data analysis in SIMS reports using Excel
- the use of various Excel formulas
- analysing assessment data using Excel
- designing more complex SIMS Reports
- Excel pivot tables
- using Excel macros.
Course code, duration and location
SIMS30 - 1 day 0930-1530 Shire Hall, Westgate Street, Gloucester. GL1 2TG
Cost
£195 per person (supported schools/academies)
£295 per person (non-supported schools/academies)
Course dates
Please see GCCPlus for available course dates.
NB. All course bookings are now done via GCCPlus. Your Business Manager/Bursar should be able to log onto GCCPlus and complete the booking for you.
If you are from out of county and would like more details about this course including booking information, please contact the SIMS Support Office on 01452 427272.
