CMIS 101 - Computer Literacy

3 Credit (2 lecture, 1 lab) 3 Contact Hours

1. Manipulate files and folders using Create, Move, Cut, Copy, Paste, Rename, Delete.
2. Open applications software.
3. Manipulate windows using resize, move, minimize, maximize, and close.

Goal 2:  Describe basic hardware components.

1. Define components of the system unit.
2. Differentiate between temporary and permanent storage devices.
3. Categorize physical components by input, output, and storage.

Goal 3:  Perform basic word processing functions.

1. Navigate within the Word user interface.
2. Enter text using word wrap.
3. Apply the autocorrect function.
4. Use document data to create labels and envelopes.
5. Use the spell check function
6. Manipulate document text using move and copy, insert and delete, search and replace
7. Demonstrate basic text selection procedures
8. Modify page layout including margins and line spacing
9. Apply basic formatting including alignment, format styles, highlighting, font, and font size

Goal 4:  Develop basic spreadsheets

1. Enter basic text and numeric information
2. Navigate within the Excel user interface.
3. Incorporate basic functions into a spreadsheet design including Sum, Average, Max, Min, If, Date, PMT.
4. Apply basic formatting to both text and numeric data.
5. Incorporate headers and footers into finished reports.
6. Create a basic chart.

Goal 5:  Structure basic databases.

1. Navigate within the Access user interface.
2. Create Access tables using multiple data types.
3. Modify an Access table.
4. Complete a basic table join.
5. Create a report.
6. Design a basic select query.
7. Input data.

Goal 6:  Create basic electronic presentations with PowerPoint.

1. Incorporate a title slide.
2. Add new slides to a presentation.
3. Insert bulleted text including multiple levels with demotion.
4. Create speaker notes.
5. Use various printing options including slides, handouts, speaker notes.

Goal 7:  Apply basic concepts of online communications.

1. Access the Web using browser software.
2. Use search engine.
3. Find geographic locations using mapping site.
4. Use e-mail.
5. Execute basic functions of course management system including the discussion board, file upload and download, and accessing the grade book.