Computer Information Systems

CIS 102. Computer Service And Repair. 1 Credit.

This course takes you from the just-a-user level to the I-can-fix-this level for the most common PC hardware and software concerns. Students will gain practical knowledge through a combination of troubleshooting techniques and hands-on lab assignments. Topics covered include hardware installation, configuration, and upgrading, along with diagnosing and troubleshooting PC problems. This course is a vocational skill course in that your knowledge and skill are best demonstrated by your ability to address a range of PC configuration and repair problems using knowledge acquired in class. Prerequisites: Basic understanding of DOS and familiarity with several applications.

CIS 109. Introduction to Programming. 3 Credits.

This course introduces students to fundamental problem-solving and programming concepts using the high-level language Python. Topics covered include data types, variables, constants, decision statements, repetition, functions, string processing and file I/O. Prerequisites: FYE 101, MAT 092, RDG 098, (or placement).

CIS 115. Surveying Technology Via The Internet. 3 Credits.

Through selected readings and web research, this course examines contemporary computer and technology issues. Students explore topics such as changing technology, data privacy and security, global IT workforce, and impact of the Internet. Prerequisites: ENG 098, FYE 101, RDG 098, or placement.

CIS 118. Mobile and Web Development. 3 Credits.

This course will cover topics that include web servers, web development software such as Expression Web and Notepad++, web languages (HTML5/XHTML and CSS), as well as mobile and website development. Students will learn how information is transferred over the Internet, how to write HTML5 and CSS code, and how to create, maintain, and publish a website for both mobile and traditional desktop devices. Topics will include working with forms, tables (and when to substitute tables with other formatting in mobile), images, graphics, hyperlinks, media queries, viewports, page weigh, network load (and testing), emulator use, and a one web design approach. All students will be expected to create , maintain, and publish several websites on a college web server. Prerequisites: FYE 101, MAT 092, RDG 098, or placement.

CIS 119. Javascript For Web Designers. 3 Credits.

This is an introductory course to web programming using JavaScript for students with no previous programming experience, but with some familiarity with common HTML tags. Students will write scripts that use variables, operators, conditional logic, looping structures, functions, arrays, and objects. This course will develop programming skills that can be used to create interactive and dynamic websites including rollovers, cycling banners, form validation, slide shows, browser detection, plug-in detection, events, and cookies. The course provides a systematic hands-on approach to web programming. Prerequisites: GID 109 or CIS 118. Spring.

CIS 120. Microcomputer Applications. 3 Credits.

This course is designed for all students who are interested in using the microcomputer for business-related applications. The major topics will include the fundamentals of spreadsheet design and analysis and the fundamentals of database management systems. Prerequisites: FYE 101, MAT 092, RDG 098, or placement.

CIS 121. Spreadsheet Applications. 3 Credits.

Students should be comfortable with basic computer usage prior to enrolling in this course. Essential computer skills include utilizing web browsers and email as well as managing files and folders (save, locate, open, create, delete). This course is designed to develop spreadsheet skills, with an in-depth study of spreadsheet design and analysis as they relate to business applications. Topics include the fundamentals of spreadsheet design, coverage of business formulas and functions, linking multiple worksheets and files, proper layout and design, and an introduction to macros using the Visual BASIC for Applications (VBA) language. Prerequisites: ENG 098, FYE 101, MAT 092, RDG 098, or placement.

CIS 122. Microcomputer Graphic Applications. 3 Credits.

This course is an introduction to presentation graphics software used to create slide shows on the PC. Topics include creating text and numeric slides, the use of templates and layouts, the development of a slide show using transitions, builds, and animation, working with imported clipart and scanned graphics files, the use of OLE/DDE techniques, the use of hyperbuttons, and the effective use of text and color. All students will have the opportunity to create and present a computer generated slide show. Prerequisite: CIS 120 or permission of division dean.

CIS 123. Microcomputer Database Management. 3 Credits.

This course uses a database software package for a wide range of applications. Students create tables, construct queries, design forms, and generate reports. Students will also create calculated fields, use the update tables function, construct a switchboard, design forms with list, combo and group option boxes, and generate queries and reports using multiple tables. Prerequisites: MAT 092 or placement; CIS 120, 127, or 128; or permission of division dean.

CIS 127. Computer Technologies. 3 Credits.

This course is for students who are already familiar with computer use. Students must know how to use a word processor, web browsers, email and manage files and folders (save, locate, open, create, delete). A variety of computer applications will be used as tools to increase students’ productivity in school and in the workplace as well as enhance their problem solving ability. Students will use utilities to perform basic computer maintenance; evaluate computer hardware and devices for purchase based on need; identify and assess user habits in regard to security threats and vulnerabilities (including viruses, malware, spyware, firewalls, passwords, encryption, and privacy); locate, evaluate and use electronic information sources (including academic databases) to solve problems and enhance software skills; use a spreadsheet application to record data, perform calculations, create graphical representations, and interpret results; write and publish web pages using HTML tags (headings, paragraphs, lists, images, and links) and CSS (color, background, and font family); use Microsoft Access to create and execute queries (with Boolean terms and aggregate functions), as well as assess results; generate reports on tables and query results in Microsoft Access. The goal is for students to become independent users of information, computer technology, and library resources. Students will be expected to communicate and collaborate throughout the course as they present their projects and assignments.Prerequisites: ENG 098, FYE 101, RDG 098, (or placement).

