Managing student data can be overwhelming, but Excel offers powerful tools to make it easier. In this video, Emily Taylor shares practical techniques for organizing and analyzing classroom data more efficiently. Learn how to streamline your workflow, apply visual insights, and make data-driven decisions to better support your students.
👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt
🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-training/hackathons/
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-mentoring/
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-training/customized-enterprise-training/
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/
Let's connect:
✔️Discord: https://prag.works/yt-discord
✔️Facebook: https://prag.works/yt-fb
✔️Instagram: https://prag.works/yt-insta
✔️LinkedIn: https://prag.works/yt-li
00:00 - Why Teachers Need Excel for Student Data
01:14 - Overview of the Student Data Example
02:24 - Using the SWITCH Function for Score Levels
06:52 - Copying Formulas Across Columns
07:34 - Mastering the XLOOKUP Function
10:58 - Conditional Formatting for Visual Insights
15:23 - Grouping Students with Filterable Tables
17:55 - Conclusion and Excel Bootcamp Information
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email:
[email protected]
#PragmaticWorks