St. Clair County Community College 2005-2006 Catalog
COMPUTER INFORMATION SYSTEMS
Computer & Office Technology Department 810-989-5628
CIS 110 CIS Concepts and Careers. This course examines the impact of computers on business, society, and the individual. Topics include the evolution of computers, including mainframe and microcomputers; the information processing cycle; components of an information system; usage of the computer as an information gathering tool; basic hardware and software terminology and concepts; information system design and development; data communications, networking, and internet.
Prerequisite: None
4 credits = 4 lecture/laboratory
CIS 110A Introduction to Computers - The Internet. CURRENTLY INACTIVE. See note at the end of the course listings.
CIS 112 Enhanced Data Cabling Installers Certification. This course prepares students to sit for the vendor-neutral, Data Cabling Installer Certification exam which is administered by the Evolving Technologies Association International (ETAI). This exam assesses the ability to correctly design, install, and test Category 5 Network Cable. This course provides all of the theory necessary to understand the concepts behind cabling standards and to pass the theory examination. In addition, it prepares the student to actually perform the tasks required of a cable installer. This course would also be appropriate for those involved in the commercial construction industry as well as computer service and network administration personnel.
Prerequisite: None
2 credits = 2 lecture/laboratory CIS 115 Microcomputer Applications. This is a hands-on class using the microcomputer in a variety of applications, including word processing, electronic spreadsheet, and database management. The course will emphasize systems as well as applications software. Fundamentals such as identifying computer hardware, file management, and problem solving methodologies will be presented.
Prerequisite: None
4 credits = 4 lecture/laboratory CL
CIS 115H Microcomputer Applications for Advanced Students, Honors. This is a hands-on class using the microcomputer in a variety of applications, including word processing, electronic spreadsheet, data base management, graphics and communications. Projects will be designed to integrate software features. Discussions and illustrations will be designed to apply/build business skills. Items such as the value of planning, documentation, and data integrity will be introduced.
Prerequisite: Acceptance into the Honors Program
4 credits = 4 lecture/laboratory CL
CIS 120 Introduction to Networking, NetPrep. This course gives students a broad overview of the networking industry. The course will cover common concepts of the technologies, topologies, protocols and standards that are used in networking. This course will provide the basic knowledge needed in all subsequent networking courses.
Prerequisite: None
4 credits = 4 lecture/laboratory CL
CIS 121 Introduction to Local Area Networks, NetPrep. This course covers local area network (LAN) physical media, layer 2 architectures, and network operating systems in detail. The course examines the advantages and disadvantages of common cable infrastructure, and provides guidelines for when each is appropriate. During this course students will examine the leading network operating systems and their administration. Wide area network considerations will be introduced. The course concludes with general LAN considerations and a case study. Fall semester only.
Prerequisite: CIS 120
4 credits = 4 lecture/laboratory CL
CIS 122 Wide Area Networks, NetPrep. Participants in this course learn the technologies used to move voice and data across long distances. They will discover important new technologies such as Asynchronous Transfer Mode (ATM) that integrate voice, data and video communications. Basic concepts of how information is transported over a wide area network (WAN), from physical layer to application layer, and how these technologies work is also reviewed. Offered Fall semester only.
Prerequisite: CIS 120
4 credits = 4 lecture/laboratory CL
*For definition of contact hours, and fees for contact hours, see pages 39-40. CIS 123 TCP/IP, NetPrep. The world's largest network, the Internet, is also one of the world's most powerful communication tools. Learn the underlying applications, components and protocols of TCP/IP and its necessary link to the Internet. This course will help participants learn how to identify TCP/IP layers, components and functions. Navigation tools, TCP/IP services, utilities, and troubleshooting methodologies are also covered. Winter semester only.
Prerequisite: CIS 120
4 credits = 4 lecture/laboratory CL
CIS 130 Operating Systems. This course provides an introduction to current operating systems and user interface types. Through lecture and hands-on exercises, students will explore concepts and usage of several different systems: MS-DOS, Microsoft Windows™, Linux, Local Area Networking, the Internet and other related topics.
Prerequisite: CIS 110
4 credits = 4 lecture/laboratory CL
CIS 150 Programming Concepts. This course provides an introduction to general programming topics such as: the program development cycle, data types and control structures, structured programming principles, problem solving, basic algorithms and data validation.
Prerequisite MTH 102 or appropriate placement by our college assessment or ACT score
2 credits = 2 lecture/laboratory
CIS 160 A+ Certification. This is an introductory course on how the computer works at the hardware level. Students will learn the basics of upgrading, maintaining, and repairing a computer. Topics include the system board, BIOS, DOS, floppy drives, hard drives, peripheral devices, memory, troubleshooting, supporting Windows, and others. This course prepares the student to take the A+ Certification exam. This course is the same as ELT 160.
Prerequisite: ELT 135 and CIS 110
4 credits = 4 lecture/laboratory
CIS 200 - Electronic Spreadsheets. This course focuses on the capabilities, features and usage of electronic spreadsheet software. Particular attention is given to the application of these spreadsheet tools in the solution of practical problems from business, finance, science and other areas. Through lecture and hands-on exercises, students will examine the skills which are needed to make effective use of spreadsheets including: worksheet design, problem organization, use of advanced functions, data manipulation, advanced charts and graphs, spreadsheet automation and presentation of results.
Prerequisite: CIS 115 or CIS 115H or CIS 110
4 credits = 4 lecture/laboratory CL
CIS 202 Microcomputer Databases. This course addresses the design, creation and management of relational databases. Topics covered include database fundamentals, the use of the database management software, the fundamentals of application development, and the use of the data management topics such as structured query language (SQL). Emphasis is placed on "hands-on" use of popular personal computer database software. Students will be expected to design and develop a real-world database application.
Prerequisite: CIS 115 or CIS 115H
4 credits = 4 lecture/laboratory CL
CIS 205 Internet Development I. This course provides an introduction to development and management of content for the Internet, specifically the World Wide Web (WWW). Techniques for planning, developing, organizing and maintaining WWW content and sites will be addressed. Through lecture and hands-on exercises, students will explore concepts and usage of HTML, Web-creation and management software, and basic web scripting tools.
Prerequisite: CIS 115
4 credits = 4 lecture/laboratory CL
CIS 221 Packets and Protocols, NetPrep. This is an advanced course intended for networking professionals and students who already grasp the general concepts of data communications and networking, but would like a more detailed understanding of the processes and protocols used in today's networks. Network architectures will be discussed from an Open System Interconnect (OSI) model perspective of the networking protocol stack, and a detailed analysis of the protocols will ensue using traces taken with protocol analyzers.
Prerequisite: CIS 120
4 credits = 4 lecture/laboratory CL
CIS 227A Special Topics in Networking. This course is an in-depth study or one or more current topics in Computer Information Systems. Topics will be selected by the discipline.
Prerequisite: CIS 120, and either CIS 121 or CIS 122
3 credits = 3 lecture/laboratory CL
CIS 227B Special Topics in Networking. This course is an in-depth study or one or more current topics in Computer Information Systems. Topics will be selected by the discipline.
Prerequisite: None
4 credits = 4 lecture/laboratory CL
CIS 235 Internet Development II. This course focuses on the design of effective web sites including page layout, navigation design, and graphic design. The course includes working with forms, images, video, audio, and interactive page elements. Students will create their own web pages and web sites utilizing intermediate web development tools.
Prerequisite: CIS 205
4 credits = 4 lecture/laboratory CL
CIS 236 Interactive Web Programming. This course provides an introduction to technologies and tools used to create dynamic, interactive web sites. Both client side and server side technologies will be examined. Programming projects will emphasize the usage of tools such as: Java, VBScript, Javascript, PHP, ASP, Perl, Python, CGI or other technologies as available.
Prerequisite: CIS 130 and CIS 205 and CIS 260
4 credits = 4 lecture/laboratory CL
CIS 238 Web Server Administration. This course explains the process of designing, installing and administering a real-world commercial web server. Students will work with the Linux operating systems and Apache Web Server, a combination that hosts the majority of websites on the Internet.
Prerequisite: CIS 130 and CIS 202 and CIS 205
3 credits = 3 lecture/laboratory CL
CIS 247A Special Topics in Computer Applications. This course is an in-depth study of one or more current topics in Computer Information Systems. Topics will be selected by the discipline.
Prerequisites will be determined by course topic. See schedule for comments.
Prerequisite: CIS 200 or CIS 202 or CIS 205
3 credits = 3 lecture/laboratory CL
CIS 247B Special Topics in Computer Applications. This course is an in-depth study of one or more current topics in Computer Information Systems. Topics will be selected by the discipline.
Prerequisites will be determined by course topic. See schedule for comments.
Prerequisite: CIS 200 or CIS 202 or CIS 205
4 credits = 4 lecture/laboratory CL
CIS 260 Computer Programming I. This course provides an introduction to fundamental concepts of computer programming, problem solving techniques and algorithm development. Programming projects will emphasize the syntax and usage of a high level programming language, along with analysis, design, and testing.
Prerequisite: CIS 150 and MTH 110 or appropriate placement.
4 credits = 4 lecture/laboratory CL CT
CIS 261 Data Structures Programming. This course explores the techniques and data structures used in the development of complex software projects. Through lectures and programming projects, this course will cover elementary data structures, dynamic memory allocation, sorting and searching, recursion, algorithmic analysis and object oriented programming techniques.
Prerequisite: CIS 260; MTH 113 or higher (Not required, but strongly recommended)
4 credits = 4 lecture/laboratory CL CIS 267A Special Topics in Computer Programming. This course is an in-depth study of one or more current topics in Computer Information System programming. Topics will be selected by the discipline.
Prerequisites will be determined by course topic. See schedule for comments.
Prerequisite: CIS 260
3 credits = 3 lecture/laboratory CL
CIS 267B Special Topics in Computer Programming. This course is an in-depth study of one or more current topics in Computer Information System programming. Topics will be selected by the discipline.
Prerequisites will be determined by course topic. See schedule for comments.
Prerequisite: CIS 260
4 credits = 4 lecture/laboratory CL
CIS 275 Visual BASIC Programming. Fundamental concepts of computer programming, problem solving techniques, and algorithm development as well as the syntax and usage of the Visual BASIC programming language in the Graphic User Environment are addressed in this class. Topics include visual BASIC controls, control properties, application planning and design, user interface creation, variables, symbolic constants, selection structures, and repetition structures. The advanced topics include sequential access files, menus, dialog boxes, error trapping, random access files, control arrays, variable arrays, and database access.
Prerequisite: CIS 150
4 credits = 4 lecture/laboratory CL
CIS 280 Systems Analysis and Design. This class focuses on the steps and procedures used for defining, analyzing, designing and implementing systems that are user oriented. Systems Analysis and Design (SAD) methods such as the traditional Systems Development Life Cycle (SDLC), Rapid Application Development (RAD), and Joint Application Development (JAD) will be evaluated. Uniform Modeling Language (UML) CASE, and prototyping will be used to model systems. Oral and written communication techniques, flowcharting, and the necessity of standards and procedures will also be topics of discussion. Fall semester only.
Prerequisite: CIS 260 and CIS 275
4 credits = 4 lecture/laboratory CL CT
CIS 284 Microcomputer Applications Specialist. This course is designed to develop management skills needed in the small to mid-sized computer installation environment. This will include the study of management (personnel, hardware and software) through research, lecture and scenarios. This course will include the development of the communication skills needed to present technical recommendations to non-technical staff. Through lecture, group work, student led presentations, and research, the student will employ a variety of software programs (word processing, presentation graphics, spreadsheets, databases and flowcharting) to reach these objectives. Winter semester only.
Prerequisite: CIS 115 or CIS 115H and CIS 130
4 credits = 4 lecture/laboratory CL CT CIS 286 Network Analysis and Design, NetPrep. This capstone course explains the process of analyzing and designing a new network or network upgrade. It presents a step-by-step approach that breaks this complex process into five major phases, each with its own inputs, tasks, and outputs: 1). Requirements Gathering, 2). Analysis, 3). Logical Design, 4). Physical Design, and 5). Installation and Maintenance. By focusing on user requirements first, students will learn to create an effective solution. Winter semester only.
Prerequisite: CIS 123
4 credits = 4 lecture/laboratory CL CT
CIS 290 Computer Co-op/Internship. This work placement is designed for the Computer Information Systems student that has completed at least all the CIS classes listed in the first and second semesters of one of the two CIS programs. The work placement may be either a paid (co-op) or non-paid (internship) placement. Students will be individually placed into positions involving operations, programming, networking, or systems analysis as fits their needs/ desires. One credit will equal 60 hours of placement. Students may receive credit for up to four CIS 290 courses A, B, C, D at the rate of one credit per course.
Prerequisite: Approval of CIS faculty co-op internship coordinator and sophomore status in one of the Computer Information Systems Programs.
1 credit each
CIS 297 The CIS Professional. In this capstone course, students will prepare for employment as CIS professionals by developing a portfolio and discussion issues pertinent to the CIS workplace.
Corequisite: CIS 238 or CIS 280 or CIS 284 or CIS 286
1 credit = 1 lecture/laboratory
NOTE: CURRENTLY INACTIVE classes may be offered in the future. If students are interested in having a currently inactive course listed in the fall, winter, spring or summer schedule, contact the department chair or an instructor in the appropriate area.