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

Enter/edit data in prepared spreadsheets to perform calculations using simple formulas (+, -. *, /) and observe the changes that occur. Spread - Spreadsheet

Resources aligned to this objective

Introduction to Spreadsheets
In this two-week unit the students will use a teacher made spreadsheet to learn how calculations work. Then student teams will work together to create their own "store" order form on a spreadsheet. The final part of the lesson is a simulated game show where students "shop" at each others stores, trying to spend an exact amount of money without going over, getting closer to their required amount than any other team.
Format: lesson plan (grade 4 Computer Technology Skills and Mathematics)
By Christine Weaver.
Nutritional Value Unit Integrated with Microsoft Works
This unit is an example of how to integrate technology into the curriculum to alleviate teaching it in isolation. Students will use Microsoft Works to compare and analyze nutritional values from nonperishable food items.
Format: lesson plan (grade 4–5 Computer Technology Skills and Mathematics)
By Gretchen Parrish.
Spreadsheets for dinner
Students will identify spreadsheet terms, create a spreadsheet about nutritional content of foods, and add the columns of the spreadsheet.
Format: lesson plan (grade 4 Healthful Living Education and Computer Technology Skills)
By Laurie Myers.