We would like to report on completions of activities sorted by date. The current activity report does not allow this as the only date available is last login.
We propose the following changes:
Row: Student ID
Columns: Activity 1, Date of Activity 1, Activity 2, Date of Activity 2, ..., Activity N, Date of Activity N
In this structure, for each activity column, there would be a corresponding date column indicating when that activity was completed.
Student ID: Unique identifier for the student
Activity: The specific activity
Date of Completion: The date when the activity was completed
Student ID |
Activity |
Date of Completion |
12345 |
Activity 1 |
2023-01-15 |
12345 |
Activity 2 |
2023-01-18 |
67890 |
Activity 1 |
2023-01-16 |
... |
... |
... |