CA-095 Basic Computer Application

Course Description

This course is designed to introduce basic computer skills for students in the bookkeeping certificate program. Emphasis is placed on developing the skills necessary to operate PC computers effectively and be productive in school and business surroundings. This course requires students to identify computer hardware components, software, and use Microsoft Office to create personal and business related files in Word, Excel and PowerPoint.

  • This course also meets PLO #(s)1,2,4,5, and 6 of Bookkeeping Certificate program.

A.  PROGRAM LEARNING OUTCOMES (PLOs): 
The student will be able to:
1. Demonstrate proper bookkeeping techniques for a small business.
2. Demonstrate general computer competence and information technology literacy.
3. Describe small business 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.             Explain basic functions and operations of the computer. 
2.             Demonstrate fundamental skills in Word Processing.
3. Demonstrate fundamental skills in Spreadsheet.      
4. Demonstrate fundamental skills in Presentation and Multimedia.


SLO

PLO 1

PLO 2

PLO 3

PLO 4

PLO 5

PLO 6

1

I

IDM

 

I

 

IDM

2

I

IDM

 

ID

 

I

3

I

IDM

 

 

I

 I

4

 

IDM

 

 

 

I

I = Introduced
D = Demonstrated
M = Mastered

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

      General SLO 1.  Explain basic functions and operations of the computer.


Student Learning Outcomes

Assessment Strategies

1.1 Identify computer ergonomics and apply correct ways to use the computer to avoid personal injury and damage to the hardware.

Checklists and hands-on exercises. At least 70% correct on the objectives.

1.2 Identify the basic hardware components:
 

  • Monitor,
  • Keyboard,
  • Mouse,
  • System Unit (CPU),
    • Hard drive,
    • RAM,
    • ROM, 
    • CD/DVD drive,
  • Microphone,
  • Speakers,
  • Printer,
  • USB flash drive,
  • CD/DVD,

in order to differentiate among components for input – processing – output  and storage devices.

Complete Worksheet 1,2,3; assignments, quiz, and Test. At least 70% correct on the objectives.

1.3 Name the two types of software:

  • Operating system and
  • Application software

and construct examples of the operating system and application software by listing the examples under each category and describe their functions appropriately.

Complete worksheet 1,2,3, assignments, quiz, and test. At least 70% correct on the objectives.

1.4 Explain Windows desktop Icons environments: file, folders, programs and perform basic file management on desktop or USB flash drive by creating, naming, renaming, and deleting files or folders in order to find or locate files/ folders effectively.
 

Hands-on exercise and assignments. At least 70% correct on the objectives.

1.5 Explain the internet and the world wide web in order to communicate and find information electronically by using Mozilla Firefox or Internet explorer, search engines, and COM-FSM Web mail.  

Hands-on exercises and assignments. At least 70% correct on the objectives.

 

General SLO 2.  Demonstrate Fundamental Skills In Word Processing.


Student Learning Outcomes

Assessment Strategies

 

2.1 Construct professional looking documents using MS Word features properly:

  • Selecting the correct ribbon
  • Opening and saving an existing document
  • Inserting, deleting, and selecting text
  • Checking spelling and grammar and using the thesaurus
  • Previewing and printing a document
  • Creating and saving a new document
  • Creating list
  • Changing document margins and setups (orientation or portrait)
  • Applying paragraph and character formatting with proofreader’s mark
  •  Finding and replacing text
  • Selecting similarly formatted text with painting formats
  • Moving and duplicating text
  • Inserting page breaks, section break, and page numbers
  • Inserting header and footer, footnotes
  • Creating and formatting a table and a report cover page
  •  Citing Sources
  • Creating a Personal-Business Letter
  • Creating letter with envelope and return address
  • Adding bullets and numbered list with special text effects
  • Inserting clip art, text boxes and page border.
  • Adding footnotes

 

Assignments, Hands-on exercises, quiz, and Projects. At least 70% correct on the objectives.

General SLO 3.  Demonstrate fundamental skills in Spreadsheet.


Student Learning Outcomes

Assessment Strategies

 

3.1 Construct professional looking spreadsheet by using the following features in MS Excel:

  • Opening, renaming, and saving a workbook
  • Moving around the worksheet and selecting in a worksheet
  • Entering text and numbers
  • Formatting a worksheet
  • Sorting data
  • Previewing and changing page setup option in a spreadsheet
  • Filing range with a numbers
  • Editing data
  • Filtering, copying, and pasting data
  • Entering formula and using the SUM, MIN, MAX, and AVERAGE functions
  • Using the LOOKUP, TODAY, and NOW functions
  • Adding and removing temporary subtotals
  • Adding borders, fill colors and indenting cell
  • Entering budget formulas
  • Use round function
  • Perform a what-if analysis
  • Creating and formatting chart
  • Adding text box
  • Creating a linking formula

Assignments, Hands-on exercises, quiz, and Projects. At least 70% correct on the objectives.

General SLO 4.  Demonstrate fundamental skills in Presentation and Multimedia.


Student Learning Outcomes

Assessment Strategies

 

4.1 Create and deliver professional looking slide show with multiple slides exercising the use of the following features in MS PowerPoint:

  • Creating, naming, and saving a new presentation
  • Adding and editing slide text
  • Inserting new slides
  • Applying theme
  • Navigating slides and running a slide show
  • Previewing and printing a presentation
  • Applying a customized theme
  • Inserting and resizing clipart
  • Drawing text boxes and shapes
  • Grouping, Distributing, and aligning slide object
  • Deleting and repositioning slides
  • Applying theme from other presentation
  • Working with slide master and slide footer
  • Adding video and audio to slides
  • Adding transition effects and setting up a slide show
  • Creating and modifying graphics
  • Inserting picture as the slide background
  • Applying customized animation effects and using slide show controls
  • Grouping and ungrouping formatting worksheet and copy and paste from excel into PowerPoint
  • Creating text and action button hyperlinks
  • Adding speaker notes.

Assignments, Hands-on exercises, quiz, and Projects. At least 70% correct on the objectives.

D.  COURSE CONTENT
1. Getting start with the computer basics
2. Computer hardware and software
3. Internet and Email
4. Word Processing (Microsoft Word)
5. Spreadsheet (Microsoft Excel)
6. Presentation (Microsoft PowerPoint)

E.  METHODS OF INSTRUCTION
1. Lectures, group work and discussions, hands-on exercises, assignments in-class or take-home, demonstration. 

F.  REQURIED TEXT(S) AND COURSE MATERIALS

  • Napier, Rivers, & Hoggatt, (Published 2012). Learning with Computers II (Level Orange, Grades 8). 2ND Edition. South-Western, Cengage Learning. (or most recent edition)
  • Instructor's Resource CD-ROM ISBN-10: 0538450819
  • ExamView® CD-ROM ISBN-10: 0538450940
  • Software: Microsoft Office latest version available

G.  REFERENCE MATERIALS

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 2020 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, 428 J Street., Suite 400 Sacramento, CA 95814, (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