School scores dataset

Twenty-three fictional test scores of eight students in four courses, in one small CSV file. Public domain, for spreadsheet, statistics and SQL exercises.

DatasetLower secondary +2CC0 1.0

Open the tool School scores (CSV)

What you will learn

Calculate averages per course and per class
Compare groups with a chart or a pivot table

One row per score out of 100. The same data is built into the SQL sandbox as three linked tables (students, courses, scores).

Column	Example
student	Mia Becker
class	10a
course	Mathematics
teacher	Ms Novak
score	92

Facts to check against

8 students in two classes, 4 courses, 23 scores.
Average by class: 10a 85.3, 10b 72.5 (one decimal).
Highest average course: Computer Science, 82.5.

Ideas

Spreadsheets: a pivot table of average score by course and class.
Statistics: the median and range per course, and which course has the widest spread.
SQL: the six "School scores" tasks in the sandbox.

The data is public domain under CC0 1.0: use it however you like.

Downloads

School scores (CSV)CSV · 1 KB

Reuse this material

CC0 1.0

It's in the public domain: use it however you like. A credit with a link is appreciated, not required.

"School scores dataset" by ManyPI (https://manypi.com/edu/school-scores-dataset), licensed under CC0 1.0 (https://creativecommons.org/publicdomain/zero/1.0/)