1.7 Sample Project | Ed Tech
Title: Analyzing Student Engagement in an Online Course
Overview: In this project, we used data analytics to understand student engagement in an online course. We collected data on student activity in the course, including the time spent on course materials, the number of discussions participated in, and the number of quizzes completed. We used SQL and Excel to analyze the data and identify trends and patterns. Our goal was to improve student engagement and retention.
Data table:
| Student ID | Time Spent (hours) | Discussions Participated | Quizzes Completed |
|---|---|---|---|
| 1 | 10 | 5 | 3 |
| 2 | 7 | 3 | 2 |
| 3 | 8 | 4 | 3 |
| 4 | 5 | 2 | 1 |
| 5 | 12 | 6 | 4 |
SQL query:
Copy codeSELECT AVG(time_spent) as Average Time Spent, AVG(discussions_participated) as Average Discussions Participated, AVG(quizzes_completed) as Average Quizzes Completed
FROM student_activity;
This query calculates the average time spent, average number of discussions participated in, and average number of quizzes completed for all students in the course (assuming the student_activity table includes columns called time_spent, discussions_participated, and quizzes_completed).
Business metrics:
- Average time spent: We can use the average time spent as a measure of student engagement. A higher average time spent may indicate that students are more engaged with the course materials.
- Average discussions participated: The average number of discussions participated in can be used as a measure of student engagement in the course community. A higher average number of discussions participated in may indicate that students are more engaged with their peers.
- Average quizzes completed: The average number of quizzes completed can be used as a measure of student progress and retention. A higher average number of quizzes completed may indicate that students are more likely to complete the course.
Key tasks and responsibilities:
- Collected and cleaned data on student activity using SQL
- Created visualizations in Excel to explore patterns and trends in student engagement
- Used text analysis to identify common themes in student feedback
- Presented findings to the course instructors and made recommendations for improving student engagement and retention
Tools and technologies used: SQL, Excel, text analysis
Key achievements:
- Identify common themes in student feedback, including a lack of interaction with instructors and difficulty with course materials
- Recommend changes to the course structure and instructor communication to improve student engagement and retention
- Present findings to the course instructors, leading to the adoption of new policies and practices that improved student engagement and retention by 20% in the following semester.
This project demonstrates your ability to collect and analyze data, identify trends and patterns, and use your findings to make recommendations for improvement. It also showcases your technical skills in SQL and Excel, as well as your ability to apply text analysis techniques to real-world data.