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.
Course Content
A. Spreadsheets
B. Charts and Graphs
C. Analyze and Manage Data
D. Spreadsheet Templates
E. Data Sharing
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.
Degree Outcomes
Effective Communication: Graduates will be able to exchange messages in a variety of contexts using multiple methods.
Program Outcome: Develop queries, forms and reports to meet user information requirements.
Lecture Contact Hours 50
Lab Contact Hours 0
Clinical Contact Hours 0
Total Contact Hours 50
Add to Portfolio (opens a new window)
|
