Training Course

SIMS 7 Advanced Reporting with Excel Analysis - 15 & 16 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 - 15 & 16 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:
Webinars

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.

Training Course

Exploring the Reading Curriculum (All 3 Virtual Sessions)

These online courses will support staff to improve their subject knowledge; develop their approaches to teaching reading and encourage reflection. Using engaging high-quality texts, the sessions will delve deeply into best practice. Delegates are welcome to book on to the full three day programme, or choose to attend the sessions individually according to need.

Training Course

Early Reading & Phonics in a Reading Rich Curriculum (2 virtual sessions) 5 March & 29 April 2021

This two-day online course will explore the importance of early reading and phonics in a ‘Reading Rich’ curriculum that values the importance of reading as a crucial life skill.

Training Course

Exploring the Reading Curriculum (Single Virtual Session) - 28 April 2021

This online course will support staff to improve their subject knowledge; develop their approaches to teaching reading and encourage reflection. Using engaging high-quality texts, the sessions will delve deeply into best practice. Delegates are welcome to book on to the full three day programme, or choose to attend the sessions individually according to need.

Training Course

Early Reading & Phonics in a Reading Rich Curriculum (single virtual sessions) 29 April 2021

This online event will explore the importance of early reading and phonics in a ‘Reading Rich’ curriculum that values the importance of reading as a crucial life skill.

Training Course

Health and Safety Risk Assessments for School Trips Post Covid - 30 April 2021

This webinar will update you on the latest government and department of education advice and how this relates to planning trips. It will also include how to plan and select venues ensuring they are Covid-secure, key documents to request and what a thorough risk assessment for a trip would be like. The basics of risk assessment principles will also be covered which will apply for School trips but also risk assessments on other activities within your school. The webinar will also cover considerations as part of your risk assessment process including social media sharing and some example case studies that highlight the importance of planning and risk assessment in making your school trip a success.

Training Course

New to Teaching Network Meeting - 5 May 2021

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

Safer Recruitment Refresher: Accredited by The Safer Recruitment Consortium - 05 May 2021

This half day accredited training, delivered by accredited trainers, will support your school to effectively discharge its responsibilities for safer recruitment. It is designed for anyone who has attended an accredited Safer Recruitment course in the last three years and will ensure their knowledge is refreshed, is up to date with the latest safer recruitment requirements in line with the current ‘Keeping Children Safe in Education’ guidance and will renew your certificate to ensure your establishment is compliant.