Curated OER
Excel Lesson
Students investigate Microsoft excel. In this technology lesson, students create formulas using excel and apply these formulas to solve relative, absolute and mixed reference cells. They perform immediate and delayed calculations.
Curated OER
Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs
Students, while in the computer lab, assess how to use Microsoft Excel as a "graphing calculator." They view visual representations of line graphs in a Cartesian plane while incorporating basic skills for using Excel productively.
West Contra Costa Unified School District
Correlation and Line of Best Fit
Computers are useful for more than just surfing the Internet. Pupils first investigate scatter plots and estimate correlation coefficients. Next, they use Microsoft Excel to create scatter plots and determine correlation coefficients and...
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
Creating Circle Graphs with Microsoft Excel
Students create graphs of circles. In this geometry lesson, students use Microsoft Excel to create graphs. They construct the graphs using paper and pencil as well as the computer.
Curated OER
Tracking Your Favorite Web Sites
Ninth graders track the hit count on their favorite web sites. In this Algebra I instructional 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
Daily Time Ratios
Students track and record how much time they spend on each activity. In this spreadsheet lesson, students apply different functions using Microsoft excel to format cells and calculate the sum of their total time spent each day. They...
Curated OER
Technobiz
Students examine candy preferences to create a plan in order to improve candy sales. In this technobiz lesson, students build spreadsheet and organizational skills by graphing and calculating data. Students are introduced to terminology...
Curated OER
Cockroach Slope
Students identify the slope of linear functions. In this slope lesson, students collect data and graph it. They write equations with no more than two variables and use technology to explain their data.
Curated OER
Interest Calculation and Spreadsheets
Students, while in the computer lab working on a spreadsheet program, calculate interest and accumulated value of a savings plan. They follow specific directives on how to create their spreadsheets. At the end of the lesson they print...
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
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 sample...
Curated OER
Cross Cultural Transportation and Resources Exchange
Students examine various modes of transportation. They explore regional transportation options and discover options available in their area. Students survey types of transportation people use in their area. Using spreadsheet data,...
Curated OER
The "U's" Have IT!
Students explore the maximum and minimum values of parabola. In this exponential equations lesson, students use graphing calculators or TI Interactive Software to calculate values of parabola and graph x-intercepts of parabola.
National Council of Teachers of Mathematics
National Debt and Wars
Take a functional approach to the national debt. Learners collect information about the national debt by decade and plot the data. They determine whether an exponential curve is a good fit for the data by comparing the percent changes...
Curated OER
There's No Accountin with Ledgers
Tenth graders create and maintain a ledger, write an essay for the process, and learn to keep financial accounts through the ledger. In this ledger activity, 10th graders define an accounting ledger and create one for the money they've...
Curated OER
Money and health
High schoolers write a proposal with an appropriate budget to establish a health day at school. They design this day to educate and promote good health. They educate other students about health care, inform high schoolers of health...
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
Plan A Trip Anywhere
Students role play being an international travel agent that is planning a trip for a client. The teacher gives specific details associated with the trip. They choose the destination and work out some of the other details. Students...
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 lesson, 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 discuss 401(k)s...
Curated OER
Statistical Pictures of School and Life
Pupils 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.