ALEX Lesson Plans
Save to ALEX 
Share

Show Details
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.
Standard(s): [SS2010] US10 (10) 11: Evaluate the impact of American social and political reform on the emergence of a distinct culture. [A.1.a., A.1.c., A.1.e., A.1.f., A.1.g., A.1.i., A.1.j.]
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

Show Details
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.
Standard(s): [TC2] CA2 (912) 16: Create a product that integrates information from multiple software applications.
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

Show Details
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.
Standard(s): [TC2] CA2 (912) 14: Use digital tools to defend solutions to authentic problems.
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

Show Details
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.
Standard(s): [TC2] CA2 (912) 17: Create an interactive digital product using programming logic.
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

Show Details
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.
Standard(s): [TC2] CA2 (912) 16: Create a product that integrates information from multiple software applications.
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

Show Details
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, GEMSU Project.
Standard(s): [MA2013] AM1 (912) 11: (+) Know the Fundamental Theorem of Algebra; show that it is true for quadratic polynomials. Understand the importance of using complex numbers in graphing functions on the Cartesian or complex plane. [NCN9] (Alabama)
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, GEMSU Project.
Save to ALEX 
Share

Show Details
Title: Predict the Future?
Description:
Students will use data collected and a "bestfit line" to make predictions for the future. The example the students will be working on for this lesson will demonstrate an exponential regression.
Standard(s): [MA2013] PRE (912) 16: For a function that models a relationship between two quantities, interpret key features of graphs and tables in terms of the quantities, and sketch graphs showing key features given a verbal description of the relationship. (Key features include intercepts; intervals where the function is increasing, decreasing, positive, or negative; relative maximums and minimums; symmetries; end behavior; and periodicity. Determine odd, even, neither.)* [FIF4] (Alabama)
Subject: Mathematics (9  12), or Technology Education (9  12)
Title: Predict the Future?
Description: Students will use data collected and a "bestfit 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

Show Details
Title: The State Capital of Stem and Leaf
Description:
This lesson is a handson, technology based math lesson. Students will create a stemandleaf 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.
Standard(s): [MA2013] (8) 26: Know that straight lines are widely used to model relationships between two quantitative variables. For scatter plots that suggest a linear association, informally fit a straight line, and informally assess the model fit by judging the closeness of the data points to the line. [8SP2]
Subject: Mathematics (8  12), or Technology Education (9  12)
Title: The State Capital of Stem and Leaf
Description: This lesson is a handson, technology based math lesson. Students will create a stemandleaf 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

Show Details
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.
Standard(s): [TC2] CA2 (912) 7: Utilize advanced features of database software, including merging data, sorting, filtering,
querying, and creating reports.
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

Show Details
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.
Standard(s): [TC2] CA2 (912) 11: Critique digital content for validity, accuracy, bias, currency, and relevance.
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

Show Details
Title: Water Tank Creations Part I
Description:
In this lesson students will study the surface area and volume of threedimensional shapes by creating a water tank comprised of these shapes. Students will work in groups of 45 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.
Standard(s): [MA2013] GEO (912) 40: Apply concepts of density based on area and volume in modeling situations (e.g., persons per square mile, British Thermal Units (BTUs) per cubic foot).* [GMG2]
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 threedimensional shapes by creating a water tank comprised of these shapes. Students will work in groups of 45 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

Show Details
Title: Let’s Tessellate
Description:
This lesson is a handson, technologybased 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.
Standard(s): [MA2013] GEO (912) 34: Determine areas and perimeters of regular polygons, including inscribed or circumscribed polygons, given the coordinates of vertices or other characteristics. (Alabama)
Subject: Mathematics (7  12), or Technology Education (9  12)
Title: Let’s Tessellate
Description: This lesson is a handson, technologybased 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

Show Details
Title: Spreadsheets  A New Study Tool
Description:
Students will learn to use spreadsheets to enter ifthen 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.
Standard(s): [TC2] (68) 14: Use digital tools to generate new ideas, products, or processes.
Subject: Technology Education (6  12)
Title: Spreadsheets  A New Study Tool
Description: Students will learn to use spreadsheets to enter ifthen 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

Show Details
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".
Standard(s): [TC2] CA2 (912) 6: Utilize advanced features of multimedia software, including image, video, and audio editing.
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

Show Details
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.
Standard(s): [TC2] CA2 (912) 10: Analyze capabilities and limitations of current and emerging technologies.
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

Show Details
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.
Standard(s): [TC2] CA2 (912) 11: Critique digital content for validity, accuracy, bias, currency, and relevance.
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

