LEARN NC

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

Goal 3

The learner will use a variety of technologies to access, analyze, interpret, synthesize, apply, and communicate information.

Objective 3.07

Modify/create spreadsheets to calculate and graph data to incorporate into content area projects (e.g., word processing, multimedia, webpages). Strand - Spreadsheet

Resources aligned to this objective

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.

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