Computer Information Systems

2013-14 Edition

Sylvania Campus
Technology Classroom Building (TCB), Room 312
971-722-4287 or 971-722-4393

www.pcc.edu/cis

Career and Program Description

Computer Information Systems are the lifeblood of the 21st century. The mainstream languages, tools, technologies and techniques used in training will allow students to pursue careers in either the computer networking or information software fields. On the networking side, computer configuration, network installation, network systems administration, security, forensics and wireless networking are some career choices. On the software side, student career choices include all phases of application development, database programming, software quality assurance, Health Informatics and project management on both desktop and World Wide Web platforms.

Computer Information Systems AAS Degree: This degree prepares students for computer information systems related careers. Students will take classes in the CIS Department that include software analysis, design, programming (in two or more languages), database modeling, Windows or Unix operating systems, data communications and an extensive selection of electives. In order to follow the recommended sequence of courses, students should be ready to enter WR 121 and MTH 95. Students must satisfactorily complete all courses with a CIS prefix in the degree with a grade of C or better.

Computer Information Systems: Network Administration AAS Degree: This degree prepares students for computer networking related careers. Students will take classes in the CIS Department including data communications, Windows and Linux network administration, network security and an extensive selection of electives. Students earning this degree will be well on their way to several network administration certifications from Microsoft and Comp TIA. In order to follow the recommended sequence of courses, students should be ready to enter WR 121 and MTH 95. Students must satisfactorily complete all courses with a CIS prefix in the degree with a grade of C or better.

Health Informatics AAS Degree: This limited entry degree prepares students for health informatics related careers. Students will take classes in the CIS department that include software analysis, design, programming, database modeling, Windows and Unix operating systems, and an extensive selection of electives. Students must meet with an advisor prior to entry in degree program. Students will also take classes from the BA and HIM departments. In order to follow the recommended sequence of courses, students should be ready to enter WR 121 and MTH 95. Students should also complete CAS 133 or CIS 120 or have basic computer skills in Windows Operating System, and Microsoft Word, Excel, Powerpoint and Access prior to taking any HIM or CIS course. Note: Criminal background checks and drug tests are required in most health care industry jobs, including health informatics.

Computer Information Systems One-Year Certificate: This certificate provides students with a foundation in computer information systems concepts. Students seeking this certificate often have various primary roles in their organizations and are taking on additional responsibilities involving information systems. All required courses in this program apply toward the credits needed to obtain an AAS degree in Computer Information Systems or CIS Network Administration. In order to follow the recommended sequence of courses, students should be ready to enter WR 121 and MTH 60.

Computer Information Systems: E-Commerce One-Year Certificate: This certificate prepares students for careers in Internet based commerce including web server administrator, webmaster, E-Commerce manager, help desk/user support specialist, web technologist and web developer. Specialists in these positions, with both a business and technical perspective, will be able to resolve multi tier E-Commerce issues involving connectivity, security and scalability. Students must have a strong CIS background before beginning this certificate. This may be accomplished by obtaining a CIS AAS degree or by equivalent industry experience. In order to follow the recommended sequence of courses, students should be ready to enter WR 227 and MTH 60.

Readiness for all Computer Information System degrees and certificates can be demonstrated through the math placement test and documented previous college level work for the WR 121 requirement. Those students with insufficient background to enter at this level may need to extend the time it takes to complete the program. CIS Department advisors will provide information regarding options to those students who may need to take preparatory course work.

Degrees and Certificates Offered

Associate of Applied Science Degree

Computer Information Systems
Computer Information Systems: Network Administration Option
Health Informatics

One-Year Certificate

Computer Information Systems
Computer Information Systems: E-Commerce

Less than One-Year Certificate: Career Pathway

Windows Network Security
Linux/Unix Network Security
Network Administration
Microsoft Server Administration
Linux Server Administration
Web Application Development
Oracle and SQL
Java Application Programming
Database Design and SQL
VB.Net Application Programming

Associate of Applied Science Degree

Computer Information Systems
Computer Information Systems: Network Administration Option
Health Informatics

Computer Information Systems AAS Degree

Minimum 94 credits. Students must also meet Associate Degree Comprehensive Requirements and Associate of Applied Science Requirements. Students must complete a total of sixteen credits of General Education. Some courses specified within the program may be used as General Education. Students should consult with program advisors for course planning.

Computer Information Systems Degree Credit Summary

CIS32
WR4
CIS Program Electives36
CIS Programming Electives8
CIS Program Business Electives6
Remaining General Education8
Total Credits94

Computer Information Systems Degree Courses

CIS 120Computer Concepts I *4
CIS 121Computer Concepts II *4
CIS 122Software Design *4
CIS 140MOperating Systems I: Microsoft4
or CS 140U Introduction to UNIX
CIS 179Data Communication Concepts I4
CIS 244Systems Analysis4
CIS 275Data Modeling and SQL Introduction4
WR 121English Composition4
WR 122English Composition4
or WR 227 Technical and Professional Writing 1
CIS Program Electives 136
CIS Programming Electives 28
Remaining General Education8
CIS Program Business Electives (see list below) *6
Total Credits94

*

Could be used as General Education

1

CIS Program Electives - 36 credits total, 20 credits must be at the 200 level.

2

For the Computer Information Systems AAS Degree, eight credits of Programming electives must be a two-term sequence from the Programming Elective List.

Computer Information Systems Programming Electives

CS 161
  & CS 162
Computer Science I
   and Computer Science II
8
CIS 133B
  & CIS 233B
Introduction to Visual Basic.NET Programming
   and Intermediate Visual Basic.NET Programming
8
CIS 133J
  & CIS 233J
Java Programming I
   and Java Programming II
8

Computer Information Systems Program Electives

