Analyzing Advanced Data
Note
AI can be used for advanced data analysis. You can also create interactive prototypes with the data. Use the following file to follow along with the prompts below.
Download File: Student Scores and Performance CSV
Download File: Student Scores and Performance CSV
Description
AI data analysis capabilities have increased in the last couple years. AI can assist in the development of multi-step workflows when it comes to analyzing data.
Prompt
Tip
Use the GPT-5 Thinking or o3 (Legacy) reasoning model
Help me run some reports analyzing student performance and related factors. Please follow these steps:
- Bar-chart: average overall exam score for each Career Aspiration (also list how many students per aspiration).
- Scatter plot: Weekly Self-Study Hours vs. overall exam score, with a best-fit line to show where gains level off.
- Bar-chart: mean overall exam score for students in four Absence Days buckets (0-2, 3-5, 6-10, >10).
- Side-by-side bar-charts: compare mean Math, English, and Science-composite scores for students with vs. without Part-Time Jobs (include a simple significance test).
Create a heatmap showing average scores for each subject (rows) across every Career Aspiration (columns).
Tip
At this point, start a new chat and continue to use the GPT-5 Thinking or o3 (Legacy) model. Upload the same CSV file as before.
Create an interactive prototype that allows me to select gender represented in the spreadsheet. When I select a gender, it shows a bar chart aggregated by career aspirations for that gender. Be sure to include total records per career aspiration.
Sample Output
In the last prompt, the chatbot might not let you interact with the prototype directly in the window, but will give you a file to download with instructions on how to run the app.
