The Applecado blog
Ten Years of Applecado: 2018 – Collaborative Data Analysis Tool (9/10)
We are nearly at the end of our ten year review, this week we’re looking back at a data analysis and collaboration tool we produced for the Education Development Trust.
Applecado were really excited to be approached by the Education Development Trust about their ideas for a new online tool that replaced numerous spreadsheets.
There are so many great benefits from taking any manual processing, paperwork or workflows and replacing them with an online system, such as:
- allowing multiple people to access and update at once
- recording who accessed a system or made updates
- various access levels depending on role permissions
- access from anywhere on multiple devices
- automated notifications
- easier report generation
- reducing time on data entry
- reducing human error, and so on.
The Education Development Trust had a previously spreadsheet based comparison tool that allowed a small group of education professionals to compare performance and identify areas to be worked on.
The problems and solutions:
1. Keeping this sort of data and sharing data entry meant taking turns or keeping a very close eye on the most up-to-date version to avoid overwriting or missing data.
Our system assigns groups of users to collaborate, tiered access gives one person permissions to add and manage other people in their group. Any number of people can add their data at any one time without any effect on previously saved information.
2. Adding data was time consuming, and sometimes required people to look up old results or answers.
The system can auto-populate answers from previous entries if they are needed repeatedly. Each step is broken down into sections and questions, progress can be saved easily if they don’t have enough time to answer everything in one sitting.
3. Reporting could only be done once everyone had completed the spreadsheet, reporting and analysis required someone to manually take that step.
Notifications are sent from the new system, encouraging people to submit their answers in time. Extra reminders can be triggered manually as well, and as soon as the answers have all been saved, the system can run various reports, produce graphs and save in easy to access PDFs and exportable CSVs.
- “Wow, this 17 year old is going places, what an amazing idea.
8th March 2021
- “Celebrating Friday! While we're in favour of following the advice /rules in place, we're very hopeful that next we… https://t.co/dvD4wfK6UC ”
5th March 2021
- “Ahh, so it is! Banksy confirms escaping prisoner artwork at Reading Prison.… https://t.co/VFmWxfHgKD ”
4th March 2021
- Busting Myths about Bespoke Websites Ohhhh the shame, its been too long since we last blogged Do us a favour and go check out the blog on our site, let us know what you think to our newest item.
- Tomorrow is loveyourpetsday apparently. Nicky had this guy zoombomb (is that a word now) a meeting this week and then collapse here, he must think hes helping officecat zoom
- When the homeschooling topic was colour wheels and youre swimming in leftover chocolates