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.
By the end of the course you will be able to: Understand the process of automating data analysis in SIMS reports using Excel Use various Excel formulas Analyse assessment data using Excel Design more complex SIMS Reports Use Excel pivot tables Use Excel macros
For non-Gloucestershire schools/academies wishing to book onto this course, please contact us on 01452 427272 for more details and prices.
Staff who wish to extend their ability to analyse data using SIMS and Excel. Basic knowledge and experience of SIMS as well as a working knowledge of Excel are required