+
Lesson Plan
Curated OER

Graphing Climate Information

For Teachers 7th
Seventh graders plot the data for the average monthly precipitation for three cities. They make a graph using a spreadsheet.
+
Lesson Plan
Curated OER

Using a spreadsheet and the Internet to learn about stock market performance

For Teachers 9th - 12th
High schoolers record the progress weekly of a business of their choice on the stock market, graph those results, research and report on current news and how it pertains to the companies recent performance.
+
Lesson Plan
Curated OER

ICT Activity 17

For Teachers 8th
Eighth graders use a spreadsheet for the first time. They work on a selected environmental issues as their theme. Students prepare costs or income for an event that raises money for an environmental issue. They use the costs and income...
+
Lesson Plan
Curated OER

African Safari

For Teachers 5th - 7th
Learners create an Excel spreadsheet that show a budget for a trip to Africa to see wildlife. In small groups, they complete internet research to determine the countries and sites to visit then calculate the costs involved for the trip....
+
Lesson Plan
Curated OER

Cannot Buy Me Love

For Teachers 6th - 9th
Students investigate the concepts that are related to finance and how it is used in the world. They take part in activities that are focused around the use of a spreadsheet while using a T-chart to simulate a ledger of credits and debits.
+
Lesson Plan
Curated OER

Introduction to Computing and Project Development

For Teachers 6th - 12th
Students use a computer and math to complete a science project. They review a brief history of computers as well as information on different operating formats will be included. In addition, students complete an overview of the hardware...
+
Lesson Plan
Curated OER

Monitoring Math with a Statistical Spreadsheet

For Teachers 4th - 6th
Students use a spreadsheet to compute landmark statistics of a math quiz. This lesson can be ongoing throughout the school year and it integrates mathematics curriculum and technology in a simple format for student use.
+
Lesson Plan
Curated OER

What About That Jazz?

For Teachers 6th - 8th
Young scholars, with the help of the NBA Utah Jazz website, formulate how to use a database. In addition, they access how to copy and paste, and prepare a spreadsheet for later use. Students apply productivity/multimedia tools and...
+
Lesson Plan
Curated OER

Who Built It?

For Teachers 7th
Seventh graders study the difference between architectural detail from the Romanesque and Gothic eras. The class participates in discussion on are in different eras. They predict what picture belongs in what era.
+
Lesson Plan
Curated OER

Trends in Precipitation

For Teachers 8th
Eighth graders study about precipitation and graph the information. They look for patterns in a scatter graph and make inferences based on what they see. They need to see a relationship between location and the amount of precipitation.
+
Lesson Plan
Curated OER

Your Just Desserts

For Teachers 6th - 8th
Young scholars write letters to town officials and local businesses asking for favorite dessert recipes. They tabulate their responses in a spreadsheet. Students turn their survey results into colorful graphs.
+
Lesson Plan
Curated OER

How Do You Spend Your Time?

For Teachers 7th - 8th
Students keep records and determine how much time they spend on certain activities. They insert the data into a spreadsheet. Students graphically display data in a bar graph and a circle graph.
+
Lesson Plan
Curated OER

Technology Integration Lesson Plan: Civil War Spreadsheet

For Teachers 8th
Eighth graders discuss and analyze Civil War data, manually graph data on handout, work with partners to enter data into spreadsheets, and create charts on spreadsheet for each data set.
+
Lesson Plan
Curated OER

Bones and Math

For Teachers 5th - 12th
students identify and explore the connection between math and the bones of the human body. Students collect data about bones from their classmates and from adults, apply formulas that relate this data to a person's height, and organize...
+
Lesson Plan
Curated OER

Society, Cyberspace and the Future

For Teachers 6th - 7th
Learners locate information on the rapid growth of world population and consumption needs through the use of Internet, Cd-ROMs, laser dics and other media. They use spreadsheet to present data gathered on world population growth between...
+
Lesson Plan
Curated OER

Rouge River Data

For Teachers 3rd - 5th
Students participate in using Excel sofware in order to create graphs. They create the graphs using data that they gathered during the Rouge River Field Trip they attended. The produce bar graphs from the excel spreadsheets.
+
Lesson Plan
Curated OER

Creating a Bar Graph Using a Spreadsheet: Dice Rolling Probabilities

For Teachers 10th
Tenth graders explore the concept of spreadsheets. They create a simple spreadsheet and chart from given data. Students perform basic formatting procedures on their chart. They use spreadsheet functions to perform calculations.
+
Lesson Plan
Curated OER

Technology - Data Collection

For Teachers 8th - 10th
Students collect and analyze data from the United States Census Bureau. Using spreadsheet technology, students explore their results and make preductions about income groups. Students compute the mean, median and mode. They create...
+
Lesson Plan
Curated OER

Volcano Spreadsheet and Graph

For Teachers 4th
Fourth graders find the height of selected volcanoes and convert their measurements to feet. Students interpret information from a graph. They also write math questions that require the use of a class created graph. Students use a...
+
Lesson Plan
Curated OER

Ladybugs in the Garden

For Teachers 5th
Fifth graders estimate the size a population (ecosystems) Students make a chart from information collected then create a graph (line or bar) from this information. Students do a lesson where they observed, examine, and record data...
+
Lesson Plan
Curated OER

Charting the Heights

For Teachers 6th - 8th
Students enter data regarding the height of classmates into a spreadsheet. Formulas will also be entered to find the median, mean, and mode of the data.
+
Lesson Plan
Curated OER

Number and Algebra: Again and Again

For Teachers 5th - 9th
Young scholars use a given spreadsheet to investigate an iterative process by changing the variables. They design their own spreadsheet to investigate the iterative process.
+
Lesson Plan
Curated OER

Running a Business

For Teachers 6th - 8th
Students discuss spreadsheets and how they work. They then imagine they are owners of a store, determine twenty items that they would sell, and create spreadsheets to record amounts of each item sold in a two-week period. After entering...
+
Lesson Plan
Curated OER

Spreadsheet Activity

For Teachers 7th - 8th
Young scholars create a spreadsheet to match a given sample. This includes adjusting column width and row height, changing alignment, changing size and style of print, changing number format.