CAS 215Cascading Style Sheets - CSS4
CIS 125DDatabase Application Development I4
CIS 133BIntroduction to Visual Basic.NET Programming4
CIS 133JJava Programming I4
CIS 133WJavaScript for Web Developers4
CIS 135AApplication Development with Agile/Scrum4
CIS 135MMobile Application Programming4
CIS 135TXML and HL74
CIS 140MOperating Systems I: Microsoft4
CIS 140SPerl Script Programming1
CIS 145Microcomputer Hardware and Troubleshooting4
CIS 178Applied Internet Concepts4
CIS 179Data Communication Concepts I4
CIS 187IWeb Technical Administration4
CIS 188Introduction to Wireless Networking4
CIS 189Wireless Security4
CIS 195PPHP Web Development I4
CIS 225End User Support4
CIS 233BIntermediate Visual Basic.NET Programming4
CIS 233JJava Programming II4
CIS 233SInternet Web Page Scripting4
CIS 234BAdvanced Visual Basic.NET Programming4
CIS 234JJava Programming III4
CIS 234NC# Programming4
CIS 234SWeb Application Development Using.NET4
CIS 240LLinux Installation and Configuration4
CIS 240MManaging a Windows Server Environment4
CIS 243E-ssentials of E-Commerce Information Systems4
CIS 244Systems Analysis4
CIS 245Project Management - Information Systems4
CIS 246Structured Systems Design4
CIS 275Data Modeling and SQL Introduction4
CIS 276Advanced SQL4
CIS 277DDatabase Security4
CIS 277OAdvanced Database Concepts in Oracle4
CIS 277TWeb Business Intelligence Application Development4
CIS 278Data Communication Concepts II4
CIS 279LLinux Network Administration4
CIS 280DCooperative Education: Application Development 14
CIS 284Network Security4
CIS 286Computer Forensics4
CIS 287IWeb Server Administration4
CIS 288MMicrosoft Network Administration4
CIS 289MMicrosoft Active Directory Administration4
CIS 295PPHP Web Development II4
CS 133UC Programming4
CS 140UIntroduction to UNIX4
CS 160Exploring Computer Science *4
CS 161Computer Science I *4
CS 162Computer Science II *4
CS 201Computer Systems4
CS 260Data Structures4
CS 261Programming Systems4
EET 178PC Architecture for Technicians4

*

Could be used as General Education

1

A maximum of four CIS 280D credits can be applied toward the CIS degree. Additional credits, up to a maximum of eight, may be applied toward the degree, but must be approved by a CIS Department advisor.

Computer Information Systems Program Business Electives

BA 203Introduction to International Business3
BA 206Management Fundamentals3
BA 211Principles of Accounting I3
BA 212Principles of Accounting II3
BA 213Managerial Accounting4
BA 215Basic Cost Accounting3
BA 222Financial Management3
BA 223Principles of Marketing4
BA 226Business Law I4
BA 227Business Law II3
BA 234International Marketing3
BA 240Nonprofit Financial Management and Accounting4
BA 242Introduction to Investments3
BA 244Introduction to Records Management3
BA 250Small Business Management3
BA 251Office Management3
EC 201Principles of Economics: Microeconomics *4
EC 202Principles of Economics: Macroeconomics *4
EC 203Principles of Economics: Applications to Economic Issues *4

*

Could be used as General Education

Network Administration AAS Degree

Minimum 94 credits. Students must also meet Associate Degree Comprehensive Requirements and Associate of Applied Science Requirements. Students must complete a total of sixteen credits of General Education. Some courses specified within the program may be used as General Education. Students should consult with program advisors for course planning.

Network Administration Degree Credit Summary 

CIS36
CS4
WR8
CIS Programming Electives4
CIS Program Business Electives6
Network Admin Degree Electives28
Remaining General Education8
Total Credits94

Network Administration Degree Courses 

CIS 120Computer Concepts I *4
CIS 121Computer Concepts II *4
CIS 122Software Design *4
CIS 140MOperating Systems I: Microsoft4
CIS 145Microcomputer Hardware and Troubleshooting4
CIS 179Data Communication Concepts I4
CIS 240MManaging a Windows Server Environment4
or CIS 240L Linux Installation and Configuration
CIS 244Systems Analysis4
CIS 288MMicrosoft Network Administration4
or CIS 279L Linux Network Administration
CS 140UIntroduction to UNIX4
WR 121English Composition4
WR 122English Composition4
or WR 227 Technical and Professional Writing 1
CIS Programming Electives4
CIS Program Business Electives6
Network Administration Degree Electives 128
Remaining General Education8
Total Credits94

*

Could be used as General Education.

1

Network Administration Electives - 28 credit total, 20 credits must be at the 200 level.

Computer Information Systems Network Administration Degree Electives

CIS 178Applied Internet Concepts4
CIS 187IWeb Technical Administration4
CIS 188Introduction to Wireless Networking4
CIS 189Wireless Security4
CIS 225End User Support4
CIS 240LLinux Installation and Configuration4
CIS 240MManaging a Windows Server Environment4
CIS 278Data Communication Concepts II4
CIS 279LLinux Network Administration4
CIS 280DCooperative Education: Application Development1-4
CIS 284Network Security4
CIS 286Computer Forensics4
CIS 287IWeb Server Administration4
CIS 287MMicrosoft Server Security4
CIS 288MMicrosoft Network Administration4
CIS 289MMicrosoft Active Directory Administration4

Computer Information Systems Program Business Electives

BA 203Introduction to International Business3
BA 206Management Fundamentals3
BA 211Principles of Accounting I3
BA 212Principles of Accounting II3
BA 213Managerial Accounting4
BA 215Basic Cost Accounting3
BA 222Financial Management3
BA 223Principles of Marketing3
BA 226Business Law I4
BA 227Business Law II3
BA 234International Marketing3
BA 240Nonprofit Financial Management and Accounting4
BA 242Introduction to Investments3
BA 244Introduction to Records Management3
BA 250Small Business Management3
BA 251Office Management3
EC 201Principles of Economics: Microeconomics *4
EC 202Principles of Economics: Macroeconomics *4
EC 203Principles of Economics: Applications to Economic Issues *4

*

