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

Use spreadsheet features/functions to calculate and present findings for content area assignments. Strand - Spreadsheet

Resources aligned to this objective

Using percent of change to measure NC growth
Students will work in small groups to use the internet to gather data on the population growth for each of the 100 counties in NC from 1992 to 1995. From this data students will find the percent of increase/decrease for the counties they have been assigned. As a follow-up, the students will enter their data into a computer spreadsheet and from that spreadsheet, produce graphs of the information.
Format: lesson plan (grade 8 Computer/Technology Skills, Mathematics, and Social Studies)
By Wanda Washburn.
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)
By Susan Blackwell.
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)
By DPI Integration Strategies.
Dear Tootsie Roll company
The students will measure the surface area and wrapper area of five pieces of candy. Using appropriate formulas and measuring techniques, they will complete information needed for a spreadsheet and database. Students wrap up the lesson by writing a letter to the company with the most wasted paper to explain how the waste affects them as consumers and a suggestion for correcting the problem.
Format: lesson plan (grade 8 English Language Arts and Mathematics)
By Tonya Thompson.