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.
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
Making Money and Spreading the Flu!
Paper folding, flu spreading in a school, bacteria growth, and continuously compounded interest all provide excellent models to study exponential functions. This is a comprehensive resource that looks at many different aspects of these...
Curated OER
USING MICROSOFT, POWERPOINT, WORD, EXCEL AND THE INTERNET TO CREATE A PRESENTATION
Explore the basic PowerPoint commands and options. They research information (including the WWW) related to an approved topic for presentation development. They create a presentation defined by specific criteria. They document research...
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.
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...
Statistics Education Web
NFL Quarterback Salaries
Use statistics to decide if NFL quarterbacks earn their salaries! Learners study correlation coefficients after using technology to calculate regression equations. Through the data, they learn the meaning of correlation and correlation...
Curated OER
Math Lesson: What Do You Want to Know? - Country Statistics
Learners are able to identify the characteristics of a variety of graphs (i.e. bar graph, line graph, pie graph, scatter plot, population pyramids, etc.) They recognize how the type of data to be presented plays a role in choosing 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
Band Tour Across America
Young scholars 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...
Code.org
Making Data Visualizations
Relax ... now visualize the data. Introduce pupils to creating charts from a single data set. Using chart tools included in spreadsheet programs class members create data visualizations that display data. The activity encourages...
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
FILLING EMPTY POCKETS: BORROWING, LOANS AND CREDIT.
Students learn that maintaining financial security takes a good math understanding. In this lesson, students apply mathematical formulas to make important financial decisions like getting the right loan to buy a house, decide which...
Space Awareness
Navigation in the Ancient Mediterranean and Beyond
Ancient texts, like Homer's Odyssey, mentions navigating ships by observing constellations. Pupils learn about the link between history and astronomy as they relate to navigation in the Bronze Age. Scholars complete two hands-on...
National Research Center for Career and Technical Education
Depreciation (Double Declining)
Have you ever been told that your new car begins to lose its value as soon as you drive it off the lot? Aspiring accountants take on the concepts of depreciation and book value through an easy-to-deliver career and technology lesson...
Curated OER
Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions
Learners improve data entry in a spreadsheet.
Kenan Fellows
Let's Move
Find a statistical reason for a fresh start. Using a hypothetical scenario, individuals research statistical data of three different cities. Their goal? Find the best statistical reason for a business to move to a new location. Their...
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,...
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
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.
Discovery Education
Sonar & Echolocation
A well-designed, comprehensive, and attractive slide show supports direct instruction on how sonar and echolocation work. Contained within the slides are links to interactive websites and instructions for using apps on a mobile device to...
National Wildlife Federation
Get Your Techno On
Desert regions are hotter for multiple reasons; the lack of vegetation causes the sun's heat to go straight into the surface and the lack of moisture means none of the heat is being transferred into evaporation. This concept, and other...
Visa
Bank or Bust: Selecting a Banking Partner
Why shouldn't we just save all our money in our mattress? Couldn't our money disappear? Pupils discover the benefits of utilizing banks and credit unions for saving money, as well as how to evaluate different types of institutions by...
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...