Module 6 Activity: Build a Summary Gallery

Estimated active time: 90 minutes

Task

Create several summary tables from a fictional learner activity dataset.

Steps

1. Create a summary by course.
2. Create a summary by course and week.
3. Use named aggregations for readable column names.
4. Add a group-level average with transform.
5. Create a pivot table with course as rows and week as columns.
6. Create a crosstab for level by status.
7. Reshape a wide weekly table into long form.
8. Write the grain for every output table.

Deliverable

• Summary notebook or worksheet.
• Summary table gallery.
• Grain explanation note.

Quality bar

The activity is ready when every table has a clear row meaning and readable column names.