Module 4 Activity: Build an Analysis Table

Estimated active time: 60-75 minutes

Task

Use a fictional learner activity table to create an analysis table for active learners with low recent practice time.

Steps

1. Select the columns needed for the question.
2. Filter rows to active enrolments.
3. Filter to records with recent practice minutes below a chosen threshold.
4. Sort from lowest practice time to highest.
5. Create a derived column called practice_hours.
6. Create a conditional column called practice_band.
7. Write the rule behind each derived column.
8. Save the analysis table to an output path.
9. Write a short limitation note.

Deliverable

• Filtered and sorted analysis table.
• Derived-column rule sheet.
• Limitation note.

Quality bar

The activity is ready when each new column has a plain-English rule and the filter can be explained without reading the code.