Click on this LINK  to complete the powerpoint Yacapaca test. 

WEEK 9 – 3^rd November

9.1 Lesson 9 Mayhem Manor: Presenting Findings. 

LEARNING OBJECTIVES

In today’s lesson you will learn how to;

• Create a presentation for a specific audience and purpose.
• Evaluate the presentation. 

STARTER: Elements that make an Effective Presentation. 

Grab a white board, pen and cloth.  Work in pairs.  Watch the presentation for the Sun Seekers Holidays Annual Sales Conference (Reso9a).  Jot down on your white boards the elements that make an effective presentation. 

The presentation has been designed to show the managers of a company (the audience) how they preformed against their objectives for the year (the purpose).  Watch the presentation for the Sun Seekers Holidays Annual Sales Conference (reso9a) again.  Jot down on your white boards why each element listed is appropriate for that audience and purpose. 

TASK 1 Assessing Audience

Your audience is the Board of Directors.  These are very important people who own the theme park, so what they think counts!  They will expect to see a very professional, clear presentation that gives them the information they need.  Your audience will affect your design choices. 

Open the Designing for Audiences worksheet (Reso9b).  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to name dialogue box.  Call the document “Designing for Audiences”.  Work in your pairs.  Look at the table and decide which of the design elements on the left would be appropriate for a presentation to the Board of Directors, and which you would not use.  Make a comment about why you have made each choice 

TASK 2 Plan a Presentation. 

Read the following presentation brief from Ms Thora Thunders, the senior manager at Mayhem Manor Theme Park;

Key things that the presentation must include:

1. A chart comparing the projected and actual sales figures for this year
2. Financial model showing projected costs and revenue, including any additional money-making activities
3. At least two predictions and recommendations based on the model

Additionally:

• The presentation should include a title slide including one image of the big wheel
• All slides should contain the theme park banner image (you can find this in CD Resource 9d – Big wheel images)
• Each slide should be self-explanatory; therefore all charts and tables must be annotated to explain exactly what they are showing.

Design features

Design of the presentation should be clear and professional, using appropriate fonts and colours.

The directors will be asking questions about the information you give in the presentation, so be prepared to answer them!

You will also need your financial model and charts you created in Lesson 7 and your predictions and recommendations from Lesson 8. 

1. Create a plan for your presentation using the squared paper and the coloured post-its.  It should show the content of each slide.  It should show the order of the slides.  Use images from the image bank (Reso9d). 

EXAMPLE of a tabular plan:

Record Company Presentation
Slide 1	Title slide.  Title and subtitle; picture of band; sound clip of the new single
Slide 2	Description of the band and music; photo from gig
Slide 3	Bar chart showing position in download chart
Slide 4	Table showing profit the band made

1. Use the presentation brief to check your partners plan.  Look at each bullet point in turn and check that your partner’s presentation answers that point.  If the answer to any point is NO then help them to address that problem. 

TASK 3 Create a NEW Presentation. 

Open PowerPoint and save the new presentation into your Presentation folder, which is within your Unit 9.1 Mayhem Manor folder.  Call the presentation “Predictions and Recommendations”.  Change to Note Page view and add your name, form and group to the FOOTER (View / Header and Footer / Footer / Apply to All). 

TASK 4 Create your Slide Design. 

Before you add your content, decide on the colours and fonts you want to use.  (Make sure that you have added this in your plan!)  It is best to do this using the Slide Master.  To open the Slide Master, choose View / Master / Slide Master. 

To change the background colour, choose Format / Background and select a colour or fill effect from the drop-down menu.  Click on Apply to All if you are happy with the colour you have selected. 

REMEMBER: any colours, fonts and images you put on the Slide Master will automatically be placed on all slides in your presentation. 

To go back to your slides, choose Close Master View o the Slide Master toolbar. 

TASK 5 Inserting Charts and Tables

To insert a chart onto a slide, find the chart and click on it to select it.  Then choose Edit / Copy. 

Go to your presentation document and find the slide where you want to place the chart. 

Choose Edit / Paste.  The chart will be inserted into the slide.  You can move the chart around and resize it if you need to. 

You can do the same with tables. 

If you want to edit anything in a table or chart, double click on it.  This will open the object as an editable object. 

TASK 6 Inserting Text and Screenshots

You can copy and paste text and screenshots from the report you created in the last tutorial. 

Make sure the slide layout is set to Titles and Text by choosing Format / Slide Layout. 

Then find your text, and copy and paste it into the text box.  You may need to resize the text or change the font colour so that it is clear and readable. 

TASK 7 Insert Images

You can use the images from the images bank (Reso9d) to make your slides more attractive. 

REMEMBER No more than TWO images per slide. 

TASK 8 Are you following the presentation brief?

Take a look at the presentation brief (Reso9c) which is displayed on the white board.  Now take a look at your buddy’s presentation.  Does your partner’s presentation answer each point on the brief? 

On your printed copy of the presentation brief;

1. tick off the objectives that have been answered satisfactorily
2. circle or highlight any points that have not been answered.

