ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
LCTC Adult Education Outreach Tracker
2
Companion to the Copy-and-Paste Message Library (LCTC_AE_Message_Library_NOV2026). Message numbers match the document.
3
4
How to use
5
1. Go to the Outreach Log. Add one row each time you contact a student, partner, or referral.
6
2. Pick the message number (for example A1 or D2). The stage and situation fill in on their own, and the row takes the stage color.
7
3. Pick the channel (email, text, Remind, phone, or in person) and the outcome. Set a follow-up date if you need one.
8
4. The Follow-up status column shows Overdue, Due today, Upcoming, or Done. Filter that column each morning to see who needs a call.
9
5. The Summary sheet counts contacts by stage, channel, and outcome. Use it for staff meetings and reports.
10
11
Good to know
12
Use a student ID or initials, not full names, unless your college says otherwise. Do not enter scores, test results, or private details in Notes.
13
Keep this file where your college says student contact records belong. A shared drive with open access is not a good place for student information.
14
The log has room for 500 rows. To add more, copy the formulas in columns D, E, and J down.
15
Data lists for the dropdowns are on the Lists sheet. You can edit the channel and outcome lists to match your program. Outcomes listed in the "closes the follow-up" column mark a follow-up Done.
16
The Message List sheet is a searchable index of all messages in the document.
17
This workbook uses simple formulas and dropdowns, so it works in Excel and in Google Sheets.
18
19
Draft, November 2026. Questions or ideas: adulteducation@lctcs.edu
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