+
Lesson Plan
Curated OER

Embracing Diversity

For Teachers 9th - 12th
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.
+
Lesson Plan
Curated OER

Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions

For Teachers 7th - 12th
Students improve data entry in a spreadsheet.
+
Lesson Plan
Curated OER

Fraction Strips on Excel

For Teachers 6th
Sixth graders create three different sets of fraction strips using Excel by following a packet of instructions that taper off as the students gain confidence in their knowledge of Excel. They copy and paste the strips into Word so that...
+
Activity
Howard Hughes Medical Institute

Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation

For Students 9th - 12th
If you've always wanted to know more about spreadsheets, here's a perfect resource for you. A self-paced tutorial introduces how to autofill and copy formulas in a Google sheet or Excel spreadsheet. It also shows users how to find range,...
+
Lesson Plan
Curated OER

Penny Pushing

For Teachers 5th
Fifth graders use an Excel spreadsheet to show them how to enter the amount of pennies they bring each week to school for a fundraising project. They count their pennies each Friday and enter the total amount in the correct columns. In...
+
Lesson Plan
Curated OER

"Reality Math: Fact or Fiction"

For Teachers 6th - 8th
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...
+
Lesson Plan
Curated OER

Fast Food Survey Using Bar Graphs

For Teachers 2nd
Second graders create a bar graph to pictorically represent the data collected from a survey of students. They use Excel to electronically create the graphs and data tallies. They then interpret their data using sentences to explain.
+
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

Spreadsheet Graphs

For Teachers Higher Ed
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...
+
Lesson Plan
Curated OER

The Hundred Penny Box

For Teachers 6th
Sixth graders research payload specialists and see how many are men and how many are women and what countries they come from. They then create an excel spreadsheet to reflect data they found and must have two graphs for interpretation.
+
Lesson Plan
Curated OER

What Color Are Your Skittles?

For Teachers 7th - 10th
Students create spreadsheets and manipulate data. They collect data, create appropriate graphs and use percentages to describe quantities. Students compare and contrast data. They use spreadsheets to generate a pie chart.
+
Lesson Plan
Curated OER

State Economy Chart

For Teachers 5th
Fifth graders research and record statistics on the economy of an assigned state. They create a spreadsheet in Excel to report the data and a 3D Pie graph using the Chart Wizard in Excel to represent their states' data.
+
Lesson Plan
Curated OER

One, Two, Three...and They're Off

For Teachers 5th - 6th
Students make origami frogs to race. After the race they measure the distance raced, collect the data, enter it into a chart. They then find the mean, median, and mode of the data. Next, students enter this data into Excel at which time...
+
Lesson Plan
Curated OER

Don't Settle for a Byte... Get the Megabyte on Technology

For Teachers 4th - 12th
Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint to...
+
Lesson Plan
Curated OER

Money Math: Lessons for Life

For Teachers 11th - Higher Ed
Students develop a budget for a college student using all of the influences that the student would have.  In this budgeting lesson plan, students use real life examples to create a budget spreadsheet.  Students read and study sample...
+
Lesson Plan
Curated OER

Math Operations/Formulas

For Teachers 6th - 8th
Students discuss the ways spreadsheets can help them solve story problems. In groups, they must set up a spreadsheet with the correct formulas based off of different scenerios using the correct order of operations. To end the lesson,...
+
Lesson Plan
Curated OER

Spreadsheet Function Machine

For Teachers 7th - 8th
Students create a spreadsheet to analyze functions. In this algebra lesson, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
+
Lesson Plan
Curated OER

Tiling a Patio

For Teachers 5th
Fifth graders practice, with spreadsheets, to demonstrate how to determine the number of tiles needed to create a patio. They use pictures and gathered data to determine a pattern that can be used to solve problems. Students create a...
+
Lesson Plan
Curated OER

Measuring Ourselves

For Teachers 5th
Fifth graders conduct various measurement activities on themselves and a partner. They measure their height, weight, thumb-to-pinky span, and body temperature, recording the information in the form of an Excel spreadsheet.
+
Lesson Plan
Curated OER

American History Through Architectural Masterpieces: Monticello

For Teachers 3rd - 5th
Students examine the life of Thomas Jefferson, explore great American landmark Monticello, discover relationships between climate, geographical factors, and time as to what kind of architecture was used, conduct research online, write a...
+
Lesson Plan
Curated OER

What Temperature Is It?

For Teachers 3rd - 5th
Young scholars use the internet to research information on the average maximum and minimum temperature for a city in their state. They create spreadsheets and enter data to analyze the information, focusing on averages, maximums,...
+
Lesson Plan
Curated OER

I'm in the Money - Practical Money Skills

For Teachers 3rd - 6th
Students make a budget and utilize math skills to keep a record of what they spend. They use technology and spreadsheets to help them keep track of their money.
+
Lesson Plan
Curated OER

Tech Smart

For Teachers 6th
Sixth graders practice computer skills. In this technology lesson, 6th graders use programs such as Microsoft Word, Excel, Print Shop, and PowerPoint. They use the Internet for research and data collection to be incorporated in their...
+
Lesson Plan
Curated OER

Meet The Graphs

For Teachers 3rd - 4th
Learners identify two types of graphs. They analyze and interpret authentic data shown in bar and pie graphs and complete a graph given specific data. Perform simple functions within an Excel document:

Other popular searches