1 / 18

Do Now

ICT Extended Holiday – Tasks for Year 8 Topic: Introduction to Modelling and presenting numeric data. Do Now. Here are some mathematical symbols that are used in formulae. Write down the name of each symbol and briefly explain what it is used for. Starter Activities.

keaton-hubbard
Download Presentation

Do Now

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ICT Extended Holiday –Tasks for Year 8Topic: Introduction to Modelling and presenting numeric data

  2. Do Now Here are some mathematical symbols that are used in formulae. Write down the name of each symbol and briefly explain what it is used for.

  3. Starter Activities Below is a part of a spreadsheet. On a sheet of paper, copy the data as it appears here and use it to answer the following questions: a) What is the cell reference of the shaded cell? b) What is the column letter of the column containing data? c) What is the cell reference of the cell containing a heading? TRUE OR FALSE d) A vertical line of data in a spreadsheet is called a row e) A horizontal line of data in a spreadsheet is called a column

  4. Learning Objectives • Know how to make up a simple formula for a spreadsheet • Understand what a computer model is. • Understand how models can be used • Use spreadsheet software to create a model • Use the model to ask ‘what if…’ questions.

  5. Keywords • Digits • Data • Models • Test data • Spreadsheet • Formulae • Cell reference • Label

  6. Introduction:What are models and why do we need them? Definition: A model represents how the real thing behaves. Examples include a flight simulator, a computer game, etc. In ICT, spreadsheets can be used to make computer models. These consist of a series of rules and variables (Like in Mathematics) Why models? • It is much cheaper than the real thing • Examples of real life situations can be slowed down to see what happens • Detailed analyses can be carried out • You can alter the input to see what happens to the output • You can ask ‘What if ….?’ questions

  7. Learning Tutorial Click here to access a brief learning tutorial

  8. Task 1 The diagram below shows a simple spreadsheet that a student uses to help budget her money. Reproduce this on a spreadsheet software and answer the following questions: Write down the contents of cell C5 Write down the content of cell D6 For each of the following formulae, say whether it would correctly work out the total of her expenditure. Write Yes or No beside the formula. Formula 1: = D1+D2+D3+D4+D5+D6 Formula 2: = C2+C3+C4+C5+C6 Formula 3: = D2+D3+D4+D5+D6 d) If the cost of food is changed to £22.50, what other cell would change as a result of this ? Write down the cell reference of this cell and the new content of the cell.

  9. Task 2 Here is a spreadsheet used to work out the number and cost of the fireworks in a box. Reproduce this using a spreadsheet software (Ms Excel is recommended) Use simple formulae to calculate the cost of each type of fire work (in cells D3:D7) as well as the Total number of fireworks (Cell C9) and the Total cost of all fireworks (Cell C10) Save your work and print it out on A4 paper (Your print out must include your name. Handwritten information on your print out is not acceptable) 4. On a separate sheet of paper answer the following questions: Write down the formula put in C9 to add up the quantities of fireworks in column C. To find the total cost of Rockets, a formula is needed. Write down this formula and the cell where this will be put A mistake has been made for the price of a Roman Candle. It should be £6.50. This is entered into cell B6. Write down a list of all other cells that will now change as a result. Also, write down the new values in these cells.

  10. PLENARY • Where can you use this skill of presenting numeric data in other subjects? • Give one real-life situation where this will be quite helpful • In not more than two sentences, explain what you understand by the term ‘What if…’

  11. LESSON 2(Continuation of Lesson 1)

  12. Do Now Answer the following questions by putting ticks in the appropriate boxes

  13. Learning Objectives • Know how to make up a simple formula for a spreadsheet • Understand what a computer model is. • Understand how models can be used • Use spreadsheet software to create a model and manage a budget

  14. Keywords • Budget • Overspend • Under spend • Cost • Alterations

  15. Task:Using a spreadsheet model to manage a budget • Reproduce the spreadsheet model in the next slide (use Ms Excel.) • Carry out the instructions that follow and answer the questions.

  16. Keeping Pets with given budget

  17. The Task • Work out the total cost per week for each of the pets • Work out the total cost per week of keeping all the pets. • Roseline’s budget is £50. Enter this in the appropriate cell. • Work out the figure for Under spent/Overspent using a simple formula • For every calculation carried out, write down the formula used on a sheet of paper. • Also, on the same sheet of paper, explain why the figure for Under spent/Overspent is very important to Roseline. • Save your work as you may be asked to bring it to class on resumption.

  18. OUTCOME Students demonstrate learning when they: • create, fill in and analyse simple spreadsheets for specific purposes using simple calculations • present results in a meaningful way. • use a spreadsheet software to explore ‘What if..’ situations by varying input in their model to see the effect on the output. • Make adjustment to budgets using a model

More Related