Home > Course Descriptions

Computers/Information Technology

CITA 100 COMPUTER FLUENCY

Fall/Spring, 3 credit hours

This course introduces basic computing concepts by simulating a computer gaming environment and project based activities. The course is intended for students who do not meet the minimum academic requirements to enter either the Computer Information Systems or Information Technology majors but desire to pursue a major in one of those programs.

CITA 101 LIBRARY/INFORMATION LITERACY

Fall/Spring, 1 credit hour

This course will focus on the organization, use, and retrieval of information, both within and outside of the library. Students will gain an understanding of the characteristics of information and be able to locate and critically evaluate it. Instruction will focus on both print and electronic information resources. Two hours lecture per week for seven weeks.

CITA 103 INTRODUCTION TO WORLD WIDE WEB

Fall/Spring, 1 credit hour

This course will introduce students to the World Wide Web ( WWW) and Microsoft Outlook. This course will offer instruction on how to use Internet Explorer and Microsoft Outlook for searching information on the Internet, send and receive e-mail, maintain a contact list, keep a calendar, and schedule meetings and events. Two hours lecture per week for seven weeks.

CITA 104 INTRODUCTION TO DATABASE

Fall/Spring, 1 credit hour

This course introduces the student to the fundamentals of database programs. Students will be exposed to the creation, maintenance and organizing of a database. The students will also create listings and reports. Two hours lecture per week for seven weeks.

CITA 105 INTERMEDIATE DATABASE

Fall/Spring, 1 credit hour

This course is designed to increase the students’ knowledge of database fundamentals using an industry standard database package as the instructional platform. The student will learn to do more advanced querying of the database, create and use custom forms, create and use custom reports, use the briefcase wizard, create action queries and macro writing.

Prerequisite: Introduction to Database (CITA 104) or permission of instructor. Two hours lecture per week for seven weeks.

CITA 106 INTRODUCTION TO WORD PROCESSING

Fall/Spring, 1 credit hour

This course is designed to help the student attain the necessary skills and knowledge needed for effective operation of word processing software and equipment. This course will introduce concepts of word processing equipment, input, output, storage and retrieval, distribution and software. Major emphasis will be put on hands-on experience. Two hours lecture per week for seven weeks.

CITA 107 INTERMEDIATE WORD PROCESSING

Fall/Spring, 1 credit hour

This course is designed to help the student attain advanced skills and knowledge needed for effective operation of word processing software and equipment. Major emphasis will be put on hands-on experience in learning how to design letterheads and newsletters, understanding the merging process, and creating tables.

Prerequisite: Introduction to Word Processing (CITA 106) or permission of instructor. Two hours lecture per week for seven weeks.

CITA 108 INTRODUCTION TO SPREADSHEETS

Fall/Spring, 1 credit hour

This course introduces the student to the fundamentals of spreadsheet programs. Students will create spreadsheets with literal and numeric data. The numeric data will be constants and/or formulas. Printing of spreadsheets will also be covered. Creating line, bar, stacked bar and pie graphs from a spreadsheet will also be included in the course. Two hours lecture per week for seven weeks

CITA 109 INTERMEDIATE SPREADSHEETS

Fall/Spring, 1 credit hour

This course is designed to increase the students’ knowledge of spreadsheet fundamentals using an industry standard spreadsheet package as the instructional platform. The student will learn to work with lists, pivot tables, object linking and embedding, developing a complete worksheet application and macro writing. Prerequisite: Introduction to Spreadsheets (CITA 108) or permission of instructor. Two hours lecture per week for seven weeks.

CITA 110 INTRODUCTION TO INFORMATION TECHNOLOGY

Fall/Spring, 3 credit hours

This course is an introduction to information technology focusing on microcomputer applications and application software. It includes word processing, spreadsheet, database, electronic presentation and an introduction to HTML. Personal computer terminology, hardware system components, operating systems, and current web applications are covered. Hands-on experience is utilized throughout. A student who completes CITA 110 may not receive credit for any of the following one-credit courses in a degree program: CITA 106 Introduction to Word Processing, CITA 108 Introduction to Spreadsheets, nor CITA 112 Introduction to Electronic Presentations.

CITA 111 WEB PAGE DEVELOPMENT

Fall/Spring, 2 credit hours