Could be used as General Education

Computer Information Systems Programming Electives

CS 161
  & CS 162
Computer Science I
   and Computer Science II
8
CIS 133B
  & CIS 233B
Introduction to Visual Basic.NET Programming
   and Intermediate Visual Basic.NET Programming
8
CIS 133J
  & CIS 233J
Java Programming I
   and Java Programming II
8

Health Informatics AAS Degree

Minimum 96 credits. Students must also meet Associate Degree Comprehensive Requirements and Associate of Applied Science Requirements. Students must complete a total of sixteen credits of General Education. Some courses specified within the program may be used as General Education. Students should consult with program advisors for course planning.

Health Informatics Degree Credit Summary

HIM14
BA7
CIS28
CIS/CS4
MP4
Health Informatics Degree Electives15
Beginning Programming Electives4
Intermediate Programming Electives4
General Education 116
Total Credits96

Health Informatics Degree Courses

BA 205Business Communication Using Technology4
BA 211Principles of Accounting I3
CIS 125DDatabase Application Development I4
CIS 140MOperating Systems I: Microsoft4
or CS 140U Introduction to UNIX
CIS 179Data Communication Concepts I4
CIS 244Systems Analysis4
CIS 245Project Management - Information Systems4
CIS 275Data Modeling and SQL Introduction4
CIS 276Advanced SQL4
CIS 280DCooperative Education: Application Development4
or CIS 277H Health Informatics Environment Simulation
HIM 110Health Record Content 14
HIM 182Health Care Delivery Systems3
HIM 283Health Information Systems4
HIM 285Healthcare Financing and Compliance3
MP 111Medical Terminology4
Health Informatics Electives15
Beginning Programming Electives4
Intermediate Programming Electives4
General Education 116
Total Credits96

Beginning Programming Electives

CIS 122Software Design *14
CIS 133BIntroduction to Visual Basic.NET Programming4
CIS 133JJava Programming I4
CS 161Computer Science I *14

Intermediate Programming Electives

CIS 135TXML and HL74
CIS 233BIntermediate Visual Basic.NET Programming4
CIS 233JJava Programming II4
CS 162Computer Science II *14

Health Informatics Degree Electives

BA 224Human Resource Management3
BA 255Project Management - Business Environments4
BI 112Cell Biology for Health Occupations *5
BI 121Introduction to Human Anatomy & Physiology I *4
BI 122Introduction to Human Anatomy & Physiology II *4
BI 231Human Anatomy & Physiology I *4
BI 232Human Anatomy & Physiology II *4
BI 233Human Anatomy & Physiology III *4
CIS 140MOperating Systems I: Microsoft4
CIS 145Microcomputer Hardware and Troubleshooting4
CIS 188Introduction to Wireless Networking4
CIS 189Wireless Security4
CIS 225End User Support4
CIS 240LLinux Installation and Configuration4
CIS 240MManaging a Windows Server Environment4
CIS 277DDatabase Security4
CIS 277OAdvanced Database Concepts in Oracle4
CIS 277TWeb Business Intelligence Application Development4
CIS 278Data Communication Concepts II4
CIS 279LLinux Network Administration4
CIS 284Network Security4
CIS 288MMicrosoft Network Administration4
CIS 289MMicrosoft Active Directory Administration4
CS 140UIntroduction to UNIX4
HIM 120Health Record Content 1 Lab1
HIM 271Quality Improvement in Healthcare3
HIM 274Quality Improvement in Healthcare Lab1
HIM 281Data Management and Analysis3
HIM 286Data Management and Analysis Lab2
MSD 279Project Management - Intro4
OS 220Business Editing Skills4
WR 122English Composition4
WR 227Technical and Professional Writing 14

*

Could be used as General Education

1

If applied to General Education requirement, students must also take an additional and equal number of credits from the Health Informatics Elective list.

One-Year Certificate

Computer Information Systems
Computer Information Systems: E-Commerce

Less than One-Year Certificate: Career Pathway

Windows Network Security
Linux/Unix Network Security
Network Administration
Microsoft Server Administration
Linux Server Administration
Web Application Development
Oracle and SQL
Java Application Programming
Database Design and SQL
VB.Net Application Programming

Computer Information Systems One-Year Certificate

Minimum 46 credits. Students must meet all certificate requirements.

Computer Information Systems Certificate Credit Summary

CIS12
CIS/CIS4
PSY4
WR8
CAS/DRF/CIS Program Elective3
CIS Program Electives12
CIS Program Business Electives3
Total Credits46

Computer Information Systems Certificate Courses

CIS 120Computer Concepts I4
CIS 121Computer Concepts II4
CIS 122Software Design4
CIS 140MOperating Systems I: Microsoft4
or CS 140U Introduction to UNIX
PSY 201AIntroduction to Psychology - Part 14
WR 121English Composition4
WR 227Technical and Professional Writing 14
Choose one of the following:3
Beginning Word
CIS Program Electives (see list below)
Introduction to AutoCAD
CIS Program Electives (see list below)12
CIS Program Business Electives (see list below)3
Total Credits46

Optional cooperative education work experience placements are available. For more information, see a CIS Department advisor.

Computer Information Systems Program Electives

