CA-101s Computer Applications for Secretaries

Course Description:

This course builds on an understanding of computer fundamentals, emphasizing the use of electronic spreadsheet in business, using Microsoft Excel topics such as: building worksheets, doing math with formulas and functions, formatting and printing worksheets, charting data, speeding up work with macros and templates, and working with multiple worksheets. In addition, students will able to create professional presentations using the Microsoft PowerPoint application. Introduction to electronic filing, management of records, and reporting will be covered using Microsoft Access database. Continued emphasis is given to the development of typing power so that students may attain a minimum speed of 45 correct words a minute with error tolerance of one error per minute on a 5-minute timed writing. This course includes 16 hours of keyboarding.

A.PROGRAM LEARNING OUTCOMES (PLOs):

The student will be able to:

1. Apply proper bookkeeping techniques in an office.
2. Demonstrate general computer competence and information technology literacy.
3. Demonstrate proper office procedures and management techniques
4. Communicate effectively in English for business purposes.
5. Perform business computations and apply logic as needed.
6. File documents properly and use common office machines.

B.STUDENT LEARNING OUTCOMES (SLOs) – GENERAL:

The student will be able to:

1. Organize and graph data using spreadsheet application.
2. Create and process data using database application.
3. Demonstrate knowledge of the use of presentation application to produce professional looking presentations.
4. Apply effective keyboarding techniques

>

SLO	PLO 1	PLO 2	PLO 3	PLO 4	PLO 5	PLO 6
1		ID			ID
2		ID			ID
3		ID			ID
4		ID			ID

I = Introduced

D = Demonstrated

M = Mastered

C. STUDENT LEARNING OUTCOMES (SLOs)-SPECIFIC The student will be able to:

General SLO 1. Organize and graph data using Spreadsheet application.

Student Learning Outcomes	Assessment Strategies
1.1 Apply Quick Start for Excel accurately	Assignments and quizzes
1.2 Formatting a Worksheet	Assignments and quizzes
1.3 Organizing Worksheets and working with multiple worksheets effectively	Assignments and quizzes
1.4 Creating and working with Charts	Assignments and quizzes

General SLO 2. Create and process data using Database application.

Student Learning Outcomes	Assessment Strategies
2.1 Identify data and structure database	Assignments and quizzes
2.2 Enter Data	Assignments and quizzes
2.3 Organize Data	Assignments and quizzes
2.4 Manage Database	Assignments and quizzes

General SLO 3. Demonstrate knowledge of the use of PowerPoint application to produce professional looking presentations.

Student Learning Outcomes	Assessment Strategies
3.1 Apply Quick Start for PowerPoint accurately	Assignments and quizzes
3.2 Navigate through a presentation and among the PowerPoint views	Assignments and quizzes
3.3 Apply designs, effects and animations	Assignments and quizzes
3.4 Proof, save and print PowerPoint presentations	Assignments and quizzes

General SLO 4. Apply effective keyboarding techniques.

Student Learning Outcomes	Assessment Strategies
4.1 Recall and improve keyboarding techniques	Typing drills and tests
4.2 Identify and use the proofreader’s marks	Typing drills and tests
4.3 Type corrected copy from rough drafts	Typing drills and tests
4.4 Attain a minimum speed of 45 correct words a minute on a 5-minute timed writing.	Typing drills and tests

D. COURSE CONTENT

1. Use Spreadsheet Application to organize and graph data
2. Use Database Application to create and process data
3. Use PowerPoint Application to produce professional looking presentations
4. Keyboarding techniques

• Alphabets, Numbers, Symbols
• Rough drafts
• Drills

E. METHODS OF INSTRUCTION

Hands-on practice, lecture, demonstration, and individual and group assignments

F. REQURIED TEXT(S) AND COURSE MATERIALS

• Pasewark and Pasewark (2008). Introductory Microsoft Office 2007 Massachusetts:
• Course Technology (or most recent edition).
• Flash drive

G. REFERENCE MATERIALS

Duncan, Charles, et al (1985). College Keyboarding/Typewriting Complete Course 11th Edition. South –Western Education Publishers (or most recent edition).

H. INSTRUCTIONAL COSTS

None

I. EVALUATION

None

J. CREDIT BY EXAMINATION

None