Now continue with your own presentation focusing on the points your buddy has circled. 

TEST YOURSELF

I would like 4 volunteers to present their presentations to the class.  The remainder of the class must be members of the Board of Directors.  You must be prepared to ask sensible questions about the information given in the presentations. 

EXTENSION WORK

Search the Internet for an advert / poster that you particularly like.  It must be advertising something and must include both text and pictures.

WEEK 8 – 20^th October

9.1 Lesson 8 Mayhem Manor: Testing Predictions and Reporting Back. 

LEARNING OBJECTIVES

In today’s lesson you will learn how to;

• Experiment with a model to test scenarios and predictions. 

Starter:

Grab a white board, pen and cloth.  Work in pairs.  Look at Starter model (Reso8a).  Consider each of the following scenarios;

1. Would it be better if we sold Queue-jumpers at half-price, but increased Season tickets to £130.00 each?
2. The Met Office is predicting really bad weather in August.  What will happen to our profit if we only sell half as many tickets in that month?
3. If that happens, will it help us to open the park in October, assuming that we sell the same amount of tickets as in April?
4. If we run a TV advertising campaign, we think we can sell twice as many tickets.  However, it will cost £250,000.  Is it worth doing?

Jot down on your white boards what you might predict would happen in real-life situations.  Guestimate!  You do not need to test these yet! 

• Why is it hard to guess what some outcomes might be? 

Making predictions is one of the most useful aspects of spreadsheet models.  You will now use your model to predict what will happen in the situations listed above. 

Task 1 Using a Model to Predict Results.

Open a copy of Starter model (Reso8a).  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the header (View / Header and Footer / Custom Header).  Call the spreadsheet Predictions using Starter Model. 

Look at the presentation Manager’s questions to remind you what the predictions are. 

