THE SCHOENCAST: Tips for Viewing Form Responses in SheetsWednesday, April 20, 20165:35 PM
Welcome back to the third episode of The Schoencast. The goal of these screencasts is to provide strategies and guides to improving edtech workflows and productivity. With more effective workflows, organization, and more automation, we can spend more time on what matters: our students.
It’s been a while since the last episode; I quickly learned that screencasts take a lot of time. But I hope to do them more regularly moving forward. Please check out past episodes, 01: Form Mule and 02 Automating Tweets From a Class Twitter: An Updated Workflow.
Tips for Viewing Google Form Results in SheetsI love Google Forms and Sheets. But sometimes it can be hard to manage the data and make meaningful use of the information. Whether you use forms for data, assessment, feedback, or to track student work, life is better when the spreadsheets are more easily viewed.
In this episode, I walk you through five tips for better use of form results:
- Summary of Responses
- Freezing Rows and Columns
- Hiding Rows and Columns
- Resizing Cells
- Formatting Word Wrap
Protect DataCollaborating on a sheet? Or just want to avoid accidents? You can protect the data in specific cells, rows, or columns to restrict editing rights. This means that only you, or whomever you allow, can edit the cells. You can also add a warning before editing, too. Right click on any highlighted cells or data and see the options below.
Publish to the WebLike with any Google Doc or Slides, you can publish sheets to the web to share them as a more finished looking website. This provides you with an embed code, a public link, and allows you to share particular worksheets as necessary. Most of my form results wind up published and public, like my class Genius Hour website, at geniushour.aschoenbart.com, for example.
Thanks for checking out this post and episode 3 of The Schoencast. If you want to learn more about using Google Sheets and working with data, I recommends GFC’s Google Sheets tutorials and Google’s Spreadsheet Functions List. It’s where I got started exploring and playing with the possibilities.