Docstoc

outside front coverindd

Document Sample
outside front coverindd Powered By Docstoc
					                                                              ,
                                                           ner
                                                      esig
                                                   D
                                                nt
                                              oi
                                            eP
                                          ar
                                      , Sh te
                                    ng o
                                  hi eN
                               lis n
                             ub O
                          l P ,&

                                                                  Computer Education &
                    ig ita ath
                   D foP
                  n In
             e si
           s
        ur
      co
N
 ew
                                                                       T ra i n i n g C e n t e r
           U n i v e r s i t y          o f        M i s s o u r i - S t.   L o u i s



           C h a n c e l l o r ’s C e r t i f i c at e
           Computer Classes



            S e pte m be r – Decem b er 2 0 11 Cl a sses




                                                                                    Continuing
                                                                                    Education



           w w w. c e t c . u m s l . e d u
Corporate
 Services
Group Training & Custom Classes
                                                                             For information on classroom rentals,
                                                                             group training, or our PrePurchase
                                                                             program, contact:

If you have a group that needs training, let us help you get more for           Kate Moore
your training budget. We can provide any of the classes listed in this          (314) 984-9000
catalog or our Web site at a discount for your group. Whether you are           kate@cetc.umsl.edu
upgrading to a new version or your staff needs training in the latest           www.cetc.umsl.edu/group.html
software, we can bring the class to your site or hold the training at our
facility near I-270 and Manchester Road. Customization can range from
minor adjustments to an existing class to a new course designed specifically for your organization. We will work
with you to determine the topics and course sequence that meet the precise needs of your staff.

Our client list for group and custom training includes small and large companies, educational institutions, and
government agencies. Our customers include:
 Enterprise Holdings, Inc.               Maritz Travel Company                Manchester Police Department
 Metro St. Louis                         Enterprise Bank & Trust              Sisters of Mercy Health System
 Kirkwood School District                Brown Shoe Company                   MasterCard Worldwide
 U.S. District Courts Eastern Missouri   Crescent Parts                       Jordan Lawrence Group, Inc.
 Nestlé Purina PetCare                   Covidien                             LaBarge, Inc.
 Department of Veterans Affairs          Swiss-American, Inc.                 Illinois National Guard
 St. Louis Rams                          Fontbonne University                 Express Scripts, Inc.
 Missouri Foundation for Health          Pro Motion, Inc.


PrePurchase Investment Program
Get more ROI on your training budget through our PrePurchase Investment program. When you PrePurchase
your computer training, you’ll receive extra training dollars at no cost to you. In addition to giving you more
value for your investment, we make it easier for you to manage your registrations and training budget. With the
PrePurchase Investment program, your employees can register for any course in our catalog or Web site. Your
PrePurchase investment is a great way to show your commitment to your employee’s professional development.

Classroom or Computer Lab Rental
The Computer Education & Training Center has computer labs and classrooms available for full-day and half-day
rentals. The computer labs vary in size and configuration for flexible classroom arrangements. The design
incorporates the latest classroom innovations with student amenities that foster the learning process. With close
proximity to highways 40/64, 44 and 270, we offer a convenient location for your next training or meeting. With
onsite staff ready to assist, we can help make your event a success.
 Letter                        from the                       Director
                      Welcome to the Computer Education & Training Center
                             at the University of Missouri-St. Louis

For more than 25 years, we have prided ourselves on the quality computer education we provide.
However, as our student, you are the true test and the ultimate judge of quality. After every class we
ask for your feedback, and I have to say, I love it when I read comments such as “The best instructor,”
“Genuinely dedicated teacher,” “Exceptional knowledge,” “Comfortable environment to learn and ask
questions,” and “Attentive to my needs.” With each class, we want you to leave with more practical
knowledge and more experience in the skills you need.

You will see over 175 different classes listed in this catalog. Along with an extensive list of classes in
SharePoint, Excel, and Access, you’ll find classes that will help you with Web Development, Graphics,
Project Management, and Desktop Publishing. For those in IT, look for our classes in Security,
Networking, Programming, Windows Server, Client Server/Business Intelligence, and UNIX, in
addition to a series in IT Professional Development.

We look forward to seeing you soon at one of our upcoming classes.

Sincerely,


Allan Crean
Director, Computer Education & Training Center
Division of Continuing Education
                                                                 www.cetc.umsl.edu
                                                                     For an up-to-date listing of our
                                                                        classes, dates, and times
                                                                        check out our Web site:
                                                                           www.cetc.umsl.edu
Our Convenient
                                                                                       12837 Flushing Meadows Drive
West County Location                                                                   St. Louis, MO 63131
The Computer Education & Training Center (CETC) is in the new
West County Continuing Education Center, conveniently located
near the intersection of Interstate 270 and Manchester Road. This
building has been extensively renovated to offer an exceptional                        Hwy 40 (I-64)                    Hwy 40 (I-64)
learning environment.
                                                                       Clarkson Road




                                                                                                             I-270




                                                                                                                                                             d
                                                                                                                                                       Roa
                                                                                                                                                 ter
                                                                                                                                          ches
The center features new classrooms designed for effective                                                                           Man


computer or classroom training, updated audiovisual equipment,                                                                                    4
                                                                                                  d




                                                                                                                                            I-4
                                                                                                  Roa




and a centralized student area that includes a spacious student
                                                                                                   Mill
                                                                                                      ods




                                                                                                                     I-44
break room with a kitchen and lounge seating. There are six
                                                                                                        Wo




computer labs, including two with moveable walls for flexible                                                               I-2
                                                                                                                               70
room layouts, as well as a large classroom with modular furniture.                         I-4
                                                                                              4




                                                                                                             Table of Contents (next page)
2

      Computer Education & Training Center Classes
      September –                           General Sections                                                  Office Advice . . . . . . . . . . . . . . . . . . . . . 11
      December 2011                                                                                           OneNote. . . . . . . . . . . . . . . . . . . . . . . . 10
                                            Course Listing . . . . . . . . . . . . . . . . . . . . . 3        Oracle . . . . . . . . . . . . . . . . . . . . . . . . . . 19
      Computer Education                    General Information . . . . . . . . . . . . . . . 31              Outlook. . . . . . . . . . . . . . . . . . . . . . . . . 10
      & Training Center                         Registration • Hours • Transcripts
                                                                                                              PDF . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
      (314) 984-9000                            Course Advice • Payment Information
                                                                                                              Perl . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30
      www.cetc.umsl.edu                     Map and Facility Information . . . . . . . . 32
                                                                                                              Photoshop . . . . . . . . . . . . . . . . . . . . . . . . 4
                                            Courses                                                           Photoshop Elements . . . . . . . . . . . . . . . . 5
                                                                                                              PHP . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
                                            A+ Certification . . . . . . . . . . . . . . . . . . 25           PowerPoint . . . . . . . . . . . . . . . . . . . . . 14
                                            Access . . . . . . . . . . . . . . . . . . . . . . . . . 15       Premiere . . . . . . . . . . . . . . . . . . . . . . . . . 3
                                            Acrobat . . . . . . . . . . . . . . . . . . . . . . . . . . 7     Professional Development . . . . . . . . . . 26
                                            Active Server Pages (ASP .NET) . . . . . 22                       Programming Concepts . . . . . . . . . 28
                                            AJAX . . . . . . . . . . . . . . . . . . . . . . . . . . . 21     Project . . . . . . . . . . . . . . . . . . . . . . . . . . 13
                                            C# . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29   Public Speaking . . . . . . . . . . . . . . . . . . . 26
                                            Captivate . . . . . . . . . . . . . . . . . . . . . . . . . 5     Publisher . . . . . . . . . . . . . . . . . . . . . . . . 6
                                            Cascading Style Sheets (CSS) . . . . . . . . 20                   QuickBooks Pro . . . . . . . . . . . . . . . . . . . 7
                                            Cisco Routers . . . . . . . . . . . . . . . . . . . . 24          Routers . . . . . . . . . . . . . . . . . . . . . . . . . 24
                                            Communications Skills . . . . . . . . . . . . . 26                Security . . . . . . . . . . . . . . . . . . . . . . . . . 26
                                            Computer Support . . . . . . . . . . . . . . . . 25               SharePoint . . . . . . . . . . . . . . . . . . . . . . . . 8
                                            Crystal Reports . . . . . . . . . . . . . . . . . . 17            SharePoint Designer . . . . . . . . . . . . . . . . 9
                                            Database Design . . . . . . . . . . . . . . . . . . 19            Silverlight . . . . . . . . . . . . . . . . . . . . . . . . 21
                                            Desktop Publishing Design . . . . . . . . . . . 6                 SQL Language Classes . . . . . . . . . . . . . 17
                                            Dreamweaver . . . . . . . . . . . . . . . . . . . . 23            SQL Server Administration . . . . . . . . . 18
                                            E-learning . . . . . . . . . . . . . . . . . . . . . . . . 5      SQL Server Reporting Services . . . . . . 18
                                            Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . 12    TCP/IP . . . . . . . . . . . . . . . . . . . . . . . . . . 25
                                            Exchange Server . . . . . . . . . . . . . . . . . 28              Team Building . . . . . . . . . . . . . . . . . . . . 26
                                            Facebook . . . . . . . . . . . . . . . . . . . . . . . . 22       UNIX . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
                                            FileMaker Pro . . . . . . . . . . . . . . . . . . . . 16          Visio. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
                                            Fireworks . . . . . . . . . . . . . . . . . . . . . . . 23        Visual Basic .NET . . . . . . . . . . . . . . . . . 28
                                            Flash . . . . . . . . . . . . . . . . . . . . . . . . . . . 24    Visual C# .NET . . . . . . . . . . . . . . . . . . . 29
                                            Flash ActionScript . . . . . . . . . . . . . . . . . 24           Windows 7 . . . . . . . . . . . . . . . . . . . . . . . 3
                                            HTML . . . . . . . . . . . . . . . . . . . . . . . . . . 20       Windows Active Directory . . . . . . . . . 28
                                            Illustrator . . . . . . . . . . . . . . . . . . . . . . . . 4     Windows Server . . . . . . . . . . . . . . . . . 28
                                            InDesign . . . . . . . . . . . . . . . . . . . . . . . . . 6      Windows XP. . . . . . . . . . . . . . . . . . . . . . 3
                                            InfoPath . . . . . . . . . . . . . . . . . . . . . . . . . . 9    Wireless Networking . . . . . . . . . . . . . . 25
                                            Introductory Courses . . . . . . . . . . . . . . . 3              Word . . . . . . . . . . . . . . . . . . . . . . . . . . 14
                                            Java Programming . . . . . . . . . . . . . . . . . 30             XML. . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
                                            JavaScript . . . . . . . . . . . . . . . . . . . . . . . . 21

    www.cetc.umsl.edu                       JavaServer Pages (JSP) . . . . . . . . . . . . . . 30
                                            Leadership . . . . . . . . . . . . . . . . . . . . . . . 26
                                            Linux . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
                                                                                                                  Course Listings
                                                                                                                  Courses are shown with the
    For the most up-to-date class
    schedules and additional infor-
                                            LiveCycle Designer . . . . . . . . . . . . . . . . . 7                program code, day/date, location,
                                            Networks . . . . . . . . . . . . . . . . . . . . . . . 25             and the last name of the instructor.
    mation about our courses,
    certificates, and all our student       Object-Oriented Programming . . . . . . 28
                                                                                                                  See p. 32 for a map and facility
    services, visit our Web site.           Office 2007 . . . . . . . . . . . . . . . . . . . . . . 10            information.
                                            Office 2010 . . . . . . . . . . . . . . . . . . . . . . 10




    September – December 2011           •       Computer Education & Training Center                          •     (314) 984-9000                  •      www.cetc.umsl.edu
                                                                                                  Introductory, Windows & Premiere 3

  INTRODUCTORY                                                              Microsoft Windows XP




                                                                                                                                                        Table of Contents, Introductory, Windows & Premiere
  Getting Started                                                           Introduction to Windows XP
                                                                            Learn the basics of how to use Windows in either a standalone or
  Introduction to Computers                                                 a networked environment. Learn how to log on to the worksta-
  Designed for students with little or no computer experience, this         tion and tour the desktop, Start menu, taskbar, and standard icons.
  course introduces you to basic computer concepts and terminol-            Discover how to organize your workspace by resizing, moving,
  ogy, using the Windows operating system. Learn how your comput-           and tiling windows and arranging icons. Understand how to cre-
  er’s desktop is organized and how to access important commands.           ate network drives and access files and folders on the network.
  Practice using fundamental mouse and keyboard skills to interact          Additional topics include creating, deleting, and renaming files and
  with your computer, including opening software programs, working          folders; configuring and recovering files and folders; and custom-
  with files, and browsing the Internet. Explore options for saving files   izing the desktop environment.
  to your computer’s hard drive or a removable storage device, such         Fee: $189
  as a CD or USB flash drive.                                               One-Day Class Meets 8:30am-4:00pm (6.5 hours)
  Fee: $99                                                                  G2402 Fri., Oct. 21              West County                Delcamp
  Half-Day Class Meets 8:30am-11:30am (3 hours)
  G2400 Fri., Oct. 7               West County               Lux
                                                                             Are You Switching to Windows 7?
                                                                             The Transitioning to Windows 7 course is intended for
  Microsoft Windows 7                                                        end-users with Windows experience who want to update
                                                                             their skills for the new version. Introduction to Windows 7
  Transitioning to Windows 7                                                 teaches the basics of the operating system.
  (Prerequisite: Experience with a previous version of the Windows
  operating system, including using the Start menu and manag-
  ing files and folders.) This course is intended for end-users with
  previous Windows experience who want to jump-start their                  DIGITAL VIDEO
  move to Windows 7 and discover the new features that will
  improve their productivity. Learn how to use the newly redesigned         Create and edit video, including transitions and audio, using
  Taskbar and Start menu and how the Windows Aero interface will            Premiere.
  heighten your user experience as you navigate multiple windows.
  Understand how Libraries help you organize your folders and               Adobe Premiere Pro
  locate files quickly, and discover how to personalize the appearance
  by setting desktop background slide shows, changing the desktop           Introduction to Digital Editing Using Premiere Pro
  icons, and adding Gadgets. Additional topics include working with         (Prerequisite: Introduction to Windows or equivalent experience.)
  jump lists, the Ribbon, and metadata.                                     Learn to create movies using Premiere Pro, a video- and audio-
  Fee: $99                                                                  editing application. Topics include importing clips (stills, movies,
  Half-Day Class Meets 8:30am-11:30am (3 hours)                             audio), adding clips to the Timeline, applying effects, inserting titles,
  G2251 Wed., Aug. 31                West County              Barry         and using transitions. Also covered will be editing clips, deleting
  G2501 Mon., Nov. 7                 West County              Barry         frames, cutting one clip into two, and changing clip speed. You will
                                                                            preview your movies and then save and compress them. Learn
        See p. 10 for courses on transitioning to Office 2007               video production and post-production terminology and concepts
                                                                            as you create your own animations and movies.
        or Office 2010.                                                     Fee: $239
                                                                            One-Day Class Meets 8:30am-4:00pm (6.5 hours)
                                                                            G2626 Tues., Dec. 6                West County                Koerper
  Introduction to Windows 7
  (Prerequisite: Introduction to Computers or equivalent experi-            Intermediate Applications of Premiere Pro
  ence.) Learn the basics of how to use Windows and how to log on           (Prerequisite: Introduction to Digital Editing Using Premiere Pro
  to the workstation and tour the desktop, Start menu, Taskbar, and         or equivalent experience.) Discover the power of transitions
  standard icons. Discover how to organize your workspace by resiz-         as you set duration and create cross cuts. Work with the audio
  ing, moving, and tiling windows, arranging icons, and creating short-     mixer to further refine your audio tracks with special effects.
  cuts. Additional topics include creating, deleting, and renaming files    You will learn to apply and adjust video effects, including color,
  and folders; using the default libraries; and customizing the desktop     page peel, motion, and lighting. Prepare your files for output by
  environment.                                                              using menu templates and setting DVD stop points using mark-
  Fee: $189                                                                 ers, selecting sequences to export, and using the Adobe Media
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)                             Encoder.
  G2401 Fri., Oct. 14                West County              Barry         Fee: $239
                                                                            One-Day Class Meets 8:30am-4:00pm (6.5 hours)
               IT Professional Development                                  G2627 Wed., Dec. 7                West County               Koerper

  As an IT professional, your job has become more complex, with
  employers and customers expecting a blend of technical skills                         Intensive Premiere Pro Training
  and talent in communication, management, and leadership. Our
  IT Professional Development courses help you to be a success                Are you coming from a distance? Join us for Premiere Pro
  at your job, to strengthen those skills that are essential in today’s       week. Each one-day class costs $239.
  IT environment, and to create value for you and your company.               Introduction to Digital Editing Using Premiere Pro, Tues., Dec. 6
                 See p. 26 for more information.                              Intermediate Applications of Premiere Pro, Wed., Dec. 7

