StudenT Report Card.
Demographics, Attendance, Classes + Grades and Behavior.
Report Card for Students with a simple select student dropdown. Making Generating report cards as easy as a microwave meal
SASID
FirstName
LastSurname
MiddleName
Gender
Hispanic/ Latino
AmericanIndianAlaskaNative
Asian
BlackOrAfricanAmerican
White
NativeHawaiianOrOtherPacificIslander
Demographics ( IC )
Attendance (IC)
SASID
TotalDaysAttended
TotalDaysExcused
TotalDaysUnexcused
TotalPossibleAttendanceDays
Behaviour IC
Handwritten notes !
We love a good old-school data capture
Assessment Data
StudentID
StudentLastName
StudentFirstName
StudentMI
SchoolName
Grade
TestRITScore
NWEA
Primary ID - Student ID (District ID)
Student Last Name
Student First Name
Student Middle Name
School Name
Enrollment Grade
Composite Level
Composite Score
Composite - National Norm Percentile
Benchmark Period
DIBELS
To get started you are going to first need to aggregate all the Primary Keys from the various platforms into one table
Next for attendance your gona need some math helper columns.
Attendance Rate = (TotalDaysAttended / TotalPossibleAttendanceDays)
For our Assessment Data we will need a few things
For Dibels
We get the data user friendly here. Each term reports assessment data by “Benchmark Period”. This means we pull our data based on the variables within the Benchmark column [ BOY , MOY , EOY ]
We then use “Composite Score” as our main Assessment Data
While “Composite - National Norm Percentile” and “Composite level” help us draw quick insights at a glance.
For NWEA
This is not as friendly and requires a new export for each Assessment Period. No Problem though because we know how to cook using all kinds of ingredients regardless of how we get them we can always add them in somehow. We simply just pull “Test RIT Score” from all 3 sheets into a master sheet.
Instructions
Reach out to me directly if you are interested in Automating your Report Card Systems or having trouble aggregating the infinite platforms which don’t talk to each other haha
*These do not give a full picture of the complexity of the formulas used to pull things such as “Grade averages” or the Conditional formatting used to indicated at a glance insights