Vigyata.AI
Is this your channel?

Making Google Sheets Work for You

315 views· 21:13· Jul 11, 2023

🛍️ Products Mentioned (5)

This tutorial will walk you through how to efficiently analyze and disaggregate data by using conditional formatting and filters. 0:00 Overview 00:40 Automatically Adjust Column Width 01:44 Borders & Alternating Colors 05:06 Freezing Rows and Columns 06:38 Adding Checkboxes 07:45 Dropdown Boxes 09:52 Text Wrapping 11:09 Conditional Formatting 16:52 Filtering Data https://bit.ly/DearDIS subscribe for more tutorials. Check out our #GoogleEdu Tools for #hcspdl students & teachers Playlist: http://bit.ly/HCSGoogleHelp Do you like @Nearpod? Check out our playlist of Nearpod resources: https://bit.ly/NearpodDLDIS Follow @DearDISes: http://bit.ly/DISFacebook - Facebook http://bit.ly/DISTwitter - Twitter

About This Video

In this video, I’m showing you how to make Google Sheets work for you—especially when you’re staring at a spreadsheet full of student data and you need it to actually tell you something. I walk you through quick formatting moves that instantly make a sheet easier to read and manage, like automatically adjusting column widths, adding borders, and using alternating colors so your eyes don’t cross while you’re trying to analyze results. I also show you how freezing rows and columns keeps headers visible while you scroll, which is a small change that makes a huge difference when you’re working with larger datasets. Then we get into the stuff that really helps with classroom workflows: adding checkboxes for quick tracking, dropdown boxes for consistent data entry, and text wrapping so nothing gets cut off. My favorite part is conditional formatting, because it helps you spot trends fast—like who’s meeting a benchmark and who needs support—without manually scanning every cell. Finally, I show you how to filter data so you can disaggregate and focus on the exact group you need, whether you’re looking at specific classes, standards, or performance levels.

Frequently Asked Questions

🎬 More from Dear DISes