Advanced Diploma in Internet Application Developer (IAD)
The IAD
program is a three-year career-directed program designed to prepare
students for rewarding career in traditional and Internet software
development. Work in this emerging field requires a sound knowledge of
client and server technologies, Web page design, scripting and
server-side programming, Web development languages and tools, database
design, security, networking and the design and development of
database-driven enterprise Internet applications. The web-centric IAD
program provides graduates with these skills.
Graduates of the IAD program have hands-on experience in various aspects of modern Internet applications from the underlying server technology to the implementation of database transaction systems. Internet concepts are integrated into all courses across the curriculum and focus on the development of dynamic database-driven web applications.
Semester 1
|
Course Number |
Credit Hours |
Course Name |
|
4 |
Programming Concepts |
|
|
3 |
Communications I |
|
|
3 |
IT Skills for Technology |
|
|
3 |
Business Mathematics I |
|
|
1 |
College Orientation |
|
| DBD111 |
4 |
Database Fundamentals |
|
4 |
Web Development I |
Semester 2
|
Course Number |
Credit Hours |
Course Name |
|
4 |
SQL Application Development |
|
|
4 |
Business Applications with RPG IV |
|
|
3 |
Communication for Technology |
|
|
4 |
Web Development II |
|
|
4 |
XML |
Semester 3
|
Course Number |
Credit Hours |
Course Name |
|
4 |
Accounting Concepts I |
|
|
4 |
Java Programming |
|
|
GED001 |
3 |
General Education Elective |
|
4 |
Operating Systems |
|
|
4 |
Network System Administration |
Semester 4
|
Course Number |
Credit Hours |
Course Name |
|
1 |
Job Search and Success |
|
|
3 |
Organizational Behaviour |
|
|
4 |
Web Server Administration and Security |
|
|
3 |
Fundamentals of Business Statistics |
|
|
3 |
Internet and E-Commerce |
|
|
4 |
Server-Side Java Development |
Semester 5
|
Course Number |
Credit Hours |
Course Name |
|
4 |
Windows Applications Using .NET |
|
|
GED002 |
3 |
General Education Elective |
|
4 |
Workplace Collaboration |
|
|
4 |
Systems Analysis and Design |
|
|
4 |
CGI Web Applications |
Semester 6
|
Course Number |
Credit Hours |
Course Name |
|
GED003 |
3 |
General Education Elective |
|
4 |
Programming with PHP |
|
|
4 |
Emerging Web Technologies |
|
|
4 |
Web Applications Using .NET |
|
|
6 |
Integrated Project |
SDV-100:
College Orientation
Prerequisite: NIL
This course surveys the ideas, strategies and skills that a beginning
student can use to be successful in college. Personal and study skills
are discussed together with a description of college resources and
services that are useful to the student. Weekly assignments must be
completed. Access to a computer at home or at the college is required.
Students have access to college computers when they sign up for this or
any college course. SDV is a requirement for most Lambton College
programs.
DEV-112:Programming
logic and problem solving
Software
development skills are learned but soon forgotten. This course provides
the necessary fundamentals in programming logic and problem solving,
helps develop skills in the use and application of problem-solving
tools, helps develop skills in the use of application development tools
and provides the foundation and understanding of application development
concepts through the use of a high-level language.
Prerequisite: Entry Level
ITS-101: ITS
Skills for Technology
Prerequisite: NIL
An introductory personal computer applications course. Topics include
operating systems, word processing, e-mail, Internet access, and
spreadsheets. Emphasis is placed on the use of spreadsheets
ENG-111:Communications I
This
is a writing course focusing on expository writings. Basic editing
principles are covered and applied to all writing. Selected essays are
read and examined as examples of the expository styles to improve
grammar skills and essay writing.
MTH-122: Business Mathematics I
This is a
course in the mathematical concepts needed for success in the modern
business world. We will examine the computation of percentages, ratios
and proportions; laws of exponents; algebraic manipulation and solution
of equations and equation systems; plotting, graphing and reading of
descriptive charts.
WEB-113: Web Development I
This
course introduces the basics of Web page creation and other aspects of
Web site development. In this course, students (1) gain experience
developing Web pages using XHTML (Extensible Hypertext Markup Language);
(2) learn how to use Cascading Style Sheets (CSS) to enhance the
presentation of Web pages; (3) are introduced to JavaScript, the primary
client-side scripting language on the Internet; and (4) gain experience
with the Eclipse Integrated Development Environment (IDE) to develop Web
pages. Students design and implement a Web site that is deployed to a
"live" HTTP server that can be accessed on the Internet. Completion of
this course involves a fair amount of lab work.
DBD-221: SQL Application Development
This
course introduces the student to SQL (Structured Query Language) using
an industry standard database management system. Students are introduced
to SQL topics including Data Definition Language, Data Management
Language, data redundancy, data independence, database security,
database constraints, journaling, commitment control, stored procedures,
and triggers. Students are also introduced to testing and debugging
techniques. Completion of this course involves a fair amount of lab
work.
Prerequisites: DEV 111-4
DEV-222: Business Applications with RPG IV
Students expand their critical thinking skills through the development
of real-life computer applications. This course is oriented towards
business application development where students analyze problems and
design and implement appropriate solutions. The RPG IV language is used
to develop enterprise business applications that include modular
techniques such as functions, and procedures, random processing of
database files, array processing, and GUI inter-active applications.
Program development is exercised through lab assignments that include
understanding the problem to be solved, designing the program, writing
the program, and testing the program. The concepts and skills learned in
this course are transferable to a wide variety of languages. Completion
of this course involves a fair amount of lab work.
Prerequisites: DBD 111-4 & DEV 112-4
ENG-217: Communication for Technology
This
course introduces communication in technical settings. Students will
write and edit letters, memos, e-mails, manuals and short informal
reports. Students will present orally.
WEB-223: Web Development II
This
course is a continuation of Web Development I. In this course, students
gain experience in using advanced features of JavaScript. Students are
also introduced to several graphics design tools that can be used to
enhance a Web site. Students complete the Web site started in WEB 113-4
that is deployed to a "live" HTTP server that can be accessed on the
Internet.
Prerequisites: WEB 113-4
WEB-224: XML
XML is a
key technology for connecting Web applications with existing business
logic and data. The appeal of XML is that it offers a cross-platform
method for describing data that can be integrated with a wide variety of
development methodologies. Students learn how companies’ share and
access data through the development of XML (eXtensible Markup Language)
Web based applications. Topics include: XML content markup, utilization
of Cascading Style Sheets (CSS), adaptive content with XSLT, Document
Object Model (DOM) navigation and utilization, XML DTDs, XML schemas,
using XML for application development and structuring content for
information management. Students create XML documents from a database,
and work with XML documents on the database server. Completion of this
course involves a fair amount of lab work.
Prerequisites: WEB 113-4
ACC-109: Accounting Concepts I
An
introduction to the theory of accounting and the standard methods of
record-keeping. Generally accepted accounting principles and concepts
are emphasized in the preparation of financial statements (after
adjustments) and control procedures over cash.
DEV-332: Java Programming
This
course is a practical introduction to application development using
Java. Topics include: (1) the object-oriented approach to application
development including modeling with UML; (2) elements of the Java
environment including object-oriented design, encapsulation, object
interfaces, inheritance, aggregation, abstract classes, polymorphism,
and data structures; (3); identifying the Main method, Keywords and
Identifiers in Java; (4) designing and coding a Java Class, adding
Methods to the Class, using Constructors and Inheritance to extend the
class; (5) designing and coding Java applications; (6) analyzing and
responding appropriately to error messages and using basic exception
handling to catch the exceptions in a program; (7) designing Java
programs to meet a specification. Completion of this course involves a
fair amount of lab work.
NET-131: Operating Systems
Students get an applied introduction to operating systems. Students
learn why operating systems are needed and what, at a functional level,
they do. Topics include: components of a modern operating system, system
resources, memory and processor management, communicating with the
operating system, device management, file systems, system administration
virtual machines, and security. Students work through hands-on lab
assignments to get a practical understanding of several modern operating
systems. Completion of this course involves a fair amount of lab work.
NET-132: Network System Administration
Students are exposed to fundamental networking concepts. Topics include
network architecture and standards, networking protocols, TCP/IP
configuration, network performance tuning, and inter-networking.
Emphasis is on how to design, select, implement, and operate a network.
Activities include identifying network hardware and software options;
work-station, LAN, and connectivity using TCP/IP; and demonstrating the
functionality of a computer network. Comparisons of current LAN systems
are presented. Concepts associated with wireless networking are also
discussed. Prerequisites: Entry Level
MAN-116:
Organizational Behaviour
This course involves how to work effectively with others
in the context of an organizational setting. It is about people working
together to achieve their own goals and those of the organization.
NET-242: Web Server Administration and Security
Students are introduced to the knowledge and skills required for
installing, configuring and administering Web servers. Topics include
the installation, configuration and troubleshooting of a Web server,
including TCP/IP, Mail and News services, Web Services, FTP Services,
Video Streaming, password authentication on different platforms (such as
Windows and Linux) and the different protocols associated with the
services. This course also explores how to implement the different
levels of security available in a network environment using technologies
such as Proxy servers, Firewalls, Secure Socket Layer (SSL)
technologies, and others. Mention is made of E-Commerce technologies and
how their security mechanisms are implemented. Prerequisites: NET 132-4
WEB-145: Internet
and E-Commerce
This
course explores and examines the multiple facets of the business –
Internet relationship. Beginning with an overview of e-commerce, the
course examines various business models for exploiting the internet,
methods for con-ducting on-line commerce and integrating it into the
business operation, and effective internet marketing and customer
relationship management strategies and techniques. This course explores
current security and privacy issues on the Internet and how the
challenges may be met.
Prerequisites: Entry Level
WEB-442:
Server-Side Java Development
This
course is a practical introduction to developing Enterprise Java
applications using associated productivity tools. This course presents
server-side Java technologies including Java Beans, Java Database
Connectivity (JDBC), and server-side development with servlets and Java
Server pages (JSPs). Java Server Faces (JSFs) and Service Data Objects (SDOs)
are also used to simplify the building of data-centric Web applications.
Students use the Eclipse IDE to build and test Java based e-business
applications that are published to a Web server. Students work in teams
to de-sign and implement a Web application that is deployed to a "live"
HTTP enterprise server. Completion of this course involves a fair amount
of lab work. Prerequisites: DEV 332-4
DEV-356: Windows Applications Using .NET
.NET
is the technology used by many developers working on the Windows
platform. This course uses an application-driven tutorial approach to
introduce students to Visual Basic .NET for the development of GUI
Windows applications. Students are introduced to the Visual Studio .NET
IDE for creating and running .NET applications on Windows. Completion of
this course involves a fair amount of lab work. Prerequisites: DBD 221-4
SYS-355: Workplace Collaboration
Effective collaboration among people, teams, and organizations is a key
to achieving and maintaining competitive advantage. This course provides
an introduction to Lotus Notes; an extensive look at developing
applications using Domino Designer including issues involving extending
a Domino application to work on the Web; an overview of Domino
Administrator; and a look at configuring Domino on the server and using
Domino to access remote server databases. Students use Lotus Notes Web
technology running on a Domino server to integrate people with
information and business processes through an integrated collaborative
environment. Students explore the Web content management process from
content authoring, workflow, management, integration and delivery.
Prerequisites: DBD 221-4
SYS-454: Systems Analysis and Design
Students study the system development life cycle, emphasizing the
investigation, planning and analysis, and design phases. Systems
implementation and support are also discussed. Emphasis is on tools for
describing data flow, data structure, process flow, and program
specifications used to design and document information systems. The
course includes coverage of other important skills such as data
gathering, reporting, project management, and cost/benefit analysis.
Students learn how to model and design system requirements using tools
such as Unified Modeling Language (UML), use cases and scenarios, class
diagrams and sequence diagrams. Prerequisites: DBD 221-4 and one of DEV
332-4 or DEV 356-4
WEB-352: CGI Web Applications
This
course explores server-side Web applications using CGI and one or more
scripting languages. This course pro-vides an in-depth understanding and
hands-on knowledge of the capabilities of the Internet communications
protocol CGI (Common Gateway Interface). In this course, students learn
about the specifications of theCGI protocol, details regarding its
operation, and security issues related to CGI applications, Students
develop Web applications that sup-port transaction processing to
databases. Students use CGI with a server-side programming language to
develop Web applications that manipulate a database. Completion of this
course involves a fair amount of lab work.
Prerequisites: DEV 221-4 & DBD 221-4
WEB-361: Programming with PHP
This
course focuses on the technologies popular with the Linux operating
system and PHP, a server-side scripting language used to develop Web
based applications, This course (1) examines Linux operating system
concepts; (2) explores the installation and configuration of the Apache
web server; (3) provides students with the skills and knowledge required
to create and maintain commercial-quality Web applications using PHP;
(4) while leveraging the power of an SQL database (mySQL); and (5)
provides coverage of Linux-specific Internet-related security is-sues.
Completion of this course involves a fair amount of lab work.
Prerequisites: DBD 221-4
WEB-362: Emerging Web Technologies
This
course provides an opportunity to discuss and work with emerging Web
technologies. This course may vary yearly as various offerings are
selected.
Prerequisites: DBD 221-4
WEB-466: Web Applications Using .NET
This
is an advanced course that uses an application-driven tutorial approach
to address the skills needed to develop feature-rich database-driven Web
applications. The course continues with ASP.NET server-side development
using the Visual Basic .NET language. ADO.NET will be used for database
access, and technology such as XML Web Services will also be covered.
Installation and configuration of IIS (Internet Information Server) is
studied, as will Windows-specific Internet-related security issues.
Completion of this course involves a fair amount of lab work.
Prerequisites: DEV 356-4
WEB-500: Integrated Project
This
is a part of a two-semester capstone project where students working in a
team environment apply sound application development principles in the
design and implementation of a major web-related project. Course SYS 454
in semester five emphases the processes required in identifying a client
business that needs a Web-based application. Students expand their
project management skills while carrying out requirements gathering,
analysis, design, and implementation planning for the identified system.
Project management concepts include scope development and management,
creation of work breakdown structures, resourcing and estimating,
network diagrams and dependencies, tracking against a baseline, and cost
benefit analysis using return on investment and payback. Students use a
modeling tool to create a software model of the system and then go on to
implement the system in semester six. In semester six, students
implement the Web-application designed in semester five. This includes
the use of Web development tools, a Web development language, database,
publishing to a "live" Web application server, and any other technique
needed to complete the system. In this course, students have an
opportunity to sharpen their skills while using knowledge and techniques
learned from previous courses. Class environment simulates that of a
typical systems department. Students work in teams under the direction
of a faculty advisor. The projects undertaken are conceived either
internally (by the College) or externally (local industry or
organizations). Students must produce appropriate documentation to
support the project progression. Good communication and documentation
are stressed in the production of a final report.