CIS 128. Introduction to Information Systems. 3 Credits.

This course provides a broad overview of information systems and their components. Students will learn the basic concepts of systems, business and web services software, networks, data storage and management, information and systems security and the development of information systems. Word processing, spreadsheet and database applications are utilized throughout the course to apply concepts to real-world examples. Electronic communication, presentation, and collaboration applications are also utilized to develop essential computing skills. Prerequisite: ENG 098, RDG 098, FYE 101, or placement.

CIS 130. Programming For The Web. 3 Credits.

This course focuses on developing interactive, database-driven web pages. Students will develop web pages that retrieve information from the user, verify information, send information to a server, and interact with a database. Students are introduced to Active Server Pages.NET. Topics covered include web forms, HTML controls, web controls, validation controls, data list controls, intrinsic objects, data collections, file I/O, manipulating XML data, databases, and ADO.NET. Other topics may include COM and web services. Prerequisites: CIS 109, CIS 118, or permission of the division dean.

CIS 131. Linux Programming. 4 Credits.

This course provides students a solid foundation in the fundamentals of the Linux operation system. Students gain system level experience through problem solving exercises at the command line and in the graphical use interface. Students learn the essential command-line commands necessary to be accomplished users of their Linux workstations, as well as be able to use the GUI when appropriate. Prerequisite: CIS 140.

CIS 132. iOS (iPhone and iPad) App Development. 3 Credits.

Over 75 billion iOS apps have now been downloaded from the Apple Store. In addition to millions of other iPhones, iPods, and iPads previously sold, Apple sold an additional 10 million new iPhones within days of the introduction of iPhone 6! This course will teach you how to make your own iPhone and iPad apps as well as how to share them through the Apple Store. The course will utilize the Swift language within the xCode IDE on MAC computers. Students will not be required to purchase Apple computers to complete classwork; lab time will be scheduled for assignments. Additionally, open lab time will be available in the school’s MAC lab. Students will also be able to utilize the Apple University Developer’s License to share apps via the Apple Store for free. Topics covered will include: basic iOS, xCode and Interface Builder, xCode Playground, testing on the iOS Simulator, Storyboards, the Cocoa Touch Frameworks, UIKit, Controls, previous introduction to programming topics (i.e. – variables, control flow, functions, and arrays), classes, and security. Prerequisites: CIS 109 or permission from the instructor. Spring.

CIS 140. Microcomputer Networking Applications. 3 Credits.

This course provides students with the necessary knowledge and skills to perform competently in the role of network administrator or system manager. Major topics include networking concepts, setting up user and group accounts, securing network resources, configuring and administering network printers, backup, auditing events, and monitoring network resources. Prerequisites: FYE 101, MAT 092, RDG 098, or placement.

CIS 141. Supporting Private Clouds. 3 Credits.

This course will instruct future network administrators how to effectively implement and maintain private clouds with a balance of conceptual expertise and hands-on skills. With a focus on server administration, this course will introduce working with Virtual Machines and prepares students to work with large providers such as Amazon, Microsoft, and Google, as well as implement smaller scale cloud computing solutions within their own network environments. Specific topic coverage includes: Introduction to the Private Cloud, Creating and Managing Virtual Machines, Configuring the Hyper-V Environment, Installing and Using Virtual Machine Manager, Installing and Using the Self-Service Portal Using the Virtual Desktop Infrastructure (VDI), Implementing High Availability in the Private Cloud, Managing High-Availability Clusters and Managing the Private Cloud with PowerShell. Prerequisite: CIS 140.

CIS 142. Web Server Management. 3 Credits.

This course teaches students how to support the various features of an Internet information server. Learn how to configure a server for Internet access and publishing, Internet connectivity options, compare Internet and Intranet implementations, install and configure a web server, and optimize server performance. Prerequisite: CIS 140.

CIS 143. Computer Service and Repair. 3 Credits.

This is a current and comprehensive course on configuring, diagnosing, and repairing microcomputers and associated technologies. (PC compatible units are used in this course.) Topics covered include how computers work, how software and hardware work together, the systems board, understanding and managing memory, floppy disk and hard disk drives, installing and supporting disk drives, troubleshooting fundamentals, supporting I/O devices, and multimedia technology. Completion of this course will assist the student in preparing to pass the A+ certification exams and succeed in the PC repair industry. No electronic experience is assumed or required. Prerequisites: FYE 101, MAT 092, RDG 098, or placement.

CIS 144. Network Security. 3 Credits.

This hands-on course is designed to prepare students for the security challenges they will face as a networking professional. Specific topic coverage includes designing a secure network framework, securing servers based on function, designing a secure public key infrastructure, securing the network management process, securing network services and protocols, securing Internet information services, securing VPN and extranet communications, securing active directory, securing network resources, and securing network clients. Prerequisite: CIS 140 or permission of division dean.

