Term 1
Course Number Course Name C - L - H Hrs
401-991-DW Administration 3 - 2 - 2 75
420-111-DW Logic of Programming 3 - 3 - 3 90
Corequisites: 420-121-DW - Internet Applications 1
420-141-DW - Fundamentals of the Computer
Description: The course will introduce the student to the basic object-oriented methodology used to write programs that encompass basic building blocks (sequential, selection and repetitive control structures) used in program construction. The student will learn the Java programming language to implement the algorithms studied. Object-oriented design and programming concepts will be explored, including class constructors, inheritance, encapsulation and parameters.
420-121-DW Internet Applications 1 1 - 2 - 2 45
Corequisites: 420-111-DW - Logic of Programming
420-141-DW - Fundamentals of the Computer
Description: The student will be introduced to the technology of the Internet and will learn to use the basic tools for connecting to and making use of this medium. The student will be introduced to Web browsers and servers, FTP clients and servers, e-mail clients and servers, and to additional tools that allow the students to understand how information flows.
420-141-DW Fundamentals of the Computer 3 - 2 - 3 75
Corequisites: 420-111-DW - Logic of Programming
420-121-DW - Internet Applications 1
Description: This course introduces the student to the architecture and organization of the modern computer system, with emphasis on the internal structure and function of the CPU, instruction representation and interpretation, buses, the organization and operation of memory and peripheral devices including disk storage devices, and related terminology used to describe computer operations. The binary and hexadecimal number systems and the various data representations used in computer systems will be covered. The features and role of various operating systems will be introduced and described, with practical examples chosen from graphical user interfaces such as Windows and command-line interfaces such as Linux.
General Education
- 109-103-02 Health and Physical Education 1 - 1 - 1 30
- 345-103-04 Knowledge 3 - 1 - 3 60
- 603-101-04 Introduction to College English 2 - 2 - 4 60
Term 2
Course Number Course Name C - L - H Hrs
201-105-DW Linear Algebra 3 - 2 - 3 75
Description: This course focuses on systems of linear equations, matrices and determinants, vectors and applications to lines and planes, and applications of linear algebra to Social Science. This course is not a substitute for Mathematics 201-NYC-05.
420-212-DW Programming I 3 - 3 - 3 90
Teacher(s) for Winter 2009: Alexander Simonelis teaching section(s) 01 L1
STAFF teaching section(s) 01
Prerequisites: 420-111-DW - Logic of Programming
420-121-DW - Internet Applications 1
420-141-DW - Fundamentals of the Computer
Description: The course will introduce the student to basic object-oriented methodology to design, implement, modify and use classes to write programs in the Java language that perform interactive processing, array processing, string processing and data validation. Object-oriented features such as encapsulation and polymorphism will be explored.
420-230-DW Database I 1 - 2 - 2 45
Teacher(s) for Winter 2009: Marcia Schaefer teaching section(s) 01 L1
Prerequisites: 401-991-DW - Administration
420-111-DW - Logic of Programming
420-121-DW - Internet Applications 1
420-141-DW - Fundamentals of the Computer
Description: This course introduces the student to the concepts of Database Management Systems (DBMS). Elementary relational database concepts such as tables, records, fields, keys, domains, relationships and properties will be introduced. The roles of a DBMS user and designer/programmer will be identified. Students will be able to produce an interactive system allowing users to input and update data in a database and retrieve information on screen and in report form.
420-442-DW Operating Systems I 3 - 2 - 2 75
Teacher(s) for Winter 2009: Gary Zarta teaching section(s) 01 L1
Prerequisites: 420-111-DW - Logic of Programming
420-121-DW - Internet Applications 1
420-141-DW - Fundamentals of the Computer
Description: Prerequisite: Successful completion of all 420 courses in Term I. This course explores the concepts, terminology, and fundamental features of operating systems in general and the Linux operating system in detail. The characteristics of a multi-user, multi-tasking, multi-threaded operating system will be examined in detail. Aspects of connectivity using TCP/IP protocols, and application services such as FTP, Telnet and web servers will be introduced. The command-line user interface will be the central focus, allowing the student to use shell commands, editors such as vi and emacs, and utilities such as sed and awk to construct and use command sequences to manipulate data and perform basic system administration tasks. The graphical user interface will be introduced and explored using XWindows. Projects will include installation and configuration of the operating system on a host machine.
General Education
- 109-104-02 Physical Activity 0 - 2 - 1 30
- 602-10_-03 French: Bloc A 2 - 1 - 3 45
- 603-102-04 Literary Genres 2 - 2 - 3 60
Term 3
Course Number Course Name C - L - H Hrs
201-257-DW Mathematics - Statistics for Computer Science 3 - 2 - 3 75
Prerequisite: 201-105-DW - Linear Algebra
Description: This course focuses on descriptive statistics, probabilities, discrete random variable, continuous random variable, statistical inference, relation between two variables, and introduction to time series.
420-213-DW Programming II 3 - 3 - 3 90
Prerequisites: 420-111-DW - Logic of Programming
420-121-DW - Internet Applications 1
420-141-DW - Fundamentals of the Computer
Description: The course will introduce the student to GUI interface programming techniques. The student will learn to design and code a user interface consisting of menus from which the user can select tasks to be performed. These tasks will include data entry, informational screens, file input-output and report production. The concepts of objects and properties and event-driven programming will be explored.
420-314-DW Programming III 3 - 3 - 3 90
Prerequisites: 420-212-DW - Programming I
420-230-DW - Database I
Description: The course will enhance the student’s knowledge of Java to produce stand-alone applications employing graphical user interfaces, layout managers and event handlers. The concepts of inheritance, polymorphism, and data abstraction will be explored. The student will learn the methodologies to create and process sequential files consisting of text and serialized object data, and to update the data in these files.
420-332-DW Database II 3 - 3 - 3 90
Prerequisites: 420-212-DW - Programming I
420-230-DW - Database I
Description: Pre-requisites: Successful completion of 420 courses in Year I. The course will introduce the student to the tools and techniques for database design and the use of Structured Query Language (SQL). Fundamental concepts of the relational data model, the use of selected data modeling methodologies, and data normalization techniques to create robust relations will also be covered. The syntax and semantics of SQL to create and maintain relational databases will be studied.
General Education
- 109-105-02 Active Living 1 - 1 - 1 30
- 603-103-04 Literary Themes 2 - 2 - 3 60
Term 4
Course Number Course Name C - L - H Hrs
420-315-DW Programming IV 3 - 3 - 3 90
Teacher(s) for Winter 2009: George Mack teaching section(s) 01
STAFF teaching section(s) 01
Prerequisites: 420-212-DW - Programming I
420-213-DW - Programming II
420-230-DW - Database I
Description: The course will introduce the student to the object-oriented methodology to design, implement, modify, and use classes to write programs in the Visual Basic .NET and C# languages. Assignments involve writing rich clients and active server pages, including file and array processing, which are interfaced to back-end databases (Access, Oracle and SQL Server are used).
420-422-DW Internet Applications II 3 - 3 - 3 90
Teacher(s) for Winter 2009: Margaret Brown teaching section(s) 01
Prerequisites: 420-314-DW - Programming III
420-332-DW - Database II
Description: Prerequisites: Successful completion of all 420 courses in Term III. The student will learn client-side programming in a Web environment. The student will learn to apply HTML, Cascading Style Sheets, and JavaScript to implement Web-based content. The student will be given an introduction to the design concepts of a Web site.
420-433-DW Database III 3 - 3 - 3 90
Teacher(s) for Winter 2009: Bonnie Diana Cameron teaching section(s) 01
Prerequisites: 420-314-DW - Programming III
420-332-DW - Database II
Description: This course will introduce the student to Oracle’s family of database and application server tools for building, deploying, hosting and managing enterprise-class applications. The roles of the DBMS user, designer/programmer and administrator will be examined. This course will provide the student with the perspective of both a developer and an administrator. The student will use SQL and PL/SQL to build and manage a database.
General Education
- 345-102-03 World Views 3 - 0 - 3 45
- 602-B__-03 French: Bloc B 2 - 1 - 3 45
- 603-BXE-04 Applied Themes in English 2 - 2 - 2 60
- COMP 1 Complementary
Term 5
Course Number Course Name C - L - H Hrs
420-516-DW Programming V 3 - 3 - 3 90
Prerequisites: 420-315-DW - Programming IV
420-422-DW - Internet Applications II
420-433-DW - Database III
Description: Pre-requisite: Successful completion of all 420 courses in Year II. The student will learn to construct stand-alone applications that require the design and implementation of multiple classes. The student will study standard data structures and their relevant use in the manipulation and management of data in applications. The student will also learn to use JDBC to access databases.
420-523-DW Internet Applications III 3 - 3 - 3 90
Prerequisites: 420-315-DW - Programming IV
420-422-DW - Internet Applications II
420-433-DW - Database III
Description: Prerequisites: Successful completion of all 420 courses in Year II. The student will be introduced to the concepts and techniques of server-side programming employing the PHP scripting language. The student will build a website with server-side code interfacing to MySQL or other databases, as well as implement web clients using scripting and web forms. Working in small groups, students will design, program and document a website that presents information on a given topic.
420-534-DW Database IV 2 - 4 - 3 90
Description: Pre-requisite: Successful completion of all Database domain courses, all Programming courses, and Internet Application domain courses in previous semesters. The course will introduce the student to Oracle Developer/Server. The student will learn to create, implement and administer interactive applications within the Oracle environment. Using Forms Developer/Server, students will learn to create customized Form modules and deploy these modules on the Web. The student will also learn how to create and web-enable reports (Reports Developer/Server). Students will also complete an independent project that will involve the design and implementation of an application in the Web environment, and will perform environment-related administrative tasks.
420-543-DW Data Communications and Networking 3 - 2 - 3 75
Prerequisites: 420-315-DW - Programming IV
420-433-DW - Database III
420-442-DW - Operating Systems I
Description: Prerequisite: Successful completion of 420 courses in Year II. This course is designed to familiarize the student with modern data communications theory, concepts, and terminology, including various communications media and protocols used to transmit and share information over various types of networks including local area networks and the Internet. Students will acquire sufficient knowledge of wide area networks and local area networks to be able to operate comfortably as programmers in a network environment. Students will define and implement network solutions using TCP/IP tools, utilities and programs that they will themselves write to demonstrate an understanding of the underlying protocols of the Internet.
General Education
- 345-BXH-03 Applied Themes in Humanities 3 - 0 - 3 45
- COMP 2 Complementary
Term 6
Course Number Course Name C - L - H Hrs
350-905-DW Psychology - Human Relations 2 - 1 - 3 45
Teacher(s) for Winter 2009: Zina Suissa teaching section(s) 01
420-624-DW Internet Applications IV 3 - 3 - 3 90
Teacher(s) for Winter 2009: Kenneth Fogel teaching section(s) 01
Prerequisites: 420-516-DW - Programming V
420-523-DW - Internet Applications III
420-534-DW - Database IV
420-543-DW - Data Communications and Networking
Description: Prerequisite: Successful completion of all 420 courses in Term V. The course will introduce the student to the concepts and techniques of server-side Java programming, XML programming and web-based database access. The student will be provided with the knowledge to analyze and design methods to develop a web-based system. The student will take part in a group project to design, program and document an e-commerce website.
420-644-DW Operating Systems II 3 - 3 - 3 90
Teacher(s) for Winter 2009: Alexander Simonelis teaching section(s) 01
Prerequisites: 420-516-DW - Programming V
420-523-DW - Internet Applications III
420-534-DW - Database IV
420-543-DW - Data Communications and Networking
Description: Prerequisite: Successful completion of all 420 courses in Term V. The course will introduce the student to the theory and practice of modern network operating systems, with emphasis on the installation and management of Windows Server networks. This course will provide the student with the perspective of both a user and a network administrator.
420-650-DW Internship 0 - 15 - 1 225
Teacher(s) for Winter 2009: Marcia Schaefer teaching section(s) 01
Carmen Legendre teaching section(s) 01
Prerequisites: 420-516-DW - Programming V
420-523-DW - Internet Applications III
420-534-DW - Database IV
420-543-DW - Data Communications and Networking
Description: The Internship course is designed to provide the student with an experiential basis for learning how to apply the theoretical skills acquired in the Computer Science Technology program to be better able to pursue successfully a career in computer programming, analysis, web page design and implementation, pc technical support, network administration and support, operations, management or sales. The Internship will last approximately eight weeks. The trainee student will report to the work place for 5 days each week. The company and the College will contract for interns and for the internship period. Upon completion of the Internship, the trainee will submit to the Internship coordinator a report detailing his/her internship experience and new learning. In the case where a sixth semester student cannot be placed in an external internship, the Chair of the Department will call upon a member of the department to take the place of the external Internship Supervisor on a Project for the student. The Chair will take into consideration the abilities, skills and preferences of the faculty member and the student.
