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

Enter/edit data and use spreadsheet features and functions to project outcomes and test simple "what if..." statements in content assignments. Strand - Spreadsheet

Resources aligned to this objective

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.
Integrated Unit on South America
This lesson includes information concerning database operations, word processing, desktop publishing, and spreadsheet formatting. Students will solve math problems.
Format: lesson plan (grade 6 Social Studies, Computer Technology Skills, English Language Development, and Mathematics)
By DPI Integration Strategies.
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.