CIS 125DDatabase Application Development I4
CIS 133BIntroduction to Visual Basic.NET Programming4
CIS 133JJava Programming I4
CIS 135TXML and HL74
CIS 140MOperating Systems I: Microsoft4
CIS 140SPerl Script Programming1
CIS 145Microcomputer Hardware and Troubleshooting4
CIS 178Applied Internet Concepts4
CIS 179Data Communication Concepts I4
CIS 1853
CIS 187IWeb Technical Administration4
CIS 188Introduction to Wireless Networking4
CIS 189Wireless Security4
CIS 195PPHP Web Development I4
CIS 225End User Support4
CIS 233BIntermediate Visual Basic.NET Programming4
CIS 233JJava Programming II4
CIS 233SInternet Web Page Scripting4
CIS 234BAdvanced Visual Basic.NET Programming4
CIS 234JJava Programming III4
CIS 234NC# Programming4
CIS 234SWeb Application Development Using.NET4
CIS 240LLinux Installation and Configuration4
CIS 240MManaging a Windows Server Environment4
CIS 243E-ssentials of E-Commerce Information Systems4
CIS 244Systems Analysis4
CIS 245Project Management - Information Systems4
CIS 246Structured Systems Design4
CIS 275Data Modeling and SQL Introduction4
CIS 276Advanced SQL4
CIS 277DDatabase Security4
CIS 277OAdvanced Database Concepts in Oracle4
CIS 277TWeb Business Intelligence Application Development4
CIS 278Data Communication Concepts II4
CIS 279LLinux Network Administration4
CIS 280DCooperative Education: Application Development 14
CIS 284Network Security4
CIS 286Computer Forensics4
CIS 287IWeb Server Administration4
CIS 288MMicrosoft Network Administration4
CIS 289MMicrosoft Active Directory Administration4
CIS 295PPHP Web Development II4
CS 133UC Programming4
CS 140UIntroduction to UNIX4
CS 160Exploring Computer Science *4
CS 161Computer Science I *4
CS 162Computer Science II *4
CS 201Computer Systems4
CS 260Data Structures4
CS 261Programming Systems4
EET 178PC Architecture for Technicians4

*

Could be used as General Education

1

A maximum of four CIS 280D credits can be applied toward the CIS degree. Additional credits, up to a maximum of eight, may be applied toward the degree, but must be approved by a CIS Department advisor.

Computer Information Systems Program Business Electives

BA 203Introduction to International Business3
BA 206Management Fundamentals3
BA 211Principles of Accounting I3
BA 212Principles of Accounting II3
BA 213Managerial Accounting4
BA 215Basic Cost Accounting3
BA 222Financial Management3
BA 223Principles of Marketing3
BA 226Business Law I4
BA 227Business Law II3
BA 234International Marketing3
BA 240Nonprofit Financial Management and Accounting4
BA 242Introduction to Investments3
BA 244Introduction to Records Management3
BA 250Small Business Management3
BA 251Office Management3
EC 201Principles of Economics: Microeconomics *4
EC 202Principles of Economics: Macroeconomics *4
EC 203Principles of Economics: Applications to Economic Issues *4

*

Could be used as General Education

E-Commerce One-Year Certificate

Minimum 48 credits. Students must meet all certificate requirements.

E-commerce Certificate Credit Summary 

Track A Design and Development

CIS17
PSY4
WR4
Track A Electives20
CIS E-Com Business Electives3
Total Credits48

E-Commerce Track A Courses

CIS 225End User Support4
CIS 243E-ssentials of E-Commerce Information Systems4
CIS 244Systems Analysis4
CIS 275Data Modeling and SQL Introduction4
CIS 280DCooperative Education: Application Development1
PSY 201AIntroduction to Psychology - Part 14
WR 227Technical and Professional Writing 14
E-Commerce Business Electives3
Track A Design and Development Electives20
Total Credits48

Track A: Design and Development Electives

CAS 110Introduction to Web Graphics Using Fireworks 11
CAS 175Introduction to Flash 13
CAS 211D 13
CAS 213JavaScript and JQuery for Designers 14
CIS 233BIntermediate Visual Basic.NET Programming4
CIS 233JJava Programming II4
CIS 233SInternet Web Page Scripting4
CIS 234BAdvanced Visual Basic.NET Programming4
CIS 234JJava Programming III4
CIS 234SWeb Application Development Using.NET4
CIS 276Advanced SQL4
CIS 277DDatabase Security4
CIS 277OAdvanced Database Concepts in Oracle4
CIS 277TWeb Business Intelligence Application Development4
CIS 280DCooperative Education: Application Development1
MM 130Multimedia Graphic Video and Audio Production 13
MM 230Graphics for Multimedia 14

1

Note: Maximum of eight credits will apply.

E-commerce Certificate Credit Summary

Track B Administration

CIS17
PSY4
WR4
Track B Electives20
E-Com Business Electives3
Total Credits48

CIS: E-Commerce Track B Courses

CIS 225End User Support4
CIS 243E-ssentials of E-Commerce Information Systems4
CIS 244Systems Analysis4
CIS 275Data Modeling and SQL Introduction4
CIS 280DCooperative Education: Application Development1
PSY 201AIntroduction to Psychology - Part 14
WR 227Technical and Professional Writing 14
E-Commerce Business Electives3
Track B Administration Electives20
Total Credits48

Track B: Administration Electives

CAS 225PHP and MySQL for Designers4
CAS 275Intermediate Flash3
CIS 179Data Communication Concepts I4
CIS 240LLinux Installation and Configuration4
CIS 240MManaging a Windows Server Environment4
CIS 279LLinux Network Administration4
CIS 280DCooperative Education: Application Development1
CIS 287IWeb Server Administration4
CIS 288MMicrosoft Network Administration4
CIS 289MMicrosoft Active Directory Administration4

E-Commerce Business Electives

BA 203Introduction to International Business3
BA 206Management Fundamentals3
BA 223Principles of Marketing4
BA 226Business Law I4

Computer Information Systems: Career Pathway Certificates

Database Design and SQL: Career Pathway Certificate

Minimum 12 credits. The Database Design and SQL Certificate is a Career Pathway. All courses are contained in the Computer Information Systems AAS Degree.

CIS 125DDatabase Application Development I4
CIS 275Data Modeling and SQL Introduction4
CIS 276Advanced SQL4
Total Credits12

Microsoft Server Administration: Career Pathway Certificate

Minimum 24 credits. The Microsoft Server Administration Certificate is a Career Pathway. All courses are contained in the Network Administration AAS Degrees.

CIS 140MOperating Systems I: Microsoft4
CIS 179Data Communication Concepts I4
CIS 240MManaging a Windows Server Environment4
CIS 287MMicrosoft Server Security4
CIS 288MMicrosoft Network Administration4
CIS 289MMicrosoft Active Directory Administration4
Total Credits24

