Student Profile ( Using only IC Data )
Demographics, Attendance, Classes + Grades and Behavior
Report Card for Students with a simple select student dropdown. This is just like the “Student Report Card” with one difference.. All this data comes from ONCE SOURCE
INFINITE CAMPUS.
student.personID
student.firstName
student.lastName
student.middleName
student.gender student.hispanicEthnicity fedRace.americanIndian
fedRace.asian fedRace.blackOrAfricanAmerican fedRace.white
fedRace.pacificIslander fedRace.multiracial
Demographics (IC)
student.personID
student.firstName
student.lastName
student.grade
attChronicAbsenteeism.scheduledDays
attChronicAbsenteeism.daysAbsent
attChronicAbsenteeism.absenteeism
-Percentage
Attendance (IC)
student.personID
Grade
CourseTeacher
customSection.semesterCode
Assessment Data(IC)
Event Name
Event Code
Event Date
Resolution type
Behaviour IC
To get started you just need to pull all the data into a master Sheet! It is all from once source which make this extremely easier
Next for attendance and demographics these are all simple data pulls.
The only helper column you need here is “Chronic Indicator (20>10>5)”. This uses “attChronicAbsenteeism.absenteeism-Percentage” to group students with exteremely low attendance. Here is the formula you need.
Formula
=IF(P6>20,“Severely Chronic",
IF(P6>=10, “Chronic",
IF(P6>=5, “At Risk", “On Track")))
This is extremely raw and easy to digest at a glance
For our Assessment Data we will need just a single Table from our export.
You can use this formula to pull all the data you need based on the Student ID
=IFERROR( QUERY(
{ARRAYFORMULA(TO_TEXT(“GRADE DATA SHEET” !A:A)), “GRADE DATA SHEET” !D:G},
"select Col2, Col3, Col4, Col5 where Col1 = '" & TO_TEXT(L4) & "' order by Col2 desc", 0),"")
*
Col 2 - Grade
Col 3 - Course
Col 4 - Teacher
Col 5 - Semeseter
Instructions
Reach out to me directly if you are interested in Automating your Infinite Campus Workflows!
*These don’t not give a full picture of the complexity of the formulas used to pull things such as “Grade averages” or Conditional Formatting