LEARN NC

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

Goal 2

The learner will demonstrate knowledge and skills in the use of computer and other technologies.

Objective 2.05

Modify/create and use spreadsheets to solve problems by performing calculations using simple formulas and functions (e.g., +, -, *, /, average). Strand - Spreadsheet

Resources aligned to this objective

Nutritional Value Unit Integrated with Microsoft Works
This unit is an example of how to integrate technology into the curriculum to alleviate teaching it in isolation. Students will use Microsoft Works to compare and analyze nutritional values from nonperishable food items.
Format: lesson plan (grade 4–5 Computer Technology Skills and Mathematics)
By Gretchen Parrish.
Solar Sizzlers
Group projects of building solar cookers or collectors provide arena for learning about energy sources and transformation. Gathering data for comparison and analysis exercises students' graphing skills and thinking.
Format: lesson plan (grade 5 Information Skills, English Language Arts, Computer Technology Skills, and Mathematics)
By Larry Parker.

Lesson plans on the web

Collecting, representing, and interpreting data using spreadsheets and graphing software: Collecting and examining weather data
Spreadsheets and graphing software are tools for organizing, representing, and comparing data. This activity illustrates how weather data can be collected and examined using these tools. (Learn more)
Format: lesson plan (grade 5 Science, Mathematics, and Computer Technology Skills)
Provider: National Council of Teachers of Mathematics