Free 9th Grade Functions In Open Office Calc Lesson Plan

Topic: Using functions in Open Office Calc to solve real world problems.

Objective: In this lesson, students will learn how to use functions in Open Office Calc to solve real world problems.

Materials: -Open Office Calc

  • Computer with internet access for researching real world problems
  • Handouts with example problems

Warm-up

  • Ask students if they have ever used a spreadsheet program before, and if so, which one.
  • Ask students if they have ever encountered the term "function" in a spreadsheet program before, and if so, what it is.
  • Show students a brief demo of how to use a function in a spreadsheet program.

Direct Instruction

  • Explain the purpose of functions in a spreadsheet program, which is to make it easier for users to solve real world problems by allowing them to manipulate data in various ways.
  • Show students some examples of functions and how to use them, using real-world data as the input and output.
  • Explain the syntax for using each function, and provide examples of how to use them properly.
  • Demonstrate how to use each function in Open Office Calc, and have students follow along.

Guided Practice

  • Have students work in pairs to practice using the functions on a set of real-world data.
  • Walk students through the process of using each function, and provide assistance as needed.
  • Assess understanding by having students explain how they used each function to solve the problem.

Independent Practice

  • Project-based: Have students work on a project-based assignment where they use multiple functions to solve a real-world problem.
  • For example, have students choose a sport and use Calc to analyze statistics and predict outcomes.
  • Encourage students to be creative and think critically about how they are using the functions.
  • Assess understanding by having students explain their analysis and predictions.

Closure

  • Review the key points of the lesson: what functions are and how to use them to solve real-world problems.
  • Ask students to share their completed project-based assignments and discuss their solutions.

Assessment:

  • Observe students during the guided practice and independent practice to ensure they are using functions to solve the problems and applying the concept of closure.
  • Review and grade the completed project-based assignments, looking for proper use of functions and closure in the solutions.

Create amazing lesson
plans 10X faster with AI.

Use AI to instantly generate high-quality lesson plans in seconds

Try NOW!