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

Identify, discuss, and use the spreadsheet terms/concepts (e.g., cell, column, row, values, labels, graph, formula). Strand - Spreadsheet

Resources aligned to this objective

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.
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)
By Christine Weaver.