Data Analysis in Excel

Objective

Utilize Copilot to analyze data and generate insights.

Activity

Imagine you are part of the administrative team at Tulane University, tasked with analyzing student satisfaction from the past semester. The dataset includes responses to various questions about course quality, faculty performance, campus facilities, and overall satisfaction.

Click here for an example data set

The following details were generated in Copilot for you to use in this activity

Sample Dataset CSV File

Student ID	Course Name	Instructor Performance (1-5)	Course Content (1-5)	Learning Environment (1-5)	Overall Satisfaction (1-5)	Comments
2001	Introduction to Psychology	4	5	4	5	Very engaging and informative.
2002	Calculus I	3	4	3	4	Good course, but challenging.
2003	World History	5	5	4	5	Excellent lectures and materials.
2004	Chemistry 101	2	3	3	3	Needs more hands-on experiments.
2005	English Literature	4	4	5	4	Well-organized and insightful.
2006	Sociology	3	3	4	3	Interesting topics, but too fast-paced.
2007	Art History	5	5	5	5	Loved the course, very enriching.
2008	Physics 101	4	4	4	4	Informative and well-structured.
2009	Economics 101	3	4	3	4	Good content, but heavy workload.
2010	Philosophy	4	5	4	5	Very engaging and thought-provoking.

This dataset includes various aspects of student satisfaction across different courses, such as instructor performance, course content, learning environment, and overall satisfaction, along with comments for qualitative feedback.

Instructions

Open/Copy the provided dataset into Copilot
Use Copilot to generate charts that visualize the data (i.e. bar charts, pie charts)
Ask Copilot to identify trends and patterns in the data, such as areas with high or low satisfaction.
Use Copilot to summarize the key findings from the data analysis.

Key Points for Exploration

Create Charts: Use Copilot to create visual representations of the data, such as:

A bar chart showing average satisfaction scores for different courses.
A pie chart illustrating the distribution of overall satisfaction levels.

Identify Trends: Ask Copilot to highlight significant trends, such as:

Courses or departments with consistently high or low satisfaction scores.
Common themes in open-ended responses.

Summarize Findings: Use Copilot to generate a summary of key insights including:

Overall satisfaction trends
Specific areas of strength and areas needing improvement
Recommendations based on the data analysis.