lesson
30 min

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.

SkillBeginningDevelopingProficient
Judges an AI answerAccepts it without checkingChecks one fact when askedChecks facts on their own and explains when not to use the tool
Writes a clear promptPrompt is vaguePrompt has a task and some contextPrompt 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)
Run the code. Then add a fifth made-up student who came to 6 sessions and predict the new average before you run it again. The 80% line is an example. Use the definition in your own contract.
Python 3
Ctrl+Enter to run | Tab to indent | Python runs in your browser via Pyodide

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 done

Ask. Answer. Build together.