🎯 Learning Objectives
- Use conditional formatting in a spreadsheet.
- Take an assessment to test your Excel skills.
💬 Key Vocabulary
- conditional formatting
- criterion/criteria
- header
- filter
- average
📖 Conditional Formatting
- Conditional formatting in Excel is like applying automatic highlights to your data based on rules you set.
- Imagine you have a list of test scores for your class. You can tell Excel, “If a score is less than 50, colour the cell red,” or, “If a score is greater than 90, colour the cell green.” Excel then instantly looks at every score and changes the cell’s appearance (like its background colour or text colour) if it meets the condition.
- This makes it super easy to quickly spot important information, like which students need extra help (the red scores) or who’s doing great (the green scores)! It helps you visualise your data instantly without having to check every single number yourself.
📝 Level 1 – Conditional Formatting
Using the information above and what your teacher has shown you it’s time to use conditional formatting on a real Excel file.
Download the Level 1 spreadsheet below and complete the sheets called Weather data and Magic square. The instructions can be found inside the spreadsheet.
📝 Level 2/3 – Assessment
- It’s now time to complete an assessment to see how much of the topic you can use without help.
- You need to download the assessment spreadsheet file and the questions file below.
- Follow the questions and complete as many as you can. Completing questions 1 -3 earns you Level 2 and 4-5 gets your Level 3.
In this lesson, you…
- Used conditional formatting in a spreadsheet
- Applied all of the spreadsheet skills covered in this unit to analyse forestry data
In this topic, you have…
- Navigated spreadsheets, used cell references, and applied formatting.
- Performed calculations using basic formulas (+, -, *, /) and the autofill tool.
- Understood data and collected it.
- Analyzed data with functions (SUM, MAX, MIN, COUNTA, AVERAGE, COUNTIF, IF) and created charts.
- Sorted, filtered, and applied conditional formatting to data.
🏅 Level up
🥇 Level 1
- Complete Level 1 – Conditional Formatting and upload the completed Excel spreadsheet to the Teams assignment.
🥈 Level 2
- Answer questions 1-3 in the assessment and upload the Excel spreadsheet to the Teams assignment.
🥉 Level 3
- Answer questions 4-5 in the assessment and upload the Excel spreadsheet to the Teams assignment.