Why logical functions handle conditions in Google Sheets - Dashboard Impact

Dashboard Mode - Why logical functions handle conditions

Dashboard Goal

Understand how logical functions like IF, AND, and OR help handle conditions in Google Sheets to make decisions automatically.

Sample Data

Student	Score	Attendance (%)
Alice	85	90
Bob	72	75
Charlie	60	80
Diana	95	95
Eva	50	60

Dashboard Components

• KPI Card: Passed Students Count
  Formula: =COUNTIF(B2:B6, ">=70")
  Shows how many students scored 70 or more.
• KPI Card: Perfect Attendance Count
  Formula: =COUNTIF(C2:C6, ">=90")
  Shows how many students have attendance 90% or above.
• Table: Pass/Fail Status
  Formula in D2: =IF(B2>=70, "Pass", "Fail") copied down to D6.
  Shows if each student passed based on score.
• Table: Eligible for Award
  Formula in E2: =IF(AND(B2>=70, C2>=80), "Yes", "No") copied down to E6.
  Shows if student qualifies for award by score and attendance.
• Summary: Any Low Attendance?
  Formula: =IF(COUNTIF(C2:C6, "<70")>0, "Yes", "No")
  Shows if any student has attendance below 70%.

Dashboard Layout

+----------------------+-----------------------+
| Passed Students: 3    | Perfect Attendance: 2 |
+----------------------+-----------------------+
| Pass/Fail Status Table                      |
| +---------+-------+----------------------+ |
| | Student | Score | Pass/Fail             | |
| +---------+-------+----------------------+ |
| | Alice   | 85    | Pass                 | |
| | Bob     | 72    | Pass                 | |
| | Charlie | 60    | Fail                 | |
| | Diana   | 95    | Pass                 | |
| | Eva     | 50    | Fail                 | |
| +---------+-------+----------------------+ |
+---------------------------------------------+
| Eligible for Award Table                      |
| +---------+-------+----------------------+ |
| | Student | Score | Eligible for Award    | |
| +---------+-------+----------------------+ |
| | Alice   | 85    | Yes                  | |
| | Bob     | 72    | No                   | |
| | Charlie | 60    | No                   | |
| | Diana   | 95    | Yes                  | |
| | Eva     | 50    | No                   | |
| +---------+-------+----------------------+ |
+---------------------------------------------+
| Any Low Attendance? Yes/No                   |
+---------------------------------------------+

Interactivity

Add a filter for minimum score or attendance percentage. When you change the filter:

• KPI cards update counts based on filtered students.
• Pass/Fail and Eligible for Award tables update to show only filtered students.
• Summary of low attendance updates to reflect filtered data.

Self Check

If you add a filter to show only students with attendance above 80%, which components update and how?

• KPI cards will show counts only for students with attendance > 80%.
• Pass/Fail and Eligible for Award tables will list only those students.
• Summary of low attendance will update to reflect filtered students, possibly showing "No" if none have low attendance.

Key Result

Dashboard shows how logical functions handle conditions to classify student results and attendance.