LEARN NC

K–12 teaching and learning · from the UNC School of Education

Goal 1

The learner will understand important issues of a technology-based society and will exhibit ethical behavior in the use of computer and other technologies.

Objective 1.10

Use spreadsheet and graphing terms/concepts to present and explain content area assignments. Strand - Spreadsheet

Resources aligned to this objective

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)
By DPI Integration Strategies.
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.
Coastal weather issues: Planning for a hurricane
The unit is designed for seventh grade students who have been studying Earth and its atmosphere. In this sequence, students are faced with the realistic issue of personal and social decision-making when planning for hurricane strikes, which includes classification, tracking, and monitoring hurricanes, as well as planning for evacuations. The inquiry-based approach involves a WebQuest in which the learner will assume the role of an emergency management team member who must create a preparation plan for the community.
Format: lesson plan (grade 7 Computer/Technology Skills and Science)
By Karen Greene.
ACC basketball
The students will use ACC basketball statistics to practice the process of converting fractions to decimals then to percents and will learn how to create and edit a spreadsheet. They will then use this spreadsheet to analyze their data. This unit is done during the basketball season.
Format: lesson plan (grade 6–8 Mathematics)
By Susan Dougherty.