Grade Records
This dataset provides detailed academic performance records for students, including individual course grades, GPA calculations, credit information, and academic standing per term. It is ideal for tracking student progress, analyzing academic trends, and supporting institutional reporting and interventions.
Sample rows
preview · 8 of 200 rows · all 16 columns| record_idstring | academic_standingstring | gpa_cumulativefloat | gradestring | student_idstring | student_first_namestring | student_last_namestring | date_of_birthdate | course_idstring | course_namestring | course_codestring | course_creditsfloat | semesterstring | grade_pointsfloat | gpa_termfloat | record_datedate |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| REC1001 | Honors | 3.92 | A | S00001 | Emily | Garcia | 2002-03-25 | C10001 | Calculus I | MATH101 | 4 | Fall 2023 | 4 | 3.95 | 2023-12-20 |
| REC1002 | Good Standing | 3.18 | B+ | S00002 | Jamal | ONeil | 2001-05-18 | C10002 | Introduction to Psychology | PSYC101 | 3 | Spring 2024 | 3.3 | 3.25 | 2024-05-25 |
| REC1003 | Honors | 3.68 | A- | S00003 | Priya | Singh | 2000-11-02 | C10003 | Organic Chemistry | CHEM202 | 4 | Fall 2022 | 3.7 | 3.72 | 2022-12-22 |
| REC1004 | Probation | 2.15 | C | S00004 | Lukas | Mueller | 1999-07-10 | C10004 | College Algebra | MATH105 | 3 | Summer 2023 | 2 | 2.1 | 2023-08-15 |
| REC1005 | Honors | 3.93 | A | S00005 | Rita | Patel | 2003-02-28 | C10005 | English Composition | ENGL102 | 3 | Spring 2023 | 4 | 3.97 | 2023-05-27 |
| REC1006 | Suspended | 1.5 | D | S00006 | Wei | Chen | 2000-09-15 | C10006 | Introduction to Biology | BIOL101 | 3 | Fall 2022 | 1 | 1.25 | 2022-12-19 |
| REC1007 | Honors | 3.79 | A | S00007 | Chloe | Nguyen | 2004-04-07 | C10007 | Physics II | PHYS202 | 4 | Spring 2024 | 4 | 3.87 | 2024-05-24 |
| REC1008 | Good Standing | 3.05 | B | S00008 | Sofia | Torres | 2002-08-22 | C10008 | World History | HIST101 | 3 | Summer 2022 | 3 | 3.12 | 2022-08-22 |
| REC1009 | Probation | 2.54 | NP | S00009 | Fatima | Khan | 2005-01-03 | C10009 | Environmental Science | ENVS201 | 2 | Fall 2021 | 0 | 2.35 | 2021-12-17 |
| REC1010 | Good Standing | 2.92 | P | S00010 | Max | Davis | 2003-05-29 | C10010 | Art Appreciation | ARTS101 | 1 | Spring 2023 | 0 | 2.85 | 2023-05-29 |
| REC1011 | Probation | 2.12 | C- | S00011 | Grace | Kim | 1998-10-12 | C10011 | Business Law | BUSN301 | 3 | Summer 2022 | 1.7 | 2.05 | 2022-08-20 |
| REC1012 | Probation | 2.48 | C+ | S00012 | Nathan | Lee | blank | C10012 | Lab Safety | CHEM100 | 0.5 | Fall 2023 | 2.3 | 2.4 | 2023-12-21 |
| REC1013 | Dismissed | 1.21 | F | S00013 | Mia | Taylor | 1997-12-14 | C10013 | Remedial Math | MATH050 | 2 | Spring 2021 | 0 | 1.1 | 2021-05-31 |
| REC1014 | Good Standing | 2.82 | C+ | S00014 | John | Smith | 1995-06-30 | C10014 | Continuing Ed: Business Writing | BUSN310 | 2 | Fall 2022 | 2.3 | 2.75 | 2022-12-18 |
| REC1015 | Good Standing | 3.39 | B+ | S00015 | Rosa | Martinez | 2001-02-17 | C10015 | Statistics | STAT101 | 3 | Fall 2023 | 3.3 | 3.44 | 2023-12-23 |
| REC1016 | Honors | 3.93 | A- | S00001 | Emily | Garcia | 2002-03-25 | C10016 | Advanced English | ENGL203 | 3 | Spring 2024 | 3.7 | 3.91 | 2024-05-28 |
| REC1017 | Good Standing | 3.09 | B | S00016 | Derek | Harris | 2000-07-19 | C10017 | Intro to Philosophy | PHIL101 | 3 | Summer 2023 | 3 | 3.12 | 2023-08-18 |
| REC1018 | Honors | 3.77 | A | S00017 | Anna | Peterson | 2004-11-22 | C10018 | Intro to Programming | CS101 | 4 | Spring 2024 | 4 | 3.83 | 2024-05-26 |
| REC1019 | Good Standing | 3.22 | B | S00018 | Samuel | White | 2002-02-10 | C10019 | Economics Principles | ECON101 | 3 | Fall 2022 | 3 | 3.28 | 2022-12-16 |
| REC1020 | Honors | 3.58 | A- | S00019 | Leah | Johnson | 2002-10-24 | C10020 | Modern Poetry | ENGL210 | 2 | Summer 2022 | 3.7 | 3.62 | 2022-08-19 |
What the 200 rows show
from the 200-row sampleHonors (academic standing) stands out: mean gpa_
- 3.2median gpa_
cumulative - 11semesters
- 3.0median course_
credits - 3.0median grade_
points - 3.1median gpa_
term
Median 3.2, from 1.2 to 4.0.
- string 10
- float 4
- date 2
Columns
16 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 10 columns | |||
record_id | string | Unique identifier for each grade record entryunique | REC1001 |
student_id | string | Unique identifier for the student | S00001 |
student_first_name | string | Student's first name | Emily |
student_last_name | string | Student's last name | Garcia |
course_id | string | Unique identifier for the course | C10001 |
course_name | string | Name of the course | Calculus I |
course_code | string | Official code for the course | MATH101 |
semester | string | Semester in which the course was taken (e.g., Fall 2023)11 semesters | Fall 2023 |
grade | string | Letter grade received for the course15 values | A |
academic_standing | string | Student's academic standing for the termGood Standing · Probation · Suspended · Dismissed · Honors | Honors |
| Numbers 4 columns | |||
course_credits | float | Number of credits awarded for the course0 or more | 4 |
grade_points | float | Numeric grade points earned for the course (e.g., 4.0 for A)0 to 4 | 4 |
gpa_term | float | Student's GPA for the semester/term0 to 4 | 3.95 |
gpa_cumulative | float | Student's cumulative GPA up to this term0 to 4 | 3.92 |
| Dates and times 2 columns | |||
date_of_birth | date | Student's date of birthoptional | 2002-03-25 |
record_date | date | Date the grade record was entered or updated | 2023-12-20 |
Use it for
An education dashboard
Gpa_
cumulative by academic_ standing and a breakdown of grade. Excel, Power BI or Tableau. Why do the 62 Honors rows have a mean gpa_
cumulative of 3.8? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Records200REC10013.92HonorsREC10023.18Good Sta…REC10033.68Honors
A software demo
Believable records with student_
id, student_ first_ name and student_ last_ name to fill a screen in front of a buyer.
blueprint · grade-records
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 16 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Grade scale: A-F or 0-100 percentage
- Credit hours earned for passing grades
- GPA calculated weighted by credit hours
- Academic standing: good, probation, suspension
- Semester/term grades roll up to cumulative
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- grade-records