Make a copy of Sheet 1 (Hold the Ctrl button, click on the Sheet 1 tab and drag it to the right with the mouse. 

Rename Sheet 1 copy, Queue-jumpers by double clicking on it and typing in the new name. 

Make three more copies of sheet 1.

Rename each one;

• August
• October
• TV advert

Work in pairs.  Jot down on your white boards HOW each question could be tested by changing variables and rules.  Let’s pool our thoughts!

Task 2 Change Variables to Test a Prediction

Open Queue-jumpers sheet.  Make a note of the Profit / Loss figure on your white board.  Change the variables for the price of the Queue-jumpers and Season tickets.  Make a note of the new Profit / Loss.  Is it more or less than before?  Can you answer question 1 now? 

Open Word.  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the header (View / Header and Footer).  Call the document Predictions using Starter Model.  Type in question one – “Would it be better if we sold Queue-jumpers at half-price, but increased Season tickets to £130.00 each?”  Then type in your answer to question one.  Then paste a screenshot of your revised model (Queue-jumpers). 

Task 3 Whether the weather is hot, or not…

Don’t be distracted by irrelevant information – what will happen to the Profit / Loss figure if half the number of tickets is sold in August?  Open August sheet.  Make a note of the Profit / Loss figure on your white board.  Change the relevant variables.  Make a note of the new Profit / Loss.  Is it more or less than before?  Can you answer question 2 now? 

Type in question two – “The Met Office is predicting really bad weather in August into.  What will happen to our profit if we only sell half as many tickets in that month?”, your word document  Then type in your answer to question two.  Then paste a screenshot of your revised model (August). 

Task 4 Add New Variables and Revise Rules

Open October sheet.  Add a new column for the October sales figures.  Then copy and paste the figure from April.  Revise the formulae for total ticket sales to include October figures.  Make a note of the Profit / Loss figure on your white board.  Change the relevant variables.  Make a note of the new Profit / Loss.  Is it more or less than before?  Can you answer question 3 now? 

Type in question three – “If that happens, will it help us to open the park in October, assuming that we sell the same amount of tickets as in April?”, into your word document  Then type in your answer to question three.  Then paste a screenshot of your revised model (October). 

Task 5 Change formulae to Test a Prediction. 

Open TV advert sheet.  Change the costs table to include the new cost, and revise the formula for total costs.  The easiest way to show the new ticket sales is to adapt the formula for total ticket sales.  What would the new formula have to include in order to show double the current ticket sales?  Experiment with the formula, and test that it works with a calculator. 

Type in question four – “If we run a TV advertising campaign, we think we can sell twice as many tickets.  However, it will cost £250,000.  Is it worth doing?”, into your word document.  Then type in your answer to question four.  Then paste a screenshot of your revised model (TV advert). 

Task 6 Predictions and recommendations

Work in pairs.  Jot down on your white boards any recommendations you would make to the manager.  Let’s pool our ideas – Are you surprised by any of the results? 

You will now create a formal report to present to the manager outlining your recommendations. 

Open Word.  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the header (View / Header and Footer).  Call the document Predictions using Starter Model.  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the header (View / Header and Footer).  Call the document Predictions and recommendations.  Outline your four predictions and the recommendations that you would make.  Here is an example answer for Scenario 1 – If Queue-jumpers are reduced to £5.00 and Season tickets are increased to £130.00, profit goes down (£23,485 instead of £25,445.00).  Therefore, I would recommend leaving the price of Queue-jumpers and Season tickets as they are, because changing them would result in the park making £1960.00 less profit.  Now do the rest yourself. 

TEST YOURSELF

Work in pairs.  Explain to your partner your predictions and recommendations for the four scenarios.  Now I would like four set of volunteers.  Each group will to go through their prediction and recommendation for one of the scenarios, on the white board and explain them to the class. 

EXTENDED TASK

Open the Email to manager document.  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the header (View / Header and Footer).  Call the document Email to manager.  Use your Predictions and recommendations to write a formal email to the manager.  REMEMBER to add your name to the footer (View / Header and Footer).  Print your work to the KC2mono printer.

WEEK 7 – 13^th October

9.1 Lesson 7 Mayhem Manor: Making and Interpreting Charts

 

LEARNING OBJECTIVES

In today’s lesson you will learn how to;

• Create a chart to represent two data series. 
• Interpret a chart and draw conclusions. 

 

Starter: Interpreting Charts. 

Grab a white board, pen and cloth.  Work in pairs.  Look at Chart Starter.  Jot down on your white boards what you think the data on the chart represents.  (HINT: Look at the y-axis values – these are too high to represent temperatures.  What else might they be measuring?) 

Look at Sheet 2.  This chart shows the number visitors per month to Mayhem Manor over two years.  On your white boards jot down the answers to the following questions;

1. What happens in January at the theme park?
2. When did the theme park close last year?
3. When does the theme park close this year?
4. What was the busiest month last year?
5. What happens one month later this year than last year?
6. Is the theme park making more or less money this year?
7. Is this chart the best chart type to show this data?  
8. What other chart type could be used?

 

Task 1 Chart Types.  

The Big Wheel has now been running for six months.  Your task is to create a chart to compare the actual with the projected ticket sales for the last six months.  Work in pairs.  Jot down on your white boards;

• Which chart type would be the most useful for presenting the information? 
• Why are charts good for comparing datasets? 

 

Task 2 Creating a Comparative Bar Chart. 

Open Mayhem Manor Sales Figures spreadsheet (Reso7b).  This contains two tables – Table A contains the projected sales figures for the theme park and Table B contains the actual figures.  To create a chart using discontinuous cells (total sales figures from both tables and these are not next to each other), then you need to use the Ctrl key with the mouse to select only the correct data.  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the header (View / Header and Footer / Custom Header).  Call the spreadsheet Mayhem Manor Sales Figures.

1. Select the total figures for the projected and the actual sales (row 10 and 18).  REMEMBER to hold the Ctrl key down.  Choose Insert / Chart to open the Chart Wizard. 
2. On Step 1 of the wizard, select a chart type.  Which chart type will give you the best results?  Some charts won’t give you any useful information.  They just look pretty!  Choose Press and Hold to View Sample to see what your chart will look like.  Select one that shows the data clearly, and then click on Next. 
3. In Step 2 select the Series tab.  This screen allows you to name the data series.  Click on Series 1 and then in the first text entry field, type Projected figures.  Click on Series 2 and in the text entry field, type Actual figures. 
4. In this screen you can also change the x-axis labels to show months instead of numbers.  Go to the bottom of the screen and click the red, white and blue button (Collapse dialogue button) on the right of the text entry field.  The Wizard will minimise allowing you to select the labels from your table.  Select the cells Apr – Sep at the top of Table A.  Click on the Collapse dialogue button to return to the Wizard. 
5. Go to Step 3 of the Wizard.  Here you can add titles for your chart, and for the x- and y-axes.  Title the chart Mayhem Manor Sales Figures: Projected versus Actual.  Label the y-axis, Number of Tickets Sold. 
6. Sometimes it is useful to look at a table and chart together.  In Step 4 of the Wizard, choose to place the chart As object in Sheet 1 and click on Finish. 

 

Task 3 Analysing your Chart. 

Work in pairs.  Take a good look at your completed charts.  Jot down on your white boards;

• What conclusions can you draw from the completed chart? 
• Were the predictions accurate? 
• Are the actual figures better or worse than the projected figures? 
• What are the implications for the theme park? 
• How could you increase ticket sales? 

 

Task 4 Adding a Third Data Series to your Chart. 

You can find a data table on Sheet 2 of the Mayhem Manor Sales Figures spreadsheet.  Try to work out how to do this on your own.  If you have difficulties, use worksheet Adding a series to a chart (Reso7c) to help you. 

 

TEST YOURSELF

Look at the Plenary Chart.  Work in pairs.  You minutes have five to prepare a statement to give to the manager of the theme park, explaining what the chart shows.  One person in each pair must read the statement you have agreed to the class. 

 

EXTENDED TASK

Print preview your chart to make sure that your name is in the Header.  To add your name to the header, choose View / Header and Footer / Custom Header.  Print your chart to the KC2mono printer.  Write an email to the park manager, explaining why she needs to increase ticket sales.  Give her some suggestions on how she might do this.  Send a copy of this email to me at l.munro@shr.gdst.net

continuing lesson 5…

2 Stars and 1 wish

Look at your buddy’s financial model.  Tell them 2 things that they have done well.  Can you suggest one improvement to their work? 

Before we print your spreadsheet we are going to add some annotation.  Use text boxes to label an example of  a variable and a rule.  Use more text boxes to explain some of the formulae you have used. 

WEEK 6 – 6^th October

9.1 Lesson 6 Mayhem Manor: Refining a Financial Model

 

LEARNING OBJECTIVES

In today’s lesson you will learn how to;

• Interrogate a model using Goal Seek. 
• Add new variables and rules to a model. 

 

Starter: Comparing Competitor Prices. 

Grab a white board, pen and cloth.  Work in pairs.  Open your Competitor Analysis extended task and find the information about different theme park prices.  Jot down on your white boards the prices of three or four different parks. 

Open your copy of your Financial Model for Mayhem Manor.  Look at your ticket prices.  Are Mayhem Manor’s ticket prices comparable with their competitors?  What do you feel would be reasonable new ticket prices? 

 

Task 1 Using Goal Seek

Look at my copy of the Theme Park Financial Model. 

How would you find out what the price of a standard ticket should be in order to break even?  (HINT: By changing the price of the ticket to arrive at a zero profit / loss figure). 

At the moment the ride is making a loss, so you need to increase the standard adult ticket price so that the ride breaks even.  (Break-even – the point at which the costs and revenue balance exactly.  The profit is zero). 

 

Open your copy of the Theme Park Financial Model.  Use Goal Seek (Tools / Goal Seek) on the cell containing the Profit / Loss value to work this out.  The Set cell field should display the cell reference for the Profit / Loss value.  Type 0 (zero) into the To Value field.  Type the cell reference of the cell showing the standard adult ticket price in the By changing cell field.  Click OK.  A new dialogue box appears telling you that Goal Seek has found a solution.  Click OK.  Look at the cell showing the standard adult ticket price.  It should now show a new figure. 

 

Task 2 New Money Making Activities. 

Work in pairs.  Look at your Competitor Analysis extended task.  Jot down on your white boards some ways in which theme parks generate income apart from ticket sales. 

 

Open the Additional Money Making Activities worksheet (Reso6b).  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the NAME dialogue box.  On the worksheet are listed two suggestions for additional activities that could generate revenue for Mayhem Manor.  For each activity, add a suggested cost, a suggested unit price (that is the price you sell it for) and unit sales (number you think you will sell) for each month.  Add at least one further idea for a money-making activity relating to the big wheel, and suggest the cost, price and unit sales per month. 

 

Task 3 Adding your Extra Activity / Product to your Model. 

Look at my copy of the Theme Park Financial Model. 

How would you add this new information into your model?  (HINT: Add the cost first, and then complete the revenue section.  You may need to revise your formulae to include the new information.) 

 

On your copy of the Theme Park Financial Model add rows to include one of your ideas for making more money.  Click in the row above where you want to place the new row and choose Insert / Rows.  Type in the name of the new activity / product in the first column, and add the cost you have allocated to it in the second column. 

 

Do the same thing in the revenue table, adding the price at which you will sell the activity / product and the unit sales that you have forecast per month.  You may want to add a subtitle Extras above the new row to show that it is separate from the ticket sales section.  This separate section will make the financial model much easier to understand. 

 

You may need to change the formulae for Total Costs and Total Revenue to accommodate the new variables you have added.  Start with your Costs section.  Double click on the Total Costs formulae and check that the selection within the blue border includes the new cost.  If it does not, drag on the handles to include the new value, and then press Enter.  Do the same for the Total Revenue formula.  You do not need to change the Profit / Loss formula. 

 

Task 4 Exploring the Impact of your New Variable. 

Open Word.  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the header (View / Header and Footer).  Call the document Impact of New Variable.  Take a screenshot of your revised financial model and paste it into your new word document.  Under your screenshot write a paragraph that answers the following questions;

• How much profit does your product or activity make? 
• Do you think this is a good profit? 
• How could you make it higher? 
• What happens if you sell only half as many as you have predicted? 
• How many do you need to sell to break even? 

You will need to use your spreadsheet to test some of these scenarios.  REMEMBER: You can use Goal Seek to find out how many unit sales are needed to make a given profit.  

 

TEST YOURSELF

Work in pairs.  Look at the Plenary Spreadsheet (Reso6c).  Jot down on your white boards the formulae I need to complete the financial model.  Now jot down on your white boards the answers to the following questions;

1. What are the total costs for all planned new rides?
2. What is the profit or loss made by the theme park?
3. What would you suggest the manager needs to do in order to break even?
4. If the ticket prices are all made 10% higher, do you think the theme park will break even?  How would you test this?
5. If sales of tickets to the park increase by 5%, do you think the theme park will break even? How would you test this?
6. How might the manager increase ticket sales?
7. What problems might the theme park have if the prices are increased a lot?

Now try this Goal Seek question;

1. What percentage do ticket sales need to increase by if the theme park is going to break even?

WEEK 5 – 29^th September

9.1 Lesson 5 Mayhem Manor: Building a Financial Model

 

LEARNING OBJECTIVES

In today’s lesson you will learn how to;

• Identify information needed for a specific purpose. 
• Recognise inputs and outputs in a model. 
• Design and create a financial model from scratch. 

 

Starter: Mayhem Manor Sandwich Shop Wages

Grab a white board, pen and cloth.  Work in pairs.  Jot down on your white boards the answers to the following questions;

 

1) What is the purpose of this model? 