Linux/Unix Server Network Security: Career Pathway Certificate

Minimum 28 credits. The Linux/Unix Server Administration Certificate is a Career Pathway. All courses are contained in the Network Administration AAS Degree.

CIS 179Data Communication Concepts I4
CIS 189Wireless Security4
CIS 240LLinux Installation and Configuration4
CIS 279LLinux Network Administration4
CIS 284Network Security4
CIS 286Computer Forensics4
CS 140UIntroduction to UNIX4
Total Credits28

Windows Network Security: Career Pathway Certificate

Minimum 36 credits. The Windows Network Security Certificate is a Career Pathway. All courses are contained in the Network Administration AAS Degree.

CIS 140MOperating Systems I: Microsoft4
CIS 179Data Communication Concepts I4
CIS 189Wireless Security4
CIS 240MManaging a Windows Server Environment4
CIS 284Network Security4
CIS 286Computer Forensics4
CIS 287MMicrosoft Server Security4
CIS 288MMicrosoft Network Administration4
CIS 289MMicrosoft Active Directory Administration4
Total Credits36

Java Application Programming: Career Pathway Certificate

Minimum 16 credits. The Java Application Programming Certificate is a Career Pathway. All courses are contained in the Computer Information Systems AAS Degree.

CIS 122Software Design4
CIS 133JJava Programming I4
CIS 233JJava Programming II4
CIS 234JJava Programming III4
Total Credits16

Network Administration: Career Pathway Certificate

Minimum 16 credits. The Network Administration Certificate is a Career Pathway. All courses are contained in the Network Administration AAS Degree.

CIS 179Data Communication Concepts I4
CIS 188Introduction to Wireless Networking4
CIS 189Wireless Security4
CIS 278Data Communication Concepts II4
Total Credits16

VB.Net Application Programming: Career Pathway Certificate

Minimum 16 credits. The VB.Net Application Programming Certificate is a Career Pathway. All courses are contained in the Computer Information Systems AAS Degree.

CIS 122Software Design4
CIS 133BIntroduction to Visual Basic.NET Programming4
CIS 233BIntermediate Visual Basic.NET Programming4
CIS 234BAdvanced Visual Basic.NET Programming4
Total Credits16

Linux Server Administration: Career Pathway Certificate

Minimum 16 credits. The Linux Server Administration Certificate is a Career Pathway. All courses are contained in the Network Administration AAS Degree.

CIS 179Data Communication Concepts I4
CIS 240LLinux Installation and Configuration4
CIS 279LLinux Network Administration4
CS 140UIntroduction to UNIX4
Total Credits16

Oracle and SQL: Career Pathway Certificate

Minimum 12 credits. The Oracle and SQL Certificate is a Career Pathway. All courses are contained in the Computer Information Systems AAS Degree.

CIS 276Advanced SQL4
CIS 277OAdvanced Database Concepts in Oracle4
CIS 277TWeb Business Intelligence Application Development4
Total Credits12

Web Application Development: Career Pathway Certificate

Minimum 16 credits. The Web Application Development Certificate is a Career Pathway. All courses are contained in the Computer Information Systems AAS Degree.

CIS 195PPHP Web Development I4
CIS 233SInternet Web Page Scripting4
CIS 234SWeb Application Development Using.NET4
CIS 295PPHP Web Development II4
Total Credits16

Courses

CIS 120. Computer Concepts I. 4 Credits.

Introduces computing fundamentals from the past into the future, utilizes key applications to solve practical problems, and explores the benefits and risks of living online. Designed for the student who is already computer literate with the MS Office applications, e-mail, and the Internet and focuses on applying this literacy to practical IT applications. Provides a foundation to pursue an IT pathway and helps prepare students for the IC3 certification. Prerequisites: WR 115, RD 115 and MTH 20 or equivalent placement test scores. Recommend: basic computer skills equivalent to CAS 133 or BA 131. Audit available. This course fulfills the following GE requirements: Mathematics, Science, and Computer Science/AS, Mathematics, Science, and Computer Science/AAS, Mathematics, Science, and Computer Science/AGS.

CIS 121. Computer Concepts II. 4 Credits.

Covers evaluation, selection and application of computer technology to solve practical problems in database design, web page design, networking and programming. Addresses ethical issues associated with technology. Prerequisites: CIS 120 or instructor permission; WR 115, RD 115 and MTH 20 or equivalent placement test scores. Audit available. This course fulfills the following GE requirements: Mathematics, Science, and Computer Science/AS, Mathematics, Science, and Computer Science/AAS, Mathematics, Science, and Computer Science/AGS.

CIS 122. Software Design. 4 Credits.

Covers software design as part of the software development life cycle. Includes basic logic constructs, testing programs, use case descriptions, modularity and an introduction to object design. Provides examples of well-designed software projects. Additional lab hours may be required. Recommended: CIS 120 or CAS 133 or BA 131. Prerequisites: WR 115, RD 115, MTH 20 or equivalent placement test scores. Audit available. This course fulfills the following GE requirements: Mathematics, Science, and Computer Science/AS, Mathematics, Science, and Computer Science/AAS, Mathematics, Science, and Computer Science/AGS.

CIS 125D. Database Application Development I. 4 Credits.

Concepts of a client-based relational database management system (RDBMS) and application of such systems to the business environment. Topics include database management issues, database design, creating and maintaining databases, creating forms, queries and reports. Design, create and maintain a database system. Recommended: CIS 121 or instructor permission. Audit available.

CIS 133B. Introduction to Visual Basic.NET Programming. 4 Credits.

Introduces design, implementation and testing of software using Visual Basic.NET. Includes how to write Visual Basic.NET programs that solve practical, real world, business-oriented problems. Uses object oriented design techniques. Prerequisite: CIS 122 or instructor permission. Audit available.

CIS 133J. Java Programming I. 4 Credits.