September – December 2011             •    Computer Education & Training Center             •     (314) 984-9000         •     www.cetc.umsl.edu
4 Illustrator & Photoshop


   GRAPHIC DESIGN & ARTWORK                                                DIGITAL PHOTOGRAPHY
   Adobe Illustrator                                                       Adobe Photoshop
   Adobe Illustrator is the industry standard for creating artwork
   for print, multimedia, and the Web.                                     Introduction to Image Editing Using Photoshop
                                                                           (Prerequisite: Introduction to Windows or equivalent experience.)
   Introduction to Computer Graphics Using Illustrator                     Alter and enhance images using various tools from the Photoshop
   (Prerequisite: Introduction to Windows or equivalent experience.)       toolbox, while becoming familiar with the tool options bar. Create
   Learn the capabilities of Illustrator as you create your own artwork.   special effects using the Filter and Image menus. Isolate areas of
   Topics include using tools and menus and creating special typo-         your image using the various selection tools. Use the eraser tool
   graphical effects. Learn how to scale, stretch, and rotate type and     to delete pixels and the history brush tool to “undo” changes
   objects. Other topics include grouping, locking, layering, creating     to an image. Crop and resize images, create custom brushes, and
   Bezier paths, using the transformation tools, and working with Live     learn the basics of layers.
   Paint and Live Trace.                                                   Fee: $189
   Fee: $189                                                               One-Day Class Meets 8:30am-4:00pm (6.5 hours)
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                           G2359 Fri., Sept. 30                  West County           Koerper
   G2329 Mon., Sept. 19               West County              Koerper     G2426 Wed., Oct. 26                   West County           Koerper
   G2537 Thurs., Nov. 3               West County              Koerper     G2621 Thurs., Dec. 1                  West County           Koerper
                                                                           Two-Evening Class Meets 6:30-9:30pm (6 hours)
   Intermediate Applications of Illustrator                                T2205 Tues., Nov. 8 & 15     West County      Koerper
   (Prerequisite: Introduction to Computer Graphics Using Illustrator
   or equivalent experience.) This course concentrates on more             Intermediate Applications of Photoshop
   advanced drawing techniques, such as developing a precise way to        (Prerequisite: Introduction to Image Editing Using Photoshop or
   draw by identifying and altering path points and working with Bezier    equivalent experience.) Add to your Photoshop skills by learning
   curves. Learn to blend shapes and paths, create and apply patterns,     to clean up and fine-tune digital images. Create quick masks and
   and make object masks. Topics include importing images and using        permanent channels to isolate areas of your image for editing or
   the image filters to enhance bitmap images. Additional topics include   manipulation. Use the selection tools to create and save paths, the
   creating and importing custom colors, making compound paths, and        vector drawing tools to add a variety of shapes to an image, and
   applying special type effects.                                          the type tool to add text to your image. Repair images with the
   Fee: $189                                                               clone stamp, healing brush, and patch tools. Change selection bor-
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                           ders, choose painting colors, and look at scanning issues. Additional
   G2330 Tues., Sept. 20            West County              Koerper       topics include the spot healing brush and the red-eye removal tool.
   G2538 Fri., Nov. 11              West County              Koerper       Fee: $189
                                                                           One-Day Class Meets 8:30am-4:00pm (6.5 hours)
                                                                           G2360 Fri., Oct. 7                   West County           Koerper
    Macintosh Users Welcome!                                               G2427 Thurs., Oct. 27                West County           Koerper
    Our Adobe courses, including Illustrator, Photoshop, InDesign,         G2622 Thurs., Dec. 8                 West County           Koerper
    Dreamweaver, Flash, and Fireworks, are taught using Windows,           Two-Evening Class Meets 6:30-9:30pm (6 hours)
    but if you use a Macintosh, you can apply what you’ve learned in       T2206 Tues., Nov. 29 & Dec. 6 West County     Koerper
    class. The programs are identical; there are only slight keyboard
    differences, and Windows has an extra mouse button to access
    some shortcuts.
                                                                           Advanced Applications of Photoshop
                                                                           (Prerequisite: Intermediate Applications of Photoshop or equiva-
                                                                           lent experience.) Learn to use channels, calculations, layer styles,
                                                                           and different image modes for special effects. Work more exten-
   Advanced Applications of Illustrator                                    sively with layers, learning adjustment layers, fill layers, layer comps,
   (Prerequisite: Intermediate Applications of Illustrator or equivalent
                                                                           and how to apply a layer blending mode. Find out how to apply
   experience. You should be familiar with all the drawing and transfor-
                                                                           pixel masks and add background effects in images. Additional topics
   mation tools, as well as layering, masking, and compound paths.) This
                                                                           include the vanishing point filter, image warping, and smart objects.
   course presents advanced techniques using Illustrator, as you plan,
                                                                           Fee: $189
   design, and execute one project throughout the day. Topics include
                                                                           One-Day Class Meets 8:30am-4:00pm (6.5 hours)
   making curved gradations of color, masking type with a Photoshop
                                                                           G2428 Fri., Oct. 28                   West County               Koerper
   file, creating interlocked stroked objects, and creating faded lines.
                                                                           G2623 Thurs., Dec. 15                 West County               Koerper
   Other topics include constructing grids, 3-D objects, and transpar-
   ent shadows. Learn to use filters and brushes on paths and shapes,
   import Photoshop layer comps, and optimize graphics for the Web.        Advanced Topics in Photoshop: Web Graphics
   Fee: $189                                                               (Prerequisite: Intermediate Applications of Photoshop or equiva-
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                           lent experience.) Optimize your images for use on the Web using
   G2331 Wed., Sept. 21               West County              Koerper     Photoshop. Learn about compression schemes, file formats, and
   G2539 Thurs., Nov. 17              West County              Koerper     Web-safe colors. Discuss scanning images for Web use, designing
                                                                           for maximum browser and hardware compatibility, and enhancing
                                                                           and converting graphics created in other programs. Learn when to
              Intensive Illustrator Training                               use transparency and interlacing, and how to create simple anima-
                                                                           tions. Create rollovers, buttons, backgrounds, and borders for an
   Join us for Illustrator week. Each one-day class costs $189.            attractive, interactive Web site.
     Introduction to Computer Graphics Using Illustrator, Mon., Sept. 19   Fee: $189
     Intermediate Applications of Illustrator, Tues., Sept. 20             One-Day Class Meets 8:30am-4:00pm (6.5 hours)
     Advanced Applications of Illustrator, Wed., Sept. 21                  G2326 Tues., Sept. 6                 West County          Koerper
                                                                           G2529 Fri., Nov. 4                   West County          Koerper
  September – December 2011               •    Computer Education & Training Center           •    (314) 984-9000         •     www.cetc.umsl.edu
                                                                                               Photoshop Elements, Captivate & Visio 5


  Adobe Photoshop Elements                                                  Advanced Applications of Captivate




                                                                                                                                                    Art/Graphics, Digital Imaging, Diagramming & E-Learning
                                                                            (Prerequisite: Intermediate Applications of Captivate or equivalent
  Introduction to Image Editing Using Photoshop                             experience.) Discover how to manipulate system variables to
  Elements                                                                  manage project behavior and create your own advanced actions.
  (Prerequisite: Introduction to Windows or equivalent experience.)         Practice working with branched projects, randomize your quiz-
  Photoshop Elements is Adobe’s user-friendly software designed for         zes by including Question Pools, and take advantage of the Adobe
  correcting, enhancing, and organizing your digital images. Learn to       Review Cycle to collect feedback before publishing. Learn how to
  use the step-by-step controls that fix red-eye, flaws, and lighting       combine multiple projects using the Aggregator. Additional topics
  problems in your photos. Organize images through keyword tags             include importing Photoshop images and working with Effects.
  and optimize images for the Web. Quickly adjust color and contrast        Fee: $189
  or improve skin tones. Other topics include creating photo collages,      One-Day Class Meets 8:30am-4:00pm (6.5 hours)
  using the filters for special effects, and making slide show presenta-    G2388 Wed., Sept. 21             West County              Delcamp
  tions.                                                                    G2604 Fri., Dec. 16              West County              Delcamp
  Fee: $99
  Half-Day Class Meets 8:30am-11:30am (3 hours)
  G2301 Mon., Sept. 12                    West County          Koerper      DRAWING/DIAGRAMMING TOOLS
                                                                            Communicate ideas visually through Microsoft Visio drawings,
  Intermediate Applications of Photoshop Elements                           including flowcharts, maps, and network diagrams.
  (Prerequisite: Introduction to Image Editing Using Photoshop
  Elements or equivalent experience.) Learn the more advanced
  features of Photoshop Elements using the Full Edit mode. Discover         Microsoft Visio
  the powerful tools to refine selections, fix flaws, and adjust color.
  Other topics include using the painting tools, working with layers,       Introduction to Visio
  adding text to your images, and creating special effects.                 (Prerequisite: Introduction to Windows or equivalent experience.)
  Fee: $99                                                                  Communicate complex business information and ideas with clarity
  Half-Day Afternoon Class Meets 1:00-4:00pm (3 hours)                      using Visio diagrams. This course covers what you need to know to
  G2302 Mon., Sept. 12                West County              Koerper      create effective diagrams, including flowcharts and block diagrams.
                                                                            Learn to use the tools and diagram types designed for specific
                                                                            disciplines and businesses, the predefined SmartShapes that can
  E-LEARNING TOOLS                                                          save you time and effort, connection points, gridlines, and alignment
                                                                            options. Personalize your diagrams with backgrounds, color coding,
  Adobe Captivate                                                           borders, formatted text, as well as your own custom shapes and
                                                                            designs.
  Adobe Captivate is used to create a variety of electronic-                Fee: $189
  learning projects, including software simulations and scenario-           Visio 2007
  based training.                                                           One-Day Class Meets 8:30am-4:00pm (6.5 hours)
                                                                            G2303 Wed., Aug. 31               West County              Koerper
  Introduction to Captivate                                                 G2507 Thurs., Nov. 10             West County              Koerper
  (Prerequisite: Introduction to Windows or equivalent experi-
  ence.) Discover how Adobe Captivate allows you to create effec-           Visio 2010
  tive e-learning modules from start to finish. Learn how to create         One-Day Class Meets 8:30am-4:00pm (6.5 hours)
  projects from scratch, record and edit software demonstrations,           G2653 Tues., Dec. 13     West County          Koerper
  and incorporate interactive quizzes. Find out how to publish these
  e- learning projects as Flash or video files. Additional topics include   Intermediate Applications of Visio
  working with the timeline, importing files from PowerPoint, using         (Prerequisite: Introduction to Visio or equivalent experience.) In
  master slides, and manipulating slides and objects.                       this course, you’ll go beyond the basics and discover how to create
  Fee: $189                                                                 custom templates and use styles to quickly update shapes. Learn
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)                             how to add behaviors to shapes and link your diagrams to exter-
  G2386 Mon., Sept. 19              West County                Delcamp      nal data sources. Create reports in a variety of formats, including
  G2602 Fri., Dec. 2                West County                Delcamp      HTML, to summarize information in your drawings. Other topics
                                                                            include importing special graphics files, using custom shape prop-
  Intermediate Applications of Captivate                                    erties, and exploring different types of drawings, such as network
  (Prerequisite: Introduction to Captivate or equivalent experience.)       diagrams and maps.
  Learn how to record and edit interactive simulations for training         Fee: $189
  or evaluation, add audio to projects, and use interactive objects to      Visio 2007
  control project navigation. Discover how to manage the project            One-Day Class Meets 8:30am-4:00pm (6.5 hours)
  size using the Library and save time by using the built-in Widgets.       G2304 Thurs., Sept. 1             West County               Koerper
  Additional topics include inserting rollover slidelets, creating proj-    G2508 Fri., Nov. 18               West County               Koerper
  ect templates, and customizing the player interface.                      Visio 2010
  Fee: $189                                                                 One-Day Class Meets 8:30am-4:00pm (6.5 hours)
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)                             G2654 Wed., Dec. 14      West County          Koerper
  G2387 Tues., Sept. 20            West County                 Delcamp
  G2603 Fri., Dec. 9               West County                 Delcamp

              Intensive Captivate Training                                             Intensive Visio 2010 Training
   Introduction to Captivate, Mon., Sept. 19                                 Introduction to Visio 2010, Tues., Dec. 13
   Intermediate Applications of Captivate, Tues., Sept. 20                   Intermediate Applications of Visio 2010, Wed., Nov. 14
   Advanced Applications of Captivate, Wed., Sept. 21
September – December 2011              •    Computer Education & Training Center           •     (314) 984-9000        •    www.cetc.umsl.edu
6 Publisher, InDesign, & Desktop Publishing Principles


   DESKTOP PUBLISHING                                                         Adobe InDesign

   Microsoft Publisher                                                        Introduction to Desktop Publishing Using InDesign
                                                                              (Prerequisite: Introduction to Windows or equivalent experience.)
   Introduction to Publisher                                                  Learn the basics of InDesign and develop the skills you need to
   (Prerequisite: Introduction to Windows or equivalent experience.)          design and produce camera-ready copy for simple publications. This
   Develop the skills you need to design and produce publications             course will guide you through creating basic text frames; typing
   ready for printing. Learn to enter, import, and format text in single-     and importing text into the frames; and selecting, editing, format-
   and multiple-column pages. Additional topics include using design          ting, and checking spelling. Learn to thread overset text from frame
   templates to simplify document creation, adding special type effects       to frame and set tabs and hanging indents. Use the Pages panel
   with WordArt, and inserting clip art into your document pages.             to move around in a document. You will create shapes and apply
   Fee: $189                                                                  strokes and fills to add color to your pages; layer, align, and group
   Publisher 2007                                                             objects; and create documents with multiple columns. Additional
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                              topics include basic printing options, opening QuarkXPress files,
   G2403 Wed., Oct. 5                   West County           Koerper         and how to use master pages to number pages automatically.
                                                                              Fee: $189
   Publisher 2010                                                             One-Day Class Meets 8:30am-4:00pm (6.5 hours)
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                              G2341 Thurs., Sept. 1             West County                 Haupt
   G2624 Mon., Dec. 12         West County       Koerper                      G2441 Tues., Oct. 11              West County                 Haupt
                                                                              G2523 Mon., Nov. 14               West County                 Haupt
   Intermediate Applications of Publisher
   (Prerequisite: Introduction to Publisher or equivalent experience.)        Intermediate Applications of InDesign
   Class examples will guide you through creating a newsletter with           (Prerequisite: Introduction to Desktop Publishing Using InDesign
   sections and spreads, using multiple master pages, customizing tem-        or equivalent experience.) Learn to import graphics and then crop,
   plates, and creating and editing styles. You’ll also explore how to        manipulate, and automatically resize graphics to fit inside their
   create a Web site, lay out an electronic newsletter, use the catalog       frames. Discover how to add elements to your page, such as text
   merge feature to merge database records into a Publisher file, and         wrap around graphics, type on a path, gradients, and tables. Work
   prepare your files for a commercial printer.                               with text graphically by converting it to paths. Additional topics
   Fee: $189                                                                  include find and change format settings, working with master pages,
   Publisher 2007                                                             dividing a document into sections, saving a file as a template, and
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                              printing options such as thumbnails and tiling.
   G2404 Fri., Oct. 14                   West County             Koerper      Fee: $189
   Publisher 2010                                                             One-Day Class Meets 8:30am-4:00pm (6.5 hours)
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                              G2342 Wed., Sept. 7              West County                Haupt
   G2625 Mon., Dec. 19         West County       Koerper                      G2442 Wed., Oct. 12              West County                Haupt
                                                                              G2524 Tues., Nov. 22             West County                Haupt

    Design Principles                                                         Advanced Applications of InDesign
                                                                              (Prerequisite: Intermediate Applications of InDesign or equiva-
    for    Desktop Publishing                                                 lent experience.) Learn to apply sophisticated text effects, such
                                                                              as hanging punctuation and decorative initial capital letters. Use
    The following course teaches the principles of page layout                the commands that give you precise control over hyphenation,
    and design using hands-on projects to reinforce the concepts.             justification, and paragraph composition. Increase your efficiency
                                                                              and ensure consistency by setting up styles and libraries. In class,
    Design Principles for Desktop Publishing                                  you will create a book with a table of contents, as well as discuss
    (Prerequisite: Intermediate Applications of InDesign or equivalent        preparing a document for output using the Preflight and Package
    experience.) This course teaches you how to combine the elec-             plug-ins.
    tronic capabilities of InDesign with established principles of design     Fee: $189
    and layout. Topics include using a grid, call outs, and optical center.   One-Day Class Meets 8:30am-4:00pm (6.5 hours)
    Other topics include page flow, typography, white space, paper and        G2343 Thurs., Sept. 15           West County                Haupt
    ink selection, planning for multi-page documents, and using spot          G2443 Thurs., Oct. 13            West County                Haupt
    color. Learn to prepare your documents for a commercial printer           G2525 Tues., Nov. 29             West County                Haupt
    or service bureau.                                                                                                          !
    Fee: $189                                                                 Digital Publishing with InDesign New
    One-Day Class Meets 8:30am-4:00pm (6.5 hours)                             (Prerequisite: Intermediate Applications of InDesign or equivalent
    G2680 Tues., Dec. 6               West County                 Haupt       experience.) In this class, you will practice using InDesign’s inter-
                                                                              active tools to create dynamic documents designed for digital
                                                                              distribution. Learn how to create a new document intended for
                                                                              the Web and how to repurpose print documents for digital use.
                                                                              Discover how to add audio and video to your document as well as
                                                                              how to include interactivity by incorporating buttons, hyperlinks,
    Intensive InDesign Training                                               and animations. Learn how to save the document as a PDF or
     Join us for InDesign week. Each one-day class costs $189.                SWF file. Additional topics include controlling timing, working with
                                                                              bookmarks, and adding page transitions.
    Introduction to Desktop Publishing Using InDesign, Tues., Oct. 11
                                                                              Fee: $189
    Intermediate Applications of InDesign, Wed., Oct. 12
                                                                              One-Day Class Meets 8:30am-4:00pm (6.5 hours)
    Advanced Applications of InDesign, Thurs., Oct. 13
                                                                              G2681 Fri., Dec. 9                West County                Haupt


  September – December 2011               •    Computer Education & Training Center             •     (314) 984-9000        •       www.cetc.umsl.edu
                                                                                         Acrobat, Livecycle Designer & QuickBooks 7


DOCUMENT MANAGEMENT USING                                                   LiveCycle Designer & Acrobat




                                                                                                                                                        Accounting, Desktop Publishing & Acrobat
ADOBE ACROBAT
                                                                            Advanced Topics in Acrobat: Forms
Use Acrobat to convert almost any document to a PDF, which                  (Prerequisite: Introduction to Acrobat or equivalent experience.)
can be shared across all platforms, sent to print shops, and                Online forms have become important tools in gathering informa-
viewed on the Web with the free Acrobat Reader.                             tion from employees and clients. Acrobat Pro and Adobe LiveCycle
                                                                            Designer allow you to easily create forms from scratch or convert
Introduction to Acrobat                                                     existing forms to PDF format. This course will show you how to
(Prerequisite: Introduction to Windows or equivalent experience.)           design an efficient form, use different field types, validate user input,
Acrobat can change the way your organization creates and distrib-           and perform calculations. Learn how to use templates to create
utes documents through e-mail, print, CD-ROM, or the Web. PDF               forms automatically. You will also work with simple scripts and find
(Portable Document Format) files are sharable across platforms and          out how to process returned form data.
devices, eliminating such problems as computer system differences           Fee: $189
or font availability. In this course, learn how to convert existing files   Version: 9
or Web sites into PDF format according to your desired settings.            One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Find out how to navigate PDFs and make changes to existing docu-            G2630 Fri., Jan. 6                 West County                Haupt
ments using the Acrobat editing tools. Send your PDFs for review
and learn how to add comments. Set basic security options to con-           Version: X
trol how your PDF is handled, and find out how to attach supporting         One-Day Class Meets 8:30am-4:00pm (6.5 hours)
documents. Additional topics include working with bookmarks and             G2486 Wed., Nov. 16      West County          Haupt
exporting information from existing PDFs into other formats.
Fee: $189                                                                   ACCOUNTING AND BOOKKEEPING
Version: 9
One-Day Class Meets 8:30am-4:00pm (6.5 hours)                               QuickBooks Pro
G2628 Wed., Dec. 14                 West County              Haupt
Version: X                                                                  Introduction to QuickBooks
One-Day Class Meets 8:30am-4:00pm (6.5 hours)                               (Prerequisite: Introduction to Windows or equivalent experience.)
G2484 Tues., Nov. 1      West County          Haupt                         Discover how QuickBooks can help you manage your business
                                                                            finances and perform day-to-day bookkeeping tasks more effectively
Intermediate Applications of Acrobat                                        and efficiently. Learn how to set up your chart of accounts and
(Prerequisite: Introduction to Acrobat or equivalent experience.)           create lists to keep track of customers, vendors, and other informa-
Learn the features of Acrobat that will enhance your documents and          tion. Additional topics include working with invoices and payments,
increase your efficiency. Use OCR (Optical Character Recognition)           tracking sales and expenses, and paying bills.
to make PDFs searchable, and find out how to compare document               Fee: $189
versions. Examine documents for sensitive information and use               One-Day Class Meets 8:30am-4:00pm (6.5 hours)
the redaction tools to permanently remove unwanted information.             G2437 Mon., Oct. 17               West County             Koerper
Discover more about the security features and how to synchro-               G2533 Mon., Nov. 21               West County             Koerper
nize page views for easier real-time collaboration. Learn how your
Acrobat documents can be more accessible when used with assistive           Intermediate Applications of QuickBooks
technologies and mobile devices. Find out how batch processing can          (Prerequisite: Introduction to QuickBooks or equivalent experi-
save you time and how simple JavaScript actions can add interactivity       ence.) Further your understanding of QuickBooks to handle more
to your documents. Learn to combine multiple files into a visually          sophisticated bookkeeping tasks. Learn to keep track of employee
rich PDF Portfolio. Additional topics include adding multimedia, back-      information and manage your payroll, produce a variety of reports
grounds, and watermarks.                                                    to help you summarize and analyze your business data, and set up
Fee: $189                                                                   and manage a budget. You’ll also learn how to communicate with
Version: 9                                                                  business associates by merging QuickBooks’ data into form letters.
One-Day Class Meets 8:30am-4:00pm (6.5 hours)                               Fee: $189
G2629 Tues., Dec. 20              West County              Haupt            One-Day Class Meets 8:30am-4:00pm (6.5 hours)
                                                                            G2438 Tues., Oct. 18             West County             Koerper
Version: X
                                                                            G2534 Mon., Nov. 28              West County             Koerper
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
G2485 Wed., Nov. 2       West County          Haupt
                                                                              Did you know we offer a Chancellor’s
                                                                              Certificate in Electronic Art & Publishing?
                Want more information?
                                                                              This Chancellor’s Certificate program combines
         For more information on our courses,                                 three key areas: desktop publishing, graphics, and
                                                                              image editing.
         including course outlines, instructor
                                                                              For more information, see the inside back cover
         biographies, and software versions, visit
                                                                              of this catalog or visit our Web site at
         our Web site: www.cetc.umsl.edu                                         http://www.cetc.umsl.edu/eafacts.html



September – December 2011             •    Computer Education & Training Center             •    (314) 984-9000         •     www.cetc.umsl.edu
8 SharePoint




       WORKGROUP and COLLABORATION
  Microsoft SharePoint
  Microsoft Windows SharePoint Services is a flexible, collaborative technology that enhances the communication and productivity
  of work groups through a Web-based environment. These courses cover creating, customizing, and managing SharePoint sites.
  Introduction to SharePoint                                            Advanced Applications of SharePoint
  (Prerequisite: Introduction to Windows or equivalent experience.      (Prerequisite: Intermediate Applications of SharePoint or equivalent
  Some experience with Microsoft Office applications and basic          experience.) Discover the advanced features of SharePoint that
  e-mail skills are also recommended.) Discover how Microsoft           can enhance your sites. Learn how galleries can make customized
  SharePoint can create Web-based environments (SharePoint sites)       content (such as columns, Web parts, and site templates) avail-
  that enhance the productivity of work groups, teams, and other        able throughout your site collection. Find out how to use standard
  collaborative groups. Learn to navigate through the SharePoint        workflows to route documents or list items through approval
  environment and create your own subsites for specific work            and feedback processes. Other topics include working with con-
  teams. Find out how to use, modify, and create SharePoint lists       tent types, building custom search centers to search for content
  (such as announcements, calendars, and contacts) to stay con-         throughout a site collection, and targeting site content to specific
  nected to other group members and more effectively share data.        users or groups.
  Discover how to create and use libraries to store, retrieve, and      Fee: $239
  share documents on the SharePoint server rather than a local          SharePoint 2007
  hard drive.                                                           One-Day Class Meets 8:30am-4:00pm (6.5 hours)
  Fee: $239                                                             G2381 Thurs., Sept. 22           West County               Lux
  SharePoint 2007                                                       G2549 Fri., Nov. 4               West County               Fry
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)
                                                                        SharePoint 2010
  G2379 Fri., Sept. 9             West County               Otto
                                                                        One-Day Class Meets 8:30am-4:00pm (6.5 hours)
  G2447 Thurs., Oct. 20           West County               Fry
                                                                        G2296 Wed., Sept. 7      West County          Lux
  G2648 Wed., Dec. 14             West County               Fry
                                                                        G2452 Tues., Oct. 25     West County          Lux
  SharePoint 2010                                                       G2612 Fri., Dec. 2       West County          Lux
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)
  G2450 Tues., Oct. 11     West County          Otto                    Advanced Topics in SharePoint: Site Management
  G2557 Fri., Nov. 11      West County          Hudson                  (Prerequisite: Intermediate Applications of SharePoint or equivalent
  G2610 Wed., Nov. 30      West County          Otto                    experience.) Enhance your knowledge of SharePoint by explor-
                                                                        ing basic administrative features and specialized services. Tour the
  Intermediate Applications of SharePoint                               Central Administration and Shared Services sites to gain a basic
  (Prerequisite: Introduction to SharePoint or equivalent experi-       understanding of administrative tasks. Learn to use Key Performance
  ence.) Explore features of SharePoint that will enhance your          Indicator (KPI) lists to analyze progress on your organization’s
  workgroup productivity. Discover how to create pages to present       goals. Additional topics include using Excel Services to interact with
  site content in different ways and use wiki libraries to create and   spreadsheet data through your SharePoint sites and implementing
  manage links between pages. Learn to improve site navigation          information management policies for your lists and libraries.
  by modifying the Quick Launch and Top Link bar. Learn how to          Fee: $239
  create lists based on Excel and Access data and link SharePoint       SharePoint 2007
  content to Excel and Access files. Additional topics include using    One-Day Class Meets 8:30am-4:00pm (6.5 hours)
  metadata to sort and filter content in your lists and libraries.      G2382 Fri., Sept. 23              West County                Lux
  Fee: $239
  SharePoint 2007                                                       Advanced Topics in SharePoint: Business Intelligence
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)                         (Prerequisite: Intermediate Applications of SharePoint or equivalent
  G2380 Fri., Sept. 16             West County                Otto      experience.) Learn how to use the business intelligence (BI) capa-
  G2448 Fri., Oct. 28              West County                Fry       bilities in SharePoint to present your business data in a meaningful
  G2649 Tues., Dec. 20             West County                Fry       way. Understand how PerformancePoint Services and the Business
  SharePoint 2010                                                       Intelligence Center site template enhance the BI functionality in
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)                         SharePoint. Create KPI lists to communicate business objectives and
  G2451 Wed., Oct. 19      West County          Otto                    progress toward meeting these goals. Use SharePoint’s reporting
  G2611 Thurs., Dec. 1     West County          Otto                    features, including report libraries and Excel-based reports, to help
                                                                        your users make intelligent business decisions.
                                                                        Fee: $239
                                                                        SharePoint 2010
                                                                        One-Day Class Meets 8:30am-4:00pm (6.5 hours)
                                                                        G2619 Fri., Dec. 9                 West County             Lux
               Intensive SharePoint 2010 Training
    Join us for SharePoint week. Each one-day class costs $239.
    Introduction to SharePoint, Wed., Nov. 30                               Note: The features covered in the Business
    Intermediate Applications of SharePoint, Thurs., Dec. 1                 Intelligence course are available only in SharePoint
    Advanced Applications of SharePoint, Fri., Dec. 2                       Server Enterprise Edition and the course is taught
                                                                            using the 2010 version of SharePoint.

  September – December 2011              •    Computer Education & Training Center          •    (314) 984-9000        •    www.cetc.umsl.edu
                                                                                                     SharePoint Designer & InfoPath 9


  Microsoft SharePoint Designer 2007                                       SharePoint Designer 2010




                                                                                                                                                   SharePoint, SharePoint Designer & InfoPath
  SharePoint Designer is used to create Web pages as well as
  extend the capabilities of SharePoint.                                   Introduction to SharePoint Designer 2010
                                                                           (Prerequisite: Introduction to HTML and Introduction to SharePoint
  If you have taken an introductory course in a Web design                 or equivalent experience.) Learn to use SharePoint Designer to
  program such as Dreamweaver, you do not need to take the                 customize your SharePoint site beyond the capabilities of the Web
  introductory SharePoint Designer 2007 course.                            browser. Discover how to create your own lists, libraries, site col-
                                                                           umns, and content types. Practice using these content types in lists
  Introduction to Web Page Design Using                                    and libraries, and learn how to create and modify sub sites and Web
  SharePoint Designer 2007                                                 Part pages. Additional topics include changing site characteristics
  (Prerequisite: Introduction to HTML or equivalent experience.)           and editing the default home page for sites.
  Learn to use SharePoint Designer to create Web pages that incor-         Fee: $239
  porate text, images, background art, and tables. Topics covered in       One-Day Class Meets 8:30am-4:00pm (6.5 hours)
  class include formatting text for size, color, and alignment; creat-     G2391 Tues., Sept. 20             West County              Otto
  ing ordered and unordered lists; and linking pages together with         G2617 Wed., Dec. 7                West County              Otto
  hyperlinks. Learn to place images on your pages and format text and
  images in columns using the table feature. Additional topics include     Intermediate Applications of SharePoint Designer 2010
  creating transparent GIFs, inserting audio and video files, changing     (Prerequisite: Introduction to SharePoint Designer or equiva-
  background color, and adding background textures to your Web             lent experience.) This course covers more advanced features of
  pages.                                                                   SharePoint Designer, including creating and customizing Data Views
  Fee: $239                                                                and using XSLT with Data Views. Discover how to connect to XML
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)                            and external data sources and how to create external content
  G2645 Mon., Nov. 28              West County                Fry          types. Additional topics include applying conditional formatting and
                                                                           working with Web Part connections.
  Intermediate Applications of SharePoint Designer 2007                    Fee: $239
  (Prerequisite: Introduction to SharePoint Designer and Introduction      One-Day Class Meets 8:30am-4:00pm (6.5 hours)
  to SharePoint or equivalent experience.) Learn to use SharePoint         G2392 Tues., Sept. 27             West County              Otto
  Designer to customize your SharePoint site beyond the capabilities       G2618 Thurs., Dec. 8              West County              Otto
  of the Web browser. Create and edit sites from within SharePoint
  Designer that include layouts and content not customizable from
  within a browser. Discover how to create lists and libraries in          Microsoft InfoPath
  SharePoint Designer, add Web Part Zones and Web Parts, and work
  with List View Web Parts and Data View Web Parts, including condi-       Introduction to InfoPath
  tional formatting of data. Start to explore Master Pages, how they       (Prerequisite: Introduction to Windows or equivalent experience.)
  are responsible for the consistent layout of your pages, and the rela-   Learn to use InfoPath to design forms solutions that streamline
  tionship of Cascading Style Sheets with the Master Page.                 your data-gathering processes. Create custom form templates that
  Fee: $239                                                                include a variety of layouts and form controls. Use control format-
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)                            ting, field properties, and data validation to ensure the accuracy of
  G2646 Mon., Dec. 5                West County             Fry            form data. Examine and modify the built-in XML data source, and
                                                                           connect to an Access database to retrieve and submit data in an
  Advanced Applications of SharePoint Designer 2007                        external data source. You will also learn to integrate InfoPath forms
  (Prerequisite: Intermediate Applications of SharePoint Designer or       with SharePoint.
  equivalent experience.) This course covers more advanced features        Fee: $239
  of master pages, including working with the components (placehold-       InfoPath 2007
  ers) that are common to all master pages. Discover how to custom-        One-Day Class Meets 8:30am-4:00pm (6.5 hours)
  ize an existing master page using HTML and CSS. You will also work       G2505 Mon., Nov. 7                 West County              Lux
  with data sources, including creating connections to ODBC and            InfoPath 2010
  using linked data sources to combine multiple data sources. Learn        One-Day Class Meets 8:30am-4:00pm (6.5 hours)
  how to use the Workflow Designer Wizard to create, delete, and           G2256 Mon., Aug. 29      West County          Lux
  modify workflows.
  Fee: $239                                                                Intermediate Applications of InfoPath
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)                            (Prerequisite: Introduction to InfoPath or equivalent experience.)
  G2647 Mon., Dec. 12              West County             Fry             Discover specialized design techniques to create sophisticated
                                                                           and customized InfoPath forms. Understand how to use repeating
                                                                           and optional controls to make your forms more dynamic. Learn
                                                                           how to merge forms to aggregate form data and produce mean-
     With InfoPath, you can create forms to gather                         ingful reports. Use e-mail to publish forms and submit form data.
                                                                           Additional topics include conditional formatting, creating and man-
     data from your customers as well as your                              aging views, and importing a form from another Office application.
     employees. Available as part of the Office suite,                     Fee: $239
     InfoPath integrates with other Office products                        InfoPath 2007
     and delivers forms through Web browsers and                           One-Day Class Meets 8:30am-4:00pm (6.5 hours)
     e-mail messages. The form templates you create                        G2506 Tues., Nov. 15              West County              Lux
     in InfoPath ensure consistency and make data                          InfoPath 2010
     entry faster and easier.                                              One-Day Class Meets 8:30am-4:00pm (6.5 hours)
                                                                           G2357 Tues., Sept. 6     West County          Lux



