| Computer Science |
|
| Cis 111 Computers and Applications |
|
| Lecture: 3 hrs. Credit: 3 hrs. |
|
| An introduction to the terminology and concepts associated with personal computer technology. Computer systems, hardware, software and applications which focus around the personal computer (PC) will be discussed. Hands-on assignments introducing students to computer concepts such as file management, word processing, spreadsheets, databases, slideshows, e-mail, searching the Internet, ftp file transfer, and building and deploying a webpage are included in the course. Taught in a lab setting. |
|
| Cis 119 Spreadsheets |
|
| Lecture: 3 hrs. Credit: 1 hrs. |
|
| An introduction to spreadsheets on the personal computer designed for business majors. Spreadsheet creation, modification, printing, graphing and preparing what-if scenarios are discussed in detail. This course utilizes Microsoft Excel software. Not open to students who have completed or are planning to take CIS 125. Prerequisite: Familiarity with using a PC, keyboard and mouse, and file management (creating folders and copying and pasting files into folders) in a Windows environment. |
|
| Cis 120 PC Hardware Fundamentals |
|
| Lecture: 2 hrs. Lab: 2 hrs. Credit: 3 hrs. |
|
| An introduction to the installation, maintenance, troubleshooting and repair of personal computer hardware. Topics include system hardware components, their functions and what to do when failure occurs; how to install and maintain PC operating systems. Students will apply what they learn in hands-on labs. This course is appropriate for persons working or planning to work in any technical or computer support position. This course closely follows the A+ curriculum for Microcomputer Hardware. Prerequisite: Familiarity with using a PC, keyboard and mouse in a Windows environment. |
|
| Cis 122 Intro to Internet Development |
|
| Lecture: 2 hrs. Lab: 2 hrs. Credit: 3 hrs. |
|
| A study of the techniques used in computer programming. Topics include an introduction to sequence, selection, iteration and subprogram structures, arrays, data validation and string processing. This course is open to anyone who desires a first course in Internet programming. The course is recommended for CS/IT majors who may not have the mathematics prerequisite to enter CIS 143 or who desire a gentler introduction to the programming process. The course will be taught using primarily JavaScript. Prerequisite: Any one of the following: CIS 111, CIS 119, CIS 125, or familiarity using a Windows-based PC and a text editing program (Notepad, WordPad, MS Word, WordPerfect, etc.) |
|
| Cis 123 PC Software Fundamentals |
|
| Lecture: 2 hrs. Lab: 2 hrs. Credit: 3 hrs. |
|
| An introduction to the installation and maintenance of personal computer software. Topics will include: PC operating systems, computer hardware interaction and related software installation and troubleshooting. The content closely mirrors the A+ curriculum for Microcomputer Software. Appropriate for persons working or planning to work in any technical or computer support position. Prerequisites: CIS 120. |
|
| Cis 125 Office Productivity Software |
|
| Lecture: 3 hrs. Credit: 3 hrs. |
|
| An introduction to office software in a Windows environment. Topics include: spreadsheet creation and modification including formulas, functions, graphing and "what-if" scenarios; database creation and modification including tables, queries, forms and reports; enhanced text presentations including graphics, charts, outlining, slide sorting and speaker notes. Taught in a lab setting. This course utilizes Microsoft Office software. Not open to students that have completed CIS 119. Prerequisite: Familiarity using a personal computer, keyboard and mouse, and file management (creating folders and copying and pasting files into folders) in a Windows environment. |
|
| Cis 126 Advanced PC Applications |
|
| Lecture: 3 hrs. Credit: 3 hrs. |
|
| This course focuses on advanced topics and commands not covered in CIS 125. The relational database Microsoft Access and spreadsheet Microsoft Excel will be studied in depth. Menu driven systems and disk organization will conclude the course. Three major projects are required. This course utilizes Microsoft Office software. Prerequisites: CIS 125. |
|
| Cis 129 Help Desk Fundamentals |
|
| Lecture: 3 hrs. Credit: 3 hrs. |
|
| An introduction to basic help desk concepts, procedures and practices. Students will use the knowledge acquired in CIS 120, CIS 123 and other courses in the curriculum to help customers define, troubleshoot and correct problems with PC hardware and software. They will learn how to deal with customers of varying levels of knowledge, temperament and skills through a laboratory component which includes role-playing scenarios. It is appropriate for a person working or planning to work as help desk or customer service representatives in any technical or computer support position where customer oriented skills are required. Prerequisites: CIS 120. |
|
| Cis 131 Introduction to Networking |
|
| Lecture: 3 hrs. Credit: 3 hrs. |
|
| A course where students will develop an understanding of networking as it applies to information processing. Topics include basic concepts and terminology, types of network hardware, operating system software, network administration, network applications and current trends in networking. Prerequisite: Familiarity using a personal computer, keyboard and mouse in a Windows environment or permission of instructor or Prerequisites: CIS 111. |
|
| Cis 133 Network Fundamentals (CCNA1) |
|
| Lecture: 3 hrs. Lab: 3 hrs. Credit: 4 hrs. |
|
| This course builds a theoretical foundation in describing and recognizing components and services supporting computer network communications and the Internet. Students are introduced to computer hardware and software, electronics and signaling, OSI and TCP/IP network models, topologies, standards and protocols. Instruction and hands-on experience are provided in the proper care, safety and maintenance of equipment, cabling, and tools. Students build small Ethernet network designs and configurations using routers, switches, and implementing IP address schemes. Particular attention is given to the use of decision-making and problem-solving techniques in applying technical and mathematical concepts to solve networking problems and analyzing data traffic. Pre/Corequisite: CIS 131 or permission of instructor. Prerequisites: CIS 131. |
|
| Cis 134 Routing Protocols & Concepts |
|
| Lecture: 3 hrs. Lab: 3 hrs. Credit: 4 hrs. |
|
| This course describes the architecture, components, and operation of routers, and explains the principles of routing and routing protocols. Students analyze, configure, secure, verify, and troubleshoot the primary routing protocols RIPvl, RIPv2, EIGRP, and OSPF. By the end of this course, students will be able to recognize and correct common routing issues and problems. Efficient IP address utilization using Variable Length Subnet Masking (VLSM) and private addressing are covered. Packet Tracer (PT) activities reinforce new concepts and allow students to model and analyze routing processes that may be difficult to visualize or understand. A multi-semester local industry case study begins with team building and decision-making techniques. Student teams evaluate, research, and design a campus LAN cabling and network infrastructure case study implementing user requirements and learned technologies. Each team will present a proposal. Prerequisite: CIS 133 or Cisco Certified Entry Level Technician (CCENT) certification or permission of instructor. Prerequisites: CIS 133. |
|
| Cis 137 LAN Switching and Wireless |
|
| Lecture: 3 hrs. Lab: 3 hrs. Credit: 2 hrs. |
|
| This course helps students develop an in-depth understanding of how switches and wireless technologies operate and are implemented in the LAN environment for small and large networks. Beginning with a foundational overview of Ethernet, this course provides detailed explanations of LAN switch operation, VLAN implementation, Rapid Spanning Tree Protocol (RSTP), VLAN Trunking Protocol (VTP), Inter-VLAN routing, and wireless WIFI Protected Access (WPA) network operations. Students develop practical experience in configuring, securing, and testing an inter-VLAN switched and wireless environment. Campus network design and Layer 3 switching concepts are introduced. Student teams analyze user requirements, design, and append to their CIS 134 case study LAN switching and wireless implementations. Each team will provide a written proposal. Prerequisites: CIS 134. |
|
| Cis 138 Accessing the WAN (CCNA4) |
|
| Lecture: 3 hrs. Lab: 3 hrs. Credit: 2 hrs. |
|
| This course explains the principles of traffic control and access control lists (ACLs) and provides an overview of the services and protocols for wide-area access. Students learn about user access technologies and devices and develop practical experience implementing and configuring Point-to-Point Protocol (PPP), PPP over Ethernet (PPoE), DSL, Frame Relay, ISDN, along with DHCP, DNS and Network/Port Address Translation (NAT/PAT). The course introduces special network services required by converged applications such as Voice over IP (VoIP), and introduction to quality of service (QoS), WAN security concepts, tunneling, and VPN basics. Student teams analyze user requirements, design, and append to their CIS 137 case study a WAN implementation. Each team will give a final presentation. Prerequisites: CIS 137. |
|
| Cis 143 Introduction to Programming |
|
| Lecture: 2 hrs. Lab: 2 hrs. Credit: 3 hrs. |
|
| An introduction to programming techniques and methods. Computer programming is used to explore simple data types, control structures and numerical computation. Other topics include hardware, software, files, testing and debugging. Stylistic concerns such as naming conventions, code layout and documentation are emphasized. BITM Majors only, prerequisite: Mat 127. Prerequisites: Regents Math B with a Score of 070 or MAT 108 or MAT 119 or MAT 123 or MAT 129 or MAT 131 or MAT 132 or MAT 231 or MAT 232. |
|
| Cis 144 Inter Programming in Windows |
|
| Lecture: 2 hrs. Lab: 2 hrs. Credit: 3 hrs. |
|
| A continuation of programming techniques and methods in a visual context. Topics will include user interface design, arrays, structs, class objects, searching and soring as approached from an object-oriented perspective in a windows environment. Other topics include recursion and problem-solving strategies. Prerequisites: CIS 143 with a Grade of C or better. |
|
| Cis 150 Topics in Computing |
|
| Lecture: 3 hrs. Credit: 3 hrs. |
|
| An overview of many of the important areas in the field of Computer combined with an introduction to office productivity applications, such as spreadsheets and databases. Topics include the history of computing, data representation, computer organization and architecture, algorithm analysis, logic circuits, finite state machines, public key encryption and an overview of the Linux operating system. Hands-on computer assignments will utilize spreadsheets, databases, HTML, C++, PHP, and Linux. Prerequisites: CIS 143. |
|
| Cis 151 Server Side Scripting |
|
| Lecture: 3 hrs. Credit: 3 hrs. |
|
| A study of the techniques used in creating dynamic database driven web pages for e-commerce and other web applications utilizing PHP and MySQL. The course introduces the PHP framework, syntax and programming structure, and covers in-depth the most important functions used to build dynamic data enriched web applications. Prerequisites: CIS 143 or CIS 122. |
|
| Cis 178 Info Tech/BITM Internship |
|
| Lecture: 3 hrs. Credit: 3 hrs. |
|
| An unpaid cooperative work experience. Students will complete a minimum of 120 hours at a cooperating employer performing IT/DP related tasks. Students will be required to keep a daily journal of their experiences and undergo an on-site observation by their supervising instructor. Upon conclusion of the internship, students will be required to give a presentation detailing their internship experiences. The internship should be taken the last semester of the student's enrollment at ACC. |
|
| Cis 222 Programming in Java |
|
| Lecture: 2 hrs. Lab: 2 hrs. Credit: 3 hrs. |
|
| A course focusing on the use of the Java programming language to develop object-oriented applications with an emphasis on the advanced features of the Java programming language including applets, classes, threads and multithreading, ODBC, graphics and visual programming. Prerequisites: CIS 144. |
|
| Cis 231 Systems Analysis and Design |
|
| Lecture: 3 hrs. Credit: 3 hrs. |
|
| A study of a business organization from an information systems perspective. Focus on the Systems Development Life Cycle, objective problem solving, data collection and analysis techniques, system design techniques, business ethics and additional skills a successful systems analyst should possess. Students will be expected to use word processing, spreadsheet, database, drawing and other software tools throughout the course. Prerequisite: For CS/IT Majors: Any two of the following courses: CIS 137, CIS 144, CIS 151, CIS 221 or CIS 222; For BITM Majors: CIS 126 and CIS 143 with at least a grade of C and pre/corequisite: CIS 237. |
|
| Cis 232 Server Administration |
|
| Lecture: 2 hrs. Lab: 2 hrs. Credit: 3 hrs. |
|
| Students will evaluate various Local Area Network (LAN) server software options and determine appropriateness and hardware requirements of that option. In addition, students will evaluate LAN support applications, such as backup options with storage area networks, print server, anti-virus software, disaster recovery implementations, user administration, server security, batch server maintenance and setup, and other related topics. Students will gain hands on experience with installing, testing and troubleshooting (NOS) servers including but not limited to Microsoft and Linux. Prerequisites: CIS 131. |
|
| Cis 233 Advanced Routing (CCNP1) |
|
| Lecture: 3 hrs. Lab: 3 hrs. Credit: 4 hrs. |
|
| Students develop practical experience planning, configuring, monitoring, and troubleshooting an enterprise routing network utilizing multicast routing, EIGRP, multiarea OSPF, Intermediate-System to Intermediate System (IS-IS) and Border Gateway Protocol (BGP) routing. Emphasis is given on how to manipulate and optimize routing updates between these protocols and efficient IP address utilization. Other topics with hands-on experience include packet queuing, IPv6, DHCP configuration, and security through reflexive and CBAC access-control lists. Prerequisite: CIS 138 or CCNA certification, or permission of instructor. Prerequisites: CIS 138. |
|
| Cis 237 Database Management Systems |
|
| Lecture: 3 hrs. Credit: 3 hrs. |
|
| A focus on the effective use of database systems, database design principles, application programming for information retrieval, database security and protection. Students will be required to complete database projects using the computer lab facilities. Prerequisites: CIS 125 or CIS 150 , CIS 143. |
|
| Cis 243 Data Struct & Obj in C++ |
|
| Lecture: 4 hrs. Credit: 4 hrs. |
|
| An object-oriented introduction to the organization of data and associated algorithms. Extensive computer programming is used to illustrate the algorithms and implementations of arrays, lists, stacks, queues, trees and heaps. Other topics include data abstraction, abstract data types, classes, encapsulation, inheritance, polymorphism, class templates and an introduction to the analysis of algorithms. Prerequisites: CIS 144 with a Grade of C or better , MAT 129. |
|
| Cis 244 Comp Systems and Programming |
|
| Lecture: 3 hrs. Lab: 1 hr. Credit: 3 hrs. |
|
| An examination of the organization and architecture of a personal computer from a low-level perspective. Topics include: data representation, processor and memory architecture, instruction representation, translation and implementation of programming language features and system interfaces. Students will complete assembly language programming assignments. Prerequisite: CIS 243 or CIS 144 and permission of instructor.
Prerequisites: CIS 243. |
|
