Back to Data Detective
Free Demo
AI-Powered Attendance Analysis
5-10 minutes
What You'll Experience
1
View anonymised attendance data for 15 students over 6 weeks
2
Use a ready-made prompt to analyse the data with ChatGPT or Claude
3
See how AI spots patterns that would take hours to find manually
Step 1: Sample Attendance Data
This is anonymised attendance data from a fictional Year 8 class. Each fraction shows days attended out of 5 school days per week.
| Student | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 |
|---|---|---|---|---|---|---|
| Amara Johnson | 5/5 | 5/5 | 5/5 | 5/5 | 5/5 | 5/5 |
| Ben Taylor | 4/5 | 4/5 | 3/5 | 4/5 | 3/5 | 3/5 |
| Chloe Williams | 5/5 | 5/5 | 4/5 | 4/5 | 3/5 | 3/5 |
| Daniel Brown | 5/5 | 5/5 | 5/5 | 5/5 | 5/5 | 5/5 |
| Emma Davies | 4/5 | 5/5 | 5/5 | 4/5 | 5/5 | 5/5 |
| Fatima Ahmed | 5/5 | 4/5 | 5/5 | 4/5 | 5/5 | 4/5 |
| George Wilson | 5/5 | 5/5 | 5/5 | 5/5 | 5/5 | 5/5 |
| Hannah Moore | 3/5 | 4/5 | 3/5 | 3/5 | 2/5 | 2/5 |
| Ibrahim Khan | 4/5 | 4/5 | 4/5 | 4/5 | 4/5 | 4/5 |
| Jessica Thomas | 5/5 | 5/5 | 5/5 | 5/5 | 5/5 | 5/5 |
| Kai Roberts | 4/5 | 3/5 | 4/5 | 3/5 | 4/5 | 3/5 |
| Lily Evans | 5/5 | 5/5 | 5/5 | 5/5 | 5/5 | 5/5 |
| Mohammed Ali | 5/5 | 4/5 | 4/5 | 3/5 | 3/5 | 2/5 |
| Niamh O'Brien | 5/5 | 5/5 | 5/5 | 5/5 | 5/5 | 5/5 |
| Oliver Smith | 4/5 | 4/5 | 4/5 | 4/5 | 4/5 | 4/5 |
Step 2: Your Analysis Prompt
Copy this prompt, then paste your data where indicated.
I'm going to share anonymised school attendance data. Please analyse it and identify:
1. Any students showing concerning attendance patterns
2. Day-of-week patterns (are certain days problematic?)
3. Students whose attendance is declining over time
4. Any other patterns worth investigating
Here's the data:
[PASTE DATA HERE]
Please present your findings in a clear summary with specific student names and percentages.
Step 3: Try It Now
Open your preferred AI tool in a new tab
Paste the prompt first, then paste the data where indicated
Send the message and review the AI's analysis
Ready to Master Data Analysis?
This demo showed just one technique. The full Data Detective course includes:
- 12 hands-on sessions with real analysis techniques
- Attendance, assessment, and wellbeing data analysis
- Privacy-first practices for GDPR compliance
- Ready-to-use prompt templates for every scenario