September – December 2011            •    Computer Education & Training Center            •    (314) 984-9000        •    www.cetc.umsl.edu
10 Office, OneNote & Outlook


   MICROSOFT OFFICE                                                        ORGANIZATION SOFTWARE
   Transitioning to Office 2007                                            Microsoft OneNote
   (Prerequisite: Experience using any version of Microsoft Word,
   Excel, Access, or PowerPoint. Specific skills include opening and       Introduction to OneNote
   saving files, using the mouse to navigate through documents, and        (Prerequisite: Introduction to Windows or equivalent experience.)
   using toolbars and menus to locate and run commands.) Learn             With this planning and note-taking software, you can easily collect,
   what you need to know to make a smooth transition to Office             organize, search, and share information from a single digital note-
   2007. This course gives you an overview of the interface differences    book. In this course, learn how to add notes, create new notebook
   between Office 2007 and previous Office suites, and helps you navi-     sections and pages, and move and format notes. Tag your notes and
   gate effectively through the Office 2007 applications (Word, Excel,     use the search tools to quickly find information. Save time by using
   PowerPoint, and Access). Learn to use the new Ribbon to access          templates and learn how OneNote and Outlook work together.
   commands and use Live Preview to check out formatting options.          Additional topics include sharing notebooks through a network and
   Discover how to use the new file formats and why you might need         sending sections of your notebook to Word.
   to save a file in a previous version. Increase your Office efficiency   Fee: $239
   by customizing the Quick Access toolbar with the commands you           OneNote 2010
   frequently use.                                                         One-Day Class Meets 8:30am-4:00pm (6.5 hours)
   Fee: $99                                                                G2312 Mon., Sept. 12             West County               Delcamp
   Half-Day Class Meets 8:30am-11:30am (3 hours)                           G2620 Mon., Dec. 5               West County               Delcamp
   G2300 Fri., Sept. 9                West County              Barry
   Half-Day Afternoon Class Meets 1:00-4:00pm (3 hours)                    WORKGROUP SOFTWARE
   G2511 Mon., Nov. 7        West County          Barry
                                                                           Microsoft Outlook
   Transitioning to Office 2010 from Office 2003
   (Prerequisite: Experience using any version of Office. Specific
                                                                           Introduction to Outlook
   skills include opening and saving files, using the mouse to navigate
                                                                           (Prerequisite: Introduction to Windows or equivalent experience.)
   through documents, and locating commands.) Learn what you
                                                                           Learn to manage your schedule and communications with Outlook.
   need to know to make a smooth transition to Office 2010. This
                                                                           Use the Contacts feature to keep track of people, phone numbers,
   course gives you an overview of the interface differences between
                                                                           and addresses; set up meetings and appointments using the Calendar;
   Office 2010 and previous Office suites and helps you navigate
                                                                           and create a “to-do” list or delegate tasks using the Tasks feature.
   effectively through the Office 2010 applications. Learn how to use
                                                                           Learn Outlook’s e-mail tools, including flagging messages for follow-
   the Ribbon to access commands and how Backstage View allows
                                                                           up, attaching files, and using the Out-of-Office Assistant. Discover
   you to manage documents. Find out more about the current file
                                                                           how to stay organized using folders and categories, and customize
   formats and how to work with files that use the 97-2003 file for-
                                                                           your workspace to increase your efficiency.
   mats. Understand how Live Preview can save time and effort, and
                                                                           Fee: $189
   increase your Office efficiency by customizing the Quick Access
                                                                           Outlook 2010
   Toolbar and the Ribbon so the commands you frequently use are
                                                                           One-Day Class Meets 8:30am-4:00pm (6.5 hours)
   within easy reach.
                                                                           G2320 Thurs., Sept. 29             West County               Delcamp
   Fee: $99
   Half-Day Class Meets 8:30am-11:30am (3 hours)
   G2313 Wed., Sept. 28             West County                Delcamp     Intermediate Applications of Outlook
   G2600 Fri., Dec. 2               West County                Hudson      (Prerequisite: Introduction to Outlook or equivalent experience.
                                                                           Some experience with Microsoft Office applications is also recom-
   Half-Day Afternoon Class Meets 1:00-4:00pm (3 hours)                    mended.) Learn how to import data from external files and how
   G2252 Wed., Aug. 31       West County          Barry                    to give other Outlook users access to your Calendar and other
                                                                           Outlook items. Create e-mail rules to manage mail messages, use
   Accelerated Topics in Office: Working with Multiple                     vCards as a way to quickly share contact information, and display the
   Programs                                                                Inbox or Contacts through customized views designed to meet your
   (Prerequisites: Introduction to Windows or equivalent experience.       specific needs. Other topics include creating templates for frequently
   Students should be familiar with the Office 2007 or Office 2010         sent e-mail messages, inserting signatures into messages, understand-
   Ribbon. Some experience is recommended with one or more of              ing the Archive options, and creating dynamic distribution lists.
   the following programs: Word, Excel, PowerPoint, or Outlook.)           Fee: $189
   Office products are designed to work together, sharing both con-        Outlook 2010
   tent and formatting. Learn to take advantage of each program’s          One-Day Class Meets 8:30am-4:00pm (6.5 hours)
   strengths in a workflow that may require you to switch among            G2321 Fri., Sept. 30             West County              Delcamp
   programs multiple times. Discover how to incorporate material
   created in a different Office program, create and manage links and
   embedded content, and design consistent document appearance
   across programs using the Office Themes. Additional topics include
   understanding the Paste Options and incorporating Outlook into
   your workflow.                                                                       Intensive Outlook 2010 Training
   Fee: $99                                                                  Join us for Outlook week. Each one-day class costs $189.
   Office 2007
   Half-Day Class Meets 8:30am-11:30am (3 hours)                             Introduction to Outlook, Thurs., Sept. 29
   G2278 Fri., Aug. 26              West County             Delcamp          Intermediate Applications of Outlook, Fri., Sept. 30
   Office 2010
   Half-Day Class Meets 8:30am-11:30am (3 hours)
   G2490 Thurs., Oct. 20     West County         Hudson
   September – December 2011            •     Computer Education & Training Center             •     (314) 984-9000         •       www.cetc.umsl.edu
                                                                                                              Office 2003, 2007 & 2010 11




                                                                                                                                              Office, Organization & Workgroup
    Office 2003, 2007 & 2010 Advice
    Are You Using Office 2003?
    Microsoft made significant changes from Office 2003 to Office 2007, including the interface, features, and file formats. There were
    fewer and less significant changes from Office 2007 to Office 2010. If your organization has not yet switched to Office 2007 or 2010,
    we recommend you take our Office 2003 classes.

    Are You Using Office 2007?
    If you are a new user or someone with limited experience, take the introductory course in the software you are interested in. For
    example, if you want to take Word 2007 classes, first take Introduction to Word in version 2007. If you have some experience with
    the software, but want to make sure you learn the new features of the 2007 version, take the introductory course in the software
    you are interested in.

    Are You Using Office 2010?
    Office 2007 and 2010 are very similar for the major applications. If you use 2010 you could take our 2007 or 2010 courses in Excel,
    Access, PowerPoint, and Word. However, the advanced Word and PowerPoint courses will have feature enhancements not available in
    Office 2007.

    Outlook
    There were significant changes between the Outlook versions 2003, 2007, and 2010.You should take the courses in the version you
    are using.

    InfoPath, OneNote,Visio, Publisher, & Project
    These applications have significant differences between versions 2007 and 2010.You should take the courses in the version you are
    using. If you are using Office 2003, you could also take the 2007 version of these courses as the versions are similar for these
    applications.

    Are You an Experienced Office 2003 User Switching to 2007 or 2010?
    If you are an experienced user who needs an overview of the changes, you should consider taking one of our half-day courses:
    Transitioning to Office 2007 or Transitioning to Office 2010 from Office 2003 (see p. 10).You can then move into an inter-
    mediate or advanced course, after checking the course prerequisites to ensure you have the experience required.

    Accelerated Topics in Office: Working with Multiple Programs shows you how to share content among programs, as well as
    take advantage of each application’s strengths in a workflow environment (see p. 10).




     What training do you need?                 What is your experience?                   Recommended classes
     I need to learn Office 2003                Limited experience                         Introduction to Word, Excel,
                                                                                           PowerPoint, or Access 2003

     I need to learn Office 2007 or 2010        Limited experience                         Introduction to Word, Excel,
                                                                                           PowerPoint, or Access 2007 or 2010
     I’m switching to Office 2007 from an       Limited experience                         Introduction to Word, Excel,
     earlier version                                                                       PowerPoint, or Access 2007 or 2010

     I’m switching to Office 2010 from an       Limited experience                         Introduction to Word, Excel,
     earlier version                                                                       PowerPoint, or Access 2007 or 2010

     I’m switching to Office 2007 from an       Experienced user                           Transitioning to Office 2007
     earlier version

     I’m switching to Office 2010 from          Experienced user                           Transitioning to Office 2010 from
     Office 2003                                                                           Office 2003




September – December 2011          •     Computer Education & Training Center          •       (314) 984-9000       •     www.cetc.umsl.edu
12 Excel


   SPREADSHEET                                                            Advanced Applications of Excel
                                                                          (Prerequisite: Intermediate Applications of Excel or equivalent
   Microsoft Excel                                                        experience.) Learn advanced functions and database management
                                                                          techniques, including sorting and filtering data, using database sta-
   Introduction to Excel                                                  tistical functions. Get the most out of your Excel applications by
   (Prerequisite: Introduction to Windows or equivalent experi-           linking data between worksheets and workbooks. Other topics
   ence.) Use Excel to create spreadsheets for accounting, budget-        include using lookup tables and performing what-if analysis using
   ing, expense tracking, and other applications. Learn to set up and     Goal Seek and scenarios.
   format worksheets and enter labels, values, and formulas. Discover     Fee: $189
   how to select data, restrict data entry, adjust column widths, and     Excel 2003
   move around the worksheet. Other topics include using simple           One-Day Class Meets 8:30am-4:00pm (6.5 hours)
   statistical functions, editing and deleting data, moving and copying   G2464 Tues., Oct. 4               West County                Koerper
   cell contents, understanding absolute and relative references, set-    G2563 Tues., Nov. 22              West County                Koerper
   ting up worksheet pages, and printing.                                 Excel 2007
   Fee: $189                                                              One-Day Class Meets 8:30am-4:00pm (6.5 hours)
   Excel 2003                                                             G2347 Fri., Sept. 23     West County          Barry
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                          G2504 Fri., Nov. 4       West County          Lux
   G2362 Thurs., Sept. 22             West County               Koerper   G2658 Tues., Dec. 20     West County          Koerper
   G2561 Tues., Nov. 8                West County               Koerper
                                                                          Excel 2010
   Excel 2007                                                             One-Day Class Meets 8:30am-4:00pm (6.5 hours)
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                          G2476 Tues., Oct. 18     West County          Barry
   G2345 Thurs., Sept. 8    West County          Barry                    G2686 Fri., Dec. 16      West County          Lux
   G2324 Fri., Sept. 30     West County          Hudson
   G2502 Wed., Nov. 2       West County          Lux                      Accelerated Topics in Excel: Introduction to
   G2656 Tues., Dec. 6      West County          Barry                    PivotTables
   Two-Evening Class Meets 6:30-9:30pm (6 hours)                          (Prerequisite: Intermediate Applications of Excel or equivalent
   T2199 Tues., Oct. 18 & 25 West County         Barry                    experience.) In this quick-paced, introductory course, you will
   Excel 2010                                                             learn how to save time extracting, organizing, and summarizing
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                          meaningful data from Excel spreadsheets or other sources by
   G2474 Tues., Oct. 4      West County          Lux                      creating interactive PivotTables and PivotCharts. In this course,
   G2684 Wed., Dec. 14      West County          Lux                      you will learn to summarize large amounts of information in a few
                                                                          steps using Excel’s PivotTable and PivotChart Wizard. Create and
                                                                          customize a PivotTable, view subsets of data, and show or hide
   Intermediate Applications of Excel                                     details. Discover how to create and design a PivotChart to view
   (Prerequisite: Introduction to Excel or equivalent experience.
                                                                          the summarized data in graphical format.
   You should know how to create formulas using the formula bar
                                                                          Fee: $99
   and understand absolute and relative references.) Learn to design
                                                                          Excel 2003
   effective spreadsheets that others can use and interpret easily.
   Practice applying effective design techniques, including naming        Half-Day Class Meets 8:30am-11:30am (3 hours)
   cells, protecting cells, and making your spreadsheets easy to read.    G2564 Wed., Nov. 30               West County              Koerper
   Additional topics include working with multiple worksheets, cre-       Excel 2007
   ating templates, rounding data, using conditional functions, and       Half-Day Class Meets 8:30am-11:30am (3 hours)
   applying conditional formatting.                                       G2365 Wed., Sept. 21      West County         Barry
   Fee: $189                                                              G2581 Mon., Nov. 21       West County         Barry
   Excel 2003
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                          Accelerated Topics in Excel: Intermediate
   G2363 Wed., Sept. 28              West County              Koerper     PivotTables
   G2562 Mon., Nov. 14               West County              Koerper     (Prerequisite: Excel PivotTables: Introduction or equivalent
   Excel 2007                                                             experience.) In this fast-paced course, discover how to create
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                          PivotTables from multiple consolidation ranges, use macros to
   G2346 Fri., Sept. 16     West County          Barry                    refresh your data, synchronize multiple tables, and set up interac-
   G2325 Fri., Oct. 7       West County          Barry                    tive Web data summaries. You will create PivotTables from a large
   G2503 Thurs., Nov. 3     West County          Lux                      database to view specific data and work with calculation and date
   G2657 Tues., Dec. 13     West County          Barry                    fields. Discover the tips and shortcuts that will make you more
                                                                          efficient and your PivotTables more effective in summarizing your
   Two-Evening Class Meets 6:30-9:30pm (6 hours)                          data.
   T2200 Tues., Nov. 8 & 15  West County         Barry                    Fee: $99
   Excel 2010                                                             Excel 2003
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                          Half-Day Afternoon Class Meets 1:00-4:00pm (3 hours)
   G2475 Tues., Oct. 11     West County          Lux                      G2565 Wed., Nov. 30               West County              Koerper
   G2685 Thurs., Dec. 15    West County          Lux                      Excel 2007
                                                                          Half-Day Afternoon Class Meets 1:00-4:00pm (3 hours)
              Intensive Excel 2007 Training                               G2366 Wed., Sept. 21      West County          Barry
                                                                          G2582 Mon., Nov. 21       West County          Barry
    Join us for Excel 2007 week. Each one-day class costs $189.
       Introduction to Excel, Wed., Nov. 2
       Intermediate Applications of Excel, Thurs., Nov. 3
       Advanced Applications of Excel, Fri., Nov. 4
   September – December 2011            •    Computer Education & Training Center           •    (314) 984-9000         •    www.cetc.umsl.edu
                                                                                                                              Excel & Project 13

 The following courses (Creating Charts with Excel, Special Topics in Excel: Data Manipulation, Excel Macros Using VBA, and




                                                                                                                                                      Spreadsheet & Project Management
 Special Topics in Excel: Formulas and Functions) use Excel 2007. Students who use Excel 2003 could take these classes, although
 there have been changes to the software interface and options. Students with Excel 2010 could also take these classes, since the
 two versions (Excel 2007 and 2010) are very similar.

 Creating Charts with Excel                                                Special Topics in Excel: Formulas and Functions
 (Prerequisite: Intermediate Applications of Excel or equivalent           (Prerequisite: Intermediate Applications of Excel or equivalent expe-
 experience.) Learn to use Excel to create powerful graphic presen-        rience.) This course concentrates on Excel functions and formulas.
 tations, including bar graphs, pie charts, exploded pies, line graphs,    Look at commonly used text and data functions, including chang-
 scatter plots, and three-dimensional graphs. Discover how to              ing the case of text, combining text cell contents (e.g., first and last
 scale and format graphs, properly select data ranges, add titles and      names), and comparing cell contents. Work with date and time func-
 labels, set up legends, use grids and color, and make other graphic       tions and logical functions. Other topics will include using simple
 enhancements. Learn to select the appropriate graph type for your         form fields to select items from a list (note that this will not cover
 data and to alter that graph for your specific needs. Other topics        creation of custom forms, as that requires VBA), using the formula
 include principles of graphing, printing graphs, and effective spread-    editing toolbar to check your data and solve formula errors, and
 sheet design to aid in graphing.                                          working with arrays.
 Fee: $189                                                                 Fee: $189
 One-Day Class Meets 8:30am-4:00pm (6.5 hours)                             One-Day Class Meets 8:30am-4:00pm (6.5 hours)
 G2348 Thurs., Sept. 29             West County               Barry        G2580 Thurs., Nov. 10            West County                  Barry

 Special Topics in Excel: Data Manipulation                                Excel Macros Using VBA
 (Prerequisite: Intermediate Applications of Excel or equivalent expe-     (Prerequisites: Significant Excel experience and Intermediate
 rience.) Discover ways to save time and increase your efficiency,         Applications of Excel or equivalent experience. Students should have
 whether you are working with one large spreadsheet or multiple            a solid knowledge of Excel, a strong background using conditional
 tables. Find out how you can combine portions of several lists or         statements, and substantial experience working with spreadsheets
 tables into one consolidated table. Learn how to navigate with            before taking this class.) In this two-day class, discover the power of
 hyperlinks through multiple sheets of a workbook, multiple work-          macros by using Visual Basic for Applications to automate your Excel
 books, or even to other programs. Save valuable time by accessing         applications. Visual Basic terminology, such as procedures, methods,
 custom-made views of your spreadsheet. Topics include how to              properties, and objects, will be introduced and used to create and
 eliminate repetitive typing by creating, modifying, and printing com-     edit Excel macros. Understand how to modify recorded macros and
 ments for compressed notations on spreadsheets; use Group and             write original macros using Visual Basic in order to customize your
 Outline to quickly show and print totals in sections of your spread-      interface and create dialog boxes for input and messages. Additional
 sheet; and create styles to use in multiple spreadsheets.                 topics include using control structures, such as conditionals and
 Fee: $189                                                                 loops.
 One-Day Class Meets 8:30am-4:00pm (6.5 hours)                             Fee: $349
 G2491 Tues., Oct. 25              West County               Barry         Two-Day Class Meets 8:30am-4:00pm (13 hours)
                                                                           G2449 Wed., Oct. 5 & Thurs., Oct. 6 West County Barry
                                                                           G2595 Tues., Nov. 15 & Wed., Nov. 16 West County Barry

  PROJECT MANAGEMENT
  Whether you run a small business or you are a project director in a large corporation, Microsoft Project can help you manage
  your organization’s resources and schedules.

  Microsoft Project
  Introduction to Project                                                  Intermediate Applications of Project
  (Prerequisite: Introduction to Windows or equivalent experience.)        (Prerequisite: Introduction to Project or equivalent experience.)
  Learn to use Microsoft Project to organize your project’s tasks,         Learn to handle multiple projects. Practice entering fixed costs,
  resources, and schedule. Create a Gantt planning chart from scratch      such as material and subcontract costs, and creating and assigning
  by identifying and entering tasks, creating task dependencies and        resources across several projects. Learn how to combine multiple
  constraints, assigning resources, and printing out the finished chart.   projects into one consolidated master schedule. Topics include
  Establish the project calendar, determine and change task durations,     splitting tasks, as well as assigning priorities to tasks and subtasks.
  view and check your project schedule, and use the schedule to            Additional topics include the various resource options, such as
  track project status. You will also learn about the Critical Path and    resource leveling, resource contouring, work assignment delays or
  its importance in project management.                                    overtime, resource loading, and assigning more than one resource
  Fee: $189                                                                value to a single resource.
  Project 2007                                                             Fee: $189
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)                            Project 2007
  G2435 Wed., Oct. 5                 West County               Lux         One-Day Class Meets 8:30am-4:00pm (6.5 hours)
  G2615 Thurs., Dec. 15              West County               Otto        G2436 Thurs., Oct. 6                West County                Lux
  Project 2010                                                             G2616 Fri., Dec. 16                 West County                Otto
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)                            Project 2010
  G2518 Tues., Nov. 1      West County          Otto                       One-Day Class Meets 8:30am-4:00pm (6.5 hours)
                                                                           G2519 Tues., Nov. 8      West County          Otto