This course will introduce students to the development process of web pages. The student will learn how to create and edit text (HTML) with a web authoring tool. They will learn how to use a draw/graphics software program to create, edit and use various types of graphic images (.GIF & .JPEG) to help maintain the “surfer’s” interest. The student will learn how to setup and maintain hyperlinks to various sites and within the original document. Also, the student will learn how to create and use tables, image maps, thumbnails and animated GIFs. Two hours lecture per week.

Prerequisite: Introduction to World Wide Web (CITA 103) or permission of instructor.

CITA 112 INTRODUCTION TO ELECTRONIC PRESENTATIONS

Fall/Spring, 1 credit hour

This course is designed to show the student how to use desktop presentation software to prepare professional-looking presentations, combining text, charts and graphics. The students will also learn how to create typical business charts using a spreadsheet and enhancing those charts with additional software. You will experiment with animation using a drawing program, and create a presentation using various types of charts and show it to the entire class. Two hours lecture per week for seven weeks.

CITA 116 VERIZON COMPUTER APPLICATIONS

Fall, 3 credit hours

This course is an introductory course in basic computer orientation to hardware and implementation of software applications in telecommunications. Students use various software packages to create documents, spreadsheets, graphs, and presentations. The student utilizes this knowledge to solve problems and transfer information via electronic media. Successful completion of this course satisfies the SUNY Canton Computer Competency requirement.

Prerequisites: Permission of instructor.

CITA 152 COMPUTER LOGIC

Fall/Spring, 3 credit hours

This course provides a background in logical problem solving skills used in computing. Topics include problem solving techniques, number systems, programming concepts, relational and logical operators. Three hours lecture per week.

Prerequisites: Leveled into at least into Intermediate Algebra (MATH 106) and Oral and Written Expression (ENGL 102) or permission of instructor.

CITA 163 SURVEY OF INFORMATION TECHNOLOGY

Fall/Spring, 3 credit hours

An introductory survey of Information Technology (IT) and IT terminology. Emphasis is given to current and emerging technologies. Topics include: computer system components, communications and networks including the Internet, basic concepts in programming languages, information system development, IT impact on society, security, privacy, and ethics. Three hours lecture per week.

CITA 170 COMPUTER CONCEPTS AND OPERATING SYSTEMS

Fall/Spring, 3 credit hours

This is a study of the terminology and concepts associated with computer systems hardware and software. Topics will include: system hardware components, memory organization and management, operating systems, troubleshooting fundamentals, etc. Students will construct PCs and install, configure, test and troubleshoot system software to apply the various concepts covered in the course. Two hours lecture, two hours laboratory per week.

CITA 171 OPERATING SYSTEMS USE AND ADMINISTRATION

Fall/Spring, 3 credit hours

This is a project intensive course covering current operating systems. Projects are designed to give students an overview of operating systems, and encompass the major aspects of operating systems. This course may be used as a first step for students wishing to obtain industrial certification for current operating systems.

Co-requisite: Computer Concepts & Operating Systems (CITA 170) or permission of instructor.

CITA 180 INTRODUCTION TO PROGRAMMING

Fall/Spring, 4 credit hours

This course develops methodologies and techniques for program creation and implementation. Writing high-quality, internally-documented, well-structured programs utilizing appropriate data structures is emphasized.

Prerequisite: Computer Logic (CITA 152) or permission of instructor.

CITA 202 COMPUTER USER SUPPORT CONCEPTS AND SKILLS

Fall/Spring, 3 credit hours

People interested in becoming a computer support specialist or systems administrator must have strong problem-solving, analytical, and communication skills because troubleshooting and helping others are vital parts of the job. This course prepares the support specialist to maintain customer satisfaction by focusing on the needs of the customer, establishing credibility and trust, and by handling the most difficult customer scenarios. Emphasis is given to problem solving and troubleshooting, team dynamics, and interpersonal communication skills. It also provides a broad overview of the back-office operations of a help desk, and exposes the student to common industry tools and technologies used in providing exceptional customer support. Three hours lecture per week.

Prerequisites: Computer related course or permission of instructor

CITA 204 SYSTEMS ANALYSIS AND DESIGN

Spring, 3 credit hours

A course designed to guide the student through the evolution of a system, an analysis of the present flow of information and the specifications, selection and implementation of information processing systems. The scope of a system development study will transcend mere knowledge of specific systems to include a study of the total management system. Three hours lecture per week.

