Using the right tools for the job
Using the right tools for the job
Therese Coffe,Pensions Secretary, conceded that UK government figures relating to COVID-19 infections may well be inaccurate after what is referred to as a computer glitch. The ensuing blame game has started with Baroness Dido Harding, who runs the Test & Trace operation saying "we report the data when they [PHE] send it. We didn't get it". We now know that the computer glitch was in fact coursed by data been processed using Microsoft Excel. The data had exceed the maximum size and has now been resolved by splitting the Excel files into batches.
Microsoft Excel is an excellent tool for advanced data organisation and has one of the most complete data organisation and analysis systems for the common consumer, but has limitation. Accountants and software engineers understand these limitation, not least the fact that complex spreadsheets relying on formulae can be corrupted very easily, when data is input over a formula, or exceeds the expected range.
In situations where organisations have to come up with solutions on under pressure, many would use software solutions like Excel - or its open source equivalent OpenOffice Calc - to process large amounts of data, in order to get information. But, the decision making process is floored, if the people making the decisions, do not have the checks and balances in place to ensure the information is handled correctly. This needs to include consideration for data protection, data errors, user input, validation etc., It is also important to ensure you monitor the use of any solution, to make sure it works as expected.
It appears that these basic checks and balances were not in place and whilst the issue has now been picked up and rectified, it highlights the fact that using the right tool for the right job applies to digital transformation and technology, just as much as in any other application. This is why we use a formal process to identify the issues and outcomes, before defining a solution. It is also critical to have a procedures that ensures the solution is tested in terms of its performance and if it meets the previously identified outcomes.
Whilst it is understandable that a spreadsheet was used in this situation and it is easy to critise, it does highlight the need to learn from our mistakes. Government agencies are renowned for some pretty epic failures, when it comes to technology and to some degree that is understandable, as they are usually pretty huge applications, but that is not an excuse. If a system is critical, it should be treated as such and tested to ensure it meets its intended outcomes within the working environment.
That's why the Childcare on-line Booking (CoB) system is the right tool for wraparound childcare providers, as it has been specifically designed to help settings handle bookings for childcare, ensuring information is collected and processed and bookings are handles appropriately. During the global pandemic, we have implemented numerous updates to help providers manage bubbles for the summer camps and more recently year group bubbles in line with government guidance. Many smaller providers use spreadsheets and indeed many of our users moved from spreadsheets to CoB as it is proven to reduce administration time spent managing bookings, registers, etc.,
Make sure you are using the right tool for the job and contact us today!
If you like to get in touch, please telephone our offices on
+44 (0) 1364 582017 or complete our
on-line form and we'll get back to you
as soon as possible.
Stay in touch with what we're up to at Ayrmer Software by following us on one of our
social media feeds: we'd be delighted to welcome you as a follower on
become friends on facebook
or add us to your circle on Google+.
You'll also find us on Linkedin, of course.
childcare on-line booking
Find out more about how our clients have processed more than 248,000 bookings and generated more than twelve million pounds in revenue for our clients!
Our expertise lies in our ability to interpret your business requirements and provide a solution that meets your needs; find out how we achieve this level of understand. It's what makes us different ...
Find out about how we approach software development to ensure that the solution matches your business requirements.
Our philosophy is based upon the needs of your target audience and understanding their requirements that ensures we deliver an intuitive solutions that focuses on the User eXperience (UX), whilst developing lightweight, robust, secure on-line database applications.
Legal information required by the Companies House Act in the United Kingdom that include: place of registration, registered number, registered office address.