{"id":35,"date":"2017-07-05T20:44:14","date_gmt":"2017-07-05T20:44:14","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/?post_type=chapter&#038;p=35"},"modified":"2017-07-06T18:21:24","modified_gmt":"2017-07-06T18:21:24","slug":"week-2-overview","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/chapter\/week-2-overview\/","title":{"raw":"Week 2 Overview","rendered":"Week 2 Overview"},"content":{"raw":"Now that you have had experience building a spreadsheet, the next steps are to incorporate formulas that will quickly return the information you request.\r\n\r\nIn the Public Expenses by Quarter, you will learn to average string of numbers quickly. From a group of numbers, you will be able to find the largest and smallest number in just a few stokes as well as the ability to count how many numbers are in a column.\r\n\r\nIn the Sales Calculation, you will learn about Relative Referencing and Absolute Referencing.\r\n<h3>Learning Outcomes: The student will:<\/h3>\r\n<ul>\r\n \t<li>Apply AVE, MAX, MIN, Count features<\/li>\r\n \t<li>Understand the difference between relative and absolute referencing<\/li>\r\n \t<li>Apply the absolute referencing to find \u201cWhat If?\u201d<\/li>\r\n \t<li>Understand the Order of Precedence when it comes to creating complex formulas<\/li>\r\n<\/ul>\r\n<h3>Tasks and Assignments:<\/h3>\r\n<ol>\r\n \t<li><strong>Public Expenses by Quarter.<\/strong> Student is introduced to new formulas, (AVE, MAX, MIN, COUNT) and these apply these formulas. (20 points)<\/li>\r\n \t<li><strong>Relative Referencing and Absolute Referencing:<\/strong> Read this informational<\/li>\r\n \t<li><strong> Sales Calculation.<\/strong> Developed a formula to answer the question \u201cWhat If?\u201d What if analysis is a decision-making tool in which data is changed and formulas ae recalculated, in order to predict various possible outcomes. (20 points)<\/li>\r\n<\/ol>\r\n<h3>Submitting your work:<\/h3>\r\n<ol>\r\n \t<li>When completing each task, make sure to save your document to the desktop or your personal storage unit (memory stick, jump drive, etc.)<\/li>\r\n \t<li>Click on the underlined word(s) at the top of each assignment. An \u201cemaillike\u201d format appears with the number of points possible in the upper left corner.<\/li>\r\n \t<li>Find a box \u201cBrowse My Computer.\u201d Click on that and find your saved document.<\/li>\r\n \t<li>Click Submit.<\/li>\r\n \t<li>For additional help, please see the EXTRA HELP folder in the CONTENT area called \u201cHow to Submit Your Work.<\/li>\r\n<\/ol>","rendered":"<p>Now that you have had experience building a spreadsheet, the next steps are to incorporate formulas that will quickly return the information you request.<\/p>\n<p>In the Public Expenses by Quarter, you will learn to average string of numbers quickly. From a group of numbers, you will be able to find the largest and smallest number in just a few stokes as well as the ability to count how many numbers are in a column.<\/p>\n<p>In the Sales Calculation, you will learn about Relative Referencing and Absolute Referencing.<\/p>\n<h3>Learning Outcomes: The student will:<\/h3>\n<ul>\n<li>Apply AVE, MAX, MIN, Count features<\/li>\n<li>Understand the difference between relative and absolute referencing<\/li>\n<li>Apply the absolute referencing to find \u201cWhat If?\u201d<\/li>\n<li>Understand the Order of Precedence when it comes to creating complex formulas<\/li>\n<\/ul>\n<h3>Tasks and Assignments:<\/h3>\n<ol>\n<li><strong>Public Expenses by Quarter.<\/strong> Student is introduced to new formulas, (AVE, MAX, MIN, COUNT) and these apply these formulas. (20 points)<\/li>\n<li><strong>Relative Referencing and Absolute Referencing:<\/strong> Read this informational<\/li>\n<li><strong> Sales Calculation.<\/strong> Developed a formula to answer the question \u201cWhat If?\u201d What if analysis is a decision-making tool in which data is changed and formulas ae recalculated, in order to predict various possible outcomes. (20 points)<\/li>\n<\/ol>\n<h3>Submitting your work:<\/h3>\n<ol>\n<li>When completing each task, make sure to save your document to the desktop or your personal storage unit (memory stick, jump drive, etc.)<\/li>\n<li>Click on the underlined word(s) at the top of each assignment. An \u201cemaillike\u201d format appears with the number of points possible in the upper left corner.<\/li>\n<li>Find a box \u201cBrowse My Computer.\u201d Click on that and find your saved document.<\/li>\n<li>Click Submit.<\/li>\n<li>For additional help, please see the EXTRA HELP folder in the CONTENT area called \u201cHow to Submit Your Work.<\/li>\n<\/ol>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-35\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Week 2 Overview. <strong>Authored by<\/strong>: Fran Wells. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":23590,"menu_order":7,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Week 2 Overview\",\"author\":\"Fran Wells\",\"organization\":\"\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-35","chapter","type-chapter","status-publish","hentry"],"part":144,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/chapters\/35","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/wp\/v2\/users\/23590"}],"version-history":[{"count":1,"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/chapters\/35\/revisions"}],"predecessor-version":[{"id":36,"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/chapters\/35\/revisions\/36"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/parts\/144"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/chapters\/35\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/wp\/v2\/media?parent=35"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/chapter-type?post=35"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/wp\/v2\/contributor?post=35"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/wp\/v2\/license?post=35"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}