SIMS is capable of extracting a wide range of data using its reporting functionality, including student details, attendance, assessment and behaviour data. The export of data into Excel is the default option for many of the pre-defined reports in SIMS.

Excel is a powerful programme capable of assisting in analysis and display of data. Formulas process data in an accurate and repeatable way and pivot tables provide an interactive method of interrogating data.

Incorporating the Excel analysis directly within the SIMS report means that both the extraction of the data from SIMS and the analysis of the data in Excel can be achieved, automatically, in one step.

Content

Automating data analysis in SIMS reports using Excel
Excel formulas
Analysing data using Excel
Designing more complex SIMS reports
Excel pivot tables

Attendance

Full day