Prerequisites: Survey of Information Technology (CITA 163), Introduction to Programming (CITA 180), and Database Systems with Web Applications (CITA 215), or permission of instructor

CITA 215 DATABASE SYSTEMS WITH WEB APPLICATIONS

Spring, 3 credit hours

Database management systems are studied in the context of an SQL-based product. Topics include: logical organization versus physical organization; relational, network and hierarchical models; normalization; and the creation of a web-based user-interface to manipulate tables. A term project is assigned. Two hours lecture, two hours laboratory per week.

Prerequisite: Computer Logic (CITA 152) or permission of instructor.

CITA 220 DATA COMUNICATIONS AND NETWORK TECHNOLOGY

Offered as needed, 3 credit hours

A study of terminology, hardware and software associated with data communications and network technology. Areas of study will include design principles for human-computer dialogue, selection criteria for communications devices, the technology of data transmission, techniques and message protocols for line control and error processing, local area net works, networking concepts, network topologies and access control, network performance, network services and design issues, and network media and access methods. Design, configuration, operation and maintenance questions are explored. Topics will include enduser perspective, network operating systems, cabling, hardware protocols, software and applications, design, and administration. This course should be taken concurrently with Data Communications and Network Technology Lab (CITA 221). Three hours of lecture per week.

Prerequisites: Computer Concepts and Operating Systems (CITA 171) and Intermediate Algebra (MATH 106) or permission of instructor.

CITA 221 DATA COMMUNICATIONS AND NETWORK TECHNOLOGY LAB

Offered as needed, 1 credit hour

This laboratory course is to accompany the lectures of CITA 220 Data Communications and Network Technology course. Students will obtain hands-on experience on data communications and network technology throughout this course. Two hours laboratory per week.

Prerequisites: Operating system Fundamentals (CITA 171), Intermediate Algebra (MATH 106) or permission of instructor.

CITA 250 INFORMATION SECURITY

Fall/Spring, 3 credit hours

An introduction to various technical and administrative aspects of Information Security and Assurance. Students will be exposed to the spectrum of Information Security activities, methods, methodologies, and procedures. Coverage will include inspection and protection of information assets, detection of and reaction to threats to information assets, and examination of pre- and post-incident procedures, technical and managerial responses and an overview of Information Security planning and staffing functions. Three hours lecture per week.

Prerequisite: Data Communications and Network Technology (CITA 220) or permission of instructor.

CITA 260 INTRODUCTION TO WIRELESS TECHNOLOGY

Spring, 3 credit hours

This course introduces various aspects of wireless technology including wireless networks, authentication, protocols, security, installation considerations, and standards. Projects to determine signal strengths from different antenna types and locations are assigned. Three hours lecture per week.

Prerequisites/corequisites: Data Communications and Network Technology (CITA 220) or permission of instructor.

CITA/MINS 300 MANAGEMENT INFORMATION SYSTEMS

Fall/Spring, 3 credit hours

Students learn the concepts underlying the design, implementation, control, evaluation, and strategic use of modern, computer-based information systems for business data processing, office automation, information reporting, decision-making, and electronic commerce. The major emphasis of the course will be on the managerial and strategic aspects of information technology. Three hours lecture per week.

Prerequisites:Junior standing or the sum of credits earned and credits currently enrolled in is at
least 60 or permission of instructor.

CITA/MINS 307 CUSTOMER RELATIONSHIP MANAGEMENT

Fall/Spring, 3 credit hours

This course provides information systems tools for building a customer-focused organization based on customer data and information. The course focuses on using current data to enhance relationships with customers, gathering data for future marketing endeavors and providing strategic guidance to the organization. The course provides insights into customer life-cycle management, customer lifetime value and measuring customer profitability. Three hours lecture per week.

Prerequisites/corequisites: Management Information Systems (CITA/MINS 300) or permission of instructor.

CITA 310 WEB SERVER ADMINISTRATION

Fall, 3 credit hours

A comprehensive survey of all aspects of web server administration. Students will gain hands-on experience by actually installing and administering their own web servers in a lab environment. Topics include: server installation and configuration, site planning, supporting dynamic content with CGI’s and ASP’s server maintenance and site security. Two hours lecture, two hours laboratory per week.

Prerequisite: Data Communications and Network Technology (CITA 220) or permission of instructor

CITA/MINS 315 DECISION SUPPORT SYSTEMS

