Best Gemini prompts for Educational Instruction and Library Workers, All Other

Create a step-by-step guide on how to connect Google Data Studio to our database of student standardized test scores, including how to create interactive dashboards that allow for filtering by demographic variables such as grade level, socioeconomic status, and English language learner status. Ensure the dashboard includes at least three visualizations: a bar chart comparing average scores across different subjects, a scatter plot examining the relationship between scores and attendance rates, and a map showing geographic distributions of scores. Provide detailed instructions on how to share this dashboard with relevant stakeholders, including teachers, administrators, and parents, and suggest strategies for using the insights gained from this dashboard to inform instructional decisions.

Design a Google Apps Script that automates the process of sending personalized emails to students who are struggling in a particular course, based on grades stored in a Google Sheets spreadsheet. The script should pull student names, current grades, and relevant course information from the spreadsheet, and then use this data to populate a template email that includes suggestions for additional support resources and invites students to meet with their instructor during office hours. Include instructions on how to schedule the script to run weekly, using Google's triggers feature, and provide troubleshooting tips for common errors that may arise during implementation.

Develop a comprehensive plan for using Google Analytics to track and analyze learning outcomes for online educational resources, such as video tutorials and interactive simulations. This plan should outline how to set up Google Analytics on the website or learning management system hosting these resources, create goals and events that correspond to key learning milestones (e.g., completing a tutorial, achieving a certain score on a quiz), and analyze the resulting data to identify trends and areas for improvement. Include recommendations for A/B testing different versions of educational content to optimize engagement and efficacy, and discuss how to use Google Analytics' segmentation features to compare outcomes across different learner subgroups.

Create a detailed workflow for using Google Drive to facilitate collaborative curriculum development among teams of educators. This workflow should include instructions on how to set up a shared Google Drive folder structure, complete with subfolders for different subjects and grade levels, and how to use Google Docs to create and edit curriculum documents in real-time. Provide guidance on using Google Drive's commenting and suggestion features to facilitate feedback and revision, and outline a process for tracking changes and updates to curriculum documents over time. Finally, discuss strategies for integrating this workflow with existing project management tools and calendars to ensure seamless collaboration and minimize version control issues.