{"id":265,"date":"2016-04-05T11:21:00","date_gmt":"2016-04-05T18:21:00","guid":{"rendered":"https:\/\/blogs.ubc.ca\/mrrobsonwindermere\/?page_id=265"},"modified":"2016-04-05T14:16:40","modified_gmt":"2016-04-05T21:16:40","slug":"lesson-3-2","status":"publish","type":"page","link":"https:\/\/blogs.ubc.ca\/mrrobsonwindermere\/grade-8\/lesson-3-2\/","title":{"rendered":"Lesson 3"},"content":{"rendered":"<p><strong>Shape of the day:<\/strong><\/p>\n<p><strong>Typing.com \u00a0(10 min), Prices Activity (20 minutes) and then Travel Budget (30 min)\u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>Do this after typing:<\/p>\n<p>We&#8217;re going to do an activity with the prices we found from last Friday: click <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1-ytVvQqOJE1gaD9SyaQHBt9jop4jZWLJavwNTaIErLo\/edit?usp=sharing\" target=\"_blank\">here.\u00a0<\/a>\u00a0(if you don&#8217;t know your Google log in, please do this activity with\u00a0a neighbour who does).<\/p>\n<p>Activity: Find the <span style=\"text-decoration: underline;\">average<\/span> and <span style=\"text-decoration: underline;\">median<\/span>\u00a0costs of the everyday items listed in the link. Use the formula<\/p>\n<p><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">average<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\">C2:F2<\/span><span class=\" default-formula-text-color\" dir=\"auto\">) \u00a0and =median(c2:f2).\u00a0<\/span><\/p>\n<p>Tip: There are two shortcuts to cascade the formula down the list.<\/p>\n<ol>\n<li>drag the bottom right corner of the cell down the list.<\/li>\n<li>copy the formula, then use CTRL and down arrow to select where you want to paste<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Field trip\u00a0Budget activity<\/strong><\/span>: click <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1iv4Vh0h9UdjsKimD-9TVBbPvkOtTmFefe526k47I5r4\/edit?usp=sharing\" target=\"_blank\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Shape of the day: Typing.com \u00a0(10 min), Prices Activity (20 minutes) and then Travel Budget (30 min)\u00a0 &nbsp; Do this after typing: We&#8217;re going to do an activity with the prices we found from last Friday: click here.\u00a0\u00a0(if you don&#8217;t &hellip; <a href=\"https:\/\/blogs.ubc.ca\/mrrobsonwindermere\/grade-8\/lesson-3-2\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":36719,"featured_media":0,"parent":125,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-265","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.ubc.ca\/mrrobsonwindermere\/wp-json\/wp\/v2\/pages\/265","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ubc.ca\/mrrobsonwindermere\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.ubc.ca\/mrrobsonwindermere\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/mrrobsonwindermere\/wp-json\/wp\/v2\/users\/36719"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/mrrobsonwindermere\/wp-json\/wp\/v2\/comments?post=265"}],"version-history":[{"count":5,"href":"https:\/\/blogs.ubc.ca\/mrrobsonwindermere\/wp-json\/wp\/v2\/pages\/265\/revisions"}],"predecessor-version":[{"id":270,"href":"https:\/\/blogs.ubc.ca\/mrrobsonwindermere\/wp-json\/wp\/v2\/pages\/265\/revisions\/270"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/mrrobsonwindermere\/wp-json\/wp\/v2\/pages\/125"}],"wp:attachment":[{"href":"https:\/\/blogs.ubc.ca\/mrrobsonwindermere\/wp-json\/wp\/v2\/media?parent=265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}