Best Gemini prompts for Sociology Teachers, Postsecondary

I have a dataset of survey responses from 500 students, with 20 questions, each with multiple-choice answers. The data is in a Google Sheets document, but it's messy and needs cleaning. I need to remove any duplicate responses, handle missing data, and convert all answer choices to numerical values. Then, I want to analyze the data to identify any correlations between the answers to questions 3, 5, and 10. Finally, I need to create a bar chart to visualize the distribution of answers to question 15. Can you provide a step-by-step process to accomplish this, including any necessary Google Sheets formulas or scripts?

I teach a large introductory sociology course with 200 students, and I use Google Classroom to manage assignments and grades. I want to automate the process of sending reminders to students who haven't submitted their assignments on time. I also want to set up a system to automatically grade quizzes and assign points based on the students' answers. Can you provide a workflow diagram and a set of Google Apps Script code snippets to accomplish this, using triggers and conditional statements to handle different scenarios?

I'm working on a literature review of 50 research articles on the topic of social inequality, and I need to analyze the themes and concepts that emerge from the data. I've extracted the abstracts and keywords from each article and stored them in a Google Sheets document. I want to use natural language processing techniques to identify the most frequently mentioned concepts and themes, and then visualize the relationships between them using a network diagram. Can you provide a step-by-step guide on how to use Google's NLP API to accomplish this, including any necessary code snippets and visualization tools?

I have a dataset of student performance metrics, including grades, attendance, and engagement scores, for a cohort of 100 students over the course of a semester. The data is stored in a Google BigQuery database, and I want to analyze it to identify trends and patterns in student performance over time. I'm particularly interested in exploring the relationships between attendance, engagement, and grades, and identifying any factors that predict student success. Can you provide a query to extract the relevant data, and then a set of statistical models and data visualization tools to analyze and interpret the results, including any necessary R or Python code snippets?