Fieldnote Learning Centre: Certificate eligibility with three conditions
Certificate 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.
enrollment_id,learner_id,learner_name,course_id,completed,passed,sessions_attended,sessions_required,certificate_eligible,reason_if_not_eligible
ENR-01,LEARN-01,Sample learner 1,COURSE-1,true,false,1,2,false,score below the pass mark or enrolment incomplete; attended 1 of 2 required sessions
ENR-02,LEARN-02,Sample learner 2,COURSE-2,true,false,2,2,false,score below the pass mark or enrolment incomplete
ENR-03,LEARN-03,Sample learner 3,COURSE-3,true,false,2,2,false,score below the pass mark or enrolment incomplete
ENR-04,LEARN-04,Sample learner 4,COURSE-1,true,true,1,2,false,attended 1 of 2 required sessions
ENR-05,LEARN-05,Sample learner 5,COURSE-2,true,true,2,2,true,
ENR-06,LEARN-06,Sample learner 6,COURSE-3,true,true,2,2,true,
ENR-07,LEARN-07,Sample learner 7,COURSE-1,true,true,2,2,true,
ENR-08,LEARN-08,Sample learner 8,COURSE-2,true,false,1,2,false,score below the pass mark or enrolment incomplete; attended 1 of 2 required sessions
ENR-09,LEARN-09,Sample learner 9,COURSE-3,true,false,2,2,false,score below the pass mark or enrolment incomplete
ENR-10,LEARN-10,Sample learner 10,COURSE-1,true,true,2,2,true,
ENR-11,LEARN-11,Sample learner 11,COURSE-2,true,true,1,2,false,attended 1 of 2 required sessions
ENR-12,LEARN-12,Sample learner 12,COURSE-3,true,true,2,2,true,
ENR-13,LEARN-01,Sample learner 1,COURSE-2,true,true,2,2,true,
ENR-14,LEARN-02,Sample learner 2,COURSE-3,true,true,2,2,true,
ENR-15,LEARN-03,Sample learner 3,COURSE-1,true,false,1,2,false,score below the pass mark or enrolment incomplete; attended 1 of 2 required sessions
ENR-16,LEARN-04,Sample learner 4,COURSE-2,false,false,2,2,false,enrolment not complete; score below the pass mark or enrolment incomplete
ENR-17,LEARN-05,Sample learner 5,COURSE-3,false,false,2,2,false,enrolment not complete; score below the pass mark or enrolment incomplete
ENR-18,LEARN-06,Sample learner 6,COURSE-1,false,false,1,2,false,enrolment not complete; score below the pass mark or enrolment incomplete; attended 1 of 2 required sessions
Specifications
- Document Set
- education
- Industry
- education
- Source Kit
- education-training
- Synthetic
- true
- As Of
- 2026-09-08
- Rows
- 18
- Eligible
- 7
- Passed
- 9
- Blocked On Attendance
- 2
- Encoding
- UTF-8
Testing contract
Expected to pass- Scenario
- Apply all three conditions and compare the eligible count with the pass count.
- Expected result
- 7 rows are eligible, not the 9 that passed. The difference is exactly ENR-04 and ENR-11, which carry passed true, sessions_attended 1 and a reason naming the shortfall. Treating a pass as a certificate would issue 2 certificates the attendance record does not support.
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: Certificate eligibility with three conditions” 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("certificate-eligibility.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: 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.
- jsonFieldnote Learning Centre: Education reconciliation assertionsEducation reconciliation assertions for Fieldnote Learning Centre. The six identities this set claims with the figure each must produce: 5250.00 of gross fees, 4442.50 net of bursary, 9 passes, 7 certificates, 18 results in both gradebook shapes and 2600.00 of scheduled instalments. It also records both deliberate defects and their exact size.
