Program in Computing and Information Technology
Office of Continuing Education
Lehman College
Spring 2004

Special Events for Spring 2004
Program offerings, requirements and procedures are subject to revision. Please check for updates periodically and request a copy of the spring 2004 course catalog, New Directions, by calling (718) 960-8512. An online version of New Directions is available in Acrobat Reader (.pdf) format.

What's new this spring

The Computing and Information Technology Program offers introductory level courses designed for individuals new to computing as well as intermediate and advanced courses in microcomputer systems (Windows 95/98/NT/2000, UNIX); microcomputer hardware; programming (C++, BASIC, Visual Basic, Java, HTML, SQL); local area networks; communications and the Internet; and microcomputer business applications. Students may select individual courses or complete a certificate program. Registration begins in December 2003. Call (718) 960-8512 to register or to request a printed copy of the spring 2004 catalog.

For further information on the Computing and Information Technology Program contact the program coordinator at 718 960-8512 or send electronic mail to compinfo@lehman.cuny.edu. If you are interested in teaching in the program, please see Job Openings for Computer Instructors.

Prerequisites

Many of our courses have a prerequisite. A prerequisite is usually either a preparatory course or equivalent experience. For example, before you can take EDP 26: Database Design and Management Using Microsoft Access , you must take EDP 07:Introduction to Microcomputing, have taken a course comparable to EDP 07 or have experience equivalent to EDP 07. If you feel you have the equivalent course or experience you must complete a Request for Waiver of Course Prerequisite form. You may request a copy of the form from the Office of Continuing Education by calling (718) 960-8512. If you have Acrobat Reader, you can print a copy of the of the form now by clicking here. Return the form to the Office. You will receive a response within five business days.

Certificate Programs

Certificates are offered in:

Follow the links above or refer to the printed catalog for certificate course requirements.

We are not accepting new students into our Systems and Programming Certificate Program. Students currently in the program should contact the Office of Continuing Education at (718) 960-8512 to plan the completion of their certificates. Click here for course requirements.

Class Schedule
Spring 2004

Classes are offered in the following areas

Pre-Semester Computing Workshops

In the following descriptions:

T = Textbook to be brought to first class meeting
D = High-density, 3 1/2 inch diskette to be brought to first class meeting

New for spring 2004

Basic Computer Skills
PCW 22/$95 (includes registration fee)

This hands-on workshop is for those who have little or no experience in using a personal computer. Topics include an overview of Microsoft Windows; use of mouse and keyboard; the desktop, icons, menus, toolbars and other elements of the Windows interface; running programs such as WordPad; editing, printing and saving simple documents. Enrollment limited: one student per computer. D

Basic Computer Skills is our entry-level course. Students who plan to take our full-semester courses must take Basic Computer Skills or have equivalent coursework or experience.

Touring the Internet
PCW 15/$50 (includes registration fee)

Take a tour on the Internet-the network of computers that brings together people from all over the world to share ideas, information and services. Learn to use the Internet to access information on subjects ranging from the arts to sports to finance and to search library catalogs and obtain free computer software. In addition, participants learn how to connect to the Internet from home or office. Enrollment limited: one student per computer. (Prerequisite: Proficiency with Windows.) D

Managing a Home Computer System
PCW 24/$95 (includes registration fee)

Topics discussed from the perspective of the home computer user with a Windows system include: sharing a computer system; protecting the system from viruses and other instrusions; firewalls and other security solutions;configuration of web browsers and safe web-browsing; applying patches and updates; basic maintenance such as backups and defragmentation and setting up a home network. The class includes demonstrations, lectures, and discussion. It is not a hands-on class. (Prerequisite: PCW 22 Basic Computer Skills or equivalent coursework or experience.)

For the Beginner

In the following descriptions:

T = Textbook to be brought to first class meeting

D = High-density, 3 1/2 inch diskette to be brought to first class meeting

CEU = The Continuing Education Unit (CEU) represents a nationally recognized instrument for documenting participation in non-credit programs. A CEU is defined as ten hours of participation in an organized continuing education experience under responsible sponsorship, capable direction, and qualified instruction. Continuing education credits may not be transferred to a degree-bearing program.

Updated for spring 2004

Introduction to Microcomputing
EDP 07/$305

This course, for those who have basic computing skills, covers essential computer concepts, the software and hardware components of microcomputers and the efficient use of Microsoft Windows. Topics include the Windows Graphical User Interface (GUI); file management; multimedia and other file types; customizing Windows and understanding hardware configurations. Also included are brief introductions to popular application software and to the Internet. (Prerequisite: PCW 22 Basic Computer Skills or equivalent course or experience.) 2.4 CEU T D

