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
Excel temperature Graphs
Students gather data about the weather in Nome, Alaska. In this Nome Temperature instructional activity, students create an excel graph to explore the weather trends in Nome. Students will find the average weather and add a trend...
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 activity, 9th graders record the number of hits on their favorite web site for twenty days. Students explore the data to determine if the...
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 instructional activity, students design a plan to help traffic flow smoothly using velocity and speed. This assignment is done using Microsoft Excel.
Curated OER
Sales Spreadsheet
Students 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
Learners 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. Learners chart their results in an Excel document...
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
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
"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
Students calculate gas prices. In this transportation lesson, 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 over time.
Curated OER
Linear and Exponential Growth
Students explore the concept of linear and exponential growth. In this linear and exponential growth lesson, students collect data about China's population. Students model the data to determine if it is linear or exponential.
Curated OER
Taxes: Where Does Your Money Go?
Students explore the concept of taxes. In this tax instructional activity, students investigate types of taxes and deductions taken out of a paycheck before they see it. Students calculate the tax on a given dollar amount. Students...
Curated OER
Geometry Shapes Playground Safety
High schoolers 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...
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.
Curated OER
"So Tell Me About Your Trip..."
Young scholars research destinations and the factors involved in taking a trip and explore how averages play a part in making decisions. They explore how to find the average speed and the distance to a particular destination, they...