Colette Cassinelli's visionary use of information literacy and educational technology

Tag: spreadsheets

Make a self-calculating Survey

Make a self-calculating Survey

I am currently teaching Excel to my computer students and we always do a project where the students create surveys and graph the results.  I was inspired by Jesse Spevack’s self-graded quizzes – so I thought I would use the same process with surveys and […]

Instructional Technology Strategies Conference (ITSC) – February 17-19, 2008

Instructional Technology Strategies Conference (ITSC) – February 17-19, 2008

Engaging Students with Authentic Technology Projects – Sun, 2/17/08, 7:30-8:30 pm Handouts located at: http://edtechvision.wikispaces.com/ITSC Embrace 21st century strategies to create an instructional learning environment that moves away from teaching isolated computer skills towards an integrated thematic approach. Come learn how you can combine everyday […]

Creating surveys using Google spreadsheets

Creating surveys using Google spreadsheets

Thanks for the tip from Darren Draper, I just learned forms.pngthat Google shared spreadsheets now has the ability to create forms to collect information and have the answers drop into a spreadsheet. How cool is that?

From Google: Create a form in a Google Docs spreadsheet and send it out to anyone with an email address. They won’t need to sign in, and they can respond directly from the email message or from an automatically generated web page. Creating the form is easy: start with a spreadsheet to get the form, or start by creating the form and you’ll get the spreadsheet automatically.

Responses are automatically added to your spreadsheet. You can even keep a closer eye on them by adding the Google Docs forms gadget to your iGoogle homepage, created by software engineers Valerie Blechar and Sarah Beth Eisinger (in her first month at Google!). It lists your recent active forms, with new responses highlighted. Add this gadget to your iGoogle page: Add to Google

I’m host a workshop next week at the ITSC conference in Portland and I was planning on sharing a project that my students did using Google shared spreadsheets and now I will have to discuss this too!! Wouldn’t it be great to have attendees each fill out the survey and then immediately show them the results on a shared spreadsheet???

Collaborating with Google Docs and Spreadsheets

Collaborating with Google Docs and Spreadsheets

Collaboration – (kuh-lab-uh-rey-shuhn) n. the act of collaborating. Working together for a common end. Every class can benefit from enhanced collaboration among students and between students and instructors. Learning is social. Course assignments that encourage collaboration are effective way of encouraging interaction and discussion among […]