Latihan Nyata · Data

Summarise quiz scores with codes, not names

A teacher wants to see how one class's quiz scores spread and which question was hardest. Build invented scores for 32 students using codes like S01 instead of names, then use AI to summarise the spread and the hardest questions. Done means the summary is correct, no student name ever went into the AI tool, and the teacher still decides final grades.

Difficulty: Easy
Time: About 1.5 hours
Tools: spreadsheet, asisten AI percakapan
Fits: AI Foundations, Educators & Trainers

Learn it first: Student data stays out of the model

What you hand in

An invented 32-row score sheet with student codes and per-question scores for 10 questions.
A spread summary (min, max, mean, median) and the three questions with the lowest average score.
A note that you computed the mean and median with spreadsheet formulas and they match the summary.
A short plan, written by the teacher, to revisit the material behind the two hardest questions.

0 of 4 ticked