Professional Learning Podcast Treasury Lesson Plans Personal Workspace Site Search ALEXville Learning Assets Home Courses of Study

ALEX Lesson Plans


Subject: Mathematics (4 - 6), or Social Studies (7), or Technology Education (6 - 8)
Title: Can you survive in the real world?
Description: Living in the real world is expensive and sometimes hard for a new college graduate to adjust to. This lesson will allow students to see the importance and need of budgeting money. Students will have to make choices and research different budget areas. Can they survive in the real world? This lesson plan was created as a result of the Girls Engaged in Math and Science University, GEMS-U Project.  


Subject: Social Studies (7), or Technology Education (6 - 8)
Title: GPS Scavenger Hunt
Description: This lesson will provide 7th and 8th grade students the opportunity to utilize GPS Handheld Tracking Units in order to understand latitude and longitude. Students will work in groups of four to complete a scavenger hunt around the campus; they will be using the GPS units to guide them to the final destination. Students will answer questions about the points listed on the handout provided by the teacher.


Subject: Social Studies (7), or Technology Education (6 - 8)
Title: Discover the World of GPS and Geocaching
Description: This lesson will be a creative approach to learning latitude and longitude, and will introduce the students to new technology. Seventh grade students will be given the opportunity to utilize GPS Handheld Tracking Units to understand latitude and longitude. Students will work in groups of four to complete a geocaching activity and a scavenger hunt around campus; they will be using the GPS units to guide them to the final destination. Students will answer questions about points listed on the handout provided by the teacher. We decided to offer this activity as a collaborative effort for one grade level in order to allow all the students the opportunity to participate and work together. This decision allowed us to have four teachers to work together supervising the students. (We also utilized volunteers to assist with supervising each group of students.)


Subject: Technology Education (6 - 12)
Title: All I Want for Christmas (a spreadsheet investigation)
Description: Students will complete a Santa list using a Spreadsheet. Students will enter a list of items they want for Christmas, try to estimate the cost, and total their cost. They will then go on an internet shopping trip to find the actual cost of their items. They will then have an itemized list they can give to their special "santa".


Subject: Technology Education (6 - 12)
Title: Spreadsheets -- A New Study Tool
Description: Students will learn to use spreadsheets to enter if-then statements that can then be used for study guides for any subject area. Students will create a generic spreadsheet that gives feedback when they enter a correct response to a particular question. They must understand the questions they are entering in order to enter the correct formula to get the desired feedback.


Subject: Technology Education (6 - 12)
Title: Using Spreadsheets to Calculate Your Grades
Description: This practical use of spreadsheets will allow students to practice entering data, and finding the sum and the mean for the set of data. It will reinforce skills the students have already learned about spreadsheets. In addition, students will be able to manipulate their data to see the effects of low scores on assignments.


Subject: Technology Education (6 - 12)
Title: Graphing for Dollars
Description: This is a collaborative effort between Leo Straughn, Riley Robinson and Barbara Lucassen. It is a lesson for cooperative learning groups of 2-3 students. This lesson will take place in the classroom if there is computer access or in a computer lab. This lesson uses a real-world scenario to teach students how to evaluate an account balance by creating a linear equation. From this equation, the students will determine the slope and y-intercept and create a graphical representation of the account balance. Students will use this graph to extrapolate information to answer probing questions.


Subject: Mathematics (7), or Science (7), or Technology Education (6 - 8)
Title: Where Did You Get Those "Jeans"?
Description: This lesson can be interdisciplinary involving science, mathematics, and language arts. The primary nature of the lesson is inquiry, project, and technology-based. In science this project is a culminating activity in the heredity unit.


Subject: Technology Education (3 - 12)
Title: Parent Brochures for English Language Learners
Description: In this lesson English Language Learners will design and publish a brochure that introduces the school to their parents. The brochure includes English and native language translations, pictures, and explanations of school function. The lesson can be adjusted for any grade level.


Subject: Mathematics (6 - 8), or Technology Education (6 - 8)
Title: You WANT me to make a paper airplane?
Description: This lesson provides students with a hands-on, cooperative learning experience. Students will make paper airplanes. They will fly their planes and record the distance and time of numerous flights in an Excel spreadsheet. Students will then calculate the speed of each flight using the formula s=d/t and summarize their results by making a line graph.


