Computer & Network Systems Administration Schedule & Curriculum
MODEL SCHEDULE FOR COMPUTER & NETWORK SYSTEMS ADMINISTRATION (OPTION #1)
SEMESTER 1
CNSA 107 PC Hardware and Support Fundamentals 3
CNSA 111 Intro to Networking 3
CNSA 117 Analysis of TCP/IP & Local Area Networking 3
CNSA 123 LAN Cabling and WAN Technologies 3
ENG 106 English Composition 3
MATH 137 Intermediate Algebra 3
SEMESTER 2
CNSA 156 Operating Systems I 3
CNSA 161 Systems Administration I 3
CNSA 166 Internetworking Devices andConcepts 3
CNSA 172 Web Technologies and Network
Security Fund 3
MATH 141 Trigonometry 3
ENG 216 Technical Report Writing 3
SEMESTER 3
CNSA 212 Programming I 3
CNSA 222 Database Management Systems 3
CNSA 227 Management Information Systems 3
CNSA 256 Operating Systems II 3
ELECTIVE General Elective 3
ENG 221 Public Speaking 3
SEMESTER 4
CNSA 216 Web Programming 3
CNSA 266 Systems Administration II 3
CNSA 271 Network Design 3
CNSA 276 Practical Applications 3
SCIENCE Elective 3
HUMANITIES Elective 3
ADDITIONAL GENERAL EDUCATION REQUIREMENTS
HEAL Elective HEAL 106 or HEAL 111 1
TOTAL CREDITS 73
Click here to download PDF version of Computer & Network Systems Administration Curriculum
COMPUTER & NETWORK SYSTEMS ADMINISTRATION (OPTION #2)
SEMESTER 1
CNSA 107 PC Hardware and SupportFundamentals 3
CNSA 111 Intro to Networking 3
CNSA 117 Analysis of TCP/IP & Local Area Networking 3
CNSA 123 LAN Cabling and WAN Technologies 3
ENG 106 English Composition 3
Math 207 Pre-Calculus 4
SEMESTER 2
CNSA 156 Operating Systems I 3
CNSA 161 Systems Administration I 3
CNSA 166 Internetworking Devices and Concepts 3
CNSA 172 Web Technologies and
Network Security Fund 3
ENG 216 Technical Report Writing 3
SEMESTER 3
CNSA 212 Programming I 3
CNSA 222 Database Management Systems 3
CNSA 227 Management Information Systems 3
CNSA 256 Operating Systems II 3
ENG 221 Public Speaking 3
SEMESTER 4
CNSA 216 Web Programming 3
CNSA 266 Systems Administration II 3
CNSA 271 Network Design 3
CNSA 276 Practical Applications 3
PHYS 106 Physics in Everyday life (or Higher) 3
HUMANITIES Elective 3
ADDITIONAL GENERAL EDUCATION REQUIREMENTS
ELECTIVE General Elective 3
HEAL Elective HEAL 106 or HEAL 111 1
TOTAL CREDITS 74
CNSA 107 (3 Credits)
PC Hardware and Support Fundamentals
This course is focused on the internal components and operation of digital devices with emphasis on desktop PC systems used for business. Processors, memory, hard drives, SSDs, communication buses, and other components are covered. Electricity fundamentals and the binary numbering system are also a part of this course. Students build a computer from scratch in the lab.
CNSA 111 (3 Credits)
Introduction to Networking
Provides an overview of modern networking arrangements and goes into detail about the digitization of analog signals, the OSI model, the Ethernet protocol, and Ethernet switching. IP addresses and IP sub-netting are also covered in depth.
Prerequisite: CNSA 107
CNSA 117 (3 Credits)
Analysis of TCP/IP and Local Area Networking
The TCP/IP protocol suite is explored in detail. Topics include ARP, ICMP, DNS, DHCP, IPv4, IPv6, and TCP operation details such as sequencing, acknowledgments, and sliding window flow control. After lecture is complete, students spend lab time capturing frames with a software protocol analyzer and verifying the behaviors they learned about in lecture. Wireless networking (WiFi) is also a part of this course.
Prerequisite: CNSA 111
CNSA 123 (3 Credits)
LAN Cabling and WAN Technologies
Telecommunications Technologies for Wide Area Networking
Cabling standards and best cabling practices in the industry are covered. Students practice hands-on cable termination of copper and fiber cables in the lab. This course also provides an overview of telecommunications technologies and the use of telecommunications in wide area networks (WANs). Students have the opportunity to earn Tyco Electronics certified premises cabling installation certification.
Prerequisite: CNSA 117
CNSA 156 (3 Credits)
Operating Systems I
Microsoft’s server operating systems are a dominant network operating system in the information technology industry. In this course, along with CNSA 161, students get
Prerequisite: CNSA 123
CNSA 161 (3 Credits)
Systems Administration I
This course continues where CNSA 156 leaves off. In this course, students learn about Microsoft’s Active Directory structure and management. User account maintenance, user profiles,
CNSA 166 (3 Credits)
Internetworking Devices and Concepts
This is a Cisco-centric course on IP routing and switching. Traditional routers and L3 switches are discussed in the classroom and used in the lab. Routing protocols such as RIPv2, EIGRP, and OSPF are covered. In addition to routing, voice-over IP (VoIP) is a significant technology that businesses implement in order to reduce cost and leverage investments in the data network. For that reason, this course provides an overview of VoIP and assigns a lab project to configure a software private branch exchange (PBX) telephone switch that is capable of routing phone calls within the lab environment.
Prerequisite: CNSA 161
CNSA 172 (3 Credits)
Web Technologies and Network Security Fundamentals
Students learn how to configure a web server that can host multiple websites. The course then moves into the creation of web pages from scratch using HTML, CSS, and a text editor. Since security has become an increasingly important issue in our times, some of the security measures that are commonly used on the Internet are included in this course. These security measures include an overview of threats and defense strategies, the public key infrastructure (PKI), digital certificates, hash codes, and digital signatures.
Prerequisite: CNSA 166
CNSA 212 (3 Credits)
Programming I
An introduction to the fundamentals of computer programming. Students learn a structured, object-oriented approach to
Prerequisites: CNSA 156 and CNSA 161
CNSA 216 (3 Credits)
Web Programming
A course that builds upon the information learned in CNSA 172, CNSA 212, CNSA 222, it introduces advanced web programming and development techniques and tools. The primary focus of the course is on the design of dynamic, interactive websites, using current web programming languages and tools, including the technology of the Microsoft .NET Framework. Students integrate the use of relational databases to provide data storage and retrieval for their interactive websites. Students also configure and manage web servers to support interactive web pages. Prerequisites: CNSA 172, CNSA 212, and CNSA 222
CNSA 222 (3 Credits)
Database Management Systems
An in-depth, hands-on survey course in which students develop the skills and the expertise required to design, implement, and manage databases using a relational database management system (RDBMS). Students learn concepts of the relational database model, the principles of database design and normalization, and database administration. In addition, the basic commands and functions of
Prerequisite: CNSA sophomore standing
CNSA 227 (3 Credits)
Management Information Systems
A course that introduces students to the policies and procedures required to administer an enterprise computer network and to support an effective information technology department and users in the enterprise. Students learn how to prepare and maintain documentation for information technology systems, software, processes, and projects. The skills learned in this course are integrated into the other CNSA courses throughout the sophomore year. An important component of the course is research, readings, and discussion related to ethical practices in the field of information technology.
Prerequisite: CNSA sophomore standing
CNSA 256 (3 Credits)
Operating Systems II
The second operating systems course in the CNSA curriculum that introduces students to the design, functionality, and administration of the predominant non-Windows operating system in the current computer industry. At this particular time, the course presents an in-depth examination of Linux, focusing on the proper installation and administration of the operating system. Students explore the wealth of support sites available to administrators of Linux systems, as well as the availability of productivity software applications and system administration tools for Linux systems.
Prerequisite: CNSA 156
CNSA 266 (3 Credits)
Systems Administration II
Students will also learn to implement dynamic
Prerequisite: CNSA 161, CNSA 256
CNSA 271 (3 Credits)
Network Design
This is the first of two capstone courses in the CNSA curriculum that requires students to rely heavily upon the knowledge and skills acquired from their entire previous course experiences. Project teams manage all accounts (i.e., user, group, computer, security) in their respective domains. In designing their enterprise domains, the teams conduct appropriate research, analyze and evaluate enterprise requirements and specifications, and document the network design. Knowledge of the fundamentals of networking technology, experience supporting a network, or successful completion of a networking essentials course is required.
Prerequisite: CNSA 266
CNSA 276 (3 Credits)
Practical Applications
The second of two capstone courses in the CNSA curriculum that requires students to rely heavily upon the knowledge and skills acquired from their entire previous CNSA course experiences. This course also includes in-depth research and examination of selected network applications and the implementation of those applications in the enterprise. Students learn how to plan, configure, and administer the specified application(s), implement the application(s), document the installation(s), and train the appropriate users to use and administer the application(s).
Prerequisites: CNSA 266 and CNSA 271