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.
Course Content
1. Spreadsheets
2. Calculations
3. Formatting
4. Filtering and sorting
5. Charting and graphing
6. Data validation and verification
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.
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 20
Lab Contact Hours 0
Clinical Contact Hours 0
Total Contact Hours 20
Add to Portfolio (opens a new window)
|
