Computer Applications for Business

Computer Applications for Business

COURSE OF STUDY OUTLINE

COMPUTER APPLICATIONS FOR BUSINESS

Shop Practice

Grade 10

Proficiencies:

Upon completion of the tenth grade level of the Computer Applications for Business course, having been given the necessary tools, equipment, materials and instruction, students should be able to meet the following proficiencies:

1. Practice safe work habits and follow safety and sanitation procedures.

2. Demonstrate good habits of shop maintenance, cleanup, and storage.

3. Demonstrate improvement in speed and accuracy in keyboarding.

  1. Practice technique of careful examination of work in order to develop pride in work and professionalism.
  1. Apply keyboarding and language skills in the composing of business letters and communications.
  1. Produce mailable output from unarranged documents utilizing the word processing systems presented.
  1. Demonstrate a knowledge, at an introductory level, of word, excel, power point and publisher.
  1. Demonstrate a knowledge of desk-top publishing with commonly used features.
  1. Demonstrate employability skills and work habits, such as work ethic, dependability, promptness, and getting along with others, needed to get and keep a job.
  1. Describe the importance of academic and occupational skills to achievement in the work world.
  1. Access and assess information on specific topics using both technological (e.g.

Computer, telephone, satellite) and print resources available in libraries or media centers.

______

COURSE: UNDERSTANDING BASIC MICROSOFT OFFICE APPLICATIONS

UNIT IREVIEW OF OCCUPATIONAL INFORMATION AND SHOP

PROCEDURES

A.Career Opportunities and Employment Requirements

B.Safety Rules and Regulations

C.Proper Identification and Use of Tools, Materials and Equipment

D.Shop Maintenance, Cleanup Procedures and Storage

E.Personal Hygiene and Good Grooming

F.Basic Shop Skills and Related Theory

G.Participation in Student and Vocational Organizations (FBLA and/or SKILLS USA/VICA)

UNIT IIKEYBOARDING

A.How to Increase Skills and Accuracy in Keyboarding

1.Practicing timings

a.One-minute

b.Three-minute

c.Five-minute

2.Interpreting symbols

3.Practicing proofreading

4.Practicing centering

B.How to Prepare Administrative Communications and Special Applications

1.Keyboarding administrative communications and special applications

a.Memorandums

b.Announcements

c.Letters and forms

d.Employment applications

e.Statistical and financial reports

f.Newsletters

g.Newspaper columnar reports

C.Advanced Technical Reports

1.Keyboarding technical reports

a.Title page

b.Table of contents with dot leaders

COURSE: UNDERSTANDING BASIC MICROSOFT OFFICE APPLICATIONS

(cont’d)

UNIT IIKEYBOARDING (cont’d)

C.Technical Reports (cont’d)

1.Keyboarding technical reports (cont’d)

c.List of tables

d.Body of report

e. Numbering pages with header and footers

f.Headings

g.Quoted material

h.Footnotes

i.Appendix

j.Bibliography

D.How to Type Special-Size Stationery and Envelopes

1.Keyboarding special-size stationery

a.Bills of lading

b.Purchase orders

c.Invoices

d.Contracts

e.Deeds

f.Wills

g.Other legal papers

2.Preparing special-size envelopes

E.How to Prepare Columnar Reports

1.Using open-column method

2.Using boxed-column method

3.Justification of columns

4.Justification of leader lines

5.Keyboarding the body of tabular reports

6. Prepare several column newsletters

UNIT IIIOFFICE PROCEDURES

A.How to Develop Personal Efficiency

1.Practicing good work habits and proper office procedures

2.Developing proper attitudes

3.Simulating office conditions

4.Role-playing in office-simulated situations

COURSE: UNDERSTANDING BASIC MICROSOFT OFFICE APPLICATIONS

(cont’d)

UNIT IIIOFFICE PROCEDURES (cont’d)

A.How to Develop Personal Efficiency (cont’d)

5.Following guidelines for employee manuals

6.Use of flow charts and instruction sheets

7.Importance of personal efficiency on a job

B.How to Type and Fold Business and Personal Communications

1.Keyboarding communications

a.Annual reports

b.Mailing lists

c.Letters and memorandums

d.International correspondence

e.Mail merge

f.Other business and personal correspondence

2.Composing business and personal letters and memorandums

3.Handling incoming correspondence

4.Handling outgoing correspondence

5.Folding for insertion into envelopes

a.Large envelopes

b.Small envelopes

6.Keyboarding envelopes and mailing labels

a.Rules for various sizes

b.State abbreviations, zip codes

d.Return address

C.How to Develop Good Business Communications

