Professional Context
I still remember the frustrating moment when I had to manually compile student performance data from multiple sources, only to realize that the error rates were higher than expected, and I had to redo the entire quality assurance process. It was then that I realized the importance of having a streamlined data analysis workflow, especially when working with industry-specific databases and communication platforms.
💡 Expert Advice & Considerations
Don't bother using Gemini to generate generic lesson plans, instead focus on using it to identify patterns in student performance data and automate tedious tasks like data cleaning and quality audits.
Advanced Prompt Library
4 Expert PromptsAutomated Data Cleaning for Student Performance Metrics
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.
Google Data Studio Dashboard for Course Enrollment Trends
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.
Error Rate Analysis for Automated Grading System
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.
Quality Audit Checklist for Online Course Development
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.