Training Course

Advanced Reporting with Excel Analysis- Secondary 13 June 2019

This course explores the use of the reporting functionality to extract data and the use of Excel to analyse this data (Secondary schools).

Contact us or call 0844 967 1111

Cost: £189.00 +VAT (Or free to ICT SLA customers using promo code)

LOCATION:

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

Go back

Advanced Reporting with Excel Analysis- Secondary

Course Content

This course explores the use of the reporting functionality to extract data and the use of Excel to analyse this data. We will explore some of the capabilities of Excel in data analysis and show how to automate this analysis. This course will demonstrate how to combine the reporting and the analysis into a repeatable automated process, enabling you to generate the reports whenever necessary

Course Objectives

By the end of the course you will have an understanding of:

automating data analysis in SIMS reports using Excel Excel formulas analysing data using Excel designing more complex SIMS reports Excel pivot tables Excel macros.

Who's It For?

SIMS Exams Officers/Data Managers/Office Users

Age

Secondary


Booking Details

Training courses

Training courses & Conferences

Filter by:
Training Course

Safer Recruitment 24 April 2019

The course considers policies and practices that minimise opportunities for abuse and ensure prompt referral, supporting schools to develop and maintain a safer recruitment ethos.

Training Course

SIMS End of Key Stage Assessment Training 24 April 2019

School administrators responsible for entering and submitting end of Key Stage, EYFS and Phonics Testing data to the DfE/Local Authority. Assessment Co-ordinators responsible for managing the submission of assessment data.

Training Course

SIMS End of Key Stage Assessment Training 25 April 2019

Hands-on training session on using SIMS to complete the statutory assessment process in 2019.

Training Course

Music Coordinators' Network 30 April 2019

An opportunity to meet up with other music co-ordinators, discuss ideas and share good practice. There will be the opportunity to take part in a practical workshop to support your own CPD.

Training Course

SIMS Year End Procedures Seminar- Primary 30 April 2019

This half day seminar explores the pastoral arrangements for the new academic year including the new student intake, student leavers and dinner money.

Training Course

Y2 Writing Moderation April 2019 30 April 2019

A half day event to give delegates the opportunity to discuss pupil’s writing in line with the National Curriculum.

Training Course

Y6 Writing Moderation 30 April 2019

A half day event to give delegates the opportunity to discuss pupil's writing in line with the National Curriculum.

Training Course

SIMS School Census Seminar- Primary level 1 May 2019

An update seminar to brief you on the proposed changes to the statutory School Census returns in 2018/19 and the preparation required to complete the School Census.