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.
  • Constructs Meaning From Informational Text
    • Locate, organize, and interpret written information for a variety of purposes, including classroom research, collaborative decision making, and performing a school or real-world task.
    • Use a variety of strategies to analyze words and text, draw conclusions, use context and word structure clues, and recognize organizational patterns.
    • Determine the main Idea or essential message in a text and identifies relevant details and facts and patterns of organization.

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 Objectives Along with Areas of Interaction::

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 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 learning, 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
  • through the lens of homo faber, students will evaluate the quality and effectiveness
    of their company documents as compared to their peers website with a student evaluation rubric.

Aims and Objectives, Fundamental Concept:

Investigate, Plan, Create, Evaluate, Personal Engagement

Guiding Questions:
  • How do I organize my thoughts into a logical and clear presentation?
  • Haw can I impact society and environment through my role as a business leader?
  • How do I effectively communicate my international business products to society?

Concepts/Skills Knowledge:

Students will:

investigate international businesses and the products they sell in order to determine
the country and product they want to represent.
plan the look of their business documents, giving all documents an international theme of the country they chose.
create flyers and other advertisement documents that will showcase their products, formatted with the international theme of their country.
evaluate the quality and effectiveness of their website as compared to their peers
products with a student evaluation rubric.

Duration:

12 Weeks

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
Student Evaluation Rubric