Creating Personalized Microsoft Office Documents For an International Business
Author: Patricia Janann Nicholson
Curriculum Area: M/J Computer Applications 2
Subject Area: International Magnet Computer Applications
Sunshine State Standard Benchmark:
  • Demonstrate the use of sequential and logical planning to describe the tasks, resources, and timelines necessary for the completion of specified projects.
  • Produce documents for specified projects using advanced word processing skills.
  • Set up a spreadsheet file; organize and analyze collected data; and produce reports for specified projects.
    • LA.A.2.3.7 - synthesize and separate collected information into useful components using a variety of techniques, such as source cards, note cards, spreadsheets, and outlines.
    • MA.D.1.3.2 - create and interpret tables, graphs, equations, and verbal descriptions to explain cause-and-effect relationships.
    • MA.E.1.3.3 - analyze real-world data by applying appropriate formulas for measures of central tendency and organizing data in a quality display, using appropriate technology, including calculators and computers.
  • Set up a database file; organize and analyze collected data; and produce reports for specified projects.
    • LA.A.2.3.6 - use a variety of reference materials, including indexes, magazines, newspapers, and journals, and tools, including card catalogs and computer catalogs to gather information for research topics.
    • LA.B.2.3.4 - use electronic technology including databases and software to gather information and communicate new knowledge.
  • Manipulate graphic images for specified projects using varied applications.
    • LA.D.2.3.5 - incorporate audiovisual aids in presentations.
    • VA.B.1.3.4 - know and use the interrelated elements of art and the principles of design to improve the communication of ideas.
  • Demonstrate knowledge of basic concepts of telecommunications and Internet use, including keyword and Boolean search strategies, to gather information for specified projects.
  • Demonstrate knowledge of the impact of computers on society and the need for their ethical use.
    • SS.A.2.3.6 - know the major events that shaped the development of various cultures (e.g., the spread of agrarian societies, population movements, technological and cultural innovation, and the emergence of new population centers).
    • SS.B.1.3.4 - understand how factors such as culture and technology influence the perception of places and regions.
    • SS.D.1.3.1 - know the options and resources that are available for consumer protection.
  • Demonstrate the use of software to create visual organizers and design solutions for specified projects (e.g., storyboards, flowcharts, schematic drawings).
  • Demonstrate the use of productivity and multimedia tools and peripherals to support personal effort and group collaboration for specified projects throughout the curriculum.
Grade Level: 8th Grade
Lesson Title: Creating Microsoft Office Documents for an International Business
Resources: International Business Computer Applications Lessons
http://neighbor.firn.edu/class/palm_beach/pahokee_ms/patricia_janann_nicholson/ibbusproj/interbusproj.htm
Learning Objective:

Students will:

  • through the lens of approaches to learning and homo faber, create a customized logo in Macromedia Fireworks for an international business that includes:
    • text that include two special effects.
    • a graphic that represents the international business.
    • include lines and shapes that enhance overall presentation of logo.
  • through the lens of approaches to learning, create a personal resume using a predefined template.
  • through the lens of approaches to learning and homo faber, create a flyer advertising one one of their company's products, a sale, or an upcoming event. The Microsoft Word document will include:
    • a decorative art border.
    • a watermark of their company logo.
  • through the lens of approaches to learning and homo faber, create a letterhead which includes:
    • company name
    • address
    • phone number
    • fax number
    • e-mail address
    • company logo
    • at least one item from the drawing toolbar
  • through the lens of approaches to learning and homo faber, create an envelope that matches the previously designed letterhead.
  • through the lens of approaches to learning and homo faber, create a form letter using the previous letterhead that will include:
    • products the company sells
    • the country where the products are made
    • the cultural value the country brings to the product
  • through the lens of approaches to learning, create a data base of customers that will be used to mail merge the form letter created above.
  • through the lens of approaches to learning and homo faber, create personalized business cards using an online free service provided by Avery.
  • through the lens of approaches to learning, create a fill-in form for their company in Microsoft Word.
  • through the lens of approaches to learning and homo faber, create a certificate of recognition for employee of the month in Microsoft Word. The certificate will include:
    • WordArt
    • autoshapes aligned and distributed both vertically and horizontally
    • use of landscape orientation
    • decorative font
    • decorative line
  • through the lens of approaches to learning and homo faber, use Microsoft Publisher to create a products brochure advertising their company. The brochure will include their company logo, product information, cultural value that the product reflects about the country, and the actual physical address of the facility where the products are made that will include:
    • map of where the facility is located in that country
    • Clipart, WordArt, Pictures
  • through the lens of approaches to learning and homo faber, create a webpage in Microsoft Word that will include:
    • Your company name as the title of the web page
    • A background with a texture
    • Graphics
    • Hyperlinks (Make sure you create hyperlinks to a web page on the Internet that shows products your company sells.)
  • through the lens of approaches to leanring, use Microsoft Excel to evaluate product performance and then displays it in easily read charts and graphs. For this activity, students will use fictitious information on the number of products sold during a week period. The Excel Worksheet will include:
    • data on products
    • merged title
    • cell alignment
    • bold formatting
    • font color
    • formulas
    • colored highlighting
    • charts and graphs
  • through the lens of approaches to learning, students will create an Access database that will keep track of their company employees. The database will include:
    • table created in design view
    • form created from the table fields
    • create quarries to find information quickly and effectively
  • through the lens of homo faber, students will Create a title page that is centered horizontally on page and contains the following:
    • Name of International Business
    • Watermark of Business Logo Centered Both Vertically and Horizontally on Page
    • Your Name
    • Institutional Affiliation
    • Date
    • Instructor's Name
  • through the lens of homo faber, students will create a table of contents for the entire portfolio. Include the title, TABLE OF CONTENTS, centered and bold. The table of contents will include:
    • a decorative page border.
    • The following headings will be listed along with the actual documents in the order listed:
      • Business Logo
      • Personal Resume
      • Company Flyer
      • Letterhead
      • Customized Envelop
      • Mail Merge/Form Letter, Data Source, Envelopes, Mailing Labels
      • Customized Business Cards
      • Customized Company Invoice
      • Certificate of Recognition
      • Products Brochure
      • Company Web Page
      • Creating a Product Analysis in Excel
      • Finding Information Using an Access Database
      • Products Research Report
  • through the lens of approaches to leaning, create a three page Products Research Report. The report will include different aspects that are directly related to the production and delivery of the finished product to the public. The products analysis will include:
    • a title for your product research paper, centered and bold, on page 1
    • at least three side headings which start at the left margin and are bold. The following headings can be used:
      • Description of Products
      • Environmental/Social Issues
      • Product Ingredients/Natural or Synthetic
      • Product Comparison
      • Impact of Product on Society
Instructions: Students will follow the instructions provided at Nicholson's Lesson Plan Blues Web page. Finished products are included in the grading rubric listed below.
Assessment International Business Grading Rubric