Training Course

SIMS 7 Extended Reporting with Excel Analysis - 11 & 12 March 2021

This two day 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 7 Extended Reporting with Excel Analysis - 11 & 12 March 2021

Contents

This two day 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:
Webinars

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.

Literacy

Literacy Conference 2020 - Virtual Conference

The fifth annual One Education Literacy Conference is sure to be a great day! The theme for #LitConf20 is ‘Literacy for All’.

Training Course

SIMS 7 School Workforce Census - 21 October 2020

This course is for staff responsible for School Workforce Census returns and/or for maintaining staff details in SIMS or elsewhere, with a working knowledge of SIMS Personnel.

Training Course

Literacy Leader Network Meeting - All 3 online sessions

The Literacy Lead network meetings take place once a term and are a fantastic opportunity to work alongside others in similar situations, whilst using the knowledge and experience of the course facilitators who are experienced moderators, curriculum advisors for the STA, School leaders and classroom teachers.

Training Course

Literacy Leader Network Meeting - 21 October 2020

The Literacy Lead network meetings take place once a term and are a fantastic opportunity to work alongside others in similar situations, whilst using the knowledge and experience of the course facilitators who are experienced moderators, curriculum advisors for the STA, School leaders and classroom teachers.

Training Course

Designated Safeguarding Lead Virtual Training - 21 October 2020

This live, virtual designated safeguarding lead training will take an in-depth look at key legislation and government guidance which provides the framework for safeguarding within our schools. The session will provide opportunities to analyse serious case reviews and will encourage professional discussions, allowing schools leaders and DSLs to review their practice within Ofsted and government guidance.

Training Course

Governor Panels - Your Responsibilities - 21 October 2020

A governance board may establish a range of ad-hoc committees to discharge its functions - including oversight of complaints, staffing matters and pupil exclusions. This session will support increased understanding of remit and responsibilities across a range of common panels and support development of generic key skills for panel chairs and members. This training will be delivered virtually.

Training Course

SIMS 7 School Workforce Census - 22 October 2020

This course is for staff responsible for School Workforce Census returns and/or for maintaining staff details in SIMS or elsewhere, with a working knowledge of SIMS Personnel.