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

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.
Interdisciplinary Integrated Unit on DNA/Genetics Part B: Math
The second lesson of an interdisciplinary integrated unit on DNA and genetics, focusing on math. The other lessons in the unit focus on science and language arts.
Format: lesson plan (grade 7 English Language Arts, Computer Technology Skills, and Mathematics)
By Jane Lentz, Jimmy White, Marlene Smith, and and Tori Goldrick.
Ohm's Law made easy with a spreadsheet
In this lesson, students will use math word problems to help them input information into a spreadsheet that will use Ohm's law to calculate current and resistance using common household appliance wattages.
Format: lesson plan (grade 7 Computer Technology Skills, Mathematics, and Science)
By Hilda Hamilton.
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.