Covers design, implementation and testing software using Java. Introduces how to write Java programs that solve practical, real world, business-oriented problems using object-oriented design techniques. Prerequisite: CIS 122. Audit available.

CIS 133W. JavaScript for Web Developers. 4 Credits.

Covers fundamental programming concepts to build practical, real-world web applications using JavaScript. Covers building websites that handle user events to manipulate page content on-the-fly, opening the door to a plethora of dynamic techniques that only JavaScript can provide. Includes an introduction to jQuery. Prerequisites: CIS 122 or instructor permission. Audit available.

CIS 135A. Application Development with Agile/Scrum. 4 Credits.

Introduces core concepts of Agile development and Scrum in the software development life cycle. Compares Agile to the more popular waterfall approach of software development. Introduces topics for working in an Agile environment as a Scrum Developer, Scrum Master or Scrum Product Owner, the entire Scrum process and artifacts. Additional lab hours may be required. Prerequisites: CIS 120, CIS 122 or instructor approval. Audit available.

CIS 135D. Database Application Development II (VBA). 4 Credits.

Design, development and implementation of a complete database application using Visual Basic for Applications (VBA). Covers Access Object Model, user interfaces, object variables, ADO automation, databases on a server, and COM add-ins. Thorough documentation and structured programming techniques will be emphasized. Recommended: CIS 133B or CIS 125D or instructor permission. Audit available.

CIS 135M. Mobile Application Programming. 4 Credits.

Covers building mobile applications using existing programming languages such as JavaScript, Java, PHP, and third party mobile application development tools. Includes developing simple applications that could run on mobile devices. Covers mobile devices application development phases, terminologies, application design, and coding. Sharpens programming skills in application development. Prerequisite: CIS 122. Audit available.

CIS 135T. XML and HL7. 4 Credits.

Presents design and creation of basic XML documents, namespaces, validation of an XML document using DTDs (Document Type Definitions) and schemas, importing and including XML schema domain information, XML schema intrinsic and user-defined data types, and combining XML with XHTML and Cascading Style Sheets. Discusses the advantages and disadvantages of XML design formats of Flat Catalog, Russian Doll and Venetian Blind. Introduces HL7. Recommend: CIS 122 or instructor permission. Audit available.

CIS 140D. Operating System: Microcomputers. 4 Credits.

Provides the basic concepts of Linux and Windows operating systems. Includes basic operating system functions, file/folder management, disk partitioning and formatting, operating system and application installation, and system configuration. See www.pcc.edu/cis. Recommended: CIS 120 or instructor permission. Audit available.

CIS 140M. Operating Systems I: Microsoft. 4 Credits.

A first course in Microsoft operating systems administration including installation, configuration, and management. Command line and GUI tools used to organize, manage and maintain the file system are covered. Additionally students are introduced to users, groups, printing, profiles policies and the registry. Recommended: CIS 120 Audit available.

CIS 140S. Perl Script Programming. 1 Credit.

Prepares students to install and configure Perl on Linux; design, implement, and test Perl scripts; debug Perl scripts; and locate, read and integrate information from a variety of technical sources. Recommended: Experience writing shell scripts and using Unix regular expressions as covered in CS 140U or equivalent. Audit available.

CIS 145. Microcomputer Hardware and Troubleshooting. 4 Credits.

Students will learn to identify, remove, and install standard components of a PC style microcomputer, including motherboards, CPUs, RAM, hard drives, removable media drives and power supplies. Additional topics include BIOS, CMOS, the boot process, video displays, printers, and home networking. Audit available.

CIS 178. Applied Internet Concepts. 4 Credits.

Introduces the Internet from a user's perspective, with emphasis on productive, professional access. Topics include how to connect to the Internet, how to communicate with others, how to find and share information productively, as well as educational, business and social issues related to the Internet. Recommended: CIS 120 or instructor permission. Audit available.

CIS 179. Data Communication Concepts I. 4 Credits.

Provides basic concepts of data communications, networking and connectivity. Explores hardware, connectivity, signaling, addressing, network topologies, communication protocols, network designs, switching, management, TCP/IP protocols, security and standards with emphasis on the OSI reference model. Prerequisite: CIS 120 or CIS 121 or EET 111 or instructor permission. Audit available.

CIS 187I. Web Technical Administration. 4 Credits.

Internet connections, file transfers, e-mail notifications, and security systems. Investigates web system logs, web content backup strategies, and issues of web user accessibility and web site performance. Linux and Windows server operating system installations, configuration, and management in a virtual environment will be required. Command line commands and GUI tools will be used to organize, manage, and maintain the file system and web server software. Recommended: CIS 121 and CIS 122 or instructor permission. Audit available.

CIS 188. Introduction to Wireless Networking. 4 Credits.

Introduces wireless networking theory and its practical application. Explores a variety of current and emerging wireless Local, Metropolitan, and Wide Area Networking technologies. Topics may include: WiFi (802.11a/b/g/n), Bluetooth, WiMAX (802.16), 3G Cellular, and others. Includes hands-on design of wireless networks and the configuration of wireless Access Points. Prerequisite: CIS 179, or instructor permission. Audit available.

CIS 189. Wireless Security. 4 Credits.

Introduces wireless security intrusion, policies, tools, and solutions. Prerequisite: CIS 179 or instructor permission. Recommended: CIS 188. Audit available.

CIS 195P. PHP Web Development I. 4 Credits.

Introduces student to the server-side scripting language, PHP, and its use in the development of Web sites. Topics include web server, PHP and MySQL database installation, scripting, techniques, database manipulation, user authentication, tracking and session management and e-Commerce techniques. Recommend: Completion of CIS 122 and CAS 213 or CIS 233S or equivalent experience; concurrent enrollment in CAS 206 and CIS 178 or equivalent experience. Audit available.

CIS 225. End User Support. 4 Credits.

