Fieldnote Learning Centre: Gradebook export, one row per result
Gradebook export, one row per result for Fieldnote Learning Centre. 18 results grouped by course, 6 per course. Scores run from 55 to 100 against a maximum of 100 and a pass score of 70. grade_band is derived from score and completion: 6 fail, 3 pass, 2 merit, 4 distinction and 3 incomplete. An incomplete enrolment gets no band even when its score would earn one.
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,90,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,86,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
- Pass Score
- 70
- Distinctions
- 4
- Incomplete
- 3
- Encoding
- UTF-8
Testing contract
Expected to pass- Scenario
- Import the gradebook and re-derive the band from score and completion.
- Expected result
- All 18 bands re-derive exactly. The 3 incomplete rows carry the incomplete band and passed false, two of them with scores of 75 and 82 that are above the pass mark. The banded passes total 9, matching the passed column.
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 export, one row per result” is a deterministic Testaroo fixture for Data import. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 18 rows · UTF-8. 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.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: Attendance summary by courseAttendance summary by course for Fieldnote Learning Centre. 3 courses and a TOTAL row. Attendance is uneven: 66.67 percent on Spreadsheet basics, 83.33 on Customer service and 100.00 on Workshop safety orientation, 83.33 overall. session_slots is enrolments times 2 on every row and sessions_attended plus absences equals it.
- csvFieldnote Learning Centre: Bursary award registerBursary award register for Fieldnote Learning Centre. 4 awards worth 807.50. Three are a percentage of the fee and apply to every enrolment the learner holds; one is a fixed 120.00 award and applies to that learner's earliest enrolment only, capped at the fee. award_value is a rate for a percentage award and an amount for a fixed one, which is why the column mixes 0.5000 with 120.00.
- csvFieldnote Learning Centre: Certificate eligibility with three conditionsCertificate eligibility with three conditions for Fieldnote Learning Centre. All 18 enrolments tested against three conditions: the enrolment is complete, the score reaches the pass mark, and both sessions were attended. 7 are eligible. 9 enrolments passed, so 2 passing learners are still ineligible on attendance alone: ENR-04 and ENR-11, each of whom attended 1 of 2 sessions. Every ineligible row names its reasons.
- csvFieldnote Learning Centre: Course capacity and outcome reportCourse capacity and outcome report for Fieldnote Learning Centre. 3 courses, each seating 10 and holding 6 enrolments, so every course is at 60.00 percent with 4 seats free. pass_rate_of_completed divides passes by completions, not by enrolments, which is why COURSE-1 reports 60.00 percent from 3 passes out of 5 completions rather than out of 6 enrolments.
- csvFieldnote Learning Centre: Course catalogue with materialsCourse catalogue with materials for Fieldnote Learning Centre. 3 courses with their fee, capacity, pass score and the exercise material attached to each. material_characters is the exact length of the markdown exercise held against the course in the operating model, from 197 to 253 characters, so a content-length assertion has a real number to check.
- csvFieldnote Learning Centre: Course fee scheduleCourse fee schedule for Fieldnote Learning Centre. 3 courses with the fee broken into tuition, materials and a flat 25.00 registration charge. The three components add up to total_fee on every row: 300.00, 350.00 and 225.00. Every course runs 2 sessions, seats 10 and passes at 70.
