Volume and Surface Area An Interactive Excel Activity for a Geometry - - PowerPoint PPT Presentation

▶
volume and surface area
SMART_READER_LITE
LIVE PREVIEW

Volume and Surface Area An Interactive Excel Activity for a Geometry - - PowerPoint PPT Presentation

Jan 18, 2023 309 likes •449 views

Volume and Surface Area An Interactive Excel Activity for a Geometry Classroom Kyle Plucinsky Spring 2016 Target Audience High School Geometry 9 th ,10 th , and 11 th Grade Students A or B Level Timeline: 1 day Prior Lessons:

slide-1
SLIDE 1

Volume and Surface Area

An Interactive Excel Activity for a Geometry Classroom Kyle Plucinsky Spring 2016

slide-2
SLIDE 2

Target Audience

  • High School Geometry
  • 9th ,10th , and 11th Grade Students
  • A or B Level
  • Timeline: 1 day
  • Prior Lessons: Introduction and Practice of

Surface Area and Volume Formulas

slide-3
SLIDE 3

Goals and Objectives

SWBAT:

  • Use Excel to calculate perimeters, areas, surface

areas, and volumes of polygons and solids

  • Check their homework and classwork with the

Surface Area and Volume Calculator

  • Describe the behavior of volumes and surface

areas as dimensions increase constantly

slide-4
SLIDE 4

NJCCCS

  • HSG-GMD.A.3 Use volume and surface area formulas

for cylinders, pyramids, cones, and spheres to solve problems.

  • HSG-MG.A.1 Use geometric shapes, their measures,

and their properties to describe objects (e.g., modeling a tree trunk or a human torso as a cylinder).

slide-5
SLIDE 5

Activities

  • Homework Review
  • Students check their homework answer using the

spreadsheet

  • Castle Activity
  • Students will find the surface area and volume of a

castle made up of various solids

slide-6
SLIDE 6

Spreadsheets

Formulas

Absolute Reference

slide-7
SLIDE 7

Excel Features

Conditional Formatting Graphs

slide-8
SLIDE 8

More Features

Concatenate

Excel’s Built-In Functions

Hyperlink

slide-9
SLIDE 9

Evaluation

  • Homework Review – self-evaluation
  • Castle Activity – Formative Assessment
  • Listening to student discussions
  • Asking critical thinking questions
  • Reviewing final answers to SA and V
slide-10
SLIDE 10

Gardner’s Multiple Intelligences

  • Logical-Mathematical – formulas on Excel
  • Visual-Spatial – graphs showing the behavior of

volumes and surface areas as heights, radii, etc change

  • Intrapersonal – checking own understanding using

spreadsheet

  • Interpersonal – cooperative learning
  • Bodily-Kinesthetic – moving around and measuring

parts of castle

slide-11
SLIDE 11

Brainy Bits

  • Frontal Lobe
  • Problem-solving skills, critical thinking
  • Occipital Lobe
  • Looking a graphs, solids making up the castle
  • Parietal Lobe
  • Processes sensory information
  • Temporal Lobe
  • Discussion with classmates
slide-12
SLIDE 12

Citations

  • Images
  • http://drumminns.scoilnet.ie/blog/files/2012/01/2012-01-16-3D-

Shape-Castle.jpg

  • http://villagecenterchiropractic.com/wp-

content/uploads/2015/07/lobes-of-brain.jpg

  • https://education-

2025.wikispaces.com/file/view/wordle.jpg/278293886/554x298/w

  • rdle.jpg
  • Sources
  • Gardner, H. (1983). Frames of Mind: The Theory of Multiple
  • Intelligences. New York: Basic Books
  • Sousa, D. (2011). How the Brain Learns (4th ed.). Thousand

Oaks, CA: Corwin Press