You can follow Ofsted on twitter: https://twitter.com/Ofstednews
Education:Dover Grammar School for Boys, University of the West of England, The Open University
Qualifications:BSc(Hons) Computer Science, PgDip Machine Learning & Adaptive Computing, Psychology (conversion diploma), MSc Psychological Research Methods, HE DIP Humanities,
Work History:Ofsted for 5.5 years, JobcentrePlus for 6.5 years
Current Job:Higher Executive Officer, Ofsted
Ofsted is the Office for Standards in Education, Children’s Services and Skills. We inspect and regulate services that care for children and young people, and services providing education and skills for learners of all ages.
Every week, we carry out hundreds of inspections and regulatory visits throughout England and publish the results online.
Our goal is to achieve excellence in education and skills for learners of all ages, and in the care of children and young people.
We report directly to Parliament and we are independent and impartial.
We aim to be “a force for improvement through intelligent, responsible and focused inspection and regulation”
My Work: I work with data to generate insight about the education sector for Ofsted
I work for OFSTED, the government agency that inspects education (both for children and adults) and childcare across England. I work on a big civil service campus near Temple Meads where staff from a lot of departments are based.
You can look up the Ofsted inspection report for your school here:
I currently work on a small team that works with data to support inspections of the Further Education & Skills sector (Colleges, Apprenticeships, vocational training for jobseekers, education in prisons, specialist dance & drama schools, etc.). We get very large data sets in from other departments, manage it, write code to manipulate it, and produce reports for inspectors. When an inspection happens, the team of inspectors need all the data about how well the education provider is doing on different measures so they know what strengths and weaknesses to look at when they visit. We try to present the data in a clear fashion and create a system to identify key points, so the inspectors (who likely have less training working with data) don’t have to do this themselves.
I also do other analysis in response to developing events. Sometimes this involves more powerful statistical approaches such as regression modelling, for which we use specialist software.
Tools I use to work with data:
- Coding is done in SQL, a programming language used to work with databases and big data sets
- Excel is used to manipulate data and do basic analysis. We use some of the more advanced functions such as VLOOKUP and COUNTIFS
- Tableau is used to create interactive dashboards. For example, I’ve used it to plot all the childcare providers in England on a map and colour code the dots by their inspection outcomes, and let users zoom in and filter.
- SPSS (‘Statistical Package for Social Sciences’) is used for deeper analysis, such as regression modelling. I was taught how to use this as a psychology student.
I also use Word and Powerpoint to write up work and present / distribute it to others. Ofsrted also gives us journal access (like at a university) so we can look up cutting research findings that scientists have published.
My Typical Day: Working with data for Ofsted
I work flexi-time, so as long as I complete enough hours of work overall it’s ok for me to come or leave early or late when I want to. I have my own work laptop which connects to a big monitor at my desk in the office. This means I can take my laptop home to work, and I usually work from home one day a week.
A typical day might involving working on the various projects I’ve got on, using some of the tools mentioned above. Often this may be a few different things of different importance and urgency, but unless we are against a hard deadline this means I work on the one I feel like at the time, or change when I want a break.
I also have my work email open constantly, to try to respond to queries as they come in. In some roles this is very important – if a member of parliament asks a minister a question about the work of their department, the minister forwards it’s to the civil service to answer and we only have 24 hours to produce an official reply which might include tables of data, and we need to fully check everything to make sure it’s right. This can be complex if the wording of the question does not match the normal methodology. For example, they might ask a ‘how many nurseries are there is England?’ which sounds easy, but ‘nursery’ is not one of the recorded categories in the data.
I also try to follow the media and specialist press about the education sector. This helps stay abreast of what is going on and can feed into our work. For example, if there is a story about a school or college we might check their data to see what that shows us.
As someone who uses a computer a lot inside and outside work, it’s important to pace yourself to avoid RSI injuries from excessive typing. Taking regular breaks can be important – that doesn’t mean not working, it means doing something other than typing or mousing for a few minutes every hour.
What's the best thing you've ever done in your career?
Finish my MSc alongside my full-time job