1 / 6

Enhance Spreadsheet Skills with Macros: A Modeling Lesson for Students

In this lesson, students will learn how to utilize spreadsheet software to create a model and improve its functionality with Macros. By the end of the session, pupils will be equipped to justify the advantages of employing Macros in their work. The engaging starter activity involves a card sort game where students must arrange cards to formulate correct answers. Key questions include calculating the total marks, average calories, and maximum class mark, providing practical applications of spreadsheet formulas in a fun and interactive format.

vannessa
Download Presentation

Enhance Spreadsheet Skills with Macros: A Modeling Lesson for Students

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