ICT Support

SIMS 7 Extended Reporting with Excel Analysis - 09 & 10 November 2021

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: £189 + 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 - 09 & 10 November 2021

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:
ICT Support

SIMS 7 Pupil Premium - 27 September 2021

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

Governor Support

Gov 03: Chairs Network Autumn - 27 September 2021

The Chairs Network is a termly meeting which includes a briefing on the latest developments in governance, best practice and policy updates from the DfE.

Music

Primary Music Coordinator’s Networking Virtual Meeting - 28 September 2021

The Autumn term’s primary music coordinators’ network meeting will once again be held online through Zoom. A chance for Primary Music coordinators to find out about current local and national issues with regards to music education.

ICT Support

SIMS 7 Standard Reporting - 28 September 2021

This course is for SIMS 7 users responsible for responding to requests for information. You should have attended a SIMS 7 Office User course or have a good understanding of SIMS.

School Improvement

Subject Leader Network Introduction - 29 September 2021

This free introductory Subject Leader Network Meeting session gives new and experienced subject leaders the opportunity to gain valuable insights from highly experienced School Development professionals.

Training Course

Advanced Designated Safeguarding Lead Training - 30 September 2021

This Advanced Training for Designated Safeguarding Leads gives an opportunity to look deeper in to the role and requirements of the Designated Safeguarding Lead whilst meeting the two-yearly statutory training needs for DSLs as stated in Keeping Children Safe in Education.

ICT Support

SIMS 7 and Power BI for Beginners - 30 September 2021

Microsoft Power BI is a powerful application for creating and sharing your school data. This course will show you all the basic concepts and get you up and running with Power BI creating your first Power BI analysis using SIMS data.

Literacy

Y2 Literacy Network Introduction - 30 September 2021

This free introductory Y2 Literacy Network Meeting session gives Y2 teachers the opportunity to gain valuable insights from experienced school leaders, moderators and DfE curriculum advisors.