|
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 |