{"id":9,"date":"2017-04-21T15:18:38","date_gmt":"2017-04-21T15:18:38","guid":{"rendered":"http:\/\/learnlearn.uk\/spreadsheets\/?page_id=9"},"modified":"2017-04-25T10:40:18","modified_gmt":"2017-04-25T10:40:18","slug":"using-charts","status":"publish","type":"page","link":"https:\/\/learnlearn.uk\/spreadsheets\/using-charts\/","title":{"rendered":"Using Charts &#038; Simple Functions"},"content":{"rendered":"\n<div class=\"arconix-tabs-horizontal\"><ul class=\"arconix-tabs\"><li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-Starter\"><a class=\"\" href=\"#tab-Starter\">Starter<\/a><\/li>\n<li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-Whyusespreadsheets\"><a class=\"\" href=\"#tab-Whyusespreadsheets\">Why use spreadsheets?<\/a><\/li>\n<li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-TutorialVideo\"><a class=\"\" href=\"#tab-TutorialVideo\">Tutorial Video<\/a><\/li>\n<li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-Activity1\"><a class=\"\" href=\"#tab-Activity1\">Activity 1<\/a><\/li>\n<li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-AutoFunctions\"><a class=\"\" href=\"#tab-AutoFunctions\">Auto Functions<\/a><\/li>\n<li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-Activity2\"><a class=\"\" href=\"#tab-Activity2\">Activity 2<\/a><\/li>\n<li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-Activity3\"><a class=\"\" href=\"#tab-Activity3\">Activity 3<\/a><\/li>\n<li data-arconix-icon=\" \" data-arconix-color=\" \" class=\"arconix-tab tab-Resources\"><a class=\"\" href=\"#tab-Resources\">Resources<\/a><\/li><\/ul>\n<div class=\"arconix-panes\"><div class=\"arconix-pane pane-Starter\">\n<h3>Starter 5 mins<\/h3>\n<p>Pie chart maker starter ( using favourite animal frequencies)<\/p>\n<a href='https:\/\/docs.google.com\/document\/d\/16syvYxw7YGYU-0x-HUOiUSQfLe9Vl4IgmBQtI8p7mXk\/edit?usp=sharing' class='arconix-button arconix-button-medium arconix-button-gray' target=\"_blank\" >Pie Chart Starter<\/a>\n<\/div>\n<div class=\"arconix-pane pane-Whyusespreadsheets\">\n<h3>Why use spreadsheets?<\/h3>\n<p>Thinking back to the starter, how many of you found the activity&#8230;<\/p>\n<ul>\n<li>Too easy \/ too hard<\/li>\n<li>Too fast \/ too slow<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Creating Tables and Charts<\/strong><\/p>\n<p>Follow the steps in the video to create a table and chart the is similar to the image below<\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<div class=\"arconix-pane pane-TutorialVideo\">\n<h3>Tutorial Video<\/h3>\n<p>Using what you have learned from the video, create a spreadsheet like the one below:<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-16\" src=\"https:\/\/learnlearn.uk\/spreadsheets\/wp-content\/uploads\/sites\/15\/2017\/04\/spreadsheets-lesson-2-wagoll.png\" alt=\"spreadsheets lesson 2 wagoll\" width=\"707\" height=\"493\" srcset=\"https:\/\/learnlearn.uk\/spreadsheets\/wp-content\/uploads\/sites\/15\/2017\/04\/spreadsheets-lesson-2-wagoll.png 707w, https:\/\/learnlearn.uk\/spreadsheets\/wp-content\/uploads\/sites\/15\/2017\/04\/spreadsheets-lesson-2-wagoll-300x209.png 300w, https:\/\/learnlearn.uk\/spreadsheets\/wp-content\/uploads\/sites\/15\/2017\/04\/spreadsheets-lesson-2-wagoll-600x418.png 600w\" sizes=\"(max-width: 707px) 100vw, 707px\" \/><\/p>\n<\/div>\n<div class=\"arconix-pane pane-Activity1\">\n<h3>Activity &#8211; Class Poll<\/h3>\n<p>You now need to go round the class and complete a poll of their favourite colour, football team, etc.<\/p>\n<p>Now create your own spreadsheet using the results and customise your sheet to make it look professional.<\/p>\n<p>Example poll ideas:<\/p>\n<ul>\n<li>Favorite football team<\/li>\n<li>favourite teacher<\/li>\n<li>number of siblings<\/li>\n<li>weight<\/li>\n<li>eye color<\/li>\n<li>favourite country<\/li>\n<\/ul>\n<\/div>\n<div class=\"arconix-pane pane-AutoFunctions\">\n<h3>Auto Functions<\/h3>\n<p>Most spreadsheet software packages have in built functions that can be used to<\/p>\n<ul>\n<li>Sum &#8211; Add all the values in a range<\/li>\n<li>Min &#8211; Find the smallest value in a range<\/li>\n<li>Max &#8211; Find the largest value in a range<\/li>\n<li>Average &#8211; Find the mean average value in a range<\/li>\n<\/ul>\n<div class=\"arconix-column-one-third\">\n<p><strong>Google Sheets<\/strong><\/p>\n<figure id=\"attachment_20\" aria-describedby=\"caption-attachment-20\" style=\"width: 162px\" class=\"wp-caption alignnone\"><img decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-20\" src=\"https:\/\/learnlearn.uk\/spreadsheets\/wp-content\/uploads\/sites\/15\/2017\/04\/Google-sheets-auto-functions.png\" alt=\"Google Sheets Quick Access Functions\" width=\"162\" height=\"221\" \/><figcaption id=\"caption-attachment-20\" class=\"wp-caption-text\">Google Sheets Quick Access Functions<\/figcaption><\/figure>\n<\/div>\n<div class=\"arconix-column-one-third\">\n<figure id=\"attachment_21\" aria-describedby=\"caption-attachment-21\" style=\"width: 157px\" class=\"wp-caption alignnone\"><img decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-21\" src=\"https:\/\/learnlearn.uk\/spreadsheets\/wp-content\/uploads\/sites\/15\/2017\/04\/excel-auto-functions.png\" alt=\"Excel Quick Access functions\" width=\"157\" height=\"174\" \/><figcaption id=\"caption-attachment-21\" class=\"wp-caption-text\">Excel Quick Access functions<\/figcaption><\/figure>\n<\/div>\n<div class=\"arconix-column-one-third\">\n<\/div>\n<\/div>\n<div class=\"arconix-pane pane-Activity2\">\n<h3>Activity 2<\/h3>\n<p>Log in to Google Classroom and go to today&#8217;s assignment. Open the assignment presentation and paste a screenshot of your chart \/ table on to the first page of the presentation.<\/p>\n<p>You should use the snipping tool and Control+V to paste your code in to the presentation<\/p>\n<\/div>\n<div class=\"arconix-pane pane-Activity3\">\n<h3>Activity 3<\/h3>\n<p>Log in to QuizMaster and complete today&#8217;s quiz.<\/p>\n<\/div>\n<div class=\"arconix-pane pane-Resources\">\n<a href='https:\/\/docs.google.com\/presentation\/d\/1Sp90Fngj4iAJb-DqSDIBp589Bl_fnU1brc2gmLzAikI\/edit?usp=sharing' class='arconix-button arconix-button-medium arconix-button-gray' target=\"_blank\" >Teacher&#8217;s Presentation<\/a>\n<\/div><\/div><\/div>\n\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Using Charts &amp; Simple Functions - Spreadsheets<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/learnlearn.uk\/spreadsheets\/using-charts\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Charts &amp; Simple Functions - Spreadsheets\" \/>\n<meta property=\"og:description\" content=\"&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/learnlearn.uk\/spreadsheets\/using-charts\/\" \/>\n<meta property=\"og:site_name\" content=\"Spreadsheets\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-25T10:40:18+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/learnlearn.uk\/spreadsheets\/wp-content\/uploads\/sites\/15\/2017\/04\/spreadsheets-lesson-2-wagoll.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/learnlearn.uk\/spreadsheets\/using-charts\/\",\"url\":\"https:\/\/learnlearn.uk\/spreadsheets\/using-charts\/\",\"name\":\"Using Charts & Simple Functions - Spreadsheets\",\"isPartOf\":{\"@id\":\"https:\/\/learnlearn.uk\/spreadsheets\/#website\"},\"datePublished\":\"2017-04-21T15:18:38+00:00\",\"dateModified\":\"2017-04-25T10:40:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/learnlearn.uk\/spreadsheets\/using-charts\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/learnlearn.uk\/spreadsheets\/using-charts\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/learnlearn.uk\/spreadsheets\/using-charts\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/learnlearn.uk\/spreadsheets\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Charts &#038; Simple Functions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/learnlearn.uk\/spreadsheets\/#website\",\"url\":\"https:\/\/learnlearn.uk\/spreadsheets\/\",\"name\":\"Spreadsheets\",\"description\":\"Just another My Blog site\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/learnlearn.uk\/spreadsheets\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using Charts & Simple Functions - Spreadsheets","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/learnlearn.uk\/spreadsheets\/using-charts\/","og_locale":"en_GB","og_type":"article","og_title":"Using Charts & Simple Functions - Spreadsheets","og_description":"&nbsp;","og_url":"https:\/\/learnlearn.uk\/spreadsheets\/using-charts\/","og_site_name":"Spreadsheets","article_modified_time":"2017-04-25T10:40:18+00:00","og_image":[{"url":"http:\/\/learnlearn.uk\/spreadsheets\/wp-content\/uploads\/sites\/15\/2017\/04\/spreadsheets-lesson-2-wagoll.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/learnlearn.uk\/spreadsheets\/using-charts\/","url":"https:\/\/learnlearn.uk\/spreadsheets\/using-charts\/","name":"Using Charts & Simple Functions - Spreadsheets","isPartOf":{"@id":"https:\/\/learnlearn.uk\/spreadsheets\/#website"},"datePublished":"2017-04-21T15:18:38+00:00","dateModified":"2017-04-25T10:40:18+00:00","breadcrumb":{"@id":"https:\/\/learnlearn.uk\/spreadsheets\/using-charts\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/learnlearn.uk\/spreadsheets\/using-charts\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/learnlearn.uk\/spreadsheets\/using-charts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/learnlearn.uk\/spreadsheets\/"},{"@type":"ListItem","position":2,"name":"Using Charts &#038; Simple Functions"}]},{"@type":"WebSite","@id":"https:\/\/learnlearn.uk\/spreadsheets\/#website","url":"https:\/\/learnlearn.uk\/spreadsheets\/","name":"Spreadsheets","description":"Just another My Blog site","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/learnlearn.uk\/spreadsheets\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"}]}},"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"learnlearnadmin","author_link":"https:\/\/learnlearn.uk\/spreadsheets\/author\/learnlearnadmin\/"},"rttpg_comment":0,"rttpg_category":null,"rttpg_excerpt":"&nbsp;","_links":{"self":[{"href":"https:\/\/learnlearn.uk\/spreadsheets\/wp-json\/wp\/v2\/pages\/9"}],"collection":[{"href":"https:\/\/learnlearn.uk\/spreadsheets\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/learnlearn.uk\/spreadsheets\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/spreadsheets\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/spreadsheets\/wp-json\/wp\/v2\/comments?post=9"}],"version-history":[{"count":0,"href":"https:\/\/learnlearn.uk\/spreadsheets\/wp-json\/wp\/v2\/pages\/9\/revisions"}],"wp:attachment":[{"href":"https:\/\/learnlearn.uk\/spreadsheets\/wp-json\/wp\/v2\/media?parent=9"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}