1 / 8

8.4 – Band Manager Spreadsheets

8.4 – Band Manager Spreadsheets. Mr Farmer. Lesson 3 - Starter. Wiki > Year 8 > Band Manager > Lesson 3 Click the link Read > Scatter > Test. 10 mins. Lesson Objectives. Develop a spreadsheet model by adding additional columns. Use absolute cell referencing to calculate VAT. VAT.

rianne
Download Presentation

8.4 – Band Manager Spreadsheets

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. 8.4 – Band ManagerSpreadsheets Mr Farmer

  2. Lesson 3 - Starter • Wiki > Year 8 > Band Manager > Lesson 3 • Click the link • Read > Scatter > Test • 10 mins

  3. Lesson Objectives • Develop a spreadsheet model by adding additional columns. • Use absolute cell referencing to calculate VAT.

  4. VAT • What is VAT? • In pairs, use the Internet to find out what VAT means and then tell me in your own words on the wall. • Add the link to the website you used. • You will need to explain what it is so don’t just copy and paste! • 5 mins

  5. Absolute Cell Reference? What is an absolute cell reference and where would we use it? Google Define C4 or $C$4 • 5 mins

  6. Calculating VAT • Save and open the Calculating VATspreadsheet from the wiki • I will show you how and then you will need to use the help PowerPoint (on the wiki) • 15 mins

  7. Homework • Chart Toppers Worksheet • On the wiki

  8. Plenary • http://quizlet.com/11596704/test/ • http://www.bbc.co.uk/apps/ifl/schools/gcsebitesize/ict/quizengine?quiz=spreadsheets;templateStyle=ict

More Related