September – December 2011            •     Computer Education & Training Center             •     (314) 984-9000        •    www.cetc.umsl.edu
14 Word & PowerPoint


   WORD PROCESSING                                                         PRESENTATION GRAPHICS

   Microsoft Word                                                          Introduction to PowerPoint
                                                                           (Prerequisite: Introduction to Windows or equivalent experience.)
   Introduction to Word                                                    Learn to use PowerPoint to create effective presentations, from start
   (Prerequisite: Introduction to Windows or equivalent experience         to finish. Master the skills necessary to plan and develop presenta-
   using the mouse.) Learn to use Microsoft Word to create and save        tions, including starting a presentation, editing text, reorganizing your
   word-processing documents. Learn to enter and edit text, control        slides to make a more logical presentation, adding multiple-level
   line spacing, format a document, and use non-printing characters.       bulleted entries, and setting up a slide show. Learn how to use slide
   Discover the ease of making changes by moving, copying, and past-       masters to make slide templates that are consistent in appearance.
   ing text. Understand the difference between Save and Save As            Additional topics include using drawing tools, clip art, and WordArt to
                                                                           create attractive art and logos that add impact to your presentation.
   and how to set up documents for printing. Learn how to apply
                                                                           Fee: $189
   paragraph formatting in your documents, including properly setting
                                                                           PowerPoint 2003
   paragraph indents and tabs and centering text. Other topics include
                                                                           One-Day Class Meets 8:30am-4:00pm (6.5 hours)
   changing the type style, inserting the date, and using the Find and
                                                                           G2373 Tues., Sept. 13              West County               Koerper
   Replace commands to make global changes.
                                                                           G2662 Fri., Dec. 2                 West County               Koerper
   Fee: $189
   Word 2007                                                               PowerPoint 2007
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                           One-Day Class Meets 8:30am-4:00pm (6.5 hours)
   G2637 Wed., Dec. 7                West County               Haupt       G2351 Fri., Sept. 9      West County          Haupt
                                                                           G2526 Tues., Nov. 15     West County          Haupt
   Word 2010
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                           PowerPoint 2010
   G2410 Fri., Sept. 30     West County          Haupt                     One-Day Class Meets 8:30am-4:00pm (6.5 hours)
                                                                           G2416 Wed., Oct. 19      West County          Haupt
   Intermediate Applications of Word
   (Prerequisite: Introduction to Word or equivalent experience.)          Intermediate Applications of PowerPoint
   Further your Word skills as you learn about formatting, tables, and     (Prerequisite: Introduction to PowerPoint or equivalent experience.)
   mail merge. Discover how to create tables to format data and text       Learn more advanced features of PowerPoint, including charts, tem-
   on your page. Table topics include inserting and deleting rows and      plates, and presentation techniques. Learn to create effective charts
   columns, editing tables, creating borders, and other formatting tech-   and graphs by keying in your data or by importing charts from other
   niques. Understand how to insert section breaks in a document in        programs using PowerPoint’s built-in datasheet capability. Learn to
   order to format specific areas or customize page numbering. Learn       create organizational charts. Discover how to alter the design tem-
   to create personalized form letters and perform queries using Mail      plates’ and create custom templates. Other topics include creating
   Merge. Other topics include headers and footers; text flow options,     tables and linking between different Microsoft Office programs.
   such as widow/orphan control; and the Paste Special feature.            Fee: $189
   Fee: $189                                                               PowerPoint 2003
   Word 2007                                                               One-Day Class Meets 8:30am-4:00pm (6.5 hours)
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                           G2374 Wed., Sept. 14             West County               Koerper
   G2638 Tues., Dec. 13              West County              Haupt        G2663 Fri., Dec. 9               West County               Koerper
   Word 2010                                                               PowerPoint 2007
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                           One-Day Class Meets 8:30am-4:00pm (6.5 hours)
   G2411 Fri., Oct. 7       West County          Delcamp                   G2352 Fri., Sept. 16     West County          Haupt
                                                                           G2527 Mon., Nov. 21      West County          Haupt
   Advanced Applications of Word                                           PowerPoint 2010
   (Prerequisite: Intermediate Applications of Word or equivalent          One-Day Class Meets 8:30am-4:00pm (6.5 hours)
   experience.) Learn to create sophisticated documents that feature       G2417 Wed., Oct. 26      West County          Haupt
   multi-column, newspaper-style formats. Discover how to import
   graphics and artwork and integrate graphics and columns. Learn          Advanced Applications of PowerPoint
   how to define styles and templates for document formats that you        (Prerequisite: Intermediate Applications of PowerPoint or equivalent
   frequently use. Create and run simple macros for automating repet-      experience.) Learn to create hyperlinks that connect one slide to
   itive tasks. Use the features that make it easier to share documents    another, to a Web page, or to another file. Investigate how to insert
   with others, including adding comments and tracking changes.            movies and sounds into your presentations and create action buttons
   Fee: $189                                                               to play these sounds and movies. Use the ruler and guides to position
   Word 2007                                                               elements precisely on a slide. Additional topics include inserting com-
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                           ments to proof the presentation and creating custom shows.
   G2639 Tues., Dec. 20              West County               Haupt       Fee: $189
   Word 2010                                                               PowerPoint 2003
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                           One-Day Class Meets 8:30am-4:00pm (6.5 hours)
   G2412 Fri., Oct. 14               West County               Delcamp     G2375 Thurs., Sept. 15           West County                Koerper
                                                                           PowerPoint 2007
            Are you wondering which version you should take?               One-Day Class Meets 8:30am-4:00pm (6.5 hours)
                                                                           G2353 Thurs., Sept. 29   West County          Haupt
            See p. 11 for course advice on Office 2003,                    G2528 Mon., Nov. 28      West County          Haupt
            2007 & 2010.                                                   PowerPoint 2010
                                                                           One-Day Class Meets 8:30am-4:00pm (6.5 hours)
                                                                           G2418 Wed., Nov. 2       West County          Delcamp

   September – December 2011            •     Computer Education & Training Center             •     (314) 984-9000        •    www.cetc.umsl.edu
                                                                                                                                       Access 15




                                                                                                                                                   Presentations, Word Processing & Database
  DATABASE                                                                    Advanced Applications of Access
                                                                              (Prerequisite: Intermediate Applications of Access or equivalent
  Microsoft Access                                                            experience.) This course covers a variety of advanced tips and
                                                                              techniques for designing and using Access databases. Learn to
  Introduction to Access                                                      write special purpose queries, including crosstab and union que-
  (Prerequisite: Introduction to Windows or equivalent experience.)           ries, and design reports that include running sums and conditional
  Learn to use the Microsoft Access database system to keep track of          formatting. Practice using text, date, and conditional functions
  inventory, update mailing lists, and manage information files. Master       to manipulate data. Create complex parameter queries and cus-
  the skills necessary to plan and design a table, as well as add, change,    tom forms to supply parameter values. Additional topics include
  and delete data. Learn how to perform queries on single and mul-            inserting subreports and using PivotTables and PivotCharts to
  tiple tables to find and display data. Discover how to generate simple      summarize your data.
  forms and reports to access or print out the information that you           Fee: $349
  need. Additional topics include global changes, sorting data, date arith-   Access 2007
  metic, modifying the table structure, and database management.              Two-Day Class Meets 8:30am-4:00pm (13 hours)
  Fee: $349                                                                   G2371 Tues., Sept. 27 & Wed., Sept. 28 West County Barry
  Access 2003                                                                 Access 2010
  Two-Day Class Meets 8:30am-4:00pm (13 hours)                                Two-Day Class Meets 8:30am-4:00pm (13 hours)
  G2355 Mon., Sept. 26 & Tues., Sept. 27 West County Koerper                  G2567 Wed., Nov. 9 & Thurs., Nov. 10 West County Lux
  Access 2007
  Two-Day Class Meets 8:30am-4:00pm (13 hours)                                Advanced Topics in Access: Database Design
  G2269 Mon., Aug. 29 & Tues., Aug. 30  West County Barry                     (Prerequisite: Intermediate Applications of Access or equivalent
  G2457 Thurs., Oct. 20 & Fri., Oct. 21 West County Barry                     experience.) Learn to effectively manage a relational database
  G2675 Tues., Dec. 6 & Wed., Dec. 7    West County Lux                       system and work with multiple tables simultaneously. Discover
                                                                              how to identify items to be stored in a database, establish rela-
  Four-Evening Class Meets 6:30-9:30pm (12 hours)                             tionships between the items, and group the items in the appro-
  T2211 Tues., Nov. 1, 8, 15 & 22       West County Lux                       priate tables. Topics include linking database tables, generating
  Access 2010                                                                 reports from multiple tables, querying multiple tables, and updat-
  Two-Day Class Meets 8:30am-4:00pm (13 hours)                                ing tables. Strong emphasis will be placed on effective database
  G2465 Wed., Oct. 12 & Thurs., Oct. 13 West County Lux                       design and deciding how to structure tables within the database.
                                                                              Fee: $349
  Intermediate Applications of Access                                         Access 2007
  (Prerequisite: Introduction to Access or equivalent experience.) This       Two-Day Class Meets 8:30am-4:00pm (13 hours)
  course covers creating effective tables, forms, and reports. Discover       G2559 Thurs., Nov. 17 & Fri., Nov. 18 West County Barry
  how to design forms so you can easily enter, edit, and delete infor-
  mation. Learn the principles of data validation and how to error-           Access 2010
  trap your inputs. This course covers special techniques for creating        Two-Day Class Meets 8:30am-4:00pm (13 hours)
  sophisticated reports, grouping data for subtotals, and generating          G2344 Thurs., Nov. 10 & Fri., Nov. 11 West County Barry
  mailing labels. Additional topics include understanding field properties,
  working with indexes and primary keys, using functions in queries and         Want more database design?
  reports, and creating summary reports.
  Fee: $349                                                                             Our course, Introduction to Relational
  Access 2003
  Two-Day Class Meets 8:30am-4:00pm (13 hours)                                          Database Design Using SQL Server will
  G2356 Tues., Oct. 11 & Wed., Oct. 12 West County Koerper
                                                                                        teach you how to create an optimized, consistent
  Access 2007
  Two-Day Class Meets 8:30am-4:00pm (13 hours)                                          database. See p. 19 for course information.
  G2370 Wed., Sept. 14 & Thurs., Sept. 15 West County         Barry
  G2558 Thurs., Nov. 3 & Fri., Nov. 4     West County         Barry
  G2676 Mon., Dec. 19 & Tues., Dec. 20 West County            Barry           Advanced Topics in Access: Macros
  Access 2010                                                                 (Prerequisite: Intermediate Applications of Access or equivalent
  Two-Day Class Meets 8:30am-4:00pm (13 hours)                                experience.) Learn how to use Access macros to automate a
  G2466 Thurs., Oct. 27 & Fri., Oct. 28   West County         Lux             database. Create forms with command buttons that guide users
                                                                              through the typical functions of a database, such as entering
                                                                              and modifying data, searching for specific records, and printing
                                                                              a selection of reports. You will design macros that control the
         Our course Accelerated Topics in Office: Working                     startup of a database, filter data, synchronize multiple forms to
         with Multiple Programs (p. 10) will teach you how to                 the same record, and perform record searches based on user
                                                                              input.
         work with multiple Office applications (Excel, PowerPoint,           Fee: $349
         Word, etc.), sharing both content and formatting,                    Access 2007
                                                                              Two-Day Class Meets 8:30am-4:00pm (13 hours)
         taking advantage of each program’s strengths.                        G2560 Wed., Nov. 30 & Thurs., Dec. 1 West County Lux




September – December 2011            •     Computer Education & Training Center             •    (314) 984-9000        •    www.cetc.umsl.edu
16 Access & FileMaker Pro


    The following programming courses use Access Visual Basic             FileMaker Pro
    for Applications (VBA).
                                                                          Introduction to FileMaker Pro
    Programming Applications of Access: Level 1                           (Prerequisite: Introduction to Windows or equivalent experience.)
    (Prerequisite: Intermediate Applications of Access and Introduction   Learn to use the FileMaker database system to help you keep track
    to Programming Concepts or equivalent experience.) Increase           of inventory, update mailing lists, and manage information files.
    the speed and efficiency of your databases and create customized      Master the skills necessary to plan and design a database, as well
    applications through Access Visual Basic for Applications (VBA).      as add, change, and delete data. Additional topics include working
    You’ll learn to use programming control structures to automate        with multiple layouts/reports, using Date type data, using the draw-
    your database applications, as well as reduce your database size      ing tools, manipulating your database with the Sort and Find com-
    to save disk space, use less memory, and make your applications       mands, converting an Excel data table into a FileMaker database, and
    run faster. Write code and create variables and control structures    exporting a FileMaker table into Excel format.
    using the Visual Basic Editor window. Along with basic commands,      Fee: $189
    techniques, and error trapping, you’ll discover the differences       One-Day Class Meets 8:30am-4:00pm (6.5 hours)
    among the various programming modules and learn about events,         G2406 Thurs., Oct. 6               West County              Koerper
    variables, and constants. Other topics include automating the
    opening and closing forms and other objects; programmatically fil-    Intermediate Applications of FileMaker Pro
    tering your forms and reports; and using option groups, list boxes,   (Prerequisite: Introduction to FileMaker Pro or equivalent expe-
    and combo boxes.                                                      rience.) Increase your knowledge of FileMaker Pro by learning
    Fee: $349                                                             techniques for designing an effective database. Learn to use the
    Two-Day Class Meets 8:30am-4:00pm (13 hours)                          calculation and summary fields to customize your database files.
    G2393 Thurs., Sept. 29 & Fri., Sept. 30 West County Richey            Learn to automatically look up data by linking one database or table
    G2587 Mon., Nov. 28 & Tues., Nov. 29 West County Richey               to another in order to populate a table. Discover how to create
                                                                          more sophisticated reports, including defining and placing totals and
    Programming Applications of Access: Level 2                           subtotals within reports. Other topics covered include mail merge,
    (Prerequisite: Programming Applications of Access: Level 1 or         generating mailing labels, converting files from earlier versions, and
    equivalent experience.) Build on your knowledge of Access pro-        creating a static HTML table to display your data on the Web.
    gramming using more advanced VBA programming code. Learn              Fee: $189
    how to use ActiveX Data Objects (ADO) coding techniques and           One-Day Class Meets 8:30am-4:00pm (6.5 hours)
    Recordset objects to work with your data. Develop error-free          G2407 Thurs., Oct. 13             West County                 Koerper
    applications using formal error-trapping techniques to trap, col-
    lect, and respond to errors. Additional topics include using loops    Advanced Applications of FileMaker Pro
    to repeat operations and programming your applications using          (Prerequisite: Intermediate Applications of FileMaker Pro or equiva-
    ActiveX controls.                                                     lent experience.) Learn to effectively use a relational database sys-
    Fee: $349                                                             tem to work with multiple databases. Discover how to use scripts
    Two-Day Class Meets 8:30am-4:00pm (13 hours)                          to automate your FileMaker database, link to other FileMaker
    G2494 Thurs., Oct. 13 & Fri., Oct. 14       West County Richey        databases, create buttons, and use repeating fields. Additional top-
    G2688 Mon., Dec. 12 & Tues., Dec. 13 West County Richey               ics include Solutions (templates) and using text parsing calculations
                                                                          to filter out unneeded text. Learn to create an interactive Web site
    Programming Applications of Access: Level 3                           using a FileMaker database and set up security for your database.
    (Prerequisite: Programming Applications of Access: Level 2 or         Fee: $189
    equivalent experience.) Learn how to make your code more              One-Day Class Meets 8:30am-4:00pm (6.5 hours)
    efficient, expand your knowledge of VBA ADO coding techniques         G2408 Fri., Oct. 21              West County                 Koerper
    using recordsets, and save time and effort through automation.
    Learn to use recordsets to modify record data record-by-record,
    as well as make bulk record changes, create and delete objects          Did you know we offer a Chancellor’s
    using code, and establish relationships between objects using VBA
    code. Examine useful application optimization techniques, such
                                                                            Certificate in Database Technology?
    as variable arrays, connection objects, and constants. Other top-
    ics include importing data from an external database, text file,        Learn about database technology and database
    or Excel spreadsheet and automating by creating and controlling         design, development, and implementation. You’ll
    Excel and Outlook from an Access database.
    Fee: $349                                                               work with both file-based and server-based
    Two-Day Class Meets 8:30am-4:00pm (13 hours)                            applications.
    G2495 Thurs., Oct. 27 & Fri., Oct. 28       West County Richey
    G2689 Mon., Dec. 19 & Tues., Dec. 20 West County Richey                 For more information, see the inside back cover
                                                                            of this catalog or visit our Web site at
                                                                               http://www.cetc.umsl.edu/dbfacts.html




   September – December 2011             •    Computer Education & Training Center           •    (314) 984-9000        •    www.cetc.umsl.edu
                                                                                                   Crystal Reports & SQL Language 17


  DATABASE (CLIENT/SERVER) REPORTS                                         CLIENT SERVER




                                                                                                                                                    Database & Database Design & Client Server
  Crystal Reports                                                          SQL
                                                                           Our SQL language courses (Introduction to SQL, Intermediate
  Introduction to Crystal Reports                                          Applications of SQL, and Advanced Applications of SQL) are
  (Prerequisite: Introduction to Windows or equivalent experi-
                                                                           taught using Microsoft SQL Server. The courses cover generic
  ence, and an understanding of basic database concepts.) Learn to
                                                                           syntax, so it does not matter which server (SQL Server, Oracle,
  use Crystal Reports to create meaningful, dynamic reports from
                                                                           MySQL, etc.) or version you are using. These courses do not
  your raw data. Practice connecting to a variety of data sources to
                                                                           cover special features of any particular SQL package. Students
  retrieve data for your reports. Learn to use Crystal Reports’ fil-
                                                                           using the MySQL database could also take these classes.
  tering capabilities to select specific records, based on criteria you
  provide. Organize and summarize your data by sorting and grouping
  records. Set up simple formula fields to manipulate text and string      Introduction to SQL
  data. Additional topics include inserting text objects and special       (Prerequisite: Introduction to Windows and Introduction to Access
  fields and applying basic formatting to customize the appearance of      or equivalent experience with another database.) This course intro-
  your reports.                                                            duces SQL using Microsoft SQL Server to demonstrate generic SQL
                                                                           commands that can be used with a variety of client/server database
  Fee: $269
                                                                           systems. Learn how to do ad-hoc queries on a database to select
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)
                                                                           the information you need. Topics include SQL syntax, data definition
  G2290 Tues., Aug. 30               West County               Lux
                                                                           language, and data manipulation language. Learn how to create and
  G2544 Thurs., Nov. 17              West County               Lux
                                                                           update tables, as well as order data, group data, and generate totals.
                                                                           Fee: $189
  Intermediate Applications of Crystal Reports                             One-Day Class Meets 8:30am-4:00pm (6.5 hours)
  (Prerequisite: Introduction to Crystal Reports or equivalent experi-     G2334 Wed., Sept. 14                West County            Lux
  ence.) Explore the flexibility and control of Crystal Reports, as you    G2422 Fri., Oct. 14                 West County            McClellan
  learn to manipulate report data and create sophisticated, custom-        G2542 Tues., Nov. 22                West County            McClellan
  ized reports. Discover how to write formulas to insert derived           G2640 Mon., Dec. 12                 West County            McClellan
  data, customize group names, and isolate the information you need.
  Additional topics include connecting to multiple data sources and        Two-Evening Class Meets 6:30-9:30pm (6 hours)
  adding running total fields.                                             T2209 Wed., Oct. 26 & Nov. 2 West County      McClellan
  Fee: $269
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)                            Intermediate Applications of SQL
  G2291 Wed., Aug. 31               West County             Lux            (Prerequisite: Introduction to SQL or equivalent experience.) This
  G2545 Tues., Nov. 22              West County             Lux            course is designed for those who want to use more advanced SQL
                                                                           commands and work with multiple tables. This course uses Microsoft
  Advanced Applications of Crystal Reports                                 SQL Server to demonstrate generic SQL commands that can be used
  (Prerequisite: Intermediate Applications of Crystal Reports or           with a variety of client/server database systems. Learn to do more
  equivalent experience.) Learn to use parameters to insert or select      complicated queries on a database to select the information you
  data “on the fly,” write advanced formulas, and create subreports to     need. Topics include creating indexes, changing tables, performing sub-
  include multiple reports within one report document. Find out how        queries, and creating views. Learn about different types of joins, like
  Crystal Reports uses SQL commands to select report data, and             inner joins, outer joins, and Cartesian products.
  learn to write your own simple SQL statements to select data for         Fee: $189
  your reports. You’ll also learn to create cross-tab reports to group     One-Day Class Meets 8:30am-4:00pm (6.5 hours)
  and summarize data in two directions.                                    G2335 Thurs., Sept. 15              West County             Lux
  Fee: $269                                                                G2423 Fri., Oct. 21                 West County             McClellan
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)                            G2543 Wed., Nov. 30                 West County             McClellan
  G2292 Thurs., Sept. 1             West County              Lux           G2641 Mon., Dec. 19                 West County             McClellan
  G2546 Tues., Nov. 29              West County              Lux           Two-Evening Class Meets 6:30-9:30pm (6 hours)
                                                                           T2210 Wed., Nov. 9 & 16     West County       McClellan
  Advanced Topics in Crystal Reports:
  Designing Reports                                                        Advanced Applications of SQL
  (Prerequisite: Intermediate Applications of Crystal Reports or           (Prerequisite: Intermediate Applications of SQL or equivalent experi-
  equivalent experience.) Learn to use special report design and for-      ence.) This course uses Microsoft SQL Server to demonstrate generic
  matting techniques to create professional reports. Apply highlight-      SQL commands that can be used with a variety of client/server data-
  ing and conditional formatting to change your report’s appearance        base systems. Learn how to properly design a relational database and
  based on specific data, and create templates to standardize format-      structure tables within the database. Learn the purpose of and how
  ting across multiple reports. Display your data graphically by setting   to specify primary and foreign keys. Understand the advantages of
  up and manipulating charts, and learn to use the Section Expert to       referential integrity and how it can affect data maintenance and pre-
  insert new sections and customize section formatting.                    vent errors. Additional topics include using the UNION operation to
  Fee: $269                                                                combine the results of two queries into a single result set and using
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)                            ROLLUP and CUBE to summarize data.
  G2293 Fri., Sept. 9              West County               Lux           Fee: $189
                                                                           One-Day Class Meets 8:30am-4:00pm (6.5 hours)
                                                                           G2336 Fri., Sept. 16                West County            Lux
                                                                           G2424 Fri., Oct. 28                 West County            McClellan
                                                                           G2644 Mon., Dec. 5                  West County            McClellan




