Fieldnote Learning Centre: Gradebook with an impossible score and a missing one
Gradebook with an impossible score and a missing one for Fieldnote Learning Centre. The same 18 results as gradebook-export.csv with two cells changed. ENR-06 carries a score of 104 where the max_score column on the same row declares 100. ENR-12's score cell is empty while its passed column still reads true and its grade_band still reads distinction, so the file asserts a distinction it holds no score for.
course_id,course_name,enrollment_id,learner_id,learner_name,score,max_score,pass_score,completed,passed,grade_band
COURSE-1,Spreadsheet basics,ENR-01,LEARN-01,Sample learner 1,55,100,70,true,false,fail
COURSE-1,Spreadsheet basics,ENR-04,LEARN-04,Sample learner 4,76,100,70,true,true,pass
COURSE-1,Spreadsheet basics,ENR-07,LEARN-07,Sample learner 7,97,100,70,true,true,distinction
COURSE-1,Spreadsheet basics,ENR-10,LEARN-10,Sample learner 10,72,100,70,true,true,pass
COURSE-1,Spreadsheet basics,ENR-15,LEARN-03,Sample learner 3,61,100,70,true,false,fail
COURSE-1,Spreadsheet basics,ENR-18,LEARN-06,Sample learner 6,82,100,70,false,false,incomplete
COURSE-2,Customer service,ENR-02,LEARN-02,Sample learner 2,62,100,70,true,false,fail
COURSE-2,Customer service,ENR-05,LEARN-05,Sample learner 5,83,100,70,true,true,merit
COURSE-2,Customer service,ENR-08,LEARN-08,Sample learner 8,58,100,70,true,false,fail
COURSE-2,Customer service,ENR-11,LEARN-11,Sample learner 11,79,100,70,true,true,pass
COURSE-2,Customer service,ENR-13,LEARN-01,Sample learner 1,93,100,70,true,true,distinction
COURSE-2,Customer service,ENR-16,LEARN-04,Sample learner 4,68,100,70,false,false,incomplete
COURSE-3,Workshop safety orientation,ENR-03,LEARN-03,Sample learner 3,69,100,70,true,false,fail
COURSE-3,Workshop safety orientation,ENR-06,LEARN-06,Sample learner 6,104,100,70,true,true,distinction
COURSE-3,Workshop safety orientation,ENR-09,LEARN-09,Sample learner 9,65,100,70,true,false,fail
COURSE-3,Workshop safety orientation,ENR-12,LEARN-12,Sample learner 12,,100,70,true,true,merit
COURSE-3,Workshop safety orientation,ENR-14,LEARN-02,Sample learner 2,100,100,70,true,true,distinction
COURSE-3,Workshop safety orientation,ENR-17,LEARN-05,Sample learner 5,75,100,70,false,false,incomplete
Specifications
- Document Set
- education
- Industry
- education
- Source Kit
- education-training
- Synthetic
- true
- As Of
- 2026-09-08
- Rows
- 18
- Max Score
- 100
- Out Of Range Score
- 104
- Out Of Range Enrolment
- ENR-06
- Missing Score Enrolment
- ENR-12
- Intentionally Invalid
- true
Testing contract
Expected to fail- Scenario
- Validate every score against the max_score on its own row, then re-derive the pass flag from the score column.
- Expected result
- ENR-06 fails the range check by 4 points against its own declared maximum of 100. ENR-12 fails the derivation: an empty score coerced to 0 gives a fail, which contradicts the passed and grade_band columns on the same row. A reader that coerces blanks to zero silently turns a distinction into a fail and reports 8 passes instead of 9.
What is a .csv file?
CSV (Comma-Separated Values) is a plain-text tabular format where rows are lines and fields are separated by commas, with quoting rules for values that contain delimiters, quotes, or newlines. It has no formal type system and depends on encoding and dialect conventions. It is the most portable format for tabular data exchange.
How to use this file
Use an example CSV to test parsers against quoting and embedded-delimiter edge cases, header handling, encoding detection, and import pipelines into databases or spreadsheets.
How to use this file for testing
“Fieldnote Learning Centre: Gradebook with an impossible score and a missing one” is a deterministic Testaroo fixture for Data import, Error handling. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 18 rows. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.
Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such, expect parsers to fail loudly rather than silently accept them.
Data fixtures document their exact quirks (delimiters, encodings, null handling, schema, and row counts) in the spec table. Point your parser or importer at the file and assert it handles the documented edge cases; clean and deliberately-messy siblings make before/after diffs straightforward.
Code examples
import pandas as pd
df = pd.read_csv("gradebook-export-score-out-of-range.csv")
print(df.head())
print(df.dtypes)Generated by generation/industry_documents.py. Free for any use, no attribution required, license.
Related files
- csvFieldnote Learning Centre: Invoice register where a bursary exceeds the fee it is set againstInvoice register where a bursary exceeds the fee it is set against for Fieldnote Learning Centre. The same 18 invoices, except that the award on ENR-03 was entered as 350.00 against a 225.00 fee. net_payable on that row reads -125.00, a negative amount, and the net column totals 4205.00 instead of 4442.50. The award is 125.00 larger than the fee it can be applied to.
- xmlAlder Books Reconciliation: camt.053 whose entry count does not match its entriescamt.053 whose entry count does not match its entries for Alder Books Reconciliation. Well-formed XML with the same header, balances and TxsSummry as bank-statement-camt053.xml, but the final Ntry, TXN-024 for 206.00 on 2026-08-24, has been dropped. NbOfNtries still declares 24 while only 23 Ntry elements are present, and the entries now sum to 10442.00 against a CLBD balance of 10236.00.
- txtAlder Books Reconciliation: Fixed-width GL feed with one record a byte shortFixed-width GL feed with one record a byte short for Alder Books Reconciliation. The same 66 records as gl-feed-fixed-width.txt except that record 5 is 119 characters instead of 120: the final character of the 4-character currency field has been lost. Every other record is correct, so a reader that splits on newlines and slices by position reads USD as US on that one record and carries on silently.
- jsonAlder Books Reconciliation: Intentionally invalid semantic test recordsIntentionally invalid semantic test records for Alder Books Reconciliation. Three independent cases report duplicate-primary-key, schema-type and foreign-key errors. JSON syntax remains valid.
- csvAlder Books Reconciliation: Journal batch with one entry out by 45.00Journal batch with one entry out by 45.00 for Alder Books Reconciliation. The same 3 journals as journal-batch.csv except that line 2 of JB-2026-08-02 credits 19.50 where its debit line is 64.50. That one journal is out by 45.00; the other two balance exactly, which is what makes this the realistic case: a batch-level check catches it only because nothing else offsets it.
- txtAlder Books Reconciliation: MT940 whose :62F: closing balance is out by 100.00MT940 whose :62F: closing balance is out by 100.00 for Alder Books Reconciliation. Identical to bank-statement-mt940.txt in every tag except :62F: and :64:, which state C260824USD10336,00 where the 24 :61: movements applied to the :60F: opening balance give C260824USD10236,00. The file is out by exactly 100.00 and nothing inside the statement explains the difference.
