Best Gemini prompts for Postsecondary Teachers, All Other

Using a dataset of student grades and performance metrics from the past semester, write a Python script to clean and preprocess the data for analysis, including handling missing values, removing duplicates, and performing data normalization. Assume the data is stored in a Google Sheets document and provide instructions on how to upload the cleaned data to a Google Cloud Storage bucket for further analysis. Provide a step-by-step guide on how to use the Google Cloud Dataflow service to perform data processing and transformation.

Create a Google Data Studio dashboard to visualize course enrollment trends over the past three years, using data from the university's database. The dashboard should include a line chart showing enrollment numbers over time, a bar chart comparing enrollment numbers across different courses, and a scatter plot analyzing the relationship between course enrollment and student demographics. Provide a detailed guide on how to connect to the database using Google Cloud SQL, and write a SQL query to extract the relevant data for the dashboard. Also, include instructions on how to schedule regular updates to the dashboard using Google Apps Script.

Using a dataset of student assignments and grades from an automated grading system, perform an error rate analysis to identify potential biases and inconsistencies in the grading process. Write a R script to calculate the error rates and provide a detailed report on the results, including visualizations and recommendations for improving the grading system. Assume the data is stored in a Google BigQuery dataset and provide instructions on how to use the Google Cloud AI Platform to train a machine learning model to predict student grades and identify potential errors.

Create a comprehensive quality audit checklist for online course development, including criteria for assessing course content, instructional design, and technical functionality. Write a detailed guide on how to use the checklist to evaluate the quality of an online course, including instructions on how to use Google Forms to collect feedback from students and instructors, and how to use Google Sheets to track and analyze the results. Provide a template for the checklist and include examples of how to use the checklist to identify areas for improvement in the course development process.