
Session Objective:

To use Excel for:
Learner performance
Analysis
Getting to Know Excel
Activity:
Formulas
Average ➡ =AVERAGE (Test 1:Test 2) - Click on ENTER
Result ➡=IF(Click on Average cell)>=25,"Pass","Fail") - Click on ENTER
Convert AVERAGE to % ➡ =(AVERAGE(Test 1:Test 2)/50)*100 - Click on ENTER
Conditional formatting:
- Pass = Green
- Fail = Red
Highlight the Result column (where it says Pass/Fail)
Click Home tab
Click Conditional Formatting
Click Highlight Cells Rules
Click Text that Contains…
Type: Pass
Choose: Green fill
Click OK
⚜ Repeat the same steps for "Fail"
To calculate how many learners failed:
=COUNTIF(Drag all Pass cells in the results column, "Pass") Click on ENTER
To calculate how many learners failed:
=COUNTIF(Drag all Fail cells in the RESULTS column, "Fail") Click on ENTER
To identify the learner with the highest average:
=MAX(Drag all the cells in the AVERAGE column) Click on ENTER