Lesson Plan
Curated OER

Influence of Beauty, The Beauty of Influence

For Teachers 10th
Tenth graders explore the influence of art on modern societies. Through the internet, they assess paintings of advertisements for commercial products and social-political beliefs. Using spreadsheet software, the class compares and...
Activity
Curated OER

Viral Marketing

For Teachers 9th - 12th Standards
What is "viral marketing" and how does it relate to mathematics? Young mathematicians use exponential functions to develop a mathematical model for a business advertising campaign. Learners then see how their campaigns increase...
Lesson Plan
Curated OER

Get a Life Project

For Teachers 8th
Eighth graders participate in interdisciplinary career unit in which they explore alternate lives. Students assume roles, manage budgets, make decisions, and solve problems, Students then research challenges, develop solutions, and...
Lesson Plan
Curated OER

Comparing Temperatures in Different Cities

For Teachers 6th - 12th
Students generate a spreadsheet to calculate average daily temperature. They create graphs from spreadsheet data and comprehend the components of the a spreadsheet.
Lesson Plan
Curated OER

Graphing With Second Graders

For Teachers 2nd
Second graders sort M & M's and then enter the data into a spreadsheet in order to create a simple graph. After printing the spreadsheet generated graph, have students compare the printed graph with their paper graph.
Lesson Plan
Curated OER

Twelve Days of Christmas

For Teachers 6th - 8th
Students create charts and graphs using a spreadsheet. They chart the number of each gift given day by day from the song, "The Twelve Days of Christmas." They create a bar graph and a circle graph from their data on the spreadsheet.
Lesson Plan
Curated OER

TV Viewing

For Teachers 7th - 8th
Students test a hypothesis to see if there is a direct correlation between number of hours of TV viewing and academic grade. They collect and compile data to enter on a spreadsheet and create a word processing document supporting their...
Lesson Plan
Curated OER

Best Buy!!

For Teachers 6th - 8th
Learners use newspaper ads to determine the best buy on products. They enter the information into a spreadsheet and then use word processing software to complete a written analysis, complete with graphs.
Lesson Plan
Curated OER

Measuring Mania

For Teachers 6th - 8th
Students rotate through stations in the classroom, completing different types of measurements. These measurements are placed into a spreadsheet, and a scatter plot is generated. They type an explanation of their results in correlation...
Lesson Plan
Curated OER

Stock Reports

For Teachers 6th - Higher Ed
Students spend $10,000 by picking up to 3 stocks in which to invest. They monitor their progress for three weeks, and chart results in a spreadsheet template.
Lesson Plan
Curated OER

Toy Planet

For Teachers 4th - 6th
Students design a toy store, supply it with merchandise (on paper) and create advertisements. They also manage the store's debits and credits by using a spreadsheet. They consider how to promote the sale of their merchandise.
Lesson Plan
Curated OER

Electronic Spreadsheets & Iditarod 2000

For Teachers 6th - 8th
Students use the Internet for gathering information for Iditarod race journals. They use a spreadsheet program for entering data and making charts for showing changes in speeds achieved over a period of four weeks in timed writings in...
Lesson Plan
Curated OER

Spyglass Transform

For Teachers 6th - 11th
Students transfer information previously saved in a spreadsheet to Spyglass Transform. They visualize the data and explain what it means
Lesson Plan
Curated OER

Our Favorite Pet

For Teachers K
Students each have a turn, telling the class his or her favorite pet. The choices are cat, dog, fish or bird. Using the computer, the information from the tally be recorded on a spreadsheet and bar graph.
Lesson Plan
Curated OER

Newspaper

For Teachers 8th
Eighth graders, in groups, create a newspaper using topics from an assigned chapter. They use ClarisWorks word processing, insert graphics, and create graphs using spreadsheets.
Lesson Plan
Curated OER

Bones and Math

For Teachers 5th - 12th
students identify and explore the connection between math and the bones of the human body. Students collect data about bones from their classmates and from adults, apply formulas that relate this data to a person's height, and organize...
Lesson Plan
Curated OER

Strength Building

For Teachers 5th
Fifth graders go to each of the 3 stations testing their maximum strength and then make a spreadsheet and how to work with excel. Students create and finish their spread sheet on how they did on day 1.
Lesson Plan
Curated OER

Space Presents Problems

For Teachers 6th - 8th
Middle schoolers use the internet to research problems related to space. They complete a questionaire to direct their research before beginning. They create a database of moon and planet characteristics.
Lesson Plan
Curated OER

Understanding Food Labels

For Teachers 3rd - 5th
Students determine the number of calories, serving size, and vitamins and minerals in different food products and use this information to create a formula determining the number of calories per serving size and the daily percentages of...
Lesson Plan
Curated OER

Body Length Experiment

For Teachers 3rd - 5th
Students measure the lengths of their bodies and various body parts to determine the relationship (or lack of one) between body part length and the length of the entire body. A spreadsheet program is suggested for data collection.
Lesson Plan
Curated OER

Learning and Population Information - Where I Live

For Teachers 4th - 5th
Learners study their county populations in a multimedia presentation format. In this populations lesson, students work in groups of 3 to research the county populations in their state. Learners chart their results in an Excel document...
Lesson Plan
Curated OER

2D Kinematics w/ String Racers

For Teachers 11th - 12th
Students calculate the speed of string racers. In this physics lesson, students measure the time in several trials and get the average. They graph their results using a spreadsheet.
Lesson Plan
Curated OER

Destination Mars!

For Teachers 5th
Fifth graders view Mysteries of Earth & Mars Video on DVD and record thoughts in their online journal. They record data in a spreadsheet about each planet then form a theory of the best time to launch a space craft from Earth to land...
Lesson Plan
Curated OER

Chart/Graph

For Teachers 3rd - 8th
Students create a class survey, place the data in a spreadsheet and graph the information.