LEARN NC

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

Goal 1

The learner will understand important issues of a technology-based society and will exhibit ethical behavior in the use of computer and other technologies.

Objective 1.08

Recognize and discuss use of spreadsheets to calculate, graph, and present data in a variety of settings (e.g., schools, government, business, industry, mathematics, science). Strand - Spreadsheet

Resources aligned to this objective

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.
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.