Fall/Spring, 3 credit hours

This course enables the student to turn raw data into information to help an organization’s managers make decisions. Students will develop decision making analytical models to provide organizational leaders with potential outcomes and their effects. Students will study the network’s role in distributed systems, distributed systems development tools, and distributed systems issues. Students will apply data-mining techniques supporting knowledge-management decisions. Three hours lecture per week.

Prerequisites/corequisites: Management Information Systems (CITA/MINS 300) or permission of instructor.

CITA/MINS 320 INTRODUCTION TO DATA MINING

Spring, 3 credit hours

A systematic introduction to the basic principles, applications, techniques and models of data mining including classification, estimation, prediction, affinity grouping, clustering, description and profiling. The emphasis is on various data mining problems and their solutions. Students will also be exposed to a sample of data mining applications. Topics include decision trees, artificial neural networks, nearest neighbor approaches, market basket analysis, and association rules. Three hours lecture per week.

Prerequisites/corequisites: Introduction to Database (CITA 104) or Database Systems (CITA 215) and Statistics (MATH 141) or permission of instructor.

CITA 330 EMERGING INFORMATION TECHNOLOGY APPLICATIONS

Spring, 3 credit hours

An advanced study of emerging information technology applications. This course covers web application development with XML, multimedia technologies including graphics, audio, animation, video, presentations, desktop publishing, web publishing, and input technologies including speech, and writing recognitions. The course will also include additional topics on most current state-of-the-art IT applications. Two hours lecture, two hours laboratory per week.

Prerequisite: junior level status or permission of instructor.

CITA 342 VISUAL PROGRAMMING AND DEVELOPMENT TOOLS

Fall, 3 credit hours

An introduction to the development of computer applications using rapid development tools such as Visual Basic or Visual C++. Emphasis will be on designing and managing graphical user interfaces, procedures, file management, debugging and testing. Two hours lecture and two hours lab per week.

Prerequisite: Introduction to Programming (CITA 180) or permission of instructor.

CITA 352 ETHICAL HACKING AND PENETRATION TESTING

Fall, 3 credit hours

This course introduces students to a wide range of topics related to ethical hacking and penetration testing. The course provides an in- depth understanding of how to effectively protect computer networks. The topics cover the tools and penetration testing methodologies used by ethical hackers and provide a thorough discussion of what and who an ethical hacker is and how important they are in protecting corporate and government data from cyber attacks.

Prerequisite:CITA 250 Information Security

CITA/JUST 365 DIGITAL FORENSIC ANALYSIS

Spring, 3 credit hours

This course is designed to prepare the student to complete forensic analysis of digital media and to understand the process and technical challenges of internet investigations. The course looks specifically at how to obtain evidence from digital media, how to process network messages and logs while preserving the evidentiary chain, and how to adhere to the legal requirements of the search and seizure of digital media and related equipment and information.

Prerequisites: Operating System Fundamentals (CITA 171) or permission of the instructor.

CITA 385 COBOL for BUSINESS AND ACCOUNTING

Fall, 3 credit hours

This course provides students with the knowledge and experience to write and modify programs written in the COBOL programming language. Classroom exercises use real world scenarios so students will gain an understanding of where COBOL fits in the business world.

Prerequisites: Computer Logic (CITA 152) or permission of the instructor.

CITA 400 QUANTITATIVE APPROACHES TO MANAGEMENT

Spring, 3 Credit hours

This is the study of the decision-making process and how quantitative methods are used to find solutions to business problems. Computer software tools will be used to analyze and process data. Opportunities, problems and decisions that confront managers are analyzed and solutions are developed. Topics covered include, but are not limited to: Cost-volume-profit analysis, forecasting, decision theory, linear programming, probability concepts and applications, inventory control, queuing theory, and game theory. Two hours lecture, two hours laboratory per week.

Prerequisite: Statistics (MATH 141) or permission of department.

CITA 420 PROGRAMMING FOR THE WEB

Fall, 3 credit hours

This is a survey of programming languages and techniques for web development. Topics include CGI’s, client side programming with JavaScript, dynamic content using Java and ActiveX, server side programming using Active Server Pages and VB Script, creating dynamic, database driven content, and developing web based client/server database applications. Two hours lecture, two hours laboratory per week.

Prerequisites: Web Server Administration (CITA 310) and Emerging Information Technology Applications (CITA 330), or permission of instructor.

