ITS - Information Tech Systems

Course provides students with basic computer skills, an introduction to Windows, software basics, internet connectivity, and PC troubleshooting and maintenance.

Introduces Window-based software including word processing, spreadsheets and databases with inclusion of graphic images. Overviews operating systems and graphical user interfaces.

Introduces web design using web development package and design concepts to create and maintain web pages. Covers emerging technologies such as Java script, cascading style sheets, dynamic content, dynamic formatting, and server scripting are covered.

Provides understanding of organizational systems, planning and decision processes and how information is used for decision support in organizations. Quality and decision theory, information theory, and practice essential for providing viable information to the organization. Concepts of IS for competitive advantage, data as a resource, IS and IT planning and implementation, Total Quality Management (TQM) and reengineering, project management and development of systems, and end-user computing.

Overview of computer programming languages including PASCAL, COBOL, and Visual Basic. Topics include I/O techniques, general rules and structured programming methodology.

Introduction to game programming. Create customized game applications. Explanations include interface and required elements, game design, drawing graphics, player and computer actions, and logic required to create an effective game.

Introduction to micro-computers, personal computers (PC's) and appropriate software applications to assist in future use of the computer to meet individual needs.

Surveys major Microsoft tools including Word, Windows, PowerPoint, Excel, Access and Outlook. Explores the Internet. No prior knowledge of computers required. Designed to assist user in meeting individual computer needs. Includes brief overview of the field of information technology.

Demonstrate material learned in solving substantial practical problems in a realistic setting. Understand major aspects of the Information Technology life cycle in detail. Objectives accomplished with help of a faculty member and/or supervisor.

Internet fundamentals covering viewing the internet, internet services, understanding internet search engines, plug-ins, security issues, and electronic commerce. Fundamentals of web authoring including web page authoring basics and HTML beginner to advanced. Network fundamentals including basics of networking, internetworking concepts, introduction to Local and Wide Area Networks, TCP/IP concepts, extending web server abilities and introduction to network security.

Install, configure, and upgrade microcomputers; Diagnose and troubleshoot microcomputers; Identify motherboard, processor and memory characteristics; Understand basic networking concepts; Know basic printing components, connections and configurations; Practice safe, preventative and performance maintenance procedures.

Navigate MS-DOS, Windows 9.x, Windows Millennium, Windows NT 4.0, Windows 2000 and Windows XP interfaces; Install, configure and maintain Windows 9.x, Windows Millennium, Windows NT 4.0, Windows 2000 and Windows XP; Install, uninstall, run and repair Windows 9.x, Windows Millennium, Windows 2000 and Windows XP applications; Install, configure and maintain peripheral components; Identify preventative maintenance techniques and practices; Identify networking and internetworking hardware/software concepts; Troubleshoot customer's Windows 9.x, NT and 2000 hardware issues.

CCNA certification designed to enable individuals new to networking technologies to understand terms, concepts, technologies, and devices commonly used in networking then apply knowledge to installation, configuration, and troubleshooting of Cisco switches and routers.

Focuses on standards, technologies, and practices for both business-to-business and business-to-consumer E-commerce models. Analysis and facilitation of relationships among marketing, promotion, customer service, user interaction, purchasing methods, and secure transactions using SSL and SET, payment gateways, inventory control, shipping, order information and site performance testing and evaluation. Prerequisite: ITS 23472 Internet.

Create and manage Web sites using HTML, FrontPage, Dreamweaver, Flash, HomeSite, DHTML, XML and various multimedia and CSS standards. Implement latest strategies to develop third-generation Web sites, evaluate design tools, discuss future technology standards, and explore incompatibility issues surrounding current browsers. Emphasizes theory, Web design and construction, information architecture concepts, Web project management, scenario development and performance evaluations. Prerequisite: ITS 23472 Internet or ITS 23410 Internet Webmaster Foundations.

Students learn the skills and knowledge necessary to install, configure, and manage windows Vista.

Provides student with the fundamental knowledge to complete the SQL 2005 curriculum.

Provides student with the fundamental programming knowledge necessary to complete training in .NET 2.0 using C# programming fundamentals.

Provides student with the funamental programming knowledge necessary to complete training in .NET 2.0 using visual basic programming fundamentals.

Provides student with the knowlege necessary to understand .NET development fundamentals.Recommended prerequisite: ITS 23478 Programming Foundations C#.

Provides student with the knowledge necessary to understand .NET development fundamentals. Recommended prerequisite:ITS 23479 Programming Foundations VB.

Provides student with the fundamentals of end-user operations of Sharepoint Server.

Provides student with technical competency in Windows Sharepoint Services, including installation, management, and maintenance functions. Prerequisite: ITS 23482 Sharepoint Server Foundations.

Students will learn to install the operating systems, manage and troubleshoot access to files, folders, network shares and printers, configure and troubleshoot hardware devices, drivers, the desktop and user environments, as well as network protocols and services.

Students will learn to configure and troubleshoot applications, resolve issues related to application usability for other applications and customization, configure and troubleshoot network connections for applications, as well as configuring application security.

Introduction to the SQL Programming language, including writing basic SQL statements, restricting and sorting data, single row functions, displaying data from multiple tables, aggregating data using group functions, subqueries, producing readable output with iSQL Plug, manipulating data, creating and managing tables, including constraints, creating views, creating other database objects, and controlling user access.

Students will learn how to use Outlook to communicate, manage messages, use the calendar, navigate and use the application effectively, use contacts, tasks, and notes, as well as to integrate other office applications with this version of MS Office.

Students will learn how to use Outlook to communicate, manage messages, use the calendar, navigate and use the application effectively, use contacts, tasks, and notes, as well as to integrate other office applications with this version of MS Office.

Students will learn to work with text, paragraphs, documents, manage files, use tables, and work with pictures and charts in this version of MS Office.

Students will learn to work with text, paragraphs, documents, manage files, use tables, and work with pictures and charts in this version of MS Office.

Students will learn to work with cells, files, format worksheets, page setup and printing, workbooks, formulas, functions and to use charts and objects in this version of MS Office.

Students will learn to work with cells, files, format worksheets, page setup and printing, workbooks, formulas, functions, and to use charts and objects in this version of MS Office.

Students will learn to plan and design databases, build and modify tables, build and modify forms, view and organize information, define relationships, and produce reports in this version of MS Office.

Students will learn to plan and design databases, build and modify tables, build and modify forms, view and organize information, define relationships, and produce reports in this version of MS Office.

Students will learn to create and modify presentations, work with text and visual elements, create output, manage files, and deliver a presentation with this version of MS Office.

Students will learn to create and modify presentations, work with test and visual elements, create output, manage files, and deliver a presentation with this version of MS Office.

Students will learn to install, configure, and operate Wireless LANs. Topics to include radio frequency fundamentals, organizations and standards, spread spectrum technologies, network architecture, wireless network management, hardware installation, physical and MAC layers, site surveying, and wireless LAN security.

Students will be exposed to the essential knowledge necessary to identify the names, purposes, and characteristics of personal computer components, operating systems, laptop/portable computers, printers and scanners, as well as how to install, configure, optimize, upgrade and troubleshoot these components. Other topics include the fundamental principles of wired/wireless networks, computer security, safety, environmental issues, communication, and professionalism.

Students will learn to apply the A+ essentials in a mobile or corporate technical environment with a high level of face-to-face client interaction.Prerequisite: A+ Essentials

Students will learn to apply the A+ essentials in a remote-based work environment where client interaction, client training, operating system and connectivity issues are emphasized. Prerequisite: ITS 26000 A+ Essentials

Students will learn to apply the A+ essentials in a hardware-based environment where components, devices, security, and environmental safety is emphasized. Course is ideal for entry-level desktop support specialists and computer assemblers. Prerequisite: ITS 26000 A+ Essentials.

Course offers an extensive introduction to Linux technology. Topics include the critical concepts of installation, operation, administration, troubleshooting services, and maintenance of Linux operating systems.

Introductory study of computer operating systems. Topics include file systems, batch processing, concurrent processing, memory management, processor scheduling, device drivers, display handling, input/output management, and operating system control commands.

Examines design, development and administration of large-scale database applications on a scale appropriate to business organizations.

Examines design, development and administration of large-scale database applications on a scale appropriate to needs of business organizations.

Explores the design, selection, implementation and management of enterprise IT solutions, focusing on applications and infrastructure and their fit within business organizations. Covers frameworks and strategies for infrastructure management, system administration, data/information architecture, content management, distributed computing, middleware, legacy system integration, system consolidation, software selection, total cost of ownership calculation, IT investment analysis, and emerging technologies. Prerequisite: ITS/MIS 13063 Foundations of Information Technology.

Course prepares students new to networking technologies to understand terms, concepts, technologies, and devices commonly used in networking. Topics include application of knowledge to the installation, configuration, and troubleshooting of Cisco switches and routers.

Continuation of ITS 31062 Cisco Networking Devices I.

Combines software development methods, tools, and management techniques to achieve rapid application development. Emphasizes object oriented analysis and design to achieve reuse of system components. Prerequisite: ITS 16163 Computer Programming.

Identify basic networking concepts; Distinguish between network transmission types and connectivity devices; Undersand TCP/IP components and NT/Novell protocol suites; Demonstrate network planning for hardware, cabling and operating systems; Assess network security, wireless technologies and secure remote connectivity; Perform network troubleshooting. Prerequisites: None.

The Java platform is based on the idea that the same software should run on many different kinds of computers, consumer products, and other devices. This course is desinged to give students an understanding of current Java programming languages. It provides the knowledge needed to compile, run and distribute simple Java applications. Prerequisite: ITS 16163 Computer Programming or consent of instructor.

Introduction to Oracle relational database concepts; Use of SQL for storing, retrieving, and manipulating data in relational database; Access data from more than one table using joins; Aggregate data using group functions, writing sub-queries, and create and populate Oracle database tables; Define, maintain, and modify other database objects; Use SQL's Data Manipulation Language and transaction controls; Control both user and object level security in an Oracle database; Use basic PL/SQL. Prerequisite: ITS 30163 Database Management, ITS 33470 Networking, or consent of instructor

Introduction to concepts and procedures associated with Oracle architectural components. Topics include database administration strategies and procedures provided in Oracle8i, managing Oracle instance and use database tools, storage structure components and tables, methods for loading and reorganizing data, and concepts and tasks associated with managing security. Prerequisite: ITS 33475 Oracle SQL and PL/SQL.

Introduction to tools and techniques to improve performance of currently accepted Oracle server platforms; Files and events supporting tuning process; Application tuning issues impacting database performance; Tuning components and functions of shared pool and buffer cache. Monitor contents and usage of Redo Log buffer. Identify: Database configuration and I/O issues; SQL operations requiring sorts. Use: Direct writes for large sorts and allocate temporary space appropriately; Oracle tools to diagnose and resolve contention. Create tuning session; Gather, view and edit input data. Prerequisite: ITS 33476 Oracle Architecture and Administration.

Introduction to backup and recovery goals and functions,archive processing and maintaining recovery catalog,identify concepts associated with performing physical backups with or without Recovery Manager (RMAN), planning and implementing database recovery strategies,identifying and handling different types of failures, diagnosing errors, detecting corruption, recovering from loss of Recovery Catalog and Control File, and mananging standby database. Prerequisite: ITS 33477 Oracle Performance Tuning.

Comprehend and explain detailed architecture of Net8 and steps in which connections are established between peers. Implement basic connection between client and server node using various naming methods. Configure Names server, Multi-threaded Server and Connection Manager. Learn differing methods to determine network problems and security risks. Advanced Security Options (ASO) such as encryption and check summing and Utilities such as logging, tracing, and Trace Assistant. Prerequisite: ITS 33478 Oracle Backup and Recovery.

Designing and developing custom business solutions with Microsoft development tools, technologies, and platforms. Building Web-based, distributed, and commerce applications using products such as MS SQL Server, MS Visual Studio, and MS Component Services. Prerequisites: ITS 23470 A+ Core Hardware, ITS 23471 A+ Operating System Technologies, ITS 33470 Networking.

Emphasizes client/server applications using network in multi-tier architecture to distribute presentation services, business logic, and data services. Applications access different data sources and COM components contained in applications typically participated in transactions. Can be shared by multiple users and multiple applications. Prerequisite: ITS 33480 MCSD Desktop Applications with/Visual Basic.

Design and implement Web solutions with Microsoft Visual InterDev 6.0. Skills involved include analyzing business requirements, defining technical architectures, conceptual & logical design, designing user interface & user services, deriving physical design, establishing development environment, creating user and data services, testing solutions, developing Web applications, and managing Website. Prerequisite: Consent of instructor.

Identify key features of current Windows operating systems. Set up and administer user accounts; Use groups to organize user accounts and administer file and print resources; Remotely administer shared folders, monitor event logs, and backup and restore data. Prerequisites: ITS 23470 A+ Core Hardware, ITS 23471 A+ Operating System Technologies, ITS 33470 Networking or consent of instructor.

Design and implement infrastructure for business solutions based on current Windows platform and Microsoft server software. Implementation responsibilities include installing, configuring, and troubleshooting network systems. Prerequisite: ITS 33485 MS Windows Professional or ITS 23476 Configuring MS Windows Vista Client.

Install, manage, monitor, configure, and troubleshoot DNS, DHCP, Remote Access, Network Protocols, IP Routing, and WINS in a current Windows network infrastructure. Test measures skills required to manage, monitor, and troubleshoot Network Address Translation and Certificate Services. Prerequisite: ITS 33486 MS Windows Server.

Install, configure, and troubleshoot Windows Active Directory components, DNS for Active Directory, and Active Directory security solutions. Test measures skills required to manage, monitor, and optimize the desktop environment using Group Policy. Prerequisites: ITS 33486 MS Windows Server, ITS 33487 MS Windows Network Infrastructure Administration, and ITS 33488 MS Windows Directory Services Administration.

Exam addresses tasks that network managers and administrators perform when managing access and controlling overhead traffic in growing routed networks once basic connectivity has been established. Specifically, router capabilities used to control traffic over Local Area Networks (LANs) and Wide Area Networks (WANs), as well as connecting corporate networks to an Internet Service Provider (ISP). Prerequisite: ITS 23473 CCNA.

Exam addresses how to build campus networks using multilayer switching technologies over high-speed Ethernet. Explores how routing and switching technologies work together with such functions as network performance, security, or design. Prerequisite: ITS 33489 CCNP Scalable Cisco Internetworks.

Build remote access network to interconnect central sites to branch offices and home office/telecommuters. Focus on using one or more available WAN technologies, permanent or dial-up, to connect the enterprise to branch offices and telecommuters. Control access to central site and maximize bandwidth utilization over remote links. Software commands, configuration, and hardware related to establishing remote connections. Prerequisite: ITS 33490 CCNP Switching.

Advanced exploration of troubleshooting processes on Cisco routers and catalyst switches for multi-protocol client hosts and servers. Prerequisite: ITS 33491 CCNP Remote Access.

Develop skills in planning, implementing and maintaining a network infrastructure including network security, routing and remote access strategies, and planning and maintaining high server availability utilizing current Microsoft Windows network operating systems. Prerequisite: ITS 33486 MS Windows Server and ITS 33487 MS Windows Network Infrastructure Administration.

Provides student with the knowledge necessary to install, configure, manage, and maintain SQL Server 2005. Recommended prerequisite: ITS 23477 SQL Server Foundations

Course enables students new to networking technologies to understand the terms, concepts, technologies, and devices commonly used in networking.

Provides studen with the knowledge necessary to optimize and maintain database solutions. Prerequisite: ITS 34000 MS SQL Server 2005 Implementation and Maintenance.

Provides student with th eknowledge necessary to optimize, maintain, secure, troubleshoot, and design SQL Server 2005 databases. Prerequisite: ITS 34003 Design Dbase Admin SQL Server 2005.

Provides student with the knowledge necessary to implement Window-based application by using Microsoft.NET Framework 2.0. Prerequisite: ITS 23480 MS.NET Framework 2.0 Foundations Using C#.

Provides student with the knowledge necessary to implement Window-based application by using Microsoft.NET Framework 2.0. Prerequisite: ITS 23481 MS.NET Framework 2.0 Foundations Using Visual Basic.

Provides student with the knowledge necessary to develop and implement web-based applications with web forms, ASP.NET, and the .NET Framework. Prerequisite: ITS 23480 MS.NET Framework 2.0 Foundations Using C#.

Provides student with the knowledge necessary to develop and implement web-based applications with web forms, ASP.NET, and the .NET Framework. Prerequisite: ITS 23481 MS.NET Framework 2.0 Foundations Using Visual Basic.

Students learn to apply networking knowledge to the installation, configuration, and troubleshooting of Cisco switches and routers. Prerequisite: ITS 34002 Interconnecting Cisco Networking Devices Part I.

Course explores security concepts such as authentication, authorization, integrity, confidentiality, and non-repudiation. Topics include basic security concepts, services, and technologies as well as the challenges in the application, transport, and message layers of applications. Prerequisite: ITS 16163.

Course exposes students to the full range of wireless data communications standards and technologies available today. Topics include technologies from Bluetooth to satellites, as well as Wireless Personal Area Networks (WPANs), Wireless Local Area Networks (WLANs), Wireless Metropolitan Area Networks (WMANs), and Wireless Wide Area Networks (WWANs). Security aspects of each wireless technology are also explored. Prerequisite: ITS 33470.

Designed around special theories, practices or interest of an individual or group of students.

Students cover the ten security domains required to implement, design, and manage network security functions. Topics include security management, cryptography, disaster recovery planning, as well as legal and ethical issues.

Study of microcomputer and minicomputer operating systems. Topics include batch processing, concurrent processing, memory management and processor scheduling.

Practical experience in the major area of study. Arranged individually and taken after completion of the major course work.

Provides theory and application in project planning, implementation, control, and completion. Includes network planning, project evaluation and review techniques (PERT), critical path methods (CPM), management by objectives, management by exception, cost analysis, and resource allocation/leveling.

Practical experience in the major area of study, arranged individually and taken after the completion of the major course work.

Covers application of project management knowledge areas (project integration, scope, time, cost, quality, human resources, communications, risk, and procurement management) and process groups (initiating, planning, executing, controlling, and closing) to information technology projects. Prerequisites: ACC 3xxxx Survey course in Accounting, OAD 30063 Behaviors in Organizations, ITS 37044 Operating Systems, ITS 30163 Database Management or consent of instructor.

Examines adult learning theory principals including motivating adult learners, fostering adult learning programs and applying them to an eLearning environment. Also examines various forms of eLearning, benefits and drawbacks.

Database administration strategies and procedures provided in current industry accepted Oracle database platforms; Introduction to the concepts and procedures associated with Oracle architectural component; Manage an Oracle instance and use database tools; Concepts associated with storage structure components and tables; Methods for loading and reorganizing data. Concepts and tasks associated with managing security. Prerequisite: ITS 33475 Oracle SQL

Students learn to identify key features of Oracle database backup, recovery, and the architecture and administration of Oracle Net Services. Prerequisite: ITS 43031 Oracle Database Fundamentals

Implementing and administering security, including: communication security, infrastructure security, cryptography, access control, authentication, external attack and operational and organization security.

Develop skills necessary to implement various security scenarios for small, medium and large scale companies including: Managing security templates, implementing service packs and patches, configuring security for communication channels, including managing SMB, IPSec, SSL and Wireless networking security protocols, managing user access and to implement Encryption and a Public Key Infrastructure. Prerequisite: ITS 33488 MS Windows Directory Services Administration.

Analyze business requirements and design directory service architecture, including: Unified directory services such as Active Directory and Windows NT domains; Connectivity between and within systems, system components, and applications; Directory and database replication. Course measures skills required to analyze business requirements for desktop management and design solutions. Prerequisite: ITS 33488 MS Directory Services Administration.

Analyze business security requirements and design security solution, including: Controlling access to resources, Auditing access to resources; Authentication, and encryption. Prerequisite: ITS 33488 MS Windows Directory Services Administration.

Implement, administer, and troubleshoot information systems that incorporate Microsoft Exchange 2000 Server.

Focuses on designing small to medium-sized networks (fewer than 500 nodes). Identify and analyze networking needs of customer, design network structure, identify appropriate network management solutions, and develop network prototype. Prerequisite: ITS 23473 CCNA Routing and Switching.

Design and deploy messaging systems that incorporate current Microsoft Exchange messaging systems.

Introduction to Oracle relational database concepts. Use of SQL for storing, retrieving, and manipulating data in relational databases; Access data from more than one table using joins; Aggregate data using group functions, write sub-queries, and create and populate Oracle database tables; Define, maintain, and modify other database objects; Use SQL's Data Manipulation Language and transaction controls; Control both user and object level security in an Oracle database; Use basic PL/SQL. Tools and techniques to improve performance of currently accepted Oracle server platforms; Files and events supporting tuning process; Application tuning issues impacting database performance; Tuning components and functions of shared pool and buffer cache. Monitor contents and usage of Redo Log buffer. Identify: Database configuration and I/O issues; SQL operations requiring sorts. Use: Direct writes for large sorts and allocate temporary space appropriately; Oracle tools to diagnose and resolve contention. Create tuning session; Gather, view, and edit input data.

Continuation of Oracle Database 10g: Admin I-A. Prerequisite ITS 44000

Introduction to Oracle relational database concepts; Use of SQL for storing, retrieving, and manipulating data in relational database; Access data from more than one table using joins; Aggregate date using group functions, write sub-queries, and create and populate Oracle database tables; Define, maintain, and modify other database objects; Use SQL's Data Manipulation Language and transaction controls; Control both user and object level security in an Oracle database; Use basic PL/SQL.

Continuation of Oracle Database 10g: Admin II-B. Prerequisite: ITS 44002

Programming techniques using the object oriented approach in the Visual Basic.NET environment. Topics include developing user interfaces, coding, decision-making and control structures. Advanced topics of class creation and usage, accessing databases and creating web and console applications

Course exposes students to the technologies, terms, and processes related to Internet security. Topics include general security, network security, operating system security, and methods for testing security. Both UNIX and Microsoft Windows operating systems are dovered. Prerequisites: ITS 43101 and ITS 43475.

With the threats of cyber terrorism and corporate espionage increasing, the need for trained network security professionals continues to grow. This course explores penetration-testing tools and techniques that ethical hackers and security testers use to protect computer networks. Topics include discovering vulnerabilities and solutions recommended for tightening network security and protecting data from potential attackers. Prerequisite: ITS 43475.

Provides an introduction to IT infrastructure issues and covers topics related to both computer and systems architecture and communication networks. Includes an overall emphasis on the services and capabilities that IT infrastructure solutions enable in an organizational context. The course also focuses on Internet-based solutions, computer and network security, business continuity, and the role of infrastructure in regulatory compliance. Prerequisite: ITS/MIS 13063 Foundations of Information Technology.

Critical examination of information systems that support management decision-making and problem solving. Topics include information systems management, data processing systems, decision support systems, office automation, expert systems, and organizational information systems.

In-depth study of systems development life cycle. Utilizes blend of traditional development and current techniques. Systems Analyst Toolkit includes cross-phase coverage of communications, economic analysis and project management. Prerequisites: ACC 3xxxx Survey course in Accounting, OAD 30063 Behavior in Organizations, ITS 37044 Operating Systems, ITS 30163 Database Management or consent of instructor.

Introduces the logical and physical design considerations that must be addressed during the development of applications software and provides a solid background in the analysis and design of information systems. Topics include system development life cycle; structured requirements specification development; system modeling and analysis tools; and cost-benefit analysis. Prerequisite: ITS 48163 System Analysis and Design or permission of instructor.

Examination or project designed to assess the student's achievement of the goals of his/her major program.

Capstone course that guides student to emphasize various methodological approaches to software acquisition, development, testing, and implementation, and understand relevance of methodologies to Capability Model Theory, interdependence of phase deliverables, quality control techniques and methods, and tools for testing. Prerequisites: ITS 33470 Networking, OAD 30563 Management or consent of instructor.