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.
Prerequisite: CITA 108 Introduction to Spreadsheets or SOET 101 Intro to Comp Usage for Technicians
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 113 INTRODUCTION TO Mobile Cloud
Fall/Spring, 3 credit hour
This course is an introduction to information technology focusing on mobile computing applications and cloud storage. It includes word processing, spreadsheet, database, multimedia presentation and an introduction to project management, voice assistance and edge computing. Mobile computer technology, operating systems, and current web applications are covered. This is a project-based course. Students taking the course should have and plan to use a mobile device utilizing the most recent versions of iOS or Android OS. A student who completes CITA 113 will not receive credit for any of the following courses in a degree program: CITA 106, CITA 108, CITA 110, or CITA 112.
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
students to programming concepts and program design through the study of a programming language with a reduced set of instructions. Topics include number systems, relational and logical operators, understanding structures, arrays, making decisions and problem solving skills used in computing.
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
In this course, students will learn the terminology and concepts of hardware and software for computer systems. Topics will include system hardware components, memory organization, and management, operating systems, troubleshooting fundamentals, etc.
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 175 COMPUTER CONCEPTS AND OPERATING SYSTEMS LAB
Fall/Spring, 1 credit hour
This laboratory course is to accompany the lectures of CITA 170 Computer Concepts and Operating Systems course. Students will disassemble and reassemble PCs, become familiar with hardware components, learn to collect information about the computer system, install and configure system software, and test and troubleshoot the system to apply the various concepts covered in the course.
Co-requisite: Computer Concepts & Operating Systems (CITA 170)
CITA 180 Introduction to PROGRAMMING
Fall/Spring, 4 credit hours
In this course, students will learn the fundamentals of programming problem-solving with algorithms. Students will learn how to work work with variables to store information for later use. Student will put the following coding structures into play – sequential, decision, and repetition to solve a problem. Students will then focus on the reuseability of code with methods and modules.
Prerequisites: CITA 152
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 SYSTEM 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.
Prerequisites: CITA 180 or CITA 215
CITA 215 DATABASE APPLICATIONS and Concepts
Spring, 3 credit hours
In this course, students will learn the fundamentals of working with a database. Students will learn database organization. Students will learn to work with tables to extract data to answer questions – select, from, where, group by, having, order by. Students will learn to work with data types and database functions to enhance queries.
CITA 220 DATA COMmUNICATIONS AND NETWORK TECHNOLOGY
Fall/Spring, 3 credit hours
A study of terminology, hardware and software associated with data communications and network technology. Areas of study 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 networks, 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 include end-user perspective, network operating systems, cabling, hardware protocols, software and applications, design, and administration. This course should be taken concurrently with CITA 221 Data Communications and Network Technology Lab course.
Prerequisites: CITA 170, CITA 171, and 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/CYBR 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 325 BUSINESS INTELLIGENCE ANALYSIS
Fall, 3 credit hours
This course exposes the students to a set of Microsoft Business Intelligence tools: Excel, SQL Server, Reporting Services, and PowerBI. These technologies provide skills on organization, strategy, performance, and competitiveness. Students examine how these tools are used in various fields.
Prerequisites/corequisites: CITA 110, CITA 215, and MATH 141
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 GMMD 121 Programming for Visual Arts and Design
CITA/CYBR 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 371 Working with Data Visualization Tools
Fall/Spring, 3 credit hours
The Power BI Desktop course provides a foundation to work with this handy data visualization tool. Data visualization allows us to see insight into our data that would not be visible by just looking at the numbers – it will enable us to see trends and patterns for better decision making. Perfect data does not always exist to support your data visualizations – data will need massaging. The Power Query editor uses the M language to extract, transform, and load data for use in the Power BI Desktop. The Power Query editor will allow you to shape data from various sources to power your data visualizations. Data can come from multiple sources and be fragmented. The Power Editor allows you to pull data from numerous data sources to produce a unified data set to perform data analysis. Data sources can be merged and stacked together.
Prerequisites: CITA 110, CITA 163 or permission of instructor
CITA 380 INTEGRATED PROGRAMMING FOR ENGINEERS
Spring, 3 credit hours
This course develops methodologies and techniques for program creation and implementation to solve mathematical and engineering problems. The students will be exposed to solving mathematical problems such as simultaneous equations and to performing engineering data acquisition from local sources as well as remote sources using high-level programming languages, scripting languages, and commercial off-the-shell products such as MATLAB.
Prerequisites: CITA 220, ENGS 203, MATH 263 (prior programming and networking knowledge preferred)
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 401 PowerShell Scripting and Automation
Spring, 3 Credit hours
This course serves as an introduction to PowerShell, a robust scripting language and automation framework developed by Microsoft. Throughout the course, learners will develop the essential skills needed to effectively utilize PowerShell for system administration, task scripting, and automation. The course will cover the basic concepts and syntax of PowerShell, such as variables, data types, operators, functions, and control structures, through hands-on exercises and assignments. Students will also become proficient in navigating and interacting with the PowerShell environment, including working with the PowerShell Integrated Scripting Environment (ISE) and the command-line interface. Additionally, they will gain proficiency in manipulating various types of data. Advanced topics covered in the course include working with modules, implementing scripting best practices, handling errors, and performing remote administration. By the end of the course, students will have a strong foundation in PowerShell scripting and automation, enabling them to create scripts that automate tasks, streamline administration processes, and boost productivity in a Windows environment.
Prerequisite: CITA 180
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/CYBR 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