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

Modify/create and use spreadsheets to solve problems, make decisions, support, and display findings in content areas projects. 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.
Planets' relative gravity spreadsheet
The students use online resources to find information about the eight 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 Science)
By Susan Blevins.
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.
Grammar Scramblers, spreadsheets, and parts of speech
Students use and create Grammar Scramblers with a spreadsheet in order to practice identifying and using parts of speech in a fun way.
Format: lesson plan (grade 3–9 English Language Arts)
By Tom Munk.