ACADEMICS · ADMISSIONS · FINANCIAL AID · CAMPUS LIFE · ATHLETICS · APPLY NOW · DIRECTORY · CALENDAR · NEWS

CIS 235 ADVANCED MICROCOMPUTER SPREADSHEETS

CIS 235 Advanced Micro Computer Spreadsheets

Course Outline 

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:

  1. describe and demonstrate advanced MS Excel skills;
  2. plan, build, and test MS Excel worksheets, which contain advanced-level Excel features;
  3. create and consolidate data;  and
  4. describe and create Pivot Table and Pivot Charts.