September – December 2011            •     Computer Education & Training Center           •    (314) 984-9000        •    www.cetc.umsl.edu
18 SQL Programming, SQL Server Reporting Services & SQL Server Administration


   Microsoft Transact-SQL Programming                                        Advanced SQL Server Reporting Services
                                                                             (Prerequisite: Intermediate SQL Server Reporting Services or
   Transact-SQL is Microsoft’s extension to the SQL language
                                                                             equivalent experience.) Learn the techniques to make your reports
   and can help increase the flexibility of your database applica-
                                                                             more flexible and efficient. Topics include creating drill-down reports
   tions. Learn to write code to interact with your SQL Server
                                                                             to display detail, either from other reports or from charts, and using
   data.
                                                                             lists for flexibility in arranging data on reports. Discover how sub-
                                                                             reports can increase your efficiency by reusing code, allow you to
   SQL Programming: Level 1                                                  display reports inside the current report, and enable use of multiple
   (Prerequisite: Intermediate Applications of SQL or equivalent expe-       data sources.
   rience.) This course introduces SQL Server programming using              Fee: $239
   Transact-SQL, Microsoft’s proprietary extension to the SQL lan-           One-Day Class Meets 8:30am-4:00pm (6.5 hours)
   guage. Learn how Transact-SQL can help you increase the flexibility       G2415 Wed., Oct. 5                     West County            McClellan
   and usefulness of your database applications. Write and execute           G2670 Tues., Dec. 20                   West County            McClellan
   blocks of code that interact with your SQL Server data by combin-
   ing SQL statements with Transact-SQL programming constructs.
   Learn how to declare and reference variables and use cursors to           SQL Server System Administration
   process rows returned by a query. Additional topics include writ-
   ing conditional and looping structures to control the flow of your        Introduction to SQL Server System Administration
   statements and using the Try...Catch construct to handle excep-           (Prerequisite: Intermediate Applications of SQL or equivalent expe-
   tions.                                                                    rience.) Learn the basics of installing, configuring, and administering
   Fee: $399                                                                 Microsoft SQL Server. Get an overview of SQL Server and how
   Two-Day Class Meets 8:30am-4:00pm (13 hours)                              the current version differs from previous versions and differ-
   G2390 Thurs., Sept. 29 & Fri., Sept. 30 West County Abernathy             ences among editions. Install and configure Microsoft SQL Server
                                                                             Enterprise Edition, and investigate how to troubleshoot your instal-
                                                                             lation, along with how to install and troubleshoot the client tools
   SQL Server Reporting Services                                             used to connect to SQL Server. Learn about some of the common
                                                                             tools and utilities, such as the SQL Server Management Studio, that
   Introduction to SQL Server Reporting Services                             come with the program and can assist you in managing your data-
   (Prerequisite: Introduction to SQL or equivalent experience.) Learn       base. Discuss SQL Server security from the standpoint of creating
   to create professional-quality reports from SQL Server and other          and working with user logon accounts and setting database security
   ODBC-compliant databases. Discover how to create both standard            through database permissions.
   and ad-hoc reports and deliver them via print, Web, e-mail, and           Fee: $399
   PDF files. Create an environment where users can design their own         Two-Day Class Meets 8:30am-4:00pm (13 hours)
   reports with limited database knowledge. Learn to build and format        G2376 Wed., Sept. 7 & Thurs., Sept. 8 West County Richey
   reports with headers, footers, titles, totals, and calculations. The      G2573 Thurs., Nov. 3 & Fri., Nov. 4 West County Richey
   reports you create can contain tables, charts (or both), and can
   drill-down to other reports for greater detail.
   Fee: $239
                                                                             Intermediate SQL Server System Administration
                                                                             (Prerequisite: Introduction to SQL Server System Administration
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)
                                                                             or equivalent experience.) This course emphasizes maintenance,
   G2413 Mon., Oct. 3                  West County               McClellan
                                                                             optimization, and performance tuning of a SQL Server database.
   G2668 Tues., Dec. 6                 West County               McClellan
                                                                             Investigate how to plan the space requirements for a database and
                                                                             control its size. Learn to optimize queries and defragment, import,
   Intermediate SQL Server Reporting Services                                export, back up, and restore databases. Additional topics include
   (Prerequisite: Introduction to SQL Server Reporting Services and          index tuning, multi-user considerations, an introduction to SQL
   Intermediate Applications of SQL or knowledge of joins, or equiva-        Server Integration Services (SSIS), and disaster recovery consider-
   lent experience.) Learn to create sophisticated reports that are          ations.
   customized for your specific needs. This course shows you how             Fee: $399
   to display multiple data sets on one report and combine graph-            Two-Day Class Meets 8:30am-4:00pm (13 hours)
   ics with and without data for visual impact. Other topics include         G2377 Thurs., Sept. 22 & Fri., Sept. 23 West County Richey
   using multi-value parameters and preparing matrix (cross-tab)             G2574 Thurs., Nov. 17 & Fri., Nov. 18 West County Richey
   reports with drill-down capabilities. Learn how to protect your
   data through model item security, security filters, and opaque
   expressions. Generate practical reports that display the information
                                                                             Advanced SQL Server System Administration
                                                                             (Prerequisite: Intermediate SQL Server System Administration or
   needed for decision-making.
                                                                             equivalent experience.) Explore advanced techniques using SQL
   Fee: $239
                                                                             Server to store and retrieve data from other SQL Server and other
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)
                                                                             heterogeneous data sources. Probe deeper into the administra-
   G2414 Tues., Oct. 4                 West County            McClellan
                                                                             tion of SQL Server with a discussion of the Microsoft Distributed
   G2669 Tues., Dec. 13                West County            McClellan
                                                                             Transaction Coordinator and distributed transactions. Investigate
                                                                             various methods of storing and retrieving data from multiple loca-
                                                                             tions, including linked servers, data replication, and log shipping.
  Intensive SQL Server Reporting Services                                    Learn how to configure snapshot, transactional, and merge replica-
  Training                                                                   tion and the advantages and disadvantages of each.
   Join us for SQL Server Reporting Services week. Each one-day class        Fee: $399
   costs $239.                                                               Two-Day Class Meets 8:30am-4:00pm (13 hours)
     Introduction to SQL Server Reporting Services, Mon., Oct. 3             G2378 Thurs., Oct. 6 & Fri., Oct. 7         West County Richey
     Intermediate SQL Server Reporting Services, Tues., Oct. 4               G2575 Thurs., Dec. 1 & Fri., Dec. 2 West County Richey
     Advanced SQL Server Reporting Services, Wed., Oct. 5



    September – December 2011             •    Computer Education & Training Center            •    (314) 984-9000         •    www.cetc.umsl.edu
                                                                                                              Oracle & Database Design 19

Oracle                                                                     PL/SQL is Oracle’s programming language that can increase




                                                                                                                                                    Client Server, Database Reports & Database Design
                                                                           the flexibility of your database applications. Combine PL/SQL
Fundamentals of SQL Using Oracle: Level 1                                  with your SQL statements to interact with your Oracle data.
(Prerequisite: Introduction to Windows and Introduction to Access or
equivalent experience with another database.) This course introduces       Oracle Programming Using PL/SQL: Level 1
a variety of SQL commands useful in working with Oracle databases.         (Prerequisite: Fundamentals of SQL Using Oracle: Level 2 or equiva-
Learn to create effective queries by using SQL SELECT statements           lent experience.) Learn how Oracle’s PL/SQL programming language
to retrieve and sort records from your tables. Work with compari-          can help you increase the flexibility and usefulness of your database
son and logical operators to display only records that meet certain        applications. Write and execute blocks of code that interact with
criteria. Practice creating tables and inserting, updating, and deleting   your Oracle data by combining SQL statements with PL/SQL pro-
records. Additional topics include deleting, renaming, and truncating      gramming constructs. Learn how to declare and reference variables
tables and controlling transactions by committing and reversing data-      in PL/SQL and use cursors to process rows returned by a query.
base changes.                                                              Practice writing conditional and looping structures to control the
Fee: $189                                                                  flow of statements within your PL/SQL blocks. Throughout the
One-Day Class Meets 8:30am-4:00pm (6.5 hours)                              course, you will learn and apply many techniques for writing effective
G2479 Wed., Oct. 19                  West County              Lux          code, including using efficient logic, incorporating accepted naming
                                                                           conventions, and commenting your code.
Fundamentals of SQL Using Oracle: Level 2                                  Fee: $399
(Prerequisite: Fundamentals of SQL Using Oracle: Level 1 or equiva-        Two-Day Class Meets 8:30am-4:00pm (13 hours)
lent experience.) Further your SQL skills using Oracle by refining         G2482 Tues., Oct. 25 & Wed., Oct. 26 West County Abernathy
your queries to retrieve the information you need from single and
multiple tables. Understand the different types of joins and how to        Oracle Programming Using PL/SQL: Level 2
use them to display data from multiple tables. Learn to use a variety      (Prerequisite: Oracle Programming Using PL/SQL: Level 1 or equiva-
of SQL functions to replace null values, perform calculations, and         lent experience.) Extend and apply your knowledge of PL/SQL by
customize the format of date data. Practice using SQL group func-          writing reusable procedures, functions, and packages that incorporate
tions to count records, determine minimum and maximum values,              common programming constructs along with various SQL commands
calculate sums and averages, and display subtotals. Additional topics      and functions. Understand the different types of triggers and learn
include creating and understanding the appropriate uses of views and       to write triggers that respond to data manipulation events, such as
subqueries.                                                                inserting, updating, and deleting records. Additional topics include
Fee: $189                                                                  learning effective methods for testing your code, handling errors, and
One-Day Class Meets 8:30am-4:00pm (6.5 hours)                              managing program units and triggers.
G2480 Thurs., Oct. 20               West County            Lux             Fee: $399
                                                                           Two-Day Class Meets 8:30am-4:00pm (13 hours)
Fundamentals of SQL Using Oracle: Level 3                                  G2583 Tues., Nov. 8 & Wed., Nov. 9          West County Abernathy
(Prerequisite: Fundamentals of SQL Using Oracle: Level 2 or equiva-
lent experience.) This course focuses on advanced applications of
SQL in an Oracle environment, including managing tables and users.         DATABASE DESIGN
Practice creating sophisticated tables that include constraints to vali-
date your data. Understand the rules of referential integrity and how      Our relational database design course will get you started on
to create primary and foreign keys that enforce these rules. Learn to      the design process so that you can maximize the speed and
modify the structure of existing tables by adding, deleting, and renam-    efficiency of your database. Learn the planning strategies,
ing columns. Control database access by creating users and roles and       implementation steps, and performance improvements that
granting object and system privileges. Additional topics include writ-     will optimize your database and ensure consistency.
ing and executing SQL scripts and creating and maintaining indexes,        Although SQL Server is used in this course, the principles
sequences, and synonyms.                                                   taught apply to a range of other database applications,
Fee: $189                                                                  including Oracle and Access. Students using other relational
One-Day Class Meets 8:30am-4:00pm (6.5 hours)                              database applications could take this course to learn about
G2481 Fri., Oct. 21                 West County            Lux             basic design and implementation.

                                                                           Introduction to Relational Database Design Using
      Not using Oracle?                                                    SQL Server
                                                                           (Prerequisite: Introduction to Windows or equivalent experience.)
      See p. 17 for general SQL language courses.                          If you are creating a new relational database or want to improve
                                                                           the speed and efficiency of an existing one, this course will guide
                                                                           you through the planning strategies you need to optimize your
                                                                           database. Learn the terminology and basic features of a relational
                                                                           database. Discover important design objectives that ensure con-
                                                                           sistency, eliminate redundancy, maximize speed, and enforce data
                                                                           integrity and security. Explore the three-schema architecture
                     SQL Server 2008                                       essential to good design, as well as the design stages in the data-
   Work with SQL Server 2008 in our SQL Server Reporting                   base life cycle, including conception and planning, translating design
                                                                           into the database structure, and tweaking the database to improve
   Services, SQL Server System Administration, and Relational              performance. Other topics include choosing the appropriate data
                                                                           types and documenting the database for yourself and coworkers.
          Database Design Using SQL Server courses.                        Fee: $399
                                                                           Two-Day Class Meets 8:30am-4:00pm (13 hours)
                                                                           G2389 Mon., Sept. 26 & Tues., Sept. 27 West County Richey
                                                                           G2577 Mon., Nov. 7 & Tues., Nov. 8          West County Richey

September – December 2011             •    Computer Education & Training Center            •     (314) 984-9000        •    www.cetc.umsl.edu
20 HTML & CSS



                       Web Design                                     and           Development
     HTML                                                                         Transitioning to HTML5
                                                                                  (Prerequisite: Intermediate Applications of HTML or equivalent expe-
     Our HTML classes teach you how to use HTML to create Web
                                                                                  rience.) HTML5 features include video playback without the need for
     sites or to quickly adjust code you have generated from a pro-
                                                                                  browser plug-ins, such as Flash and Silverlight, and new form input
     gram like Dreamweaver. The classes use the current XHTML
                                                                                  types. This class is intended for those who already know the basics
     tags, in addition to introducing code from the evolving HTML5
                                                                                  of HTML and want to learn about the new tags found in HTML5,
     standard.
                                                                                  including those for adding multimedia, sound content, and graphics.
                                                                                  Additional topics include using new tags to identify headers and foot-
     Introduction to HTML                                                         ers, grouping headings, creating a navigation section, using article tags,
     (Prerequisite: Introduction to Windows or equivalent experience.             drawing on the canvas with JavaScript, and using the new form types
     Students should be familiar with the Windows interface and be                for e-mail, dates, and numbers.
     able to copy and paste material from one document to another, as             Fee: $99
     well as move, change, resize, and manage multiple windows.) This             Half-Day Class Meets 8:30am-11:30am (3 hours)
     course introduces the basics of creating Web pages using Hypertext           G2340 Tues., Sept. 13              West County              Fry
     Markup Language (HTML). Understand the philosophy of HTML,                   G2572 Fri., Nov. 11                West County              Fry
     effective Web page design, and how a markup language works. Learn
     the basic HTML document elements, tags, and structures. Topics
     include titles, headings, paragraphs, nested lists, horizontal rules, line   Cascading Style Sheets
     breaks, basic formatting techniques, and changing text appearance
     and color. Additional topics include using special characters, placing       Introduction to Cascading Style Sheets
     graphics in Web-compatible formats, and setting up hypertext links           (Prerequisite: Intermediate Applications of HTML or equivalent expe-
     on Web pages.                                                                rience.) Learn to use Cascading Style Sheets (CSS) to effectively and
     Fee: $189                                                                    efficiently format and position Web page elements. Create CSS to
     One-Day Class Meets 8:30am-4:00pm (6.5 hours)                                add presentation-type effects, visual qualities, and layout options to
     G2327 Mon., Sept. 19              West County                 Barry          your Web pages. Learn to create drop caps, insert page breaks for
     G2446 Wed., Oct. 26               West County                 Barry          printing, place images and other Web elements on your page, incor-
     G2631 Thurs., Dec. 1              West County                 Barry          porate links that change color as the mouse passes over them, and
                                                                                  access additional text and font properties. Understand how to create
     Two-Evening Class Meets 6:30-9:30pm (6 hours)                                style sheets that are embedded in a particular page, external style
     T2151 Tues., Oct. 11 & 18 West County         Koerper                        sheets that can be used by multiple sheets, and inline styles that apply
                                                                                  to a particular occurrence. Topics include the STYLE, LINK, and @
     Intermediate Applications of HTML                                            import tags and the style attribute of standard HTML tags. Additional
     (Prerequisite: Introduction to HTML or equivalent experience.) This          topics include font, text, color, background, and positioning properties
     course covers techniques for planning and creating attractive Web            unavailable with standard HTML attributes and tags. Style classes and
     pages that combine text and images. Discover how to create tables            rules of precedence for overlapping styles will also be covered.
     to display data and use the table features to align images with text,        Fee: $189
     create newspaper-style columns, and insert side heads. Work with             One-Day Class Meets 8:30am-4:00pm (6.5 hours)
     referencing sections of a Web page for hyperlinks and using image            G2430 Wed., Oct. 12                West County               Barry
     maps for navigation. Learn techniques for designing Web pages                G2634 Thurs., Dec. 15              West County               Barry
     effectively and understand different ways to publish your Web site.
     Additional topics include adding meta and base tags.                         Intermediate Applications of Cascading Style Sheets
     Fee: $189                                                                    (Prerequisite: Introduction to Cascading Style Sheets or equivalent
     One-Day Class Meets 8:30am-4:00pm (6.5 hours)                                experience.) Learn to create page layouts and multiple-column
     G2328 Mon., Sept. 26             West County               Barry             formats using CSS and DIV tags. This class will show you how to
     G2547 Wed., Nov. 2               West County               Barry             use floats to position items and wrap text, nest floats, use negative
     G2632 Fri., Dec. 2               West County               Barry             margins, and create fixed and liquid layouts. Learn to build horizon-
     Two-Evening Class Meets 6:30-9:30pm (6 hours)                                tal and vertical navigation bars with rollover features. Other topics
     T2152 Tues., Oct. 25 & Nov. 1 West County     Koerper                        include formatting tables with CSS, working with graphics, and adding
                                                                                  styles to links. Learn some of the problems in working with mul-
     Advanced Applications of HTML                                                tiple browsers and the troubleshooting techniques that fix Internet
     (Prerequisite: Intermediate Applications of HTML or equivalent               Explorer bugs.
     experience.) Enhance the design and effectiveness of your Web                Fee: $189
     pages using the advanced features of HTML. Learn basic CSS code              One-Day Class Meets 8:30am-4:00pm (6.5 hours)
     for formatting text and the DIV tag for page layout. Create forms            G2431 Thurs., Oct. 13             West County               Barry
     that include multiple-choice questions, comment boxes, and buttons           G2635 Fri., Dec. 16               West County               Barry
     so your users can interact with your site and you can gather use-
     ful information and feedback. Discover how you can include media,
     both audio and video, in your Web site.                                       Intensive CSS Training
     Fee: $189                                                                     Do you want two intensive days of training? Join us for
     One-Day Class Meets 8:30am-4:00pm (6.5 hours)                                 Cascading Style Sheets week. Each one-day class costs $189.
     G2361 Fri., Sept. 2              West County             Barry
     G2429 Mon., Oct. 3               West County             Barry                Introduction to Cascading Style Sheets, Wed., Oct. 12
     G2548 Wed., Nov. 9               West County             Barry                Intermediate Applications of Cascading Style Sheets, Thurs., Oct. 13
     G2633 Fri., Dec. 9               West County             Barry

   September – December 2011              •     Computer Education & Training Center               •    (314) 984-9000         •    www.cetc.umsl.edu
                                                                                                 XML, JavaScript, AJAX & Silverlight 21


  XML                                                                       Advanced Applications of JavaScript




                                                                                                                                                    Web Design & Development
                                                                            (Prerequisite: Intermediate Applications of JavaScript or equivalent
  XML is the Web standard used to describe and transfer data,               experience.) Learn more about using loops, including the substring
  just as HTML is the standard to format and display data.                  method and the break and continue statements. Topics include using
                                                                            associative and multi-dimensional arrays, creating client-side cook-
  Introduction to XML                                                       ies to tailor pages for your user, and scheduling and timing events.
  (Prerequisite: Introduction to HTML or equivalent experience.) Learn      Additional topics include referencing a script as a URL in a LINK tag
  to create “well-formed” extensible Markup Language (XML) docu-            and creating image maps that execute JavaScript functions.
  ments that conform to the specific syntax rules of XML. Understand        Fee: $189
  both internal and external Document Type Definitions (DTD) in             One-Day Class Meets 8:30am-4:00pm (6.5 hours)
  order to create valid XML documents that correspond to their              G2316 Fri., Sept. 16                     West County        Abernathy
  DTDs. Learn to display the XML using CSS. This course introduces          G2607 Wed., Dec. 7                       West County        Abernathy
  the mechanics of writing XML documents and will not cover the
  extraction of the page contents by other programs.                        AJAX (Asynchronous JavaScript and XML)
  Fee: $189
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)                             AJAX (Asynchronous JavaScript and XML) is used in construct-
  G2553 Thurs., Nov. 3            West County             Otto              ing fast, interactive Web sites through the client-side power of
                                                                            JavaScript and the parsing ability of XML. AJAX is fast because it
  Intermediate Applications of XML                                          can transfer data to and from a server without the user refresh-
  (Prerequisite: Introduction to XML or equivalent experience.) Learn       ing a Web page. Visitors can request information from your
  to create an XML schema as recommended by the W3 organiza-                product database, for example, and that information can be
  tion as an alternative to the DTD (covered in the Introduction to         instantly loaded into a table on the Web page.
  XML course). Understand the creation of XML schemas as a means
  of validating XML documents. Learn how to define simple elements,         Introduction to AJAX
  complex elements, and attributes. Other topics include creating XML       (Prerequisites: Intermediate Applications of JavaScript and
  namespaces to resolve conflicts with similarly named elements from        Intermediate Applications of XML or equivalent experience.) AJAX
  two different schemas and using data types to define the specific         (Asynchronous JavaScript and XML) is ideal for creating high-perfor-
  content of attributes and elements. This course will not cover the        mance, extremely efficient, interactive Web sites, combining client-
  extraction of the XML data into other programs.                           side JavaScript with the power of XML. Web pages are much more
  Fee: $189                                                                 responsive, because not all data needs to be transferred between
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)                             the server and browser. In this class, learn how to use AJAX to cre-
  G2554 Wed., Nov. 9              West County               Otto            ate drop-down form menus that are automatically populated based
                                                                            on your users’ input. Learn the Document Object Model, XML
                                                                            Document Object Model, JavaScript Document Object Model, and
  JavaScript                                                                various AJAX frameworks. Other topics include customized searches
  JavaScript is a scripting language that you can use with your             and creating Web sites that dynamically update form information
  Web pages to add dynamic and interactive features. With                   without using a Submit button.
  JavaScript, you can run calculations, check forms for errors, cre-        Fee: $399
  ate special effects and animations, and secure your pages.                Two-Day Class Meets 8:30am-4:00pm (13 hours)
                                                                            G2470 Mon., Oct. 3 & Tues., Oct. 4 West County             Abernathy
  Introduction to JavaScript
  (Prerequisite: Intermediate Applications of HTML or equivalent            Microsoft Silverlight
  experience.) This course introduces the JavaScript object script-         Silverlight is Microsoft’s browser plugin for delivering media,
  ing language. Learn how to add special features to your Web pages,        animations, and rich Internet applications (RIAs) to the Web. It
  including alert boxes and user prompts. Discover how to incorporate       is similar to Adobe’s Flash plugin. With Silverlight, you can use
  calculations into your pages. Topics include understanding the basic      the .NET framework to work with 3D graphics, use effects such
  commands and structure of JavaScript and working with properties          as drop shadows and blurs, and add animation effects such as
  and methods. Additional topics include variables, operators, inputs,      bouncing and scaling.
  and conditionals.
  Fee: $189                                                                 Silverlight also lets you write applications using such built-in
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)                             controls as datagrids and calendars and work with forms by
  G2314 Wed., Sept. 14             West County              Abernathy       enhancing validation controls and user warnings.
  G2605 Mon., Dec. 5               West County              Abernathy
                                                                            Introduction to Silverlight
  Intermediate Applications of JavaScript                                   (Prerequisite: Introduction to Visual Basic .NET Programming or
  (Prerequisite: Introduction to JavaScript or equivalent experience). In   Introduction to Visual C# .NET Programming and a basic understand-
  this course, learn how to create forms with data validation and use       ing of Web application development using HTML. Some exposure to
  JavaScript to open and close different windows. Discover how to use       JavaScript would be helpful, but is not essential.) This course intro-
  built-in functions, assign functions to events like button clicks, and    duces the Silverlight plug-in and SDK. Learn how to implement inter-
  define your own Objects. Practice creating loops to manage repeated       active applications with Silverlight tools and Visual Studio. Understand
  tasks.                                                                    the Silverlight framework and architecture. Other topics include
  Fee: $189                                                                 Extensible Application Markup Language (XAML), which is also the
  One-Day Class Meets 8:30am-4:00pm (6.5 hours)                             foundation of Windows Presentation Framework (WPF); drawing
  G2315 Thurs., Sept. 15             West County               Abernathy    shapes; the integration of images, audio, and video into your applica-
  G2606 Tues., Dec. 6                West County               Abernathy    tions; and binding controls.
                                                                            Fee: $399
                                                                            Two-Day Class Meets 8:30am-4:00pm (13 hours)
                                                                            G2590 Thurs., Nov. 3 & Fri., Nov. 4 West County              Abernathy


