LEARN NC

K–12 teaching and learning · from the UNC School of Education

Goal 2

The learner will demonstrate knowledge and skills in the use of computer and other technologies.

Objective 2.03

Use spreadsheet terms/concepts and functions to calculate, represent, and explain content area findings. Strand - Spreadsheet

Resources aligned to this objective

ACC basketball
The students will use ACC basketball statistics to practice the process of converting fractions to decimals then to percents and will learn how to create and edit a spreadsheet. They will then use this spreadsheet to analyze their data. This unit is done during the basketball season.
Format: lesson plan (grade 6–8 Computer Technology Skills and Mathematics)
By Susan Dougherty.
Exploring Probability : Part 1 of 2
This lesson will introduce students to probability using resources of Shodor Education Foundation, Inc. Permission has been granted for the use of the materials as part of the workshop Interactivate Your Bored Math Students. Students will discover the rule for calculating simple probability as well as explore the ideas of experimental and theoretical probability.
Format: lesson plan (grade 6 Computer Technology Skills and Mathematics)
By Wendy Korbusieski.
Holiday Shopper
This activity uses a prepared spreadsheet and the grocery sales paper from the newspaper to figure the cost of a holiday meal for a certain number of people.
Format: lesson plan (grade 6–7 Computer Technology Skills)
By Stephanie Hurley.
Planets' relative gravity spreadsheet
The students use online resources to find information about the nine planets in our solar system. Then, using the relative gravity of each planet, they will create a spreadsheet to calculate what the weight of an average man and woman (possibly their own weight or the weight of other objects) would be on each of the planets.
Format: lesson plan (grade 6 Computer Technology Skills and Science)
By Susan Blevins.
Popcorn Math
In this lesson students will use a consumable manipulative to understand percent, fraction and decimal conversions. They will also collect data on a teacher produced spreadsheet while using a computer generated spreadsheet to make conversions.
Format: lesson plan (grade 6 Computer Technology Skills and Mathematics)
By Henrietta Shepherd.
Spreadsheet formulas
This lesson will provide practice using formulas, print options, functions, and adjusting column widths.
Format: lesson plan (grade 6–8 Computer Technology Skills and Mathematics)
By DPI Integration Strategies.
Stocks Report
Students will create graphs illustrating changes in stocks and answer questions using the graphs.
Format: lesson plan (grade 6–8 Computer Technology Skills and Mathematics)
By Susan Blackwell.
Winter Olympics: Inquiry into Statistics
Following the excitement of Olympic events, students are involved in an I-search http://www.avon.k12.in.us/hickory/pages/hickoryhome2.htm (click on Media Center then I-Search) activity that helps them develop question and search techniques. Their research provides them with data to enter into spreadsheets and display in graph format.
Format: lesson plan (grade 6–12 Information Skills, English Language Arts, and Computer Technology Skills)
By Carol Horne, Nancy Cowal, and Victoria Lunetta.

Lesson plans on the web

Bouncing Tennis Balls
Students develop their skills in collecting and recording data using the real-world situation of a bouncing tennis ball. (Learn more)
Format: lesson plan (grade 6 Computer Technology Skills and Mathematics)
Provider: National Council of Teachers of Mathematics