1.Developing good business communications

  1. Using standard language
  2. Clear speech
  3. Proper pronunciation and enunciation
  4. Avoidance of colloquialism and slang
  5. Use of correct grammar
  6. Elimination of distracting mannerisms
  7. Nonverbal influences

2.Developing good spelling habits

3.Expanding vocabulary

  1. Using common abbreviations
  2. Following good etiquette

COURSE: UNDERSTANDING BASIC MICROSOFT OFFICE APPLICATIONS

(cont’d)

UNIT IIIOFFICE PROCEDURES (cont’d)

D. How to Handle Type of Electronic Communication Systems

  1. Types of electronic information services
  2. E-mail and ethics with it

E.How to Construct Charts in Word and/or Excel

  1. Constructing simple graphs and charts
  2. Interpreting graphs and charts

UNIT IVINTRODUCTION TO DESKTOP PUBLISHING

A.How to Utilize the Computer for Graphics/Desktop Publishing (Introductory Level)

1.Identifying

a.Software and hardware

b.Components/accessories

c.Control keys

d.Laser printer

e.Mouse

  1. Proper terminology

2.Starting up and using the system

  1. Loading software
  2. Keyboarding
  3. Practicing using programmed software

a.Use of Windows

  1. Recording, processing and saving information
  2. Maintaining system--care and storage
  3. Shutting down system

B.How to Complete Desktop Publishing

  1. Completing

a.Flyers

b.Newsletters

c.Other

d. Utilize the Publisher Page Wizard/Templates

COURSE: UNDERSTANDING BASIC MICROSOFT OFFICE APPLICATIONS

(cont’d)

UNIT V COMPUTER APPLICATIONS FOR BUSINESS WITH EXCEL
A.Microsoft Excel, Spreadsheets
1.Starting a spreadsheet
2.Changing cells
  1. Navigating between worksheets
  2. Opening worksheets
  3. Closing worksheets
  4. Navigating within a worksheet
  5. Saving a worksheet
  6. Printing worksheets
B.Microsoft Excel, Creating a Worksheet

1.Entering labels

2.Entering values

3.Constructing basic formulas

4.Using the SUM function

C.Microsoft Excel, Enhancing a Worksheet

1.Selecting multiple columns and rows

2.Inserting cells, columns, and rows

3.Deleting cells, columns and rows

4.Moving data to a new location

5.Formatting numbers; the basics

D.Microsoft Excel, Printing a Worksheet

1.Selecting display options

2.Protecting files

3.Printing worksheets

4.Printing formulas

E.Microsoft Excel, Copying Data

1.Using copy and paste

2.Using drag and drop

COURSE: UNDERSTANDING BASIC MICROSOFT OFFICE APPLICATIONS

(cont’d)

UNIT V COMPUTER APPLICATIONS FOR BUSINESS WITH EXCEL (cont’d)

F.Microsoft Excel, File Management

1.Checking spelling

2.Using auto correct

3.Finding and replacing data

4.Finding files

5.Renaming, copying, and deleting files

G.Microsoft Excel, Formatting Text and Numbers

1.Formatting numbers

2.Aligning text

3.Changing column width and row height

4.Hiding columns and rows

H.Microsoft Excel, Using Functions

1.Entering functions

2.Using the AVERAGE function

3.Using the COUNT function

4.Using the COUNTA function

5.Using the INT and ROUND functions

I.Microsoft Excel, Advanced Printing

1.Inserting and removing page breaks

2.Adding print titles

3.Changing margins in print preview

4.Changing page order and printing

J.Microsoft Excel, Creating Charts

1.Identifying chart types and chart objects

2.Using the chart wizard

3.Sizing and moving a chart

K.Microsoft Excel, Enhancing Charts and Worksheets

1.Formatting chart text

2.Legends

3.Adding backgrounds and borders

COURSE: UNDERSTANDING BASIC MICROSOFT OFFICE APPLICATIONS

(cont’d)

UNIT VIMS ADVANCED WORD APPLICATIONS

A.Microsoft Word, Formatting with Special Features

1.Using autotext

2.Inserting a non breaking space

3.Affecting text flow

4.Adding borders and shading

5.Finding and replacing special formatting and characters

6.Creating footnotes and endnotes

7.Using bookmarks

8.Creating a cross-reference

9.Formatting pages in a document

10.Creating and balancing columns

B.Microsoft Word, Merging Documents and Sorting and Selecting Data

1.Creating a data source with mail merge helper

2.Creating the main document

3.Merging files

4.Viewing merged records in the main document

5.Checking for errors

6.Editing the data source

7.Merging envelopes

8.Merging mailing labels

9.Inputting text during a merge

10.Sorting text

11.Sorting text in columns

12.Sorting text in tables

13.Sorting records in a data source

14.Selecting records