September – December 2011           •     Computer Education & Training Center             •    (314) 984-9000        •    www.cetc.umsl.edu
22   ASP .NET, PHP & Facebook for Business


     ASP .NET                                                                   PHP
     ASP is Microsoft’s technology for database interactivity on the            PHP was designed for Web development, so it is especially suited
     Web. See p. 28-29 for courses in Visual C# and Visual Basic .NET.          for dynamic Web tasks such as handling forms and maintaining
                                                                                databases.
     Introduction to ASP .NET
     (Prerequisite: Introduction to Visual Basic .NET Programming or            Introduction to PHP
     Introduction to Visual C# .NET Programming or equivalent experi-           (Prerequisites: Introduction to Programming Concepts or experience
     ence.) Design dynamic Web pages using Visual Studio and the Visual         with a programming language and Advanced Applications of HTML
     Basic language. Start by creating a simple Web form, and then dif-         or equivalent experience. Experience with a server-side technology,
     ferentiate various types of server-side controls. You’ll learn to design   such as ASP or ColdFusion, is a plus.) PHP is an embedded script-
     pages that include server-side controls and to separate program            ing system that lets you create dynamic, data-driven Web sites. This
     code from HTML. Other topics include modifying compilation using           course teaches you the fundamentals of PHP so you can develop
     page directives, creating event procedures that process data sub-          your own simple PHP pages. Learn how to embed PHP code tags,
     mitted from HTML forms, preserving the state of a page, directing          create and run pages, display your output, and place HTML within the
     execution from one page to another, and validating submitted data          PHP code. You’ll also learn basic functions, such as date, time, number
     using form validator controls. The class uses VB .NET examples             format, round, floor, and rand. Other topics include creating variables
     throughout the course; however, students who are proficient in C#          and arrays, using control structures (conditionals, loops), reading and
     .NET will benefit from the class.                                          writing text files, and handling form controls. Find out what platforms
     Fee: $189                                                                  support PHP and which publication servers are required.
     One-Day Class Meets 8:30am-4:00pm (6.5 hours)                              Fee: $189
     G2487 Mon., Oct. 17               West County                Abernathy     One-Day Class Meets 8:30am-4:00pm (6.5 hours)
                                                                                G2332 Thurs., Sept. 22             West County               Abernathy
     Intermediate Applications of ASP .NET                                      G2613 Mon., Dec. 12                West County               Abernathy
     (Prerequisites: Introduction to ASP .NET and Introduction to SQL,
     or equivalent experience.) Learn to create ASP .NET applications           Intermediate Applications of PHP
     that access and update data from a data source. Use the data source        (Prerequisite: Introduction to PHP and Introduction to SQL or equiv-
     control to bind radio buttons, checkboxes, and other simple controls       alent experience.) The growing popularity of PHP rests partly on its
     to various data elements. You’ll also learn to display and edit data       support for a variety of database management systems, which lets you
     tables in a table of rows and columns using the GridView control.          create dynamic, data-driven Web sites with relative ease. This course
     Learn various techniques to filter data records according to user-         introduces the concepts and coding you need to know to begin main-
     specified criteria. Declare parameters to supply values to a data          taining data tables in databases. Learn how databases compare to text
     source control for updating the data source. The class uses VB .NET        files, the differences between server- and file-based databases, and
     examples throughout the course; however, students who are profi-           how to connect to databases, including connection methods, clos-
     cient in C# .NET will benefit from the class.                              ing connections, and error handling. You’ll also learn how to retrieve
     Fee: $189                                                                  your data through SQL SELECT, WHERE, and ORDER BY clauses, and
     One-Day Class Meets 8:30am-4:00pm (6.5 hours)                              how to insert and delete records in your data tables. Additional top-
     G2488 Tues., Oct. 18              West County               Abernathy      ics include using SQL UPDATE for updating records and maintaining
                                                                                state through hidden values and cookies.
     Advanced Applications of ASP .NET                                          Fee: $189
     (Prerequisite: Intermediate Applications of ASP .NET or equivalent         One-Day Class Meets 8:30am-4:00pm (6.5 hours)
     experience.) Learn to encapsulate visual and programmatic behavior         G2333 Fri., Sept. 23              West County              Abernathy
     in reusable ASP components. Discover how a user control differs            G2614 Mon., Dec. 19               West County              Abernathy
     from a custom control and how to create user controls with prop-
     erties and event handlers. Create various custom controls, including
     those that inherit from standard controls. Add your new custom
     controls to the toolbox for easy access alongside other standard
                                                                                Introduction to
     controls. Use the industry standard protocols (HTTP, SOAP, and
     XML) to develop and consume a Web service. You’ll also learn how
     to create a proxy class for use with a Web service consumer. The
     class uses VB .NET examples throughout the course; however, stu-
                                                                                Facebook for Business
     dents who are proficient in C# .NET will benefit from the class.
                                                                                Social media tools, such as Facebook, are an increasingly
     Fee: $189                                                                  powerful method to connect businesses with customers.
     One-Day Class Meets 8:30am-4:00pm (6.5 hours)                              Facebook can give your organization an edge in promoting
     G2489 Wed., Oct. 19              West County             Abernathy
                                                                                your products or services and enhancing customer feedback.
            For classes in Visual Basic .NET and                                (Prerequisite: Introduction to Windows or equivalent experience.)
                                                                                This introductory class shows users the basic steps for creating
            Visual C# .NET, see p. 28-29.                                       a new Facebook Page for an official organization. Topics include
                                                                                understanding Facebook terminology and the differences between
                                                                                personal profiles and official pages; creating a new Page; adding dif-
                                                                                ferent types of content to the Page; getting insights about the Page;
                                                                                and sending updates.
                                                                                Fee: $59
                                                                                Half Day Class Meets 9:00am 11:00am (2 hours)
                                                                                G2460 Mon., Oct. 24               West County               Delcamp
                                                                                G2550 Wed., Nov. 30               West County               Hudson

     September – December 2011             •    Computer Education & Training Center              •    (314) 984-9000        •    www.cetc.umsl.edu
                                                                                                             Dreamweaver & Fireworks 23


 Adobe Dreamweaver




                                                                                                                                                   Web Development/Design & Facebook for Business
                                                                             Did you know we offer a Chancellor’s
 Introduction to Web Page Design Using Dreamweaver                           Certificate in Web Scripting & Interactivity?
 (Prerequisite: Introduction to HTML or equivalent experience.)
 Learn to use Dreamweaver to create Web pages that incorporate               Engage your users with special interactive effects,
 text, images, background art, and tables. Topics covered in class
 include formatting text for size, color, and alignment; creating            such as animations, message boxes, and dropdown
 ordered and unordered lists; using tables; and linking pages together       menus. Produce forms that gather user input and
 with hyperlinks. Learn to place images on your pages. Create a
 Web site on a local disk, clean up the HTML code, and perform               create pages designed to fit the user’s needs.
 a final site check. Topics include viewing and editing HTML code,
 inserting and changing horizontal lines, and creating a library of fre-
                                                                             For more information, see the inside back cover
 quently used images and text. In addition, learn the fundamentals of        of this catalog or visit our Web site at
 Cascading Style Sheets (CSS) for text formatting and simple layouts.           http://www.cetc.umsl.edu/wsfacts.html
 Fee: $189
 One-Day Class Meets 8:30am-4:00pm (6.5 hours)
 G2383 Wed., Sept. 14               West County              Otto
 G2419 Mon., Oct. 17                West County              Haupt         Advanced Topics in Dreamweaver: Dynamic
 G2515 Tues., Nov. 15               West County              Otto          Database Connections
 Two-Evening Class Meets 6:30-9:30pm (6 hours)                             (Prerequisite: Intermediate Applications of Dreamweaver or equiva-
 T2201 Tues., Nov. 15 & 22 West County         Haupt                       lent experience.) Learn how to use Dreamweaver to display data-
                                                                           base information on your Web pages and let your users retrieve
                                                                           the specific information they need. Topics include connecting to a
 Intermediate Applications of Dreamweaver                                  database and filtering records using comparison operators, creating
 (Prerequisite: Introduction to Web Page Design Using Dreamweaver
                                                                           links with a URL parameter, and working with recordsets and SQL.
 or equivalent experience.) Add visual interest to your Web pages          Other topics include adding dynamic information to a Web page,
 using the interactive and design features of Dreamweaver. Use             displaying multiple records, navigating through records, viewing Live
 Cascading Style Sheets (CSS) and HTML styles to standardize for-          Data, and using the Binding panel. Learn how your users can add
 matting throughout your Web site and lay out pages using DIV tags.        records to the database through forms.
 Use the History palette to quickly repeat steps in your design pro-       Fee: $189
 cess. Learn to include rollovers to enhance your pages and to use         One-Day Class Meets 8:30am-4:00pm (6.5 hours)
 image maps to create splash screens. Create navigation bars from          G2510 Fri., Nov. 18               West County               Fry
 simple lists. Time will also be spent on inserting media, such as Flash
 and Fireworks files, into your Web pages.
 Fee: $189                                                                                                                Fireworks allows
 One-Day Class Meets 8:30am-4:00pm (6.5 hours)
 G2384 Thurs., Sept. 22             West County              Otto          Introduction to                                  you to create
 G2440 Mon., Oct. 24                West County              Haupt                                                           special Web
 G2516 Wed., Nov. 16                West County              Otto                                                            effects, such
 Two-Evening Class Meets 6:30-9:30pm (6 hours)
                                                                           Adobe Fireworks                                   as animated
 T2202 Tues., Nov. 29 & Dec. 6 West County     Haupt
                                                                                                                              rollovers,
                                                                           (Prerequisite: Introduction to Windows
 Advanced Applications of Dreamweaver                                      or equivalent experience.) Learn to use        navigation bars,
 (Prerequisite: Intermediate Applications of Dreamweaver or                Fireworks to create Web grapics that will        and pop-up
 equivalent experience.) Learn to use the advanced elements of
                                                                           enhance the visual design of your Web                menus.
 Dreamweaver to create dynamic Web pages. Insert events and
 actions using JavaScript and work with Dreamweaver’s site man-            pages. Use the drawing tools to create
 agement features. Add interactivity by linking scripts to behaviors.      and alter images and optimize them for
 Other topics include creating Spry validation fields for forms, Spry      quality and file size. Work with both bitmap and vector graphics.
 navigation features, and special Spry effects.                            Use the Layers panel to organize your artwork project and the
 Fee: $189                                                                 History panel to undo or repeat actions. Create animations and
 One-Day Class Meets 8:30am-4:00pm (6.5 hours)                             apply filters to your images. Discover how to create rollovers and
 G2385 Wed., Sept. 28              West County               Otto          apply masks. Additional topics include image maps, styles, text and
 G2517 Thurs., Nov. 17             West County               Otto          text effects, formats and settings for Web graphics, and the export
                                                                           process.
                                                                           Fee: $189
                                                                           One-Day Class Meets 8:30am-4:00pm (6.5 hours)
 Intensive Dreamweaver Training                                            G2369 Thurs., Sept. 8             West County              Koerper
 Are you coming from a distance? Do you want three intensive
 days of training? Join us for Dreamweaver week. Each one-day class
 costs $189.                                                                         See p. 4 for our class Special Topics in
      Introduction to Dreamweaver, Tues., Nov. 15                                    Photoshop: Web Graphics.
      Intermediate Applications of Dreamweaver, Wed., Nov. 16
      Advanced Applications of Dreamweaver, Thurs., Nov. 17




September – December 2011            •    Computer Education & Training Center             •    (314) 984-9000        •    www.cetc.umsl.edu
24 Flash, Flash ActionScript & Routers


    Adobe Flash                                                               Adobe Flash ActionScript
    Introduction to Flash                                                     Add interactivity and dynamic features to your Web pages
    (Prerequisite: Introduction to HTML or equivalent experience.)            using ActionScript, Flash’s scripting language. The ActionScript
    Learn to use Flash to design dynamic Web pages that combine seam-         editor is part of Flash.
    less animation and special effects. Build a Web movie by inserting lay-
                                                                              Introduction to Flash ActionScript
    ers, creating and importing artwork, then arranging all the elements
                                                                              (Prerequisite: Intermediate Applications of Flash or equivalent expe-
    on the Timeline. Animate shapes on stage using motion and shape
                                                                              rience.) Learn how to enhance your Web pages with interactivity
    tweening. Additional topics include managing the library elements,
                                                                              and special effects using ActionScript 3.0, Flash’s scripting language.
    using symbols, and optimizing text.                                       Although scripting concepts and terminology are discussed, the
    Fee: $189                                                                 emphasis is on editing and creating simple scripts for practical
    One-Day Class Meets 8:30am-4:00pm (6.5 hours)                             application. Use ActionScript to perform simple scripts includ-
    G2305 Wed., Oct. 5               West County               Otto           ing timeline navigation. Learn to work with MovieClip symbols
                                                                              by changing their properties and methods. Create an external
    Intermediate Applications of Flash                                        ActionScript file for use in multiple movies. Start to explore using
    (Prerequisite: Introduction to Flash or equivalent experience.) Learn
                                                                              some basic built-in components.
    to use Flash for more complex animations. Create frame-by-frame
                                                                              Fee: $189
    animations and then refine and edit the animation sequences. Learn
                                                                              One-Day Class Meets 8:30am-4:00pm (6.5 hours)
    to create, duplicate, and change the order of multiple scenes. Other
                                                                              G2444 Mon., Oct. 24               West County                 Otto
    topics include importing and editing bitmap graphics; onion-skinning;
    and importing, editing, and compressing sounds. Learn to create your      Intermediate Applications of Flash ActionScript
    own buttons for assigning actions. You will also learn how to create      (Prerequisite: Introduction to Flash ActionScript or equivalent
    and share common libraries.                                               experience.) Add excitement and interactivity to your Web pages
    Fee: $189                                                                 through special effects with ActionScript. Animate masks for dynam-
    One-Day Class Meets 8:30am-4:00pm (6.5 hours)                             ic effects and create drag-and-drop movie clips so users can move
    G2306 Thurs., Oct. 6              West County             Otto            objects around on the page. Other topics include adding sounds,
                                                                              creating external ActionScript files that can be reused in multiple
    Advanced Applications of Flash                                            movies, building preloaders, and using XML files in your code.
    (Prerequisite: Intermediate Applications of Flash or equivalent expe-
                                                                              Fee: $189
    rience.) This class takes you a step further in your Flash knowledge
                                                                              One-Day Class Meets 8:30am-4:00pm (6.5 hours)
    by showing you the range of effects possible in animation design.
                                                                              G2445 Tues., Oct. 25              West County              Otto
    Learn to create continuous scrolling graphics using groups and add
    special effects, such as blur to focus, laser and fading light, flares,
    and masking. Create the effect of film grain, including the scratches.
    Learn how you can sync an animation to a sound track.                            You may also be interested in our new class Digital
    Fee: $189
    One-Day Class Meets 8:30am-4:00pm (6.5 hours)                                    Publishing with InDesign. See p. 6 for details.
    G2307 Fri., Oct. 14                West County                 Otto




     Cisco Week (5-Day Class)
    Do you want practical routers training, condensed into one week of training? If so, enroll in our 5-day Cisco Week.
    This class covers material that will get you up and running with routers, and includes theoretical information as well
    as classroom exercises and hands-on practice.


    Fundamentals of Routers
    (Prerequisite: Intermediate TCP/IP and Introduction to Networks or equivalent experience.) Gain both practical hands-on experience and
    a thorough theoretical knowledge of internetworking. Learn to configure, design, and debug multiple network configurations using network
    bridges, switches, and routers. Participate in classroom exercises to reinforce core internetworking principles that are discussed in detail
    during the class. Learn the differences among bridges, switches, and routers, and when to use them effectively; configure networks with a
    combination of Ethernet and serial links; and use various routing protocols to achieve the best routing solution. Additional topics include
    configuring IP on different platforms, designing a subnetted network to maximize networks or nodes, managing a network using SNMP and
    other tools, and troubleshooting network design.
    Fee: $1295
    Five Day Class Meets 8:30am 4:00pm (32.5 hours)
    G2599 Mon., Nov. 7 through Fri., Nov. 11                West County              McClellan

    Note: Knowledge of TCP/IP along with an operating system is required to successfully complete the series of classes in routers.
    Please make sure that you take the necessary prerequisite courses.

    September – December 2011              •    Computer Education & Training Center            •    (314) 984-9000        •     www.cetc.umsl.edu
                                                                           Networks, Wireleses, Computer Support & TCP/IP 25


 NETWORKING FUNDAMENTALS                                                 TCP/IP




                                                                                                                                                    Flash, Networks, Wireless & Routers
 Introduction to Networks                                                Introduction to TCP/IP
 (Prerequisite: Introduction to Windows or equivalent experience. It     (Prerequisite: Managing a Network Using Windows Server or
 is also recommended that you have some experience with one or           Introduction to UNIX or equivalent experience.) This course intro-
 more software applications before taking this course.) This course      duces TCP/IP and its related utilities. Learn how to use the telnet
 is an introduction to setting up a network of personal comput-          program and its service options to provide a virtual terminal capabil-
 ers. Learn the terminology, how to plan a network installation,         ity. Understand the FTP utility and its related user commands for file
 and what a network can and cannot do. Topics include network            manipulation. Topics include the structure of TCP/IP-based networks,
 planning decisions, such as choosing the appropriate network;           how to correctly choose IP addresses, various methods for using
 determining the necessary performance level; and considering the        logical names for network devices, a brief introduction to routing,
 differences among operating systems, types of network interface         and a brief introduction to DNS. Additional topics include using TCP/
 cards, and cabling required. Additional topics include installation     IP utilities, such as rlogin, rcp, ping, traceroute, netstat, and nslookup.
 and setup features, such as network topologies, protocols, basic        Fee: $239
 system commands, and how to efficiently run software applications       One-Day Class Meets 8:30am-4:00pm (6.5 hours)
 on a network.                                                           G2308 Thurs., Sept. 1                 West County                McClellan
 Fee: $239                                                               G2512 Mon., Nov. 14                   West County                McClellan
 One-Day Class Meets 8:30am-4:00pm (6.5 hours)
 G2208 Fri., Aug. 26              West County                McClellan   Intermediate TCP/IP
 G2500 Thurs., Nov. 3             West County                McClellan   (Prerequisite: Introduction to TCP/IP or equivalent experience.) This
                                                                         course focuses on the installation and setup of TCP/IP networks.
 Wireless Networking                                                     Understand how to configure a TCP/IP network. Learn how to use
                                                                         the various TCP/IP administrative tools such as ARP, ipconfig, and
                                                                         netstat. Review IP addressing, IP address classifications, the structure
 Introduction to Wireless Communications                                 of frames, and how to set up IP addresses. Topics include 4-layer
 (Prerequisite: Introduction to Networks or equivalent experience.)      and 7-layer models and hexadecimal conversions for IP addressing.
 If you’re ready to install a wireless network and want to know          Additional discussions include IP versions 4 and 6, DNS, ARP, and
 more about the equipment and configuration, this hands-on course        subnetting best-design practices.
 is the introduction you need to this technology. Discover the           Fee: $239
 advantages and disadvantages of wireless networks and which tech-       One-Day Class Meets 8:30am-4:00pm (6.5 hours)
 nology and equipment are best for you. Practice setting up your         G2309 Wed., Sept. 7               West County                McClellan
 own wireless networks by configuring wireless network adapters          G2513 Mon., Nov. 21               West County                McClellan
 and access points. Learn how to find wireless hot spots, determine
 communications distance, and share printers and hard drives on a        Advanced TCP/IP
 Windows XP computer.                                                    (Prerequisite: Intermediate TCP/IP or equivalent experience.) This
 Fee: $249                                                               class covers the structure of TCP/IP packets and the installation
 One-Day Class Meets 8:30am-4:00pm (6.5 hours)                           of advanced protocols. Understand the structure of the Internet
 G2322 Thurs., Sept. 22             West County            McClellan     Protocol (IP), the Internet Control Message Protocol (ICMP), and
                                                                         the Transmission Control Protocol (TCP). Break down IP and TCP
 Intermediate Wireless Communications: Security                          packets to understand their layouts. Explore mapping types, dissect
 (Prerequisites: Introduction to Wireless Communications and             ARP packets, and learn how ARP requests are handled. Additional
 Introduction to Security or equivalent experience.) Is your wireless    topics include Ethernet frames, the Simple Mail Transfer Protocol
 network secure? This hands-on course will teach you how to pro-         (SMTP), the configuration of sendmail, the Domain Name Service
 tect your communications and data through proper configuration          (DNS), and basic firewall setup.
 of devices, added security measures, and special network design.        Fee: $239
 Learn the limits of your wireless technology and the risks of public    One-Day Class Meets 8:30am-4:00pm (6.5 hours)
 Internet hot spots. Find out how to configure your wireless router      G2310 Wed., Sept. 14             West County              McClellan
 with security in mind, set up a firewall to prevent access from the     G2514 Thurs., Dec. 1             West County              McClellan
 Internet, and use a wireless sniffer to learn about wireless net-
 works in your area. Learn how to add password protection, disable       Computer Support and A+ Certification
 the SSID broadcast, set up MAC address filters, and enable encryp-      If you’re a Help Desk professional or involved in IT support, this
 tion using WEP and WPA. Additional topics include securing your         course covers the hardware installation, network troubleshooting,
 Windows XP computer for wireless network access.                        and other support skills you need to be effective. This course is
 Fee: $249                                                               also a starting point for A+ certification.
 One-Day Class Meets 8:30am-4:00pm (6.5 hours)
 G2323 Fri., Sept. 23              West County               McClellan   Introduction to Computer Support
                                                                         (Prerequisites: Introduction to Networks and Introduction to TCP/IP
 See p. 26 for additional security courses.                              or equivalent experience.) Are you interested in entering the technol-
                                                                         ogy field? Are you responsible for system upgrades but you’re not a
                                                                         technology expert? Do you want to pursue vendor certification? If
    Want to see a course outline?                                        so, this class is a great starting place to learn the basics of computer
                                                                         support. This class will introduce you to the fundamentals of LAN and
    Check the course schedule on our Web site                            WAN networks, including hardware components, through practical,
                                                                         hands-on examples. You’ll learn to troubleshoot simple networks, iden-
    at www.cetc.umsl.edu and click the Course                            tify and install hardware, and configure and upgrade software.
                                                                         Fee: $269
    Outline link next to the class description.                          One-Day Class Meets 8:30am-4:00pm (6.5 hours)
                                                                         G2319 Fri., Sept. 2                West County        McClellan
                                                                         G2578 Fri., Nov. 18                West County        McClellan

