Exercise: Sorting, Filtering, and Tabulating Data

You are given the following dataset of students:

Tasks

Sorting

(a) Sort the students by Score in descending order.

(b) Sort the students first by Class (SS1 before SS2), and then by Name alphabetically.

Filtering

(a) Show only Female students.

(b) Show students who scored above 70.

Tabulating

(a) Create a summary table showing the number of students per class.

(b) Create a summary table showing the average score by gender.

Answers

1. Sorting

(a) Sorted by Score (Descending):

(b) Sorted by Class then Name:

2. Filtering

(a) Female students:

(b) Students with scores above 70:

3. Tabulating

(a) Number of students per class:

(b) Average score by gender:

M4:S3 - Exercise: Sorting, Filtering and Tabulating Data

Sorting, Filtering, and Tabulating Data