One of the things I enjoy most about my job as an instructional technology coordinator is working alongside teachers to dream up creative, out-of-the-box projects for our students. I really enjoy the process of brainstorming ideas, implementing the project in the classroom, and then sitting back to see what unfolds. Sometimes, though, technology coordinators have to do the little things to help out around the school. This was the case for me when I was recently asked by the 9th grade class to help them with a system to facilitate the annual Halloween Cupcake Sale. They wanted a program that would allow them to collect information about who the cupcake was purchased for, what grade level that individual was in, and the name of the person purchasing the cupcake. The program also needed to be able to eventually print labels to go along with each cupcake, sort orders by grade level, and help the 9th graders figure out if there were any students who did not receive a cupcake. Last year they used a filemaker pro solution written by an employee who was no longer here, so I suggested that we develop a google form to collect the data. And because the data automatically populates to a spreadsheet, we could do some type of mail merge with a word processing program and print-out the cupcake information on avery labels. Today we battle tested this process during our morning break time. We had two students taking orders via the google doc form and a few students taking money. I gotta say that the process worked incredibly well and the girls did great managing the sale.I suppose the most challenging thing on my end was entering all of the student and faculty/staff names in the form as options in a drop down list. Unfortunately the school roster that I received for our business office was alpha ordered by grade level, which meant that the names in the drop down list weren't alpha ordered across grade levels. This presented a few challenges to the girls as they entered sale information into the form. Finally, one other thing that I learned is that the forms can select at least 429 options in the drop down list (I was a little worried that there would be a limit on the number of options).
To borrow a phrase from Lee Lefeever at the end of his awesome Google Docs Commoncraft Video, "Google Docs Rocks!"
