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

Demonstrate knowledge that spreadsheets are used to process information in a variety of settings (e.g., schools, government, business, industry, mathematics, science). 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.
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.
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.
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.