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): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] CA2 (912) 12: Use digital tools to publish curriculumrelated content. [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): [BMA] BA02 (912) 4: Utilize advanced features of word processing software, including outlining, tracking changes, hyperlinking, creating macros, developing forms, and mail merging. [BMA] BA02 (912) 1: Utilize advanced technology utilities, including compressing files, converting files, importing files, exporting files, and transferring data among applications. [BMA] BA02 (912) 5: Utilize word processing software to demonstrate professional writing skills by producing and editing business correspondence documents using various data input techniques. [BMA] BA02 (912) 6: Utilize spreadsheet features, including formulas, functions, sorting, and filtering data, templates, charts, and graphs in creating, editing, and printing workbooks. [BMA] BA02 (912) 10: Critique the Internet and digital information for validity, accuracy, bias, and current relevance. [BMA] BA02 (912) 11: Create a product that integrates information from multiple software applications. [BMA] BA02 (912) 16: Analyze the organizational structure of a business to determine roles and responsibilities of employees and functions of departments or units. [TC2] CA2 (912) 3: Demonstrate advanced technology skills, including compressing, converting, importing,
exporting, and backing up files. [TC2] CA2 (912) 4: Utilize advanced features of word processing software, including outlining, tracking changes,
hyperlinking, and mail merging. [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] CA2 (912) 11: Critique digital content for validity, accuracy, bias, currency, and relevance. [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): [S1] ENV (912) 1: Identify the influence of human population, technology, and cultural and industrial changes on the environment. [S1] ENV (912) 3: Evaluate other sources of energy for their effectiveness as alternatives to fossil fuels. [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] CA2 (912) 10: Analyze capabilities and limitations of current and emerging technologies. [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): [S1] BIO (912) 1: Select appropriate laboratory glassware, balances, time measuring equipment, and optical instruments to conduct an experiment. [S1] BIO (912) 13: Trace the flow of energy as it decreases through the trophic levels from producers to the quaternary level in food chains, food webs, and energy pyramids. [TC2] CA2 (912) 3: Demonstrate advanced technology skills, including compressing, converting, importing,
exporting, and backing up files. [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] CA2 (912) 6: Utilize advanced features of multimedia software, including image, video, and audio editing. [TC2] CA2 (912) 12: Use digital tools to publish curriculumrelated content. [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): [S1] BIO (912) 5: Identify cells, tissues, organs, organ systems, organisms, populations, communities, and ecosystems as levels of organization in the biosphere. [S1] BIO (912) 13: Trace the flow of energy as it decreases through the trophic levels from producers to the quaternary level in food chains, food webs, and energy pyramids. [S1] BIO (912) 14: Trace biogeochemical cycles through the environment, including water, carbon, oxygen, and nitrogen. [S1] BIO (912) 15: Identify biomes based on environmental factors and native organisms. [S1] BIO (912) 16: Identify densitydependent and densityindependent limiting factors that affect populations in an ecosystem. [TC2] CA2 (912) 3: Demonstrate advanced technology skills, including compressing, converting, importing,
exporting, and backing up files. [TC2] CA2 (912) 4: Utilize advanced features of word processing software, including outlining, tracking changes,
hyperlinking, and mail merging. [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] CA2 (912) 6: Utilize advanced features of multimedia software, including image, video, and audio editing. [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): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [MA2013] AL1 (912) 28: 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.* [FIF4] [MA2013] AL1 (912) 18: Solve quadratic equations in one variable. [AREI4] [MA2013] AL1 (912) 21: Solve a simple system consisting of a linear equation and a quadratic equation in two variables algebraically and graphically. [AREI7] [MA2013] AL1 (912) 31: Graph functions expressed symbolically and show key features of the graph, by hand in simple cases and using technology for more complicated cases.* [FIF7] [MA2013] AL1 (912) 33: Compare properties of two functions each represented in a different way (algebraically, graphically, numerically in tables, or by verbal descriptions). [FIF9] [MA2013] AL1 (912) 36: Identify the effect on the graph of replacing f(x) by f(x) + k, k f(x), f(kx), and f(x + k) for specific values of k (both positive and negative); find the value of k given the graphs. Experiment with cases and illustrate an explanation of the effects on the graph using technology. Include recognizing even and odd functions from their graphs and algebraic expressions for them. [FBF3] [MA2013] AL2 (912) 6: (+) Know the Fundamental Theorem of Algebra; show that it is true for quadratic polynomials. [NCN9] [MA2013] AL2 (912) 32: Compare properties of two functions each represented in a different way (algebraically, graphically, numerically in tables, or by verbal descriptions). [FIF9] [MA2013] ALC (912) 6: Use the extreme value of a given quadratic function to solve applied problems. (Alabama) [MA2013] ALT (912) 4: Solve quadratic equations with real coefficients that have complex solutions. [NCN7] [MA2013] ALT (912) 6: (+) Know the Fundamental Theorem of Algebra; show that it is true for quadratic polynomials. [NCN9] [MA2013] ALT (912) 32: Compare properties of two functions each represented in a different way (algebraically, graphically, numerically in tables, or by verbal descriptions). [FIF9] [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): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] CA2 (912) 7: Utilize advanced features of database software, including merging data, sorting, filtering,
querying, and creating reports. [MA2013] AL1 (912) 12: Create equations and inequalities in one variable, and use them to solve problems. Include equations arising from linear and quadratic functions, and simple rational and exponential functions. [ACED1] [MA2013] AL1 (912) 31: Graph functions expressed symbolically and show key features of the graph, by hand in simple cases and using technology for more complicated cases.* [FIF7] [MA2013] AL1 (912) 37: Distinguish between situations that can be modeled with linear functions and with exponential functions. [FLE1] [MA2013] AL1 (912) 38: Construct linear and exponential functions, including arithmetic and geometric sequences, given a graph, a description of a relationship, or two inputoutput pairs (include reading these from a table). [FLE2] [MA2013] AL1 (912) 45: Represent data on two quantitative variables on a scatter plot, and describe how the variables are related. [SID6] [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): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [MA2013] AL1 (912) 41: Represent data with plots on the real number line (dot plots, histograms, and box plots). [SID1] [MA2013] (8) 25: Construct and interpret scatter plots for bivariate measurement data to investigate patterns of association between two quantities. Describe patterns such as clustering, outliers, positive or negative association, linear association, and nonlinear association. [8SP1] [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): [S1] ENV (912) 9: Describe landuse practices that promote sustainability and economic growth. [S1] ENV (912) 1: Identify the influence of human population, technology, and cultural and industrial changes on the environment. [S1] ENV (912) 12: Identify positive and negative effects of human activities on biodiversity. [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [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): [S1] BIO (912) 10: Distinguish between monocots and dicots, angiosperms and gymnosperms, and vascular and nonvascular plants. [S1] BOT (912) 1: Identify the twelve plant kingdom divisions. [S1] BOT (912) 2: Describe phylogenetic relationships between plants and other organisms. [S1] BOT (912) 3: List plant adaptations required for life on land. [S1] BOT (912) 9: Identify life cycles of mosses, ferns, gymnosperms, and angiosperms. [S1] BOT (912) 10: Describe the structure and function of flower parts. [S1] BOT (912) 12: Describe the ecological and economic importance of plants. [TC2] CA2 (912) 4: Utilize advanced features of word processing software, including outlining, tracking changes,
hyperlinking, and mail merging. [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [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): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] CA2 (912) 4: Utilize advanced features of word processing software, including outlining, tracking changes,
hyperlinking, and mail merging. [MA2013] (7) 11: Solve problems involving scale drawings of geometric figures, including computing actual lengths and areas from a scale drawing and reproducing a scale drawing at a different scale. [7G1] [MA2013] (7) 12: Draw (freehand, with ruler and protractor, and with technology) geometric shapes with given conditions. Focus on constructing triangles from three measures of angles or sides, noticing when the conditions determine a unique triangle, more than one triangle, or no triangle. [7G2] [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] [MA2013] (8) 24: Know the formulas for the volumes of cones, cylinders, and spheres, and use them to solve realworld and mathematical problems. [8G9] [MA2013] AL1 (912) 4: Use units as a way to understand problems and to guide the solution of multistep problems; choose and interpret units consistently in formulas; choose and interpret the scale and the origin in graphs and data displays. [NQ1] [MA2013] AL1 (912) 5: Define appropriate quantities for the purpose of descriptive modeling. [NQ2] [MA2013] AL1 (912) 6: Choose a level of accuracy appropriate to limitations on measurement when reporting quantities. [NQ3] [MA2013] ALC (912) 11: Use ratios of perimeters, areas, and volumes of similar figures to solve applied problems. (Alabama) [MA2013] GEO (912) 36: Use volume formulas for cylinders, pyramids, cones, and spheres to solve problems.* [GGMD3] [MA2013] GEO (912) 37: Determine the relationship between surface areas of similar figures and volumes of similar figures. (Alabama) [MA2013] GEO (912) 39: Use geometric shapes, their measures, and their properties to describe objects (e.g., modeling a tree trunk or a human torso as a cylinder).* [GMG1] [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): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [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] [MA2013] (8) 17: Understand that a twodimensional figure is congruent to another if the second can be obtained from the first by a sequence of rotations, reflections, and translations; given two congruent figures, describe a sequence that exhibits the congruence between them. [8G2] [MA2013] ALC (912) 9: Analyze aesthetics of physical models for line symmetry, rotational symmetry, or the golden ratio. (Alabama) [MA2013] ALC (912) 11: Use ratios of perimeters, areas, and volumes of similar figures to solve applied problems. (Alabama) [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) [MA2013] ALC (912) 9: Analyze aesthetics of physical models for line symmetry, rotational symmetry, or the golden ratio. (Alabama) [MA2013] ALC (912) 11: Use ratios of perimeters, areas, and volumes of similar figures to solve applied problems. (Alabama) [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] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] (68) 5: Use basic features of word processing, spreadsheets, databases, and presentation software. [TC2] (68) 6: Select specific digital tools for completing curriculumrelated tasks. [TC2] (68) 7: Demonstrate correct keyboarding techniques. [TC2] (68) 11: Use digital tools and strategies to locate, collect, organize, evaluate, and synthesize
information. [TC2] (68) 12: Use digital tools to communicate and collaborate at all levels from interpersonal to global. [TC2] (68) 13: Use digital tools to formulate solutions to authentic problems. [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] (68) 6: Select specific digital tools for completing curriculumrelated tasks. [TC2] (68) 5: Use basic features of word processing, spreadsheets, databases, and presentation software. [TC2] (68) 13: Use digital tools to formulate solutions to authentic problems. [TC2] (68) 11: Use digital tools and strategies to locate, collect, organize, evaluate, and synthesize
information. [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [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] (68) 5: Use basic features of word processing, spreadsheets, databases, and presentation software. [TC2] (68) 6: Select specific digital tools for completing curriculumrelated tasks. [TC2] (68) 11: Use digital tools and strategies to locate, collect, organize, evaluate, and synthesize
information. [TC2] (68) 13: Use digital tools to formulate solutions to authentic problems. [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] CA2 (912) 7: Utilize advanced features of database software, including merging data, sorting, filtering,
querying, and creating reports. [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) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [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): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] CA2 (912) 11: Critique digital content for validity, accuracy, bias, currency, and relevance. [TC2] CA2 (912) 4: Utilize advanced features of word processing software, including outlining, tracking changes,
hyperlinking, and mail merging. [TC2] CA2 (912) 11: Critique digital content for validity, accuracy, bias, currency, and relevance. [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): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [MA2013] (7) 17: Understand that statistics can be used to gain information about a population by examining a sample of the population; generalizations about a population from a sample are valid only if the sample is representative of that population. Understand that random sampling tends to produce representative samples and support valid inferences. [7SP1] [MA2013] (7) 18: Use data from a random sample to draw inferences about a population with an unknown characteristic of interest. Generate multiple samples (or simulated samples) of the same size to gauge the variation in estimates or predictions. [7SP2] [MA2013] (7) 20: Use measures of center and measures of variability for numerical data from random samples to draw informal comparative inferences about two populations. [7SP4] [MA2013] (7) 21: Understand that the probability of a chance event is a number between 0 and 1 that expresses the likelihood of the event occurring. Larger numbers indicate greater likelihood. A probability near 0 indicates an unlikely event, a probability around ^{1}/_{2} indicates an event that is neither unlikely nor likely, and a probability near 1 indicates a likely event. [7SP5] [MA2013] (7) 22: Approximate the probability of a chance event by collecting data on the chance process that produces it and observing its longrun relative frequency, and predict the approximate relative frequency given the probability. [7SP6] [MA2013] (7) 23: Develop a probability model and use it to find probabilities of events. Compare probabilities from a model to observed frequencies; if the agreement is not good, explain possible sources of the discrepancy. [7SP7] [MA2013] AL1 (912) 42: Use statistics appropriate to the shape of the data distribution to compare center (median, mean) and spread (interquartile range, standard deviation) of two or more different data sets. [SID2] [MA2013] AL2 (912) 37: (+) Use probabilities to make fair decisions (e.g., drawing by lots, using a random number generator). [SMD6] [MA2013] ALT (912) 41: (+) Use probabilities to make fair decisions (e.g., drawing by lots, using a random number generator). [SMD6] [MA2013] DM1 (912) 12: Use combinatorial reasoning and counting techniques to solve applicationbased problems. (Alabama) [MA2013] AL2 (912) 43: Find the conditional probability of A given B as the fraction of B's outcomes that also belong to A, and interpret the answer in terms of the model. [SCP6]
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): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [MA2013] MI1 (912) 9: Analyze works of visual art and architecture for mathematical relationships. (Alabama) [MA2013] MI1 (912) 3: Use special numbers, including e, i, π and the golden ratio, to solve applicationbased problems. [MA2013] GEO (912) 41: Apply geometric methods to solve design problems (e.g., designing an object or structure to satisfy physical constraints or minimize cost, working with typographic grid systems based on ratios).* [GMG3] [MA2013] ALC (912) 11: Use ratios of perimeters, areas, and volumes of similar figures to solve applied problems. (Alabama) [MA2013] ALC (912) 9: Analyze aesthetics of physical models for line symmetry, rotational symmetry, or the golden ratio. (Alabama) [MA2013] (7) 20: Use measures of center and measures of variability for numerical data from random samples to draw informal comparative inferences about two populations. [7SP4] [MA2013] (7) 11: Solve problems involving scale drawings of geometric figures, including computing actual lengths and areas from a scale drawing and reproducing a scale drawing at a different scale. [7G1] [MA2013] (7) 2: Recognize and represent proportional relationships between quantities. [7RP2] [MA2013] (7) 1: Compute unit rates associated with ratios of fractions, including ratios of lengths, areas, and other quantities measured in like or different units. [7RP1] [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): [LOE] ML1 (912) 11: Identify situations and resources in which target language skills and cultural knowledge may be applied beyond the classroom setting. [LOE] ML2 (912) 3: Create oral and written presentations in the target language about a variety of topics using familiar and newly acquired vocabulary words and phrases and correct structure in the past time frame. [LOE] ML2 (912) 8: Compare vocabulary usage, grammatical structures, and idiomatic expressions of a target language with English. [LOE] ML3 (912) 10: Apply language skills and cultural knowledge for recreational, educational, and occupational purposes. [LOE] ML3 (912) 8: Describe similarities and differences that exist within target cultures, including language, clothing, foods, dwellings, recreation, and social conventions. [LOE] ML3 (912) 7: Identify the complex linguistic elements of the target language as they relate to English. [LOE] ML3 (912) 3: Use the target language to create oral and written presentations on a variety of topics using familiar vocabulary and learned structures and time frames. [LOE] ML2 (912) 9: Compare traditions and social conventions of a target culture to one's own. [LOE] ML1 (912) 8: Identify similarities and differences between words in the target language and in English, including pronunciation, intonation, stress patterns, and simple written conventions of language. [LOE] ML1 (912) 6: Identify tangible and intangible products of a target culture, including symbols and expressive art forms. [LOE] ML1 (912) 3: Present oral and written information in the target language using familiar vocabulary and correct structure in the present time frame. [LOE] ML1 (912) 2: Interpret basic oral and written information in the target language on a variety of topics in the present time frame. [LOE] ML2 (912) 2: Interpret spoken and written authentic target language materials and information on familiar topics. [LOE] ML2 (912) 7: Compare information common to other school subjects and to the target language. [LOE] ML3 (912) 2: Interpret culturally authentic oral and written texts in the target language about familiar and unfamiliar topics presented in the future time frame to determine main ideas and supporting details. [LOE] ML4 (912) 2: Interpret complex oral and written materials in the target language, incorporating learned structures and time frames. [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) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] CA2 (912) 11: Critique digital content for validity, accuracy, bias, currency, and relevance. [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): [S1] BIO (912) 8: Identify the structure and function of DNA, RNA, and protein. [TC2] CA2 (912) 4: Utilize advanced features of word processing software, including outlining, tracking changes,
hyperlinking, and mail merging. [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] CA2 (912) 6: Utilize advanced features of multimedia software, including image, video, and audio editing. [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] AL2 (912) 21: Create equations in two or more variables to represent relationships between quantities; graph equations on coordinate axes with labels and scales. [ACED2] [MA2013] AL1 (912) 45: Represent data on two quantitative variables on a scatter plot, and describe how the variables are related. [SID6] [MA2013] AL1 (912) 31: Graph functions expressed symbolically and show key features of the graph, by hand in simple cases and using technology for more complicated cases.* [FIF7] [MA2013] AL1 (912) 28: 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.* [FIF4] [MA2013] ALC (912) 12: Create a model of a set of data by estimating the equation of a curve of best fit from tables of values or scatter plots. (Alabama) [MA2013] AL1 (912) 46: Interpret the slope (rate of change) and the intercept (constant term) of a linear model in the context of the data. [SID7] [MA2013] AL1 (912) 37: Distinguish between situations that can be modeled with linear functions and with exponential functions. [FLE1] [MA2013] AL1 (912) 30: Calculate and interpret the average rate of change of a function (presented symbolically or as a table) over a specified interval. Estimate the rate of change from a graph.* [FIF6] [MA2013] AL1 (912) 22: Understand that the graph of an equation in two variables is the set of all its solutions plotted in the coordinate plane, often forming a curve (which could be a line). [AREI10] [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] CA2 (912) 14: Use digital tools to defend solutions to authentic problems. [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): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [MA2013] ALT (912) 30: Graph functions expressed symbolically, and show key features of the graph, by hand in simple cases and using technology for more complicated cases.* [FIF7] [MA2013] ALC (912) 3: Use formulas or equations of functions to calculate outcomes of exponential growth or decay. (Alabama) [MA2013] AL1 (912) 45: Represent data on two quantitative variables on a scatter plot, and describe how the variables are related. [SID6] [MA2013] AL1 (912) 32: Write a function defined by an expression in different but equivalent forms to reveal and explain different properties of the function. [FIF8] [MA2013] AL1 (912) 29: Relate the domain of a function to its graph and, where applicable, to the quantitative relationship it describes.* [FIF5] [MA2013] AL1 (912) 26: Use function notation, evaluate functions for inputs in their domains, and interpret statements that use function notation in terms of a context. [FIF2] [MA2013] AL1 (912) 2: Rewrite expressions involving radicals and rational exponents using the properties of exponents. [NRN2] [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] [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) [MA2013] AL2 (912) 30: Graph functions expressed symbolically, and show key features of the graph, by hand in simple cases and using technology for more complicated cases.* [FIF7] [MA2013] AL1 (912) 33: Compare properties of two functions each represented in a different way (algebraically, graphically, numerically in tables, or by verbal descriptions). [FIF9] [MA2013] AL2 (912) 21: Create equations in two or more variables to represent relationships between quantities; graph equations on coordinate axes with labels and scales. [ACED2] [MA2013] AL1 (912) 31: Graph functions expressed symbolically and show key features of the graph, by hand in simple cases and using technology for more complicated cases.* [FIF7] [MA2013] AL1 (912) 28: 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.* [FIF4] [MA2013] AL1 (912) 22: Understand that the graph of an equation in two variables is the set of all its solutions plotted in the coordinate plane, often forming a curve (which could be a line). [AREI10] [MA2013] AL1 (912) 1: Explain how the definition of the meaning of rational exponents follows from extending the properties of integer exponents to those values, allowing for a notation for radicals in terms of rational exponents. [NRN1] [MA2013] AL1 (912) 9: Choose and produce an equivalent form of an expression to reveal and explain properties of the quantity represented by the expression.* [ASSE3]
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) 4: Utilize advanced features of word processing software, including outlining, tracking changes,
hyperlinking, and mail merging. [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [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] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] (68) 4: Determine basic troubleshooting strategies to correct common hardware and software
problems. [TC2] (68) 5: Use basic features of word processing, spreadsheets, databases, and presentation software. [TC2] (68) 6: Select specific digital tools for completing curriculumrelated tasks. [TC2] (68) 7: Demonstrate correct keyboarding techniques. [TC2] (68) 11: Use digital tools and strategies to locate, collect, organize, evaluate, and synthesize
information. [TC2] (68) 12: Use digital tools to communicate and collaborate at all levels from interpersonal to global. [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) 4: Utilize advanced features of word processing software, including outlining, tracking changes,
hyperlinking, and mail merging. [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] CA2 (912) 6: Utilize advanced features of multimedia software, including image, video, and audio editing. [TC2] CA2 (912) 11: Critique digital content for validity, accuracy, bias, currency, and relevance. [TC2] CA2 (912) 4: Utilize advanced features of word processing software, including outlining, tracking changes,
hyperlinking, and mail merging. [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] CA2 (912) 6: Utilize advanced features of multimedia software, including image, video, and audio editing. [TC2] CA2 (912) 9: Practice ethical and legal use of technology systems and digital content. [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): [S1] (8) 1: Identify steps within the scientific process. [S1] (7) 1: Describe characteristics common to living things, including growth and development, reproduction, cellular organization, use of energy, exchange of gases, and response to the environment. [S1] BIO (912) 2: Describe cell processes necessary for achieving homeostasis, including active and passive transport, osmosis, diffusion, exocytosis, and endocytosis. [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] CA2 (912) 14: Use digital tools to defend solutions to authentic problems. [MA2013] (7) 14: Know the formulas for the area and circumference of a circle, and use them to solve problems; give an informal derivation of the relationship between the circumference and area of a circle. [7G4] [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): [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) [MA2013] AL1 (912) 45: Represent data on two quantitative variables on a scatter plot, and describe how the variables are related. [SID6] [MA2013] AL1 (912) 28: 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.* [FIF4] [MA2013] ALC (912) 1: Create algebraic models for applicationbased problems by developing and solving equations and inequalities, including those involving direct, inverse, and joint variation. (Alabama) [MA2013] AL1 (912) 34: Write a function that describes a relationship between two quantities.* [FBF1] [MA2013] AL1 (912) 12: Create equations and inequalities in one variable, and use them to solve problems. Include equations arising from linear and quadratic functions, and simple rational and exponential functions. [ACED1] [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: 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): [TC2] CA2 (912) 5: Utilize advanced features of spreadsheet software, including creating charts and graphs,
sorting and filtering data, creating formulas, and applying functions. [TC2] CA2 (912) 11: Critique digital content for validity, accuracy, bias, currency, and relevance. [TC2] CA2 (912) 14: Use digital tools to defend solutions to authentic problems. [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] (02) 6: Identify uses of technology systems in daily living. [TC2] (02) 9: Identify digital tools used for problem solving. [TC2] (35) 9: Use technology tools to organize, interpret, and display data. [TC2] (68) 5: Use basic features of word processing, spreadsheets, databases, and presentation software. [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] (35) 9: Use technology tools to organize, interpret, and display data. [TC2] (68) 5: Use basic features of word processing, spreadsheets, databases, and presentation software. [TC2] (68) 11: Use digital tools and strategies to locate, collect, organize, evaluate, and synthesize
information. [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] (35) 9: Use technology tools to organize, interpret, and display data. [TC2] (68) 5: Use basic features of word processing, spreadsheets, databases, and presentation software. [TC2] (68) 11: Use digital tools and strategies to locate, collect, organize, evaluate, and synthesize
information. [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] (35) 9: Use technology tools to organize, interpret, and display data. [TC2] (68) 5: Use basic features of word processing, spreadsheets, databases, and presentation software. [TC2] (68) 11: Use digital tools and strategies to locate, collect, organize, evaluate, and synthesize
information. [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] (35) 9: Use technology tools to organize, interpret, and display data. [TC2] (68) 5: Use basic features of word processing, spreadsheets, databases, and presentation software. [TC2] (68) 11: Use digital tools and strategies to locate, collect, organize, evaluate, and synthesize
information. [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] (35) 9: Use technology tools to organize, interpret, and display data. [TC2] (68) 5: Use basic features of word processing, spreadsheets, databases, and presentation software. [TC2] (68) 11: Use digital tools and strategies to locate, collect, organize, evaluate, and synthesize
information. [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.

