Teachers.Net
JoinLog in
Teachers.Net

Company Stockholder Newsletter

By Debbie A. white

  • Computer
  • Senior
Activity Time
4 hours
Materials
Computer, scanner, Microsoft Word, Microsoft Excel, Word Art and paper and pencil for designing the
Concepts / Topics
Integration of Software Programs

Groups create an imaginary business newsletter, producing its text, sales figures, spreadsheet, and graph, then share it with classmates for evaluation.

Directions

After class discussion, demonstration, and individual student practice, students will be divided into groups of three or four. Each group will do the following:

  1. Create an imaginary business. Use WordArt and/or a scanner to create letterhead stationery for the business. Use this stationery for the newsletter.
  2. Develop text for the newsletter using Microsoft Word.
  3. Develop sales figures for the business either by geographic region (north, south, east, etc.) or by category of sales (fresh flowers, potted flowers, flower arrangements, etc.).
  4. Develop a spreadsheet using Microsoft Excel, and cut and paste the spreadsheet into the newsletter.
  5. Develop a graph using Microsoft Excel to graph the sales data, and cut and paste this graph into the newsletter.

Presentation and Evaluation

The student groups will show their newsletter to other members of the class and will be evaluated by their classmates.

Teachers.Net · https://teachers.net/lessons/1366.html