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

Narrow Results:

Lesson Plans (34) A detailed description of the instruction for teaching one or more concepts or skills. Podcasts (1) A program (audio or video) made available in digital format for playback or download over the Internet. Assessments (1) Any activity or resource teachers use to help gauge student progress.
Informational Materials (1) Textual information containing useful facts or information. Interactives/Games (1) A learning object that requires a user's involvement. Learning Activities (1) Any activity that would enhance a lesson or unit in order to help the learner master an objective 
and/or acquire a skill.  Examples include, but are not limited to, online tutorials, experiments, 
demonstrations, and hands-on activities.
Teacher Tools (1) An extensive set of online resource tools teachers can use to enhance student learning or increase teacher productivity often useful across grade levels and/or subject areas (Aligned to professional learning standards instead of content standards).


ALEX Lesson Plans


Save to ALEX | Share Share | Show Details

Subject: Social Studies (10), or Technology Education (9 - 12)
Title: Spice up the Nineteenth Century!
Description: Students will make interactive outlines using the Internet of the reform movements, literature, trails, religion or technology of the early nineteenth century.


Save to ALEX | Share Share | Show Details

Subject: Business, Management, and Administration (9 - 12), or Technology Education (9 - 12)
Title: It's Time
Description: Students must prepare to be future business professionals.  By researching the importance of employee/student time and attendance and creating a brochure, students will gain essential knowledge of practical business practices.  The brochure should explain the school's policy, describe the role good/poor attendance plays in the workplace, and describe penalties/rewards.


Save to ALEX | Share Share | Show Details

Subject: Science (9 - 12), or Technology Education (9 - 12)
Title: Save a buck challenge
Description: Our pipes leak, air drafts push through our windows and walls, light bulbs create more heat than light, and every appliance we have stays plugged in all day long.  Of course its our parents who pay the bills, so it doesn't matter.  This is a challenge for students to enact the biggest change per cost at home.


Save to ALEX | Share Share | Show Details

Subject: Science (9 - 12), or Technology Education (9 - 12)
Title: Barf Biology (An Extended Owl Pellet Dissection)
Description: As part of the study of the biosphere, the students will create pyramids using owl pellets.  In groups, students will dissect owl pellets to aquire information about owl consumption.  Groups will then create an ecological pyramid, a number pyramid, and a biomass pyramid.  These creations will be composed into a vodcast to be shared on school tube.


Save to ALEX | Share Share | Show Details

Subject: Science (9 - 12), or Technology Education (9 - 12)
Title: What is in a Biome? 
Description: As part of the study of the biosphere, the students will create a lesson and provide a three dimensional model of teacher assigned biome.  In groups students will use lap tops to acquire information about assigned biome.  Groups will then create lesson presentation and a three dimensional model explaining identifying characteristics of assigned biome.


Save to ALEX | Share Share | Show Details

Subject: Mathematics (9 - 12), or Technology Education (9 - 12)
Title: Family Ties:  Parabolas
Description: This lesson allows students to manipulate the parameters while using the vertex form of the equation of a parabola to see the effects on the graph.  The spreadsheet can be altered for other functions.This lesson plan was created as a result of the Girls Engaged in Math and Science University, GEMS-U Project.


Save to ALEX | Share Share | Show Details

Subject: Business, Management, and Administration (9 - 12), or Technology Education (9 - 12)
Title: A Car for College?
Description: In this lesson, students will create a budget and project savings for 2 years. They will project using their savings to purchase a car for graduation. This is a Commerce and Information Technology lesson plan.


Save to ALEX | Share Share | Show Details

Subject: Mathematics (9 - 12), or Technology Education (9 - 12)
Title: Predict the Future?
Description: Students will use data collected and a "best-fit line" to make predictions for the future. The example the students will be working on for this lesson will demonstrate an exponential regression.


Save to ALEX | Share Share | Show Details

Subject: Mathematics (8 - 12), or Technology Education (9 - 12)
Title: The State Capital of Stem and Leaf
Description: This lesson is a hands-on, technology based math lesson. Students will create a stem-and-leaf plot and scatter plot both manually and using Microsoft Excel. This lesson plan was created as a result of the Girls Engaged in Math and Science, GEMS Project funded by the Malone Family Foundation.


Save to ALEX | Share Share | Show Details

Subject: Science (9 - 12), or Technology Education (9 - 12)
Title: The Tragedy of the Commons
Description: Tragedy of the Commons is the mind set: "If I don't use the resources then someone else will." This is a simulation that allows students to explore how the common usage of a potentially renewable resource can lead to its exploitation. Students will complete an activity, a data sheet, an analysis of the data, and a comparison of this problem to a local environmental issue. Students will pose solutions to this problem.This lesson plan was created as a result of the Girls Engaged in Math and Science, GEMS Project, funded by the Malone Family Foundation.


Save to ALEX | Share Share | Show Details

