Data Driven & Stress-Free: Mastering Google Sheets for Student Success (Basics)

As Alberta educators, we're constantly juggling diverse student data, from assessment results to attendance records. Let's transform that data from a source of overwhelm into a powerful tool for informed teaching! This practical, hands-on session will demystify Google Sheets and show you how to leverage its features to streamline your workflow and gain valuable insights into student progress, all while adhering to Alberta Education standards. In this session, you'll learn how to: * Organize Your Data: Create structured spreadsheets for efficient data entry and retrieval, making student information readily accessible. * Sort & Filter Like a Pro: Quickly identify trends and patterns in student performance using powerful sorting and filtering techniques. * Colour Code for Clarity: Visually represent student progress with conditional formatting, enabling you to instantly spot areas of strength and need. * Harness the Power of Formulas: Calculate averages, track attendance, and automate grading with simple yet effective formulas (e.g., AVERAGE, COUNTIF, SUMIF). * Create Visual Representations: Generate basic charts and graphs to illustrate student progress and share data with parents and administrators. * Utilize Data Validation: Build drop down lists for easy input of things like attendance codes, or subject names. * Use the "Filter Views" function: Allow multiple users to filter the data without affecting the main data set. * Explore "Google Forms" integration: Learn how to use google forms to collect data, that then populates directly into a google sheet. Join us and discover how Google Sheets can become your indispensable ally in creating a data-driven, organized, and stress-free classroom environment, ultimately benefiting our Alberta students." Session Objectives: 1. Basics of Google Sheets 2. Spreadsheet basics 3. How to use formatting to make data work for you