C.Microsoft Word: Working With Shared Documents

1.Tracking changes to a document

2.Inserting comments

3.Sending and routing documents

4.Protecting documents

5.Creating a template

6.Creating multiple versions of a document

7.Creating a master document and subdocuments

COURSE: UNDERSTANDING BASIC MICROSOFT OFFICE APPLICATIONS (cont’d)

UNIT VIMS ADVANCED WORD APPLICATIONS (cont’d)

D.Microsoft Word: Creating Specialized Tables And Indexes

1.Creating a table of contents

2.Creating an index

3.Creating a table of figures

4.Creating a table of authorities

E.MICROSOFT WORD: CREATING FILL-IN FORMS

1.Creating a form

2.Filling in a form document

3.Printing a form

4.Editing a form template

5.Customizing form field options

6.Creating tables in a form template

F. MICROSOFT WORD: INTEGRATED TOPIC: ADDING VISUAL APPEAL TO DOCUMENTS

1.Customizing toolbars

2.Inserting and customizing clip art images

3.Aligning graphic elements

4.Performing calculations in a table

UNIT VII WORKING WITH POWER POINT

1. Creating Slides

a. Blank Slides

b. Templates

2. Adding clip art, Smart art, graphics, sound, animation, etc.

3. Setting up presentation of slide show.

4. Working with Power Point Objects

a.Using Clip Art

b.Formats and Crop Clip Art

c.Using Word Art for Special Effects

d.Working with Floating Text Boxes

e.Rotating Text

f.Working with Basic Drawing Tools

g.Using Basic Auto Shapes

h.Placing Text in a Graphic Object

COURSE: UNDERSTANDING BASIC MICROSOFT OFFICE APPLICATIONS (cont’d)

UNIT VII WORKING WITH POWER POINT (cont’d)

5. Working with Lines, Fills, and Colors

a.Changing the Line Color and Style of Objects

b.Changing the Fill Color of Objects

c.Adding Patterns, Shading, and Textures

d.Using the Format Painter Tool

e.Adding Fill and Shading Effects to Master Slides and

Backgrounds

f.Changing the Colors of a Clip Art Object

g.Changing a Presentation Color Scheme

h.Changing Black and White Settings

.6. Manipulating Powerpoint Objects

a.Selecting Multiple Objects

b.Aligning, Flipping, and Distributing Objects

c.Groping and Ungrouping Objects

d.Working with Layers of Objects

e.Applying Object Shadows and 3-D Effects

f.Using the Duplicate Command

g.Advanced Clip Art Editing

7. Text Manipulation

a.Working with Indents

b.Working with Tabs

c.Controlling Line Spacing

d.Working with Text Box Settings

e.Working with Page Setup Options

f.Customizing Handout and Notes Masters

BIBLIOGRAPHY OF TEXT AND REFERENCE BOOKS

COMPUTER APPLICATIONS FOR BUSINESS

Grade 10

TEXTS:

Century 21 Keyboarding and Computer Applications, 5th Edition, South-Western Publishing Company.

Microsoft Office 2000 Illustrated Series, Premium Edition, Thomas Learning.

REFERENCES:

Computer Applications & Keyboarding, South-Western Publishing Co.

Excel Basics 7.0. M. Rosow, the H.M. Rowe Co.

Front Page Introductory. Thompson Learning.

Internet Office Projects. South-Western Publishing Company.

Microsoft Access. Thompson Office Technology.

Microsoft Office XP Introductory Concepts & Techniques, Window XP, Thompson Office Technology.

MS Illustrated Series Excel. South-Western Publishing Company.

MS Office Word Illustrated Series Complete. Thompson Learning.

MS Power Point Brief Edition. ITP.

MS Power Point Complete Tutorial. Thompson Learning.

New Perspectives on Microsoft Word-Comprehensive. Thompson Learning.

New Perspectives on MS Excel Comprehensive. Thompson Learning.

Norton, P. Computing Fundamentals 5th Edition. Glencoe-McGraw Hill.

Office 2000--A Comprehensive Approach. Glencoe-McGraw-Hill.

BIBLIOGRAPHY OF TEXT AND REFERENCE BOOKS (cont’d)

Office XP: A Comprehensive Approach. Thompson Learning.

Pace, P. Word Basics (List 295). The H.M. Rowe Co.

Performing with MS Power Point Comprehensive Course. Thompson Learning.

Practical Excel. H.M. Rowe Co.

Rossow, M.A. Microsoft Word. The H.M. Rowe Co.

Shelly, G. et al. Microsoft Publisher: Complete. Thompson Course Technology.

Today’s Electronic Office, 2nd Edition. EMC.

1

I: Curriculum

Computer Applications for Business - 2010

Top View