Subject: Science (9 - 12), or Technology Education (9 - 12)
Title: The Circles of Life
Description: This is an inquiry based cooperative learning unit that can be used in biology as a graduation exam review or in botany for a nine week project. The students will learn the life cycle of mosses, ferns, gymnosperms and angiosperms. The teacher can choose to do the cycles together or separate.This lesson plan was created as a result of the Girls Engaged in Math and Science, GEMS Project funded by the Malone Family Foundation.


Save to ALEX | Share Share | Show Details

Subject: Mathematics (7 - 12), or Technology Education (9 - 12)
Title: Water Tank Creations Part I
Description: In this lesson students will study the surface area and volume of three-dimensional shapes by creating a water tank comprised of these shapes. Students will work in groups of 4-5 to research water tanks, develop scale drawings and build a scale model. Teacher will evaluate the project using a rubric and students will assess one anothers cooperative skills using a rubric.


Save to ALEX | Share Share | Show Details

Subject: Mathematics (7 - 12), or Technology Education (9 - 12)
Title: Let’s Tessellate
Description: This lesson is a hands-on, technology-based project that will take place in the classroom and computer lab. Students will discover which regular polygons tessellate the plane by constructing polygonal tessellations. Students will also use a spreadsheet to calculate the area and perimeter of the polygons.


Save to ALEX | Share Share | Show Details

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.


Save to ALEX | Share Share | Show Details

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".


Save to ALEX | Share Share | Show Details

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.


Save to ALEX | Share Share | Show Details

Subject: Technology Education (9 - 12)
Title: How much if the first year of college going to cost?
Description: Students will determine the first year costs of college or junior college in the state of Alabama.


Save to ALEX | Share Share | Show Details

Subject: Social Studies (12), or Technology Education (9 - 12)
Title: Advertising and Its Effects on Consumer Decision Making
Description: This lesson will show the student the power of advertising to create demand for a product. After reviewing existing advertisements, the students will create their own campaign for a product. Following a presentation to the class as a whole, the students will analyze the campaign.


Save to ALEX | Share Share | Show Details

Subject: Mathematics (7 - 12), or Technology Education (9 - 12)
Title: Dice Roll Project
Description: This project is a fun way for students to observe the integration of a probability lesson with spreadsheet software. Students will record 36 rolls of a pair of dice. After they record their data, students will manually calculate the mean, median, mode and range. Students will then observe how quickly a computer can do those same calculations and many more things with that same data. Students will also compare experimental outcomes to the theoretical outcome.


Save to ALEX | Share Share | Show Details

Subject: Technology Education (9 - 12)
Title: Advanced Features of Excel XP
Description: This lesson is designed to teach current Microsoft Excel users the new features in Excel XP and some advanced features of Excel. The teacher follows a detailed list of instructions to demonstrate the features. The students are then given an exercise to allow them some hands-on time to practice the features. This would be beneficial for a class that is beginning a project that will use Microsoft Excel to insure that all of the students are up to speed.


Save to ALEX | Share Share | Show Details

Subject: Mathematics (6 - 12), or Technology Education (9 - 12)
Title: Golden Ratios of the Body, Architecture, and Nature
Description: Students will study the golden ratio as it relates to human body measurements, architecture, and nature. Students will use a desktop publishing program to create a poster. The poster will have digital photos of themselves, architecture samples, or nature examples. Students will also include a spreadsheet with the lengths, widths, and length/width ratios of the samples included in the photos.


Save to ALEX | Share Share | Show Details

Subject: Languages Other Than English (Foreign Languages) (9 - 12), or Technology Education (9 - 12)
Title: French Internet Clothes Shopping
Description: Students practice clothing vocabulary and computer spreadsheet skills by visiting authentic French online clothing catalogs. They choose articles of clothing for purchase for themselves and family members and create a spreadsheet to record and calculate information. They also visit a currency exchange rate website for the current rate of Euros to American dollars. This lesson could easily be used for any target language, once vocabulary for clothes, colors, and family relationships are mastered.


Save to ALEX | Share Share | Show Details

Subject: Technology Education (9 - 12)
Title: Finding Information Using the Internet
Description: In this lesson students learn how to use the Internet to find driving directions and maps. Students will locate the street address of a financial institution and generate a map with driving directions from home or school. Students will then research the financial institutions to determine what types of services are offered by each and compile the information using a spreadsheet.


Save to ALEX | Share Share | Show Details

Subject: Science (9 - 12), or Technology Education (9 - 12)
Title: "Dummie's" Guide to PCR
Description: (This lesson is for a more advanced class such as honors or AP Biology.) The lesson will look at one of the most important tools to the molecular biologist, PCR (Polymerase Chain Reaction). The students will learn the science behind PCR and the steps scientists go through to do PCR. The students will design a slideshow presentation to explain the science of PCR to others.


Save to ALEX | Share Share | Show Details

Subject: Mathematics (9 - 12), or Technology Education (9 - 12)
Title: Math is Functional
Description: This lesson is a technology-based activity in which students extend graphing of linear functions to the use of spreadsheet software. After students have become proficient in constructing a table of values, students are able to efficiently graph equations with more extensive computational requirements. Furthermore, inquiry and discovery about slope and y-intercept will help students conceptualize material normally presented in Algebra I textbooks.


