Educate : Analyse : Improve

Tailor-Made School Data Solutions and Training

IntrepiData creates bespoke automated school data systems in Excel to enhance school improvement and drive your student intervention strategies, saving you days (if not weeks) in your analysis work. Unlike some companies who offer one-size-fits-all data solutions, IntrepiData works hand in hand with school senior leaders and data managers to design and create systems that fit the needs of your school perfectly. Once you have extracted your raw data from your school's management information system, these solutions run automatically at the click of a few buttons and provide you with invaluable information in a much more timely manner than performing the analysis manually.

Some examples of the types of data systems we can provide your school:

  • Key Stage 3 and 4 automated attainment analysis systems to calculate Attainment 8, Progress 8, Basics, Ebacc and other pertinent measures needed for intervention strategies, governors' meetings, Ofsted inspections etc.
  • Automated behaviour and rewards analysis to identify "hotspots".
  • Attendance reporting and analysis tool to track individual students' attendance profiles and flag up concerns.
  • Early years system to collect and analyse pupil progress within each of the early learning goals.
  • Key stage 1 and 2 attainment data collection and analysis which augments teaching and learning.

IntrepiData can create automated systems to process and analyse any spreadsheet data that you would normally analyse manually in Excel. We currently charge £750 per day for system development and consultancy work. For more information on our tailor-made school data solutions, please don't hesitate to contact us.

Excel Training Courses for Schools

IntrepiData offers high quality off-the-shelf and tailored Excel training courses for school staff. Courses are delivered at your venue, therefore we can use your own data throughout the training, and at the end of the training you will have created solutions that you can actually utilise straightaway.

Off-the-Shelf Courses

"Demystifying Progress 8 using Microsoft® Excel®" - 1 day course, £295 per delegate

Using a step-by-step process and utilising some extremely powerful, yet completely understandable functions within Excel, this course will show you how to systematically calculate everything needed to work out Attainment 8, Progress 8, English Baccalaureate and Basics. Learn how quick and easy it is to analyse these headline figures by full year group cohorts or by sub-groups using PivotTable and PivotChart Reports.

Furthermore, empower yourself with advanced Excel skills that will be invaluable for the analysis of pupil attainment data within a subject. Quickly see how pupils are performing against their targets. Identify any pupils that are underachieving so interventions can be put in place. Analyse subject data by sub-groups to examine any attainment gaps, to help develop strategies for narrowing the gaps.

"Unleashing the Power of Microsoft® Excel® VBA to Automate School Data Analysis" - 2 day course, £535 per delegate

Do you want to speed up manual and repetitive Excel tasks within your school, in order to save vast amounts of time in your spreadsheet work? If the answer is yes, this two day course is ideal. You will learn how to automate spreadsheet tasks using Visual Basic for Applications (VBA). The course is very hands-on and your learning is reinforced by applying the topics covered to school related data problems in order to create practical solutions to those problems.

For both courses, delegates need to be familiar with Excel and creating basic formulae but do not need any experience of utilising functions. Current scheduled course dates and venues can be found on our Course Calendar page.

Tailor-made Courses

Whatever type of data you need to analyse within your school, IntrepiData can provide customised Excel training for your staff to speed up their analysis work. Staff from throughout your school, teaching or administrative, will benefit from the types of training courses that we provide - just ask IntrepiData for more information.

All of these courses can be delivered on-site to your team, using your own facilities and equipment. Onsite delivery costs £750 per day for up to 3 delegates. For each additional delegate, add £65 per day.  To find out more about our school training courses or to book a course delivery, please don't hesitate to contact us.

Prices are correct for 2020.