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

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 Computer Technology Skills and Mathematics)
By Susan Dougherty.
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 English Language Arts, Computer Technology Skills, and Science)
By Karen Greene.
Do Not Touch!
This lesson focuses on the reason for the "hands off" policy in art museums.
Format: lesson plan (grade 7 Visual Arts Education and Computer Technology Skills)
By Darlene Ryan1.
Graphing Climate Information
Students learn to plot the data for the average monthly precipitation for three cities.
Format: lesson plan (grade 7 Computer Technology Skills and Science)
By Madelyn Owenby.
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.
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 and Mathematics)
By DPI Integration Strategies.
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.