Save to ALEX | Share Share | Show Details

Subject: Technology Education (9 - 12)
Title: A Day in the Life
Description: The ability to create a timeline is a skill that students can use across the curriculum to represent changes over time. This spreadsheet project provides students the opportunity to learn to produce a timeline and introduces the life skill of time management as well.


Save to ALEX | Share Share | Show Details

Subject: Mathematics (9 - 12), or Technology Education (9 - 12)
Title: You Mean ANYTHING To The Zero Power Is One?
Description: This lesson is a technology-based project to reinforce concepts related to the Exponential Function. It can be used in conjunction with any textbook practice set. Construction of computer models of several Exponential Functions will promote meaningful learning rather than memorization.


Save to ALEX | Share Share | Show Details

Subject: Technology Education (9 - 12)
Title: Planning a Family Vacation
Description: Students will use the Internet to explore different vacation opportunities for the family. Using a given set of criteria, students will compile data in a table, then use the data to create a tri-fold brochure and a slideshow presentation.


Save to ALEX | Share Share | Show Details

Subject: Technology Education (9 - 12)
Title: Parabola
Description: This lesson is a technology-based project to reinforce previously taught concepts related to the quadratic equation. It can be used in conjunction with any textbook practice set. Through technology students expand their existing knowledge base related to the solutions of a quadratic equation, the upward or downward position, the vertex, and the width between paths. As students discover the relationship between the solutions and the x-intercepts, prior knowledge about the quadractic formula is connected to the graph of the equation--making the quadratic formula more than a "recipe."


Save to ALEX | Share Share | Show Details

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.


Save to ALEX | Share Share | Show Details

Subject: Technology Education (9 - 12)
Title: Beaver Mountain Bike Tours Presentation
Description: Students will create, design and give a multimedia presentation about Beaver Mountain Bike Tours to pursuade travel agents to use their service. Presentations will include digital photography, Excel graphs, Word tables, and organizational graphs in PowerPoint. This is a business simulation that students will complete after finishing all major sections in the Microsoft Office Suite and is a culmulation of all of the skills learned previously. The total business simulation was created by Carl Lyman.


Save to ALEX | Share Share | Show Details

Subject: Mathematics (7), or Science (7 - 12), or Technology Education (9 - 12)
Title: How Big Can a Bee Be?
Description: Students will study the relationship between surface area and volume. Math, science, and technology components are included.


Save to ALEX | Share Share | Show Details

Subject: Mathematics (9 - 12), or Technology Education (9 - 12)
Title: Creating a Payroll Spreadsheet
Description: Spreadsheet software allows you to calculate numbers arranged in rows and columns for specific financial tasks. This activity allows students to create an "Employee Work/Pay Schedule" spreadsheet to reinforce spreadsheet skills. Students will practice spreadsheet skills by entering data, creating formulas, and using formatting commands.


Save to ALEX | Share Share | Show Details

Subject: Mathematics (9 - 12), or Technology Education (9 - 12)
Title: Spreadsheets and Budgets
Description: This activity allows students to use real-world data to create a spreadsheet budget. This project is designed to be the culmination of a spreadsheet unit.


ALEX Podcasts


Save to ALEX | Share Share | Show Details
How to Create a Chart in Microsoft Excel
Overview:
This podcast shows how to create and edit a chart (graph) using Microsoft Excel 2010. 


Web Resources


Assessments


Save to ALEX | Share Share | Show Details
Using Excel Tables Tutorial
http://office.micros...
This interactive tutorial teaches you how to manage information using Excel Tables, including formatting data, sorting, filters, and formulas. There are exercises and a test to complete in the tutorial. This tutorial is for Microsoft Excel 2010.

Informational Materials


Save to ALEX | Share Share | Show Details
Using Excel Tables Tutorial
http://office.micros...
This interactive tutorial teaches you how to manage information using Excel Tables, including formatting data, sorting, filters, and formulas. There are exercises and a test to complete in the tutorial. This tutorial is for Microsoft Excel 2010.

Interactives/Games


Save to ALEX | Share Share | Show Details
Using Excel Tables Tutorial
http://office.micros...
This interactive tutorial teaches you how to manage information using Excel Tables, including formatting data, sorting, filters, and formulas. There are exercises and a test to complete in the tutorial. This tutorial is for Microsoft Excel 2010.

Learning Activities


Save to ALEX | Share Share | Show Details
Using Excel Tables Tutorial
http://office.micros...
This interactive tutorial teaches you how to manage information using Excel Tables, including formatting data, sorting, filters, and formulas. There are exercises and a test to complete in the tutorial. This tutorial is for Microsoft Excel 2010.

Teacher Tools


Save to ALEX | Share Share | Show Details
Using Excel Tables Tutorial
http://office.micros...
This interactive tutorial teaches you how to manage information using Excel Tables, including formatting data, sorting, filters, and formulas. There are exercises and a test to complete in the tutorial. This tutorial is for Microsoft Excel 2010.

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