Professional Context
I still remember the frustration I felt when trying to create a personalized learning plan for a student with autism, only to realize that the data from our district's database wasn't syncing with our classroom's Google Sheets. It was a tedious task to update each student's progress manually, and I knew there had to be a more efficient way to do it.
💡 Expert Advice & Considerations
Don't waste your time trying to use Gemini to generate generic lesson plans - instead, focus on using it to analyze your students' data and identify trends that can inform your instruction.
Advanced Prompt Library
4 Expert PromptsAutomated Progress Monitoring Report
Create a script that automatically updates a Google Sheets progress monitoring report for a class of 20 kindergarten students with special needs, using data from our district's database and Google Forms assessments. The report should include columns for student names, dates, and scores on the following skills: alphabet knowledge, phonological awareness, and social skills. Use the `=QUERY` function to filter the data by date range and student name, and the `=AVERAGE` function to calculate the average score for each skill. Assume the data is stored in a sheet named 'Data' and the report should be generated in a sheet named 'Progress Report'.
Individualized Education Plan (IEP) Goal Analysis
Analyze the IEP goals for a student with a learning disability and generate a report that identifies areas of strength and weakness, based on data from our classroom's Google Forms assessments and the student's IEP document stored in Google Drive. Use natural language processing to extract specific skills and objectives from the IEP document, and then use statistical analysis to compare the student's assessment scores to their peers. The report should include visualizations of the student's progress over time and recommendations for instructional strategies to support the student's growth.
Behavior Intervention Plan (BIP) Data Visualization
Create a data visualization dashboard using Google Data Studio that displays the behavioral data for a student with emotional and behavioral disorders, based on data from our classroom's Google Forms behavior tracking sheets. The dashboard should include charts and graphs that show the frequency and duration of target behaviors, as well as the effectiveness of interventions over time. Use the `=SUM` function to calculate the total frequency of each behavior and the `=AVERAGE` function to calculate the average duration. Assume the data is stored in a Google Sheets sheet named 'Behavior Data'.
Parent-Teacher Conference Agenda Generator
Generate a personalized agenda for a parent-teacher conference for a student with special needs, based on data from our classroom's Google Sheets progress monitoring reports and the student's IEP document stored in Google Drive. Use natural language generation to create a narrative summary of the student's progress and challenges, and then use machine learning to identify key discussion topics and recommendations for the conference. The agenda should include space for notes and action items, and should be formatted as a Google Doc. Assume the data is stored in a sheet named 'Student Data' and the IEP document is stored in a folder named 'Student Files'.