LEARN NC

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

Goal 3

The learner will use a variety of technologies to access, analyze, interpret, synthesize, apply, and communicate information.

Objective 3.06

Create/modify spreadsheets to test simple “what if...” statements to solve problems and make decisions in content areas. Strand - Spreadsheet

Resources aligned to this objective

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.
Grammar Scramblers, Spreadsheets, and Parts of Speech
Students use and create Grammar Scramblers with a spreadsheet in order to practice identifying and using parts of speech in a fun way.
Format: lesson plan (grade 3–9 English Language Arts and Computer Technology Skills)
By Tom Munk.
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
This lesson is part of an interdisciplinary integrated unit on DNA and genetics. The idea is for students to complete a week's worth of activities in science, math, and language arts. This lesson is Part B: Math. Students will complete a math survey interviewing people on whether they believe humans should or should not be cloned. They will take the data they gather and create computer generated spreadsheets, charts/graphs. Using the charts/graphs, students will answer mathematical percent and ratio questions and write a final journal entry on the information they collected and discovered.
Format: lesson plan (grade 7 English Language Arts, Computer Technology Skills, and Mathematics)
By Jane Lentz, Jimmy White, Marlene Smith, and Tori Goldrick.
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.