CIS 145. PC Repair & Support Certification. 4 Credits.

This course provides foundation level knowledge and skills for a career in PC repair and support. Students will gain practical knowledge through a combination of troubleshooting techniques and hands-on lab assignments. Topics covered include hardware installation, configuration and upgrading along with diagnosing and troubleshooting PC problems. Using knowledge acquired in class, this course is a vocational skill course that will prepare take the CompTIA A+ 220-801 and 220 – 802 exams. Additionally, it serves as a building block for other CompTIA certifications such as Security + and Network +. May not get credit for both CIS 143 and CIS 145. Prerequisite: MAT 092, RDG 098 or placement.

CIS 208. Mobile and Web Development 2. 3 Credits.

This course will cover topics that include web servers, web languages (HTML5/XHTML, CSS, JavaScript, and PHP), as well as mobile and website development. Students work with previous HTML5 and CSS skills while adding introductory level client and server side scripting. Students will also learn to move from multi-layout design to considering both layout and content for mobile devices. Topics will include Viewport, Media Queries, Modernizr, Frameworks and Libraries, Local and Session Storage with Appcache, Cache Manifest, Client Side Database use, Device Features, going offline, making your web app native, and submitting your app to iTunes. All students will be expected to create, maintain, and publish several websites on a college web server. Note: This class is not intended to provide in depth coverage of JavaScript or PHP. Prerequisites: CIS 109, CIS 118, or permission of division dean. Spring.

CIS 218. E-Commerce Systems. 3 Credits.

Students in this course develop and present solutions to a number of case studies involving network technologies, business software applications, and web application development. They integrate the case study material with previous course experiences and research of new technologies. They apply extensive critical thinking skills as well as teamwork, research, and writing skills. Students will present solutions using multimedia presentations. Prerequisite: Completion of 24 CIS credits or permission of division dean.

CIS 219. Principles Of Information Security. 3 Credits.

This course provides students with a broad overview of information security and serves as the capstone course for the Computer Information Systems degree program. The required networking, database and programming courses for the Information Systems degree program lays a solid foundation for learning information security terminology and measures that protect confidentiality, preserve integrity, and promote availability of data. Topics include security policies, security models, business continuity plans, computer crime and security laws, physical security, operations security, access control, cryptography, Internet security and application development security. Students will complete at least one major research and writing project, at least one oral class presentation, and work on at least one team project. Students should find the topics covered informative and useful for their career in the Information Technology field, and the topics serve as a foundation for advance studies in Information Security. Prerequisite: Completion of 24 CIS credits or permission of division dean.

CIS 224. Beginning Pl/Sql. 3 Credits.

This course is designed to teach students PL/SQL skills. Students will be able to define a well-structured relational database; use SQL, create tables, keys, and constraints; as well as work with insert and select statements, functions, procedures, and triggers. Prerequisites: CIS 109 and CIS 120, or CIS 127.

CIS 232. Programming C++. 3 Credits.

This course is an introduction to C++ as an object-oriented programming language. The fundamentals of data types, variables, access modifiers, scope, selection structures, repetition structures, functions, and arrays will be covered using C++ classes and objects. Key topics in object oriented program design include encapsulation, information hiding, member access control, constructors, destructors, software reusability, member functions, overloaded functions and operators, and dynamic memory allocation. All students will be expected to write programs in C++ to exercise these topics. Prerequisite: FYE 101, MAT 092, RDG 098, or placement.

CIS 244. Internetworking. 3 Credits.

This course provides users with a basic understanding of networking technology with a focus on network hardware. Major topics include the Open Systems Interconnect (OSI) reference model, bridges, switches, hubs, Virtual Local Area Networks (VLANs), and 105 management commands. After completing the course, the student will be prepared for the Cisco CCNA Exam. Prerequisite: CIS 140.

CIS 245. Internetworking II. 4 Credits.

This course is a continuation of CIS 244 Internetworking I and introduces advanced router configurations, advanced LAN switching theory and design, VLANs, Novell IPX, and LAN and network segmentation with bridges, router, and switches. Additional topics include VLANs, WAN theory and design, WAN technology, PPP, Frame Relay, ISND, and the Spanning Tree protocol. Prerequisite: CIS 140.

CIS 290. Java I. 3 Credits.

This course is an introduction to object-oriented programming (OOP) using Java. Object-oriented programming enables the programmer to create flexible, modular programs and reuse code. Students learn what classes and objects are and how they interrelate to each other by writing programs in Java. The following topics will be covered: classes, objects, fundamental data types, control structures, repetition, operators, methods, strings, and arrays. Prerequisite: CIS 109 or comparable programming/course experience. Fall.

CIS 292. Java II. 3 Credits.

This course is a continuation of CIS 290 Java I. Students will write and present solutions to advanced Java applets and Windows applications using the graphic user interface (GUI) packages. Topics include inheritance, abstract classes, interfaces, packages, graphics, exceptions, files. A research paper is required to explore contemporary issues in software development of information systems. This course serves as a capstone course for CIT majors and as a CIS elective for CIS majors. Prerequisite: CIS 290, ENG 102. Spring.