Best Gemini prompts for Teaching Assistants, Special Education

Create a Google Data Studio dashboard to track student progress towards IEP goals, using data from a Google Sheets template that includes student names, goal areas, baseline data, and quarterly progress updates. The dashboard should include a table with student names, goal areas, and percentage of progress towards each goal, as well as a bar chart showing the average progress across all students. Assume the data is already cleaned and formatted, but you may need to adjust the data validation rules to ensure accuracy. Please provide a step-by-step guide on how to create this dashboard, including any necessary formulas or scripts.

Analyze a dataset of student accommodation requests for standardized testing, including data on student names, test dates, accommodation types, and approval status. Using Google BigQuery, write a query to identify the most commonly requested accommodations, the percentage of students who receive each accommodation, and the average processing time for accommodation requests. Then, use the results to create a set of recommendations for improving the accommodation request process, including potential automation opportunities and areas for further analysis.

Create a scheduling matrix in Google Sheets to optimize the delivery of related services such as occupational therapy, physical therapy, and speech therapy. The matrix should include columns for student names, service types, frequencies, and durations, as well as rows for each day of the week and time blocks. Using conditional formatting and formulas, highlight conflicts and suggest alternative scheduling options to minimize overlaps and maximize service delivery. Assume a set of predefined service schedules and student needs, but you may need to adjust the formula logic to accommodate specific scheduling constraints.

Develop a data-driven intervention planning framework using Google Jamboard, based on a set of student assessment data including scores, progress monitoring metrics, and demographic information. The framework should include a decision tree to guide the selection of interventions, a set of data visualizations to illustrate student progress, and a collaborative workspace for teachers and support staff to share resources and coordinate intervention efforts. Using sample data, create a prototype of the framework and provide a step-by-step guide on how to implement it in your own practice, including tips for customizing the decision tree and visualizations to meet the unique needs of your students.