CITA/MINS 425 ENTERPRISE RESOURCE PLANNING

Fall/Spring, 3 credit hours

This course provides information systems tools to ensure a comprehensive resource planning system for all functions of businesses. The course will discuss the development and employment of enterprise resource planning for marketing, accounting, supply chain management, and human resources. Content will focus on practical applications of enterprise resource planning to ensure businesses get the greatest returns on information systems investment. Three hours lecture per week.

Prerequisites/corequisites: Management Information Systems (CITA/MINS 300) and junior level status or permission of instructor.

CITA/MINS 430 DATA AND KNOWLEDGE MANAGEMENT

Fall/Spring, 3 credit hours

This course focuses on the development of a knowledge-management system using an organization’s tacit and explicit knowledge to execute its strategy. The course explores practices entailed in developing a knowledge infrastructure, managing the interaction of people and technology, valuing knowledge assets, leveraging teams, and transferring knowledge across organizations. Three lecture hours per week.

Prerequisites/corequisites: Management Information Systems (CITA/MINS 300) and junior level status or permission of instructor.

CITA 440 NETWORK MANAGEMENT

Spring, 3 credit hours

An advanced study of network management concepts, architectures, protocols, models, tools, systems, and applications. The course concentrates on the implementation of the Simple Network Management Protocol (SNMP). Students are also introduced to the use of the Desktop Management Interface (DMI) standard and Web-based Management. Three hours lecture per week.

Prerequisites/corequisites: Network Technology (CITA 220) or permission of instructor.

CITA 441 NETWORK MANAGEMENT LAB

Fall/Spring, 1 credit hour

This laboratory course is to accompany the lectures of CITA 440 Network Management course. Students obtain hands-on experience on various network management tools, protocols, applications, and systems throughout this course.

Prerequisites/corequisites: Data Communications and Network Technology Lab (CITA 221) or permission of instructor.

CITA 460 INFORMATION TECHNOLOGY AND NETWORKED ECONOMY

Fall, 3 credit hours

This course will examine the fundamental concepts and components of Information Technology from both managerial and professional end-user perspective. The course will also explore the foundations of information systems to the demands of electronic commerce, connectivity, and networked economy. Three hours lecture per week.

Prerequisite: Senior status in a four-year program or permission of instructor.

CITA 479 INFORMATION TECHNOLOGY INTERNSHIP ORIENTATION

Fall/Spring, 1 credit hour

This course is designed as the precursor to the Senior Culminating Experience for seniors in the Information Technology, program. Seniors will meet on a weekly basis with faculty to discuss resume preparation, job interviewing, locating and establishing internships, and internship requirements. This course is a prerequisite to Internship in Information Technology (CITA 480). One hour lecture per week.

Prerequisites/Corequisites: all upper-level Information Technology core courses.

CITA 480 INFORMATION TECHNOLOGY INTERNSHIP

Fall/Spring, 6 or 12 credit hours

This is supervised field work in a selected business, industry, government or educational setting. Students carry out a planned program of educational experiences under direct supervision of an owner, manager or supervisor of information technology in an organization. Each intern will be supervised by a member of the faculty on a regular basis. Written and oral reports of work experience activities will be required. Evaluation will be based on the quality of experiences gained from the internship. Approximately 600 hours of supervised activity.

Prerequisites: Information Technology Internship Orientation (CITA 479) and senior status in the Information Technology program or permission of instructor.

CITA 481 SENIOR PROJECT IN INFORMATION TECHNOLOGY

Fall/Spring, 6 credit hours

The course requires extensive project development work to integrate the specialized skills and knowledge presented throughout other courses in the Information Technology curriculum. Under the guidance of a faculty mentor, the student will prepare a project proposal, conduct literature review and project implementation, submit a project report, and make an oral presentation. At least 225 project activity hours needs to be fulfilled. Corequisite: Information Technology and Networked Economy (CITA 460).

Prerequisites: Information Technology Internship Orientation (CITA 479), and senior level status in Information Technology program, or permission of the program director

CITA 291-295, 391-395, OR 491-495 SPECIAL TOPICS IN COMPUTING

Fall/Spring, 1-4 credit hours

Special Topics in computers will generally include topics of current interest or topics not covered in courses currently offered by the department or in combinations not currently available.

Prerequisite: permission of the instructor