September – December 2011           •    Computer Education & Training Center            •    (314) 984-9000         •     www.cetc.umsl.edu
26 Security & IT Professional Development


   SECURITY
   Introduction to Security                                                     Intermediate Security: Live System Analysis
   (Prerequisite: Introduction to Networks or equivalent experience.)           (Prerequisite: Introduction to Security or equivalent experience.
   This class will provide you with an overview of basic and advanced           It is also recommended that you have some experience with
   computer and network security policies. Learn about the types                networking.) Learn how to track activity on a computer or a net-
   of attacks used by potential intruders. Gain an understanding of             work. Trace computer use by analyzing logs, Registry keys, cached
   what a firewall is and exactly what protection can be achieved               settings, and data. Discover where the system stores information
   by adding one to your network. Learn how to use an Intrusion                 about autorun software, “Most Recently Used” lists, wireless
   Detection System to determine who, what, when, and where an                  access history, and previous network connections. Learn where
   attack came from. Discuss why anonymity may be one of the best               data is kept on USB-device access history, previously typed URLs,
   forms of security. Learn how to make computers on your network               recently accessed systems, and network-resource access logs.
   appear anonymously to computers outside your network by using                Recover files and e-mails that have been “permanently” removed
   Network Address Translation in combination with a Proxy Server.              from the system. Learn where and how networks store informa-
   Learn what steps to take if your computer or system has been                 tion about computer configurations and communications. Become
   attacked.                                                                    more effective at incident response, or apply the same principles
   Fee: $239                                                                    toward protecting privacy.
   One-Day Class Meets 8:30am-4:00pm (6.5 hours)                                Fee: $399
   G2317 Fri., Sept. 9                      West County McClellan               Two-Day Class Meets 8:30am-4:00pm (13 hours)
   G2651 Wed., Dec. 14                      West County McClellan               G2318 Thurs., Sept. 15 & Fri., Sept. 16 West County McClellan
                                                                                G2652 Thurs., Dec. 15 & Fri., Dec. 16 West County McClellan




     courses for
     IT Professional Development
     As an IT professional, your job has become more complex, with employers and customers expecting a blend of technical skills
     and talent in communication, management, and leadership skills.
     Our IT Professional Development courses help you succeed in your career by strengthening those skills that are
     essential in today’s IT environment and creating value for you and your company.

     The Successful IT Team                                                       IT Business Communications
     An essential key to a productive team is understanding its strengths         Effective communication can seem simple, but it requires active lis-
     and weaknesses. Learn to mold your group into a successful project           tening, the ability to ask pertinent questions, and the skill to engage
     team through a deeper understanding of typical personality types and         in constructive conversations. Learn how to lead more effective
     how you can best relate to them. Identify how each type communi-             meetings, speak more clearly, and communicate without ambiguity.
     cates and responds to motivation. Become skilled at understanding            Understand how attitude and barriers impact communications, and
     your personal style and those of your team members and capitalize            how you can manage expectations.
     on your combined strengths.                                                  Fee: $99
     Fee: $99                                                                     Half Day Class Meets 8:30am 11:30am (3 hours)
     Half Day Class Meets 8:30am 11:30am (3 hours)                                G2570 Mon., Nov. 14               West County                 Abernathy
     G2468 Mon., Oct. 24             West County              Abernathy
                                                                                  IT Communications: Public Speaking
     IT Leadership Skills: The Art of Influence                                   Most people fear public speaking, but with a proper understand-
     Today’s IT leaders work in an evolving environment that requires the         ing of time-proven principles, this fear can be overcome. Enhance
     ability to influence customers, clients, and team members. You must          your speaking skills through a comprehensive approach that includes
     traverse the levels of influence and determine a strategy based on the       instruction on how to capture an audience, how to build upon your
     situation and people involved. Learn to identify your own resources          main points, and how to properly conclude a presentation. Through
     and the specific techniques for becoming an influential leader. Tap into     hands-on practice, learn to share ideas, communicate difficult topics
     the motivation factors that impact performance and commitment.               concisely, and engage an audience with enthusiasm.
     See how your vision and work ethic can impact results and create             Fee: $189
     shared success.                                                              One Day Class Meets 8:30am 4:00pm (6.5 hours)
     Fee: $99                                                                     G2571 Thurs., Dec. 8              West County             Abernathy
     Half Day Class Meets 8:30am 11:30am (3 hours)
     G2569 Mon., Nov. 7                West County              Abernathy




   September – December 2011             •     Computer Education & Training Center               •    (314) 984-9000         •    www.cetc.umsl.edu
                                                                                                                                  UNIX & Linux 27

 UNIX/LINUX




                                                                                                                                                         Security, IT Professional Development & UNIX/Linux
 Linux was developed as a version of UNIX, for use on personal computers. Its syntax, kernal compilation, and environment are
 very similar to other versions of UNIX. Students interested in Linux can take the UNIX series of classes to learn the basics of the
 operating system.

 Introduction to UNIX/Linux                                                  Advanced UNIX/Linux Scripting: SED and AWK
 (Prerequisite: Intermediate Applications of Windows or equiva-              (Prerequisites: Advanced UNIX/Linux: Scripting or programming
 lent experience. Students should be familiar with the concept of            experience using Bourne, C shell, or Korn shell.) This course is
 a tree-structured directory before taking this class.) This course          designed for anyone managing such services as Apache Web, DNS,
 introduces the UNIX operating system, focusing on the essential             print, mail, or database. If you are concerned with system-wide, net-
 components of UNIX in the context of the overall operating sys-             work, or firewall performance, or need to learn more about log file
 tem structure. Explore the UNIX file system and learn techniques            evaluations, this course will guide you through the programming you
 and commands for managing files, including copying, renaming, and           need. Learn to create complex programs for automating functions
 deleting files. Learn how to create and edit files using the vi editor.     used in managing a UNIX system. You will have hands-on experience
 Understand the concept of a shell, along with specific aspects of           with the AWK programming language in gathering system statis-
 the Bourne shell and K shell. Additional topics include working with        tics and generating reports; the Stream editor (SED) for multiple
 foreground and background processes, using pipes and wildcards,             editing changes on a variety of files, including colon-delimited and
 interpreting file access permissions, and linking files.                    Web-based; and the advanced features of Korn and C shells for
 Fee: $399                                                                   using functions. You will generate programs to control, monitor, and
 Two-Day Class Meets 8:30am-4:00pm (13 hours)                                report on multiple-system services and applications.
 G2454 Mon., Oct. 17 & Tues., Oct. 18 West County McClellan                  Fee: $399
                                                                             Two-Day Class Meets 8:30am-4:00pm (13 hours)
 Intermediate Commands of UNIX/Linux                                         G2339 Mon., Sept. 26 & Tues., Sept. 27 West County McClellan
 (Prerequisite: Introduction to UNIX/Linux or equivalent experience.
 Students should already have experience with basic UNIX file com-           Linux
 mands, such as ls, pwd, cd, rm, cp, mv, grep, and sort.) Learn about
 file security, shell commands, and file manipulation utilities. Compare     Introduction to Linux Administration
 several popular shells (Bourne shell, Korn shell, C shell, and Bourne       (Prerequisite: Intermediate Commands of UNIX/Linux and
 Again shell) and learn about specific capabilities of each shell, includ-   Introduction to TCP/IP or equivalent experience. Students will use
 ing creating regular and environment variables, setting up aliases,         the following UNIX commands: ls, cat, cd, pico, cp, rm, mv, pwd, tel-
 and rerunning commands in your history. Practice setting default file       net, login, touch, more, mkdir, rmdir, and ping.) Practice installing the
 and directory permissions and changing file ownership. Learn to use         Linux operating system. Understand the steps necessary to plan for
 a variety of tools to manipulate and filter files, including head, tail,    a successful installation, learn techniques for troubleshooting instal-
 grep, sed, and awk. Additional topics include scheduling processes,         lations, and create file systems for the Linux platform. Additional
 archiving and compressing files, and using the find command to              topics include understanding the background of Linux, its potential,
 locate files that meet specific criteria.                                   and its various distributions; mounting file systems; and creating
 Fee: $399                                                                   users and passwords.
 Two-Day Class Meets 8:30am-4:00pm (13 hours)                                Fee: $249
 G2237 Mon., Aug. 29 & Tues., Aug. 30 West County McClellan                  One-Day Class Meets 8:30am-4:00pm (6.5 hours)
 G2555 Tues., Nov. 1 & Wed., Nov. 2 West County McClellan                    G2398 Wed., Sept. 28                        West County McClellan
                                                                             G2608 Thurs., Dec. 8                        West County McClellan
 Advanced UNIX/Linux: Scripting
 (Prerequisite: Intermediate Commands of UNIX/Linux or equivalent            Intermediate Linux Administration
 experience.) This course covers the design and use of UNIX script           (Prerequisite: Introduction to Linux Administration or equivalent
 files for custom applications. Topics include the consideration of the      experience.) This hands-on course teaches you how to configure
 Bourne shell and C shell as programming languages, user-defined             the Linux operating system. Learn how to do a basic configuration
 variables (including arrays), numeric variables, operators, assign-         of the Apache Web Server. Understand how to install SAMBA and
 ment statements, and input/output operations. Learn the standard            do Linux-to-Windows communication. Additional topics include sys-
 programming concepts, such as conditional statements, loop state-           tem maintenance, setting up user accounts and groups, configuring
 ments, and recursion, in the context of shell programming. Sample           firewalls, and understanding runlevels.
 programs will be discussed to demonstrate techniques of using               Fee: $249
 UNIX commands.                                                              One-Day Class Meets 8:30am-4:00pm (6.5 hours)
 Fee: $399                                                                   G2399 Thurs., Sept. 29                   West County McClellan
 Two-Day Class Meets 8:30am-4:00pm (13 hours)                                G2609 Fri., Dec. 9                       West County McClellan
 G2338 Mon., Sept. 12 & Tues., Sept. 13 West County McClellan
 G2556 Tues., Nov. 15 & Wed., Nov. 16 West County McClellan
                                                                                        See p. 30 for classes in Perl scripting for
                                                                                        UNIX/Linux administration.
  Linux Course Sequence
  If you have little or no experience with Linux or                                   Intermediate             Introduction            Intermediate
  UNIX and are interested in learning Linux admin-            Introduction to
                                                                                      Commands of                to Linux                  Linux
  istration, the following is the sequence of courses           UNIX/Linux
                                                                                       UNIX/Linux             Administration          Administration
  you should take.



September – December 2011             •     Computer Education & Training Center               •    (314) 984-9000         •    www.cetc.umsl.edu
28 Server, Active Directory, Programming & Visual Basic


    Windows Server                                                         PROGRAMMING
    Managing a Network Using Windows Server 2008                           Programming Concepts
    (Prerequisite: Previous experience with Windows required. The
    Introduction to Networks class is also recommended as a prereq-        Introduction to Programming Concepts
    uisite to this course.) Develop the skills needed to manage a net-     (Prerequisite: Introduction to Computers or equivalent experience.)
    work using Windows Server. Learn to use the appropriate com-           This course covers the fundamentals of computer programming.
    mands and utilities to manage Windows Server, set up group and         Develop a better understanding of how computer applications work
    user accounts, and manage file systems and resources. Additional       by learning to write your own simple programs in the VBScript
    topics include basic operating system commands, user accounts          scripting language. Learn the basic programming structures that
    and rights, security and permissions, local and global groups, group   are common to many programming languages, including input and
    management, and profiles. This course also provides an introduc-       output statements, constants, assignment statements, string and
    tion to the Active Directory and its components.                       numeric variables, conditionals, and branching and looping control
    Fee: $399                                                              structures. Programming techniques covered include counting, aver-
    Two-Day Class Meets 8:30am-4:00pm (13 hours)                           aging, rounding, the use of random numbers, and numerous tips on
    G2354 Tues., Sept. 20 & Wed., Sept. 21 West County McClellan           developing a good programming style.
    G2655 Mon., Nov. 28 & Tues., Nov. 29 West County McClellan             Fee: $399
                                                                           Two-Day Class Meets 8:30am-4:00pm (13 hours)
    Windows Active Directory                                               G2405 Wed., Oct. 5 & Thurs., Oct. 6 West County Abernathy
    The Introduction to Windows Active Directory course includes
    information on planning, designing, and implementing Active            Object-Oriented Programming Concepts
    Directory Services. Intermediate Windows Active Directory
    will help you with security, troubleshooting, and disaster             Introduction to Object-Oriented Programming
    recovery.
                                                                           Concepts
                                                                           (Prerequisites: Experience with or understanding of any proce-
    Introduction to Windows Active Directory                               dural programming language, such as C or COBOL.) This course
    (Prerequisite: Managing a Network Using Windows Server or
                                                                           is intended for procedural programmers who want to move into
    equivalent experience.) Explore the basics of planning, design-
                                                                           object-oriented (OO) programming or managers who want to
    ing, configuring, and administering Active Directory Services on a
                                                                           become more familiar with OO concepts. Understand the termi-
    Windows server. Topics include designing the site topology, Active
    Directory forest domain structure, planning for Active Directory       nology, notation, and development skills you need to make a suc-
    deployment, migrating from previous server environments,               cessful transition to OO programming and development. Learn the
    Operation Master servers, and the placement of various types of        advantages of OO, as well as the concepts of encapsulation, inheri-
    servers. Additional topics include domain and organizational unit      tance, class, object, and relation. Learn about special classes, such as
    planning, DNS services, and DHCP infrastructure.                       Interface, and techniques, such as callbacks, as well as about archi-
    Fee: $399                                                              tectural elements, such as layers, patterns, and packages. This course
    Two-Day Class Meets 8:30am-4:00pm (13 hours)                           also introduces development as a process, along with basic system
    G2455 Tues., Oct. 11 & Wed., Oct. 12 West County McClellan             views and models, such as the Use Case, Class, and Object models,
                                                                           all presented in the Unified Modeling Language (UML). Examples
    Intermediate Windows Active Directory                                  illustrating and contrasting OO syntax and memory models, drawn
    (Prerequisite: Introduction to Windows Active Directory or             from C++ and Java, are also included. (Note: Because this course
    equivalent experience.) Explore the basics of maintaining a secure     presents programming and development concepts, the amount of
    Active Directory infrastructure. Learn about DNS and DHCP              hands-on experience is limited.)
    security and server security. Learn how to troubleshoot and            Fee: $239
    diagnose such components as Active Directory, DNS, DHCP, File          One-Day Class Meets 8:30am-4:00pm (6.5 hours)
    Replication Services, Active Directory replication, and Windows        G2530 Wed., Nov. 9                          West County Janikow
    Time Service. Discover how to recover from a disaster through
    the backup and restoration of Active Directory.                        Microsoft Visual Basic .NET
    Fee: $399
    Two-Day Class Meets 8:30am-4:00pm (13 hours)                           Introduction to Visual Basic .NET Programming
    G2287 Mon., Aug. 22 & Tues., Aug. 23 West County McClellan             (Prerequisite: Introduction to Programming Concepts or equiva-
    G2456 Wed., Oct. 26 & Thurs., Oct. 27West County McClellan             lent experience with another programming language.) This course,
                                                                           intended for students with no previous Visual Basic experience,
    Exchange Server                                                        introduces the Visual Studio development environment and funda-
                                                                           mental Visual Basic programming statements. Learn to design pro-
    Introduction to Exchange Server                                        fessional user interfaces that feature a variety of Windows controls,
    (Prerequisites: Introduction to TCP/IP and Managing a Network          including buttons, text boxes, combo boxes, and radio buttons. Add
    Using Windows Server or equivalent experience.) Explore                Visual Basic procedures to your Windows forms to interact with
    the basics of installing and administering a Microsoft Exchange        users and add functionality to your applications. Review essential
    Server. Learn how to plan for installation and install the software.   programming concepts, including variable declarations, conditional
    Configure users and mail protocols and integrate Exchange with         statements, loops, and arrays, using the Visual Basic syntax. Other
    the Windows Active Directory. Additional topics include securing       topics include an introduction to classes and methods using funda-
    the server from anonymous relay, maintaining a reliable server, and    mental classes in the .NET Framework.
    troubleshooting.                                                       Fee: $399
    Fee: $399                                                              Two-Day Class Meets 8:30am-4:00pm (13 hours)
    Exchange 2007                                                          G2270 Mon., Aug. 29 & Tues., Aug. 30 West County Abernathy
    Two-Day Class Meets 8:30am-4:00pm (13 hours)                           G2584 Tues., Nov. 15 & Wed., Nov. 16 West County Abernathy
    G2467 Mon., Oct. 17 & Tues., Oct. 18 West County Richey

    September – December 2011            •     Computer Education & Training Center          •     (314) 984-9000         •    www.cetc.umsl.edu
                                                                                                                       Visual Basic & Visual C#              29

 Intermediate Visual Basic .NET Programming                                      Microsoft Visual C# .NET




                                                                                                                                                            Windows, Server & Programming
 (Prerequisite: Introduction to Visual Basic .NET Programming or
 equivalent experience.) Streamline your Visual Basic projects by                Introduction to Visual C# .NET Programming
 creating your own user-defined classes. This course will review                 (Prerequisite: Introduction to Programming Concepts or equiva-
 and expand on the object-oriented programming concepts pre-                     lent experience with another programming language.) This course,
 sented in the introductory Visual Basic course and guide you                    intended for students with no previous C# experience, introduces
 through creating and instantiating user-defined classes with user-              the Visual Studio development environment and fundamental C# pro-
 defined properties, methods, and constructors. Discover tips on                 gramming statements. Learn to use Visual Studio to design profession-
 searching Visual Studio documentation to locate and use classes                 al user interfaces that feature a variety of Windows controls, including
 and methods provided by the .NET Framework to perform nec-                      buttons, text boxes, combo boxes, and radio buttons. Add C# code
 essary tasks. Learn to declare and use overloaded methods and                   behind your Windows forms to interact with users and add logic to
 static members. Use collections to work with groups of objects.                 your applications. Review essential programming concepts, including
 Consider the principles of good object-oriented design in your                  variable declarations, conditional statements, loops, and arrays, using
 Visual Basic programs. Practice inheritance to extend the func-                 the C# syntax. Other topics include an introduction to classes and
 tionality of existing classes, and then take advantage of inheritance           methods using fundamental classes in the .NET Framework.
 using polymorphic variables and methods.                                        Fee: $399
 Fee: $399                                                                       Two-Day Class Meets 8:30am-4:00pm (13 hours)
 Two-Day Class Meets 8:30am-4:00pm (13 hours)                                    G2433 Thurs., Oct. 13 & Fri., Oct. 14 West County Abernathy
 G2271 Mon., Sept. 12 & Tues., Sept. 13 West County Abernathy
 G2585 Tues., Nov. 29 & Wed., Nov. 30 West County Abernathy                      Intermediate Visual C# .NET Programming
                                                                                 (Prerequisite: Introduction to Visual C# .NET Programming or
 Advanced Visual Basic .NET Programming                                          equivalent experience.) Streamline your C# projects by creating your
 (Prerequisite: Intermediate Visual Basic .NET Programming or                    own user-defined classes. This course will review and expand on the
 equivalent experience.) Explore the more advanced user controls                 object-oriented programming concepts presented in the introduc-
 provided by Visual Studio and add your own controls. Learn to                   tory C# course, and guide you through creating and instantiating
 use the “My” objects, which provide access to commonly used                     user-defined classes with user-defined properties, methods, and con-
 functions in the .NET Framework. Create class diagrams that                     structors. Discover tips on searching Visual Studio documentation to
 represent the structure of your projects, survey the key classes                locate and use classes and methods provided by the .NET Framework
 for creating and manipulating XML documents, and learn to parse                 to perform necessary tasks. Learn to declare and use overloaded
 XML documents using XMLDocument and XMLTextReader.                              methods and static members. Use collections to work with groups
 Additional topics include writing multi-threaded applications that              of objects. Consider the principles of good object-oriented design in
 perform several tasks simultaneously, creating multiple document                your C# programs. Practice inheritance to extend the functionality
 interface (MDI) applications consisting of child forms within par-              of existing classes, and then take advantage of inheritance using poly-
 ent forms, and designing forms that contain toolbars and menus.                 morphic variables and methods.
 Fee: $399                                                                       Fee: $399
 Two-Day Class Meets 8:30am-4:00pm (13 hours)                                    Two-Day Class Meets 8:30am-4:00pm (13 hours)
 G2272 Mon., Sept. 26 & Tues., Sept. 27 West County Abernathy                    G2434 Thurs., Oct. 27 & Fri., Oct. 28 West County Abernathy
 G2586 Tues., Dec. 13 & Wed., Dec. 14 West County Abernathy
                                                                                 Advanced Topics in Visual C# .NET: Data Access
 Advanced Topics in Visual Basic .NET: Data Access                               (Prerequisite: Intermediate Visual C# .NET Programming or equiva-
 (Prerequisite: Intermediate Visual Basic .NET Programming or                    lent experience. Experience with a database is also recommended.)
 equivalent experience. Experience with a database is also rec-                  Learn to create Windows forms that access data using the Visual C#
 ommended.) Learn to create Windows forms that access data                       programming language and the Visual Studio development environ-
 using the Visual Basic programming language and the Visual Studio               ment. Configure data sources and data-related components using a
 development environment. Configure data sources and data-relat-                 variety of tools, including the Data Source Configuration Wizard, the
 ed components using a variety of tools, including the Data Source               Dataset Designer, and the TableAdapter Configuration Wizard. Take
 Configuration Wizard, the Dataset Designer, and the TableAdapter                advantage of the Data Sources window and Visual Studio’s drag-and-
 Configuration Wizard. Take advantage of the Data Sources win-                   drop data-binding capabilities to build data-centric forms. Set up data-
 dow and Visual Studio’s drag-and-drop data-binding capabilities to              sets that include data from related tables by creating relationships and
 build data-centric forms. Set up datasets that include data from                establishing foreign keys. Learn techniques to validate data and make
 related tables by creating relationships and establishing foreign               updates to the underlying database. Other topics include creating
 keys. Learn techniques to validate data and make updates to the                 reports and using the BindingSource component to navigate through,
 underlying database. Other topics include creating reports and                  sort, and filter data.
 using the BindingSource component to navigate through, sort, and                Fee: $399
 filter data.                                                                    Two-Day Class Meets 8:30am-4:00pm (13 hours)
 Fee: $399                                                                       G2535 Thurs., Nov. 10 & Fri., Nov. 11 West County Abernathy
 Two-Day Class Meets 8:30am-4:00pm (13 hours)
 G3373 Tues., Oct. 11 & Wed., Oct. 12 West County Abernathy
 G2687 Thurs., Jan. 5 & Fri., Jan. 6        West County Abernathy
                                                                                      IT Professional Development
  Cisco Routers                                                                       Our IT Professional Development courses help you to
   Do you want practical routers training, condensed into one week of                 be a success at your job, to strengthen those skills that
   training? If so, enroll in our 5-day Cisco Week. This class covers material        are essential in today’s IT environment, and to create
   that will get you up and running with routers, and includes theoretical
                                                                                      value for you and your company.
   information as well as classroom exercises and hands-on practice.
                                                                                                See p. 26 for more information.
   See p. 24 for more information.


