Best Gemini prompts for Teaching Assistants, Postsecondary

I have a dataset of student grades in a Google Sheet, with columns for student ID, assignment name, score, and date submitted. I want to write a script that calculates the average score for each assignment, identifies students who are at risk of falling behind (i.e., those with a cumulative GPA below 2.5), and generates a report that highlights areas where students are struggling. The report should include visualizations of grade distributions and trends over time. Please provide a step-by-step guide on how to accomplish this using Google Apps Script and Google Data Studio.

I am working with a team to develop a personalized learning pathway for a postsecondary course, and we need to analyze student learning outcomes data to identify knowledge gaps and areas where students are excelling. We have a dataset of student assessment results in a Google Sheet, with columns for student ID, assessment name, score, and learning objective. I want to use Gemini to develop a decision tree that recommends customized learning resources and activities based on individual student needs. Please provide a prompt that generates a decision tree based on the data and learning objectives, and includes suggestions for supplemental resources and activities.

I need to conduct an audit of our Google Classroom integration to ensure that all courses are properly configured and that student data is being accurately synced. I have a list of course IDs and instructor names in a Google Sheet, and I want to use Gemini to generate a report that checks for consistency in course settings, identifies any errors or discrepancies in student enrollment data, and provides recommendations for improving our Google Classroom workflow. Please provide a step-by-step guide on how to accomplish this using Google Apps Script and Google Data Studio.

I am working with a team to develop a predictive model that identifies students who are at risk of dropping out of a postsecondary program, and we need to analyze a dataset of student demographic and academic data to inform our model. We have a Google Sheet with columns for student ID, GPA, attendance, and demographic information, and we want to use Gemini to develop a predictive model that identifies key risk factors and generates a report that highlights areas where interventions can be targeted. Please provide a prompt that generates a predictive model based on the data and includes suggestions for interventions and support services.