Show Details
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.
Standard(s): [SS2010] ECON (12) 6: Describe how specialization and voluntary exchange between buyers and sellers lead to mutually beneficial outcomes.
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

Show Details
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.
Standard(s):
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

Show Details
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 handson 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.
Standard(s): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions.
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 handson 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

Show Details
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.
Standard(s): [MA2013] (6) 24: Represent threedimensional figures using nets made up of rectangles and triangles, and use the nets to find the surface area of these figures. Apply these techniques in the context of solving realworld and mathematical problems. [6G4]
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

Show Details
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.
Standard(s): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions.
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

Show Details
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.
Standard(s): [TC2] CA2 (912) 14: Use digital tools to defend solutions to authentic problems.
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

Show Details
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.
Standard(s): [TC2] CA2 (912) 11: Critique digital content for validity, accuracy, bias, currency, and relevance.
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

Show Details
Title: Math is Functional
Description:
This lesson is a technologybased 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 yintercept will help students conceptualize material normally presented in Algebra I textbooks.
Standard(s): [MA2013] AL1 (912) 13: Create equations in two or more variables to represent relationships between quantities; graph equations on coordinate axes with labels and scales. [ACED2]
Subject: Mathematics (9  12), or Technology Education (9  12)
Title: Math is Functional
Description: This lesson is a technologybased 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 yintercept will help students conceptualize material normally presented in Algebra I textbooks.
Save to ALEX 
Share

Show Details
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.
Standard(s): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions.
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

Show Details
Title: You Mean ANYTHING To The Zero Power Is One?
Description:
This lesson is a technologybased 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.
Standard(s):
Subject: Mathematics (9  12), or Technology Education (9  12)
Title: You Mean ANYTHING To The Zero Power Is One?
Description: This lesson is a technologybased 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

Show Details
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 trifold brochure and a slideshow presentation.
Standard(s): [TC2] CA2 (912) 6: Utilize advanced features of multimedia software, including image, video, and audio editing.
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 trifold brochure and a slideshow presentation.
Save to ALEX 
Share

Show Details
Title: Parabola
Description:
This lesson is a technologybased 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 xintercepts, prior knowledge about the quadractic formula is connected to the graph of the equationmaking the quadratic formula more than a "recipe."
Standard(s): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions.
Subject: Technology Education (9  12)
Title: Parabola
Description: This lesson is a technologybased 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 xintercepts, prior knowledge about the quadractic formula is connected to the graph of the equationmaking the quadratic formula more than a "recipe."
Save to ALEX 
Share

Show Details
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.
Standard(s): [TC2] (68) 13: Use digital tools to formulate solutions to authentic problems.
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

Show Details
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.
Standard(s): [TC2] CA2 (912) 16: Create a product that integrates information from multiple software applications.
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

Show Details
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.
Standard(s): [MA2013] (7) 16: Solve realworld and mathematical problems involving area, volume, and surface area of two and threedimensional objects composed of triangles, quadrilaterals, polygons, cubes, and right prisms. [7G6]
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

Show Details
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.
Standard(s):
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

Show Details
Title: Spreadsheets and Budgets
Description:
This activity allows students to use realworld data to create a spreadsheet budget. This project is designed to be the culmination of a spreadsheet unit.
Standard(s): [MA2013] ALC (912) 7: Use analytical, numerical, and graphical methods to make financial and economic decisions, including those involving banking and investments, insurance, personal budgets, credit purchases, recreation, and deceptive and fraudulent pricing and advertising. (Alabama)
Subject: Mathematics (9  12), or Technology Education (9  12)
Title: Spreadsheets and Budgets
Description: This activity allows students to use realworld data to create a spreadsheet budget. This project is designed to be the culmination of a spreadsheet unit.
ALEX Podcasts
Save to ALEX 
Share

Show Details
Title: How to Create a Chart in Microsoft Excel
Overview:
This podcast shows how to create and edit a chart (graph) using Microsoft Excel 2010. Standard(s):
[TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions.
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

Show Details
Title: Using Excel Tables Tutorial
Description:
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.
Standard(s): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions.
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

Show Details
Title: Using Excel Tables Tutorial
Description:
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.
Standard(s): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions.
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

Show Details
Title: Using Excel Tables Tutorial
Description:
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.
Standard(s): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions.
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

Show Details
Title: Using Excel Tables Tutorial
Description:
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.
Standard(s): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions.
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

Show Details
Title: Using Excel Tables Tutorial
Description:
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.
Standard(s): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions.
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.

