Open Oregon Educational Resources
Beginning Excel
How can Microsoft Excel help manage data in people's personal and professional lives? Using the Beginning Excel eBook, scholars learn the basics of creating, editing, and using spreadsheets. They explore spreadsheet design, formulas,...
Curated OER
Introduction to Spreadsheets
Sixth graders utilize Excel or other spreadsheet software to create both text and numerical valued columns to produce a Christmas or birthday wish list. They study the difference between text and numerical values for column use and...
Curated OER
Weather, Weather, Everywhere!
Sixth graders collect weather data to compare temperatures around the world. Using the Internet, learners collect data, put it into spreadsheets, and analyze and graph the results. An interesting way to cover the topic of weather.
Curated OER
Super Spreadsheets
Middle schoolers develop a spreadsheet containing statistical data. They describe and interpret the data to make conclusions. They review the differences between an unorganized spreadsheet verses an organized one.
Curated OER
Embracing Diversity
High schoolers explore and use different computer programs for collecting data. In this technology based instructional activity, students set up a survey and use the Excel and Lotus software to collect data.
Curated OER
Computers: Inside and Out - Programs Matching Worksheet
In this computer program instructional activity, students draw a line from a list of 10 tasks to the type of application that would the best to used to complete each task. They choose from applications such as spreadsheets, database, and...
Curated OER
Family Search We All Came To America
Eighth graders participate in a computer based Family Search Unit. They use multimedia resources to research their country of origin, conduct interviews, and use software to produce narratives, databases, spreadsheets and graphs in this...
Curated OER
Million Dollar House
Fourth graders use a combination of calculators and spread sheet software to furnish their own million dollar horse without going over the specified amount of a million. The goal being to create a house that came to the exact amount of...
Curated OER
Level III: Technology Integration
Fourth graders prepare two spreadsheets each with an embedded line graph that displays data about the growth of the bitter rot fungus on apples and on petri dishes that were stored in the refrigerator and the classroom. They prepare a...
Bowland
Outbreak: Infection Detection
Explore the mathematics of infection outbreaks with activities that ask learners to use coordinate grids to locate infected patients. They calculate amounts of ingredients for antidotes and determine which groups of people should be...
Curated OER
Solving Polynomial Equations
Students demonstrate how to use spreadsheets as a tool for analyzing, visualizing and solving mathematical problems. Students obtain fundamental grasp of cubic equations and other polynomial equations.
Curated OER
Survey Says...
Learners practice taking surveys to answer different questions about radio. In this communications lesson plan, students brainstorm to create questions they can ask strangers about how often they listen to their radio. Learners turn...
Curated OER
Spreadsheets - WP9/Quattro Pro
Learners discover spreadsheet applications using Quattro Pro. They demonstrate basic knowledge and application of hardware, software, and Internet use. They recognize and appreciate the value of recording keeping, data input and data...
Curated OER
Electronic Spreadsheets & Iditarod 2000
Students use the Internet for gathering information for Iditarod race journals. They use a spreadsheet program for entering data and making charts for showing changes in speeds achieved over a period of four weeks in timed writings in...
Curated OER
Dino-Myte Spreadsheet
Do your learners like dinosaurs and theme parks? An ambitious activity invites learners to put together a plan for supplying dinosaurs for a new theme park. Pupils work together in groups to come up with their plan, which must include a...
Curated OER
Irish Eyes: Taking a Look at Local Landscape
Direct your class’s attention to the elements that make their community unique. After examining sample travel brochures, groups select something from their community to use as the subject, and then research, create, and publish a...
Curated OER
Multiplication Tables Using Microsoft Excel
Eighth graders are introduced to Microsoft Excel as a computer application software program. They create multiplication tables in Microsoft Excel. Students work in small groups. They discuss the $ (anchor) function in Microsoft Excel.
Curated OER
Getting It Right!
Young scholars construct right triangles, measuring the sides and recording the measurements in spreadsheets. They analyze their measurements for patterns and research the Internet for information on Pythagoras.
Curated OER
Moving Day!
Eighth graders continue their geometry unit by focusing on volume. Using data, they create a spreadsheet, estimate and calculate volume. They solve real-life problems and round their answers to the hundredths place. They also practice...
Curated OER
"Reality Math: Fact or Fiction"
Students investigate the use of math in everyday life. They investigate several occupations and pay scales. They complete spreadsheets that show how monthly bills can be organized using technology. They use word processing software to...
Curated OER
Spreadsheet Graphs
Students create graphs using information from spreadsheets. They select a topic from the following choices: website use, digital cameras, spreadsheets, calculators or educational software. They tally the class results and create an...
Curated OER
Calculating & Graphing Using a Spreadsheet
Students use the lab apparatus to calculate the average velocity and average acceleration at several points and record the data. They use the spreadsheets to plot distance vs. time, velocity vs. time and acceleration vs. time graphs.
Curated OER
Using Computer for Statistical Analysis
Students examine the use for spreadsheets in analyzing data. They make spreadsheets that display and calculate a given data set such as temperature change.
Curated OER
Pollution Assessment: Is Wood Lake a Good Lake?
Students become aware of pollution in Richfield Minnesota's Wood Lake, identify sources of pollution in Wood Lake, learn to use variables, equations, spreadsheets and modeling software, and generate solutions for the problem.