2) To whom would this model be useful?  

3) What are the inputs? (what data must be put in?) 

4) What are the outputs from the model? (what information do we get out of the model) 

5) Which cells contain variables? 

6) Which cells contain formulae? 

7) What would the rules of this model be? 

What would happen if the pay per hour was increased by £1 for everyone? What would change?  Why? 

9) Can you spot a mistake that happened during data input? What do you think this figure should be? How would you check it? 

10) With the mistake rectified, how much profit does the shop make? Is this good or bad? 

11) How could you find out what the shop takings would need to be in order to make £1000 profit?  (HINT: Goal Seek)

 

Task 1 Financial Model Brief 

Work in pairs.  Open the Financial Model Brief (Reso5b).  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the footer (View / Header and Footer).  Read the brief carefully.  Use the highlighter in MS Word to do the following;

• Highlight in GREEN all information that the manager wants to get from the model (OUTPUTS). 
• Highlight in PINK all information that you need to put into the model (INPUTS). 

 

Task 2 Financial Model Planning

Open the Financial Model Planning sheet (Reso5c).  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the NAME dialogue box. 

1. Complete the table to show what information the manager needs to get out of the model you create (outputs).
2. Complete the tables with the information you will need to put into the model (inputs).  An example has been added for you. 
3. You need to know how much money is coming into the theme park each month (revenue).  You know the ticket prices, but what other information do you need to work out the revenue? 