Prepares computer professional for providing training and support to end users. Includes the roles and responsibilities of the end-user support person; characteristics of the adult learner; and strategies and techniques for developing instruction, teaching technical subject matter and providing ongoing technical support. Recommended: CIS 120, WR 227, and three additional CIS courses or instructor permission. Additional lab hours may be required. Audit available.

CIS 233B. Intermediate Visual Basic.NET Programming. 4 Credits.

Utilizes Visual Basic.NET to access streams and relational databases. Includes how to follow UML diagrams to create objects, arrays and collections that solve advanced, real world, business oriented problems. Introduces building an interactive web page using ASP.NET. Includes writing test plans to evaluate software quality. Continues use of object oriented design techniques. Prerequisites: CIS 133B. Prerequisite/concurrent. CIS 275 or instructor permission. Audit available.

CIS 233J. Java Programming II. 4 Credits.

Covers the use of Java to access databases and files including XML. Includes creating collections and arrays and using inheritance in Java programs. Prerequisites: CIS 133J. Prerequisites/concurrent: CIS 275. Audit available.

CIS 233S. Internet Web Page Scripting. 4 Credits.

Provides the foundation to build real-world, browser independent, web applications using client-side technologies including HTML, DHTML, Cascading Stylesheets and Javascript. Although the primary focus is on W3C Standards, Internet Explorer and Netscape specific extensions are discussed. A functioning website is built using the content presented in the course. Recommended: Proficiency in a modern programming language (CIS 133B, CIS 133J or CS 161); or instructor permission. Audit available.

CIS 234B. Advanced Visual Basic.NET Programming. 4 Credits.

Continues the Visual Basic.NET Programming sequence utilizing relational database access, multiple document interface and software objects and classes. Structured design techniques emphasized throughout. Recommended: CIS 233B, CIS 275; or instructor permission. Audit available.

CIS 234J. Java Programming III. 4 Credits.

Learn to use Java/J2EE to build scalable n-tiered web applications. Covers servlets, JSP, JDBC database connectivity, Enterprise JavaBeans, and SOAP Web Services Technologies. Learn advanced Apache Tomcat web server configuration including how to secure web resources, authenticate users and mask URLs. Recommended: CIS 233J or instructor permission. Audit available.

CIS 234N. C# Programming. 4 Credits.

Presents an accelerated introduction to object-oriented programming in C# focusing on language features supported by .NET frameworks using the Visual Studio IDE and NUnit. Includes design, code and test projects involving namespaces; simple, abstract anonymous and partial classes; structures, enums and interfaces; delegates and events; exceptions; class, instance and anonymous methods, properties and indexers; LINQ, streams, generic collections, ADO databases, timers, and multithreading. Recommended: Experience with UML class diagrams, object-oriented concepts and a two-course sequence (or proficiency) in an object-oriented programming language. Audit available.

CIS 234S. Web Application Development Using.NET. 4 Credits.

Provides the necessary knowledge to create real-world web applications using server-side technologies, including ASP.NET, VB.NET, and database access with ADO.NET. Although the primary focus is on the concepts, a business web-site is developed utilizing the presented material. Recommended: CIS 233S. Audit available.

CIS 240L. Linux Installation and Configuration. 4 Credits.

Introduces the administration of systems utilizing the Linux operating system. Focuses on knowledge and skills necessary for day-to-day operations on a Linux system using the command line. This is the first course of a two course sequence. Prerequisite: CS 140U or instructor permission. Audit available.

CIS 240M. Managing a Windows Server Environment. 4 Credits.

The first of a three-term sequence designed to prepare students for an entry-level position as a system administrator of a network utilizing Microsoft's Windows operating systems. The course focuses on the knowledge and skills necessary to design, install, configure and manage a workgroup or domain consisting of Microsoft Windows servers and workstations. Recommended: CIS 140M. Audit available.

CIS 243. E-ssentials of E-Commerce Information Systems. 4 Credits.

Encompasses the multi-faceted aspects of e-commerce information systems. Combines study of network, database and programming concepts with hands on skills. Provides a framework for the analysis of information system based e-commerce solutions to issues surrounding B2B, B2C, and intra-organizational trade. Provides a solid background in critical issues and technologies related to e-commerce. Recommended: CIS 120 and one programming class or instructor permission. Audit available.

CIS 244. Systems Analysis. 4 Credits.

Provides overview of the system development life cycle (SDLC) emphasizing analytical techniques to develop the correct definition of business problems and user requirements. Students will prepare a feasibility assessment and develop system requirements for an assigned project. Recommended: One class in a high-level programming language and WR 227. One 200-level business administration course. Additional lab hours may be required. Audit available.

CIS 245. Project Management - Information Systems. 4 Credits.

Study practical approaches for managing, planning, organizing and implementing Information Systems projects using modern management techniques. Complete hands-on projects requiring management of project resources, scope, time-line, cost, scheduling, human and other resources. Use Microsoft Project and other project monitoring tools. This course is one of the Project Management series that includes CAS 220, MSD 279, and BA 255. Project management is a broad term that can include many areas of business. Recommend: CIS 122, MSD 279, and CAS 220. Audit available.

CIS 246. Structured Systems Design. 4 Credits.

Provides overview of the system development life cycle (SDLC), emphasizing analytical techniques to develop a project from a previously prepared requirements document through a structured design to a final implementation. Students will prepare a formal design statement and implement the project in a computer language of their choice. Recommended: Two classes in a high-level programming language, CIS 233S, CIS 244 and CIS 275 or instructor permission. Audit available.

CIS 275. Data Modeling and SQL Introduction. 4 Credits.

Introduces the design, uses, and terminology of a database management system. Includes data modeling using Entity Relationship modeling tools and Semantic Object modeling tools, normalization rules, relational database terminology, program/query development, multi-user database issues (including the Internet) and data administration. Recommended: CIS 122. One high-level programming language course (CIS 133B, CIS 133J, CS 161) or equivalent or instructor permission. Audit available.

CIS 276. Advanced SQL. 4 Credits.

