Tracking Attendance and Skills
Simple templates for attendance and skills, plus a short Python routine to calculate attendance rates.
What you will be able to do
By the end of this lesson, you can set up an attendance log and a skills rubric, and calculate attendance rates from them.
An attendance log template
Use a spreadsheet your program approves and keeps access-limited. One row per student, one column per session. Use student ID codes in shared files instead of full names when you can.
student_id, s1, s2, s3, s4, s5, s6, s7, s8, s9, s10
A01, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1
A02, 1, 0, 1, 1, 0, 1, 1, 0, 1, 1
A03, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
1 means present, 0 means absent. Add a notes column only if your program allows it, and keep notes factual.
A skills rubric template
Write three or four levels for each course goal. Describe what a student does at each level.
| Skill | Beginning | Developing | Proficient |
|---|---|---|---|
| Judges an AI answer | Accepts it without checking | Checks one fact when asked | Checks facts on their own and explains when not to use the tool |
| Writes a clear prompt | Prompt is vague | Prompt has a task and some context | Prompt has role, task, context, and format |
Rate students at the start, middle, and end. Two staff rating the same work should land on the same level. If they do not, sharpen the words.
Calculate attendance rates
This Python runs in your browser. The first run downloads the Python runtime (several MB), so use Wi-Fi if you can. The names are made up. Never put real student names into code you share.
attendance = {"Student A": 9, "Student B": 7, "Student C": 10, "Student D": 4}
sessions = 10
total = 0
regular = 0
for name, days in attendance.items():
rate = days * 100 / sessions
total = total + rate
if rate >= 80:
regular = regular + 1
print(name, str(round(rate)) + "%")
print("Average:", str(round(total / len(attendance))) + "%")
print("Attended 80% or more:", regular)
A spreadsheet formula can do the same work. The point is the same either way: know how the number is calculated, so you can explain it.
The judgment angle
Look at the student behind the number. Student D came to 4 of 10 sessions. That is a reason to call the family with care, not a reason to drop the student. Never paste attendance or rubric data into an AI tool to summarize it.
Tracking setup
0 of 6 doneDiscussion
Ask. Answer. Build together.
Loading…