Catalog Description
CIOS 135 Microcomputer Spreadsheets
Comprehensive exploration of topics related to using microcomputer spreadsheets. Includes creating, formatting and revising spreadsheets; creating formulas, graphics and charts; and using spreadsheets to organize, analyze and query information. (Recommended: CIOS 150 or equivalent computer literacy including saving/retrieving files, use of office applications, Internet and e-mail.) (1 - 3+0) As Demand Warrants

Skill Expectations
Students should have taken CIOS 150 Computer Business Applications or have equivalent skills before taking this class.

List of Class Competencies

1. To be able to understand the purpose of the software and to select and apply the software features to accomplish appropriate tasks.
    
2. To be able to use help, reference, and tutorial information, included with the application, to answer questions and to learn procedures.
    
3. To be able to use basic worksheet skills including selection and navigation.
    
4. To be able to use editing skills including inserting, deleting, copying and moving.
    
5. To be able to select and use appropriate formatting skills to prepare the worksheet for printing or screen display.
    
6. To be able to create formulas and select and use functions.
    
7. To be able to use a workbook, including using multiple worksheets, writing 3D formulas, and formatting and creating groups of worksheets.
    
8. To be able to use charting skills to display worksheet information for analysis or presentation.
    
9. To be able to use database or list skills to organize, analyze, and query information.
    
10. To be able to use graphic skills, such as drawings and embedded objects, to annotate a worksheet or to create a form or handout.
     
11. To be able to use printing skills to use the full capability of the application to prepare worksheets for printing.
     
12. To be able to use file management skills to import and export files and to convert files to different formats.
     
13. To be able to use special worksheet features such as names and styles to format and document a workbook.
     
14. To be able to use the auditing capabilities of the worksheet to look for and correct worksheet errors.
     
15. To be able to design and protect a workbook so that it can be used safely by a variety of computer users.
16. To be able to convert and publish documents to the World Wide Web.
     
17. To be able to use application customizing options, such as custom toolbars and macro or application languages to create custom work environments.
     
18. To be able to protect the software application from viruses and to configure the appropriate security settings of the software.
     
19. To be able to support other users of the software and to help them use the application effectively.

Related Links:

• CIOS Course Descriptions
• Credit for Prior Learning