1 / 6

Spreadsheet Skills

Spreadsheet Skills. Modelling Mario – Part 2. Lesson Objectives. Use spreadsheet software to build a model. Use Macros to improve the functionality of a spreadsheet model. Justify the benefits of using Macros. By the end of the lesson pupils will be able to:. Starter – Card sort game.

vannessa
Download Presentation

Spreadsheet Skills

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. Spreadsheet Skills Modelling Mario – Part 2

  2. Lesson Objectives • Use spreadsheet software to build a model. • Use Macros to improve the functionality of a spreadsheet model. • Justify the benefits of using Macros. By the end of the lesson pupils will be able to:

  3. Starter – Card sort game. Rules. • When you see the question, put the cards on your table in the correct order to make your formula. • Put your hands up when you think you have the correct answer. • DO NOT shout out! The team next to may hear your answer.

  4. Question 1. What is the formula to work out the TOTAL marks for ‘Mary Davenport’? Answer: =SUM(B5:C5)

  5. Question 2. What is the formula to work out the AVERAGE Calories Answer: =AVERAGE(B3:B14)

  6. Question 3. What is the formula to work out the MAXIMUM mark for the class’? Answer: =MAX(C2:C10)

More Related