Embedded Files
Class Expectations
Class Expectations
- To understand filter and sorting data in a spreadsheet
- To use Edmodo to save your learning
- To use formula function to find the total, average, maximum and minimum values.
Starter Challenge
Starter Challenge
- Log into Edmodo
- Click the Backpack on the Menu bar of Edmodo
- Click New and choose New Folder
- Give the Folder the name Spreadsheet Learning
- Go into that folder and press New and choose Excel Spreadsheet
- At the top of the document where it says 'untitled' give it an appropriate name (you can change this later)
You are now working in the cloud from Edmodo.
Challenge 1
Challenge 1
- Open the spreadsheet by clicking the link below.
- Highlight all the data and copy (Ctrl-C) everything.
- Paste all the data into your new spreadsheet.
- Turn on filtering for the spreadsheet and then answer the following questions.
- Complete the form by writing in 144 words what you have learned today.
- Go to the Assignment in Edmodo and upload your spreadsheet.
Challenge 2
Challenge 2
- Open Numbers on the iPad
- Recreate the spreadsheet from Challenge 1 in Lesson 3 in Numbers
- Make sure your name is in the Spreadsheet in Row 1
- Take a screenshot of your spreadsheet
- Airdrop the screenshot to your teacher
Report abuse