Lesson 6 - Challenge Tasks


LEARNING OBJECTIVE

Success Criteria

To be able to create a column chart using Excel.

To enter the correct formula into Excel.

To calculate the total cost.

To budget to $65.00.


LEARNING OUTCOME

To have completed the ICT assessment on spreadsheets.

SHOULD:

  • I can create a column chart using Excel
  • I can enter the correct formula using Excel.
  • I can calculate the correct cost.

 

COULD:

  • I can improve my column chart (e.g., by changing the colours of the bars and underlining the title).
  • I can budget to $65.00.

Challenge Tasks

1. Budgeting For A Greek Meal

Scenario
You are in a Family of 4 and you are visiting a Greek Restaurant.

You have a budget of $65 for the whole family to eat.  You cannot go over this amount.  
(What is a budget?)
Each person in the family must have a Starter, Main Course and a Dessert each.


Your Tasks
  1. Download this spreadsheet
  1. Complete the formulas that will give us a total for each menu item, and a Grand Total for the whole meal
  2. Play around with the Quantities to get as close as possible to $65 for the Grand Total.
2. Greek Restaurant Reviews

Go To Sheet 2

  • You will find a list of 5 different restaurants in Greece.  
  • Each has been given a score out of 10.
  • Put the scores in a BAR CHART.
  • Put Chart Titles, Axis Titles and change the colours of the background and the bars




Comments