{"id":66,"date":"2015-10-13T09:25:01","date_gmt":"2015-10-13T09:25:01","guid":{"rendered":"http:\/\/mr-west.uk\/igcse\/?page_id=66"},"modified":"2020-11-12T19:13:09","modified_gmt":"2020-11-12T19:13:09","slug":"6-5-modelling-applications","status":"publish","type":"page","link":"https:\/\/learnlearn.uk\/igcseict\/6-5-modelling-applications\/","title":{"rendered":"6.5 Modelling Using Spreadsheets"},"content":{"rendered":"<div class=\"responsive-tabs\">\n<h2 class=\"tabtitle\">Starter<\/h2>\n<div class=\"tabcontent\">\n\n<p><iframe loading=\"lazy\" src=\"\/\/scratch.mit.edu\/projects\/embed\/125880439\/?autostart=false\" width=\"800\" height=\"600\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n\n<\/div><h2 class=\"tabtitle\">Introduction<\/h2>\n<div class=\"tabcontent\">\n\n<div class=\"arconix-column-two-thirds\">\n<h2>Modelling Using Spreadsheets<\/h2>\n<p>We often need to plan for future events and activities, and these plans sometimes include calculations about and money and budgeting.While we can make simple calculations in \u00c2\u00a0our heads, it is sometimes beneficial to use spreadsheet software to make financial predictions and plans ( such as how per week we need to save per week in order to afford that new computer game&#8230;etc&#8230;etc). This type of planning is known as spreadsheet modelling.<\/p>\n<p><strong>Advantages of spreadsheet models<\/strong><\/p>\n<ul>\n<li>Formulas and scripts allow for powerful, advanced modelling<\/li>\n<li>In built charts make for user friendly and professional output.<\/li>\n<li>Easy to use and make<\/li>\n<li>Easy to share &#8211; copy \/ online<\/li>\n<\/ul>\n<\/div>\n<div class=\"arconix-column-one-third\">\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1532\" src=\"https:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2015\/10\/modelling-with-spreadsheets.jpg\" alt=\"modelling-with-spreadsheets\" width=\"221\" height=\"228\" \/><\/p>\n<\/div>\n\n<\/div><h2 class=\"tabtitle\">Budgeting<\/h2>\n<div class=\"tabcontent\">\n\n<div class=\"arconix-column-two-thirds\">\n<h3>Holiday Savings Model<\/h3>\n<p>We all love going on holiday, but it&#8217;s often quite difficult to save up enough money to enjoy yourself! Holiday budget modelling using spreadsheets is a great way to help you work out how much you need to save each week or month in order to save up enough!<\/p>\n<p>Click on the link on the right to make a copy of the Google Sheets model and have a go at calculating what you need to save for your next holiday!<\/p>\n<p><strong>Questions<\/strong><\/p>\n<ol>\n<li>You want to go scuba diving in August and you have calculated that you will need to have at least \u00c2\u00a3550 pounds saved up. How much will you have to save per week to achieve your goal?<\/li>\n<li>You are going to Disney World with your family in July but you have to pay for your own park tickets at \u00c2\u00a3400! How much will you have to save each month to pay for your tickets?<\/li>\n<\/ol>\n<\/div>\n<div class=\"arconix-column-one-third\">\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-1535 size-medium\" src=\"https:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2015\/10\/Holiday-savings-model-300x167.png\" alt=\"Modelling Using Spreadsheets\" width=\"300\" height=\"167\" srcset=\"https:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2015\/10\/Holiday-savings-model-300x167.png 300w, https:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2015\/10\/Holiday-savings-model-600x335.png 600w, https:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2015\/10\/Holiday-savings-model.png 733w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<a href='https:\/\/docs.google.com\/spreadsheets\/d\/1om7RdyV79ni9650HLO_M9GZ8GHJVZYy-GjPtgEVhJs0\/copy' class='arconix-button arconix-button-medium arconix-button-blue'>Holiday Savings Model<\/a>\n<\/div>\n\n<\/div><h2 class=\"tabtitle\">Grade Prediction<\/h2>\n<div class=\"tabcontent\">\n\n<div class=\"arconix-column-two-thirds\">\n<h3>Grade Prediction \u00c2\u00a0Model<\/h3>\n<p>When studying for a qualification, or managing a class of students, you will often need to calculate a student&#8217;s present or predicted grade. Grade prediction modelling using spreadsheets is a great way to quickly work out what your predicted grade is!<\/p>\n<p>Click on the link on the right to make a copy of the Google Sheets model and have a go at calculating what your predicted grade is!<\/p>\n<p><strong>Questions<\/strong><\/p>\n<ol>\n<li>You scored 45% on your first test, but have improved by 7% each time in all the following tests. What is your current predicted grade?<\/li>\n<li>You scored 72% , 66 % , 95% and 80% on your first\u00c2\u00a04 tests. What is the minimum percent you need to achieve on your final test to achieve an A?<\/li>\n<\/ol>\n<\/div>\n<div class=\"arconix-column-one-third\">\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-1536\" src=\"https:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2015\/10\/grade-prediction-model-300x199.png\" alt=\"grade-prediction-model\" width=\"300\" height=\"199\" srcset=\"https:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2015\/10\/grade-prediction-model-300x199.png 300w, https:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2015\/10\/grade-prediction-model-600x397.png 600w, https:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2015\/10\/grade-prediction-model.png 648w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>&nbsp;<\/p>\n<a href='https:\/\/docs.google.com\/spreadsheets\/d\/1Qv-1B4xxrT1H4rN0C91pL-JxzeKOqETgeP0iKGSwsqU\/copy' class='arconix-button arconix-button-medium arconix-button-blue'>Grade Prediction Model<\/a>\n<\/div>\n\n<\/div><h2 class=\"tabtitle\">Activity<\/h2>\n<div class=\"tabcontent\">\n\n<div class=\"arconix-column-two-thirds\">\n<h3>Activity -\u00c2\u00a0Road trip Model<\/h3>\n<p>You are going on a long road trip across the USA and would like to know how many miles you will need to travel each day.<\/p>\n<p>Create a model of the road trip. It should be able to:<\/p>\n<div class=\"arconix-list\" data-arconix-icon=\"fa-chevron-circle-right\" data-arconix-color=\"black\">\n<ul>\n<li>Calculate how many miles per day you will need to travel<\/li>\n<li>How much fuel you \u00c2\u00a0will use for your trip ( assume 50 MPG and a price of $5 a gallon)<\/li>\n<li>How many hours driving you will need to do each day.<\/li>\n<\/ul>\n<\/div>\n<p>You will need to draw on your knowledge from the practical units you have covered.<\/p>\n<\/div>\n<div class=\"arconix-column-one-third\">\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-1548\" src=\"https:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2015\/10\/road-trip-300x199.jpg\" alt=\"road-trip\" width=\"300\" height=\"199\" srcset=\"https:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2015\/10\/road-trip-300x199.jpg 300w, https:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2015\/10\/road-trip-768x510.jpg 768w, https:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2015\/10\/road-trip-600x399.jpg 600w, https:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2015\/10\/road-trip.jpg 960w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<\/div>\n\n<\/div><h2 class=\"tabtitle\">Homework<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Homework<\/h3>\n<p>Complete the QuizMaster quiz titled &#8220;Spreadsheet modelling review quiz&#8221;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<\/div><\/div>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Homework Complete the QuizMaster quiz titled &#8220;Spreadsheet modelling review quiz&#8221; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":70,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>6.5 Modelling Using Spreadsheets - IGCSE ICT<\/title>\n<meta name=\"description\" content=\"Free online lesson plan for modelling using spreadsheets in the ICT IGCSE qualification. Full resources and activities included.\" \/>\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\/igcseict\/6-5-modelling-applications\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"6.5 Modelling Using Spreadsheets - IGCSE ICT\" \/>\n<meta property=\"og:description\" content=\"Free online lesson plan for modelling using spreadsheets in the ICT IGCSE qualification. Full resources and activities included.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/learnlearn.uk\/igcseict\/6-5-modelling-applications\/\" \/>\n<meta property=\"og:site_name\" content=\"IGCSE ICT\" \/>\n<meta property=\"article:modified_time\" content=\"2020-11-12T19:13:09+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2015\/10\/modelling-with-spreadsheets.jpg\" \/>\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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/learnlearn.uk\/igcseict\/6-5-modelling-applications\/\",\"url\":\"https:\/\/learnlearn.uk\/igcseict\/6-5-modelling-applications\/\",\"name\":\"6.5 Modelling Using Spreadsheets - IGCSE ICT\",\"isPartOf\":{\"@id\":\"https:\/\/learnlearn.uk\/igcseict\/#website\"},\"datePublished\":\"2015-10-13T09:25:01+00:00\",\"dateModified\":\"2020-11-12T19:13:09+00:00\",\"description\":\"Free online lesson plan for modelling using spreadsheets in the ICT IGCSE qualification. Full resources and activities included.\",\"breadcrumb\":{\"@id\":\"https:\/\/learnlearn.uk\/igcseict\/6-5-modelling-applications\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/learnlearn.uk\/igcseict\/6-5-modelling-applications\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/learnlearn.uk\/igcseict\/6-5-modelling-applications\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"IGCSE ICT Home\",\"item\":\"https:\/\/learnlearn.uk\/igcseict\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"6.5 Modelling Using Spreadsheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/learnlearn.uk\/igcseict\/#website\",\"url\":\"https:\/\/learnlearn.uk\/igcseict\/\",\"name\":\"IGCSE ICT\",\"description\":\"Lessons &amp; Revision\",\"publisher\":{\"@id\":\"https:\/\/learnlearn.uk\/igcseict\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/learnlearn.uk\/igcseict\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/learnlearn.uk\/igcseict\/#organization\",\"name\":\"IGCSE ICT\",\"url\":\"https:\/\/learnlearn.uk\/igcseict\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/learnlearn.uk\/igcseict\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2019\/02\/LearnLearnLogowhite.png\",\"contentUrl\":\"https:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2019\/02\/LearnLearnLogowhite.png\",\"width\":710,\"height\":98,\"caption\":\"IGCSE ICT\"},\"image\":{\"@id\":\"https:\/\/learnlearn.uk\/igcseict\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"6.5 Modelling Using Spreadsheets - IGCSE ICT","description":"Free online lesson plan for modelling using spreadsheets in the ICT IGCSE qualification. Full resources and activities included.","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\/igcseict\/6-5-modelling-applications\/","og_locale":"en_GB","og_type":"article","og_title":"6.5 Modelling Using Spreadsheets - IGCSE ICT","og_description":"Free online lesson plan for modelling using spreadsheets in the ICT IGCSE qualification. Full resources and activities included.","og_url":"https:\/\/learnlearn.uk\/igcseict\/6-5-modelling-applications\/","og_site_name":"IGCSE ICT","article_modified_time":"2020-11-12T19:13:09+00:00","og_image":[{"url":"http:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2015\/10\/modelling-with-spreadsheets.jpg"}],"twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/learnlearn.uk\/igcseict\/6-5-modelling-applications\/","url":"https:\/\/learnlearn.uk\/igcseict\/6-5-modelling-applications\/","name":"6.5 Modelling Using Spreadsheets - IGCSE ICT","isPartOf":{"@id":"https:\/\/learnlearn.uk\/igcseict\/#website"},"datePublished":"2015-10-13T09:25:01+00:00","dateModified":"2020-11-12T19:13:09+00:00","description":"Free online lesson plan for modelling using spreadsheets in the ICT IGCSE qualification. Full resources and activities included.","breadcrumb":{"@id":"https:\/\/learnlearn.uk\/igcseict\/6-5-modelling-applications\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/learnlearn.uk\/igcseict\/6-5-modelling-applications\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/learnlearn.uk\/igcseict\/6-5-modelling-applications\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"IGCSE ICT Home","item":"https:\/\/learnlearn.uk\/igcseict\/"},{"@type":"ListItem","position":2,"name":"6.5 Modelling Using Spreadsheets"}]},{"@type":"WebSite","@id":"https:\/\/learnlearn.uk\/igcseict\/#website","url":"https:\/\/learnlearn.uk\/igcseict\/","name":"IGCSE ICT","description":"Lessons &amp; Revision","publisher":{"@id":"https:\/\/learnlearn.uk\/igcseict\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/learnlearn.uk\/igcseict\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/learnlearn.uk\/igcseict\/#organization","name":"IGCSE ICT","url":"https:\/\/learnlearn.uk\/igcseict\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/learnlearn.uk\/igcseict\/#\/schema\/logo\/image\/","url":"https:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2019\/02\/LearnLearnLogowhite.png","contentUrl":"https:\/\/learnlearn.uk\/igcseict\/wp-content\/uploads\/sites\/3\/2019\/02\/LearnLearnLogowhite.png","width":710,"height":98,"caption":"IGCSE ICT"},"image":{"@id":"https:\/\/learnlearn.uk\/igcseict\/#\/schema\/logo\/image\/"}}]}},"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"learnlearnadmin","author_link":"https:\/\/learnlearn.uk\/igcseict\/author\/learnlearnadmin\/"},"rttpg_comment":0,"rttpg_category":null,"rttpg_excerpt":"Homework Complete the QuizMaster quiz titled &#8220;Spreadsheet modelling review quiz&#8221; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;","_links":{"self":[{"href":"https:\/\/learnlearn.uk\/igcseict\/wp-json\/wp\/v2\/pages\/66"}],"collection":[{"href":"https:\/\/learnlearn.uk\/igcseict\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/learnlearn.uk\/igcseict\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/igcseict\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/igcseict\/wp-json\/wp\/v2\/comments?post=66"}],"version-history":[{"count":1,"href":"https:\/\/learnlearn.uk\/igcseict\/wp-json\/wp\/v2\/pages\/66\/revisions"}],"predecessor-version":[{"id":1903,"href":"https:\/\/learnlearn.uk\/igcseict\/wp-json\/wp\/v2\/pages\/66\/revisions\/1903"}],"wp:attachment":[{"href":"https:\/\/learnlearn.uk\/igcseict\/wp-json\/wp\/v2\/media?parent=66"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}