ITSchool at the Brooklyn Campus of Long Island University

Long Island University understands that technology plays a significant role in business, healthcare and every aspect of our daily lives. Therefore, the ITSchool at the Brooklyn Campus has been established to help working adults acquire new, updated or complementary skills needed to achieve or maintain proficiency in their current professions, as well as to prepare for professional certification. The ITSchool offers introductory to advanced-level training that ranges from office, Web and graphic design to database management, networking and programming. After completing our program you will develop in-depth skills and knowledge in a professional field.

Take a moment to look at our course descriptions and see how our program can qualify you for a promotion or transition you into a new career. If you are looking for an entry-level opportunity or to expand your technical skills, contact us today.

ITSchool Courses

• Cisco Certified Network Associate - Level I
• Cisco Certified Network Associate - Level II
  
• Cisco Certified Network Associate - Level III
• Cisco Certified Network Associate - Level IV
• Introduction to Windows XP
  
• Microsoft Word 2003 - Core & Expert
• Microsoft Excel 2003 - Core & Expert
  

  
  Cisco Certified Network Associate (CCNA) Courses

  Cisco Certified Network Associate - Level I (CCNA 100)
  Learn network computer basics, the OSI Model, Local Area Networks (LANs), Layer 1 - Electronics and Signals, Design and Communication. You will be required to do a Structured Cabling Project. (75 hours)
  
  CCNA 100       $700          
  Section 1: Tuesdays & Thursdays, 6:00 - 9:00 p.m.
  Schedule to be announced.
  Instructor: Garth Trotman, CCAI, CCNA
  *****
  Cisco Certified Network Associate - Level II (CCNA 200)
  In the second semester, you will learn about the Router and WANS, how to use a Router, routed and routing protocols, Router configurations, CISCO IOS and IP subnetting.
  (75 hours)
  Prerequisite: CCNA 100.
  
  CCNA 200       $700 
  Schedule to be announced.
  *****
  Cisco Certified Network Associate - Level III (CCNA 300)
  In the third semester, you will be given a quick curriculum tour, review the OSI reference model and routing, and learn about LAN Switching, Virtual LANs (VLANs), LAN Design, Interior Gateway Routing Protocol (IGRP), Access Control Lists (ACLs), Novell IPX, and Network Management. (75 hours)
  Prerequisite: CCNA 200.
  
  CCNA 300        $700          
  Schedule to be announced.
  *****
  Cisco Certified Network Associate - Level IV (CCNA 400)
  This course covers the design and support of the WAN switching network; learn how to configure, operate, troubleshoot, and manage WAN switched networks through case study hands-on exercises. You will also learn to identify PPP operations to encapsulate WAN data on Cisco routers, the uses of ISDN networking and description of ISDN protocols, and Cisco's implementation of ISDN BRI. (75 hours)
  Prerequisite: CCNA 300.
  
  CCNA 400      $700          
  Schedule to be announced.

  
  Microsoft Office Specialist Word & Excel Courses
  

Introduction to Windows XP (MOUS 100)
This course is for the beginner who wants to learn how to operate a personal computer. You will learn the system components and peripherals and how to navigate in a Windows environment. In addition, keyboarding, Microsoft Word 2003 and Microsoft Excel 2003 will be covered. You will learn the various Microsoft Window elements and how to perform basic word-processing and spreadsheet tasks. Please contact the bookstore for the required text. (24 hours)

MOUS 100 $285
Schedule to be announced.
* * * * *
Microsoft Word 2003 --- Core (MOUS 200)
Today, Microsoft Word is the most widely-used, highly-acclaimed word processing application for both business and personal use. You will learn to create, format, save and print documents including letters, memoranda and manuscripts. Please contact the bookstore for the required text. (24 hours)
Prerequisite: MOUS 100.

MOUS 200 $285
Schedule to be announced.
* * * * *
Microsoft Word 2003 --- Expert (MOUS 300)
Become a "power user" of Microsoft Word 2003. Learn advanced word processing skills including tables, mail merge, AutoFormat, styles, graphics, and more. Upon completion of this course, you will be prepared to take the MOUS Word 2003 expert level exam. Please contact the bookstore for the required text. (24 hours)
Prerequisite: MOUS 200.

MOUS 300 $285
Schedule to be announced.
* * * * *
Microsoft Excel 2003 --- Core (MOUS 400)
Microsoft Excel is one of the most popular spreadsheet applications used in business environments today. It is extensively used in the banking, insurance, accounting, financial and scientific fields because of its ability to calculate and manipulate data. You will learn to prepare and present numerical data in a pictorial form using Microsoft Excel 2003. Please contact the bookstore for the required text. (24 hours)
Prerequisite: MOUS 100.

