Student Database (Roster)
Set up your class list, learner IDs, and assignment deadlines once — then reuse your cohort effortlessly across every BTEC unit you assess.
- Master Class Roster: Register learner names, candidate IDs, and groups once; reuse across every unit in your Pearson scheme of work.
- Instant Bulk Importer: Paste directly from Excel, Google Sheets, or school MIS (SIMS, iSAMS, PowerSchool) in under two seconds.
- Intelligent File Auto-Matching: Uploaded Word (
.docx) and PDF files map automatically to student records via fuzzy name matching.
Why roster setup comes first
In BTEC assessment, consistency of student tracking across multiple units is critical. Your Student Database (Roster) serves as the master record for your class. Once your students are registered in checkb.tech, their names, candidate IDs, submission history, and feedback trails stay synchronised whether you are assessing Level 2 Unit 1, Level 3 Unit 2, or an optional specialty unit.
The screen, in 15 seconds
The Student Database view provides high-density cohort management:
Importing from CSV, Excel, or Word
You do not need to type student names one by one. The Import Roster Modal accepts pasted text directly from spreadsheet software (Microsoft Excel, Google Sheets), school MIS systems (SIMS, iSAMS, PowerSchool), or table exports from Word:
- Open the Import Modal: Click the Import Roster button in the Batch View or Student Database header.
- Copy & Paste your class table: Highlight your student column(s) in Excel or your MIS and paste into the text box. The importer accepts standard formats:
First Name, Last Name, Student ID"Last Name, First Name", ID(e.g.Hayes, Tyler, 9042)- Single column list of full names (one per line)
- Preview and confirm: checkb.tech parses the columns and shows a clean preview grid with row counts. Click Confirm Import to populate the batch in under two seconds.
Automatic file linking & naming best practices
When your cohort is established in the database, file upload becomes a simple drag-and-drop operation. checkb.tech uses intelligent fuzzy matching to assign uploaded files to the right student:
| Uploaded Filename | Matched Roster Student | Detection Logic |
|---|---|---|
Tyler_Hayes_Unit1_Activity1.docx | Tyler Hayes | Matches first name + middle name token with high confidence. |
Vance, Chloe_BTEC_Unit1_Report.pdf | Chloe Vance | Matches "Last, First" naming convention extracted from school LMS. |
9048_Bennett_Liam_Activity2.docx | Liam Bennett (ID #9048) | Exact match on candidate ID prefix + surname. |
Unit1.docx or Assignment.pdf cannot be auto-assigned. In such cases, checkb.tech prompts you with a quick dropdown selector in the upload tray to link the file manually to the appropriate learner in one click.Grouping & submission deadlines
Managing multiple sets or tracking first submissions versus authorized resubmissions is built directly into batch settings:
Reusing cohorts across Level 2 & 3 units
In BTEC programmes, a single cohort often progresses through multiple units across the academic year (for example, Level 2 Award Units 1 and 2, or Level 3 Extended Diploma Units 1, 2, 3, 4, and 8).
When creating a new batch for Unit 2, simply select Copy Roster from Existing Batch in the creation modal. The entire student database—including names, candidate numbers, and group tags—is duplicated into the new unit workspace without altering your historical Unit 1 feedback or moderation records.
Internal Verification (IV) sampling prep
Pearson BTEC International regulations mandate that Lead Internal Verifiers sample assessor judgements across a balanced cohort distribution. The Roster lens makes sampling selection straightforward:
| Sampling Category | Pearson IV Requirement | How checkb.tech facilitates selection |
|---|---|---|
| Full Grade Range | Samples must include Pass, Merit, Distinction, and Unachieved/Borderline submissions. | Filter by criteria achievement status to instantly select representative candidates across all tiers. |
| Borderline Scripts | Submissions with partly met criteria or marginal distinction evidence require verification. | Students with active or resolved <StatusPill status="partly" /> flags are flagged with amber chips. |
| Multi-Assessor Standardisation | Ensure consistent application of command verbs across different teaching staff. | Export verification sheets showing exact assessor decisions and timestamps for team standardisation meetings. |