The manager will need to send you this information.  Open the Theme Park Data (Reso5d).  Copy and paste the table into your planning sheet. 

 

Task 3 Creating the Financial Model in Excel. 

1. Open an Excel spreadsheet.  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the footer (View / Header and Footer / Custom Footer).  Call the spreadsheet Theme Park Financial Model. 
2. Build a COSTS table, with column headers and inputs.  Include the formula to calculate the Total Cost. 
3. Build a REVENUE table.  Add ticket types and prices.  Add monthly ticket sales.  Include the formulae to calculate you outputs (Total Ticket Sales, Revenue, Total Revenue and Profit / Loss). 
4. Open Financial Model Screenshot document (Reso5f) to check your work.  REMEMBER, your model doesn’t have to look exactly like this one, but the figures must match.  Cells that contain formulae are coloured pale yellow.

TEST YOURSELF

Work in pairs.  Show your financial model to your partner. 

• Does the model work? 
• Can it be improved in any way? 

 

EXTENDED TASK

Complete the competitor research extended task that you were given.  Make sure that all of the information you have is save din one folder called Competitor Research.  You need this information in the next lesson.

WEEK 4 – 22^nd September

9.1 Lesson 4 Mayhem Manor: Main Routines – Sensors and Safety

 

LEARNING OBJECTIVES

In today’s lesson you will learn how to;

• Understand the use of sensors in a system. 
• Identify safety issues and possible ICT solutions. 
• Create a program and add a safety feature. 

 

Starter – Automatic Door Flowchart. 

1. Watch the presentation Sensors and Flowcharts (Reso4a) – slides 1 – 7. 
2. Open the Automatic Door Flowchart (Reso4b).  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the NAME dialogue box.  Work in pairs.  Arrange the flowchart symbols to build a working program to control an automatic door.  Add lines or arrows to show the order in which each instruction is carried out.  Then add loops to show how the system repeats, or goes back to check something.  You will need to add your own lines or arrows to do this.  REMEMBER: Your door must be safe, and not trap anyone in it! 
3. Watch the presentation Sensors and Flowcharts (Reso4a) – slide 8. 

• What is the problem with this solution? 
• How could you change it?

