ALEX Lesson Plan


Planning a Company Picnic

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:Janice Hatley
System: Etowah County
School: Southside High School
  General Lesson Information  
Lesson Plan ID: 11191


Planning a Company Picnic


As students plan a company picnic, they gain proficiency in word processsing, online research, and the creation of a database and spreadsheet.
 Associated Standards and Objectives 
Content Standard(s):
TC2 (9-12) Computer Applications
4. Utilize advanced features of word processing software, including outlining, tracking changes, hyperlinking, and mail merging.
TC2 (9-12) Computer Applications
11. Critique digital content for validity, accuracy, bias, currency, and relevance.

Local/National Standards:


Primary Learning Objective(s):

Students will assume the role of event planner for a company and compose a memo to company employees, inviting them to the annual company picnic. Students will create a database of company employees, name tags for the picnic, and a spreadsheet of expenses for the picnic. Spreadsheet information will be obtained from the Internet.

Additional Learning Objective(s):

 Preparation Information 

Total Duration:

Greater than 120 Minutes

Materials and Resources:

Avery name tag labels, telephone books, newspaper grocery store advertisements

Technology Resources Needed:

Computers with Internet access, word processing software, such as Word, spreadsheet software, such as Excel, database software such as Access, printer


Prior instruction in and practice with word processing, spreadsheet, and database software, desktop publishing features, and Internet usage
1.)Introduce the project by explaining that students will pretend to be the event planner of a company who must plan, invite, and justify costs of the annual company picnic. Students will need to name their company, determine its size, and select a date and location for the event.

2.)Students will create a memo to be sent to all company employees, inviting them to the annual company picnic. The memo will contain information about the time, location, and other particulars of the event.
(Writing@CSU: Writing Guide)
Easy to use guide to writing memos, designed for student use

3.)Students will design a database listing each employee's last name, first name, job title, address, phone number, and e-mail address. Add 10 - 12 records of employees. Students may use telephone books to fabricate address and phone number information.

4.)Students will use the label feature in Microsoft Word to design labels with borders and a graphic logo to be used as name tags at the company picnic. Labels will be printed on Avery labels.

5.)Students will search online for grocery store websites to find the unit price for food and other items needed for the picnic. Menus and caterers might also be searched. Grocery store advertisements may also be used. Students will then determine how much of each item to purchase.
(Gregerson's Foods)
This is an online grocery store website showing ads, coupons, specials, departments, and employment

6.)Students will design a spreadsheet listing all items included in the cost of the picnic. Items could include food, location rental, entertainment, etc. Items should be listed in categories. For the food section of the spreadsheet, students will list how many of each item will be purchased. Students will insert a formula to determine the cost of each item. The spreadsheet should show a total cost for food, a total cost for entertainment, and a total cost for reservations of the facility. The formula must then determine the grand total for the cost of the company picnic. Students may search online yellow pages for locations, entertainment, etc.
(Estimating Food Quantities for a Party)
Outlines general principles one can follow when planning quantities of food for a party.

(Reason to Party)
Guides for food and beverage quantities for an event or party.

8.)Students will print a portfolio consisting of the memo, database, labels, and spreadsheet.


Assessment Strategies

Rubrics can be used for each item in the portfolio according to class standards.


Instead of creating a memo, more advanced students may be istructed to create a letter with a designed company letterhead. Students can then mail merge the letter and the database.


Assign a peer helper to check understanding of directions and to read important directions and essential information.

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.