Math Lesson Plans
Word Processing/Spreadsheet
Overview
Students will compare prices to determine the best buy. They will
collect data from newspaper advertisements and enter the data on a spreadsheet and
create a word processing document complete with graphs to support their
findings.
English and Math (Statistics, spreadsheets and graphs)
Overview:
After reading “Casey at the Bat” and discussing the
sports “hero,” students use the Internet to research real
baseball heroes. In groups, students compare individual baseball
players’ hitting and/or pitching statistics and nominate one
baseball hero per group. Students then justify their conclusions by
creating spreadsheets and generating graphs of the data. Finally,
students individually write a short editorial which incorporates a
graph and tells why their player is a hero based on overall
achievement as well as statistics
Spreadsheet
Overview:
Students are given a list of items purchased with prices,
deposits, and withdrawals in a checking account format. They will
create a spreadsheet by entering the information into the appropriate
cells and the formula that is necessary for computation.
Word Processing/Spreadsheet
Overview
Students will use the concepts of changing percent to decimal and
rounding (hundredth) to find discounts. They will use the subtraction
operation to find sale prices. The students will gather sale price
data to enter on spreadsheet to compare with others.
Word Processing & Internet Research (Math History &
Mathematicians)
Overview
Mathematicians and scientists are people too!!!!! Did you know
that Sir Isaac Newton was inspired to study mathematics after a fight
with a school bully? Leonhard Euler wrote more mathematics than
anyone -- even after he became totally blind!!!! Great mathematical
or scientific discoveries were made by real people who experienced
the same misunderstandings and frustrations that we all do when
learning a new concept. The purpose of this activity is for you to
research a person who made a math or science discovery happen.
Overview:
Students will create a spreadsheet to match a given sample. This will
include adjusting column width and row height, changing alignment,
changing size and style of print, changing number format. They will
learn the concept of compound interest and write formulas to complete
the investment chart. They will create a line graph displaying the
results of the chart.
Word Processing/ Spreadsheet (Scatter Plot Activity)
Overview
The students will compile and enter different sets of data on a
spreadsheet to be used in constructing scatter plots. The data will
be collected by completing different stations set up in the
classroom. A word processing document that describes the different
correlations found will also be created.
Spreadsheet (Statistics/Percents)
Overview
After completing a game-like simulation to determine a career and
salary, student groups will collect information and decide what is
the “best” city in which to live. Students will
individually choose a “best” city, support their decision,
and create a monthly budget for their “best” city based on
the salary from the simulation.
English and Math (graphs and spreadsheets)
Overview :
Students in groups of two will create a newspaper using topics
from an assigned chapter. Students will use ClarisWorks word
processing, insert graphics, and create graphs using spreadsheets
Geosketchpad
Overview :
Students will use the geosketch pad program to come up with a
design given certain guidelines.
Internet/Spreadsheets
Overview
The class will research statistical information involving racial
breakdown of the United States population by gender and ethnicity.
These breakdowns could consist of issues such as population changes,
number of AIDS cases, death rates and educational levels. This will
give students an opportunity to use the Internet to access and
analyze current data.
Spreadsheet Activity
Overview
Part of the Fairfax County Numerical Reasoning POS is for the
students to be able to create and design a spreadsheet. This lesson
will familiarize students with searching for information on the Web.
Integrating the data collected from the Web into a spreadsheet adds a
sense of interest and ownership to the project. The students are
researching a topic they are familiar with and which they like.
Integers and Literature :Using Timeler 4.0 Software
Overview
As an interdisciplinary project, students will demonstrate their
understanding of the placement of integers on a number line. Students will place integers on the timeline corresponding to zero, the date
of their birth. Events will relate to significant family and personal
events before they were born and during their lives. In addition,
students will place the publication or copyright dates of literary
selections they have read throughout the year on the timeline.
Word Processing/Spreadsheet (Statistics/Scatter plots)
Overview
Students will test a hypothesis to see if there is a direct
correlation between number of hours of TV viewing and academic grade.
They will collect and compile data to enter on a spreadsheet and
create a word processing document which will include data and graphs
to support their hypothesis.
Geometer’s Sketchpad and a computer
Overview
Students will investigate the rigid motions of reflection,
rotation, translation, and dilation.
Computer with Microsoft Excel
Overview
A walk-through introducing the basics of spreadsheet development
using Microsoft Excel.
Computer
Overview
The lesson includes research from web sites, copying and pasting
graphics and/or text from the Internet to a word processing document
and composing a final draft of a booklet.
Computers with Internet access, TI-82 or TI-83 graphing
calculators
Overview
The students will research box plots on the Internet and
then gather real life statistics. They will analyze the collected
statistics by making multiple box plots on the TI-83 calculator and
comparing the one variable statistics.
Computer
Overview
Students will create and maintain a spreadsheet budget based on a
predetermined salary. They will have an opportunity to make
“investments and purchases.”
Computer with Data Explorer Software
Overview
Test scores from a recent test have been compiled from 3 classes
and the data is given to the students for their analysis. In the
computer lab the students will use Data Explorer to input the data
and display as 3 stacked box plots. Students will analyze the data and
write a paragraph of their analysis.
(Candy that is about the same size and weight), another type of
weight (heavier candy or dimes), two meter sticks or yardsticks per
group, small cup (I used the containers that holds a roll of film),
wire, masking tape, graph paper, loose-leaf paper (for notes and to
record information), straight edge, pencils, graphing calculators,
ClarisWorks or Microsoft Word
Overview
Description of Lesson (includes context):
Before conducting this activity, students should have experience
creating tables of values and plotting points on a coordinate plane. This lesson is a concrete example of linear progression. The
abstract ideas of slope and intercepts are represented in this
activity as the constant weights (slope) and the length of the spring
with no weights (y-intercept). Students will have the opportunity to
create tables of values and graph lines using paper and pencil and
the graphing calculator. Students will use either ClarisWorks or
Microsoft Word to answer questions focusing on the effects of slope
and intercepts on the graph of a line.
Quick Reference Section
|
