ALEX Lesson Plan

     

Open for Business

You may save this lesson plan to your hard drive as an html file by selecting "File", then "Save As" from your browser's pull down menu. The file name extension must be .html.

  This lesson provided by:  
Author:Sharon Smith
System: Blount County
School: Blount County Board Of Education
  General Lesson Information  
Lesson Plan ID: 3439

Title:

Open for Business

Overview/Annotation:

This is an integrated lesson using word processing, spreadsheet, presentation, and database software and the Internet. Each student will create the appropriate documents for operating a personal business: Letter (with designed letterhead) to perspective customer requesting a meeting for a presentation of services or products; database listing with proper fields for products and one for customer listings; invoice with company logo showing a sale with tax and shipping; a presentation to promote products or services. Students will search the Internet for actual prices, pictures, and documentation of products or service. They will have creative privileges for designs and logos.
 Associated Standards and Objectives 
Content Standard(s):
Technology Education
TC2 (2009)
Grade: 9-12
Computer Applications
11 ) Critique digital content for validity, accuracy, bias, currency, and relevance.

Technology Education
TC2 (2009)
Grade: 9-12
Computer Applications
12 ) Use digital tools to publish curriculum-related content.

Examples: Web page authoring software, coding software, wikis, blogs, podcasts

Local/National Standards:

 

Primary Learning Objective(s):

Students will:

demonstrate an understanding of how to integrate software programs to produce documents and gain workplace skills in a real life business simulation;

create correct form letter with letterhead and envelope, save, and print;

create, format, design, save, and print database;

create, format, design, use functions, save, and print invoice in spreadsheet software;

use online resources to gather information;

create, present, use functions to customize, save, and print presentation.

Additional Learning Objective(s):

Students will demonstrate skills in problem solving (how they will present their product, what will they include, what would make it desirable, etc.).
 Preparation Information 

Total Duration:

Greater than 120 Minutes

Materials and Resources:

Student checklist snf rubrics (see attached)

Technology Resources Needed:

Computers with Internet access, printers, Word or other publishing software, Excel or other spreadsheet software, Access or other database software, PowerPoint or other presentation software, large group projection device such as data projector or TV with scan converter.

Background/Preparation:

Students must have working knowledge of word processing, publishing, spreadsheet, and database software, Internet skills and tools, and presentation skills.
  Procedures/Activities: 
1.)Teacher will demonstrate expectations of presentation of business and sample of documents to be produced by students.

2.)Teacher will hand out and discuss rubrics and deadlines. Students must save all documentation to be turned in at the end of the project.

3.)Students will contract for their business and proceed to search on the Internet for at least 10 items (pictures, prices, and descriptions). This should take approximately 3 class periods and then they can move on to start on their databases.

4.)Students create and design a database for products and customers. Product database should include ISDN #, Item No #, Product Description, Price, and Number in Stock. The product database should be sorted by Item # and include 10 products. The customer database should include Customer Lastname, Firstname, Street Address, City, State, Zip, Phone, Item No Ordered (lookup function), and Date Ordered. The customer database should have 10 customers listed and ascending sorted by Lastname.

5.)Students prepare an Invoice for sale of at least three items listed on product database to a customer on the customer database. It must include proper sales tax and shipping cost if applicable.

6.)Students will write a prospective customer or company and ask for a meeting to deliver a presentation of products or service. The letter must be typed in the correct form on a word processor with student created letterhead. An addressed envelope must also be attached.

7.)Students will create a presentation (slideshow or web) advertising their businesses. Each student will present his/her presentation to the class.

8.)All documentation and checklists must be turned in at the end of the presentation.


Attachments:
**Some files will display in a new window. Others will prompt you to download.
  Assessment  

Assessment Strategies

Grading Rubrics attached:

Documentation and deadlines 20;

Letter and envelope 20;

Invoice 15;

Database 15;

Presentation 30

Acceleration:

Students may opt to use charts from spreadsheets in their presentations for additional points and/or create a web page to advertise their businesses.

Intervention:

Templates for letters, invoices, and databases may be used for students who need remediation.

Each area below is a direct link to general teaching strategies/classroom accommodations for students with identified learning and/or behavior problems such as: reading or math performance below grade level; test or classroom assignments/quizzes at a failing level; failure to complete assignments independently; difficulty with short-term memory, abstract concepts, staying on task, or following directions; poor peer interaction or temper tantrums, and other learning or behavior problems.

Presentation of Material Environment
Time Demands Materials
Attention Using Groups and Peers
Assisting the Reluctant Starter Dealing with Inappropriate Behavior
Be sure to check the student's IEP for specific accommodations.