MOUS 400 $285
Schedule to be announced.
* * * * *
Microsoft Excel 2003 --- Expert (MOUS 500)
Learn advanced functions and prepare to take the Microsoft Office Specialist Excel 2003 expert-level exam. You will learn data analysis, how to use "what-if" analysis, pivot tables, lists, and more. Please contact the bookstore for the required text. (24 hours)
Prerequisite: MOUS 400.

MOUS 500 $285
Schedule to be announced.


Elective Courses

Microsoft Access 2003 (MOUS 600)
From corporate inventory to personal telephone lists, from complex relationships to custom programming, Microsoft Access 2003 is an application to manage your information needs. You will learn to create, save and print a database, perform queries, sort data and use wizards. (24 hours)
Prerequisite: MOUS 100.

MOUS 600 $285
Schedule to be announced.
* * * * *
Microsoft PowerPoint 2003 (MOUS 700)
Microsoft PowerPoint is a powerful presentation graphics program that makes it easy to generate and organize ideas. It provides tools to make graphs, charts, bulleted lists, eye-catching text, multimedia video and sound clips. PowerPoint also makes it easy to create slide shows, handouts, transparencies, and speaker's notes. Please contact the bookstore for the required text. (24 hours)
Prerequisite: MOUS 100.

MOUS 700 $285
Schedule to be announced.

Individual ITSchool Courses

Windows File and Disk Management (ITWD 100) 
Learn how to find missing files, delete, move and copy files, work with the recycle bin, organize, maintain and troubleshoot your hard disk, add and remove items and applications from your start button, work with the Startup group, and create desktop icons and other shortcuts to your favorite programs and documents. (6 hours)

ITWD 100 $100
Schedule to be announced.

Photoshop CS: Fundamentals (ITPH 100)
Photoshop is the leading photo design and production software for images used in multimedia, Internet Web site development and standard publications like brochures, flyers and other promotional materials. In this beginning course, you will explore and use essential features necessary to produce and publish quality images. (6 hours)

ITPH 100 $300
Schedule to be announced.

Photoshop CS: Intermediate (ITPH 200)
 Add to your Photoshop skills by learning to clean up and fine tune digital images. Create quick masks and permanent channels to isolate areas of your image for editing or manipulation. Use the selection tools to create and save paths, the vector drawing tools to add a variety of shapes to an image and the type tool to add text to your image. Warp images with precision.Repair images with the clone stamp, healing brush and patch tools. (6 hours) Prerequisite: ITPH 100.

ITPH 200 $300
Schedule to be announced.

Photoshop CS: Advanced (ITPH 300)
This course was formerly titled Mastering Photoshop: Advanced Topics.
Enhance your Photoshop skills to work with more precision and efficiency.
Learn to use channels, calculations and layer styles for special effects.
Discuss color models and color management, printing and preparing for prepress work more efficiently using the actions palette, batch processing and droplets. (6 hours)
Prerequisite: ITPH 200.

ITPH 300 $300
Schedule to be announced.

Database & Client Server (ITDB 100)
 Microsoft Access is the most popular Windows-based database in the world. Windows users can use Access to manipulate data, such as suppliers, customers or employees, and to generate reports and mailing labels. In addition, MS Access can act as the front-end user interface for the client/server database system. (14 hours)

ITDB 100 $350
Schedule to be announced.

Fundamental of SQL Using Oracle: Level 1 (ITSQ 100)
This course introduces a variety of SQL commands useful in working with Oracle databases. Learn to create effective queries by using SQL SELECT statements to retrieve and sort records from your tables. Work with comparison and logical operators to display only records that meet certain criteria. Practice creating tables and inserting, updating and deleting records. (14 hours)

ITSQ 100 $350
Schedule to be announced.

Fundamentals of SQL Using Oracle: Level 2 (ITSQ 200)
Further your SQL skills using Oracle by refining your queries to retrieve the information you need from single and multiple tables. Understand the different types of joins and how to use them to display data from multiple tables. Learn to use a variety of SQL functions to replace null values, to perform calculations and to customize the format of date data. (14 hours) Prerequisite: ITSQ 100.

ITSQ 200 $350
Schedule to be announced.

Oracle Programming using PL/SQL: Level 1 (ITOP 100)
Learn how Oracle¹s PL/SQL programming language can help you increase the flexibility and usefulness of your database applications. Write and execute blocks of code that interact with your Oracle data by combining SQL statements with PL/SQL programming constructs. Learn how to declare and reference variables in PL/SQL and use cursors to process rows returned by a query.  (14 hours)

ITOP 100 $350
Schedule to be announced.

Oracle: Database Fundamentals 1 - Advanced (ITOP 200)
This course introduces students to the responsibilities of an Oracle® Database Administrator (DBA). You will learn the underlying architecture of the Oracle database server and the essential tasks required to manage database installations such as how to start up and shut down an Oracle instance. (14 hours)
Prerequisite: ITOP 100.

ITOP 200 $350
Schedule to be announced.

To register...
Call: (718) 488-1361
or
E-mail: info-scs@brooklyn.liu.edu