+
Lesson Plan
Curated OER

Basic Excel

For Teachers 1st - 4th
Students explore basic Excel spreadsheets.  In this spreadsheet lesson plan, students enter Alaska weather information and  perform calculations. Students title the columns on the spreadsheet and format the cells.  Students complete...
+
Lesson Plan
Curated OER

Correlation of Variables by Graphing

For Teachers 7th - 10th
Middle and high schoolers use a spreadsheet to graph data. In this graphing lesson, learners determine how two parameters are correlated. They create a scatter plot graph using a computer spreadsheet.
+
Lesson Plan
Curated OER

Which Amusement Park Would You Choose?

For Teachers 5th - 10th
Students analyze data related to amusement parks and create a spreadsheet to display the data. They read the data and predict which amusement park they think is safer, create a spreadsheet and graph, and write a proposal based on their...
+
Lesson Plan
Curated OER

Shopping Around

For Teachers 3rd
Third graders select a recipe and compare prices for ingredients at two different stores. They select the best place to buy the ingredients and answer questions about the process. They include their data on a spreadsheet related to their...
+
Lesson Plan
Curated OER

What are they like Today

For Teachers 6th
Sixth graders compare the modern day countries that exist in the areas they study in Ancient History. They use a spreadsheet on the computer to organize data that includes population of the countries, along with other various types of...
+
Lesson Plan
Curated OER

Microsoft Office Excel

For Teachers 6th - 8th
Middle schoolers use Microsoft Office Excel. In this technology lesson, students enter data on a spreadsheet using Excel. This programs tallies data and presents it using graphs. 
+
Printables
3
3
Vertex42

Weekly Lesson Planning Template

For Teachers K - 12th
You'll feel prepared and ready to begin your school week when you've considered the progression of your lessons on an hourly and day-to-day basis. 
+
Lesson Plan
Curated OER

Haber's Process- A Computer Simulation

For Teachers 10th - Higher Ed
Young scholars use an on line simulation to produce ammonia using Haber's process. In this Haber's process lesson plan, students use a spreadsheet to manipulate the pressure, temperature and catalysts used in the production of ammonia....
+
Lesson Plan
Alabama Learning Exchange

How Big Can a Bee Be?

For Teachers 7th - 10th Standards
Mathematicians analyze the relationships between surface area and volume. They conduct Internet research, conduct various experiments, record the data in a spreadsheet, and graph the results and compare the rate of increase of surface...
+
Lesson Plan
Curated OER

Historical Population Changes in the US

For Teachers 9th - 12th
High schoolers conduct research on historical population changes in the U.S. They conduct Internet research on the Historical Census Data Browser, create a bar graph and data table using a spreadsheet program, and display and interpret...
+
Assessment
Concord Consortium

Boards I

For Students 7th - 9th Standards
Learners create patterns in a table to mimic the function of an electronic spreadsheet. The result is a table that creates an addition table for decimals in intervals of one-tenth. While creating the pattern, pupils must thoroughly...
+
Assessment
Concord Consortium

Boards IV

For Students 7th - 9th Standards
Build a connection between algebraic sequences and spreadsheets. Learners examine a specific folding pattern and convert the pattern into a spreadsheet. The goal of the spreadsheet is to produce a sequence of a specific pattern modeled...
+
Activity
Teach Engineering

Air Pollution in the Pacific Northwest

For Teachers 6th - 8th Standards
Scholars investigate levels of nitrogen dioxide in the Pacific Northwest by examining the role of nitrogen in air pollution and how remote sensing can be used to measure nitrogen levels. An Excel spreadsheet calculates the difference...
+
Assessment
Concord Consortium

Boards III

For Students 7th - 9th Standards
Learn to visualize mathematical patterns as a folded pattern. Beginning with a visual display, the task encourages pupils to view sequences as a folded table. The pattern of the table then becomes a formula in a spreadsheet that...
+
Lesson Plan
Curated OER

How Credit Card Interest Works

For Teachers 10th - 12th
Students experiment with an Excel spreadsheet model that demonstrates the effects of interest on payments. They calculate actual costs, interest paid, and time necessary to pay off credit purchases and draw conclusions about the...
+
Lesson Plan
Curated OER

Discovering Pi

For Teachers 9th - 11th
Define terminology related to a circle. Practice accuracy in measuring and then create a spreadsheet based on data collected from solving for parts of a circle. Groups can have fun analyzing their data as it relates to Pi.
+
Lesson Plan
Curated OER

Birds, Fractions and Percentages

For Teachers 6th - 12th
Students study fractions, percentages, spreadsheets, and computers by watching and recording the number of species of birdsseen. They create a spreadsheet to record the results of their one month study.
+
Lesson Plan
Curated OER

Level III: Technology Integration

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

Forces of Flight - Lift

For Teachers 3rd - 8th
Young scholars design and test paper airplanes to understand the concept of lift and how it affects flight. This technology-based Science lesson plan is excellent for use with upper-elementary and middle-level learners and uses...
+
Lesson Plan
Curated OER

Counting Coins

For Teachers 2nd
Second graders identify a quarter, dime, penny, nickel, and dime. They match the coin with it's monetary value, collect data on excel spreadsheet, and create a graph in Excel. Students participate in group activities.
+
Lesson Plan
Curated OER

Conversation Heart Graphing

For Teachers 6th
Sixth graders review the different types of graphs (bar, line, pictograph) They predict the data set they can garner several boxes of conversation hearts. Students record their data using an Excel spreadsheet. They create a graph based...
+
Lesson Plan
Curated OER

"Living in the Limelight The Universal Dream"

For Teachers 9th - 12th
Students, using Leo's Lyrics, investigate common themes in popular music. They create a Microsoft Excel spreadsheet that analyzes their findings along with a 200 word paragraph stating their observations, conclusions and hypotheses about...
+
Lesson Plan
Curated OER

Does Humidity Affect Cloud Formation?

For Teachers 6th - 8th
Students use S'COOL data to identify factors that affect cloud formation. They find a data set using the S'COOL database , and use Excel to manipulate the data. Student isolate relevant data, create meaningful graphs from a spreadsheet,...
+
Lesson Plan
Curated OER

Math Hunt

For Teachers 8th - 10th
Go on a scavenger hunt around your school to find evidence of math. Investigate different areas of your school for patterns, fractions, and different geometric shapes. Finally, create a spreadsheet and plot the data you've collected.

Other popular searches