2021-2022 Pierce College Catalog 
    Mar 20, 2023  
2021-2022 Pierce College Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

CIS 137 Applied Spreadsheet Applications I (2 credits)

Prerequisite Admission to any BAS program.

Course Description
Microsoft Excel is an integral part of most business organizations. It is a robust data tracking, analytical, and decision-making tool used by for-profit and non-profit organizations around the world. It is commonly applied for operational, marketing, and financial computations decision-making. Business professionals who hold Excel certifications demonstrate facility with this powerful software and ability to add value to an organization. This is a beginning spreadsheet course in Microsoft Excel that ties to the first level Microsoft Office Specialist (MOS) certification exam.

Student Outcomes
1. Create, customize, and manage worksheets and workbooks for distribution.
2. Summarize, organize and format data cells and ranges.
3. Create, format, filter, and sort Excel tables.
4. Use Excel functions to perform calculations on data, perform conditional operations, and modify text data.
5. Create and format charts and objects (such as text boxes, images, and shapes).
6. Demonstrate basic computer usage skills such as saving files, backups, file management, security, and virus checking.
7. Translate technical information into user-appropriate format.
8. Validate and manage data integrity.
9. Design spreadsheets to meet accessibility requirements.

Add to Portfolio (opens a new window)