Classroom Tracker

Welcome! To get started, connect your Google Sheet.

Step 1 - Create your Google Sheet

Create a new Google Sheet and add two tabs named passes and config. Then share it with:

classroom-tracker@classroom-tracker-499621.iam.gserviceaccount.com

Step 2 - Paste your Sheet ID

The Sheet ID is the long string in your Sheet's URL between /d/ and /edit

Classroom Tracker

Track attendance, tardies, and hall passes. How many classes do you teach?

Number of classes

Not clocked in Present Absent Tardy Bathroom Water Other Note Alert 🔔 = watched

Tap a student to update status

Random picker

Groups:

Student kiosk

Set which class is active on the kiosk screen

Kiosk shows: not set

Max students out at once: 2 — change in Settings ⚙ → Alert thresholds

Today's log

No activity yet

Student Search

History

No history yet

Event Hours

Track hours for events like bake sales or fundraisers. Students add their own name once, then tap their card to clock in and out.

Student kiosk

Show this event on the kiosk screen

Kiosk shows: not set

Recent activity

No activity yet

Settings

Google Sheet connection

Connected Sheet ID:

Student report (CSV)

Per-student summary: attendance, tardies, passes, watch list.

From

To

Alert thresholds

Auto-flag after this many bathroom passes:

5 passes

Over this many days:

7 days

Out-too-long alert:

7 min

Max students out at once (kiosk):

1

Add a class

For a new section added mid-year, or a quick "test class" to demo a feature without touching real rosters.

Name

Update rosters

Note library

Other destinations

Pass data archive

Moves pass history older than 60 days into a separate "passes_archive" tab in your Sheet, so the live sheet and this page stay fast. Archived passes stay searchable under Student Search.

Danger zone