Oct 12 2012
Google Apps for Educators Workshop – Using Google forms to gather and analyze data from your students
Part 1 – Demonstration:
As a teacher of a subject in which data forms the basis all understanding, I like to put my students to work finding and analyzing the data most relevant to our subject. In my unit on Macroeconomics (the study of entire nations’ economies), I teach that the primary objectives of government and central bank policies is to achieve four goals. These are:
- Price level stability (low inflation)
- Economic growth (increase in income over time)
- Low unemployment
- Relative equality in the distribution of income
Now, as a class, we can gain a deeper understanding of some of the most important macroeconomic indicators using current data from our own countries, researched and aggregated using Google Forms, analyzed using Google Spreadsheets and the charts it can be used to create.
Part 2 – Brainstorming
As an Economics teacher, there are loads of data relating to nearly every topic I teach available online for students to research, aggregate and analyze. But what about in your subject? The second part of this presentation requires you and some of your peers here today to get together and brainstorm how Google Forms and Spreadsheets could be harnessed in your own subject area. Please get together with two or three people around you and discuss the following questions.
- What do you teach or what is your role in your educational community?
- What role does data play in your field?
- How could you harness Google Forms and Spreadsheets to more efficiently and effectively collect and analyze data either for educational or productivity enhancing purposes?
Take 10 minutes and discuss these questions with the people around you. Once you’ve discussed the questions, follow the link below and share your your thoughts on how you could use Google Forms in your role as a member of a faculty or staff in an educational community.
At the end of this session, the results from everyone’s brainstorming session can be viewed publicly by clicking here: Google Forms for Data Analysis – Brainstorming Results
If you have any questions about how I use Google Forms or other Google Apps in the classroom, please send me an email at email@example.com. I hope you enjoyed today’s presentation, and thanks for coming!
About the author: Jason Welker teaches International Baccalaureate and Advanced Placement Economics at Zurich International School in Switzerland. In addition to publishing various online resources for economics students and teachers, Jason developed the online version of the Economics course for the IB and is has authored two Economics textbooks: Pearson Baccalaureate’s Economics for the IB Diploma and REA’s AP Macroeconomics Crash Course. Jason is a native of the Pacific Northwest of the United States, and is a passionate adventurer, who considers himself a skier / mountain biker who teaches Economics in his free time. He and his wife keep a ski chalet in the mountains of Northern Idaho, which now that they live in the Swiss Alps gets far too little use. Read more posts by this author