Data Trackers to the Max! Build Totally Rad Student Tools with Your AI Coding Partner

Are your student data systems stuck on the B-side? It's time to press eject on tedious, insecure spreadsheets and create a system that truly rocks. In this hands-on workshop, you'll go from roadie to rockstar, building a sophisticated, secure, and automated student data tracker using Google Sheets and your new AI coding partner, Gemini.Forget sharing a master sheet where everyone sees everything. We'll tackle one of the biggest challenges in data management head-on: access control. You will learn how to build a system that automatically generates a separate, secure, view-only Google Sheet for every single student, shared only with them and their designated guardians. These individual "data stories" pull live information from a central teacher-managed database, ensuring privacy and providing families with a 24/7 window into student progress.A quick heads-up: Some school districts may restrict access to the Google Apps Script extension we'll be using. To ensure you can fully participate, we highly recommend having a personal Gmail account ready to use as a backup.We will start with a pre-populated data template. Using our "Programming Partner Protocol"—a simple guide for managing your projects—and a powerful "superprompt," you will instruct the AI to:Design a visually appealing student dashboard on a template tab.Dynamically link data from the master sheet to individual student tabs.Write a script that automatically creates and shares a unique, secure spreadsheet for every student.(Bonus) Abstract complex conditional formatting rules into a simple configuration sheet, making updates a breeze.You'll leave not just with a finished, high-impact tool, but with two powerful resources: our Programming Partner Protocol to guide your future projects, and a flexible "superprompt" template to build other custom solutions for your classroom, school, or district. This session is totally for you if you want to spend less time managing data and more time using it to make a difference.IMPORTANT NOTES:1. This session is designed for educators who are comfortable using Google Workspace but have zero prior coding experience. The central premise is that by learning how to effectively partner with an AI assistant, the technical barriers to creating powerful tools are removed. We will leverage pre-built templates and a structured prompting protocol, allowing participants to focus on the educational logic and goals, not on complex syntax. Familiarity with basic Google Sheets functions like =SUM or VLOOKUP is helpful but not required. One of your most-used technical skills will be copy-and-paste!2. Primary Focus: Instructional CoachesThis session directly empowers coaches to lead digital innovation by equipping them with a framework to build and deploy scalable, data-driven systems. It aligns with key competencies by enabling coaches to:Promote and model the use of digital tools to create systems for analyzing and sharing data for continuous improvement (Admin Competency - Content & Instruction).Build capacity in teachers by providing them with tools that make data more accessible and actionable, directly supporting the creation of individual learner profiles and personalized learning experiences (Teacher Competency - Data and Assessment).Demonstrate leadership for technology innovation beyond a single classroom by creating solutions that can be implemented school-wide, solving systemic challenges like data privacy and parent communication (Teacher Competency - Leadership).For Teachers:Digital Citizenship: This session provides a practical, hands-on application of digital citizenship by teaching how to manage and share sensitive student information ethically, securely, and responsibly.Data and Assessment: Participants will build a tool that directly supports the use of performance data to empower student self-monitoring and create individual learner profiles, making personalized instruction more attainable.For Administrators:Vision and Strategy: The session provides a concrete, low-cost model for executing a strategic vision around personalized learning and data transparency, which can be scaled across a school or district.Community: The tool created directly enhances communication and collaboration with community stakeholders (families) by leveraging online channels to maintain an open, transparent discourse about student learning.3. How This Session Supports:Advocacy: The tool empowers students and parents to advocate for themselves by giving them clear, continuous access to their own performance data, providing a foundation for data-driven conversations.Fairness: By automating the creation and distribution of data reports, the system ensures that every student receives the same level of detailed information, removing inconsistencies in communication.Equity: The system is built to bridge the digital divide. By providing both a 24/7 secure digital portal and an automated option for generating privacy-conscious paper reports, it en...