Microcomputer Applications

In the following descriptions:

T = Textbook to be brought to first class meeting

D = High-density, 3 1/2 inch diskette to be brought to first class meeting

ZD = 100 MB ZIP disk to be brought to first class meeting.

CEU = The Continuing Education Unit (CEU) represents a nationally recognized instrument for documenting participation in non-credit programs. A CEU is defined as ten hours of participation in an organized continuing education experience under responsible sponsorship, capable direction, and qualified instruction. Continuing education credits may not be transferred to a degree-bearing program.

Database Design and Management Using Microsoft Access
EDP 26/$305

Students are introduced to the theory and practice of information management through hands-on experience with Microsoft Access. Topics include: database definitions and concepts; Access fundamentals; creating tables, forms, queries and reports. (Prerequisite: EDP 07 Introduction to Microcomputing or equivalent course or experience) 3 CEU T D

New for spring 2004

Microsoft Outlook
EDP 36/$150

Learn to make efficient use of one of the most popular e-mail and information management software packages in use today. Topics include creating, sending, receiving and organizing e-mail; managing contacts, address books, schedules and tasks; filtering; customizing the way Outlook works; protecting your information and integrating Outlook with other Microsoft Office applications such as Excel and Access (Prerequisite: EDP 07 Introduction to Microcomputing or equivalent course or experience) 3 CEU T D

Computerized Keyboarding (Typing)
CBS 51/$245

This course is offered through the Word Processing Program.

This is an intensive course in the elements of keyboarding and proper form and style for letters, centering tasks, reports, memoranda and tables. Development of keyboarding speed to a minimum of 35 words per minute is the goal. The skills taught are essential for success in word processing tasks. Students use IBM-compatible personal computers. 3 CEU T D

Word Processing with Microsoft Word
CBS 78/$305

This course is offered through the Word Processing Program.

This course in Microsoft Word emphasizes editing commands and formatting features while introducing the Windows environment. Students learn to create, edit, format and print single and multiple-page documents. Other topics include mail merge, tables, columns, inserting graphics, and basic macros. (Prerequisite: Basic keyboarding [typing skills] )Two (2) 3 1/2 inch HD diskettes and textbook to be brought to first class meeting. 3 CEU

Microsoft Excel
CFM 47/$305

This course is offered through the Business Bookkeeping and Accountant Assistant Program.

Learn to create a spreadsheet using Microsoft Excel. Topics covered include building formulas, copying and moving techniques, formatting, and saving and printing files. More advanced topics include building multiple-sheet files, creating graphs, and using Excel functions. Enrollment limited: one student per computer. (Prerequisite: EDP 07 Introduction to Microcomputing or equivalent coursework or experience.) 3 CEU T D

Intermediate Microsoft Excel
CFM 48/$305

This course is offered through the Business Bookkeeping and Accountant Assistant Program.

This course builds upon CFM 47: Microsoft Excel to provide a more in-depth view of spreadsheet design and advanced functions. Topics include IF statements; macrodesigning; editing and debugging; lookup tables; solving formulas; what-if analysis; linking multiple worksheets; 3-D spreadsheets; pivot tables; customizing Excel and database functions. (Prerequisite: CMF 47 Microsoft Excel or equivalent coursework or experience.) 3 CEU T D

Microsoft PowerPoint
EDP 19/$305

To be offered in fall 2004

Advanced Database Management Using Microsoft Access
EDP 39/$305

To be offered in fall 2004

Desktop Publishing, Graphics and Web Design

In the following descriptions:

T = Textbook to be brought to first class meeting

D = High-density, 3 1/2 inch diskette to be brought to first class meeting

CEU = The Continuing Education Unit (CEU) represents a nationally recognized instrument for documenting participation in non-credit programs. A CEU is defined as ten hours of participation in an organized continuing education experience under responsible sponsorship, capable direction, and qualified instruction. Continuing education credits may not be transferred to a degree-bearing program.

Adobe Illustrator
EDP 64/$245

Adobe Illustrator is the industry-standard object-oriented graphics application used to create drawings, logos, typographic designs, charts, maps, artwork and other materials for print and electronic publication. Topics include Illustrator tools fro creating, selecting, copying, transforming, and reshaping drawings and other vector graphics; layers, masks and filters; working with type; and the management of output. (Prerequisite: EDP 07 or equivalent course or experience.) 2.4 CEU T ZD

Publishing on the World Wide Web
EDP 115/$245

