The ICT service

Designing the EWO Weekly Attendance Report

Thongsley Fields Primary School, Cambridgeshire


Improving life for school administrators, by providing efficient ways to complete the mundane tasks they are expected to undertake, is something that The ICT Service MIS and Helpline teams take pride in doing.

Just one example of this is the Weekly Attendance Report that our Helpline team member, Rob Gorst, has designed to support Thonglsey Fields Primary School and a number other schools in Cambridgeshire using SIMS.


The challenge for school administrative staff

A weekly report of ‘Percentage Attendance Per Pupil’ is commonly requested of school administrators by Education Welfare Officers (EWOs).  A pre-defined SIMS Attendance Report can be run (Reports | Attendance | Selected Pupil Reports | Percentage Attendance Report), however, this report will only show one week at a time. Whilst it is possible to change the date range, generate the report and then copy and paste the results into an Excel spreadsheet, this is a time-consuming task and requires a certain amount of post-production (i.e. pupils leaving or joining the school mid-year makes matching up the list of pupils, week-on-week, an arduous process).


How an efficient solution was created

Our Helpline team member, Rob, is extremely experienced in supporting schools with all manner of requests and he recognised that several schools were finding this data formatting task inefficient.   He designed a new SIMS report definition – named ‘EWO Weekly Attendance’ - and he produced a detailed visual guide for our customers to use; which includes how to import the SIMS report definition, run the report, add filters and change the sort order.   The guide also includes examples showing how selecting the attendance data and running conditional formatting in the report, can make it easier to interpret the results. This solution has succeeded in reducing a rather laborious process to just a few steps.

Why use The ICT Service?

The ICT Service currently offers FREE MIS audits, which we hope will increase and expand your understanding of what the SIMS system can do for you and how it can better meet the needs of your own specific school requirements.
We offer regular training to support your staff throughout the year with key areas of focus and across all aspects of SIMS.  Please visit for the full schedule of workshops available.  Alternatively, our consultants can deliver training via remote sessions or in-school consultancy.
If you think your school would benefit from a bespoke service offered by The ICT Service MIS Team, please call us on 0300 300 0000, send an email to or visit our website at

Download the case study


Customer Request/Incident

We invite our customers to use our online form to quickly let us know if you have a request or an incident to report.

Submit details

Your Basket

  • No products selected


Add products to your basket to enquire about multiple services

what people say…

  • I found the whole session incredibly useful. You gave us lots of useful resources to take back to school and even more to think about.

    E-Safety Course

  • I was given extremely clear and understandable instructions to help me find my way through difficulties.

    Sue Bardell, LLDD Team, CCC

  • Everyone I deal with on the Helpline is helpful and patient especially understanding the pressures we're under. It's lovely to know we have an efficient team available when needed.

    Lynn Hilling, The Vine Primary School

  • I have been in this job over 10 years and find the team a comfort at times of stress over jobs that have gone wrong. They are a credit to the service.

    Rebecca Mack, Business Manager, The Fields CC

  • The course answered all my questions but went far beyond my expectations. Very good value for money. I also appreciate the handbook.

    Margaret Carpenter, Longsands Academy

  • The trainers was very happy to answer all questions so that we are able to use the system in the most effective way for our school

    Alison Rowbotham, The Weatheralls Primary School

  • All courses that I have attended are so helpful and are explained in terms that I can understand and I am not afraid to ask questions.

    Sarah Walker, Thorndown Primary School

  • Emma always explains what you need to do very clearly and is extremely helpful - Thank you

    Sue Scott, Alderman Payne Primary School

  • I always find the technical team extremely helpful and knowledgeable and very patient with whatever question you ask!

    Emily Lewney, Bar Hill Community Primary School

  • I attended a truly fantastic course which has really opened my eyes to how I can use SIMS to support my data analysis.

    Yasmin Trace, Hatton Park Primary School

  • Thank you. The e-safety session was one of the best uses of time that I have had for a long while.

    E-Safety Course

  • ...really helplful during a very stressful time...

    Secondary School ICT Technician

  • Our Technician always goes the extra mile for us. He understands our school needs and limitations. He is considered to be one of our school team.

    Primary School Headteacher

  • I don't know what I would do without The ICT helpline. I have always found them to be friendly and supportive whenever I have called

    Primary School Secretary

  • I just wanted to let you know how happy we have been with a recent server installation at school. Great service and so prompt.

    Head, Abbots Ripton C of E Primary School

  • Always helpful to guide me through the troubled waters of the Post 16 Census! I don't know how I would manage without them.

    Christine Bradshaw, St Ivo School

  • Very helpful, I like the way that The ICT Service can come on to the system remotely it saves so much time!

    Chris Cater, Cottenham Primary School

  • Really clear, easy to follow course with some great ideas.

    Sarah Dodsworth, Wisbech St Mary Primary School

  • We have used The ICT Service now for many years, and have the highest praise for all the departments we deal with (we couldn’t live without our ICT technician or the helpdesk!).

    Weatheralls Primary School

  • The Helpline are always great when I ring and try to sort the problem there and then at all times if possible. Great service.

    Paula Beeby, Coates Primary School

  • Lorraine on The ICT Service Helpline was very patient and friendly and seemed genuinely pleased to be helping me.

    Sheena Marsh, Sawtry Infant School

latest tweet

  • Scheduled downtime is complete, all services are back online. For support, contact The ICT Service Helpline on 0300 300 0000 #ICTDowntime

    1 week

Tel:0300 300 0000