Administrative Staff

Senior Leaders

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