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