LEARN NC

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

Goal 3

Select and use a variety of technology tools to collect, analyze, and present information. Strand - Societal/Ethical Issues

Objective 3.04

Create/modify spreadsheets to analyze and interpret information, test simple "what if..." statements, solve problems, and make decisions in content areas. Strand - Spreadsheet

Resources aligned to this objective

Dear Tootsie Roll company
The students will measure the surface area and wrapper area of five pieces of candy. Using appropriate formulas and measuring techniques, they will complete information needed for a spreadsheet and database. Students wrap up the lesson by writing a letter to the company with the most wasted paper to explain how the waste affects them as consumers and a suggestion for correcting the problem.
Format: lesson plan (grade 8 English Language Arts, Computer Technology Skills, and Mathematics)
By Tonya Thompson.
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.
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.
What Can Scatterplots Tell Us?
Using data from peer surveys and self surveys of popular TV shows, students will create computer-generated scatterplots. Students will culminate a unit on correlation with a Parent vs. Teen scatterplot project.
Format: lesson plan (grade 8 Information Skills, English Language Arts, Computer Technology Skills, and Mathematics)
By Hilda Hamilton.