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

This website and all COM-FSM Internet based services are best viewed with Firefox 3.0 or better.
© Copyright 2014 College of Micronesia-FSM | Site Disclaimer
P. O. Box 159, Kolonia, Pohnpei, 96941 - (691) 320-2480
College of Micronesia-FSM is accredited by the Accrediting Commission for Community and Junior Colleges,
Western Association of Schools and Colleges, 10 Commercial Bldv., Suite 204, Novato, CA 94949, (415) 506-0234,
an institutional accrediting body recognized by the Council for Higher Education Accreditation and the U.S. Department of Education.
Additional information about accreditation, including the filing of complaints against member institutions, can be found at: www.accjc.org

feedback