September – December 2011                •     Computer Education & Training Center                 •    (314) 984-9000        •    www.cetc.umsl.edu
30 JavaServer Pages (JSP), Perl & Java Programming


   Perl Programming                                                           Intermediate Java Programming
   Perl is a cross-platform programming language that can work                (Prerequisite: Introduction to Java Programming or equivalent
   with HTML, XML, and CGI in developing Web scripts and                      experience with Java, C, or C++.) Explore Java’s object-oriented
   interactive Web pages. It is also frequently used for UNIX                 features, with the goal of making your programs more reliable,
   administration.                                                            efficient, and reusable. Write classes that include variables, con-
                                                                              structors, and methods, and learn to create objects based on your
   Introduction to Perl Programming                                           own classes and classes included in Java’s class libraries. Examine
   (Prerequisite: Introduction to Programming Concepts or equiva-             the concepts of inheritance and class hierarchy, and learn to design
   lent experience.) Perl is a flexible programming language used by          classes that inherit and extend existing functionality. Practice apply-
   system and network administrators, Web developers, and database            ing effective object-oriented design strategies and writing useful
   administrators. In this course, you will explore the basics of Perl        class documentation. Additional topics include formatting numeric
   and learn the language structure. Practice creating loops, work-           and date data, overloading methods and constructors, managing
   ing with conditionals, and using variables. Discover how to create         flexible-size collections, working with polymorphic variables, and
   arrays and hashes, format reports, and match patterns.                     organizing your classes into packages.
   Fee: $399                                                                  Fee: $399
   Two-Day Class Meets 8:30am-4:00pm (13 hours)                               Two-Day Class Meets 8:30am-4:00pm (13 hours)
   G2521 Tues., Nov. 1 & Wed., Nov. 2 West County Abernathy                   G2349 Tues., Sept. 6 & Wed., Sept. 7 West County Abernathy
                                                                              G2642 Thurs., Dec. 1 & Fri., Dec. 2 West County Abernathy
   Intermediate Perl Programming
   (Prerequisite: Introduction to Perl Programming or equivalent              Advanced Java Programming
   experience. Some familiarity with SQL is also helpful.) Create             (Prerequisite: Intermediate Java Programming or equivalent experi-
   subroutines and work with modules. Discover how to access and              ence.) Create graphical user interfaces that incorporate compo-
   manipulate files and how to use Perl to access remote databases.           nents of Swing and the Abstract Windowing Toolkit. Learn to apply
   Learn about Web interfaces and Perl’s built-in CGI (Common                 practical exception-handling techniques to deal with errors gen-
   Gateway Interface) Module.                                                 erated when you run your programs. Other topics include using
   Fee: $399                                                                  input and output streams to interact with external data and laying
   Two-Day Class Meets 8:30am-4:00pm (13 hours)                               out your GUI applications effectively.
   G2522 Mon., Nov. 21 & Tues., Nov. 22 West County Abernathy                 Fee: $399
                                                                              Two-Day Class Meets 8:30am-4:00pm (13 hours)
                                                                              G2350 Mon., Sept. 19 & Tues., Sept. 20 West County Abernathy
   Java                                                                       G2643 Thurs., Dec. 15 & Fri., Dec. 16 West County Abernathy
   Introduction to Java Programming
   (This course is intended for students with very little program-            JSP: Web Application Development
   ming experience. Introduction to Programming Concepts is rec-              Learn to create JavaServer Pages (JSP) that generate dynamic
   ommended as a prerequisite for students with no exposure to                Web pages.
   programming concepts. Students who have practical experience
   using a C-style programming language and an understanding of               Introduction to JavaServer Pages (JSP)
   object-oriented programming concepts are encouraged to enroll in           (Prerequisites: Introduction to HTML and Introduction to Java
   Intermediate Java Programming.) This course introduces Java, one           Programming or equivalent experience.) With JavaServer Pages
   of today’s most popular programming languages. Learn to design,            (JSP), you can develop platform-independent Web-based applica-
   write, compile, and run basic Java applications that incorporate           tions and dynamic Web pages. This class will guide you through JSP
   fundamental programming concepts and accepted programming                  and how Java is used in JSP, including JSP-specific built-in objects,
   techniques. Learn to declare and use variables of different data           methods, and interfaces. Learn how to use HTML forms and con-
   types to store information in your programs. Practice using con-           trols such as buttons, images, text, and drop-boxes to get data
   trol structures, such as if statements, switch statements, and loops,      from Web pages. You’ll learn how to create reusable components
   to control the flow of your applications. Learn to interpret Java’s        known as JavaBeans, how to use basic JSP actions and directives, as
   online documentation to make use of the features included in Java’s        well as how to track users with sessions and cookies.
   class libraries. Additional topics include relational and logical opera-   Fee: $399
   tors, String and Math methods, and arrays.                                 Two-Day Class Meets 8:30am-4:00pm (13 hours)
   Fee: $399
                                                                              G2695 Mon., Nov. 21 & Tues., Nov. 22 West County Janikow
   Two-Day Class Meets 8:30am-4:00pm (13 hours)
   G2248 Mon., Aug. 22 & Tues., Aug. 23 West County Abernathy
   G2541 Thurs., Nov. 17 & Fri., Nov. 18 West County Abernathy




                  Earn Specialized Certificates
           A specialized certificate can be the reward for pursuing a challenging area of computer study. It can also show
           employers your desire to enhance job skills and productivity. You earn a specialized certificate by taking courses
           in a particular area. We have established standards, including time limits and course requirements, to ensure the
           certificate you earn is current, meaningful, and valuable to you, the student, and to employers.

           For information about each of our specialized certificates, see the inside back cover of this catalog.

   September – December 2011              •     Computer Education & Training Center             •    (314) 984-9000         •    www.cetc.umsl.edu
                                                                                                                General Information           31


 Course Information                                                     Registration & Payment




                                                                                                                                              Programming & General Information
 Course Listings                                                        How to Register
 Courses are shown with the program code, fee, day/date,                The registration office is located at 12837 Flushing Meadows
 location, and name of the instructor. Course outlines for most         Drive, St. Louis, MO 63131.
 classes are available on our Web site.                                 The registration office is open from 8:00 a.m. to 5:30 p.m.
                                                                        Monday through Thursday, and from 8:00 a.m. to 5:00 p.m. on
 Prerequisites                                                          Friday.
 Prerequisites are important to ensure the experience level of          Complete the registration form on the back page and send it
 the student is adequately matched with the content level of the        with full payment.
 class. If you are not sure you have all the prerequisites listed for
 a class, or have questions concerning the prerequisites and level      MAIL:               University of Missouri–St. Louis
 of class, take advantage of our program advising service. Call,                            Computer Education & Training Center
 e-mail, or stop by to discuss your questions with our advisor,                             12837 Flushing Meadows Drive
 Paul Westermann.                                                                           St. Louis, MO 63131
 Paul can be reached by phone at (314) 984-9000, by e-mail at           PHONE:              Charge with MasterCard, Visa,
 info@cetc.umsl.edu, or in person at our West County location.                              or Discover by calling
 Let us help you take the right class that fits your needs and                              (314) 984-9000.
 experience!
                                                                        FAX :               Fax by calling (314) 966-0409.
 Disability Access                                                      WEB:                www.cetc.umsl.edu/regonline.html
 The University of Missouri complies with the Americans
 with Disabilities Act of 1990. Persons requiring auxiliary aids        No enrollments are accepted without a registration form.
 should contact the Director of Disability Access Services,
 (314) 516-5228, at least two weeks prior to the first class
 session for assessment and assistance.
                                                                        Payment of Fees
                                                                        The registration fee for each course is shown below the course
 Alumni Association Member Discount                                     description. Checks should be made payable to the University
 Become a member of the University of Missouri-St. Louis                of Missouri–St. Louis. MasterCard, Visa, and Discover are also
 Alumni Association and receive a 10% discount on Computer              accepted.
 Education & Training Center classes. Call (314) 516-5833 for           Please note that payment of fees is due in full prior to the start
 more information.                                                      of your class. You are not officially registered until your payment
                                                                        has been received. Course fees include all course materials. No
 Bringing Your Own Flash Drive                                          additional purchases are required.
 In order to save your class work, you may bring your own USB
 flash or thumb drive. Thumb drives can be used in most of our          Invoicing
 classes.                                                               In order to be invoiced, please fill out the registration form and
                                                                        attach authorization and billing information, including the name
 Transcript Requests                                                    and signature of the person responsible for payment.
 On our Web site, you can view a list of classes you’ve attended        Please note the cancellation and refund policies. Non-payment
 using your student ID at www.cetc.umsl.edu/stdnserv.html.              or failure to abide by payment policies will result in loss of
 The information on the Web site does not include name                  invoicing rights.
 and address information. If you would prefer your attendance
 not to be included in this listing, please call the registration       Cancellation, Withdrawal & Refunds
 office at (314) 984-9000, or e-mail us at enroll@cetc.umsl.edu.        The University reserves the right to cancel any program. In
 If you would like a printed copy of your transcript on official        the event of cancellation, you will be notified immediately, and
 letterhead, contact the registration office. Written authorization     course fees will be refunded or applied to a future program at
 is required for an official transcript.                                your request.
                                                                        If you must cancel your registration or if you want to
 Enrollment Confirmation                                                transfer to another class, call (314) 984-9000 by 9:00 a.m. two
 Upon receipt of your registration, you will receive a confirma-        business days prior to the start of a day class and by 5:00 p.m.
 tion notice and a map by return mail or e-mail. Please register        two business days prior to the start of an evening class to guar-
 early to ensure timely receipt of this information.                    antee a refund or to ensure a transfer. Your student number is
 Registrations that include all information are normally processed      required to process a refund. Refunds will not be given after a
 the same day they are received, and confirmations are mailed or        course begins. There is a limit of one transfer per class.
 e-mailed out the following day. You should receive your confir-        Substitutions are allowed at any time prior to the beginning of
 mation within a week of registering for the class.                     the course. If you are unable to attend but would like another
                                                                        employee to attend in your place, contact the registration office
 For Map and Facility Information, see p. 32.                           with the necessary information to make the change.


September – December 2011           •     Computer Education & Training Center          •      (314) 984-9000       •   www.cetc.umsl.edu
32   Map & Facility Information
     West County Continuing Education Center

     The Computer Education &                                                                                                                      Hwy 40 (I-64)
     Training Center has moved                                                                                                                                                                                           Ballas




                                                                Mason Road
                                                                                                                                                                                                                          Exit

     to new facilities in the West
                                                                                                          Ou
                                                                                                            ter
                                                                                                                       Ro




                                                                                                                                                                                                           Ballas Road
                                                                                                                         ad
     County Continuing Education
                                                                                       Clayton Road
     Center at 12837 Flushing                                                                                                                                      No exit at 270
     Meadows Drive. This is                                                                                                                                        & Clayton

     minutes away from our
     previous location.
                                                                                New location!
     The Center is located in the




                                                                                                                                                          I-270
     Bel Aire Office Park, near




                                                                                                                                      Des Peres Road
     the intersection of I–270 and                                                                                                                                                      N
     Manchester Road, just down                                          UMSL
                                                         West County Continuing Education Center                                                                            W
     Des Peres Road from the Des
                                                                                                                                                                                                       E
                                                                     12837 Flushing Meadows Drive
     Peres Ciné.                                                          St. Louis, MO 63131                                                                                            S


     From Des Peres Road, turn
                                                                                                                  Deer Tracks
                                                                                                                     Trail
                                                                             Parking

     west onto Flushing Meadows                                                                Hidden
                                                                                               Creek Ct
                                                                                                                           Bel Aire
                                                                                                                           Office




                                                                                                                                                                                                           Ballas Road
     Drive. Go approximately two
                                                                                                                            Park
                                                                                       Flushing Meadows Drive

     blocks past Deer Tracks Trail.                                                                               oa
                                                                                                                       d

     The Center is a brown                                                                         De
                                                                                                     sP
                                                                                                       ere
                                                                                                             sR
                                                                                                                                                                          J.J. Kelley Memorial Drive

     building on your right.                     Westbound Manchester Road Only


     Registration is on the first
     floor, in the center of the                   Eastbound Manchester Road Only
     building.
                                                                                                                               Des
                                                                                                                               Peres
                                                                                                                                                           I-270                    West County
                                                                                                                                                                                     Shopping
                                                                                                                              Square                                                  Center




     Parking                                                                              Chancellor’s Certificate & CEUs
     Course fees include all parking charges for Computer Education                       By completing 96 hours of classroom work (9.6 CEUs), you
     & Training Center courses. No permit is required for the West                        receive the Chancellor’s Certificate on the Computer. This cer-
     County Continuing Education Center.                                                  tificate provides recognition for the time and effort you spent
     Parking can be accessed off Flushing Meadows Drive or two                            to expand your computer knowledge. In addition, Continuing
     entrances off Hidden Creek Court. Parking is available both in                       Education Units (CEUs) are offered for participation in these
     front and behind the building. Handicap-accessible parking is                        courses and are kept on record at the University. CEUs (one
     located at the front of the building.                                                for each 10 class hours) record your efforts toward personal
                                                                                          and professional growth. For more information, contact Paul
                                                                                          Westermann at (314) 984-9000, or info@cetc.umsl.edu.
     Check-In
     Please arrive 10 to 15 minutes early for your first class session                    For More Information
     to check in and receive your course materials. Day class check-in
     begins at 7:45 a.m. Evening class check-in begins at 5:30 p.m. Go                    To register or find out if
     to the registration area on the first floor.                                         a class is full                                                                      (314) 984-9000
                                                                                          To receive a catalog                                                                 (314) 984-9000
     The Facility                                                                         Course & Certificate advice
     You will be given an hour for lunch. Restaurants are located
                                                                                            Paul Westermann                                                                    (314) 984-9000
     nearby (within a 5- to 10-minute drive). There are vending
     machines and a small student lounge in the building for eating                       For information on our PrePurchase program,
     lunch.                                                                               group training, or room rentals
     No child-care facilities are available. Children who are not regis-                    Kate Moore                   (314) 984-9000
     tered for a class cannot accompany students to classes or be left
     unattended at the facilities during classes.


     September – December 2011           •    Computer Education & Training Center                                              •                      (314) 984-9000                    •         www.cetc.umsl.edu
                                                                          Specialized
            Certificate Programs
The Computer Education & Training Center offers 10 Specialized Chancellor’s Certificates.
These certificates demonstrate your technical knowledge, skills, and hands-on experience in a
concentrated area of study. Use these certificates to explore a new career or a career change,
or to update your current computer knowledge.

Chancellor’s Certificate in Web Page Design provides you with the tools you need
to design, develop, and maintain attractive and effective Web pages.

Chancellor’s Certificate in Web Scripting and Interactivity is for Web designers,
                                                                                               Why pursue a
technical managers, developers, and authors who want to add interactivity to their Web          specialized
sites to gather information and heighten the user experience.                                   certificate?

Chancellor’s Certificate in Web Programming and Databases provides you with                   Explore a new career
the tools you need to design, install, and maintain Web-based applications.                    or a career change.

Chancellor’s Certificate in Database Technology provides you with an understand-                 Strengthen and
ing of database technology and database design, development, and implementation.               update your current
                                                                                              computing knowledge
Chancellor’s Certificate in Business Applications helps develop computer skills                 and increase your
and proficiency in a variety of software applications that are essential for success in           value to your
today’s office environment.
                                                                                                  organization.
Chancellor’s Certificate in Programming teaches you fundamental programming
concepts and how they apply to procedural and object-oriented languages, as well as the        Use the certificate
standard techniques and programming logic that will help you solve practical problems.        to demonstrate your
                                                                                               computer skills to
Chancellor’s Certificate in Electronic Art and Publishing is for designers, editors,          current and potential
desktop publishers, and others responsible for producing layout and artwork for                    employers.
distribution through a conventional printing process or electronically via the Web.
                                                                                                  Learn specific,
Chancellor’s Certificate in Digital Graphics is for traditional designers who are              targeted computer
going digital, as well as those with experience working in a digital environment, including       skills and earn
graphic designers, illustrators, desktop publishers, Web designers, and photographers.        credentials for proof
                                                                                                 of concentrated
Chancellor’s Certificate in Excel is for anyone using Excel to input and manage data                     study.
and who wants to learn the Excel features that automate your work, prevent errors,
make data entry easier, and visually present your spreadsheet for the greatest                  Use the certificate
understanding and impact.                                                                      program as a guide
                                                                                              for a course of study.
Chancellor’s Certificate in SharePoint covers the collaboration features of
SharePoint, as well as how to integrate with Office products, store and secure data,
customize lists, and manage user access.


For more information, visit our certificate Web page:

www.cetc.umsl.edu/webfacts.html
University of Missouri-St. Louis                                                                                                           Nonprofit Org.
                                                                                                                                             U.S. Postage
Continuing Education
                                                                                                                                                 Paid
One University Boulevard
                                                                                                                                            St. Louis, MO
St. Louis, MO 63121-4400
                                                                                                                                            Permit No. 3


                                                          VISIT OUR WEB SITE AT www.cetc.umsl.edu




Computer Education & Training Center Classes                                                 SEPTEMBER – DECEMBER 2011 CLASSES


name                                                                                         student # (if known)    Complete the application
                                                                                                                     form on the left and en-
                                                                                                                     close full payment with
employer                                                                                                             registration.

                                                                                                                     Please fax or mail the entire
address for mailing confirmation
                                                                                                                     page, including the mailing
                                                                                                                     label.
city                                                         state               zip
                                                                                                                     Confirmation and map will be
                                                                                                                     mailed (or e-mailed) on
address for billing (if different from address for confirmation)                                                     receipt of registration.

                                                                                                                     To register or check if a class is full:
city                                                         state               zip
                                                                                                                                 (314) 984-9000

phone: business                             home/cell                                  fax                           For course content information:

                                                                                                                                 (314) 984-9000
e-mail address (to e-mail you a confirmation of your class registration)                                             By Mail:   University of Missouri-
                                                                                                                                St. Louis, 12837 Flushing
course_________________________________________ course code_________ fee_________                                               Meadows Dr., St. Louis,
                                                                                                                                MO 63131-1824
course__________________________________________course code_________ fee_________
                                                                                                                     By Phone: Charge with MasterCard,
                                                                                                                               VISA, or Discover
course__________________________________________course code_________ fee_________                                              by calling
                                                                                                                               (314) 984-9000
Fees are payable by check or charge. To charge, fill in: MasterCard/Visa/Discover #
                                                                                                                     By Web:     www.cetc.umsl.edu

                                                                                                                     FAX:        (314) 966-0409
amount paid__________ exp. date_____________ signature                __________________________________________
                                                                                                                     FOR INVOICING: In order to be
                                                                                                                     invoiced, please fill out the regis-
       I do not want to register for a course right now, but please keep me on your mailing list for future course   tration form and attach authoriza-
       catalogs.
                                                                                                                     tion and billing information,
       Coming from a distance? Please check here and we’ll send you hotel information, or you can visit our Web      including the name and signature
       site: http://www.cetc.umsl.edu/hotels.html                                                                    of the person responsible for
                                                                                                                     payment.
       Please send me an application form for the following specialized certificate(s) (from inside back cover):
                                                                                                                                        0.9.11#MKD

				
DOCUMENT INFO
Shared By:
Tags:
Stats:
views:20
posted:10/12/2011
language:Swedish
pages:36