Training Course

SIMS Extended Reporting with Excel Analysis - 10 November & 11 November 2020

This course explores using SIMS reports to extract data and Excel to automatically analyse this data. It will cover the creation of reports in SIMS and explore some of Excel’s capabilities for data analysis including formulas, conditional formatting, macros and pivot tables.

Contact us or call 0844 967 1111

Cost: £349 + VAT (or free to ICT SLA customers using promo code)

LOCATION:

One Education, Universal Square, Devonshire Street North, Manchester, M12 6JH

Go back

SIMS Extended Reporting with Excel Analysis - 10 November & 11 November 2020

Contents

This course explores using SIMS reports to extract data and Excel to automatically analyse this data. It will cover the creation of reports in SIMS and explore some of Excel’s capabilities for data analysis including formulas, conditional formatting, macros and pivot tables.

What you will learn:

• How to link a SIMS report to a custom Excel template

• Excel formulas including Count-If / Count-Ifs, Sum If / Sum Ifs, IFERROR and others

• Designing more complex SIMS reports

• Excel conditional formatting

• Excel pivot tables

• Excel macros.

Who is it for?

Staff who wish to extend their ability to analyse data using SIMS and Excel

Age Phase

Secondary


Booking Details

Training courses

Training courses & Conferences

Filter by:
Training Course

New to Teaching Network Meeting - All five online sessions

As a highlighted area in the Ofsted Handbook, CPD for NQTs is of paramount importance. The new to teaching networks provide support and training for NQTs and those teachers who are in the early stages of their careers.

Training Course

SIMS 7 New User - All Phases - 16 September 2020

This course is for new administrative users of SIMS 7 – Admin Staff and Data Manager

Training Course

SCR Management and Myth Busting (online webinar) - 16 September 2020

Schools must ensure that they properly carry out, record and evidence a raft of pre-appointment checks as part of the recruitment process which is at the heart of safeguarding and promoting child welfare. A key part of this is maintaining the Single Central Record (SCR)

Training Course

SCR Management and Myth Busting - 16 September 2020

Schools must ensure that they properly carry out, record and evidence a raft of pre-appointment checks as part of the recruitment process which is at the heart of safeguarding and promoting child welfare. A key part of this is maintaining the Single Central Record (SCR)

HR and People

OneWellbeing Webinar Series - Autumn Term

This series of 5 webinars will guide leaders to develop, implement and assess their whole school wellbeing strategy. Offering practical advice and techniques to help you balance the needs of your staff and students.

Training Course

SIMS 7: Pupil Premium Training Course – All Phases - 21 September 2020

This course is for Data Managers and School Administrators who are in charge of inputting and maintaining Pupil Premium data in SIMS 7.

Training Course

SIMS 7 Parent App Demo - 21 September 2020

A brief overview of the Parent App, a simple way to collect, manage and handle information complying with the new GDPR requirements.

Training Course

SIMS 7 – School Census New User - 23 September 2020

This course is for staff with responsibility for preparing the statutory census return