Connect Evaluation Data
Choose how to load your Google Form responses
Auto-Connect (Default)
Loads automatically from the configured Google Sheet on every page open.
Google Sheet Link
Enter any sharable Google Sheet URL to load from a different source.
Upload CSV File
Manually upload an exported CSV file from Google Sheets.
Example: https://docs.google.com/spreadsheets/d/.../edit?usp=sharing
Drop your CSV file here or click to browse
Export from Google Sheets: File → Download → CSV (.csv)
🎯
Link Quiz Scores to Rotations Optional
If your program gives residents quizzes tied to specific rotations, connect them here.
The dashboard will auto-match each quiz to the correct rotation period on every resident's profile so their ITER exam % fills in automatically.
Works with any institution's rotation naming — just tell it which rotation codes to look for.
▶ How the mapping works
- Load quiz scores — each row is one resident, each column is one quiz (Quiz 1, Quiz 2, …). Up to 5 quizzes supported.
- Load the rotation schedule — each row is one resident with 13 blocks for the academic year. Block cells contain whatever rotation codes your program uses (e.g. EM-Main, PICU, Elective).
- Tell us which codes are "core" — quizzes are only auto-assigned to blocks matching these codes. The Nth matching block a resident does receives Quiz N. Consecutive matching blocks form a single ITER period whose exam % is the average of its quizzes.
- Override anytime — per-resident on the profile page via the Map manually button next to the quiz picker, or skip all of this and enter the exam % by hand.
1📚 Quiz & Exam Scores
Paste a Google Sheet URL (shared as "Anyone with the link") or upload a CSV. Each row is one resident, each column is one quiz/exam (Quiz 1, Quiz 2, …). Column labels can be anything — the app matches on "Quiz N" style.
Not loaded yet.
2📅 Rotation Schedule
Year-long rotation matrix — one row per resident, 13 block columns. Used to render the rotation strip on each resident profile and to match quizzes to blocks. Optional if you only want to enter exam % manually.
Not loaded yet.
3🎯 Core Rotation Codes
Which rotation labels in your schedule should receive quizzes? Enter a comma-separated list — partial matches work (e.g. EM-Main matches EM-Main-1). Quizzes are only auto-assigned to blocks whose code matches one of these.
Currently using: —
💡 Examples.
If your schedule uses
EM-Main for in-hospital EM rotations, enter just that.
If you have two in-program codes like EM-Adult and EM-Peds, enter both separated by a comma.
Rotations that don't match (Electives, Research, External, etc.) are skipped — no quiz is auto-assigned to them.
Program Roster
Your program's residents, per academic year. Only residents listed here will be tracked for long-term progress, assessments, and KPI cards. Rotators and external trainees do not need to be in the roster — they remain visible in daily evaluations.
| Name | Level | Specialty | Hospital | Start date | Status | Actions | |
|---|---|---|---|---|---|---|---|
| No residents in this year's roster yet. Use Import from Google Sheet names to pull in your current trainees, or Bulk paste from Excel. | |||||||
💡 Tip: The roster is stored in your account and syncs across your devices. Use the Academic year switcher to view a past year, promote residents to graduated, or start a new intake without losing history.
Assessments
Track every assessment — quizzes, written exams, OSCEs, simulations, case presentations, research, and more. Connect a Google Sheet or upload a CSV.
📄 Assessments Google Sheet
Paste a Google Sheet URL with your assessment results. Two formats work:
• Long format: Resident / Type / Date / Score / Max (one row per result)
• Wide format: Resident + a column per assessment (e.g. Quiz 1 (%), OSCE, Written Exam) — each column becomes an assessment type.
Make sure the sheet is shared with Anyone with the link.
• Long format: Resident / Type / Date / Score / Max (one row per result)
• Wide format: Resident + a column per assessment (e.g. Quiz 1 (%), OSCE, Written Exam) — each column becomes an assessment type.
Make sure the sheet is shared with Anyone with the link.
Tabs:
Leave empty to use whichever tab your URL points to. Enter a comma-separated list of tab names (e.g.
R1, R2, R3, R4, R5) to fetch every level at once. The tab name becomes the resident's level label.
Not loaded yet.
| Resident | Level | Type | Score | % | Notes |
|---|---|---|---|---|---|
| No assessments loaded yet. Connect a Google Sheet or upload a CSV above. | |||||
📝 Sheet format tip: Either long (Resident / Type / Score / Max) or wide (Resident + one column per assessment, e.g.
Quiz 1 Final (%), OSCE, Written Exam). In wide mode, each column header becomes the assessment type and cell values are treated as percentages. When you list tab names above, the dashboard fetches each tab and tags every row with that tab's name as the resident's level. Preset types: Quiz, Written Exam, OSCE, Simulation, Case Presentation, Research, Chart Review, 360 Feedback — but any column name works.
All Residents Overview
Click any row to view detailed profile. Flagged residents have fewer than 5 evaluations in the selected period.
| Resident | Level | Evals | H&PE | Pres/DDx | Activity | Punctuality | Overall | Status |
|---|
Find Resident
Search by name to view evaluations and generate ITER scores
Score Trend Over Time
Track performance trajectory across evaluations
Assessment Progress
Quiz and exam results over time — track trajectory across assessments
Scores mapped from daily evaluations (/10) to ITER 1-4 scale. Knowledge-domain criteria can also use an exam score. Final Score is editable — override any value before auto-fill.
🎓 Exam Score (Knowledge Domain)
📄 Bulk upload CSV
Enter exam %:
%
Applies to criteria: 2, 3, 4, 7, 15, 20, 23
Console Script (Alternative Method)
If bookmarklet doesn't work: Open the ITER form in your browser → F12 → Console → Paste → Enter
Evaluator Comments & Areas for Improvement
Comments are the most valuable part of each evaluation — review carefully before ITER submission.
Batch Export — All Residents ITER Summary
Generate a CSV with ITER scores for every resident in a selected month
Quick ITER Fill
Enter domain percentages to generate an ITER auto-fill — no daily evaluations needed
Clinical
Criteria 1, 5, 6, 8, 9, 14, 16, 17, 18, 19
%
Knowledge
Criteria 2, 3, 4, 7, 15, 20, 23
%
Attitude & Behaviour
Criteria 11, 12, 26
%
Documentation
Criteria 10, 13
%
Punctuality
Criterion 25
%
Attendance
Criterion 21
%
Education
Criteria 22, 24
%
Daily Evaluation (Overall)
Criterion 27
%
≥ 90% → 4 (Exceeds)
≥ 70% → 3 (Meets)
≥ 50% → 2 (Borderline)
< 50% → 1 (Does Not Meet)
PDF ITER Auto-Fill
Upload an ITER PDF form, pick a rating + default comment, and download the filled version
Drop PDF here or click to browse
Works with flat PDFs — detects rating rows automatically
/ 10
This writes plain text in the Program Director box. You are confirming the ITER after review — the dashboard is only a calculator aid.
PDF preview will appear here after upload
Specialty ITER Templates
Build a custom ITER form per specialty. Each criterion maps to one of your 8 score domains and is auto-filled from daily evaluations or a manual domain %.
Select a template on the left to edit, or create a new one.