Computer Technology - System Administration Track
Computer Technology - System Administration Track
Computer Technology - System Administration Track
Outcomes
Upon successful completion of the Associate Degree in Computer Technology System Administration Track, the graduate will be able to:
Install, maintain, upgrade and manage both Linux and Windows based computer and related server and network systems. Administer computer, network and web services and security. Conduct system performance analysis, tuning, and capacity planning. Apply computer program scripting knowledge to automate system tasks. Provide entry level computer programming. Apply and integrate the basic knowledge attained in server, networking, computer programming, scripting, web and database technologies to develop business solutions. Understand mathematics, through calculus, and the ability to apply this knowledge to solve computer related problems. Effectively communicate technical observations, results, issues, and successes, in both oral and written form. Continue education toward a BS degree in four-year system administration and related programs. Recognize the need for, and develop the ability to engage in, lifelong learning. Understand professional, ethical, and social responsibilities.
Curriculum
Students receive a solid foundation in computer concepts, operating systems, server administration, networking, computer programming and mathematics through calculus. They receive training in both Linux and Windows system administration, introductory C++ programming, Java programming, and exposure to scripting and contemporary programming languages. Exposure to web design and database management is also provided. Humanities, social sciences, and English courses round out the curriculum to ensure that graduates possess a broad social understanding and effective communication skills.
Facilities
The Computer Technologies Department facilities include more than 72 computer workstations in four classroom laboratory settings, a computer sand box equipped with servers, 18 workstations and networking equipment for hands-on server administration and data communications courses, and a computer diagnostics laboratory. All computer rooms are equipped with up-to-date software and dual operating system environments, where necessary, to provide all students with hands-on computer programming, installation, server administration and networking capabilities for their learning. The computer diagnostics laboratory provides the students with the necessary equipment to perform hardware and software troubleshooting.
Faculty
Chair: Larson Rogers Instructor staff: Richard Azzi, Vivian Hatziyannis, Mozhgan Hosseinpour
42
COMPUTER TECHNOLOGIES
Course # CT111 CT121 CT134 CT143 CT146 CT247 CT261 CT231 CT233 CT218 CT263 CT249
Credits 4 3
Class 3 2 2 3 3 3 3 2 2 2 3 3 Class 3 3 3 3 3 3 4 4
Lab 2 2 2 2 2 2 2 2 2 2 2 2 Lab 0 0 0 0 0 0 0 0
Computer Concepts Web Design I: HTML and Dreamweaver Introduction to Programming Logic and C++ College Composition I College Algebra and Trigonometry Introduction to Operating Systems with Linux Java Programming Database Management Systems College Composition II Pre-Calculus Linux System Administration Advanced Java Programming Data Communications and Networking Technical Communication Calculus I Windows System Administration Survey of Contemporary Programming Languages Applied Networking Calculus II Elective
Introduction to Operating Systems with Linux 3 Introduction to Programming Logic and C++ Java Programming Advanced Java Programming Data Communications and Networking Linux System Administration Windows System Administration Database Management Systems Applied Networking Survey of Contemporary Programming Languages Course Title College Composition I College Composition II Technical Communication Humanities/Social Science Req. College Algebra and Trigonometry Pre-Calculus Calculus I Calculus II 4 4 4 4 3 3 3 4 4 Credits 3 3 3 3 3 3 4 4
43
COMPUTER TECHNOLOGIES
Outcomes
Upon successful completion of the Associate Degree in Computer Technology Applied Technology Track, the graduate will be able to:
Analyze, troubleshoot, and solve computer hardware and software problems. Employ hardware/software knowledge to configure, install and maintain computer and network systems. Design and develop websites using contemporary web design software. Design and develop entry-level database application systems. Understand and apply the fundamental knowledge of mathematics to solving of computer related problems. Effectively communicate technical observations, results, issues, and successes, in both oral and written form. Successfully pass the CompTIA A+ Essentials/IT Technician and Cisco CCENT certification exams. Continue education toward a BS degree in related four-year computer technology programs. Recognize the need for, and develop the ability to engage in, lifelong learning. Understand professional, ethical, and social responsibilities.
Curriculum
Students receive a solid foundation in computer concepts, PC diagnostics and management, web and database technologies, networking and mathematics through pre-calculus. Humanities, social sciences and English courses round out the curriculum to ensure that graduates possess a broad social understanding and effective communication skills. Upon successful completion of this program students should have the necessary preparation for CompTIA A+ Essentials/IT Technician and Cisco CCENT (Cisco Certified Entry Networking Technician) certifications.
Facilities
The Computer Technologies Department facilities include more than 72 computer workstations in four classroom laboratory settings, a computer sand box equipped with servers, 18 workstations and networking equipment for hands-on server administration and data communications courses, and a computer diagnostics laboratory. All computer rooms are equipped with up-to-date software and dual operating system environments, where necessary, to provide all students with hands-on computer programming, installation, server administration and networking capabilities for their learning. The computer diagnostics laboratory provides the students with the necessary equipment to perform hardware and software troubleshooting.
Faculty
Chair: Larson Rogers Instructor staff: Richard Azzi, Vivian Hatziyannis, Mozhgan Hosseinpour
44
COMPUTER TECHNOLOGIES
Course # CT111 CT121 CT122 CT134 CT145 CT211 CT212 CT218 CT217 CT221 CT245 CT271 CT273 Course # EN130 EN140 EN320 HU/SS MA105 MA120 MA130
Course Title Computer Concepts Web Design I: HTML and Dreamweaver Web Design II: Adobe Flash
Credits 4 3 3
Lecture 3 2 2 2 3 3 1 2 1 2 3 3 3 Lecture 3 3 3 3 3 3 3
Lab 2 2 2 2 2 2 4 2 2 2 2 2 2 Lab 0 0 0 0 0 0 0
Computer Concepts Web Design I: HTML and Dreamweaver Survey of Computer Programming Languages College Composition I Technical Mathematics I Introduction to Operating Systems with Linux PC Maintenance & Management Web Design II: Adobe Flash College Composition II College Algebra and Trigonometry Web Site Management Database Management Systems Introduction to Networking Technical Communication Pre-Calculus CompTIA A+ Certification Preparation Enterprise Database Management Introduction to Game Programming Routing Basics Elective
Introduction to Operating Systems with Linux 3 Survey of Computer Programming Languages Web Site Management PC Maintenance and Management Database Management Systems CompTIA A+ Certification Preparation Enterprise Database Management Introduction to Networking Routing Basics Course Title College Composition I College Composition II Technical Communication Humanities/Social Science Req. Technical Mathematics I College Algebra and Trigonometry Pre-Calculus 4 3 3 3 2 3 4 4 Credits 3 3 3 3 3 3 3
45
COMPUTER TECHNOLOGIES
Curriculum
The curriculum is structured to provide a broad undergraduate education with students taking courses in each of the recognized areas of computer concepts and architecture, processors, network systems, digital circuits, analog circuits, and electronic principles. A strong foundation in physics and mathematics through calculus is provided so as to provide the student with a strong engineering foundation. The students education is rounded off with an emphasis in the humanities and social sciences, which allow students to develop their written and oral presentation skills, promoting lifelong learning. The curricula of many four-year college programs in Computer Engineering Technology are the same as their Electronic Engineering Technology programs during the first two years of study and are strongly hardware and electronics centered. Therefore the curriculum of this Computer Engineering technology program mirrors our Electronic Engineering Technology program, except for two data communications/ networking courses. Prospective students interested in this program should also examine the Electronic Engineering Technology program description in this catalog for additional description of the curriculum.
Outcomes
Upon successful completion of the Associate Degree in Computer Engineering Technology, the graduate will be able to:
Analyze or troubleshoot in three major electronic engineering areas: Analog Circuits, Digital Circuits, and Processors. Recognize and apply fundamental knowledge of mathematics, especially algebra and trigonometry. Conduct experiments in teams, building or breadboarding, using basic test equipment and tools to measure performance, and to critically analyze and interpret data. Effectively communicate technical observations, results, issues, and successes or negotiate a change in design or procedure. Effectively discuss and communicate computer architecture, networking and electronics concepts. Apply computer skills to prepare technical documents or analyze data: using applications for word processing, spreadsheets, simple programming, schematic capture, and simulation. Calculate costs. Read manuals and schematics and identify components on a printed wiring board. Apply proper laboratory procedures.
Facilities
This program utilizes facilities from both the Computer Technologies and Electronics Engineering Technology departments. The Computer Technologies Department facilities include more than 72 computer workstations in four classroom laboratory settings, a computer sand box equipped with servers, 18 workstations and networking equipment for hands-on server administration and data communications courses, and a computer diagnostics laboratory. All computer rooms are equipped with up-to-date software and dual operating system environments, where necessary, to provide all students with hands-on computer programming, installation, server administration and networking capabilities for their learning. The computer diagnostics laboratory provides the students with the necessary equipment to perform hardware and software troubleshooting.
Faculty
EE designated courses are taught by faculty identified in the Electronic Engineering Technology program description, while CT designated courses are taught by faculty identified in the Computer Technology program description.
46
COMPUTER TECHNOLOGIES
Course # EE101 CT143 EE110 EE113 EE122 EE223 EE131 CT261 EE240 CT263
Course Title Intro. to Electro-Mechanical Systems Introduction to Programming Logic and C++ DC Circuits AC Circuits Electronics I Electronics II Digital Principles Data Communications and Networking Embedded Processors Applied Networking
Credits 3 4 4 4 4 4 4 4 4 4
Lecture 2 3 3 3 3 3 3 3 3 3
Lab 2 2 2 2 2 2 2 2 2 2
EE101 EE110 EE131 EN130 MA120 CT143 EE113 EE122 EN140 MA130 EE223 CT261 EN320 MA240 PH222 EN215 CT263 EE240 MA250 PH223 PH225 HU/SS
Intro. to Electro-Mechanical Systems DC Circuits Digital Principles College Composition I College Algebra and Trigonometry Introduction to Programming Logic and C++ AC Circuits Electronics I College Composition II Pre-Calculus Electronics II Data Communications & Networking Technical Communications Calculus I University Physics I Physics Lab I Applied Networking Embedded Processors Calculus II University Physics II Physics Lab II Elective
SECOND SEMESTER
THIRD SEMESTER
Course # EN130 EN140 EN320 HU/SS MA120 MA130 MA240 MA250 PH222 PH215 PH223 PH225
Credits 3 3 3 3 3 3 4 4 3 1 3 1
FOURTH SEMESTER
College Algebra and Trigonometry Pre-Calculus Calculus I Calculus II University Physics I Physics Lab I University Physics II Physics Lab II
47
COMPUTER TECHNOLOGIES
Course Descriptions
CT111 COMPUTER CONCEPTS 4 CREDITS CT145 SURVEY OF COMPUTER PROGRAMMING LANGUAGES 4 CREDITS
This course presents a comprehensive look at computer architecture, including the system unit, memory, input/output and storage devices. Personal computers are utilized in a laboratory setting to provide students with hands-on exposure to hardware components. Students are introduced to the M/S Windows Operating System and how the hardware and software work together. An in-depth look at the motherboard, memory management and storage devices is included. Other topics include the application of M/S Word and Excel to prepare lab reports, an introduction to the Internet and an understanding of information literacy through the use of various Internet search engines. The course concludes with a discussion of computer ethics and social issues.
CT121 WEB DESIGN I: HTML AND DREAMWEAVER 3 CREDITS
This course introduces students to the basic concepts of three of the most popular computer languages in use today: Visual Basic, C++, and Java. Students will work with various languages to gain an understanding of the differences that exist among them. This course assumes no programming experience. Knowledge of basic computer operations, such as how to use a mouse and how to manipulate windows and menus, is required.
CT146 JAVA PROGRAMMING 4 CREDITS
Students learn how to design and develop Web sites using HTML and Dreamweaver. Students will create Web pages utilizing forms, frames, cascading work sheets, links and images. Students will reinforce the skills learned in this course through the design, development and publishing of their own website.
CT122 WEB DESIGN II: ADOBE FLASH 3 CREDITS
Building on the students exposure to procedural logic and programming in CT143, this course introduces the student to object oriented thinking and programming using Java. Students learn about the fundamental constructs of the Java programming language using control structures first, followed by objects. The course begins with the fundamentals of data types, decision structures, loops and files. Students create methods and objects from the standard library classes and follow this by writing their own classes and developing simple GUI applications. This is followed by arrays and a series of more advanced class and object topics including inheritance, polymorphism and exception handling. Prerequisite: CT143
CT211 WEB SITE MANAGEMENT 3 CREDITS
This course introduces the student to the tools and features available in Adobe Flash to create more dynamic and interactive web pages. Topics covered include drawing objects, symbols, interactivity, animation and the creation of special effects. Students will plan and create their own website using Adobe Flash features. Prerequisite: CT121
CT134 INTRODUCTION TO OPERATING SYSTEMS WITH LINUX 3 CREDITS
This course introduces the student to the major concepts and principles of the Linux Operating System. Topics covered include the Linux file system and directory management, pipes, redirection, the vi editor, the Bash Shell, user controlled security, and Unix/Linux utilities. Shell scripting is introduced and the X Windows Environment is explored. Students will apply covered topics through hands-on lab assignments. Prerequisite: CT111
CT143 INTRODUCTION TO PROGRAMMING LOGIC AND C++ 4 CREDITS
Students explore the services necessary for the administration and management of a website. Topics covered include the planning, configuration and the installation of a website. Students will examine what is needed to implement and support a web server, research industry web server products, understand how to create domains and perform domain name search, explore performance monitoring and optimization techniques, and explore technical support and security issues. The course concludes with a look at website advertising and marketing considerations. Prerequisite: CT122
CT212 PC MAINTENANCE AND MANAGEMENT 3 CREDITS
This course is an introduction to problem solving and program design using the procedural aspects of the C++ programming language. Students are introduced to programming logic and design using flowcharts and algorithm development. The fundamentals of the C++ programming language are then introduced with the student expected to apply the programming and logic design methodology in solving and programming problems. The Microsoft Visual C++ Integrated Development Environment is used as the primary development tool.
48
BENJAMIN FRANKLIN INSTITUTE OF TECHNOLOGY
This course provides advanced coverage of the internal components of a personal computer system, from the processor to the keyboard to the video display. The course focuses on troubleshooting and diagnostics and starts off with diagnostic tools, operating system software and troubleshooting, as well as data recovery. This course also instructs the student in troubleshooting the kind of hardware problems that can make PC upgrade and repair difficult. Prerequisite: CT111
COMPUTER TECHNOLOGIES
CT217
2 CREDITS
CT233
3 CREDITS
This course allows the student to apply his/her knowledge from the PC Maintenance and Management and other program courses to prepare for the CompTIA A+ Essentials 220-601 and A+ IT Technician 220-602 exams. Practice test software and lab facilities are made available for the student to take practice exams and to review the CompTIA A+ Essentials and IT Technician recommended objectives. At the completion of this course the student should be ready to take the actual CompTIA A+ Essentials and IT Technician exams. CompTIA A+ certification confirms a technicians ability to perform tasks such as installation, configuration, diagnosing, preventive maintenance and basic networking, and confirms that the holder has the ability to get the job done right. It is an international, vendor-neutral certification recognized by major hardware and software vendors, distributors and resellers. Prerequisites: CT111, CT134, CT212, CT271
CT218 DATABASE MANAGEMENT SYSTEMS 3 CREDITS
This course provides the student with the knowledge and skills necessary to install, configure, and support Microsoft Windows servers. Topics covered include system administration procedures, configuring disks, users, groups, Remote Desktop, hardware, and printing and network connectivity. Students will be exposed to the Windows Power Shell command line and scripting environment, as well as optimization and troubleshooting techniques. Prerequisite: CT134
CT242 JAVA OBJECT PROGRAMMING 4 CREDITS
This course provides a comprehensive introduction to the Java programming language. Students utilize the object-oriented features and main classes of the language to build a wide variety of Java applications and applets. In addition to object-oriented programming and classes, topics covered include flow control, streams, threads, packages, graphics and animation. Prerequisite: CT144
CT245 INTRODUCTION TO GAME PROGRAMMING 4 CREDITS
This course introduces students to the fundamental processes of developing, implementing and maintaining a database system. Various database models are studied with a focus on issues related to the fundamental concepts of the relational model. Using the ACCESS database management system, students learn to create, query and maintain a database and to create forms, reports, and combo boxes with an emphasis on the fundamentals of the Structured Query Language, SQL. Web features are used to publish to the Internet and an application system is created using Macros and Object Linking and Embedding (OLE). Prerequisites: CT111 and CT143 or CT145
CT221 ENTERPRISE DATABASE MANAGEMENT 3 CREDITS
This course is an introduction to computer/video game programming. The student is exposed to the different elements that comprise game programming, including computer graphics, artificial intelligence, algorithms, data structures, networking and human-computer interaction. Topics include the game engine, sound, rendering, modeling, and the user-interface. Prerequisite: CT145 or CT143
CT247 ADVANCED JAVA PROGRAMMING 4 CREDITS
Provides students with an understanding of the issues in managing enterprise database systems as an essential organizational resource. Topics include the enterprise data architecture components, data storage configurations, and information retrieval methods. Expands from the relational model to the multidimensional model, object-relational techniques, and Web-accessed data. Prerequisite: CT218
CT231 LINUX SYSTEM ADMINISTRATION 3 CREDITS
This course is a continuation of CT146 Java Programming, covering some of the advanced features of the Java programming language. Topics include graphics, applets, files and streams, networking and communication, data structures, Java utilities, database connectivity, Servlets, Java Server Pages and Events. Prerequisite: CT146
CT249 SURVEY OF CONTEMPORARY PROGRAMMING LANGUAGES 4 CREDITS
This course introduces the Linux file system, group administration, and system hardware controls. Topics include installation, creation and maintaining file systems, NIS client and DHCP client configuration, NFS, SMB/Samba, Configure X-Windows, Gnome, KDE, basic memory, processes and security. Students will write shell scripts and constructs to enhance and automate system administration activities, and, upon course completion, will be able to perform all system administration tasks including installation, configuring and attaching a new Linux workstation to an existing network. Prerequisite: CT134
This course looks at some of the more contemporary programming and scripting languages. Languages examined include Perl (Practical Extraction and Report Language), Python, ASP (Active Server Pages), ASP.Net, VBScript, Ruby, Linux Shell Scripting and C# (C Sharp). Students write programs using all languages and examine the situations for which the different languages are best suited. Prerequisite: CT146
49
COMPUTER TECHNOLOGIES
CT261
4 CREDITS
CT273
ROUTING BASICS
4 CREDITS
This course provides students with an in-depth understanding of the planning, design, implementation, and operation of wired and wireless LANs (Local Area Networks). The course provides hands-on experience with end-user networking appliances such as wireless routers and switches. The course focuses on the LAN as a conduit for personal computers to intercommunicate and access the Internet. The course will help students understand issues related to computers and general networking principles. The course will pay special attention to the end terminal network, switches, wired and wireless routers, the components of a network, and the roles each component plays in a home and in a business. The course will prepare students to build and operate a small LAN at home or in the workplace. Prerequisite: CT111
CT263 APPLIED NETWORKING 4 CREDITS
This course, a continuation of Introduction to Networking, is the second of two courses leading to the Cisco Certified (CCENT) designation. It introduces the student to routing and router configuration design and management using the engineering design model described in the Mass DOE Technology framework. It covers the architecture, components, and operation of routers, along with the principles of routing and routing protocols. With the completion of CT271 Introduction to Networking and this course, students should be able to install and configure Cisco switches and routers in multiprotocol internetworks using LAN and WAN interfaces, provide Level 1 troubleshooting service, improve network performance and security, and perform entry level tasks in the planning, installation, operation, and troubleshooting of Ethernet and TCP/IP networks. Prerequisite:CT271
This course continues and builds upon the hands-on laboratory work in CT261. It focuses on the design and implementation of state-of-the-art network architectures and solutions for enterprise networks. It provides an in-depth hands-on coverage of protocols and network technologies that are essential for building corporate infrastructures and seamlessly integrating them with the Internet. Special attention is paid to essential characteristics of high-quality e-business environments, such as scalability, reliability, and security. Hands-on laboratory work will be done on industry leading Cisco routers and switches. Students will develop and build small enterprise class networks. Prerequisite: CT261
CT271 INTRODUCTION TO NETWORKING 4 CREDITS
This course is the first of two courses leading to the Cisco Certified (CCENT) designation. Students are introduced to computer networking concepts using the TCP/IP and OSI networking models. Topics covered include the TCP/IP application, transport, Internet and network access layers, and the OSI layers and their functions. The fundamentals of LANs, including Ethernet data link protocols and basic cabling, are covered. This course uses a practical, technical introduction to computer networking and provides a thorough foundation through concept mastery and hands on activities. Prerequisite:CT111
50