Curated OER
Basic Excel
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. ...
Curated OER
Introducing Tessellations
Students create tessellations to increase their knowledge of the applications of geometry. They explore the different shapes of polygons.
Curated OER
Excel temperature Graphs
Students gather data about the weather in Nome, Alaska. In this Nome Temperature lesson, students create an excel graph to explore the weather trends in Nome. Students will find the average weather and add a trend line to their graph.
Curated OER
Simple Bar Graphs Using Excel
Students create original survey questions, and develop a bar graph of the data on paper. They input the survey data using two variables onto an Excel bar graph spreadsheet.
Curated OER
Tracking Your Favorite Web Sites
Ninth graders track the hit count on their favorite web sites. In this Algebra I lesson, 9th graders record the number of hits on their favorite web site for twenty days. Students explore the data to determine if the relation...
Curated OER
Creating Circle Graphs using Excel
Fifth graders evaluate data from a circle graph that compares time spent on various activities. They use the computer to manipulate their own data as they compare, examine, create and evaluate data using circle graphs.
Curated OER
Using Excel to Draw a Best Fit Line
Middle schoolers create line graphs for given data in Microsoft Excel. Students follow step by step instructions on how to create their graph, including how to create a trend line. Middle schoolers print graphs without trend lines and...
Curated OER
Lunch Food? Mmmm! Mmmm! Good!
Examine how nutrition plays an important role in our lives by conducting online research and developing lunch menus that satisfy nutritional requirements set up by the United States Department of Agriculture. Students download recipes,...
Teach Engineering
Applying Statistics to Nano-Circuit Dimensions in Fabrication
Do flexible circuits change dimensions during fabrication? Groups use GeoGebra software to measure the length of pictures of flexible nano-circuits. To determine if the circuits change dimensions, future engineers use Microsoft...
Curated OER
Estimation
Select items to purchase from a store, add up the total cost, then estimate the total cost! Kids count out the money needed to make the purchase and pay for the items. An excelent way to connect real life math and estimation!
Curated OER
Hopes and Dreams: A Spreadsheet Lesson Using Excel
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
Curated OER
Traffic Problem- Solved Using Microsoft Excel
Students relate algebra to real life scenario. In this algebra lesson, students design a plan to help traffic flow smoothly using velocity and speed. This assignment is done using Microsoft Excel.
Curated OER
Sales Spreadsheet
Young scholars use Excel spreadsheets to organize purchases, discounts, sales prices, and sales tax. Students follow step by step instructions and enter formulas as well as use the auto sum feature to calculate required calculations.
Curated OER
Learning and Population Information - Where I Live
Students study their county populations in a multimedia presentation format. In this populations lesson, students work in groups of 3 to research the county populations in their state. Students chart their results in an Excel document...
Curated OER
What Temperature Is It?
Students 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, minimums and...
Curated OER
What Percentage of Time Do You Spend Doing Daily Activities?
Engage your kids with an intriguing, real-life exploration that covers several areas in math, and allows for natural academic differentiation.
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
Money Math: Lessons for Life
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...
Curated OER
Data, Data, Everywhere... and What Am I To Think?
Students demonstrate good random sampling techniques for data collection, select and develop graphic presentations of data and analyze the data to solve a problem presented.
Curated OER
Pumped Up Gas Prices
Learners calculate gas prices. In this transportation instructional activity, students tally the mileage and gas costs of their car for one months. They figure out how much was spent on gas and create a graph showing average gas prices...
Curated OER
Linear and Exponential Growth
Young scholars explore the concept of linear and exponential growth. In this linear and exponential growth lesson, students collect data about China's population. Young scholars model the data to determine if it is linear or exponential.
Curated OER
Taxes: Where Does Your Money Go?
Learners explore the concept of taxes. In this tax lesson, students investigate types of taxes and deductions taken out of a paycheck before they see it. Learners calculate the tax on a given dollar amount. Students discuss 401(k)s...
Curated OER
Geometry Shapes Playground Safety
Students create a new playground design to present to elementary students during Playground safety week. They review basic geometry to use in observing and recording the equipment on a local playground. They research playground safety...
Curated OER
Statistical Pictures of School and Life
Students explore how mathematical data is used to summarize and illustrate everyday life. They apply mathematical concepts and skills to analyze data. Students conduct a five question survey of 50 people or more and graph the data.