Subject: Mathematics (6 - 7), or Technology Education (6 - 8)
Title: Trading and Tracking Stock Portfolios Online
Description: Student teams will trade stocks and track the progress of their Alabama Stock Market Simulation portfolio by using spreadsheet software and the Internet. They will relate the information to a previous social studies unit on economics and will be utilizing math concepts they have learned. The Internet will be used to research stock trends.


Subject: Mathematics (6), or Technology Education (6 - 8)
Title: Food Fit for a King?
Description: During this lesson, students will have the opportunity to interpret and create bar graphs to compare the nutritional values of fast food. Students will learn many skills during this lesson that will help them create graphs independently. The Internet will serve as a reference to help them learn to create graphs using a spreadsheet program.


Subject: Arts Education (6 - 8), or English Language Arts (7), or Technology Education (6 - 8)
Title: Brian's Winter by Gary Paulson: Using Art to Study Plot
Description: In this interdisciplinary lesson, students examine the artwork in Lasceaux Cave in France via Internet and illustrate a chapter summary from Brian's Winter by Gary Paulson in "caveman style."


Subject: Mathematics (6 - 7), or Technology Education (6 - 8)
Title: How Much Money Can I Make?
Description: This lesson is a technology-based activity in which students will research two careers they are possibly interested in pursuing. They will convert the average yearly salary of each career into an hourly wage and record their findings in a spreadsheet. They will calculate their weekly gross and net pay for each career choice.


Subject: Science (8), or Technology Education (6 - 8)
Title: Sonar Mapping of the Ocean Floor
Description: Mapping the ocean floor must be done by indirect observation. One method involves bouncing a sonar signal off of the ocean floor and measuring the length of time this signal takes to return. This length can be translated into distance: Distance=Speed of Sound X Time/2. In this lab, students will be making indirect observations using a wooden rod as the "sonar signal."


Subject: Technology Education (6 - 8)
Title: From Here to Technology
Description: Students will create a slide on an assigned topic that will become part of a class presentation. The class presentation will trace the evolution of the computer, identify the pioneers of technology, investigate the impact technology has had on the workplace and society, and examine how technology has influenced the course of history in geneeral. This project is a semester long assignment with required progress due each six weeks. Computer lab time will need to be made available either during or after school throughout the semester.


Subject: Science (8), or Technology Education (6 - 8)
Title: Newton's Laws of Motion
Description: Students use toy cars, a CBR sonic motion detector, and pennies to investigate Newton's Laws of Motion.


Subject: Technology Education (6 - 12)
Title: Spreadsheets 101
Description: This lesson introduces students to the function and use of spreadsheets. It includes a Power Point presentation (to be used by the teacher) as well as beginning student assignments.


Subject: Mathematics (6), or Technology Education (6 - 8)
Title: Exploring Length and Perimeter
Description: In this lesson students manipulate and calculate the perimeter of geometric shapes on a grid through the use of a technology-based resource. Hands-on activities and class discussion reinforce the concept. This lesson can be used as a follow-up lesson or to introduce perimeter and length.


Subject: Social Studies (7), or Technology Education (6 - 8)
Title: Personal Economics
Description: Students will be able to explain the various services available to protect consumer rights. They will develop a PowerPoint presentation in their student achievement teams which contains the required information along with a question section. This presentation will then be used in class for a review activity prior to testing.


Subject: Technology Education (6 - 8)
Title: Understanding Nutrition Labels
Description: In this lesson, students will use an Excel spreadsheet to determine the percentage of fat, protein and carbohydrates in a common breakfast cereal. The students will create a pie chart to represent the percentages of fat, protein and carbohydrates in the food.


Thinkfinity Lesson Plans


Alabama Virtual Library
Alabama Virtual Library

Hosted by Alabama Supercomputer Authority
The University of Alabama at Birmingham
The University of Alabama at Birmingham
The Malone Family Foundation
The Malone Family Foundation
Thinkfinity
Thinkfinity
Best of the Web

Web Design by: Digital Mason LLC