This report is designed as a dynamic risk-assessment tool to help administrators and counselors identify students who are academically at risk. It doesn’t just look at who is failing; it calculates a weighted risk score that prioritizes students with deeper failures (very low grades) and compares their progress to the previous week.

📊 Core Documentation: Student Risk Report

1. The Weighting Logic (The “Risk Score”)

The report goes beyond a simple count of failing classes. It assigns a “Weight” to every grade between 1 and 59. The lower the grade, the higher the points added to the student’s total Risk Score.

Why this matters: A student failing two classes with a 58 (Score: 2.0) is flagged as a lower priority than a student failing just one class with a 25 (Score: 8.0).

2. Risk Status Levels

Based on the Total Risk Score (the sum of all weighted failing grades), students are categorized into four action levels:

• 🔴 CRITICAL (Score 5+): Requires immediate intervention.

• 🟠 HIGH (Score 3-4.9): High priority for counselor review.

• 🟡 MEDIUM (Score 2-2.9): Monitor closely.

• ⚪ LOW (Score < 2): Single or borderline failure.

3. The Smart Date Engine

The report is “weekend-aware.” It automatically adjusts the data it pulls based on the day of the week you run it:

• Monday – Friday: The report pulls “Live” data from the current day.

• Saturday – Sunday: The report “freezes” on the previous Friday’s data so the dashboard doesn’t go blank over the weekend.

• The Comparison: The “Last Week” column always looks exactly 7 days back from the analyzed date to show true week-over-week progress.

4. Visual Features

• Trend Indicator: * UP ↑ (Red): The student’s risk score has increased (grades dropped or new failures added).

  • DOWN ↓ (Green): The student’s risk score has decreased (grades improved).

  • NO CHANGE: The situation remains the same as last week.

• Detailed Breakdown: Shows the specific courses and the exact numeric grades for both the Current Week and Last Week.

• Photo Integration: Enables instant student identification to support face-to-face check-ins.