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.