I was in charge of leading a group of around 60 campers on a sport camp recently. All campers signed themselves up online and i was provided with a raw output of all the data that had been inputted by the individual campers.

To make my job easier and a lot more effecient for future use, I spent time ‘cleaning’ the data by manaually searching through the raw data for open or blank cells and consolidating all the information into a nice and smalller package than that what was recieved originally.

The new data base was a lot less confusing and compact compared to the chaotic information hall that was given to me.