(HINT: You must make sure that your program has a safety feature. 

1. Watch the presentation Sensors and Flowcharts (Reso4a) – slide 9. 

• Compare your solution to the one shown on slide 9. 

 

Task 1 Mind Map Safety Issues. 

Grab a white board, pen and cloth.  Work in pairs.  On your white boards sketch a mind map of safety issues relating to a big wheel.  Think about fairground rides you have been on to help you think of ideas.  Expand your mind map to include possible solutions to each problem. 

 

Task 2 Controlling the Movement of the Wheel. 

Open Flowol.  Open Big Wheel Mimic. 

• Which elements of this mimic can be controlled? 
• Which could be used to increase safety? 
• What are these elements named? 

REMEMBER: an input puts something into the system – in this case it tells the wheel whether to move or not. 

HINT:  There are two components in the mimic that are essential for controlling the movement of the wheel, and one that is needed for safety. 

 

Task 3 Planning the Wheel Movement. 

Open the Wheel Movement Design Sheet (Reso3b).  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the NAME dialogue box.  Work in pairs.  Write the instructions that will control the wheel.  REMEMBER: Input 2 is a switch that turns the ride on and that input 3 (gate) must be closed before the wheel will start turning (Mot A). 

 

Task 4 Create the Movement Program

Open Flowol.  Open your Lights Program.  Create the new Movement Program on the same page, next to the lights program.  Don’t add the safety feature yet. 

 

Task 5 Adding a Safety Feature

You should now have a program that allows you to make the wheel turn by clicking on Input 2 on the Big Wheel Mimic (Input 1 controls the lights).  When you click Input 2 off, the wheel should stop turning. 

The gate is a safety element in the Big Wheel Mimic.  You need your program to tell the wheel to move ONLY if both Input 2 and Input 3 (the gate) are on.  If one of these components is switched off, the wheel should stop moving. 

To add the gate safety feature, you will need to insert a new symbol into the flowchart.  Click on the symbol you want to add on the left-hand toolbar, and then click on your flowchart in the place where you want to add the symbol.  Use the grey prompt box to program it.  

You will need to draw new lines to connect the symbols together.  To remove lines or boxes use the Edit tool, then click on the line or symbol you want to remove.  Finally, click on the Erase tool. 

There is more than one safe solution to include the gate input.

Task 6 Annotating your Flowcharts. 

To annotate programs, use the Add Label tool.  Annotate each process box and any loops to explain what each part of the program is doing. 

 

TEST YOURSELF

I am going to divide you into four or five teams.  Each team will have a copy off the quiz.  Answer the questions for ROUND 1.  Swap sheets with another team to mark your answers.  Swap back.  Answer the questions for ROUND 2.  Swap sheets with another team to mark your answers.  Swap back.  Answer the questions for ROUND 3.  Swap sheets with another team to mark your answers.  Swap back.  Answer the tie break question.  Swap sheets with another team to mark your answers.  Swap back. 

 EXTENDED TASK

Continue the competitor research extended task that you were given.

continuiing lesson 2…

Open your copy of Subroutine Design Sheet. 

Open Flowol3 and your program LIGHTS1.  Please ensure that you have built Flash1 and Flash2.

WEEK 3 – 15^th September

9.1 Lesson 3 Mayhem Manor: Main Routines – Inputs and Decisions

 

LEARNING OBJECTIVES

In today’s lesson you will learn how to;

• Create a flowchart to represent the big wheel system. 
• Create a main routine and subroutines using Flowol. 

 

Starter – Big Wheel mimic labels

Open the Big Wheel mimic labels (Reso3a).  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the NAME dialogue box.  Work in pairs.  Open Flowol and then open the Big Wheel Mimic.  Label the screenshot of the Big Wheel mimic, explaining what each of the inputs, outputs and motors do.  The monitor bar at the bottom of the Flowol screen will help you do this. 

 

Task 1 Inputs and Decisions

Open Big Wheel Mimic.  Click on Input 1.  Now click on Input 2.  Grab a white board, pen and cloth.  Work in pairs.  Jot down on your white boards;

• “What does an input do?” 

Using these two inputs you can control the light subroutines that you have already created.  First you need to build a main program.  Input 1 will become a switch which turns the lights on and off, when it is clicked.  When adding inputs to a program, the Decision symbol is normally used because the program needs to ask itself a question at this point: “Is Input 1 on?” 

When you draw a line from the decision symbol, two options are given – YES and NO.  Think about your subroutines.  Work in pairs.  Jot down on your white boards;

• “What should happen for option YES?” 
• “What should happen for option NO?”

 

Task 2 Planning Main Routine

Open the Main routine Design Sheet (Reso3b).  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the NAME dialogue box.  Work in pairs.  Use the table to design your main program to control the lights on the Big Wheel.  You will need to add your two subroutines to the program. 

 

Task 3 Creating the Main Program in Flowol

1. Open your subroutine document.  You will need to build the main program next to your subroutines.  The main program always begins with a Start symbol, called the terminator (“ender”).  Click on the symbol in the left-hand toolbar, the click on the page.  In the grey prompt box, click on Start, and then OK. 
2. The program needs to know when to switch the lights on.  Add the Decision symbol after the Start symbol.  The program needs to ask the question: “Is the light switched on?” The Decision symbol will have two lines coming from it, a YES line and a NO line.  In the grey prompt box, program the symbol to ask the question: “Is Input 1 on?” 
3. Make sure that the subroutines are named correctly – Sub Flash 1 and Sub Flash 2.  Add the subroutine to the main routine by using a Process box.  In the grey prompt box, choose Sub, select Sub Flash 1, and then tell it to repeat twice.  Click OK.  Add the second subroutine in the same way. 
4. Once you have added all the symbols, you need to join them together using the Add Line symbol.  Click on the Add Line symbol, then on the first symbol, then on the symbol you want it to go to next.  The line will be drawn between them. 
5. When you click on the Decision symbol you will be given two options.  The YES option tells the program what to do if the switch is ON.  The NO option tells the program what to do if the switch is OFF.  If the answer is YES then the program needs to play the subroutines. 
6. A loop is a line which goes back to an earlier part of the program.  This allows a small section of a program to be repeated, and allows programs to run more efficiently than if you had to write the instruction again each time.  When the answer to the Decision symbol is NO, the program needs to go back and keep checking to see if the switch has been turned ON.  Select the Add Line symbol, and then click the Decision symbol twice.  The loop will be drawn to go back on itself. 
7. You need to tell the program to keep the lights flashing until they are turned off.  You do this using a loop.  This will make the program run continuously until you tell it to stop by clicking Input 1 off on the BIG Wheel Mimic.  Draw a line from the last symbol back to the Decision symbol.  Click Add Line symbol, then click on the last box in your program, and then click on the Decision symbol.  A loop will be drawn in your program. 

TEST YOURSELF

Watch the Lights Program (Reso3c).  Work in pairs.  Can you explain to your partner what the program is doing at each point?  Can you suggest ways in which the subroutine Sub Flash 2 could be made more efficient?  (HINT: More than one instruction can be placed in output symbols.) 

 

EXTENDED TASK

Begin the competitor research that you were given in the previous lesson.

continuing lesson 1…

Task 3 Creating a File Structure. 

Within your Unit 9.1 Mayhem Manor folder create a folder structure to save the documents you will create during the project.  You will need a folder for each task.  Subfolders could be:

1. Planning / Planning documents / Project planning or similar
2. Control or Control documents or Flowol files or Big Wheel program or similar. 
3. Finances or Financial model or Spreadsheet files or similar. 
4. Presentation or Presentation files or PowerPoint files or similar. 
5. Posters or Poster files or Publisher files or Advertising or similar. 

 

Task 4 Inputs, Processes and Outputs. 

Grab a white board, pen and cloth.  Work in pairs.  Jot down on your white boards what you understand by the following terms;

• Input
• Process
• Output

Try to give an example for each term. 

 

Open the Inputs, Processes and Outputs (Reso1d).  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the NAME dialogue box.  Work in pairs.  Use your mind map with tasks and sub-tasks listed to decide what inputs, processes and outputs are involved in each of the systems you have been asked to produce.  

 

TEST YOURSELF

Work in pairs.  Choose one of your answers (input, process or output) and explain your choice to your partner.  Compare ideas.  Does your partner agree with you?  Do they have any differences of opinion?  If you need to, amend your work now. 

 

EXTENDED TASK – Competitor Analysis

Open the Competitor Analysis (Reso1e).  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the NAME dialogue box.  Work in pairs.  Insert a table on the worksheet, with six rows and three columns.  Use this table to create a project plan using the tasks listed.  Agree deadlines for each task with your teacher, and write these in the final column.

WEEK 2 – 8^th September

9.1 Lesson 2 Mayhem Manor: Creating subroutines

 

LEARNING OBJECTIVES

In today’s lesson you will learn how to;

• Write subroutines as flowcharts. 
• Create and test a program in Flowol. 
• Identify problems in a program and revise as necessary. 

 

STARTER – Creating subroutines. 

I need 3 volunteers.  Each person will be a colour.  I need you to follow the instructions (Creating subroutines – Reso2a) that I will now show you on the white board. 

This kind of simple sequence can be added into a larger program as a subroutine.  A subroutine is a small part of a larger program and works as a separate program. 

 

Task 1 Design a simple subroutine. 

You need to create subroutines that will control the lights.   The manager wants the lights to flash in two different sequences, to attract the crowds.  You need to create two subroutines – Flash1 and Flash2. 

Flash1 – all the lights flash on and off once at the same time. 

Flash2 – red lights flash on and off, then blue lights, and then yellow lights. 

1. Open the Subroutine design sheet (Reso2b).  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the NAME dialogue box.  Work in pairs; 
   1. Use the table to design a flowchart that makes the red, blue and yellow lights flash on and off once, all at the same time. 
   2. Use the second table to design a flowchart that makes the red lights flash once, then the yellow lights, and then the blue lights.

REMEMBER – Use AutoShapes (Insert / Picture / AutoShapes / Flowchart). 

Also a subroutine always starts with Sub, not Start and ends with Stop. 

 

Task 2 Create a subroutine in Flowol. 

1. Open and read Flowol symbols (Reso2c).  Flowol uses a set of symbols to allow it to tell the computer what type of instruction it is giving.  These symbols are standard, and you can find many of them in Microsoft Word in the AutoShapes menu under Flowchart. 
2. Open Flowol. 
3. Open the Big Wheel Mimic with the labels showing. 

• Which output are the red lights represented by? 
• Which output are the yellow lights represented by? 
• Which output are the blue lights represented by? 

(Clue: Click on the wheel and watch the bottom toolbar). 

1. To start your subroutine, use the Start symbol, but instead of choosing Start, click on Sub. 
2. Name the subroutine Flash1 and click OK. 

 

Task 3 Test your subroutine. 

You cannot run subroutines until they have been added to a main program. 

1. To test your subroutine, replace the first Sub command with Start.  Click on the Sub symbol and in the dialogue, choose Start.  Click OK. 
2. Click on the Run symbol on the left-hand toolbar. 

Does it work as you expected?  Some things that you might have forgotten to include;

• Have you added delays in appropriate places in the program? 
• Have you turned lights off as well as on? 

Task 4 Creating Flash2 Subroutine

Use the second table on your copy of Subroutine design sheet (Reso2b), to create a second subroutine called Flash2.  The second subroutine will be similar to the first, but it will be much longer, because each set of lights needs to come on at a different time. 

REMEMBER: Test your subroutine to make sure that it works, then rename it Sub Flash 2. 

IMPORTANT: Change the first symbol of your subroutine back to Sub and rename (Sub Flash 1) it once you are happy with how it is working.

Task 4 Creating Flash2 Subroutine

Use the second table on your copy of Subroutine design sheet (Reso2b), to create a second subroutine called Flash2.  The second subroutine will be similar to the first, but it will be much longer, because each set of lights needs to come on at a different time. 

REMEMBER: Test your subroutine to make sure that it works, then rename it Sub Flash 2. 

TEST YOURSELF

Show one of your subroutines to another pair of students in the class.  As you go through it explain to them what they can see happening.  If you encountered any problems, explain how you solved them.  If your subroutine is not working correctly, can the other pair suggest how to fix it? 

 

EXTENDED TASK

Continue the competitor research extended task that you were given in the last lesson. 

 

WEEK 1 – 1^st September

9.1 Lesson 1 Mayhem Manor: Identifying Tasks & Folder and File Tidy up

 

LEARNING OBJECTIVES

In today’s lesson you will learn how to;

• Break down a project into sub-tasks. 
• Identify inputs, outputs and processes. 
• Identify information needed to solve a problem. 

 

Task 1 Setting up a New Folder

Mayhem Manor is a small but successful theme park that has started an expansion programme, which involves the building of some new rides.  The biggest challenge for the manager of the theme park is to build the biggest big wheel in the UK! 

As a recognised computer expert you have been asked to design the big wheel and model the costs and revenue.  The manager would also like you to design separate posters for adults and children. 

Within your ICT folder create a new folder called Unit 9.1 Mayhem Manor. 

 

STARTER – Project Brief

Work in pairs.  Open the Project Brief (Reso1a).  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the footer (View / Header and Footer).  Read the brief carefully and identify the key tasks that you have been asked to do.  Use the highlighter in MS Word to make these points stand out. 

 

Task 2 Mind Map

Work in pairs.  Open the Mind Map (Reso1b).  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the NAME dialogue box.  Read through the Project brief (Reso1a) again and highlight the four main tasks in one colour, and sub-tasks in another.  Then complete the mind map by adding the main tasks and the sub-tasks relating to that task.  We will complete the first box as a class. 

 

Task 3 Creating a File Structure. 

Within your Unit 9.1 Mayhem Manor folder create a folder structure to save the documents you will create during the project.  You will need a folder for each task.  Subfolders could be:

1. Planning / Planning documents / Project planning or similar
2. Control or Control documents or Flowol files or Big Wheel program or similar. 
3. Finances or Financial model or Spreadsheet files or similar. 
4. Presentation or Presentation files or PowerPoint files or similar. 
5. Posters or Poster files or Publisher files or Advertising or similar. 

 

Task 4 Inputs, Processes and Outputs. 

Grab a white board, pen and cloth.  Work in pairs.  Jot down on your white boards what you understand by the following terms;

• Input
• Process
• Output

Try to give an example for each term. 

 

Open the Inputs, Processes and Outputs (Reso1d).  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the NAME dialogue box.  Work in pairs.  Use your mind map with tasks and sub-tasks listed to decide what inputs, processes and outputs are involved in each of the systems you have been asked to produce.  

 

TEST YOURSELF

Work in pairs.  Choose one of your answers (input, process or output) and explain your choice to your partner.  Compare ideas.  Does your partner agree with you?  Do they have any differences of opinion?  If you need to, amend your work now. 

 

EXTENDED TASK – Competitor Analysis

Open the Competitor Analysis (Reso1e).  Save this into your Unit 9.1 Mayhem Manor folder.  Add your name to the NAME dialogue box.  Work in pairs.  Insert a table on the worksheet, with six rows and three columns.  Use this table to create a project plan using the tasks listed.  Agree deadlines for each task with your teacher, and write these in the final column.