IF / Academic Administrator
Determining Student Pass/Fail Status
An Academic Administrator needs to quickly determine the pass/fail status for a large class of students based on their exam scores. The passing grade is 70. Manually assigning status for each student is tedious and error-prone.
formula.xlsx
=IF(B2>=70,"Pass","Fail") How it works: This formula checks if the exam score in cell B2 is greater than or equal to 70. If it is, the student receives a 'Pass' status; otherwise, they receive a 'Fail' status. This automates the grading process.
Data Setup
| Student Name | Exam Score |
|---|---|
| Emily | 85 |
| David | 68 |
| Sarah | 70 |
| Michael | 92 |
Step-by-Step Guide
1
Open your student gradebook spreadsheet.
2
In a new column (e.g., C2), type the formula: `=IF(B2>=70,"Pass","Fail")`
3
Press Enter.
4
Drag the fill handle down to apply the formula to all students.