PBL Pathways
Medical Insurance
Design a plan for finding the best health insurance for your money. Learners compare two health plans by writing and graphing piecewise functions representing the plan rules. Using Excel software, they create a technical report...
Curated OER
The Viewing Tube
Looking for an excellent lesson that incorporates math, science, and technology? Groups of three students use a viewing tube to perform an experiment, and discover how to organize their data into an Excel spreadsheet. This is a...
Curated OER
Tessellations in Excel
Students complete an Excel project on tessellations. In this technology and math lesson, students discuss tessellations and their occurrences in nature. Students use the Excel computer program to create tessellations.
Curated OER
Microsoft Office Excel
Students 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.
Curated OER
Be Sharp and Never Flat
An outstanding lesson on music awaits your young composers! They learn about patterns found in music, the different sections of an orchestra, and see the differences between musicians and a composer. Excellent streamed videos and good...
PBL Pathways
Students and Teachers 2
Examine trends in student-to-teacher ratios over time. Building from the first task in the two-part series, classes now explore the pattern of student-to-teacher ratios using a non-linear function. After trying to connect the pattern to...
Sea World
Endangered Species
Study different endangered species with several activities that incorporate math, science, language arts, and research strategies. A great addition to your lesson on conservation or Earth Day.
Curated OER
Calculating Profits from Selling Virtual Lemonade
Students set up and collect data for a virtual lemonade stand. In this entrepreneurship, economics, and technology lesson plan, students purchase ingredients, determine costs, and set up a virtual lemonade stand. Students consider...
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
Graphing Our Marbles
Students collect information pertaining to marble colors found in their bag; then creating a spreadsheet in order to make a chart representing their findings using Microsoft Excel. Students will present their results to small groups.
Curated OER
Band Tour Across America
Learners plan the trip of a band across America. In this money planning lesson, students create a budget for the band using excel basic functions. They manage the band and its budget and relate the tour to future budgeting needs of the...
PBL Pathways
Medical Insurance 2
Make an informed decision when choosing a medical insurance provider. An engaging lesson asks your classes to write piecewise models to represent the cost of different medical plans. The project-based learning activity is a variation of...
Curated OER
Data! Data! Graph that Data!
Fifth graders create data graphs using Microsoft Excel. In this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
Curated OER
Topic 6: Evaluating and Presenting Results
Students construct spreadsheets from raw data. In this spreadsheet construction lesson, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.
Curated OER
Fraction Strips on Excel
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...
Curated OER
FILLING EMPTY POCKETS: BORROWING, LOANS AND CREDIT.
Students learn that maintaining financial security takes a good math understanding. In this instructional activity, students apply mathematical formulas to make important financial decisions like getting the right loan to buy a house,...
PBL Pathways
College Costs 2
What is the financial benefit for attending a community college for the first two years before transferring to a four-year college? The second part of the educational lesson asks young scholars to explore this question through data...
PBL Pathways
Potassium-Argon Dating
Find the age of a fictional sample of rocks using a genuine approach. A well-designed lesson asks young mathematicians to use exponential modeling to analyze half-life. As a project-based learning activity, scholars communicate...
Curated OER
Great Online Art Sites
Students complete an online study of art websites. In this art and technology lesson, students explore the links and try the activities to learn about art online.
Curated OER
The Survey Says
Students experience the development of statistical data. In groups, they construct a survey questionnaire for a target audience. Students produce the questionnaire, distribute it, collect it, and tabulate the data. Using EXCEL, the...
Curated OER
Making a Spreadsheet
Students explore spreadsheet software. In this personal finance and computer technology lesson, students develop a vacation spreadsheet on the computer. Students represent hotel, food, transportation, and entertainment costs...
Curated OER
Is the Rainbow Fair?
Third graders perform statistical calculations. Given a bag of Skittles, 3rd graders sort and collect data regarding the colors included in their bag. Using spreadsheet software, students create a bar graph of the information collected....
PBL Pathways
Medical Insurance 3
Create a technical report explaining the components of a medical plan through a function. The project-based learning activity gives a medical insurance scenario that young mathematicians model using piecewise functions. Their analyses...
PBL Pathways
College Costs
Predict the year that college costs will double in your state using linear modeling. The first part of this two-part project based learning activity asks young mathematicians to use data from the College Board. They graph the data,...