Embedded Files
Class Expectations
Class Expectations
- To review the comments from the previous lesson.
- To create an Excel Spreadsheet and format it to look professional
- To use formula function to find the total, average, maximum and minimum values.
- To solve a problem using an Excel Spreadsheet.
- To hand in the learning into Edmodo.
Starter Challenge
Starter Challenge
- Log into Edmodo and go to the assignment that you handed in last week.
- Spend 5 minutes reviewing the comments and improving your spreadsheet online in Edmodo.
Challenge 1
Challenge 1
- Open a new spreadsheet and save it with an appropriate name (your name).
- Upload the assignment to Edmodo, but DO NOT TURN IT IN!!
- Once it is uploaded, click on the Spreadsheet within Edmodo and continue the challenge online.
- Copy the spreadsheet exactly as it is in the image below into your spreadsheet.
- Complete the spreadsheet by adding the correct formulas in the cells in Columns E to H.
Challenge 2
Challenge 2
- Open the spreadsheet by clicking the link below.
- Highlight all the data and copy (Ctrl-C) everything.
- Create a new Sheet within your spreadsheet from Challenge 1 and call it Challenge 2.
- Paste all the data into that sheet.
- 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.
Report abuse