1 / 8

Understanding VAT and Spreadsheet Modeling in Band Manager Lesson 3

In this lesson, students will enhance their spreadsheet modeling skills by incorporating additional columns and applying absolute cell referencing to calculate VAT. The lesson objectives include defining VAT through research and sharing insights collaboratively, followed by practical exercises using the Calculating VAT spreadsheet. Learners will utilize online resources and complete homework using the Chart Toppers Worksheet. By the end of the session, students will understand VAT's significance and how to manipulate spreadsheets effectively for calculations.

rianne
Télécharger la présentation

Understanding VAT and Spreadsheet Modeling in Band Manager Lesson 3

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