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

Select and use spreadsheet formulas and functions to solve problems in content areas. Strand - Spreadsheet

Resources aligned to this objective

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.