Google Sheets for Teachers | How to Make Checklists, Dropdown Menus, and Use Formatting Tools
TeacherFYI
@teacherfyiAbout
Hi everyone! I'm MacKenzie, a 3rd grade teacher in Northern California. This channel aims to provide tips, tricks, and tutorials that would hopefully make things just a bit easier for teachers; focusing on classroom technology, classroom management, and a healthy work life balance. Please consider subscribing and clicking the bell icon to get notified of new videos. I upload videos every week (although my school schedule may have an impact around certain times of the year)! Welcome, and thank you for joining me!
Latest Posts
Video Description
Hey teachers! Follow along step by step to create your own colorful and functional checklist using Google Sheets. In this quick tutorial you will learn how to use the formatting tools, create a checklist, customize it to fit your teaching style, use dropdown menus to organize data and other tips, tricks and teacher hacks to make the most out of Google Sheets. Remember to like, comment with any feedback or questions, and subscribe so you don’t miss future videos for teaching tips! Subscribe here: https://www.youtube.com/teacherfyi?sub_confirmation=1 Let's Stay Connected! TpT store: https://www.teacherspayteachers.com/Store/Teacherfyi Instagram: https://www.instagram.com/teacherfyi/ Blog: http://teacher.fyi/ #teacherfyi #googlesheets #googleedu #formattingtools #edtech #googlesheetstutorial #teacherguide #teacher #teaching #teachertips #newteachertips #teachertechtips #classroomtechnology #elementaryteacher 0:00 Introduction 0:51 Setup & Formatting Tools 4:41 Checkboxes 5:00 Alternating Colors 5:23 Checklist Colors 6:51 Drop Down Menus 8:52 Freeze Columns 9:30 Text Wrapping 10:10 Printing
Streamline Teaching with These Tools
AI-recommended products based on this video
(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws
Magnetic Car Mount Air Vent Cell Phone Holder, Universal Vehicle Dash Dashboard Ac Airvent Cellphone Magic Stand with Clip Hook, for iPhone 16 15 Samsung Lenovo Google etc
100W USB C Universal Laptop Charger Fit for Lenovo MacBook HP Dell Acer Asus Thinkpad Google MSI LG Samsung Huawei, ROG Ally, Steam Deck, Chromebook Computer and All USB-C Devices
INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad
(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws
INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc
INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad
Open Office Suite 2024 Professional Edition CD DVD 100% compatible with Microsoft® Word® and Excel® for Windows 10, 8, 7, Vista, XP And Mac OS X
(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws
Magnetic Car Mount Air Vent Cell Phone Holder, Universal Vehicle Dash Dashboard Ac Airvent Cellphone Magic Stand with Clip Hook, for iPhone 16 15 Samsung Lenovo Google etc
100W USB C Universal Laptop Charger Fit for Lenovo MacBook HP Dell Acer Asus Thinkpad Google MSI LG Samsung Huawei, ROG Ally, Steam Deck, Chromebook Computer and All USB-C Devices