Training Course

SIMS 7 Advanced Reporting with Excel Analysis - 08 & 09 July 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 Advanced Reporting with Excel Analysis - 08 & 09 July 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:
COVID-19 Webinars

One Education: COVID-19 Webinar series for schools - Can be viewed up to end of February 2021

Webinars will include discussion around The Recovery Curriculum, the experience of loss and isolation, how best to manage emotions as well as exploring anxiety and how to work with it using sensory activities.

COVID-19 Webinars

One Education: COVID-19 Webinar series for schools - 30 June 2020

Webinars will look at how to modify your curriculum, the best ways to use books to support children's emotional literacy and how we can help SEND pupils who have felt an impact due to COVID-19.

COVID-19 Webinars

One Education: COVID-19 Webinar series for schools - 1 July 2020

Webinars will continue; exploring how we can bridge the gap between home and school re-attachment, putting the best transition plans in place for SEND pupils, supporting autistic students back into schools post lockdown, and delving into a recovery curriculum for Looked After Children.

COVID-19 Webinars

One Education: COVID-19 Webinar series for schools - 2 July 2020

Webinars will look at safeguarding and pupil attendance during and after COVID-19, the Health & Safety essentials for re-building your school community, the changes to Payroll processes and how to maintain effective governance in challenging circumstances.

COVID-19 Webinars

One Education: COVID-19 Webinar series for schools - 3 July 2020

Webinars will explore the impact of COVID-19 on performance management, the best ways to manage ongoing HR Issues, how the equality law still applies as well as how to maintain a culture of positive wellbeing throughout the pandemic.

Training Course

OneWellbeing Webinar Series

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

How To Be An Effective Primary Music Coordinator - 01 December 2020, 09 February 2021 & 10 March 2021

Invaluable online courses for Primary Music Coordinators who are new to the role and need support and guidance on how to manage and lead music through their school setting.