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

Narrow Results:

Lesson Plans (8) A detailed description of the instruction for teaching one or more concepts or skills. Podcasts (1) A program (audio or video) made available in digital format for playback or download over the Internet.


ALEX Lesson Plans


Save to ALEX | Share Share | Show Details

Subject: Business, Management, and Administration (9 - 12)
Title: Creating Line Charts: Lines over Time
Description: Students will select (3) colleges or universities that they would consider attending. Students will then conduct an online research on the average temperature Highs and Lows for each location over a 12 month period. Next, students will create a line chart illustrating the average temperature highs and lows for each university and then answer 10 questions based on their research (information in the chart). This is a College- and Career-Ready Standards showcase lesson plan.


Save to ALEX | Share Share | Show Details

Subject: Business, Management, and Administration (7 - 12)
Title: College Cost: A MAJOR Expense!
Description: Students will choose a college based on their career goals and aspirations. In this lesson, students will select a career field, choose a field of study (major), and research college cost. Students will learn how to chart, graph, analyze and present the total cost of college in a spreadsheet. This is a College- and Career-Ready Standards showcase lesson plan.


Save to ALEX | Share Share | Show Details

Subject: Business, Management, and Administration (9 - 12)
Title: On the Mark, Get Set, EXCEL!!! It’s Time to buy a NewCar!
Description: Students will learn about loans and how to calculate the monthly payment on a major purchase such as a car loan, home loan, or school loan. In a spreadsheet students will learn how to calculate monthly payments using the PMT (Payment) function. This is a College- and Career-Ready Standards showcase lesson plan.


Save to ALEX | Share Share | Show Details

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


Save to ALEX | Share Share | Show Details

Subject: Business, Management, and Administration (9 - 12), or English Language Arts (12)
Title: Financing Your College Education-What College Can I Afford?
Description: This lesson provides student with the opportunity to think about financing college by considering the best use of the funding available. Consider pros and cons of attending school in state or out of state. Students should determine which education option they can afford to meet the goal of attending college. This plan contains a financial aid component.


Save to ALEX | Share Share | Show Details

Subject: Business, Management, and Administration (9 - 12)
Title: What Is Simple And Compound Interest and How Can I Make It Work For Me?
Description: Students will learn how simple and compound interest is figured and why it is important to maintain a savings account. Students will calculate compound interest to identify benefits of saving in interest-bearing savings accounts. They will learn the "Rule of 72" which states that your savings will double in a specified number of years. Students will learn how to become a millionaire when they retire by investing in a high-yield interest bearing investment strategy while they are in their 20's.


Save to ALEX | Share Share | Show Details

Subject: Business, Management, and Administration (9 - 12), or Education and Training (9 - 12), or English Language Arts (9 - 10), or Mathematics (9 - 12)
Title: Teen Parent: Don't Just Let It Happen
Description: This lesson addresses facts and fiction about teen pregnancy. It is an in-depth look into the social and financial challenges of teen parenting. It includes a cost analysis of a baby's first year of life. Be aware the subject of this lesson is sensitive, it includes research and discussions about sex, birth control, and the consequences of teen pregnancy. The lesson has a financial student aid component which allows teens to research opportunities to further their education through grants, scholarships or student loans, and involves filling out the Federal Application for Student Aid.


Save to ALEX | Share Share | Show Details

Subject: Business, Management, and Administration (9 - 12)
Title: Can I Afford This House?
Description: In this lesson, students will prepare a spreadsheet that provides information about purchasing a house. Using functions and formulas, they will determine if they can afford the house. This is a Commerce and Information Technology lesson plan.


ALEX Podcasts


Save to ALEX | Share Share | Show Details
Make it EZ on Yourself with XL Fill Handles
Overview:
This podcast shows two basic uses of the Excel fill handle. First is the use of filling patterns in numbers, days of the week, or months of the years.  Second is the use of fill handles in conjunction with cell reference formulas.  The video illustrates that fill handles can calculate multiple formulas at one time when applied to cell reference formulas.


Alabama Virtual Library
Alabama Virtual Library

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

Web Design by: Digital Mason LLC