Lesson 3

Shape of the day:

Typing.com  (10 min), Prices Activity (20 minutes) and then Travel Budget (30 min) 

 

Do this after typing:

We’re going to do an activity with the prices we found from last Friday: click here.  (if you don’t know your Google log in, please do this activity with a neighbour who does).

Activity: Find the average and median costs of the everyday items listed in the link. Use the formula

=average(C2:F2)  and =median(c2:f2). 

Tip: There are two shortcuts to cascade the formula down the list.

  1. drag the bottom right corner of the cell down the list.
  2. copy the formula, then use CTRL and down arrow to select where you want to paste

 

Field trip Budget activity: click here.