Go to your area and Create a Week 5 Folder in your Computing/Excel area. Save the files below to this area.
I am not in today. Follow the instructions on this Page and you will understand how to sort and filter. There are some hard copies of the fill in worksheets on the filing cabinet or you can fill them in electronically. Help each other but make sure you fill in your own work sheet. I will go through it all again next week.
If you are still having problems then work on the chocolate brownies work sheet from last week and choose your own recipe to work out the percentage of ingredients.
Top Tip USE Chrome Right Click, then Left click on Save link as
Save to the New Folder.
Save the files above and open the file Test results
Save this file below to add in your answers.
As you have sorted the data you can just read the top mark and the bottom mark.
Open the file Secret Missions
Fill in the Sort and Filter Worksheet you will get the answers by filtering the data.
Comparing data
Open the file Comparison Operators