Professional Context
The postsecondary education landscape is becoming increasingly reliant on data-driven decision making, and Teaching Assistants are at the forefront of this shift, tasked with interpreting complex data sets to inform instructional design and student support strategies. As a result, the ability to effectively analyze and communicate data insights has become a critical skill for Teaching Assistants, who must navigate a myriad of software tools and systems to meet the demands of their role.
💡 Expert Advice & Considerations
To get the most out of Gemini, Teaching Assistants should focus on developing workflows that integrate Google Sheets, Docs, and Slides to create seamless data pipelines and presentation-ready reports, rather than trying to reinvent the wheel with bespoke solutions.
Advanced Prompt Library
4 Expert PromptsAutomated Gradebook Analysis
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.
Personalized Learning Pathway Development
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.
Google Classroom Integration Audit
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.
Predictive Analytics for Student Retention
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.