ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Learning Engagement Analytics (LEA) - Template User Instructions
2
3
This spreadsheet is the Learning Engagement Analytics (LEA) monitoring template. It is designed to help educators track student
4
engagement across a module, identify students at risk of disengagement, and support timely, evidence-based interventions.
5
The template contains nine sheets, each capturing a specific dimension of student activity:
6
7
• Engagement Metrics - Consolidated engagement summary with scores and warnings per student
8
• Attendance - Weekly attendance record (Week 1-13)
9
• Activity 1 - Weekly quiz completion record
10
• Activity 2 - Secondary formative activity (e.g. problem sets, polls)
11
• Activity 3 & Activity 4 - Additional formative activity tracking sheets
12
• Summative Assessment - Formal assessment grades
13
• Assessment Analytics - Cohort-level performance summary
14
• Warnings - Student alert tracker with weekly flags
15
16
⚠ IMPORTANT: Sample data is fictional. It does not represent real students. Delete it before populating the template with your cohort.
17
18
⚠ Do NOT delete, overwrite, or modify any formula cells. Doing so will break the template and produce incorrect results.
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100