CIS 235 ADVANCED MICROCOMPUTER SPREADSHEETS
CIS 235 – Advanced Micro Computer Spreadsheets
Course Number & Name: CIS 235 Advanced Micro Computer Spreadsheets
Credit Hours: 3.0 Contact Hours: 3.0 Lecture: 3.0 Lab: N/A Other: N/A
Prerequisites: Grade of “C” or better in CIS 135
Co-requisites: None Concurrent Courses: None
Course Description: This course is a continuation of CIS 135, which introduced students to the spreadsheet analysis application, Excel for Windows. Continuing the step-by- step instruction using case studies, advanced Excel features and OLE (Object Linking and Embedding), hyperlink to the Internet and Visual Basic function will be covered. Special attention is paid to creating macro modules using Visual Basic. An advanced research project is required.
Course Goals: Upon successful completion of this course, students should be able to do the following:
- describe and demonstrate advanced MS Excel skills;
- plan, build, and test MS Excel worksheets, which contain advanced-level Excel features;
- create and consolidate data; and
- describe and create Pivot Table and Pivot Charts.