Focuses on design, development and implementation of SQL programming for all types of relational database applications including client/server and Internet databases. Learn to write complicated interactive and embedded SQL statement and learn the implications of multi-user database applications. Recommended: CIS 275; two-term programming language sequence; or instructor permission. Audit available.

CIS 277D. Database Security. 4 Credits.

Covers all aspects of securing a database. Uses Oracle database security to explain concepts in an relational database. Topics covered include: the importance of a database policy, identification and authorization methods (including web applications), securing connection pools and proxy authorization, identity management and enterprise users, authorizations and auditing, fine-grained access control (including application contexts security, views, row -level security, virtual private database, Oracle label security and database encryption). Recommended: CIS 276. Additional lab hours may be required. Audit available.

CIS 277H. Health Informatics Environment Simulation. 4 Credits.

Develop career objectives by solving projects in a simulated Health Informatics environment. Projects may include, but will not be limited to the following topics: data mining, work flow analysis, user interface evaluation, and other database, networking and programming applications. An overview of the Health Informatics degree will be covered. Prerequisite: CIS 135T, CIS 140M and CIS 275. Audit available.

CIS 277O. Advanced Database Concepts in Oracle. 4 Credits.

Covers concepts with Oracle including PL/SQL programming concepts review. Includes design considerations for PL/SQL program units and packages. Advanced interface methods, features for PL/SQL, performance and tuning, and advanced features of Oracle supplied packages also covered. Recommended: CIS 276. Audit available.

CIS 277T. Web Business Intelligence Application Development. 4 Credits.

Introduces fundamentals of Oracle Application Express 3.0, Web Application Development and Business Intelligence reporting using the newest ANSI99 standard's features for SQL and DML. Covers fundamentals of Web Business Intelligence reporting and Web User Interface development. Recommend: CIS 276 or equivalent database experience. Audit available.

CIS 278. Data Communication Concepts II. 4 Credits.

Provides in-depth concepts of data communications, and networking. Explores network architectures, complex network designs and network hardware configuration. Includes a close look at network/telephone company interfaces. Includes configuring operating Cisco routers and other data communication equipment in order to build functional networks. Prerequisite: CIS 179, or instructor permission. Audit available.

CIS 279L. Linux Network Administration. 4 Credits.

Second of a two term sequence designed to prepare students for an entry-level position as a system administrator of a network utilizing the Linux network operating system. Covers networking, TCP/IP, DNS, DHCP, NFS and Samba . Prerequisite: CIS 240L or instructor permission. Audit available.

CIS 280D. Cooperative Education: Application Development. 1-4 Credit.

Develop career objectives by linking course work with off-campus learning experiences in computer information systems of the public/private sector organizations. Successful completion of 16 CIS course credit hours in CIS declared major with a letter grade of C or better, and instructor permission.

CIS 284. Network Security. 4 Credits.

Continues exploring the role of network administrator. Focuses on the knowledge and skills necessary to maintain system security and to install, configure and maintain a local area network with common internet applications. Emphasizes the use of Open Source software and CompTIA's Security+ content. Prerequisite: CIS 240M or CIS 279L or instructor permission. Audit available.

CIS 285. Security Tools. 4 Credits.

Prepares network administrators to apply information security concepts and Open Source applications to manage security in Windows and Linux/Unix information systems. Topics include analysis and management tools, firewalls and packet filters, port and vulnerability scanners, sniffers, intrusion detection, encryption, wireless and forensics. Recommended: CIS 284 Audit available.

CIS 286. Computer Forensics. 4 Credits.

Introduces computer security administrators to computer forensics. Includes setup and use of an investigator's laboratory, computer investigations using digital evidence controls, processing crime and incident scenes, performing data acquisition, computer forensic analysis, e-mail investigations, image file recovery, investigative report writing, and expert witness testimony. Includes maps to the IACIS certification. Prerequisite: CS 140U and either CIS 240L or CIS 240M, or instructor permission. Audit available.

CIS 287I. Web Server Administration. 4 Credits.

Provides aspiring systems administrators with the knowledge and skill sets to install, configure, implement, and manage a web server. A variety of operating systems will be explored. Course does not cover publishing Web page content. Recommended: CIS 278 and either CIS279M or CIS 279L. Audit available.

CIS 287M. Microsoft Server Security. 4 Credits.

Prepares IT security professionals working in medium to large computing environments to implement authorization and authentication strategies, use certificates and certificate authorities, use Encrypting File System, create secure baselines, use Software Update Services enhance data transmission security, wireless network security, perimeter security and secure remote access. The primary focus will be Windows Server with some client content. Maps to Microsoft certification exam. Prerequisite: CIS 240M or instructor permission. Audit available.

CIS 288M. Microsoft Network Administration. 4 Credits.

Second of a three-term sequence designed to prepare students for an entry-level position as a system administrator of a network utilizing Microsoft's network operating system. Focuses on the knowledge and skills necessary to design, install, configure, and administer a network infrastructure that uses Microsoft Windows Server products. Recommended: CIS 240M or instructor permission. CIS 289M may be taken concurrently. Audit available.

CIS 289M. Microsoft Active Directory Administration. 4 Credits.

Third of a three-term sequence designed to prepare students for an entry-level position as a system administrator of a network utilizing Microsoft's network operating system. Focuses on the knowledge and skills necessary to design, install, configure, and administer an enterprise network using Microsoft Windows Active Directory. Also focuses on implementing Group Policies and understanding Group Policy tasks required to centrally manage users and computers. Recommended: CIS 240M, or instructor permission. CIS 288M may be taken concurrently. Audit available.

CIS 295P. PHP Web Development II. 4 Credits.

Introduces the advanced capabilities and features of PHP for Web site development. Topics include using the object- oriented features of PHP, developing applications for security and portability, advanced features of MySQL, creating efficient applications by implementing business logic within the database itself using stored procedures and triggers. Recommend: Completion of CIS 195P and CIS 125D or equivalent experience; concurrent enrollment in CIS 275 or equivalent experience. Audit available.