Actually I have used this system for several years, but thought perhaps with the New Year, I would share my system with all of you. For those of you who do not know it, I keep track of my demographics/impact data using Google Docs. Yep, that’s right, Google Docs. Google Docs allows me to have access to my database where ever I have access to the internet. So, if you have a MiFi and are in the field when you are teaching, this is just the trick to help you keep track of your impact data.
First of all, I have a form that I have set up in Google Docs. This one is designed to keep track of demographic data. You can take a look at my form here: http://go.unl.edu/accountabilityreportform2014
When I input data into the form, the data goes into a spreadsheet which looks like this: http://go.unl.edu/accountabilityreportdata2014
I use a second form/spreadsheet set to keep track of my evaluation data.
The functions embedded in the spreadsheet allow me to aggregate data without a whole lot of fuss! And, when I’m running short on time, I can embed the charts into online documents/websites and let the documents update themselves with the data as I catch up with data input.
Feel free to submit your own data using the first link (I made a copy of my form/spreadsheet data to share so that no one is messing up my data), then click on the second link to see how that data is recorded.
Happy New Year!!!