HTML (HyperText Markup Language) is the language used to create documents for electronic publication on the Internet's World Wide Web. Students learn how to design and format documents; embed links to other resources; and use lists, tables, forms, and frames. The incorporation and management of graphic content created in other programs such as Photoshop and obtained from input devices such as scanners is covered. Emphasis is placed on creating effective, informative and asthetically-pleasing web content. (Prerequisite: EDP07 Introduction to Microcomputing or equivalent course or experience and familiarity with the Internet. Students who are not familiar with the Internet should consider taking our pre-semester workshop PCW 15 Touring the Internet) 2.4 CEU T D

Computer Graphics Using Photoshop
EDP 56/$245

To be offered in summer 2004

QuarkXPress
EDP 67/$245

To be offered in fall 2004

Operating Systems and Hardware (Technical Support)

In the following descriptions:

T = Textbook to be brought to first class meeting

D = High-density, 3 1/2 inch diskette to be brought to first class meeting

CEU = The Continuing Education Unit (CEU) represents a nationally recognized instrument for documenting participation in non-credit programs. A CEU is defined as ten hours of participation in an organized continuing education experience under responsible sponsorship, capable direction, and qualified instruction. Continuing education credits may not be transferred to a degree-bearing program.

Microcomputer Operating Systems
EDP 09/$305

In this course, students are introduced to the architecture, concepts and commands of microcomputer operating systems including Microsoft's Disk Operating System (DOS) and Microsoft Windows 98. Students perform tasks such as managing files, directories and disks. They are also introduced to basic components of a microcomputer including the CPU, random access memory and disk storage, and, in addition, learn to use the operating system to make efficient and effective use of the hardware (Prerequisite: EDP 07 Introduction to Microcomputing or equivalent course or experience.) 3 CEU T D

Microcomputer Hardware and Repair
EDP 59/$445

This course is designed to prepare students to support personal computer hardware. Topics include the identification, installation, configuration and upgrading of microcomputer components including power supplies; system boards; CPUs; input/output (I/O) devices such as keyboards and video; ports and expansion slots; memory; storage devices such as floppy drives, hard drives and CDs; multimedia devices; and network hardware. Safety, preventive maintenance, and diagnostic and troubleshooting techniques used by entry-level PC technicians are covered. Enrollment limited: two students per computer. (Prerequisites: EDP 09 Microcomputer Operating Systems or equivalent course or experience. EDP 10 Advanced Microcomputer Operating Systems is highly recommended.) PC tool kit, available in the Lehman College Bookstore, to be brought to first class meeting. 4.2 CEU T D

Advanced Microcomputer Operating Systems
EDP 10/$305

To be offered in summer 2004

Introduction to Computer Networks
EDP 42/$305

To be offered fall 2004

Information Technology Professionals' Series

In the following descriptions:

T = Textbook to be brought to first class meeting

D = High-density, 3 1/2 inch diskette to be brought to first class meeting

CEU = The Continuing Education Unit (CEU) represents a nationally recognized instrument for documenting participation in non-credit programs. A CEU is defined as ten hours of participation in an organized continuing education experience under responsible sponsorship, capable direction, and qualified instruction. Continuing education credits may not be transferred to a degree-bearing program.

Introduction to SQL and the Client/Server Environment Using the Oracle Database Server
EDP 500/$370

Students are introduced to the industry standard Structured Query Language(SQL) and its use as a data access and manipulation language for relational databases, specifically, the Oracle database system. Students become familiar with the concepts by developing statements to access data in the sample Oracle database system. The other component of the course is an introduction to client/server systems. The focus is on the database server (RDBMS) to show how it is used by developers to create efficient applications on the client side. (Prerequisite: EDP 26 or equivalent course or experience). 3.6 CEU

Relational Database Analysis and Design
EDP 502/$370

The course provides a comprehensive foundation for designing, building and working with relational databases. The course includes an overview of relational database fundamentals; all aspects of the design of relational databases such as developing a logical data model, mapping the data model to a relational model, developing conceptual schema and data normalization. The course also covers elements of physical database design such as grouping and assigning tables to files, indexing for performance and integrity. Database access and security are discussed. (Prerequisite: EDP 26 Database Design and Managment Using Microsoft Access or equivalent course or experience). 3.6 CEU

New for spring 2004

Visual Basic .NET: An Introduction for Programmers
EDP 504/$245

Following an overview of the Microsoft .NET framework, students are introduced to Visual Basic .NET - the newest version of the Visual Basic programming language for the development of Windows-based and web-based applications. Differences between the Visual Basic .NET and previous versions of the language are discussed and demonstrated with examples created within the Visual Studio .NET Integrated Development Environment. (Prerequisite: Knowledge of at least one programming language). 2.4 CEU
Document updated 28 December 2003