2021-2022 Pierce College Catalog 
    
    Feb 03, 2023  
2021-2022 Pierce College Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

CIS 136 Spreadsheet Applications (5 credits)



Prerequisite MATH 096  or higher; or instructor permission.

Course Description
This course introduces basic and advanced spreadsheet design and development mapped to the multiple levels of Microsoft Excel certifications. Topics will include creation and manipulation of spreadsheets, conversion to charts and graphs, and creation of macros. Additional coverage of data validation, data integrity, testing, legal constraints, retention policies, and documentation.

Student Outcomes
1. Demonstrate basic computer usage skills such as saving files, backups, file management, security, and virus checking.
2. Translate technical information into user-appropriate format.
3. Solve mathematical, accounting, logical, and statistical problems using spreadsheet capabilities.
4. Create, modify, and run macros using an appropriate programming/scripting language.
5. Design and create spreadsheets, graphs, and charts to accurately summarize and document information.
6. Sort, pivot, and filter data.
7. Validate and manage data.
8. Perform goal-seeking and what-if-analysis.
9. Build and use spreadsheet templates.
10. Import, convert, link, and export data from one application to another.
11. Link spreadsheets with other documents.
12. Organize data using spreadsheet database capabilities.



Add to Portfolio (opens a new window)