CBIS 3501 - Web Developers

**CBIS 3501 - Web Developers**
CourseName	Description	Objectives	Duration
Introduction	Standards for ICAPP program. Expectations. A high level look at the infrastructure of the Internet and the Protocols and Systems that make it work.	1. demonstrate a knowledge of communications hardware and software architectures, including modems, protocols, data handling routines and interrupts, LANs and WANs, client/server and peer-to-peer network operating systems (3C). 2. Be able to describe the internet, the protocols, and the systems that make the Internet work. (2A) 3. Be able to perform basic commands involving FTP and understand server space and directory structures. (1A) 4. Be able to navigate and use the web effectively. (1A)	2
Hardware	A breakdown of the differences of a Workstation and a Server. Also, the physical components of a Local Area Network (LAN). This course presents a systems-level review of computing equipment and the organization of components and devices into architectural configurations.	1. Demonstrate an understanding of the role that Hardware plays in a LAN system. (2B) 2. Be able to set up a peer-to-peer network. (1B) 3. Be able to install RAM and build a computer using components. (1B) 4. Be able to install drives and know the difference in the different kinds of drives (e.g., SCSI). (1A)	5
Intro to C	Introduction to programming using C	1. Be able to design an effective and efficient program using diagramming techniques, such as flowcharts, pseudocode, or UML. 2. Understand the differences in programming languages and demonstrate familiarity with programming terminology and functionality, such as compilers, strings, arrays, loops, etc. 3. Write programs that will write to files, send e-mail, calculate summary statistics on data, and write output based on command line input (e-mail, print, etc.) 4. Be able to write well-structured, easy to maintain programs.	5
UNIX	Indepth look at the tools and functionality of an operating system using a UNIX Server (Solaris). To include, SED, AWK, VI, KSH, and Bash. How the O/S uses mounts, NIS, and directory structure. Intro to UNIX Kernal and Security issues	Be able to: 1. Use the KornShell to accomplish tasks on a UNIX system. (1A) 2. Be able to use VI and Bash commands. (1A) 3. Understand SED, AWK, KSH and the UNIX Kernal. (2B) 4. Describe security issues. (3C) 5. Be able to describe the form and function of operating systems in general. (3A) 6. Use the help facility (Man Page) of the UNIX system. (1A)	5
Data Comm	Network design, structure, optimization, and reliability. Integration of data communication and computing technologies, including POT's, ISDN, DSL, and general concepts of Cable modems and general analog modems. Focus is on data communication affecting the internet (I.e., from the gateway out).	1. Understand when to use compression, FTP, vs unaltered web retrievals: I.e., when / how to reduce network load. (2A) 2. Describe RAID and why it is important (2B) 3. Understand the relationship between customers' bandwidth capabilities and the design of the system. 4. Describe the concepts of POTs, ISDN, DSL, and general concepts of cable modems and general analog modems	4
Intro Databases	Introduction to the design and development of databases using Oracle and SQL.	1. Be able to design a well-structured database in Oracle. 2. Be able to perform queries in MySQL.	5
Web Design	Layout and design of a web site in HTML 4 to cover effective use of graphics, colors, and other media elements. Creative use of tables, frames, and cascading style sheets (CSS) for control	1. Be able to "program" a web page in HTML 4 (1A). 2. Be able to look at another's web page and understand its appearance (2B). 3. Describe in detail the interaction between HTML and the server (2A). 4. Describe the differences between browsers in their treatment of HTML. 5. Demonstrate, by web page development, an awareness of how design affects speed and performance (1A). 6. Be able to follow standards for software design (Scott Helms is to provide standards).	10
HTML with JavaScripting	In-depth course on advanced HTML coding and JavaScript. The course will focus on providing interactivity through JavaScripting. Learn how to use Cookies effectively and securely	1. Be able to write the JavaScript which will enable a web page to "talk to" a CGI and manipulate the web environment. 2. Be able to look at others' JavaScript, understand and modify it to meet new requirements. 3. Understand and develop Cookies.	15
Java Applets	Intro to JAVA programming language and its use on the Web as an Applet	1. Be able to develop Java Applets such as (ISPA to give examples). 2. Describe web push technology and build a "push" web system, such as a news serve system.	10
Perl	A hands-on course in PERL 5 focusing on both System Administration and CGI applications. Should also include use of modules and PERL as an Object Oriented language.	1. Understand the following in Perl: scalar data, arrays, basic IO, file handling, directory access, process management, system database access, and CGI programming. 2. Understand objects, classes, and inheritance. 3. Develop and use utility programs written in Perl.	12
Systems Analysis for Web Developers	Introduction to the concepts of systems analysis and the importance of analysis and design to the effectiveness of web-based or other systems.	1. Be able to apply concepts of systems analysis to an e-commerce system.	2
Advanced Database Design	The creation, population, and use of Oracle and MySQL focusing on using them in a web application environment. Database, including security, for E-commerce sites, is the focus of the course.	1. Understand performance issues in database design and queries. 2. Develop a small web application that can insert, retrieve, update, and delete records effectively from an Oracle database. 3. Be able to use MySQL through the web for data retrieval. 4. Set up and configure Oracle and MySQL on a UNIX Server. 5. Be able to create secure accounts and proper permissions for secure sharing.	10
Java	Advanced topics course in JAVA focusing on servlets, database connectivity (JDBC), and JAVA server pages (JAVA Servlet 2.2 and JavaServer Pages 1.1).	Course Objectives for JAVA: 1. Present dynamic content through the use of servlets. 2. Be able to perform SQL queries through the servlet using JDBC. 3. Construction of a basic E-Commerce application built entirely in JAVA Server Pages.	16
Web Developer final project	Advanced programming that will culminate in the construction of an original E-Commerce system	1. Use the proper mix of languages (C, Perl, Java) and web technology (HTML, JavaScript, Applets) to develop a working E-Commerce site. The E-Commerce site should include the updating of a database.	5