{"id":87,"date":"2026-01-14T06:52:34","date_gmt":"2026-01-14T06:52:34","guid":{"rendered":"http:\/\/bispcomputingtest.ddns.net\/wordpress\/?page_id=87"},"modified":"2026-01-23T02:29:03","modified_gmt":"2026-01-23T02:29:03","slug":"skill-6-the-if-logic","status":"publish","type":"page","link":"https:\/\/bisp-digital-literacy.com\/?page_id=87","title":{"rendered":"Skill 6 &#8211; The Final Challenge: Theme Park Tycoon"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">\ud83c\udfaf The Goal<\/h3>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"has-pale-cyan-blue-background-color has-background\"><strong>I can use my spreadsheet skills to design, budget, and manage a world-class Theme Park within a fixed budget.<\/strong><\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udcd6 The Walkthrough: You are the Manager!<\/h3>\n\n\n\n<p>You have been given <strong>\u00a31,000,000<\/strong> (1 Million) to open a brand-new Theme Park. However, running a park is expensive! You need to buy rides, hire staff, and make sure you still have money left for advertising.<\/p>\n\n\n\n<p><strong>Your mission is to create a master budget that proves your park will be profitable.<\/strong><\/p>\n\n\n\n<p>To succeed, you must use:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Skill 2:<\/strong> Professional formatting and currency symbols.<\/li>\n\n\n\n<li><strong>Skill 3:<\/strong> Basic math to calculate &#8220;Total Cost&#8221; (Price x Quantity).<\/li>\n\n\n\n<li><strong>Skill 4:<\/strong> Functions (<code>SUM<\/code>) to find the grand total and (<code>MAX<\/code>) for your biggest expense.<\/li>\n\n\n\n<li><strong>Skill 5:<\/strong> A Chart to show the Board of Directors where the money is going.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udce5 The Starter File<\/h3>\n\n\n\n<p>Download the <strong>&#8220;Theme Park Builder&#8221;<\/strong> spreadsheet below. It has a list of available rides and staff, but the finances are a mess!<\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-16018d1d wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1gvVoqt6i6XBNpoprUj4CGkrPX7cwvEE4e9CqNeEOR4A\/copy?gid=507107281#gid=507107281\">Download Theme Park Builder<\/a><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u2705 The Checklist: Your Task<\/h3>\n\n\n\n<p>Open your spreadsheet and complete these milestones:<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Format for the Board:<\/strong> Make your headers bold, add &#8220;Steel Blue&#8221; fill colors, and ensure all money columns are set to <strong>Currency (\u00a3)<\/strong>.<\/li>\n\n\n\n<li><strong>Calculate Costs:<\/strong> For every item (like Rollercoasters or Security Guards), multiply the <strong>Price<\/strong> by the <strong>Quantity<\/strong>.<\/li>\n\n\n\n<li><strong>The Grand Total:<\/strong> At the bottom, use the <code>=SUM<\/code> function to calculate the total cost of building your park.<\/li>\n\n\n\n<li><strong>The Budget Check:<\/strong> In a new cell, subtract your Grand Total from your <strong>\u00a31,000,000 budget<\/strong>.\n<ul class=\"wp-block-list\">\n<li><em>Warning: If the number is negative, you are bankrupt! You must change your quantities until you are under budget.<\/em><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Analyze:<\/strong> Use <code>=MAX<\/code> to identify your most expensive investment and <code>=AVERAGE<\/code> to find the average cost of a ride.<\/li>\n\n\n\n<li><strong>The Visual Pitch:<\/strong> Create a <strong>Pie Chart<\/strong> showing the categories: <em>Rides, Staff, and Facilities.<\/em><\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83c\udfc6 Level Up! (Extension)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Ticket Sales:<\/strong> If you charge <strong>\u00a340 per ticket<\/strong>, how many people need to visit your park before you make your \u00a31,000,000 back? (Hint: Budget \/ Ticket Price).<\/li>\n\n\n\n<li><strong>Conditional Formatting:<\/strong> Make the &#8220;Budget Remaining&#8221; cell turn <strong>Bright Green<\/strong> if you have more than \u00a350,000 left.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udce4 Test Your Knowledge<\/h3>\n\n\n\n<p>Once you have completed the tasks click the button below to take the quiz for this skill.<strong>Remember to select Final in the first question !<\/strong><\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-16018d1d wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-text-align-center wp-element-button\" href=\"https:\/\/forms.gle\/o6zeXt9zpYXtUBvv9\">Skills Quiz<\/a><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ud83c\udfaf The Goal I can use my spreadsheet skills to design, budget, and manage a world-class Theme Park within a fixed budget. \ud83d\udcd6 The Walkthrough: You are the Manager! You&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":75,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-87","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bisp-digital-literacy.com\/index.php?rest_route=\/wp\/v2\/pages\/87","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bisp-digital-literacy.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bisp-digital-literacy.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bisp-digital-literacy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bisp-digital-literacy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=87"}],"version-history":[{"count":7,"href":"https:\/\/bisp-digital-literacy.com\/index.php?rest_route=\/wp\/v2\/pages\/87\/revisions"}],"predecessor-version":[{"id":165,"href":"https:\/\/bisp-digital-literacy.com\/index.php?rest_route=\/wp\/v2\/pages\/87\/revisions\/165"}],"up":[{"embeddable":true,"href":"https:\/\/bisp-digital-literacy.com\/index.php?rest_route=\/wp\/v2\/pages\/75"}],"wp:attachment":[{"href":"https:\/\/bisp-digital-literacy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=87"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}