Curated OER
Introductory Excel Lesson involving Problem Solving
Sixth graders analyze an introductory lesson for Microsoft Excel. They go step by step through the creation of a basic spreadsheet and the use of simple formulas in a problem solving format.
Curated OER
Data Lesson Vital Information
Students prepare and collect data and use excel and create a graph. They collect data about the number of pattern blocks that are put on tables. Students then record that data in Excel.
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,...
Curated OER
A Financial Flower Garden
Here is another in the interesting series of lessons that use the special State Quarters as a learning tool. This one uses the Mississippi State Quarter. During this instructional activity, pupils learn about the variety of state flowers...
Curated OER
How Credit Card Interest Works
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...
Curated OER
Data Analysis Challenge
In this data analysis worksheet, young scholars work with a partner to collect information for a survey. The information is then compiled into a graph. Learners must indicate their survey question, the target audience, predict the...
Berkshire Museum
Adopt a Schoolyard Tree
Help young scientists connect with nature and learn about trees with a fun life science lesson. Heading out into the school yard, children choose a tree to adopt, taking measurements, writing descriptions, and drawing sketches of it in...
Curated OER
Using Excel To Teach Probability And Graphing
Students engage in the use of technology to investigate the mathematical concepts of probability and graphing. They use the skills of predicting an outcome to come up with reasonable possibilities. Students also practice using a...
Curated OER
Positive Future Fair Project
Ninth graders view the film "Pay It Forward" and discuss what kind of public campaign is needed to move people to positive action. They consider different ways of presenting information (graphs, visual displays, etc.) as tools for...
John Lentine
Butterflies and Bugs
Symmetry, line, shape, art, and math are all connected through a fun hands-on craft. Included are instructions to a classic activity, where learners create butterflies to show symmetry in nature and then discuss symmetry in math. It is...
Curated OER
Building Arrays Using Excel Spreadsheets
Young scholars create arrays using Microsoft Excel. For this technology-based math lesson, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.
Curated OER
Survey Project
Eighth graders create a website using FrontPage. They use inserted forms to collect survey information and use Microsoft Excel and MS Word to create a presentation of the survey and the results.
Curated OER
Enrichment Project
Students create enrichment activities for Geoboards, Napier Rods, and Bean Sticks. This includes annotated links to problem solving Internet Sites.
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
What's Your Favorite? Survey And Graphing Project
Sixth graders create and edit spreadsheet documents using all data types, formulas and functions, and chart information. They collect and organize data that be portrayed in a graph that they create using EXCEL.
Curated OER
George and Sam Save for a Present
Third graders develop their algebraic thinking by recognizing a variety of patterns using concrete objects, numbers, tables, and pictures. In this George and Sam Save for a present lesson, 3rd graders communicate their mathematical...
Curated OER
Integrating Math and Sports Project
Students work in pairs to choose a set data from one of the sports websites for their chosen sports. They find the mean, median, mode, and range of their data set. Students create a graph on Microsoft Excel and write several...
Federal Reserve Bank
Creating a Budget
Learning to create and maintain a budget is an important life skill. Guide individuals in the discovery of their spending habits and how to track them. They then use what they learned to create a budget and make decisions on where they...
Kenan Fellows
Saving Those Who Save Us: Exploring the Use of Sensors with Data Visualization
Sensor technology is amazingly accurate and useful. Combining the sensor technology and mathematical knowledge, scholars design experiments to answer a question they have developed. Questions may focus on light sensing, temperature...
Curated OER
Time Management
Students record their daily activities and graph the results using the educational software program called Inspiration. This lesson is intended for the upper-elementary classroom and includes resource links and activity extensions.
Curated OER
Penny Pushing
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...
Curated OER
Soil Excavation
Students comprehend how percent of change and multipliers are used to determine volume for removal and replacement of soils. They calculate soil volume percent changes using data tables. They apply formulas to solve a variety of...
Curated OER
Rule of Quarters
Students memorize four key decimal values for quick and accurate conversion. They convert decimal foot measurements to inches and fractions using math tables, computation or memorization. They memorize decimal foot conversions.
Curated OER
More or Less Pigs in the Pen
Kindergarteners practice basic addition and subtraction. In this math lesson, students sing a song about pigs on a farm to help them understand the concept of adding and subtracting things together. Some excellent extension activities...