1 / 8

AO5 Modelling

AO5 Modelling. Can I explain what a model is? Can I create a model?. How does a spread sheet model?. Biscuit model. eTunes model.

andra
Download Presentation

AO5 Modelling

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. AO5 Modelling Can I explain what a model is? Can I create a model?

  2. How does a spread sheet model? Biscuit model

  3. eTunes model You have been asked by the director of website called eTunes to create a model to track downloads of their music tracks and predict how much money they will make.

  4. Enter the following in Excel and add suitable title and formatting

  5. Task 2: Adding Formula Now you have set up your data, in the next column, work out a formula that will calculate how much income is made from each of the songs. Use the SUM function to calculate the total amount of income made. Use the AVERAGE function to work out the average number of downloads made. Print your draft model and label it draft 1

  6. eTunes want to work out how much commission they are making from selling music downloads. Currently eTunes get a 9% commission for each song downloaded. Can you enter a formula to calculate how much commission eTunesrecieves.

  7. Task 3: Formatting your Spreadsheet • You can now spend 5-10 minutes formatting your spread sheet so that it looks professional and is easy to read…remember, it will probably be printed in black and white. • You should think about: • Text Style, size and Colour • Background Colour • Borders • Currency Task 4: Headers and Footers It is important to know who had produced the spreadsheet, when it was printed, how many it pages it has etc…  Put your name, and the date in the header and the page number in the footer. Print your draft model and label it draft 2

  8. Task 5: Adding missing data eTunes left off 4 artists and their sales, add the following artists to your model.

More Related