Summer Camp Registration & Administration

Problem: Create a less time consuming way of processing and handling registration, daily class lists including allergies and name labels for a Summer Camp. This used to be done manually, typing in registrant information - about twenty fields including name, address, emergency contact info- from a paper registration into a table in word. Then the info was manually copy/pasted to create class lists and labels for up to 150 kids each day.

My Solutions:

Online Registration

1. Use Google Spreadsheet & Forms to create a online registration form that can be linked to from the organizations main page. The data for each child registered flow to a google spreadsheet.

Excell Master List

1. Using the export funtion from google, the data can be copied and pasted into the 'master' list- a excell spreadsheet which has been formatted to have the same column headers, making data compatible.
2. I used excell's 'List' capability to be able to sort and filter the data by column by the criteria within it- for example, the Class column can be sorted to show just the SK or Grade 1s, so that a list of registered campers can be printed per class- of course any other relevant columns can be printed as well! Sorting by Allergy gives the kitchen staff a list of kids for whom they need to prepare special food.

Printing Name Tags

1. Avery has a great tool that you can download for free to make all sorts of labels with a few clicks. It works for data in excell or in a word document. You simply filter and select the data you want to be able to print and follow the simple wizard to select the type of label, arrange how the info will be displayed (just like in Word) and create your merged data labels. Voila; Class, Name & Allergy labels which the kids will wear everyday, created and printed in a few minutes!

Training Time: about 2 hours!