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 Sheets

I 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:

1. Summary of Responses
2. Freezing Rows and Columns
3. Hiding Rows and Columns
4. Resizing Cells
5. Formatting Word Wrap

Below the episode, find two bonus tips to increase your impact and productivity. If you’re looking for more use cases for forms or sheets, here are few articles worth checking out, too: The 5 Best Google Forms & Sheets Add-ons for Teachers, The Pros & Cons of Google Forms in Classroom, and Managing Late & Revised Student Work in Classroom & Forms.