Information Technology, Associate in Applied Science
This is an archived copy of the 2022-2023 catalog. To access the most recent version of the catalog, please visit https://catalog.cgc.edu.
Associate in Applied Science: AAS 3196
61-68 Credits
Program Contacts
Scott Miller | 480-857-5536 | scott.miller@cgc.edu
Program Description
The Associate in Applied Science (AAS) in Information Technology (IT) program is designed to provide students with skills to meet information technology needs across industries. This program includes instruction in the principles of computer hardware components and business software, programming, databases, networking, customer service, web development, and information systems and project management. Coursework helps prepare students for a variety of industry-recognized examinations and certifications. Students will earn one or more of the following Certificates of Completion (CCLs):
- CCL/5154 Cybersecurity Fundamentals
- CCL/5083 Database Development
- CCL/5043 Desktop Support
- CCL/5793 Foundations of Mobile App Development
- CCL/5132 Microsoft Office Professional
- CCL/5031 Microsoft System Administration
- CCL/5048 Programming and Systems Analysis Level I
- CCL/5183N Oracle Database Operations
- CCL/5050N Red Hat Linux Engineer
- CCL/5984 Web Foundations
Program Notes
CCL 5183N, and 5050N are not eligible for Title IV Federal Financial Aid.
Students must earn a grade of “C” or better in all courses required within the program. Overall program minimum GPA = 2.00.
Courses within any of the following prefixes must be taken within five (5) years prior to completion of the program to be applied toward this award: AIM, BPC, CIS, CLD, CNT, CSC, ITS, and MST.
++ indicates any suffixed course may be selected.
Program Requirements
Program Prerequisites: None
Required Courses: 33-41 Credits
Complete all courses in the specialization below that best aligns with your academic and professional goals. Consult with an academic, faculty, or program advisor.
Code | Title | Credits |
---|---|---|
FYE101 | Introduction to College, Career and Personal Success | 1-3 |
or FYE103 | Exploration of College, Career and Personal Success |
Specialization 1: Cybersecurity Fundamentals
Credits: 33-38
Code | Title | Credits |
---|---|---|
Information Technology Core | ||
Select one of the following: | 3 | |
A+ Exam Prep: Operating System Configuration and Support | ||
MST150++ | Any Microsoft Windows course | |
CIS105 | Survey of Computer Information Systems | 3 |
Select one of the following: | 3 | |
Microsoft Access: Database Management | ||
Introduction to Oracle: SQL | ||
MySQL Database | ||
SQL Server Database | ||
CIS126DL | Linux Operating System | 3 |
or CIS126RH | Red Hat System Administration I | |
CIS133DA | Internet/Web Development Level I | 3 |
CIS156 | Python Programming: Level I | 3 |
CIS190 | Introduction to Networking | 3-4 |
or CNT140AB | Introduction to Networks | |
Select one of the following: | 3 | |
Project Management Microsoft Project for Windows | ||
Management of Information Systems 1 | ||
Cybersecurity Fundamentals | ||
CIS111 | Ethics in Information Technology | 3 |
or ITS120 | Legal, Ethical and Regulatory Issues | |
CIS270 | Essentials of Network and Information Security | 3-6 |
or CIS271DB & CIS272DB | Information Security Essentials and Information Security Principles | |
or ITS110 | Information Security Fundamentals | |
ITS240 | Ethical Hacking and Network Defense | 3 |
Related Area Credits | ||
Select courses with one of the following prefixes to complete a minimum of 60 credits for the Associate in Applied Science (AAS) in Information Technology: | 0-5 | |
BPC+++++ | Any BPC Business-Personal Computers courses | |
CIS+++++ | Any CIS Computer Information Systems courses | |
CLD+++++ | Any CLD Cloud Computing courses | |
CNT+++++ | Any CNT Cisco Network Technology courses | |
ITS+++++ | Any ITS Information Technology Security courses | |
MST+++++ | Any MST Microsoft Technology courses |
- 1
Students taking CIS271DB Information Security Essentials would be required to take CIS250 Management of Information Systems.
Specialization 2: Database Development
Credits: 36-38
Code | Title | Credits |
---|---|---|
Information Technology Core | ||
Select one of the following: | 3 | |
A+ Exam Prep: Operating System Configuration and Support | ||
Linux Operating System | ||
Red Hat System Administration I | ||
MST150++ | Microsoft Windows | |
CIS105 | Survey of Computer Information Systems | 3 |
CIS119DO | Introduction to Oracle: SQL | 3 |
CIS133DA | Internet/Web Development Level I | 3 |
Select one of the following: | 3 | |
Python Programming: Level I | ||
CIS162++ | Any C Programming: Level I course | |
Java Programming: Level I | ||
CIS190 | Introduction to Networking | 3-4 |
or CNT140AB | Introduction to Networks | |
CIS224 | Project Management Microsoft Project for Windows | 3 |
or CIS250 | Management of Information Systems | |
Database Development | ||
CIS117DM | Microsoft Access: Database Management | 3 |
or CIS154 | Database Modeling and Design | |
CIS150++ | Programming Fundamentals | 3 |
Select one of the following: | 3 | |
Oracle: PL/SQL Programming | ||
MySQL Database | ||
SQL Server Database | ||
CIS217AM | Advanced Microsoft Access: Database Management | 3 |
or CIS276DB | SQL Server Database | |
CIS225AB | Object-Oriented Analysis and Design | 3 |
Related Area Credits | ||
Select courses with one of the following prefixes to complete a minimum of 60 credits for the Associate in Applied Science (AAS) in Information Technology: | 0-2 | |
BPC+++++ | Any BPC Business-Personal Computers courses | |
CIS+++++ | Any CIS Computer Information Systems courses | |
CLD+++++ | Any CLD Cloud Computing courses | |
CNT+++++ | Any CNT Cisco Network Technology courses | |
ITS+++++ | Any ITS Information Technology Security courses | |
MST+++++ | Any MST Microsoft Technology courses |
Specialization 3: Desktop Support
Credits: 32-38
Code | Title | Credits |
---|---|---|
Information Technology Core | ||
BPC270 | A+ Exam Prep: Operating System Configuration and Support | 3 |
CIS105 | Survey of Computer Information Systems | 3 |
Select one of the following: | 3 | |
Microsoft Access: Database Management | ||
Introduction to Oracle: SQL | ||
MySQL Database | ||
SQL Server Database | ||
CIS126DL | Linux Operating System | 3 |
or CIS126RH | Red Hat System Administration I | |
CIS133DA | Internet/Web Development Level I | 3 |
Select one of the following: | 3 | |
Object-Oriented Programming Fundamentals | ||
Python Programming: Level I | ||
CIS162++ | Any C Programming: Level I course | |
Java Programming: Level I | ||
CIS190 | Introduction to Networking | 3-4 |
or CNT140AB | Introduction to Networks | |
CIS224 | Project Management Microsoft Project for Windows | 3 |
or CIS250 | Management of Information Systems | |
Desktop Support | ||
BPC170 | A+ Exam Prep: Computer Hardware Configuration and Support | 3 |
CIS102DA | Customer User Support | 3 |
Related Area Credits | ||
Select courses with one of the following prefixes to complete a minimum of 60 credits for the Associate in Applied Science (AAS) in Information Technology: | 2-8 | |
BPC+++++ | Any BPC Business-Personal Computers courses | |
CIS+++++ | Any CIS Computer Information Systems courses | |
CLD+++++ | Any CLD Cloud Computing courses | |
CNT+++++ | Any CNT Cisco Network Technology courses | |
ITS+++++ | Any ITS Information Technology Security courses | |
MST+++++ | Any MST Microsoft Technology courses |
Specialization 4: Foundations of Mobile App Development
Credits: 33-38
Code | Title | Credits |
---|---|---|
Information Technology Core | ||
CIS105 | Survey of Computer Information Systems | 3 |
Select one of the following: | 3 | |
A+ Exam Prep: Operating System Configuration and Support | ||
Linux Operating System | ||
Red Hat System Administration I | ||
MST150++ | Microsoft Windows | |
Select one of the following: | 3 | |
Microsoft Access: Database Management | ||
Introduction to Oracle: SQL | ||
MySQL Database | ||
SQL Server Database | ||
CIS133DA | Internet/Web Development Level I | 3 |
CIS162++ | Any C Programming: Level I course | 3 |
CIS190 | Introduction to Networking | 3-4 |
or CNT140AB | Introduction to Networks | |
CIS224 | Project Management Microsoft Project for Windows | 3 |
or CIS250 | Management of Information Systems | |
Foundations of Mobile App Development | ||
CIS120DF | Introduction to Adobe Photoshop | 3 |
CIS165 | Introduction to IOS Application Development | 3 |
CIS165DA | Introduction to Android Application Development | 3 |
CIS165DB | C#/VB.NET: Windows 8 App Development | 3 |
or CIS165DC | Xamarin/C# Cross-Platform Development | |
Related Area Credits | ||
Select courses with one of the following prefixes to complete a minimum of 60 credits for the Associate in Applied Science (AAS) in Information Technology: | 0-5 | |
BPC+++++ | Any BPC Business-Personal Computers courses | |
CIS+++++ | Any CIS Computer Information Systems courses | |
CLD+++++ | Any CLD Cloud Computing courses | |
CNT+++++ | Any CNT Cisco Network Technology courses | |
ITS+++++ | Any ITS Information Technology Security courses | |
MST+++++ | Any MST Microsoft Technology courses |
Specialization 5: Microsoft Office Professional
Credits: 31-38
Code | Title | Credits |
---|---|---|
Information Technology Core | ||
CIS105 | Survey of Computer Information Systems | 3 |
CIS117DM | Microsoft Access: Database Management | 3 |
CIS133DA | Internet/Web Development Level I | 3 |
Select one of the following: | 3 | |
Object-Oriented Programming Fundamentals | ||
Python Programming: Level I | ||
CIS162++ | Any C Programming: Level I course | |
Java Programming: Level I | ||
CIS190 | Introduction to Networking | 3-4 |
or CNT140AB | Introduction to Networks | |
Select one of the following: | 3 | |
MST150++ | Microsoft Windows | |
A+ Exam Prep: Operating System Configuration and Support | ||
Microsoft Office Professional | ||
Select one of the following: | 0-1 | |
Computer Keyboarding I | ||
or Permission from Program Director | ||
CIS113DE | Microsoft Word: Word Processing | 3 |
CIS114DE | Excel Spreadsheet | 3 |
CIS118DB | Desktop Presentation: PowerPoint | 3 |
CIS124AA & CIS124BA | Project Management Software: Level I and Project Management Software: Level II | 2-3 |
or CIS224 | Project Management Microsoft Project for Windows | |
Related Area Credits | ||
Select courses with one of the following prefixes to complete a minimum of 60 credits for the Associate in Applied Science (AAS) in Information Technology: | 0-8 | |
BPC+++++ | Any BPC Business-Personal Computers courses | |
CIS+++++ | Any CIS Computer Information Systems courses | |
CLD+++++ | Any CLD Cloud Computing courses | |
CNT+++++ | Any CNT Cisco Network Technology courses | |
ITS+++++ | Any ITS Information Technology Security courses | |
MST+++++ | Any MST Microsoft Technology courses |
Specialization 6: Microsoft Server
Credits: 36-38
Code | Title | Credits |
---|---|---|
Information Technology Core | ||
CIS105 | Survey of Computer Information Systems | 3 |
Select one of the following: | 3 | |
Microsoft Access: Database Management | ||
Introduction to Oracle: SQL | ||
MySQL Database | ||
SQL Server Database | ||
CIS133DA | Internet/Web Development Level I | 3 |
Select one of the following: | 3 | |
Object-Oriented Programming Fundamentals | ||
Python Programming: Level I | ||
CIS162++ | Any C Programming: Level I course | |
Java Programming: Level I | ||
CIS190 | Introduction to Networking | 3-4 |
or CNT140AB | Introduction to Networks | |
CIS224 | Project Management Microsoft Project for Windows | 3 |
or CIS250 | Management of Information Systems | |
MST150++ | Microsoft Windows | 3 |
Microsoft Server | ||
CIS121AH | Microsoft PowerShell/Command Line Operations | 3 |
MST155DC | Installation, Storage, and Compute with Windows Server | 4 |
MST157DC | Networking with Windows Server | 4 |
MST158DC | Identity Management with Windows Server 2016 | 4 |
Related Area Credits | ||
Select courses with one of the following prefixes to complete a minimum of 60 credits for the Associate in Applied Science (AAS) in Information Technology: | 0-2 | |
BPC+++++ | Any BPC Business-Personal Computers courses | |
CIS+++++ | Any CIS Computer Information Systems courses | |
CLD+++++ | Any CLD Cloud Computing courses | |
CNT+++++ | Any CNT Cisco Network Technology courses | |
ITS+++++ | Any ITS Information Technology Security courses | |
MST+++++ | Any MST Microsoft Technology courses |
Specialization 7: Oracle Database Operations
Credits: 32-38
Code | Title | Credits |
---|---|---|
Information Technology Core | ||
Select one of the following: | 3 | |
A+ Exam Prep: Operating System Configuration and Support | ||
Linux Operating System | ||
Red Hat System Administration I | ||
MST150++ | Microsoft Windows | |
CIS105 | Survey of Computer Information Systems | 3 |
CIS119DO | Introduction to Oracle: SQL | 3 |
CIS133DA | Internet/Web Development Level I | 3 |
Select one of the following: | 3 | |
Object-Oriented Programming Fundamentals | ||
Python Programming: Level I | ||
CIS162++ | Any C Programming: Level I course | |
Java Programming: Level I | ||
CIS190 | Introduction to Networking | 3-4 |
or CNT140AB | Introduction to Networks | |
CIS224 | Project Management Microsoft Project for Windows | 3 |
or CIS250 | Management of Information Systems | |
Oracle Database Operations | ||
CIS119DP | Oracle: Database Administration | 3 |
CIS154 | Database Modeling and Design | 3 |
CIS164AB | Oracle: PL/SQL Programming | 3 |
Related Area Credits | ||
Select courses with one of the following prefixes to complete a minimum of 60 credits for the Associate in Applied Science (AAS) in Information Technology: | 2-8 | |
BPC+++++ | Any BPC Business-Personal Computers courses | |
CIS+++++ | Any CIS Computer Information Systems courses | |
CLD+++++ | Any CLD Cloud Computing courses | |
CNT+++++ | Any CNT Cisco Network Technology courses | |
ITS+++++ | Any ITS Information Technology Security courses | |
MST+++++ | Any MST Microsoft Technology courses |
Specialization 8: Programming and Systems Analysis Level 1
Credits: 32-38
Code | Title | Credits |
---|---|---|
Information Technology Core | ||
CIS105 | Survey of Computer Information Systems | 3 |
Select one of the following: | 3 | |
Introduction to Oracle: SQL | ||
MySQL Database | ||
SQL Server Database | ||
Select one of the following: | 3 | |
Linux Operating System | ||
Red Hat System Administration I | ||
MST150++ | Microsoft Windows | |
CIS133DA | Internet/Web Development Level I | 3 |
CIS150AB | Object-Oriented Programming Fundamentals | 3 |
CIS190 | Introduction to Networking | 3-4 |
or CNT140AB | Introduction to Networks | |
CIS224 | Project Management Microsoft Project for Windows | 3 |
or CIS250 | Management of Information Systems | |
Programming and Systems Analysis | ||
Select one of the following: | 3 | |
Visual Basic Programming I | ||
CIS162++ | Any C Programming: Level I course | |
Java Programming: Level I | ||
CIS165++ | Any Mobile Application Development course | |
CIS166++ | Any Web Scripting course | 3 |
GBS151 | Introduction to Business | 3 |
Related Area Credits | ||
Select courses with one of the following prefixes to complete a minimum of 60 credits for the Associate in Applied Science (AAS) in Information Technology: | 1-8 | |
BPC+++++ | Any BPC Business-Personal Computers courses | |
CIS+++++ | Any CIS Computer Information Systems courses | |
CLD+++++ | Any CLD Cloud Computing courses | |
CNT+++++ | Any CNT Cisco Network Technology courses | |
ITS+++++ | Any ITS Information Technology Security courses | |
MST+++++ | Any MST Microsoft Technology courses |
Specialization 9: Redhat Linux Engineer
Credits: 32-38
Code | Title | Credits |
---|---|---|
Information Technology Core | ||
CIS105 | Survey of Computer Information Systems | 3 |
Select one of the following: | 3 | |
Microsoft Access: Database Management | ||
Introduction to Oracle: SQL | ||
MySQL Database | ||
SQL Server Database | ||
CIS126RH | Red Hat System Administration I | 3 |
CIS133DA | Internet/Web Development Level I | 3 |
Select one of the following: | 3 | |
Object-Oriented Programming Fundamentals | ||
Python Programming: Level I | ||
CIS162++ | Any C Programming: Level I course | |
Java Programming: Level I | ||
CIS190 | Introduction to Networking | 3-4 |
or CNT140AB | Introduction to Networks | |
CIS224 | Project Management Microsoft Project for Windows | 3 |
or CIS250 | Management of Information Systems | |
Redhat Linux Engineer | ||
CIS238RH | Red Hat System Administration II | 3 |
CIS240RH | Red Hat System Administration III | 3 |
Related Area Credits | ||
Select courses with one of the following prefixes to complete a minimum of 60 credits for the Associate in Applied Science (AAS) in Information Technology: | 5-11 | |
BPC+++++ | Any BPC Business-Personal Computers courses | |
CIS+++++ | Any CIS Computer Information Systems courses | |
CLD+++++ | Any CLD Cloud Computing courses | |
CNT+++++ | Any CNT Cisco Network Technology courses | |
ITS+++++ | Any ITS Information Technology Security courses | |
MST+++++ | Any MST Microsoft Technology courses |
Specialization 10: Web Foundations
Credits: 36-38
Code | Title | Credits |
---|---|---|
Information Technology Core | ||
Select one of the following: | 3 | |
A+ Exam Prep: Operating System Configuration and Support | ||
Linux Operating System | ||
Red Hat System Administration I | ||
MST150++ | Microsoft Windows | |
CIS105 | Survey of Computer Information Systems | 3 |
Select one of the following: | 3 | |
Microsoft Access: Database Management | ||
Introduction to Oracle: SQL | ||
MySQL Database | ||
SQL Server Database | ||
CIS133DA | Internet/Web Development Level I | 3 |
Select one of the following: | 3 | |
Object-Oriented Programming Fundamentals | ||
Python Programming: Level I | ||
CIS162++ | Any C Programming: Level I course | |
Java Programming: Level I | ||
CIS190 | Introduction to Networking | 3-4 |
or CNT140AB | Introduction to Networks | |
CIS224 | Project Management Microsoft Project for Windows | 3 |
or CIS250 | Management of Information Systems | |
Web Foundation | ||
CIS120DF | Introduction to Adobe Photoshop | 3 |
CIS136 | Content Management Systems: WordPress | 3 |
CIS166AA | Introduction to Javascript | 3 |
CIS233DA | Internet/Web Development Level II | 3 |
CIS235 | E-Commerce | 3 |
Related Area Credits | ||
Select courses with one of the following prefixes to complete a minimum of 60 credits for the Associate in Applied Science (AAS) in Information Technology: | 0-2 | |
BPC+++++ | Any BPC Business-Personal Computers courses | |
CIS+++++ | Any CIS Computer Information Systems courses | |
CLD+++++ | Any CLD Cloud Computing courses | |
CNT+++++ | Any CNT Cisco Network Technology courses | |
ITS+++++ | Any ITS Information Technology Security courses | |
MST+++++ | Any MST Microsoft Technology courses |
Specialization 11: A Related Certificate of Completion (CCL) At the Discretion of the Program Director
Credits: 32-33
A related Certificate of Completion (CCL) at the discretion of the Program Director (minimum of 11 credits) AND the following core courses with permission of the Program Director.
Code | Title | Credits |
---|---|---|
Information Technology Core | ||
CIS105 | Survey of Computer Information Systems | 3 |
Select one of the following: | 3 | |
Microsoft Access: Database Management | ||
Introduction to Oracle: SQL | ||
MySQL Database | ||
SQL Server Database | ||
Select one of the following: | 3 | |
A+ Exam Prep: Operating System Configuration and Support | ||
Linux Operating System | ||
Red Hat System Administration I | ||
MST150++ | Microsoft Windows | |
Select one of the following: | 3 | |
Object-Oriented Programming Fundamentals | ||
Python Programming: Level I | ||
CIS162++ | Any C Programming: Level I course | |
Java Programming: Level I | ||
CIS190 | Introduction to Networking | 3-4 |
or CNT140AB | Introduction to Networks | |
CIS133DA | Internet/Web Development Level I | 3 |
CIS224 | Project Management Microsoft Project for Windows | 3 |
or CIS250 | Management of Information Systems |
General Education
Code | Title | Credits |
---|---|---|
General Education | ||
Core | ||
First-Year Composition | ||
ENG101 | First-Year Composition | 3 |
or ENG107 | First-Year Composition for ESL | |
ENG102 | First-Year Composition | 3 |
or ENG108 | First-Year Composition for ESL | |
Oral Communication | ||
Select one of the following: | 3 | |
Introduction to Human Communication | ||
Interpersonal Communication | ||
Public Speaking | ||
Small Group Communication | ||
Critical Reading | ||
Select one of the following: | 0-3 | |
College Critical Reading and Critical Thinking | ||
Or equivalent as indicated by assessment | ||
Mathematics | ||
Select one of the following: | 3-6 | |
College Mathematics | ||
College Mathematics | ||
College Mathematics | ||
College Mathematics with Review | ||
College Mathematics with Review | ||
Equivalent or higher level mathematics course in the Mathematical Applications (MA) area | ||
Distribution | ||
Humanities, Arts and Design | ||
Any approved general education course(s) from the Humanities, Arts and Design (HU) area | 3 | |
Social and Behavioral Sciences | ||
Any approved general education course from the Social and Behavioral Sciences (SB) area | 3 | |
Natural Sciences | ||
Any approved general education course from the Natural Science (SG) or (SQ) area | 4 | |
Total Credits | 22-28 |