At Risk Indicator for Failing Students
( Using only IC Data )
Students failing 3 or more Classes
A simple tool to help instantly identity and confirm which students are at risk for failing classes segregated by Grade level. This works great as an example of something rare cooked while the “Student profile” is more medium rare.
Both can be used together on the same File to create a powerful tool for data driven decision making.
student.personID
student.firstName
student.lastName
student.grade
+ Number of failing classes ( helper column )
Attendance (IC)
student.personID
Grade
CourseTeacher
customSection.semesterCode
Assessment Data(IC)
This one is a super simple 2 ingrediant 2 formula recipe.
Lets start by making our helper column add up the total # of failing classes.
We will call that “Number of failing classes”
Formula
=COUNTIFS(
“Grade Data Sheet”!A:A, $A2,
“Grade Data Sheet” !D:D, "<70")
Note : <70 means any student with a grade for a class that is less than 70 will count as 1 failed class
Next we want to pull that data into a table for us to see. This is the visualization of the data
Formula
=SORT( FILTER(
{“Attendance Data Sheet”!I:I,“Attendance Data Sheet”!B:B,“Attendance Data Sheet”!C:C,'“Attendance Data Sheet”!A:A},
“Attendance Data Sheet”!D:D = $B$2,
“Attendance Data Sheet”!I:I >= 3 ), 1, FALSE)
Instructions
PRe MAde Spredsheet link
(Coming 2026 )
Reach out to me directly if you are interested in Automating your Infinite Campus Workflows!
This is a complete Build thats uses data which already exists in larger Models like the Student Profile to help admin catch up to teachers who are seeing this raw data live.