close

Вход

Log in using OpenID

IT Training Catalog (pdf)

embedDownload
IT Training Catalog
Last updated: Summer 2014
Simplifying Technology
Enhancing Productivity and Skills
LEARNING TECHNOLOGIES
A world of learning options
Online workshops and webinars
Learn with lynda for free
IT Training continues to expand its outreach by offering more
lynda.com is a leading provider of online self-study training, with
training online allowing you to take workshops and webinars
comprehensive coverage of Adobe applications and technologies,
at the location that best suits your needs. Webinars are
open source software, Macintosh applications, and multimedia and
presentation only and allow for you to chat with the instructor.
web programming. Their video-based elearning format works well for
Online workshops are like our regular classroom workshops in
those who are short on time and need self-study options. IU students,
that they facilitate assisted hands-on practice; participants can
faculty, and staff statewide continue to enjoy fee-free access to
also ask questions of the instructor via chat.
the entire lynda elearning library! Additionally, you can track your
course history and easily pick up where you left off. Learn more at
Get up and running in Adobe CS6 and Office 2013
lynda.iu.edu.
Our popular Adobe and Microsoft Office workshops are taught
in the most current versions - Adobe CS6 and Office 2013.
most-used software tools!
Step ahead
EdCerts
With award-winning training
Our EdCert (Education Certification) program delivers high-
UITS IT Training has won international awards for its workshop
quality industry standard advanced technical training to
materials and online training offerings. Additionally, universities and
members of the IU community, and many can be taken by non-
organizations from around the world are using IT Training workshop
IU participants as well. Learn more on p. 4 and by checking out
materials in their own training programs.
Take advantage of the opportunity to grow your skills with the
the descriptions on pp. 38-56.
Workshop materials
IU faculty, staff and students can download IT Training’s
On the most current technologies
We keep our technology up to date to help you keep on top of the
most current innovations.
workshop materials for self-study learning. Go to
ittraining.iu.edu/downloads to get started. If you are not a
Taught by experienced instructors
member of the IU community, you can still order printed
Our instructors average more than 10 years experience in
copies to use in self-study mode. To place an order, go to
developing and delivering training and education. Our staff
ittraining.iu.edu/materials.
members have chaired programs, judged competitions, and
Coaching sessions
presented papers at national conferences.
Come to a free coaching session to get hands on help in
Teaching the latest technoloogies!
applying any technology we teach to projects you are working
IT Training’s workshops are designed to help you build your
on. An IT Training staff member will be on hand to answer your
productivity and problem solving skills By making the technology
questions on how to apply what you learned in our workshops
simpler for you, we can help you expand your creative canvas and
or on our blog to the tasks you need to complete.
enable you to get your work done more efficiently and effectively. In
Stay in touch
2013, 95% of all workshop participants indicated on their workshop
evaluation form that what they learned in the workshop would help
You can subscribe to our monthly it2go newsletter to keep up
them in their career or academic work. Additionally, the UITS user
to date with the latest training news. You can also subscribe to
survey indicated an overwhelming 97% satisfaction with our self-
the IT Training Tips blog or follow us on Twitter or Facebook.
study options such as lynda.com, Skillsoft and Microsoft eLearning
See the Stay Connected section at ittraining.iu.edu.
courses; downloadable workshop materials; IT Training Tips blog;
IT Training Tips blog
and Oncourse Feature Demos.
Our award-winning IT Training Tips blog (ittrainingtips.iu.edu) has
Ready, set, learn!
short text and video based tutorials and how-to tips on a wide
Look through the catalog and visit us online and get a STEP ahead!
range of technology topics. Use IT Training Tips to learn more
ittraining.iu.edu
about applications you learned to use in workshops or to start
studying new computing topics. Comment or ask questions on
the articles you read and join in on the conversations.
Contents
Instructor-led training. . . . . . . . . . . . . . . . . . 2
Self-study, certification, & group training . . . . . . 3
IT Training Certificate series . . . . . . . . . . . . . 4‑5
Design & media. . . . . . . . . . . . . . . . . . . . 6‑12
Page design
PowerPoint & Prezi
Illustrator CS6
Captivate
InDesign CS6
Dreamweaver & Fireworks
Photoshop CS6
HTML5 & CSS
IU systems. . . . . . . . . . . . . . . . . . . . . . .15‑21
Oncourse
SharePoint
Cascade Server
SAS &SPSS
IUIE
Excel
UniCom
PowerPoint & Prezi
Business Intelligence
Microsoft Project
CRM
Productivity . . . . . . . . . . . . . . . . . . . . . 22‑32
Access
Word
Outlook
SharePoint
Technical skills . . . . . . . . . . . . . . . . . . . 33‑49
CompTIA
Microsoft server
Hardware
High performance computing
Python & PHP
SAS
Outlook
SAS & SPSS
Unix
Cloud computing
Web development. . . . . . . . . . . . . . . . . . 50‑56
Web publishing
Cascade Server
HTML5
Cascade Style Sheets
Dreamweaver
XHTML
Unix
User-centered web
Questions? Contact us!
UITS IT Training
Two campuses—One program . . . . . . . . . . . . . 57
Phone: (812) 855-7383 or (317) 274-7383
Maps to our sites. . . . . . . . . . . . . . . . . . . . 58
Email: ittraining@iu.edu
Instructor-led training
IT Training workshops, webinars, coaching sessions,
& certificate series
Canceling your enrollment
Our workshops are open to everyone, and most are free to staff,
least two weekdays advance notice if you will be unable to attend a
faculty, and students from any IU campus and offered for a
workshop. You can cancel your enrollment online through your user
nominal fee to everyone else. Webinars and coaching sessions
profile or by contacting us.
are free for everyone. In addition:
• If you paid to enroll in a workshop that you cannot attend, we will
Due to the popularity of our workshops, we ask that you give us at
• IT Training workshops have won multiple national awards.
refund your registration fee only if you notify us at least two working
• Workshops are taught on the Bloomington and Indianapolis
days before the day the workshop is scheduled to be taught.
• If you are enrolled in a free workshop that you cannot attend, please
campuses and many are also offered online.
notify us at least two weekdays in, so we can make your seat available
• Webinars are regularly offered online on new and cutting to other participants.
edge topics
• Anyone who enrolls but fails to attend or give adequate advance
• Workshops and webinars are offered on more than 80 beginning
cancellation notice for three free workshops during an academic
to advanced topics.
year will lose their free registration privileges for the rest of that
• Workshops are offered in a modular sequence so you can take
academic year.
the appropriate workshops for your skill level.
• Anyone who loses their free registration privileges can still reserve a
• Most workshops and webinars are 1-3 hours long and include
seat in a workshop for a fee or participate as a walk-in registrant at no
materials you keep.
charge, provided seating is available.
• Webinars are recorded allowing you to view them if you are
unable to attend the session.
Our guarantee
• Many workshops are part of a series to help you build skills If you paid to attend a regularly scheduled workshop and are not
over time.
completely satisfied, we will cheerfully refund your registration fee.
• Workshops combine instructor lecture with hands-on practice.
• Assistants are available to help participants.
EdCerts
• You can download exercise files from our Website to work through
Our EdCert (Education Certification) program delivers high-quality
the materials on your own.
• Brief descriptions of all workshops can be found on pp. 8-62.
industry standard advanced technical training to departmental
• IT Training Certificate Series are available. Series enable you to
computing support providers, technical staff, enrolled IU students,
earn certificates by taking a group of related workshops. Paying
faculty who teach advanced technical topics in their academic
participants receive a 10% discount when they register for all
classes, and others. Most EdCerts use third party training materials
workshops in a series at once. See descriptions on pp. 6-7.
from industry leaders like Microsoft and CompTIA and so there is
typically a registration fee. Most EdCerts are multi-day and cover
• We can provide assistance for persons with disabilities. Advance
advanced topics in depth. Taking EdCert courses helps prepare
notice is important. Contact us if you have a need.
attendees to take industry standard professional certification exams.
The most current descriptions, schedules, and registration
information can be found online at:
To learn more about the EdCert program, see descriptions on pp.
ittraining.iu.edu/training
37-39. To register, go to:
ittraining.iu.edu/edcert
2
Self-study, certification, & group training
Self-study options
Special request workshops
IT Training offers a wide range of self-study options:
Faculty, AIs, and TAs at IU Bloomington and IUPUI can request that
• Lynda.com offers more than 2,000 video-based elearning
we teach a specially scheduled session of most workshop topics to
courses on Adobe, Microsoft, and Macintosh-specific
their students at no charge. Additionally, departments, businesses,
applications, open source technologies, and multimedia and web
and other groups can request that we teach a specially scheduled
development. This award-winning service is available to IU staff,
session of a workshop to their staff at no charge. To get more
faculty, and students statewide.
information, or to request a specially scheduled workshop, go to:
• Thousands of eLearning courses on advanced IT topics and
ittraining.iu.edu/request
professional skills are available for a nominal fee through Indiana
University’s license agreement with Skillsoft.
Note: Special Request workshops scheduled as resources permit.
• Microsoft eLearning courses on Office and Windows are available
Please give at least three weeks advance notice.
to IU students, staff, and faculty at no charge.
• IU students, staff, and faculty can download workshop materials
Faculty, AIs and TAs using our materials to teach
their students
at no charge. Anyone can order printed copies for a small fee. You
can also download the associated exercise files to use in working
through workshop content on your own.
Faculty, AIs, and TAs on all IU campuses are welcome to use our
• Free IT Training-developed tutorials and course materials are
materials at no charge to teach their students. Contact us if you
available on new features in Adobe, Oncourse CL, Windows End-
would like to pursue this option:
User Security, student email, UniCom, podcasting, and more.
IU Bloomington: ittraining@iu.edu or (812) 855-7383
To learn more about all of your training options, visit:
IUPUI: ittraining@iu.edu or (317) 274-7383
ittraining.iu.edu/online
Skills certification
IT Training offers Microsoft Office Specialist exams, which
enable you to certify your skills in Office 2013 applications.
We also offer Transcender and Prometric exam vouchers to
EdCert participants who want to certify their skills in advanced
IT topics. Additionally, you can earn certificates by taking IT
Training Certificate Series.
To learn more about your certification options, visit IT Training’s
Certification page at:
ittraining.iu.edu/certification
Group training options
IT Training also offers special training opportunities for your class,
department, business, or group.
Room reservations
Our training classrooms are also available for reservation for
conferences, meetings, and special events for a fee. To get more
information or to reserve a training room at IU Bloomington or
IUPUI, go to:
ittraining.iu.edu/services/room_res.aspx
3
IT Training Certificate Series
Overview
Access 2013 end-user
IT Training is making it easier for you to find the training you need
Databases are ideal tools for tracking large volumes of data, and
and to enable you to earn the recognition you are looking for
Microsoft Access is a popular and powerful tool used to design and
when you expand your computing skills with us! These series
develop Windows-based databases. This series, which is intended for
will help you grow your skills in Office and Adobe applications,
new Access users, introduces the most important features in Access
web development, and desktop publishing.
which end-users need to know to work with Access databases.
General information
Participants must complete the following workshops to receive
IT Training Certificate Series enable you to earn certificates
a certificate:
by taking a group of related workshops together. Certificate
• Access 2013: The basics
Series attendees receive a certificate of achievement on
• Access 2013: Database relationships
completion, and paying participants receive a 10% discount
• Access 2013: Queries
when they register for all workshops in a series at once. This
• Access 2013: Forms
is the perfect way to learn about an application or topic in a
• Access 2013: Reports
comprehensive way!
• Access 2013: Project Lab
To register for an IT Training Certificate Series online, go to:
Note: The Project Lab is a special workshop for series registrants
only, and it gives participants practice in creating database
ittraining.iu.edu/workshops/series.aspx
components on their own.
Office 2013 productivity
Workshop fees
In this series, you will be introduced to a variety of Microsoft Office
applications and learn ways you can make them work together.
Participants will learn the basic skills for day-to-day office activities
90-minute workshops
from creating a spreadsheet in Excel to creating a PowerPoint
• Free to IU students, staff & faculty
presentation.
• $35 general public & non-profit
Participants must complete the following workshops to receive
2-3 1/2-hour workshops
a certificate:
• Free to IU students, staff, & faculty
• Outlook 2013: Calendar essentials
• $50 non-profit agency employees
• Outlook 2013: Managing your email
• $60 general public
• Word 2013: The essentials
• PowerPoint 2013: The basics
4-6-hour workshops
• Excel 2013: The basics
• Free to IU students, staff & faculty
• Access 2013: The basics
• $55 non-profit agency employees
• $65 general public
Excel 2013 end-user
IT Training Certificate Series
Excel is the most-used spreadsheet and analysis application today.
SAVE 10% off the cost of the workshops by
In this series, you will be introduced to some of the most commonly
registering for all workshops in a series at once.
used features in Excel and build upon that foundation as you extend
your charting and data tracking and analysis skills in Excel.
Participants must complete the following workshops to receive
a certificate:
• Excel 2013: The basics
• Excel 2013: Charts & graphics
• Excel 2013: Data management
• Excel 2013: Basic automation using macros
4
IT Training Certificate Series (cont’d)
Excel 2013 advanced end–user
Website development fundamentals
This series will help you take your data analysis capabilities to
Developing even simple websites according to current standards
the next level by teaching you how to compare different data
demands an understanding of Extensible Hypertext Markup
scenarios and to predict future trends in Excel. You will learn
Language (XHTML) and Cascading Style Sheets (CSS). Adobe
how to use pivot tables to summarize data in flexible ways,
Dreamweaver is a robust tool for visually designing and building
look up related data from other worksheets, use conditional
Web pages, but it is often not enough. Most web pages also utilize
logic to summarize, count, or format specific data, and use the
images, whether in the form of banners, buttons, logos, photos or
data table, Goal Seek, and Solver tools to solve complex data
scans. Adobe Fireworks was built from the ground up as a tool to
analysis problems. In addition, you will learn how to create
create and manipulate images destined for the web, and to enable
sophisticated macros to automate your work.
creators to optimize those images in order to minimize file size.
Fireworks also provides excellent integration with Dreamweaver
Participants must complete the following workshops to receive
to streamline the web development process. This series provides
a certificate:
a comprehensive introduction to XHTML, CSS, and web image
• Excel 2013: Analyzing data with pivot tables
production; it concludes with a practice lab where participants
• Excel 2013: Using VLOOKUP & conditional functions
can apply what they’ve learned in an open-ended setting and
• Excel 2013: What-if analysis & named scenarios
independently create a basic Website with graphics.
• Excel 2013: Advanced macros & user-defined functions
Participants must complete the following workshops to receive
a certificate:
Desktop publishing fundamentals
• Dreamweaver CS6: The basics
Documents that require precise layout of text and graphics,
• Dreamweaver CS6: Using templates to standardize your site
such as brochures, newsletters, and professional looking
• Illustrator CS6: Creating graphics for the web
flyers, are typically designed using several graphics software
• Website development Project Lab
applications that specialize in certain tasks. Adobe, Inc.
offers all of these applications in a package named Creative
Note: The Project Lab is a special workshop for series registrants
Suite, which includes Photoshop, Illustrator, and InDesign.
only, and it gives participants practice in creating a website with
In this series you will learn how to use Photoshop to modify
integrated graphics.
photographs, use Illustrator to create logos and line art, and
how to pull it all together with text into a layout using InDesign.
Participants must complete the following workshops to receive
a certificate:
• Photoshop CS6: The basics
• Illustrator CS6: The basics
• Page design & layout basics
• InDesign CS6: The basics
• InDesign CS6: Using page masters for efficient design
• Desktop Publishing Project Lab
Note: The Project Lab is a special workshop for series
registrants only, and it gives participants practice in creating a
completed print project.
5
Design & media
Desktop publishing
Adobe CS6: Pen tool basics for advanced graphic design
In this workshop, participants will learn about paths. Paths are used
Illustrator CS6: The basics
as the building block for all vector objects in many graphic design
This workshop lasts 3 hours, and is part of the certificate
programs. Once participants are comfortable with paths, we will
series Desktop Publishing Fundamentals. In this workshop,
learn how to use one of the most challenging and powerful path
participants will learn how the basics of Adobe Illustrator, a
creation tools: the Pen tool. This tool is difficult to master, but in this
drawing program. Participants will spend time building basic
workshop, we will build up specific skills slowly, and by the end of
skills like drawing with brushes, creating and combining
the workshop, participants will be comfortable using the tool. We will
shapes, and using gradients, and will then use those skills to
also examine differences of the tool in several Adobe applications,
create a professional looking business logo.
including InDesign, Fireworks, Flash, and Photoshop. This workshop
In this workshop, you will:
will run for 3 hours, with an additional half hour of lab time for practice
• Explore the shape creation tools
of new skills with the instructor present. Participants are free to use as
• Combine and alter shapes
much of the practice time as they like. In this workshop, you will:
• Create gradients
• Use the Pen tool proficiently in the Adobe Creative Suite
• Understand the different selection tools
• Understand paths and path creation in the Adobe Creative Suite
• Understand stroke and fill
• Create simple and complex shapes using the Pen tool
• Create a professional looking logo
• Alter paths to create new shapes
• Examine path creation with multiple tools
Prerequisite: Windows: Basic computing skills or
• Examine how the Pen tool would be used in Photoshop, InDesign,
equivalent skills
Flash and Fireworks
Length: 3 hours
Prerequisite: Illustrator CS6: The basics or equivalent skills
Illustrator CS6: Creating graphics for the web
What you need to know:
This workshop introduces the different tools Illustrator offers to
• Use the mouse and keyboard proficiently
create web graphics
• Use the Adobe interface
What You’ll learn:
Length: 3 hours
• Learn the difference between vector and bitmap graphics
• Create graphics for a website, including a banner, buttons, InDesign CS6: The basics
and a background
• Import and manipulate graphics in Illustrator
This workshop is intended to be a four-hour hands-on experience.
• Choose and apply filters to objects
In the context of constructing a basic newsletter, participants of this
• Optimize images for the web
workshop will manipulate text and graphic objects using a broad
range of InDesign tools. Brief references to basic design principles
and terminology will be incorporated into the process. In this
Prerequisite: Windows: Illustrator CS6: The basics or
equivalent skills
workshop, you will:
What you need to know:
• Apply basic principles of layout and design
• Navigate the Illustrator interface
• Set up a publication
• Edit and manipulate art elements
• Create, edit, and apply styles to format text
• Work with shapes and text in Illustrator
• Work with text and graphic frames
Length: 3 hours
• Import and place external graphics
Prerequisite: Word 2013: The essentials or equivalent skills
What you need to know:
• Use word processing features
• Apply text styles
• Be proficient with refined mousing tasks
Length: 3 hours
6
InDesign CS6: Using page masters for efficient design
InDesign CS6: Creating a poster
Participants will work on a newsletter publication that features both
InDesign is a page design application frequently used for
text and graphics. While participants edit the original document and
newsletters or other publications. However, InDesign is also a
expand it, they will learn how to use InDesign page masters, which
powerful tool for any kind of print design. In this session, we’ll
are underlying templates for document pages. They will also learn
explore how to go about creating a poster in InDesign, including
how to: flow text from one part of a document to another: check
selecting a page size, working with backgrounds and layers, adding
a document for errors; and perform some common publishing
artwork, selecting fonts and working with colors. This session will
techniques. In this workshop, you will:
also discuss design decisions made during the process. This session
• Configure and apply page masters
is appropriate for basic to intermediate users of InDesign who have
• Create headers and footers
never successfully used it to create a poster. In this webinar, you will:
• Create automatic “continued on” segments
• Create a new document
• Thread a story with in and out ports
• Add a background
• Copy and paste with the Content Collector and
• Place artwork
Content Placer tools
• Work with fonts
• Modify a frame and content independently
• Create and add colors
• Resolve missing links and fonts
• Understand design decisions
• Package a publication for sending
• Export in Portable Document Format
Prerequisite: Windows: Basic computing skills or equivalent skills
What you need to know:
Prerequisite: InDesign CS6: The basics or equivalent skills
• Use a mouse and keyboard
What you need to know:
• Be familiar with graphic file formats
• Use word processing features
Length: 2 hours
• Apply text styles
• Be proficient with refined mousing tasks
Length: 2 hours
Page design & layout basics
This workshop introduces basic page design theory. It is not a
“hands-on” experience; there will be no interaction with computers.
Digital magazine publishing with InDesign
The workshop is designed to provide basic instruction on how plan a
With the advent of tablet PCs, there is a new type of magazine that
publication’s layout. In this workshop, you will:
designers need to be ready for: the Digital Magazine. In this session,
• Learn how readers perceive and view elements of text, graphics, and
we’ll look at what a Digital Magazine is, along with how to go about
“white space”
using the Adobe tools in conjunction with InDesign in order to design
• Explore how to best convey the purpose through placement choices
for this new medium. We’ll also discuss how these magazines can be
• Learn about the anatomy of typography and usability
published on various tablet PCs through the Adobe Digital Content
• Learn how to examine and troubleshoot type, graphics, and Viewer, or IU Libris. In this webinar, you will:
visual elements
• Understand how InDesign can be used to create digital magazines
• Learn to plan color in a document
• Create a digital magazine in InDesign
• Gain a basic understanding of publication terminology
• Publish a digital magazine
Prerequisite: Windows: Basic computing skills or equivalent skills
Prerequisite: InDesign CS6: Creating a poster or equivalent skills
What you need to know:
What you need to know:
• Use a mouse
• How to work in the InDesign interface
• Use Windows command menus
Length: 90 minutes
• Save and organize files
Length: 3 hours
7
Photoshop CS6: The basics
Photoshop CS6: In-depth healing tools
In this workshop, participants will learn the basics of Adobe
In this workshop, participants will be challenged to master the
Photoshop, the premiere image editing application. Particpants will
various Healing Tools Photoshop offers. The Healing Tools in
learn how to retouch a photo while building skills that will help them
Photoshop enable users to remove damaged or distracting portions
go further with the application. Participants will also work on a more
of an image, and even replace sections of an image that may be
complex photo compositing project, and learn about layers, selections,
missing. Participants will spend time in this workshop learning how
healing tools, and image adjustments. In this workshop, you will:
each tool behaves and examine situations in which it would be the
• Understand the Photoshop interface
most appropriate tool to use. Participants will also spend plenty
• Retouch and blend two images
of time practicing with these tools and mastering the techniques
• Understand layers
required to get the most out of them. In this workshop, you will:
• Use effects and filters
• Use the Clone Stamp Tool, Healing Brush, Spot Healing Brush, and
• Use the History Panel
Patch Tool
• Save a file for the web
• Use the Crop tool to minimize work
• Use basic healing tools
• Repair torn and cracked images
• Remove spots and distracting elements from images
Prerequisite: Windows: Basic computing skills or equivalent skills
• Learn to use the best tool for different types of damage to the image
What you need to know:
• Use the mouse and keyboard proficiently
Prerequisite: Photoshop CS6: The basics or equivalent skills
Length: 3 hours
Length: 2.5 hours
Photoshop CS6: Restoring old photos
Photoshop CS6: Restoring & blending images
In this session, participants will look at some techniques to restore
This workshop is especially for people who want to learn to create
old photographs in Photoshop. We will look at using healing tools,
photo collages and for those who are interested in refurbishing
sharpening, contrast adjustments, and color correction. In this
digital images of aging photographs. Designed for people with some
webinar, you will:
experience using Photoshop, this workshop delves more deeply into
• Work with old photographs
Photoshop image-editing strategies and practices. Participants will
• Learn techniques for restoring photographs
learn the most beneficial way to modify images, using channels and
• Work with healing tools
masks to preserve and edit their work. While doing the exercises,
• Work with adjustment layers
participants will save and re-use complex pixel selections, colorize
grayscale photographs, learn the best method to create collages, and
Prerequisite: Photoshop CS6: The basics or equivalent skills
explore the ways Photoshop digitizes color. In this workshop, you will:
What you need to know:
• Restore digital scans of aging photographs
• Work with Photoshop interface
• Sharpen a blurry image
Length: 60 minutes
• Create a true black and white image from a yellowing photo
• Blend two images together with a gradient mask
• Create sepia tone effects with a Duotone
Basic digital photo editing with Adobe Photoshop
• Colorize a grayscale image
Photoshop is a wonderful tool, but can be a bit intimidating with all
• Create a photo collage
of its tools. Learn very basic skills in digital photo editing to get up
and running with Photoshop. In this webinar, you will learn:
Prerequisite: Photoshop CS6: The basics or equivalent skills
• How to straighten an image
What you need to know:
• How to crop an image
• Work with Photoshop’s toolbox, Options bar, and palettes
• How to correct blemishes
• Make basic pixel selections
• How to correct poor exposure, lighting, and focus
• Use filters
• How to save image for print, email, or the web
• Work with layers
Length: 3 hours
Prerequisite: Windows: Basic computing skills or equivalent skills
What you need to know
• Use a mouse fluently, including press and drag functions
• Create folders and manage files in Windows interface
Length: 50 minutes.
8
Presentations
Desktop publishing project lab
In this 3-hour lab session, you will integrate the skills you learned
PowerPoint 2013: The basics
in Photoshop, Illustrator, and InDesign to independently create a
PowerPoint is the most popular and widely used presentation
design project. You will work with predetermined materials and your
software package in the world. This workshop will teach participants,
own design ideas. In this workshop, you will:
with little or no previous experience with PowerPoint, how to create
• Create a layout using InDesign
and deliver a finished presentation. In this workshop, you will:
• Crop and resize photos (provided), with Photoshop
• Use the PowerPoint 2013 Interface
• Place a main body of text (provided)
• Begin a new presentation
• Create subheads within the main body
• Insert existing slides into a presentation
• Work with a separate piece of text
• Add, rearrange, and delete slides
• Create a banner or nameplate, featuring the name of the publication
• Apply layouts, themes, and QuickStyles
• Apply at least two text styles
• Work with text and bullets
• Use one or more color elements
• Insert clip art and pictures
• Create a vector-based object using Illustrator
• Apply simple animations and transitions
• Create audience and presenter handouts
Prerequisite: Page design & layout basics, Photoshop: The basics;
• Rehearse and deliver a presentation
Illustrator: The basics; InDesign: The basics
What you need to know:
Prerequisite: Windows: Basic computing skills or equivalent skills
• Generate and manage text and graphic frames in InDesign
What you need to know:
• Resize and crop images using Photoshop
• Use a mouse
• Work with font specifications in InDesign
• Work with command menus
• Use Paragraph Styles in InDesign
• Save and organize files
• Work with the Color palette in InDesign
Length: 3.5 hours
• Manipulate a vector object in Illustrator
Length: 3 hours
Note: You can only register for this workshop as part of the Desktop
Effectively presenting data in office applications
Publishing Fundamentals IT Training Certificate Series.
Once you have compiled an interesting and compelling data set,
how do you present it for maximum impact? In this webinar, you
will learn how to use Excel charts, Access reports, and PowerPoint
Premiere Pro CS6: The basics
to maximize the visual impact of your data and present it more
Premiere Pro is a part of the Adobe CS6 Production Premium Suite.
effectively. You will also learn how to leverage these tools into written
It is a full-featured video editing application that is used by some
reports developed in Word. In this webinar, you will learn:
professional videographers. During this workshop, participants will
• An overview of the different features and chart types available in
become familiar with the Premiere Pro interface, and will learn how
Excel charts and pivot charts
to import audio, video, and graphic files into a presentation. They will
• How to determine which chart type best tells the story of
learn different methods for trimming clips, working with still images,
A specific data set
and creating titles and text overlays. At the end of the workshop,
• Learn how Access reports can be used to effectively present
participants will explore Premiere’s publishing options and will use
Complex data sets
Adobe Media Encoder to convert their video masterpiece into a
• How to incorporate charts and other visual elements into PowerPoint
movie that can be posted on the web. In this workshop, you will:
• How to leverage these different resources into written reports
• Become familiar with the Adobe Premiere Pro CS6 interface
developed in Word
• Select settings and adjust preferences
• Learn how to import footage and other assets
Prerequisite: Windows: Basic computing skills or equivalent skills
• Trim, cut, and move clips
What you need to know:
• Add titles and transitions
• Basic computing skills
• Work with still images and audio
• Basic skills in Office applications
• Publish a project
Length: 60 minutes
Prerequisite: Digital video: An introduction or equivalent skills
What you need to know:
• Understand basic video concepts and terminology
• Use Windows Movie Maker or another video editing application to
perform simple edits
Length: 3.5 hours
9
PowerPoint 2013: Creating customized backgrounds,
graphics, & animations
Prezi: The basics
Intended for users with basic PowerPoint skills who want to
application that can be used to create non-linear presentations.
learn how to design more visually appealing presentations, this
In this webinar, you will learn:
short workshop will teach participants how to create customized
• How to get started with Prezi
backgrounds, impressive graphics and diagrams, and eye-
• How to create a basic presentation
catching WordArt. Participants will also learn how to apply custom
• When and why you might want to use Prezi instead of PowerPoint
In this webinar, you will learn how to use Prezi, an exciting new
animations to their graphics. In this workshop, you will:
• Customize a theme
Prerequisite: Windows: Basic Computing Skills or equivalent skills
• Create customized backgrounds
Length: 2 hours
• Link and embed tables and charts
• Add hyperlinks and section breaks
PowerPoint 2013: Setting up a slide show with
audio & video
• Insert and modify WordArt and Smart Art graphics
• Apply animation to graphics
Go beyond the basics and add pizazz to your presentations. In this
Prerequisite: PowerPoint 2013: The basics or equivalent skills
fast-paced workshop, you will learn how to add audio and video to a
What you need to know:
slide show, and then you will edit these multimedia clips from within
• Create and deliver a basic presentation
the application. In this workshop, you will:
• Insert clip art and pictures into slides
• Add an audio clip to a slide
• Apply simple layouts and transition effects
• Configure an audio file so that it will play across multiple slides
• Save and print a presentation
• Add a video clip to a slide
Length: 2.5 hours
• Edit a video clip from within PowerPoint
• Add a bookmark
• Crerate triggers
PowerPoint 2013: Slide masters
• Create a link to an online video
In this short, fast-paced workshop, you will find out why most
• Capture a screenshot from within PowerPoint and add it to a slide
advanced PowerPoint users prefer to create their presentations
using slide masters. You will learn how slide masters can help to
Prerequisite: PowerPoint 2013: The basics or equivalent skills
protect a slide show from being tampered with or edited, and you
What you need to know:
will learn how using slide masters can save you time when editing
• Create and deliver a basic presentation
pre-existing presentations. You will also learn how you can set up
• Insert clip art and pictures into slides
custom slide shows from a single presentation. In this workshop,
• Apply simple layouts and transition effects
you will:
• Save and print a presentation
• Understand you should use slide masters when creating Length: 2 hours
a presentation
• Set up a slide show so that you can use the same content but with
Screen capture
different customized backgrounds for different audiences
• Insert and customize a new set of slide masters
Captivate 6: The basics
• Insert text that cannot be edited in Normal view
In this workshop, you will learn how to use one of the most popular
• Use the Custom Slide Show feature so that you can view only certain
rapid development elearning tools that is currently available. You will
slides in a presentation
create a basic screencast, complete with audio, video, transitions,
and animated effects. Before leaving, you will learn how to publish
Prerequisite: PowerPoint 2013: The basics or equivalent skills
your project so that it can be posted online. In this workshop, you will:
What you need to know:
• Begin a new Captivate project
• Create and deliver a basic presentation
• Import assets, such as images, PowerPoint slides, audio, and video
• Insert clip art and pictures into slides
• Record what you see on your screen
• Apply simple layouts and transition effects
• Publish for the web and other mobile devices
• Save and print a presentation
Length: 2 hours
Prerequisites: Windows: Basic computing skills or equivalent skills
Length: 3 hours
10
Audio & video
Digital video: Basic editing using Windows Movie Maker
Windows Movie Maker is an easy to use video editing application.
After Effects CS6: Video effects & text animation basics
While there are many other programs on the market that provide
Adobe After Effects is an animation program focused on video
more bells and whistles, in many cases, this is the only application
production which allows you to combine video and animations into a
that you will need in order to create a really great movie. This
single project and then export it into many common video formats.
application comes preinstalled on many PCs and it can be
In this workshop, participants will create a 30 second movie trailer
downloaded for free if you don’t already have it. In this 90 minute
in After Effects. While working, participants will spend time learning
workshop, participants will use Windows Movie Maker as they learn
how to work efficiently in the After Effects interface, as well as
basic video editing techniques. Since most video editing packages
learning how the basic animation and effects tools work. Eventually,
have a similar look and feel, this workshop also serves as a good
we will combine all of these skills to build a more complex set of
introduction to other, more complex programs.
animations. In this workshop, you will:
• Learn the After Effects interface
In this workshop you will learn to use Windows Movie Maker version
• Learn how to create animations in After Effects
2.6 which is available for free download from the Internet. This
• Learn how to use Effects in After Effects
version is only compatible with Windows 7 and later. If you are
• Create lower third text over video
running an older operating system, such as Windows XP, you can
• Combine animations with video
download and use version 2.1 instead. In this workshop, you will:
• Add audio to an animation
• Become familiar with the Windows Movie Maker user interface
• Link After Effects compositions and Premiere Pro sequences
• Learn to add titles and credits
• Learn to import video clips
Prerequisite: Premiere Pro CS6: The basics or equivalent skills
• Use the Storyboard view and the Timeline view
What you need to know:
• Learn to trim, split, and move clips
• Use the mouse and keyboard proficiently
• Narrate the title
• Understand video formats
• Add transitions and special effects
• Understand video resolution
• Work with a timeline
Prerequisite: Windows: Basic computing skills
Length: 3.5 hours
What you need to know:
• Open and close windows and files
• Switch between applications and documents
Digital video: An introduction
• Use a file menu, standard toolbar, and other drop-down menus
This short, lecture-based workshop provides an overview of the
• Navigate a web page
basic concepts and terminology that a person needs to be familiar
• Perform basic computing tasks
with as they begin to work with video. If you are using a digital video
Length: 2 hours
camera or video editing software for the first time, this workshop is a
must! In this workshop, you will:
• Learn about video cameras and video equipment
• Become familiar with basic video concepts and terminology
• Find out how to transfer video footage to a computer
• Learn about video formats and compression
• Learn some basic guidelines for creating compelling video
Prerequisite: Windows: Basic computing skills or equivalent skills
What you need to know:
• Open and close windows files
• Switch between applications and documents
• Use a file menu, standard toolbar, and other drop-down menus
• Navigate a web page
• Perform basic computing tasks
Length: 2 hours
11
Web design
Premiere Pro CS6: The basics
Premiere Pro is a part of the Adobe CS6 Production Premium Suite.
It is a full-featured video editing application that is used by some
professional videographers. During this workshop, participants will
become familiar with the Premiere Pro interface, and will learn how
to import audio, video, and graphic files into a presentation. They will
learn different methods for trimming clips, working with still images,
and creating titles and text overlays. At the end of the workshop,
participants will explore Premiere’s publishing options and will use
Adobe Media Encoder to convert their video masterpiece into a
movie that can be posted on the web. In this workshop, you will:
Dreamweaver CS6: The basics
Dreamweaver is used to create web pages and manage websites;
perfect for beginners, it allows you to design pages graphically
without having to write X. This workshop is intended for people
with little or no experience using Dreamweaver, and it covers how
to build basic web pages that include text, images and links. In this
workshop, you will:
• Design a CSS based website
• Explore page layout options
• Become familiar with the Adobe Premiere Pro CS6 interface
• Insert graphics
• Select settings and adjust preferences
• Re-use content from external text files
• Learn how to import footage and other assets
• Work with CSS styles
• Trim, cut, and move clips
• Insert links
• Add titles and transitions
• Upload a completed site to a web server
• Work with still images and audio
• Publish a project
Prerequisite: XHTML: The basics or equivalent skills
What you need to know:
Prerequisite: Digital video: An introduction or equivalent skills
What you need to know:
• Navigate a web page
• Understand basic video concepts and terminology
Length: 3 hours
• Understand XHTML code
• Use Windows Movie Maker or another video editing application to
perform simple edits
Length: 3.5 hours
Dreamweaver CS6: Using templates to standardize your
site
Audacity: The basics
This workshop is intended for participants with experience using
Audacity is a free digital audio recording and editing program, which
when used in conjunction with the free LAME encoder application,
enables you to export your recordings into an MP3 format. In this
workshop, you will learn how to use Audacity to create a simple
audio file that includes voice narration and music. You will learn how
to record audio, edit it to remove unwanted content, mix audio with
fades and volume adjustments, and export your finished product as
an MP3 file. In this workshop, you will:
Dreamweaver and familiarity with markup code (HTML or XHTML).
It explores how to use Dreamweaver templates to make controlling
and updating page content a snap. In this workshop, you will:
• Implement templates to reduce website maintenance time
• Create editable regions
• Create optional regions
• Create nested templates
• Make attributes editable
• Configure computers for sound recording
• Record narration
Prerequisite: Dreamweaver CS6: The basics or equivalent skills
• Edit an audio track and delete unwanted audio
• Add prerecorded music to an audio clip
What you need to know:
• Mix multiple audio tracks
• Understand using CSS to handle layout
• Create fades
• Understand and insert links
• Export your finished recording as an mp3
• Create and employ CSS in external style sheets
• Understand XHTML code
Length: 75 minutes
Prerequisite: Windows: Basic computing skills or equivalent skills
What you need to know
• Use the mouse
• Work with windows and menus
• Save, copy, and organize your documents
Length: 60 minutes
12
Website development project lab
In this 3-hour lab session, you will integrate the skills you learned
HTML5: Using geolocation, local storage, canvas,
and video
in Dreamweaver and Fireworks to independently create a design
HTML5 is the future of the web. We will discuss what’s available
project. You will work with predetermined materials and your own
now and what can be expected in the future including looking at
design ideas. In this workshop, you will:
examples from around the web. This session will discuss basic
• Gain additional practice and experience working with web design HTML5 and some JavaScript. Topics include embedding video, using
geolocation, and canvas. In this workshop, you will:
and development tools
• Get reinforcement on concepts and skills learned in • Use geolocation in a web application
the prerequisite workshops
• Store values locally using Local Storage
• Use an individualized, creative, and explorative approach to
• Draw items on a Canvas
Web design
• Embed video into a web page
• Gain experience integrating Adobe Dreamweaver and Fireworks
• Understand the different codecs that are used in HTML5 for video
Prerequisites: Fireworks CS6: The basics; Dreamweaver CS6: The
Prerequisite: HTML5: Using Semantic Markup or equivalent skills
basics; Dreamweaver CS6: Using Templates to Standardize your
Length: 3 hours
Site What you need to know:
• Build a site using HTML, CSS, and Dreamweaver
Length: 3 hours
Illustrator CS6: The basics
Note: You can only register for this workshop as part of the Website
In this workshop, participants will learn how the basics of Adobe
Development Fundamentals IT Training Certificate Series.
Illustrator, a drawing program. Participants will spend time building basic
skills like drawing with brushes, creating and combining shapes, and
using gradients, and will then use those skills to create a professional
HTML5 and CSS: The basics
looking business logo. In this workshop, you will:
HTML and CSS are languages used in order to build web pages. This
• Explore the shape creation tools
is a beginner’s workshop on learning how to read and code these
• Combine and alter shapes
languages. Participants will learn how to structure content for the
• Create gradients
web, incorporate graphics, and style a web page. In this workshop,
• Understand the different selection tools
you will:
• Understand stroke and fill
• Structure text and image content for the web using HTML5
• Create a professional looking logo
• Learn semantic markup new to the HTML standard
• Style a web page using Cascading Style Sheets (CSS)
Prerequisite: Windows: Basic computing skills or equivalent skills
• Create hyperlinks to link to other pages
Length: 3 hours
• Learn the box model for basic layout
• Make web pages accessible and well-formed
Photoshop CS6: The basics
Prerequisite: XHTML: The basics or equivalent skills
In this workshop, participants will learn the basics of Adobe
What you need to know:
Photoshop, the premiere image editing application. Particpants will
• Type well
learn how to retouch a photo while building skills that will help them
• save and organize files
go further with the application. Participants will also work on a more
Length: 3.5 hours
complex photo compositing project, and learn about layers, selections,
healing tools, and image adjustments. In this workshop, you will:
• Understand the Photoshop interface
• Retouch and blend two images
• Understand layers
• Use effects and filters
• Use the History Panel
• Save a file for the web
• Use basic healing tools
Prerequisite: Windows: Basic computing skills or equivalent skills
What you need to know:
• Use the mouse and keyboard proficiently
Length: 3 hours
13
Illustrator CS6: Creating graphics for the web
User-centered web design & usability testing
This workshop introduces the different tools Illustrator offers to
Intended for anyone involved in planning, designing, or creating
create web graphics. What you’ll learn:
a medium to large website. Uses lecture, video, and discussion to
• Learn the difference between vector and bitmap graphics
introduce the importance of incorporating user-centered design
• Create graphics for a website, including a banner, buttons, principles and usability testing in web design and implementation.
In this workshop, you will:
and a background
• Import and manipulate graphics in Illustrator
• Explore user-centered web design
• Choose and apply filters to objects
• See and discuss examples of usability testing
• Optimize images for the web
• Learn about ADA web guidelines
• Learn a four-part website design method
Prerequisite: Windows: Illustrator CS6: The basics or equivalent skills
• Examine specific guidelines and considerations at each stage
What you need to know:
• Learn where to find resources for Web design
• Navigate the Illustrator interface
• Edit and manipulate art elements
Prerequisite: XHTML: The basics or equivalent skills
• Work with shapes and text in Illustrator
What you need to know:
Length: 3 hours
• Understand basic HTML code
• Understand Web colors and graphic formats
• Monitor image sizes and Web page load time
Fireworks CS6: The basics
• Encode Web pages for text-only Web browsers
Fireworks was built from the ground up for the creation of web
Length: 3 hours
graphics. This workshop is intended for anyone who wants to
use Fireworks to create beautiful, editable graphics from scratch,
intended for use on the web. This workshop also provides basic
coverage of optimizing graphics for web distribution. In this
workshop, you will:
• Learn the difference between vector and bitmap graphics
• Create art using vector paths, strokes, fills, and Fireworks Live Effects
• Use the Pen tool to draw vector shapes and lines
• Bend text around paths
• Use Fireworks’ Live filters, such as shad-ows, bevels, and textures
• Use Fireworks’ Layers panel to control which elements obscure other elements
• Optimize and export graphics for use on the Web
Prerequisite: Windows: Basic computing skills or equivalent skills
What you need to know:
• Use the mouse
• Work with windows and menus
• Save, copy, and organize documents in a Windows or Mac
environment
Length: 3 hours
14
IU systems
Academic systems
OneNote 2013: An introduction
Microsoft OneNote is a digital notebook. It allows you store and
Oncourse basics for students
organize your notes and other information. It provides tools for
This workshop introduces students to Oncourse, giving a
searching notes, managing multiple notebooks and allows users to
general overview of the online environment and its tools.
share their notes. The IT Training Live! will cover the basics of how to
In this webinar, you will learn:
use OneNote 2013. In this webinar, you will learn:
• How to log in to Oncourse
• How to create notebooks
• How to customize class tab order
• How to insert notes, images, web content, and other media
• How to save and store files
• How to search for content
• How to customize notification preferences
• How to start a basic ePortfolio using Presentations
Prerequisite: Windows: Basic computing skills or equivalent skills
Length: 60 minutese
Prerequisite: Windows: Basic computing skills or
equivalent skills
Length: 60 minutes
IU eTexts: Basic skills for students
eTexts are electronic textbooks, as well as other course materials
provided by your course instructor. Learn how to use the eText
Oncourse basics for instructors
system within Oncourse to read your materials, highlight passages
This webinar provides a brief overview of some of the most
and make notes, and share these notes with other classmates.
common Oncourse activities, as well as an introduction to other
In this webinar, you will learn:
help, training, and consultation resources that are available to
• Basic navigation in eTexts
you and your students. In this webinar, you will learn:
• How to create markups
• How to post a syllabus
• How to make your notes viewable by other students
• How to post announcements and resources
• How to send course mail to students
Prerequisite: Windows: Basic computing skills or equivalent skills
• How to set up a basic gradebook
Length: 60 minutes
Prerequisite: Windows: Basic computing skills or
equivalent skills
IU eTexts: Basic skills for instructors
Length: 60 minutes
eTexts are electronic versions of textbooks, as well as other course
material that is provided and stored in digital format. Instructors can
Collaborating in Oncourse
use the eText tools to highlight selections and add notes that will be
In this webinar, we will discuss the various collaboration tools
visible to their students. Using this type of engagement increases
that are available in Oncourse. In this workshop, you will:
student interaction with your course materials. In this workshop, we
• Use messages
will learn how to navigate the eText system within Oncourse, how to
• Use forums
organize materials into stacks, and how to create markups. In this
• Use chat
webinar, you will learn:
• Basic navigation in eTexts
Prerequisite: Windows: Basic computing skills or
• How to organize materials
equivalent skills
• How to create markups
Length: 60 minutes
Prerequisite: Windows: Basic computing skills or equivalent skills
Length: 60 minutese
15
Administrative systems
ePortfolio and presentations for students
When creating your electronic Personal Development Plan, you will
Business Intelligence for report analysts
use Oncourse’s ePortfolio, or Presentations, or both. In this session,
Business Intelligence, or BI, is about getting the right information
we will learn how to navigate the ePortfolio, add material, and submit
to the right people at the right time for greater efficiency and better
material for evaluation. We will also cover basic skills for adding
decision-making. A key success factor for any organization is the
content to Presentations, to personalize your electronic portfolio,
ability to effectively use available data and to transform it into
and make it visible to others. In this webinar, you will learn:
actionable information. The new Business Intelligence system at
• How to use ePortfolio tools
Indiana University will enable decision makers to access and analyze
• How to create basic presentations in Presentations
data more efficiently. This workshop focuses on the three main tools
included in IU’s BI stack: Dashboard Designer, Report Builder, and
Prerequisite: Windows: Basic computing skills or equivalent skills
PowerPivot. Report Analysts will learn how to access and use these
What you need to know:
powerful tools. In this workshop, you will:
• How to upload files to Oncourse
• Access the BI tools at IU
Length: 60 minutese
• Select an appropriate BI tool
• Connect to a data source
• Select a dataset
ePortfolio and presentations for instructors
• Use Dashboard Designer
This workshop is geared towards instructors using ePortfolio and
• Use Report Builder
Presentations with a course. In this session, we will learn how to
• Use PowerPivot
navigate the ePortfolio, add material, and submit comments and
• Publish, save, and access reports
evaluations. We will also cover basic skills for adding content to
Presentations. In this webinar, you will learn:
Prerequisite: Windows: Basic computing skills or equivalent skills
• How to use ePortfolio tools
What you need to know:
• How to create basic presentations in Presentations
• Some previous experience working with Relational Data
• How to post comments and evaluations of student work
• Basic understanding of OLAP cubes
• Basic SQL knowledge
Prerequisite: Windows: Basic computing skills or equivalent skills
• Basic SharePoint knowledge
What you need to know:
Length: 2 days.
• How to upload files to Oncourse
Length: 60 minutes
IUIE reporting basics
This workshop is intended to be a three-hour, hands-on experience.
This course covers: assessing the IUIE, navigating in IUIE, working
with catalogs, working with report objects, using control tables,
and using the scheduling function. It is intended for staff. In this
workshop, you will learn:
• How to access IUIE through OneStart
• Basic navigation in IUIE
• How to work with catalogs
• How to work with parameters in reports
• How to run reports
• How to use control tables
• How to use the scheduling function
Prerequisite: Windows: Basic computing skills or equivalent skills
What you need to know:
• Ability to work with windows
Length: 3 hours
16
Excel 2010: Formatting & analyzing IUIE data
SharePoint 2010: Workflows with nintex
This workshop is specifically designed for any IU staff member who
In this session, participants will see how to create workflows in
uses Excel to format IUIE data. Participants will learn how to format
Nintex to automate SharePoint functionality. These workflows
text and numeric data, create and remove subtotals, convert data
are very powerful and can make business processing much
to a table, sort and filter data, automate work using macros, and
easier by automating file creating, task completion, and notifying
analyze data using pivot tables. In this workshop, you will:
stakeholders in a site. We will see how to create workflows, where to
• Format text and numeric data
create them, and create a few simple workflows and see examples of
• Use macros to automate tasks
more complex workflows. In this workshop, you will:
• Use AVERAGE, COUNTIF, and VLOOKUP functions
• Create workflows in Nintex
• Create and remove subtotals
• Explore the Nintex interface
• Work with Table features
• See how to use workflows to automate SharePoint processes
• Sort and filter data
Prerequisites: SharePoint 2010: The basics and SharePoint 2010
• Analyze data using pivot tables
Site Administration: The basics.
Prerequisite: Excel 2013: The basics or equivalent skills
What you need to know:
What you need to know:
• Create a SharePoint site
• Navigate an Excel spreadsheet
• Create libraries and lists in SharePoint
• Switch back and forth between Windows applications
Length: 3.5 hours
• Enter and edit data
• Work with basic formulas and functions
• Save and print a worksheet
SharePoint 2010 Site Administration: The basics
Length: 3 hours
Participants will continue from the skills they learned in SharePoint:
The basics. They will learn how to create and manage sites in the
IU environment, work with content types, lists and library views,
SharePoint 2010: For end users
and work with forms and web parts among other skills We will also
You can use Sharepoint to store documents and share them with
briefly discuss SharePoint security concepts, how workflows are
colleagues. In this workshop, we’ll help you get up and running with
created at IU, and list and library features. Participants will also
the Sharepoint 2013 service at IU. SharePoint is a document storage
have the opportunity to ask questions about their own SharePoint
and sharing solution in use at many businesses and IU departments.
systems. In this workshop, you will:
We’ll show you how to work in the SharePoint 2013 interface, and
• Manage lists in a site collection
get started sharing documents for yourself, and creating your own
• Manage document libraries
personal space in SharePoint. In this workshop, you will:
• Manage form libraries
• Create a SharePoint account
• Manage content types in a site collection
• Work in a departmental SharePoint site
• Work with forms
• Share documents with colleagues
• Work with web parts
• Integrate Microsoft Office with SharePoint
Prerequisite: SharePoint 2010: The basics or equivalent skills
• Edit documents with Microsoft Office web apps
What you need to know:
Prerequisite: Windows: Basic computing skills or equivalent skills
• The basics of SharePoint
What you need to know:
• How to create a custom list
• Use a web browser
• How to create a document library
Length: 1.5 hours
• How SharePoint lists are structured
• Basic SharePoint permission settings
Length: 1 day
17
SIS basics for administrators
Cascade Server: Contributors, approvers, and publishers
This course covers: How to log in via OneStart, basic SIS navigation,
This workshop teaches a content contributor, approver and/or
basic academic structure, review of FERPA and Service Indicators,
publisher how to use the authoring functions within Cascade Server.
and Bio/Demo data. This class is intended for only administrative
It covers basic content creation, editing, and publishing. Participants
staff who will be using the SIS. In this workshop, you will learn:
will learn how to create pages, use asset factories, create external
• The SIS structure
links, edit pages, manipulate workflows. In this workshop, you will:
• How to launch the SIS application
• Create content within Cascade Server
• Basic navigation in SIS menus, components and pages
• Edit content within Cascade Server
• How to find existing data using basic and advanced searches
• Use workflows within Cascade Server
• How Effective Dates work
• Publish content within Cascade Server
• How to use Action Modes to maintain data
• How to insert and delete rows of data
Prerequisite: Web publishing: An overview of tools & resources or
• How to identify FERPA
equivalent skills
• How to view Service Indicators
What you need to know:
• How to use the SIS Online Help
• Navigate a web page
• Use a word processor
Prerequisite: Windows: Basic computing skills or equivalent skills
• Publish a web document
What you need to know:
Length: 3 hours
• Ability to work with windows
Length: 3 hours
SIS Administrative, faculty and student centers
for administrators
This workshop is intended for administrative staff who have access
to a student’s biographic, demographic, and academic information. It
is also for faculty who have access to class rosters, class schedules,
and grade rosters. In addition, there will be an overview of what the
students see in the Student Center. This class will also cover assigning
and removing Service Indicators and/or Class Permissions for those
who need to do this. In this workshop, you will learn:
• Contents and uses of the various pages in the Administrative Center
including My Advisees and for individual students: The Student View,
General Information, Admission Information, Academic Information,
Advising Contacts, Academic Advisement Reports, Course History,
Grades, Transfer/Test/Other credits and unofficial transcripts
• Introduction to the Faculty Center
• Introduction to the Student Center
• Additional topics covered if needed by participants: Search/Match,
assigning and releasing Service Indicators, assigning
Class/Permissions
Prerequisite: SIS basics for administrators or equivalent skills
What you need to know:
• Ability to work with windows
Length: 3 hours
18
Cloud computing
Cascade Server: Site managers
Cascade Server is Indiana University’s Web Content Management
Cloud computing at IU—IUanyWare, Box, &
Cloud Storage
System (WCMS). Maintaining content in a WCMS doesn’t require
any knowledge of web design languages or standards. Using
In this webinar, we will discuss many different aspects of cloud
Cascade Server, a site manager can put the power of editing content
computing at Indiana University and how they interact. We will
into the hands of content experts, and focus on maintaining the
explore the IUanyWare service, how it connects with Box accounts,
structural and visual aspects of a site.
and other cloud storage options. In this webinar, you will learn:
• How to use IUanyWare applications
Cascade Server: Site Managers is a three day, eighteen hour workshop
• How to save IUanyWare documents to the cloud
that will teach an experienced web designer everything they need to
• How to connect your cloud services to IUanyWare
know to start creating a working site within Cascade Server.
• How to use Box to access files everywhere
Before coming to the training, a Site Manager should have an intimate
Prerequisite: Windows: basic computing skills or equivalent skills
working knowledge of their group’s website including a knowledge
What you need to know:
of at least XHTML, CSS, and transforming XML documents into
• How to use a web browser
XHTML using XSLT. Day one begins an in-depth look at the process of
Length: 90 minutes
converting an existing website into a Cascade Server site, beginning
from nothing and finishing with a functional, albeit rough, site. Day
two focuses on refining the site using Data Definitions, Workflows,
multiple publishing configurations (PDF, HTML, XML, RTF, etc.), as
Communication tools
well as setting up a site using pre-defined templates.
Outlook 2013: Email basics
This webinar is intended for participants who have never used
This workshop is not intended for novice web designers as a deep
Outlook Exchange before, or for those who may have used a
understanding of XHTML, CSS, and XML use and syntax is expected
previous version of Outlook or another email client in the past but
of all participants. An understanding of the structure and the
need to fill in gaps in their knowledge. The session focuses on basic
inner workings of your group’s existing website is helpful, but not
email features.
necessary. In this workshop, you will:
In this workshop, you will learn:
• Create, edit, and publish content using the WCMS
• How to navigate the Outlook 2013 interface
• Use workflows to control a series of review steps for a document
• How to compose, format, and send email
• Bring common assets into your site
• How to reply to email messages
• Use XPath to navigate through an XML document
• How to set the importance level of an email
• Transform XML data into an XHTML document
• How to use Conversation View
• Learn strategies for applying XSLT and XML to a Cascade Server site
• How to use IU’s Global Address List to find email addresses
• Convert a traditional site to a Cascade Server site
• How to use categories to organize messages
• Organize the building blocks of a site
• How to create and add an automated signature
• Learn the diverse vocabulary of Cascade Server
• How to work with email attachments
• Create and manage Asset Factories, Data Definitions, Configuration
Sets, Transports, Targets, Destinations, Blocks, Users, Groups,
Prerequisite: Windows: Basic computing skills or equivalent skills
Metadata Sets, and Publish Sets
What you need to know:
• Create and manage static assets such as images
• Use a mouse
• Create PDF, Printable, and XML versions of pages
• Cut, copy, paste, and format text
• Understand user roles
• Save and organize files
• Manage multiple users
• Identify and understand the basic parts of an email message
• Manage user groups
Length: 2 hours
• Create new site structures with the Managers’ Tools interface
• Create a site from pre-existing templates
• The organization and structure of your group’s existing website
• The business rules surrounding the publishing of content in your
group’s existing site
Prerequisite: HTML5 & CSS: The basics or equivalent skills
Length: 2 days
19
Outlook 2013: Managing your email
Outlook 2013: Calendar essentials
Is your Outlook Exchange account a mess? Are you having trouble
Microsoft Outlook contains a calendar feature that offers
finding the messages that you need? Are you spending way too
organizational tools that are easy for the novice to use, yet
much time sorting through files and folders? Have you almost
powerful enough for the busy manager. It provides us with tools for
reached your Outlook Exchange account storage quota? Are you
scheduling appointments, and allows us to share and manage many
uncertain whether or not to use the AutoArchive feature? Do you
calendars at the same time. Its innovative viewing and organizing
think about using features such as Rules and Automatic Replies
capabilities offer an effective way to simultaneously deal with
but can’t quite remember how they work? If so, attend this session
many complex timetables and agendas. This workshop will teach
and learn advanced strategies for maintaining and organizing your
participants how to get the most out of Outlook. It will cover various
Outlook Exchange account. In this workshop, you will learn:
topics, including how to make appointments in Outlook, how to
• How to tag messages for follow-up
color-code your calendar, changing preferences and views, sharing
• How to use Smart Groupings to sort messages
calendars with others, making meeting requests, and more. In this
• How to use advanced delivery options, Search folders, and
workshop, you will learn:
Quick Steps
• How to explore the Outlook 2013 calendar interface
• How to create Rules and Automatic Replies
• How to use calendar views, preferences, and defaults
• How to create personal folder files that do not count against your
• How to make appointments and meeting requests
storage quota
• How to use calendar fields
• How to delete and recover Outlook items
• How to compare calendars with others
• How AutoArchive works
• How to create and communicate with Outlook groups
• To manually archive files and folders
• How calendar sharing works with non-IU users
• How to access email via the Web (OWA)
Prerequisite: Outlook 2013: Email basics or equivalent skills
Prerequisite: Outlook 2013: Email basics or equivalent skills
What you need to know:
What you need to know:
• Work with the Outlook interface
• Compose, format, send, and reply to email messages
• Compose, format, reply to, and forward email messages
• Set the importance level of an email
• Use IU’s Global Address List
• Understand how to use different views
• Attach files to email messages
• Use IU’s Global Address List to find email addresses
Length: 2.5 hours
• Create and add an automated signature
Length: 3 hours
Unicom: Using Lync for collaboration
Now that you know how to use Lync for basic phone calling, we’ll
show you what else you can do. Learn how to share files, share
desktops, initiate conference calls from Contact Groups, create
polls, use whiteboards, participate in video calls, generate a video
bridge, and more. In this webinar, you will learn:
• How to share a file via chat
• How to create a conference call from a Contacts Group
• How to create a poll
• How to share and use whiteboards collaboratively
• How to share and manipulate desktops
• How to generate and participate in a video call
• How to create and enter an Ad Hoc Video Bridge
Prerequisite: Windows: Basic computing skills or equivalent skills
What you need to know:
• How to use Lync to make VOIP calls
Length: 90 minutes
20
Research computing & resources
Statistical applications
Introductory parallel programming for supercomputers
SAS: The basics
This workshop will introduce the concepts of threads and message
SAS is a popular and powerful application that is used for data
passing to harness multiple processors to accomplish a single task.
management and analysis in both industry and academia. This
Both a lecture and hands-on lab will be included. In this workshop,
workshop is intended for those that are new to SAS or those who
you will:
need a refresher of basic topics. Participants should have experience
• To write threads and message passing into simple programs to speed
with Microsoft Windows file structure and basic statistical concepts.
Working knowledge of Microsoft Word and Excel, as well as familiarity
up their execution.
with basic programming concepts/logic, will be very helpful.
Prerequisite: Windows: Basic computing skills or equivalent skills
Participants will learn about the SAS windowing environment, how
What you need to know:
to use the import wizard to get data into SAS, how to use DATA steps
• A basic understanding of UNIX or LINUX
to create new variables or subset a dataset, and how to use basic
• The ability to compile a basic program in that environment
PROC steps to examine data and compute descriptive statistics.
Length: 7 hours
In this workshop, you will:
• Use an existing SAS dataset through a user-defined library
• Import an Excel spreadsheet into a SAS dataset
Unix: The basics
• Create new datasets from existing datasets, subset a dataset
Unix is a popular operating system used on many central systems
• Create new variables, recode existing variables
and web servers. This workshop is intended for people who have little
• Print and sort datasets
or no experience working with Unix from the command line. It gives a
• Produce descriptive statistics for continuous and categorical data
quick overview of how Unix works, explains the directory structures,
• Produce scatterplots and bar charts
and provides guided practice with core file management commands
• Add titles and footnotes to output
and setting file permissions. File archiving, file compression, and file
• Apply formats to numeric and date variables
transfer (FTP) are also covered. In this workshop, you will:
• Manage files and directories
Prerequisite: Windows: Basic computing skills or equivalent skills
• Set file permissions
What you need to know:
• Share and copy files
• How to use Windows applications
• Archive and compress files
• Understand basic spreadsheets and statistical concepts
• Get files from another machine using FTP
• How to use basic programming concepts (i.e. ‘if-then-else’ logic)
• Get help
Length: 3 hours
Prerequisite: Windows: Basic computing skills or equivalent skills
What you need to know:
SPSS: The basics
• Use a keyboard to perform typing tasks
SPSS is a powerful statistics application. This workshop, which is
• Use a mouse
intended for people who already have a basic understanding of
Length: 3 hours
statistics, introduces SPSS for performing common basic statistical
Note: At IU, Unix is the operating system used to run research
analyses. Participants will learn the basic features of SPSS and
systems, central Web servers storage systems (MDSS), and many
how to use it to generate t-tests, linear regression, and descriptive
enterprise information systems.
statistics, and to interpret results. In this workshop, you will:
• Explore and edit data
• Conduct a T-Test
• Perform regression analysis
• Generate plots
• Use subgroups of data
• Create cross-tabulation
• Interpret the results of these procedures
Prerequisite: Windows: Basic computing skills or equivalent skills
What you need to know:
• Use Windows applications
• Understand basic spreadsheets
• Understand basic statistical concepts
21
Length: 2.5 hours
Productivity
Microsoft Office
Access 2013: Database relationships
Relationships are the fundamental building blocks of complex
Access 2013: The basics
databases and are critical to designing and working with
Access databases are ideal tools for tracking large volumes of
sophisticated databases. This workshop is intended for participants
related information and is the most commonly used desktop
who are familiar with the basic features of Access but are interested
database application in use today. Intended for people with
in learning how to define relationships in a relational database and
little or no experience using Access, this workshop introduces
how to create relational queries and forms. Creating multivalued
database terminology and relationships concepts. Participants
and lookup fields will be introduced. Challenge exercises will help
will create Access objects such as tables and queries as well as
reinforce concepts. In this workshop, you will:
simple forms and reports. In this workshop, you will:
• Explore various types of relationships and create relationships
• Create a new database
between tables
• Create, design, and modify tables to hold data
• Understand how referential integrity rules work
• Enter, edit, and delete data
• Build relational queries exploring different join types
• Import data from an Excel spreadsheet
• Create multivalued and lookup fields
• Create select queries
• Export a query to Microsoft Excel
• Import a table from an external database
• Create a relational form
• Define relationships between tables
• Import columns of data from an Excel workbook into an Access table
• Create a relational form and report
• Explore the options for cascade update related fields and cascade
delete related records
Prerequisite: Windows: Basic computing skills or
equivalent skills
Prerequisite: Access 2013: The basics or equivalent skills
What you need to know:
What you need to know:
• Use a mouse
• Understand the basic features of Access
• Save and organize files
• Create simple tables
• Use command menus
• Enter and edit data in tables
Length: 3 hours
• Create simple queries
Length: 3.5 hours
Access 2013: Queries
Queries enable you to retrieve, analyze, and manipulate data.
Access 2013: Reports
This workshop is intended for those participants who are
Reports can provide attractive and organized ways to share
interested in creating and modifying queries on related tables.
data with others. This workshop is intended for anyone who is
Various types of queries will be introduced. This workshop also
interested in learning how to create and enhance relational reports.
covers advanced query functions such as aggregate totals and
Participants will also learn how to create calculated fields, select
calculated expressions. In this workshop, you will:
sorting and grouping options, modify design, count records, create
• Build relational queries and modify query properties
mailing labels , create a personalized report, and export a report to a
• Learn to perform mathematical and text operations in a query
PDF format. In this workshop, you will:
• Create parameter queries
• Produce relational reports using the Report Wizard and Report Designer
• Summarize data using groups, calculated expressions,
• Enhance and modify report design
And aggregate totals
• Create group calculations
• Create Crosstab queries to summarize data
• Export an Access report to a PDF format
• Create and run Action queries to create, modify and delete data
• Produce mailing labels
• Use Find Duplicates and Find Unmatched queries to locate data
• Create a personalized report
Prerequisite: Access 2013: Database relationships or
Prerequisite: Access 2013: Forms or equivalent skills
equivalent skills
What you need to know:
What you need to know:
• Understand database relationships
• Create and modify tables
• Create and modify tables and queries
• Understand database relationships
• Create relational forms
Length: 3 hours
Length: 3 hours
22
Access 2013: Forms
Excel vs. Access for data storage
Relational forms tie together data from various tables into a single
Have you had trouble figuring out whether the data you need
object, facilitating data entry and editing. This workshop is intended
to manage is best tracked in Excel or Access? In this webinar
for anyone who is interested in learning how to create and enhance
presentation, IT Training staff will walk you through different types
various types of forms, such as linked and embedded forms.
of data problems to show you which kinds of data are best tracked
Command buttons, combo boxes, calculated fields, and conditional
in each program, focusing on the various kinds of problems each
formatting will all be introduced. You will then pull forms and reports
program is designed to solve. Bring the questions you have about
together into a single Navigation form. In this workshop, you will:
the data you need to track! In this webinar, you will learn:
• Create and modify a form with attachments
• The differences in the kinds of data problems Excel and Access are
• Create linked and embedded forms
designed to solve
• Save a continuous form as a report
• How to distinguish between simple and relational data problems
• Enhance forms with drop-down lists and command buttons
• How to use VLOOKUP and paste links in Excel to incorporate data
• Add calculated fields
from other spreadsheets
• Apply conditional formatting
• The basics of creating a relational database in Access
• Create a Navigation form
Prerequisite: Excel 2010: The basics or equivalent skills
Prerequisite: Access 2013: Queries or equivalent skills
Length: 60 minutes
What you need to know:
• Define relationships between tables
• Create lookup fields
Access 2013: Designing & packaging databases
• Create relational queries
This workshop introduces experienced Access users to issues
Length: 3.5 hours
relating to database design and the packaging of completed
databases for distribution to end users. The workshop begins with
an extensive lecture and discussion section on database modeling,
Access 2013: Creating a multipage form
then proceeds into a series of hands-on exercises to implement the
When a form becomes overcrowded, it can be organized into tabbed
database design and create a usable application for end users. Also
pages. Multiple-page forms can make viewing and manipulating
provides a brief introduction to database security considerations.
data easier for the user. In this 90-minute workshop, you will learn
In this workshop, you will:
how to: create multiple pages, modify tab controls, change the order
• Define database needs
of the pages, modify tab stops, and insert a Web Browser control.
• Use business rules in database design
Creating simple macros to navigate between pages will also be
• Model a database before creating it
covered. In this workshop, you will:
• Normalize imported flat file data into separate tables
• Create and edit a form with multiple tab pages
• Create and maintain complex table relationships
• Change order of the pages
• Package and password protect a database
• Insert a Web Browser control
• Compact a database
• Create a text box control in the form header
Prerequisite: Access 2013: Reports or equivalent skills
• Create macros to navigate between pages
What you need to know:
Prerequisite: Access 2013: Queries or equivalent skills
• Understand database relationships
What you need to know:
• Create and edit relational forms and reports
• Work with relational databases
• Create a form-based application
• Define relationships between tables
Length: 3 hours
• Create relational queries
Length: 90 minutes
23
Access 2013: Project Lab
Excel 2013: Charts & graphics
In this hands-on lab session, you will integrate and reinforce
This workshop will help participants develop skills required to
the skills you learned in Access 2010: The basics; Access 2010:
create effective and accurate charts. Intended for those already
Database Relationships; Access 2010: Queries; Access 2010: Forms
comfortable with using Excel, participants will create various types
and Access 2010: Reports to independently create relationships,
of charts and apply elements and formats. Chart templates and
queries, forms, and reports from an existing database. You will be
SmartArt graphics will be covered. This workshop also covers how to
given guidelines to accomplish specified tasks within the database.
insert charts into PowerPoint slides. In this workshop, you will:
In this workshop, you will:
• Understand charting terminology
• Define relationships between tables and create lookup fields
• Select appropriate chart types for a specific set of data
• Reinforce concepts and skills learned in prerequisite workshops by using
• Create basic chart types, including column, pie, line, XY Scatter,
an explorative approach to create relational queries, forms, and reports
And bar charts
• Incorporate data into an Access table from an Excel worksheet
• Add a trendline and equation to the XY Scatter chart
• Prepare mailing labels
• Apply custom formats to charts and chart elements
• Generate a personalized report
• Save and apply a chart template
• Add shapes and SmartArt graphics to charts
Prerequisites: Access 2013: The basics; Access 2013: Database
• Apply themes to charts
Relationships; Access 2013: Forms; Access 2013: Queries; Access
• Insert Excel charts into a PowerPoint presentation
2013: Reports.
What you need to know
Prerequisite: Excel 2013: The basics or equivalent skills
• Create tables and define relationships between tables
What you need to know:
• Create lookup fields
• Enter text and numbers into a worksheet
• Create relational queries, forms, and reports
• Perform calculations with formulas and functions
• Enter, edit, and delete data using tables, queries, and forms
• Format cells and worksheets
• Import data into Access tables from external sources
• Select ranges of data
Length: 3 hours
Length: 3 hours
Excel 2013: The basics
Excel 2013: Basic automation using macros
Excel is the most-used spreadsheet and analysis application today.
Macros enable you to automate your work by recording a sequence
This workshop introduces basic Excel features such as entering
of commands into a single action. In this workshop, participants will
various types of data, working with formulas and functions, and
explore how to record and edit macros in Excel, how to make them
creating a simple chart. Formatting a worksheet and importing
easily available, and how to share their recorded macros with other
data are also covered. Although this workshop is intended for the
Excel users.In this workshop, you will:
spreadsheet novice, participants with some previous spreadsheet
• Create simple macros to automate complex actions
experience may gain a better understanding and learn some new
• Learn about macro security issues
tricks to increase their efficiency in using Excel. In this workshop,
• Assign a macro to the Quick Access toolbar and a keyboard shortcut
you will:
• Edit macros
• Become familiar with spreadsheet terminology
• Make macros available to other workbooks and users
• Enter various types of data into a worksheet
• Work with formulas and functions
Prerequisite: Excel 2013: Data management or equivalent skills
• Create a simple chart
What you need to know:
• Import text-delimited data into Excel
• Create and rename subtotals
• Format cells and ranges
• Enter data into cells
• Create named ranges and use them in formulas
• Use built-in functions
• Customize printouts
• Sort and filter lists
Length: 90 minutes
Prerequisite: Windows: Basic computing skills or equivalent skills
What you need to know:
• Use a mouse
• Open and close windows
• Open and save files
• Switch between applications
Length: 3 hours
24
Excel 2013: Data management
Excel 2013: Managing & analyzing data
Learn how to use lists to extract and manipulate data. Participants
Organizing and analyzing data can be made much quicker and
will explore Excel’s table-related features in this workshop, as well
easier in Excel by working with Excel’s table feature. This 50-minute
as creating custom lists, validating data entry, sorting and filtering
workshop provides some simple techniques in analyzing data, such
data, creating and removing subtotals, and recording a macro.
as inserting subtotals, creating tables and pivot tables, and sorting
Participants will also learn how to work with multiple worksheets
or filtering data. In this webinar, you will learn:
and how to save a workspace. This workshop also introduces pivot
• How to create, replace, and remove subtotals
tables. In this workshop, you will:
• How to convert data to a table
• Specify data validation criteria
• How to work with table features
• Separate and concatenate text strings
• How to sort and filter data
• Record and use a macro
• How to create a simple pivot table
• Protect a worksheet
• Work with custom lists
Prerequisite: Excel 2013: The basics or equivalent skills
• Convert data to a table and work with table features
What you need to know:
• Sort and filter data
• Understand spreadsheet terminology
• Create and remove subtotals
• Create basic formulas and functions
• Create a pivot table
• Enter text or numeric data
• Link data between worksheets
Length: 50 minutes
• Work with multiple worksheets
• Compare workbooks
Excel 2013: Analyzing data with pivot tables
Prerequisite: Excel 2013: The basics or equivalent skills
Discover how pivot tables can make work tasks easier and how
What you need to know:
they can be useful in analyzing data. In this workshop, participants
• Understand spreadsheet terminology
will learn how to create, format, and modify pivot tables, perform
• Create and modify Excel spreadsheets
various summary techniques when displaying data, and how to
• Enter text or numeric data and formulas or functions
create pivot charts. This workshop will also explore more advanced
• Create named ranges
techniques such as how to group items in pivot tables and how to
• Format worksheets
create calculated fields. The slicer tool will also be introduced.
• Create simple charts
In this workshop: you will:
Length: 3 hours
• Create, modify, and format pivot tables
• Use summary functions and customized calculations
• Group numbers and dates
Excel 2013: Using pivot tables & slicer for data analysis
• Create filters and slicers
Pivot tables are very useful in summarizing and analyzing large
• Link and update pivot tables
datasets. This 50-minute workshop will show you how to quickly
• Create pivot charts
create and modify a pivot table and will also introduce the slicer tool
in Excel, which provides buttons for quick filtering.In this webinar,
Prerequisite: Excel 2013: The basics or equivalent skills
you will learn:
What you need to know:
• How to create pivot tables
• Navigate an Excel spreadsheet
• How to add filters to view data
• Create basic formulas
• How to group and sort within a pivot table
• Work with subtotals
• How to use the pivot table slicer
• Sort and filter data
• Work with tables
Prerequisite: Excel 2013: The basics or equivalent skills
• Manage named ranges
What you need to know:
Length: 3 hours
• Enter text or numeric data
• Create simple formulas and functions
• Create named ranges
Length: 50 minutes
25
Excel 2013: Using VLOOKUP & conditional functions
Excel 2013: What-if analysis & named scenarios
This workshop will explore arrays and conditional functions used to
This workshop introduces a number of tools that will allow
summarize or count data with certain criteria. Discover how to use
participants to develop what-if models or predict future trends in
IF and Nested IF functions to test for specific conditions and how
Excel. Discover how to analyze complex data by using data tables,
to apply different types of conditional formats. Participants will also
Goal Seek, and Solver. Participants will use the Scenario Manager
explore various techniques to look up values in a range of data using
feature, which makes automating what-if models easy by storing
VLOOKUP. Challenge exercises will be provided for reinforcement.
and comparing named data scenarios. Summary reports will be
In this workshop, you will:
generated to see the effects of these various combinations of input
• Perform calculations using array formulas
values. In this workshop, you will:
• Create IF and nested IF functions
• Create a simple array
• Use conditional functions to summarize or count data
• Create one- and two-input tables
• Use the CONCATENATE function to join text
• Use the Goal Seek tool
• Look up data using VLOOKUP
• Create, modify, and recall scenarios using the Scenario Manager and
• Apply different types of conditional formatting
generate summary reports
Prerequisite: Excel 2013: Data management or equivalent skills
Prerequisite: Excel 2013: Data management or equivalent skills
What you need to know:
What you need to know:
• Create and manage named ranges
• Create and manage named ranges
• Create formulas and functions
• Create formulas and functions
• Create and apply validation criteria
• Work with table features
• Work with tables
Length: 90 minutes
• Sort and filter data
Length: 3 hours
Excel 2013: Statistical features
While Excel’s statistics capabilities are not as refined as those
Excel 2013: Advanced macros & user-defined functions
of dedicated statistics applications like SPSS, it can be used to
Macros combine a sequence of commands into a single action and
perform many common statistical analyses. This workshop is
user-defined functions are used to perform complex calculations
intended for participants who are already comfortable using Excel
that can be launched from a single function name. In this workshop,
and who have a familiarity with statistical concepts and terminology,
participants will learn how to use advanced macro capabilities to
and would like to learn how to perform statistical analyses in
automate complex workflows and how to write and assign user-
Excel. Participants will learn how to perform a variety of statistical
defined functions. Participants will incorporate decision making
procedures in Excel using the function wizard and add-in modules,
logic and repeating actions into their macros and add to Excel’s
and how to interpret the results. In this workshop, you will:
default function library by creating their own functions. In this
• Find the mean for a range of data
workshop, you will:
• Find the standard deviation of a variable
• Run macros when files open
• Generate a pivot table
• Add dialog and input boxes to macros
• Find the correlation among several variables
• Create macros that can make decisions
• Perform simple regressions and t-tests
• Create user-defined functions to perform complex calculations
• Interpret the results of these procedures
• Use user-defined functions in an Excel worksheet
• Learn basic Visual Basic for Applications programming concepts
Prerequisite: Excel 2013: The basics or equivalent skills
What you need to know:
Prerequisite: Excel 2013: Basic automation using macros or
• Read a file into Excel
equivalent skills
• Copy, paste, and hide columns
What you need to know:
• Switch from one worksheet to another
• Record basic macros
• Understand basic statistical concepts
• Edit basic macros using the Visual Basic Editor
Length: 3 hours
• Use the Personal Macro Workbook to store macros
Length: 3.5 hours
Note: This workshop will teach the basics of programming in Visual
Basic for Applications (VBA) as it relates to Excel, but no prior
programming experience is required.
26
Excel 2010: Formatting & analyzing IUIE data
Outlook 2013: Email basics
This workshop is specifically designed for any IU staff member who
This webinar is intended for participants who have never used
uses Excel to format IUIE data. Participants will learn how to format
Outlook Exchange before, or for those who may have used a
text and numeric data, create and remove subtotals, convert data
previous version of Outlook or another email client in the past but
to a table, sort and filter data, automate work using macros, and
need to fill in gaps in their knowledge. The session focuses on basic
analyze data using pivot tables. In this workshop, you will:
email features. In this workshop, you will learn:
• Format text and numeric data
• How to navigate the Outlook 2013 interface
• Use macros to automate tasks
• How to compose, format, and send email
• Use AVERAGE, COUNTIF, and VLOOKUP functions
• How to reply to email messages
• Create and remove subtotals
• How to set the importance level of an email
• Work with Table features
• How to use Conversation View
• Sort and filter data
• How to use IU’s Global Address List to find email addresses
• Analyze data using pivot tables
• How to use categories to organize messages
• How to create and add an automated signature
Prerequisite: Excel 2013: The basics or equivalent skills
• How to work with email attachments
What you need to know:
• Navigate an Excel spreadsheet
Prerequisite: Windows: Basic computing skills or equivalent skills
• Switch back and forth between Windows applications
What you need to know:
• Enter and edit data
• Use a mouse
• Work with basic formulas and functions
• Cut, copy, paste, and format text
• Save and print a worksheet
• Save and organize files
Length: 3 hours
• Identify and understand the basic parts of an email message
Length: 2 hours
Outlook 2013: Managing your email
Is your Outlook Exchange account a mess? Are you having trouble
Outlook 2013: Calendar essentials
finding the messages that you need? Are you spending way too
Microsoft Outlook contains a calendar feature that offers
much time sorting through files and folders? Have you almost
organizational tools that are easy for the novice to use, yet powerful
reached your Outlook Exchange account storage quota? Are you
enough for the busy manager. It provides us with tools for scheduling
uncertain whether or not to use the AutoArchive feature? Do you
appointments, and allows us to share and manage many calendars
think about using features such as Rules and Automatic Replies
at the same time. Its innovative viewing and organizing capabilities
but can’t quite remember how they work? If so, attend this session
offer an effective way to simultaneously deal with many complex
and learn advanced strategies for maintaining and organizing your
timetables and agendas. This workshop will teach participants how to
Outlook Exchange account. In this workshop, you will learn:
get the most out of Outlook. It will cover various topics, including how
• How to tag messages for follow-up
to make appointments in Outlook, how to color-code your calendar,
• How to use Smart Groupings to sort messages
changing preferences and views, sharing calendars with others,
• How to use advanced delivery options, Search folders,
making meeting requests, and more. In this workshop, you will learn:
• How to explore the Outlook 2013 calendar interface
And Quick Steps
• How to create Rules and Automatic Replies
• How to use calendar views, preferences, and defaults
• How to create personal folder files that do not count against your
• How to make appointments and meeting requests
• How to use calendar fields
storage quota
• How to delete and recover Outlook items
• How to compare calendars with others
• How AutoArchive works
• How to create and communicate with Outlook groups
• To manually archive files and folders
• How calendar sharing works with non-IU users
• How to access email via the Web (OWA)
Prerequisite: Outlook 2013: Email basics or equivalent skills
Prerequisite: Outlook 2013: Email basics or equivalent skills
What you need to know:
What you need to know:
• Work with the Outlook interface
• Compose, format, send, and reply to email messages
• Compose, format, reply to, and forward email messages
• Set the importance level of an email
• Use IU’s Global Address List
• Understand how to use different views
• Attach files to email messages
• Use IU’s Global Address List to find email addresses
Length: 2.5 hours
• Create and add an automated signature
Length: 3 hours
27
PowerPoint 2013: The basics
PowerPoint 2013: Slide masters
PowerPoint is the most popular and widely used presentation
In this short, fast-paced workshop, you will find out why most
software package in the world. This workshop will teach participants,
advanced PowerPoint users prefer to create their presentations
with little or no previous experience with PowerPoint, how to create
using slide masters. You will learn how slide masters can help to
and deliver a finished presentation. In this workshop, you will:
protect a slide show from being tampered with or edited, and you
• Use the PowerPoint 2013 Interface
will learn how using slide masters can save you time when editing
• Begin a new presentation
pre-existing presentations. You will also learn how you can set up
• Insert existing slides into a presentation
custom slide shows from a single presentation. In this workshop,
• Add, rearrange, and delete slides
you will:
• Apply layouts, themes, and QuickStyles
• Understand you should use slide masters when creating • Work with text and bullets
a presentation
• Insert clip art and pictures
• Set up a slide show so that you can use the same content but with
• Apply simple animations and transitions
different customized backgrounds for different audiences
• Create audience and presenter handouts
• Insert and customize a new set of slide masters
• Rehearse and deliver a presentation
• Insert text that cannot be edited in Normal view
• Use the Custom Slide Show feature so that you can view only certain
Prerequisite: Windows: Basic computing skills or equivalent skills
slides in a presentation
What you need to know:
• Use a mouse
Prerequisite: PowerPoint 2013: The basics or equivalent skills
• Work with command menus
What you need to know:
• Save and organize files
• Create and deliver a basic presentation
Length: 3.5 hours
• Insert clip art and pictures into slides
• Apply simple layouts and transition effects
• Save and print a presentation
PowerPoint 2013: Creating customized backgrounds,
graphics & animations
Length: 2 hours
Intended for users with basic PowerPoint skills who want to
short workshop will teach participants how to create customized
PowerPoint 2013: Setting up a slide show with
audio & video
backgrounds, impressive graphics and diagrams, and eye-
Go beyond the basics and add pizazz to your presentations. In this
catching WordArt. Participants will also learn how to apply custom
fast-paced workshop, you will learn how to add audio and video to a
animations to their graphics. In this workshop, you will:
slide show, and then you will edit these multimedia clips from within
• Customize a theme
the application. In this workshop, you will:
• Create customized backgrounds
• Add an audio clip to a slide
• Link and embed tables and charts
• Configure an audio file so that it will play across multiple slides
• Add hyperlinks and section breaks
• Add a video clip to a slide
• Insert and modify WordArt and SmartArt graphics
• Edit a video clip from within PowerPoint
• Apply animation to graphics
• Add a bookmark
learn how to design more visually appealing presentations, this
• Crerate triggers
Prerequisite: PowerPoint 2013: The basics or equivalent skills
• Create a link to an online video
What you need to know:
• Capture a screenshot from within PowerPoint and add it to a slide
• Create and deliver a basic presentation
• Insert clip art and pictures into slides
Prerequisite: PowerPoint 2013: The Basiscs or equivalent skills
• Apply simple layouts and transition effects
What you need to know:
• Save and print a presentation
• Create and deliver a basic presentation
Length: 2.5 hours
• Insert clip art and pictures into slides
• Apply simple layouts and transition effects
• Save and print a presentation
Length: 2 hours
28
Effectively presenting data in Office applications
Word 2013: The essentials
Once you have compiled an interesting and compelling data set,
This workshop introduces some of the more commonly used
how do you present it for maximum impact? In this webinar, you
commands and tools available in Microsoft Word. Intended for
will learn how to use Excel charts, Access reports, and PowerPoint
participants who are already comfortable with basic text editing and
to maximize the visual impact of your data and present it more
formatting, this workshop covers more advanced topics such as
effectively. You will also learn how to leverage these tools into written
using tabs, creating lists, working with headers and footers, using
reports developed in Word. In this webinar, you will:
styles, sorting text, and saving a Word document for the web. In this
• An overview of the different features and chart types available in Excel
workshop, you will:
• Charts and pivot charts
• Utilize views and styles
• How to determine which chart type best tells the story of
• Change line spacing
A specific data set
• Align text using tabs and indents
• Learn how Access reports can be used to effectively present • Sort information
complex data sets
• Format bulleted and numbered lists
• How to incorporate charts and other visual elements into PowerPoint
• Create headers and footers
• How to leverage these different resources into written reports
• Create cover pages
developed in Word
• Add bibliographies and footnotes
Length: 60 minutes
Prerequisite: Windows: Basic computing skills or equivalent skills
Length: 3 hours
Word 2013: Publishing research & longer documents
Intended for experienced users of Word who want to create long
Word 2010: Collaborative tools
documents such as research papers, team project reports, books,
Intended for anyone who is comfortable using Word and has a need
and graduate theses or dissertations. This workshop explores
to collaborate with others in writing or editing a Word document. This
the best method for structuring long documents in Word and
workshop introduces Word’s collaborative writing features that can
demonstrates how to reliably assemble long documents from
be particularly useful when working with multiple authors, but can
multiple source files. It highlights Word’s advanced publishing
also be used by a single author. With these features, multiple people
features and automated functions, so participants will also learn
can review a document and make changes or suggestions without
how to create lists of figures and captions, a table of contents and a
actually altering the original text. Also introduces how to protect
document index. In this workshop, you will:
documents from undesired changes. In this workshop, you will:
• Create and edit an outline
• View, add, edit, and delete comments
• Collapse, expand and relocate sections of an outline
• Track and review changes to a document
• Create and manage master documents
• Compare drafts of a document
• Create a table of contents in a master document
• Protect a document from undesired changes
• Create captions and lists of figures
• Combine multiple copies of an edited document
• Use advanced search options
• Use highlighting
• Format and generate an index
• Remove personal and hidden data
• Format footers in a master document
Prerequisite: Windows: Basic computing skills or equivalent skills
• Print a master document
What you need to know:
Prerequisite: Word 2013: Regaining control with AutoCorrect &
• Work with basic Word documents
Styles or equivalent skills
• Use toolbars and keyboard shortcuts
What you need to know:
• Apply basic text formatting
• Use templates
Length: 50 minutes
• Create and edit headers and footers
• Insert and edit footnotes or endnotes
• Work with multiple documents
• Create and edit styles
• Create tables of contents
• Insert and modify graphics
• Format text using Word shortcuts
Length: 3 hours
29
Word 2013: Advanced features
Word 2010: Desktop publishing
Attend this webinar and learn about some less-frequently-used
Though Word is not a robust desktop publishing application, it does
but extremely helpful features of Microsoft Word! See how to
have some advanced layout features which can be used to create
create a table of contents, work with graphics, use the spelling and
simple newsletters and brochures. This workshop is intended for
grammar check for languages other than English. Learn how to
participants who are already familiar with Word and want to learn
make autocorrect work with you, not against you. Add footnotes
its advanced layout features. Participants will learn how to use
and comments, track changes, and create simple macros to make
templates and styles in creating more polished documents, and how
repetitive tasks easy. In this workshop, you will:
to incorporate graphics, charts, and an automated table of contents
into a multi-column document. In this workshop, you will:
• Create tables of contents
• Create and use document templates
• Insert and modify graphics
• Create and edit styles
• Use spelling and grammar check in multiple languages
• Design a document layout
• Use and modify the AutoCorrect function
• Create a table of contents
• Disable Word’s automatic features
• Customize headers and footers
• Insert and edit footnotes or endnotes
• Format sections, columns and text boxes
• View, add, edit, and delete comments
• Insert and modify graphics and charts
• Track and review changes to a document editdelete
• Create and use simple macros
Prerequisite: Word: The essentials or equivalent skills
What you need to know:
Length: 1.5 hours
• Launch Windows and Word
• Navigate through a document
• Use toolbars and pop-up menus
Word 2010: Regaining control with autocorrect & styles
• Highlight, edit, and format text and paragraphs
Word often makes intrusive guesses about the way you want a
• Change margins and tab settings
document or list formatted, or automatically changes the spelling
• Save and print your document
or capitalization of words you don’t want changed. This workshop
Length: 3 hours
will help you understand how these automatic features work so you
can keep them from making these kinds of unwanted corrections.
In addition, by gaining a better understanding of these features, you
Word 2010: Mail merge
will learn how to modify them to make them work for you, thereby
In this workshop, participants will explore the tools available for
helping you improve your overall productivity in Word. Formatting
automating the creation of individually customized documents in
text consistently can be a tedious, error-prone process, too. Using
Microsoft Word. Participants will create a data file using Word, and
styles for formatting will allow you to spend less time formatting
use that data file to create a merged document of a personalized
your documents, and allow you to take advantage of Word’s other
workshop certificate. The second merged document created
automated features, such as Live Preview and automatically
will involve transferring a data document from Word to Excel,
generated tables of contents. In this workshop, you will:
modifying the data, and generating a form letter for a mass mailing.
• Use and modify the autocorrect function
Participants will then create a third merged form letter that contains
• Control AutoFormat As You Type settings
conditional merge fields, so two variations of the letter are created
• Disable Word’s automatic features
at once. The data set for this third merge will be a query from an
Access database. In this workshop, you will:
• Create, apply and modify styles to format a document
• Create a merge data file in Microsoft Word
• Use themes and building blocks
• Use Microsoft Office documents as merge data sources
• Share customized styles between documents
• Populate a document with merge fields
• Automatically generate a table of contents
• Perform a mail merge
• Create and execute conditional merges
Prerequisite: Word: The essentials or equivalent skills
• Create merges for envelopes and label
What you need to know:
• Launch Windows and Word
Prerequisite: Word: The essentials or equivalent skills
• Use toolbars and pop-up menus
What you need to know:
• Highlight, edit, and format text and paragraphs
• Create and save documents using Word
Length: 3.5 hours
• Format text
• Sort information
• Use the Task Panel
Length: 3 hours
30
Hardware
Prerequisite: Excel 2013: The basics
What you need to know:
PC Hardware: The basics
• Should have at least 12 months of cumulative experience in leading,
In this workshop, participants will get the opportunity to open a
managing, and participating in small- to medium-scale projects
computer case, and see how to perform common upgrades and
Length: 5 days
repairs, without risking their own system. Acronyms and obscure
terms are explained, and participants will be able to take out
individual components of the computer, and examine them in detail.
Microsoft Project 2010: The basics
This workshop is intended for anyone wanting to make upgrades on
Successful project management begins with a clearly defined goal
their own computers, and looking for a safe environment to practice.
and project scope. In this workshop, participants will be given a
In this workshop, you will:
sample project in which the goal and the scope of the project are
• Perform basic maintenance on a computer
already defined. Participants will enter project information given
• Replace and upgrade common computer components like RAM, hard
from the Work Breakdown Structure (WBS) in MS Project and will
drives and expansion cards
learn how to schedule and manage the project using the application.
• Understand current computer terminology
In this workshop, you will:
• Recognize common hardware problems
• Specify new project information
• Create Gantt and network charts and identify critical paths
Prerequisite: PC Hardware: The basic or equivalent skills
• Allocate resources to tasks
What you need to know
• Identify and resolve over-allocated resources
• Use a Windows-based computer
• Create and save a baseline schedule
Length: 3 hours
• Generate project reports easily
• Use tracking Gantt to update and track the project
Project management
Prerequisite: Windows: Basic computing skills or equivalent skills
CompTIA Project+
What you need to know
• Use a mouse
This five day instructor-led course is intended for individuals in various
• Work with windows and command menus
job roles who are involved in managing, leading, and participating in
• Experience or training in project management
small- to medium-scale projects. It is designed to provide you with
Length: 6 hours
the skills and knowledge to lead, manage, and be part of successful
project teams in today’s rapidly changing world. In addition, this
Note: While this workshop focuses on the use of Microsoft Project
course’s content may provide a significant part of the preparation
in managing projects, it does not teach the fundamental aspects of
for the CompTIA® Project+™ (2009 Objectives) certification exam,
project management. Participants with previous experience or training
an international, vendor-neutral certification that demonstrates
in project management will be better prepared for this workshop.
competency in Project Management. In this workshop, you will:
Note: This workshop normally includes a one hour break for lunch.
• Identify the fundamentals of project management
• Perform the pre-project setup
• Initiate a project
SharePoint
• Plan project strategies
• Develop project schedules
What SharePoint can do for you
• Plan project staffing, communications, and quality
In this session, participants will learn what SharePoint is used for
• Plan project risk management
and how they might use it in their departments. They will get an
• Plan project costs
understanding of how SharePoint is structured, and see examples of
• Plan project procurements
systems built in SharePoint. In this workshop, you will:
• Plan for change management and transitions
• Learn advantages and disadvantages of using SharePoint
• Manage project execution
• See examples of SharePoint systems
• Manage project procurement
• Learn the best way to use SharePoint in a business enviroment
• Monitor project performance
• Monitor and control project constraints
Prerequisite: Windows: Basic computing skills or equivalent skills
• Monitor project risks and procurements
Length: 1 hour
• Perform project closure
31
Statistical applications
SharePoint 2013: F or end users
You can use Sharepoint to store documents and share them with
colleagues. In this workshop, we’ll help you get up and running with
the Sharepoint 2013 service at IU. SharePoint is a document storage
and sharing solution in use at many businesses and IU departments.
We’ll show you how to work in the SharePoint 2013 interface, and
get started sharing documents for yourself, and creating your own
personal space in SharePoint. In this workshop, you will:
SAS: The basics
SAS is a popular and powerful application that is used for data
management and analysis in both industry and academia. This
workshop is intended for those that are new to SAS or those
who need a refresher of basic topics. Participants should have
experience with Microsoft Windows file structure and basic
• Create a SharePoint account
statistical concepts. Working knowledge of Microsoft Word and
• Work in a departmental SharePoint site
EXCEL, as well as familiarity with basic programming concepts/
• Share documents with colleagues
logic, will be very helpful. Participants will learn about the SAS
• Integrate Microsoft Office with SharePoint
windowing environment, how to use the import wizard to get data
• Edit documents with Microsoft Office web apps
into SAS, how to use DATA steps to create new variables or subset
a dataset, and how to use basic PROC steps to examine data and
Prerequisite: Windows: Basic computing skills or equivalent skills
What you need to know:
compute descriptive statistics. In this workshop, you will:
• Use a web browser
• Import an Excel spreadsheet into a SAS dataset
Length: 1.5 hours
• Create new datasets from existing datasets, subset a dataset
• Use an existing SAS dataset through a user-defined library
• Create new variables, recode existing variables
• Print and sort datasets
Cloud computing
• Produce descriptive statistics for continuous and categorical data
Cloud computing at IU—IUanyWare,
Box, & Cloud Storage
• Produce scatterplots and bar charts
In this webinar, we will discuss many different aspects of cloud
computing at Indiana University and how they interact. We will
explore the IUanyWare service, how it connects with Box accounts,
and other cloud storage options. In this webinar, you will learn:
• Apply formats to numeric and date variables
• How to use IUanyWare applications
• Understand basic spreadsheets
• How to save IUanyWare documents to the cloud
• Understand basic statistical concepts
• How to connect your cloud services to IUanyWare
• How to use basic programming concepts (i.e. ‘if-then-else’ logic)
• How to use Box to access files everywhere
Length: 3 hours
• Add titles and footnotes to output
What you need to know:
• How to use Windows applications
Prerequisite: Windows: Basic computing skills or equivalent skills
Length: 90 minutes
SPSS: The basics
SPSS is a powerful statistics application. This workshop, which is
intended for people who already have a basic understanding of
Communication tools
statistics, introduces SPSS for performing common basic statistical
Unicom: Using Lync for collaboration
analyses. Participants will learn the basic features of SPSS and
Now that you know how to use Lync for basic phone calling, we’ll
show you what else you can do. Learn how to share files, share
desktops, initiate conference calls from Contact Groups, create
polls, use whiteboards, participate in video calls, generate a video
bridge, and more. In this webinar, you will learn:
how to use it to generate t-tests, linear regression, and descriptive
statistics, and to interpret results. In this workshop, you will:
• Explore and edit data
• Conduct a T-Test
• Perform regression analysis
• How to share a file via chat
• Generate plots
• How to create a conference call from a Contacts Group
• Use subgroups of data
• How to create a poll
• Create cross-tabulation
• How to share and use whiteboards collaboratively
• Interpret the results of these procedures
• How to share and manipulate desktops
• How to generate and participate in a video call
Prerequisite: Windows: Basic computing skills or equivalent skills
• How to create and enter an Ad Hoc Video Bridge
Length: 2.5 hours
Prerequisite: Windows: Basic computing skills or equivalent skills
Length: 90 minutes
32
Technical skills
EdCerts
Installing and configuring Windows Server 2012
(MOC20410)
CompTIA Project+
The course is part one, of a series of three courses, which provide
This five-day instructor-led course is intended for individuals
the skills and knowledge necessary to implement a core Windows
in various job roles who are involved in managing, leading, and
Server 2012 infrastructure in an existing enterprise environment.
participating in small- to medium-scale projects. It is designed
The three courses in total collectively cover implementing,
to provide you with the skills and knowledge to lead, manage,
managing, maintaining, and provisioning services and infrastructure
and be part of successful project teams in today’s rapidly
in a Windows Server 2012 environment. While there is some cross-
changing world. In addition, this course’s content may provide a
over in skillset and tasks across the courses, this course primarily
significant part of the preparation for the CompTIA® Project+™
covers the initial implementation and configuration of those core
(2009 Objectives) certification exam, an international, vendor-
services, such as Active Directory Domain Services, networking
neutral certification that demonstrates competency in Project
services, and initial Hyper-V configuration. In this workshop, you will:
Management. In this workshop, you will:
• Install and Configure Windows Server 2012
• Identify the fundamentals of project management
• Describe Active Directory Domain Services
• Perform the pre-project setup
• Create and Configure user, group and computer objects
• Initiate a project
• Use Windows PowerShell and other command line tools to create and
• Plan project strategies
configure AD DS objects
• Develop project schedules
• Configure IPv4 simple scenarios
• Plan project staffing, communications, and quality
• Configure IPv6 Simple scenarios
• Plan project risk management
• Configure local storage on a server
• Plan project costs
• Create and Secure file shares and shared printers
• Plan project procurements
• Create and Manage Group Policy Objects
• Plan for change management and transitions
• Secure Windows Servers by using Group Policy Objects
• Manage project execution
• Manage project procurement
Prerequisite: Configuring, managing and maintaining Windows
• Monitor project performance
Server 2008-based Server (MOC6419) and installing and
• Monitor and control project constraints
configuring Windows 7 Client (MOC6292). What you need to know:
• Monitor project risks and procurements
• A good understanding of networking fundamentals
• Perform project closure
• An understanding and experience configuring security and
administration tasks in an Enterprise environment
Prerequisite: Excel 2013: The basics
• Experience supporting or configuring Microsoft Windows Clients
What you need to know:
Length: 5 days
• Should have at least 12 months of cumulative experience in
leading, managing, and participating in small- to medium-scale
projects
Length: 5 days
33
CompTIA Network+
This is a 5-day instructor-led class where you will learn to install,
Administering system center 2012 Configuration
Manager (MOC10747)
configure, upgrade, maintain and troubleshoot servers. You will also
This course is intended for Configuration Manager Administrators
examine the server hardware and software, server IT environment,
who are responsible for configuring and managing one or
disaster recovery concepts, and learn information and skills that will
more System Center 2012 Configuration Manager sites and all
be helpful on the job. In this workshop, you will:
supporting systems. They have one to three years of experience
• Explore server hardware and software
supporting multiple desktop and server computers running the
• Use the server storage system
Windows Server operating system in medium to large enterprise
• Install server hardware
organizations. Administrators may have previous Configuration
• Configure servers
Manager experience, or be new to the product. Individuals who are
• Upgrade server components
interested in taking exam 70-243 TS: Microsoft System Center 2012
• Work with servers in an IT environment
Configuration Manager, Configuring can also attend this course.
• Troubleshoot servers
Both Configuration Manager courses will be necessary to prepare
• Explore disaster recovery concepts and methodologies
for the exam. In this workshop, you will:
• Describe the System Center 2012 Configuration Manager Set
Prerequisite: PC hardware: The basic or equivalent skills
• Discover and organize resources
What you need to know:
• Manage the Configuration Manager client
• Basic Windows skills and a fundamental understanding of computer
• Manage the inventory and software metering
concepts are required
• Query and Reporting
• Attendees should have at least one year of experience as a PC or help
• Create and deploy applications
desk technician
• Manage Software deployments by using packages and programs
Length: 5 days
• Manage application deployments
• Implement System Center 2012 EndPoint Protection
• Deploy operating systems by using System Center 2012
Configuration Manager
• Manage compliance settings on devices
Prerequisite: CompTIA Server+, configuring, managing and
maintaining Windows Server 2008-based Server (MOC6419)
What you need to know:
• A base level understanding of Systems Management
• Have a system administrator-level working knowledge of
deployment, configuration, and troubleshooting for Windows- based
personal computers
• Understand TCP/IP networking
• Work with SQL server
• Use Active Directory
• Understand basic Publick Key Infrastructure concepts
Length: 5 days
34
Administering Windows Server 2012 (MOC20411)
Prerequisite: CompTIA Server+ or Configuring, Managing and
Learn how to administer Windows Server 2012 with this five-day
Maintainining Windows Server 2008-based Server (MOC6419).
course. This course is part two in a series of three courses that
What you need to know:
provides the skills and knowledge necessary to implement a core
• Real-world hands-on experience working with Windows Server 2008,
2008 R2, and 2012
Windows Server 2012 Infrastructure in an existing enterprise
• Good knowledge and undertanding of Active Directory and
environment. The three courses collectively cover implementing,
Networking Infrastructure
managing, maintaining and provisioning services and infrastructure in
• Knowledge equivalent to that covered in the Installing and Configuring
a Windows Server 2012 environment. Although there is some cross-
Windows Server 2012 (MOC 20410)
over of skills and tasks across these courses, this course primarily
Length: 5 days
covers the administration tasks necessary to maintain a Windows
Server 2012 infrastructure such as Implementing Server Images, User
and Group management with Active Directory Domain Services(AD
DS) and Group Policy, Remote Access and Network Policies, Data
CompTIA Linux+
Security, Monitoring and Update Management.
You will acquire the skills needed to install and support one or more
distributions of the Linux operating system and learn information
This course maps directly to and is preparation material
and skills that will be helpful as you prepare for CompTIA® Linux+™
for Microsoft Certified Solutions Associate (MCSA):
Powered by LPI exams (Exam Codes: LX0–101 and LX0–102). Target
Windows Server 2012 exam “70-411: Administering
Student: This course is intended for entry-level computer support
Windows Server 2012” details of which are available at:
professionals with basic knowledge of computer hardware, software,
www.microsoft.com/learning/en/us/exam.aspx?ID=70-411
and operating systems, who wish to increase their knowledge and
understanding of Linux concepts and skills to prepare for a career
This course is intended for Information Technology (IT) Professionals
in Linux support or administration, or to prepare for CompTIA®
with hands on experience working in a Windows Server 2008 or
Linux+™ Powered by LPI exams (Exam Codes: LX0–101 and
Windows Server 2012 environment, who wish to acquire the skills
LX0–102). A typical student in the CompTIA® Linux+™ Certification
and knowledge necessary to be able to manage and maintain the
course should have at least 6 to 12 months of Linux experience.
core infrastructure required for a Windows Server 2012 environment.
This EdCert workshop uses courseware licensed from CompTIA.
The key focus for students in this course is to broaden the initial
Due to licensing restrictions, though anyone can register for this
deployment of Windows Server 2012 services and infrastructure
course, only IU students, staff and faculty are eligible for discounted
and provide the skills necessary to manage and maintain a domain
CompTIA exam vouchers upon completion of the course.
based Windows Server 2012 environment, such as user and group
Additionally, since the materials for EdCert workshops are ordered
management, network access and data security.
from a 3rd party source, you must register for EdCert workshops 3
business days in advance of the first teach date to guarantee your
Candidates would typically be System Administrators or aspiring to
seat. If you believe you are eligible but are unable to register, or if
be System Administrators. They must have at least one year hands
you have missed the cut off date and would like to register, please
on experience working in a Windows Server 2008 or Windows Server
contact our IUPUI office. In this workshop, you will:
2012 environment. Candidates must also have knowledge equivalent
• Manage user and group accounts
to that already covered in “20410A: Installing and Configuring
• Manage partitions and Linux filesystem
Windows Server 2012” course as this course will build upon that
• Work with Linux permissions and ownership
knowledge. In this workshop, you will:
• Print files
• Deploy and Maintain Server Images
• Manage packages
• Manage AD Accounts
• Install Linux
• Implement Group Policies
• Configure the GUI
• Manage systems with Group Policies
• Optimize File Services
Prerequisite: Unix: The basics or equavalent skills
• Configure Encryption and Advanced Auditing
What you need to know:
• Implement Update Management
• Basic familiar with Linux, ideally with at least 6-12 months of previous
experience
• Monitor Windows Server 2012
Length: 5 days
35
CompTIA CASP
CompTIA Healthcare IT Technician
The CompTIA Advanced Security Practitioner (CASP) Certification
The recent explosion of the use of various IT systems in the
is a vendor-neutral credential. The CASP exam is an internationally
healthcare areana presents a tremendous opportunity for IT
targeted validation of advanced-level security skills and knowledge.
professionals. Additionally the deployment and utilization of
While there is no required prerequisite, the CASP certification is
electronic record keeping sytems for use in healthcare presents both
intended to follow CompTIA Security+ or equivalent experience and
an opportunity and a challenge to everyone involved. The CompTIA
has a technical, “hands-on” focus at the enterprise level. The CASP
Healthcare IT Technician was developed as a supplement to both
exam will certify that the successful candidate has the technical
real-world experience and other IT certifications as a way for IT
knowledge and skills required to conceptualize, design, and engineer
personnel to demonstrate basic understanding of, and competency
secure solutions across complex enterprise environments.
in, essential healtcare and IT concepts and terminology and the
integration of the two realms of practice. As an IT professional,
The candidate will apply critical thinking and judgment across a
you are in a unique position to contribute to and benefit from the
broad spectrum of security disciplines to propose and implement
increasing integration of IT and healthcare systems.
solutions that map to enterprise drivers. This EdCert workshop uses
courseware licensed from CompTIA. Due to licensing restrictions,
This course will provide you with foundational knowledge that
though anyone can register for this course, only IU students, staff
is critical to your ability to take advantage of the tremendous
and faculty are eligible for discounted CompTIA exam vouchers upon
opportunity presented by the advancements in healthcare-IT
completion of the course. Additionally, since the materials for EdCert
integration. This EdCert workshop uses courseware licensed from
workshops are ordered from a 3rd party source, you must register for
CompTIA. Due to licensing restrictions, though anyone can register
EdCert workshops 3 business days in advance of the first teach date
for this course, only IU students, staff and faculty are eligible for
to guarantee your seat. If you believe you are eligible but are unable
discounted CompTIA exam vouchers upon completion of the course.
to register, or if you have missed the cut off date and would like to
Additionally, since the materials for EdCert workshops are ordered
register, please contact our IUPUI office. In this workshop, you will:
from a 3rd party source, you must register for EdCert workshops 3
• Enterprise Security covering cryptographic tools and techniques
business days in advance of the first teach date to guarantee your
• Distinguish and select among different types of virtualized, distributed
seat. If you believe you are eligible but are unable to register, or if you
have missed the cut off date and would like to register, please contact
and shared computing
• Explain security implications of enterprise storage
our IUPUI office. In this workshop, you will:
• Integrate hosts, networks, infrastructures, applications and storage
• Regulatory requirements
into secure comprehensive solutions
• Organizational behaviour
• Risk Management, Policy/Procedure and Legal - risk mitigation
• IT Operations
strategies and controls
• Medical business operations
• Explain the importance of preparing for and supporting the incident
• Security
response and recovery process
Prerequisite: Configuring, managing and maintaining Windows
• Research and Analysis - Analyze industry trends and outline potential
server 2008-based Server (MOC 6419) or installing and configuring
impact to the enterprise
• Carry out relevant analysis for the purpose of securing the enterprise
Windows 7 Client (MOC 6292) or equivalent skills
• Integration of Computing, Communications and Business Desciplines
What you need to know:
• A good understanding of networking fundamentals
Prerequisite: CompTIA Network+, CompTIA Security+, or CompTIA
• Fundamentals using Office 2010 and Office 2007
Server+ or equivalent skills
• An understanding and experience configuring security and
What you need to know:
administration tasks in an Enterprise environment
Length: 3 days
• Vendor specific tools and technologies such as: Laptops, Virtualized
appliances ( firewalls, IPS, RSA authentication) Basic Server
Length: 5 days
36
CompTIA cloud essentials
The dynamic business environment today may increase IT demands
Automating Windows server 2008 administrator with
PowerShell (MOC 6434)
tremendously. You need to meet the demands to ensure the survival
This is Microsoft Official Curriculum course 6434. This three-
of your organization in the market. Needless to say, you must make
day instructor-led course provides students with the knowledge
plans to meet the demands within limited reources of finance,
and skills to utilize Windows PowerShell for administering and
people, and technology. This is exactly what cloud computing can
automating administration of Windows Server 2008. The course
provide to your business. In this coure, you will weigh the pros and
focuses on cmdlets, script structure and flow control, language
cons of cloud computing to make effective decisions in meeting the
syntax, and implementation details of scripting administrative tasks
IT challenges. You will cover an introduction to cloud computing,
using COM, WMI, and .NET foundations. This course is intended for
assess the business value of cloud computing, the technical aspects
Windows administrators interested in automating Windows Server
and challenges of cloud computing, and an overview of ITIL and
2008 administration tasks, as well as those people looking for a
service strategy of cloud computing.
full-featured interactive command-line environment for Windows
operating systems. Windows end users or developers who need
This EdCert workshop uses courseware licensed from CompTIA.
to understand what is involved in Windows administration or
Due to licensing restrictions, though anyone can register for this
command-line environments may also find this course helpful.
course, only IU students, staff and faculty are eligible for discounted
CompTIA exam vouchers upon completion of the course.
This EdCert workshop uses courseware licensed from Microsoft.
Additionally, since the materials for EdCert workshops are ordered
Due to licensing restrictions, only technical staff (which includes
from a 3rd party source, you must register for EdCert workshops 3
LSPs and UITS staff), currently enrolled IU students, and faculty who
business days in advance of the first teach date to guarantee your
teach this topic in academic classes are eligible to register for this
seat. If you believe you are eligible but are unable to register, or if
workshop. Additionally, since the materials for EdCert workshops
you have missed the cut off date and would like to register, please
are ordered from a 3rd party source, you must register for EdCert
contact our IUPUI office. In this workshop, you will:
workshops 3 business days in advance of the first teach date to
• Learn the fundamental concepts of cloud computing
guarantee your seat. If you believe you are eligible but are unable
• Learn the business aspects and impact of cloud computing
to register, or if you have missed the cut off date and would like to
• Differentiate the types of cloud solutions and the adoption measures
register, please contact our IUPUI office. In this workshop, you will:
needed for each
• Install and launch Windows PowerShell
• Identify the technical challenges and the mitigation measures involved
• Use PowerShell scripts to automate the administration of
in cloud computing
Windows Server 2008.
• Identify the steps to successfully adopt cloud services
• Work with basic objects in Windows PowerShell, including using
• Identify the basic concepts of ITIL and describe how the ITIL framework
cmdlets, data types, variables, and fundamental object-based
is useful in the implementation of cloud computing
information models
• Identify possible risks involved in cloud computing and the risk
• Implement sequences of operations by putting them together mitigation measures.
into a pipeline
• Control the formatting of the resultant set of objects that are emitted
Prerequisite: Configuring and troubleshooting Windows server
at the end of a pipeline
2008 Active Directory Domain Services (MOC 6425) or configuring,
• Implement sequences of operations by putting them together managing and maintaining Windows server 2008-based server
into a script
(MOC 6419) or equivalent skills
• Implement flow control within scripts and define functions and filters
What you need to know:
to help modularize complex scripts
• A good understanding of networking fundamentals
• Manipulate files and registry values
• Experience implementing, managing and administering Windows
• Manage disk storage volumes, shadow copies, shared folders,
Server 2008 and Windows Server 2008 R2
Terminal Services and IIS properties using WMI in Windows
• Fundamentals using Office 2010 and Office 2007
PowerShell
• Fundamental knowledge of network design and management
Length: 2 days
Prerequisite: PC Haardware: The basics or equivalent skills
What you need to know:
• Windows Server administration
Length: 3 days
37
Troubleshooting and supporting Windows 7 in the
enterprise (MOC 6293)
Configuring, managing and maintaining Windows Server
2008-based Server (MOC 6419)
This course is designed for Information Technology (IT)
This five-day instructor-led course combines five days’ worth of
professionals who have experience with Windows XP and Windows
instructor-led training content from the Network Infrastructure
Vista who work as Windows 7 Enterprise Desktop Support
Technology Specialist, Active Directory Technology Specialist, and IT
Technicians (EDSTs) in Tier 2 support environments. The goal of
Professional Server Administrator courses of Windows Server 2008
this training is to enable these individuals to support the Windows 7
to provide students with the knowledge and skills that are required
operating system and solve technical troubleshooting problems in a
to manage accounts and resources, maintain server resources,
Windows 7 and Windows Server 2008 R2 networking environment.
monitor server performance, and safeguard data in a Microsoft
Windows Server 2008 environment.
This course helps candidates prepare for Exam 70-685, the final
requirement for the Enterprise Desktop Support Technician
This course covers the core skills required by anyone working
(EDST) professional credential. By the course’s end, students
with Windows Server 2008 Servers. This EdCert workshop uses
will have been exposed to the process of establishing and using
courseware licensed from Microsoft. Due to licensing restrictions,
a troubleshooting methodology, and the EDST job role and
only technical staff (which includes LSPs and UITS staff), currently
responsibilities. Additionally, students will be exposed to various
enrolled IU students, and faculty who teach this topic in academic
troubleshooting tools and techniques that enable them to address
classes are eligible to register for this workshop. Additionally, since
multiple Windows 7 issues in an enterprise network environment.
the materials for EdCert workshops are ordered from a 3rd party
This EdCert workshop uses courseware licensed from Microsoft.
source, you must register for EdCert workshops 3 business days in
Due to licensing restrictions, only technical staff (which includes
advance of the first teach date to guarantee your seat. If you believe
LSPs and UITS staff), currently enrolled IU students, and faculty
you are eligible but are unable to register, or if you have missed the
who teach this topic in academic classes are eligible to register for
cut off date and would like to register, please contact our IUPUI
this workshop.
office. In this workshop, you will:
• Manage a Windows 2008 Server
Additionally, since the materials for EdCert workshops are ordered
• Manage user and computer accounts
from a 3rd party source, you must register for EdCert workshops 3
• Maintain servers
business days in advance of the first teach date to guarantee your
• Work with Server 2008, backup and restore
seat. If you believe you are eligible but are unable to register, or if
• Monitor server performance
you have missed the cut off date and would like to register, please
• Manage storage technologies
contact our IUPUI office. In this workshop, you will:
• Manage DFS
• describe the processes of establishing and using a troubleshooting
Prerequisite: PC Hardware: The basics or equivalent skills
methodology, and define the EDST job role and responsibilities
• Troublehoot startup issues on a Windows 7 computer
What you need to know
• Troublehoot client-configuration issues and Group Policy object
• An understanding of security concepts and methodologies (for
(GPO) application issues
example, corporate policies)
• Troubleshoot hardware device, device driver, and performance issues
• Basic knowledge of TCP/IP
• Troublehoot network connectivity issues
• Basic knowledge of scripting tools such as Powershell and WMI
• Troubleshoot remote connectivity issues
• Work with Windows Server 2003 and Windows Server 2008
• Troubleshoot logon and resource access issue
Length: 5 days
• Troubleshoot security system issues, such as Encrypting File Systems
(EFS) BitLocker Drive Encryption, and file permissions
• Troubleshoot operating system and applications issues
Prerequisite: Installing and Configuring Windows 7 Client
(MOC 6292), PC Hardware: The basics or equivalent skills
What you need to know:
• Understand networking fundamentals, including TCP/IP and DNS
• Understand Active Directory principles and management
• Know Microsoft Windows Server 2008 fundamentals
• Know the fundamentals of using Office 2010 and Office 2007
Length: 3 days
38
Configuring and troublehooting a Windows 2008
network infrastructure (MOC 6421)
Prerequisite: PC Hardware: The basics or equivalent skills
This five-day instructor-led course provides students with the
• You must have an intermediate understanding of Windows Server
What you need to know:
knowledge and skills to configure and troubleshoot Windows Server
operating systems such as Windows Server 2003, Windows Server
2008 and Windows Server 2008 R2 SP1 Network Infrastructures.
2008 or Windows Server 2008 R2 and Windows client operating
It will cover networking technologies most commonly used with
systems such as Windows Vista or Windows 7
• You should understand how TCP/IP functions and have a basic
Windows Server 2008 and Windows Server 2008 R2 SP1 such as
DNS, DHCP, IPv4 and IPv6 network addressing, Network Policy
understanding of addressing, name resolution (Domain Name
server and Network Access Protection and configuring secure
System[DNS]/Windows Internet Name Service[WINS]) and
network access. It also covers fault tolerant storage technologies,
connection methods (wired, wireless, virtual private networks [VPN])
• You should have an awareness of security best practices such as
Network Storage and routing and remote access, monitoring and
understanding file system permissions, authentication methods,
compliance updates as well as other relevant technologies. This
workstation and server hardening methods
course also maps directly to the 70-642: TS: Windows Server 2008
Length: 5 days
Network Infrastructure, Configuring Exam.
This EdCert workshop uses courseware licensed from Microsoft.
Planning, deploying, and managing Microsoft System
Center Configuration Manager 2007 (MOC 6451)
Due to licensing restrictions, only technical staff (which includes
LSPs and UITS staff), currently enrolled IU students, and faculty who
This five-day instructor-led course provides students with the
knowledge and skills to plan, deploy, and manage Configuration
Manager 2007. The course focuses on planning and deploying sites
and clients, configuring software distribution, deploying operating
systems, and managing software updates. It also focuses on remote
tools and managing mobile devices.
teach this topic in academic classes are eligible to register for this
workshop.
Additionally, since the materials for EdCert workshops are ordered
from a 3rd party source, you must register for EdCert workshops 3
business days in advance of the first teach date to guarantee your
seat. If you believe you are eligible but are unable to register, or if
This EdCert workshop uses courseware licensed from Microsoft.
Due to licensing restrictions, only technical staff (which includes
LSPs and UITS staff), currently enrolled IU students, and faculty who
teach this topic in academic classes are eligible to register for this
workshop. Additionally, since the materials for EdCert workshops
are ordered from a 3rd party source, you must register for EdCert
workshops 3 business days in advance of the first teach date to
guarantee your seat. If you believe you are eligible but are unable
to register, or if you have missed the cut off date and would like to
register, please contact our IUPUI office. In this workshop, you will:
you have missed the cut off date and would like to register, please
contact our IUPUI office. In this workshop, you will:
• Plan and configure an IPv4 network infrastructure
• Implement DHCP within their organization
• Configure and troubleshoot DNS
• Configure, transition to, and troubleshoot IPv6
• Configure and troubleshoot Routing and Remote Access
• Install, configure, and troubleshoot the Network Policy Server
Role service
• Implement Network Access Protection
• Understand Configuration Manager and its features
• Implement security features within Windows Server 2008 and
• Install Configuration Manager
Windows Server 2008 R2, including those features that help to secure
• Prepare and deploy system center client installations
network communications
• Collect inventory and metering
• Configure and troubleshoot file and print services
• Query and report data
• Enable and configure services to optimize branch office data access
• Prepare and manage software distribution
• Control and monitor network storage
• Deploy operating systems
• Recover data on Windows Server 2008 and Windows Server
• Deploy and manage software updates
• Use remote tools and Wake on LAN features
2008 R2 server
• Maintain and troubleshoot Configuration Manager
• Monitor Windows Server 2008 and Windows Server R2 network
infrastructure services
39
Prerequisite: Configuring, managing and maintaining Windows
Server 2008-based Server (MOC 6419) or PC hardware: The basics
or equivalent skills
What you need to know:
This EdCert workshop uses courseware licensed from Microsoft.
• A base-level understanding of Systems Management Server 2003
workshop. Additionally, since the materials for EdCert workshops
• Have a system Administrator–level working knowledge of
are ordered from a 3rd party source, you must register for EdCert
Due to licensing restrictions, only technical staff (which includes
LSPs and UITS staff), currently enrolled IU students, and faculty who
teach this topic in academic classes are eligible to register for this
deployment, configuration, and troubleshooting for Windows-based
workshops 3 business days in advance of the first teach date to
personal computers
guarantee your seat. If you believe you are eligible but are unable
• Understand TCP/IP networking
to register, or if you have missed the cut off date and would like to
• Work with SQL Server
register, please contact our IUPUI office. In this workshop, you will:
• Use Active Directory
• Design a Windows 7 standard image
• Understand basic Public Key Infrastructure concepts
• Deploy Windows 7 using WAIK
Length: 5 days
• Deploy Windows 7 using WDS
• Deploy Windows 7 using Lite Touch
• Deploy Windows 7 using Zero Touch
• Migrate user state data with WET and USMT
Planning and Managing Windows 7 deployments
(MOC 6294)
Prerequisite: PC Hardware: The basics or equivalent skills
This five-day instructor-led course is intended for desktop
What you need to know:
administrators who want to specialize in desktop deployment,
• Perform basic Windows 7 installation
configuration, and management. In this course, students will learn
• Perform basic Windows troubleshooting
how to plan and deploy Windows 7 desktops in large organizations.
Length: 5 days
They will also learn how to design, configure and manage the
Windows 7 client environment.
Planning and implementing Windows server 2008
(MOC 6433)
This course helps students prepare for the Exam 70-686: MCITP:
Enterprise Desktop Administrator. This course is intended for
This five day course is intended for IT Professionals who are
IT Professionals who are interested in specializing in Windows 7
interested in the knowledge and skills necessary to plan and
desktop and application deployments and managing the desktop
implement a Windows Server 2008 and Windows Server 2008
environments for large organizations. People attending this training
R2 environment. It incorporates both the planning of the server
could be support technicians or currently in deployment roles and
infrastructure and key aspects of the implementation, management
are looking at taking the next step in their career or enhancing their
skills in the areas of planning and deploying Windows 7 desktops.
and maintenance of Active Directory and Network Infrastructure.
After completing this course, students will be able to:
(MCITP: Server Administrator certification). It covers the most
It is the primary training resource for Exam 70-646 preparation
important job tasks for Server Administrators who are responsible
• Prepare to deploy Windows 7 business desktops
for the planning, operations, and day-to-day maintenance of
• Assess and resolve application compatibility issues with Windows 7
Windows Server 2008 and Windows Server 2008 R2 servers in the
• Determine the most appropriate method to deploy Windows 7 based
enterprise.
on specific business requirements
• Design standard Windows 7 image
The course covers Windows server 2008, Windows Server 2008
• Deploy Windows 7 using WAIK
R2 and Windows Server 2008 R2 sp1. After completing this course,
• Deploy Windows 7 using WDS
students will be able to:
• Deploy Windows 7 using Lite Touch Installation -Deploy Windows 7
• Plan Windows Server 2008 and Windows Server 2008 R2 SP1
using Zero Touch Installation
deployments and upgrades
• Migrate user state with Windows Easy Transfer Wizard and User State
• Plan server management and delegated administration strategies
Migration Tool
• Plan for network addressing with IPv4 and IPv6 and also the
• Design, configure, and manage the Windows 7 client environment
provisioning of DNS services
• Plan and deploy applications and updates to Windows 7 client
• Plan and provision Active Directory Domain Services
computers
40
• Plan and implement Group Policy strategy
• Describe the features and functionality of active direclty • Plan and implement Active Directory Certificate Services
domain services
• Plan and provision Application servers including Web services,
• Perform secure and efficient administration of Active Directory
presentation virtualization and application virtualization
• Manage users and services accounts
• Plan and implement file and print server roles
• Manage groups
• Plan and implement secure network access policies such as VPNs,
• Manage computer accounts
Network Access Protection (NAP) and Direct Access
• Implement Group Policy Infrastructure
• Plan and provision data and storage
• Configure DNS
• Plan and implement an update management strategy using Windows
• Administer AD DS Domain Controllers
Server Update Services (WSUS)
• Plan and implement high availability
This EdCert workshop uses courseware licensed from Microsoft.
• Plan for server performance and event monitoring
Due to licensing restrictions, only technical staff (which includes
• Plan and implement a backup and recovery strategy.
LSPs and UITS staff), currently enrolled IU students, and faculty who
teach this topic in academic classes are eligible to register for this
This EdCert workshop uses courseware licensed from Microsoft.
workshop. Additionally, since the materials for EdCert workshops
Due to licensing restrictions, only technical staff (which includes
are ordered from a 3rd party source, you must register for EdCert
LSPs and UITS staff), currently enrolled IU students, and faculty who
workshops 3 business days in advance of the first teach date to
teach this topic in academic classes are eligible to register for this
guarantee your seat. If you believe you are eligible but are unable
workshop. Additionally, since the materials for EdCert workshops
to register, or if you have missed the cut off date and would like to
are ordered from a 3rd party source, you must register for EdCert
register, please contact our IUPUI office. In this workshop, you will:
workshops 3 business days in advance of the first teach date to
• Configuration of Active Directory Domain Services
guarantee your seat. If you believe you are eligible but are unable
• Group Policy strategy
to register, or if you have missed the cut off date and would like to
• Administer Active Directory Domain Services
register, please contact our IUPUI office. In this workshop, you will:
• Windows Server 2008 and 2008 R2 deployments and installations
Prerequisite: PC hardware: The basics or equivalent skills
• Plan server administration and delegation
What you need to know:
• Plan and provision Active Directory Domain Services
• Basic understanding of networking
• Plan and implement Group Policy strategy
• An awareness of security best practices
• Basic knowledge of server hardware
Prerequisite: Configuring and troublehooting a Windows 2008
• Good knowledge of Windows Client operating systems
network infrastructure (MOC 6421); Configuring, managing and
Length: 5 days
maintaining Windows Server 2008-based server (MOC 6419); PC
hardware: The basics or equivalent skills
• Implementing and contributing to server and client planning
Monitoring and maintaining a private cloud with system
center 2012 (MOC 10750)
• Day to day network infrastructure and Active Directory management
This course provides an overview of a private cloud infrastructure,
Length: 5 days
the business and technical drivers behind the implementation, and
What you need to know:
how System Center 2012 can be used to monitor and operate the
private cloud infrastructure. Students will learn how to configure
Configuring and troubleshooting Windows Server 2008
active directory domain services (MOC 642 5)
and optimize a new business unit cloud as well as how to deploy
This five-day instructor-led course provides in-depth training on
deploy a service into the cloud. Students will learn how System
implementing, configuring, managing and troubleshooting Active
Center Operations Manager is used to monitor the various services
Directory Domain Services (AD DS) in Windows Server 2008 and
that underpin the private cloud and will gain a deep insight into the
Windows Server 2008 R2 environments. It covers core AD DS
Application Performance Monitoring (APM) feature of Operations
concepts and functionality as well as implementing Group Policies,
Manager to monitor the performance and availability of an
performing backup and restore and monitoring and troubleshooting
application.
pre-packaged applications and create a new service template to
Active Directory related issues. After completing this course
students will be able to configure AD DS in their Windows Server
2008 and Windows server 2008 R2 environments. The course also
provides a direct mapping to the objective domain of the 70-640:
TS: Windows Server 2008 Active Directory, Configuring exam.
At course completion, students will be able to:
41
Monitoring and maintaining a private cloud with system
Center 2012 (cont’d)
Installing and configuring Windows server 2012
(MOC 20410)
Students will learn about the core functionality of Service Manager
The course is part one, of a series of three courses, which provide
the skills and knowledge necessary to implement a core Windows
Server 2012 infrastructure in an existing enterprise environment. The
three courses in total collectively cover implementing, managing,
maintaining, and provisioning services and infrastructure in a Windows
Server 2012 environment. While there is some cross-over in skillset
and tasks across the courses, this course primarily covers the initial
implementation and configuration of those core services, such as
Active Directory Domain Services, networking services, and initial
Hyper-V configuration.
and learn how to create and manage change requests, incidents,
and release records as well as the security model behind Service
Manager. Students will also learn about problem management and
how to use it within a service management framework using Service
Manager. They will perform custom event monitoring in Operations
Manager and then use it to identify and route incidents and
problems to Service Manager, providing automatic incident creation,
remediation and change requests. Students will learn how to
provide automated self service provisioning and how to protect and
recover the resources in the private cloud. Students will learn how
This EdCert workshop uses courseware licensed from Microsoft.
This EdCert workshop uses courseware licensed from Microsoft. Due
to licensing restrictions, only technical staff (which includes LSPs and
UITS staff), currently enrolled IU students, and faculty who teach this
topic in academic classes are eligible to register for this workshop.
Additionally, since the materials for EdCert workshops are ordered
from a 3rd party source, you must register for EdCert workshops 3
business days in advance of the first teach date to guarantee your
seat. If you believe you are eligible but are unable to register, or if you
have missed the cut off date and would like to register, please contact
our IUPUI office. In this workshop, you will:
Due to licensing restrictions, only technical staff (which includes
• Install and Configure Windows Server 2012
to implement IT Governance, Risk Management, and Compliance
(GRC) in a private cloud. They will configure the environment to
verify whether key private cloud infrastructure is correctly patched
and updated, and will check for compliance across key Service
Components and remediate non-compliant items. Students will
learn how to provide surfacing service and performance-related
data and how to optimize Cloud Resources.
• Describe Active Directory Domain Services
LSPs and UITS staff), currently enrolled IU students, and faculty who
• Create and Configure user, group and computer objects
teach this topic in academic classes are eligible to register for this
• Use Windows PowerShell and other command line tools to create
workshop. Additionally, since the materials for EdCert workshops
And configure AD DS objects
are ordered from a 3rd party source, you must register for EdCert
• Configure IPv4 simple scenarios
workshops 3 business days in advance of the first teach date to
• Configure IPv6 Simple scenarios
guarantee your seat. If you believe you are eligible but are unable
• Configure local storage on a server
to register, or if you have missed the cut off date and would like to
• Create and Secure file shares and shared printers
register, please contact our IUPUI office. In this workshop, you will:
• Create and Manage Group Policy Objects
• Configure Data Center Process Automation - Implement Workflows -
• Secure Windows Servers by using Group Policy Objects
Implement Service Offerings
• Deploy Resource Monitoring - Deploy end-to-end monitoring -
Prerequisite: Configuring, managing and aintaining Windows server
2008-based Server (MOC 6419), Installing and configuring Windows 7
Client (MOC 6292), or equivalent skills
What you need to know:
Configure end-to-end monitoring - Create monitoring reports and
dashboards
• Monitor Resources - Monitor Network Devices - Monitor Servers -
• A good understanding of networking fundamentals
Monitor Virtualization layer - Monitor applicaiton health
• An understanding and experience configuring security and
• Configure and Maintain Service Manager - Implement service level
administration tasks in an Enterprise environment
management - Manage problems and incidents - cloud resources
• Manage Configuration and Protection
• Experience supporting or configuring Microsoft Windows Clients
Prerequisite: Administering System Center 2012 Configuration
Manager (MOC 10747) or equivalent skills
What you need to know:
Configuring Windows 8 (MOC 20687)
• Windows Server 2008 R2 experience
This course provides students hands-on experience with Windows
• Active Directory Domain Services (AD DS) knowledge
8. It provides guidance on installing, upgrading, and licensing for
• Networking fundamentals, including TCP/IP, DNS
Windows 8. Students will learn how to manage storage by creating
• Working knowledge of previous versions of System Center Products
simple, spanned, and striped volumes, and how to optimize file-system
• Knowledge of configuration of Microsoft SharePoint
performance. Additionally, they will learn how to manage available disk
• Hyper-V Knowledge
space by using quotas. Students will work with Windows tools and
• Knowledge of Data Center management processes
services to determine the source of performance and reliability issues,
Length: 5 days
Length: 5 days
and to troubleshoot these issues.
42
Upgrading your skills to MCSA Windows 2012
(MOC 20417)
This course describes how to configure networking to include IPv4,
IPv6, connect to wireless networks, and use the networking features
included in Windows 8 to troubleshoot networking issues. Students
This five day course will cover new features and functionality
will also learn preventive measures and tools that work together
in Windows Server 2012 around Management, Networking
to protect their computers from security threats. The course then
Infrastructure, Storage, Access Control, Hyper-V, High Availability,
covers the features related to file and folder management, which
and Identity Federation. Specific technologies covered will include
include setting permissions, file/folder compression, and configuring
Dynamic Access Control(DAC), High Availability, Failover Clustering,
shared folders. Students will also learn about installing and managing
Microsoft Online Backup and changes with Active Directory, Hyper-V
printers. Additionally, the course provides an overview of the SkyDrive
and Active Directory Federation Services (ADFS). It is not a Product
functionality, and describes the procedures to install and configure
Upgrade course, detailing the considerations for migrating and
applications, including Windows Store apps. The course also examines
upgrading your specific environment to Windows Server 2012.
the fundamentals of working with virtual machines in the Client
Rather, it will update your skills to Windows Server 2012. This course
Hyper-V environment in Windows 8. Students will learn about features
is also preparation material, and maps directly to, the Exam 70-417:
such as Virtual Private Networks (VPNs) and DirectAccess, which
Upgrading Your Skills to MCSA Windows Server 2012.
provide mobile users access to internal resources when the users are
out of the office.
This course is intended for Information Technology (IT)
professionals who are already experienced Windows Server 2008
Throughout the course, students will use Windows PowerShell 3.0, and
or Windows Server 2008 R2 Server Administrators, carrying out
its graphical user interface (GUI) to configure and manage the system.
day to day implementation, management and administrative tasks,
Students will also use the scripting editor to create and examine
who want to update their skills and knowledge to Windows Server
PowerShell scripts used to manage the system. The course is also
2012. This course will also be of interest to students who hold the
intended for students who seek certification in the 70-687 Windows
MCSA: Windows Server 2008 credential, who aspire to update it to
8 Configuring exam. This EdCert workshop uses courseware licensed
the MCSA: Windows Server 2012 credential by taking the upgrade
from Microsoft. Due to licensing restrictions, only technical staff
Exam 70-417: Upgrading Your Skills to MCSA Windows Server 2012.
(which includes LSPs and UITS staff), currently enrolled IU students,
This EdCert workshop uses courseware licensed from Microsoft.
and faculty who teach this topic in academic classes are eligible to
Due to licensing restrictions, only technical staff (which includes
register for this workshop. In this workshop, you will:
LSPs and UITS staff), currently enrolled IU students, and faculty who
• Plan and perform installations of Windows 8 utilizing
teach this topic in academic classes are eligible to register for this
Different methods
workshop.
• Configure Disks, partitions, volumes and devices in a
Windows 8 system
Additionally, since the materials for EdCert workshops are ordered
• Configure network connectivity
from a 3rd party source, you must register for EdCert workshops 3
• Implement Windows 8 Technologies to secure network connections
business days in advance of the first teach date to guarantee your
• Share files and printers
seat. If you believe you are eligible but are unable to register, or if
• Optimize and maintain Windows 8 based computers
you have missed the cut off date and would like to register, please
• Determine how to recover Windows 8 from various failures
contact our IUPUI office. In this workshop, you will:
• Install and configure Windows Server 2012
Prerequisite: Installing and Configuring Windows 7 Client
• Monitor and maintain Windows Server 2012
(MOC 6292) or equivalent skills
• Manage Windows Server 2012 with Windows Powershell 3.0
What you need to know:
• Manage storage for Windows Server 2012
• Networking fundamentals, including TCP/IP, DNS
• Implement Network Services, DirectAccess, Failover Clustering,
• Microsoft Active Directory Directory Services principles
Hyper-V, Dynamic Access Control and more
And fundamentals
• Understand basic Publick Key Infrastructure concepts
• Windows Automated Installation Kit components including Windows
PE, Windows SIM, VAMT, ImageX, USMT and DISM concepts and
fundamentals
Length: 5 days
43
Prerequisite: Configuring and troubleshooting a Windows 2008
This EdCert workshops uses courseware licensed from Microsoft.
Due to licensing restrictions, only technical staff (which includes
LSPs and UITS staff), currently enrolled IU students, and faculty who
teach this topic in academic classes are eligible to register for this
workshop. In this workshop, you will:
network infrastructure (MOC 6421); Configuring, managing and
maintaining Windows server 2008-based Server (MOC 6419);
Planning and implementing Windows server 2008 (MOC 6433), or
equivalent skillsWhat you need to know:
• Overview of System Center 2012 Configuration Manager - describes
• Experience implementing, managing and administering Windows
the infrastructure and typical deployment scenarios
Server 2008 and Windows Server 2008 R2
• Planning and deploying a Stand-Alone Primary Site
• Experience with implementing and managing, Windows networking
• Planning and configuring Role-Based Administration
technologies
• Planning and deploying a Multiple Site Hierarchy - covers deployment
• Explerience with implementing and Managing Active Directory
of CAS, Primary and Secondary sites
techonologies
• Data Replication and Content Management
• An understanding of basic virtualization and storage technologies
• Planning and completing System Center 2012 Configuration Manager
• Knowledge equivalent to the MCSA: Windows Server 2008 credential
Client Deployment
Length: 5 days
• Maintaining and monitoring System Center 2012 Configuration
Manger - inlcudes backup and recovery of a site, maintenance tasks
and monitoring
Deploying system center 2012 Configuration Manager
(MOC 10748)
• Migrating from System Center Configuration Manager 2007 to
System Center 2012
This course describes how to plan and deploy a Microsoft System
Center 2012 Configuration Manager hierarchy, including the central
administration site, one or more primary sites and secondary sites,
and all associated site systems. This course also covers migration
from System Center Configuration Manager 2007. Audience Profile.
This course is intended for:
Prerequisite: CompTIA Server+, Configuring, Managing and
Maintaining Windows Server 2008-based Server (MOC 6419) or
equivalent skills
What you need to know:
• Networking fundamentals, including TCP/IP, DNS
• Systems Engineers who need to plan a Microsoft System Center 2012
• Active Directory Domain Services (AD DS) knowledge
Configuration Manager deployment. They have three to five years of
• Windows Server Management
experience in medium to large enterprise organizations supporting
• Windows client fundamentals
multiple desktop and server computers that run Microsoft Windows.
• Deployment, configuration and troubleshooting for Windows-based
• Configuration Manager Administrators responsible for designing and
personal computers
deploying one or more System Center 2012 Configuration Manager sites
• System Administrator–level working knowledge of deployment,
and all supporting systems. They have three to five years of experience
configuration, and troubleshooting for Windows-based
in medium to large enterprise organizations supporting multiple
Personal computers
desktop and server computers that run Microsoft Windows Server.
• Microsoft SQL Server 2008 including reporting services
Individuals who are interested in taking exam 70-243: Administering
and Deploying System Center 2012 Configuration Manager, can also
attend this course. Both this course and course 10747A: Administering
System Center 2012 Configuration Manager will help to prepare for
the exam. After completing this course, students will be able to:
• Basic Public Key Infrastructure concepts
• Configuration Manager features and administrative tasks including Working with the Administrator Console, Installing clients, hardware
and software inventory, working with collections, deploying
applications, managing software updates, deploying operating systems
• Describe the Configuration Manager 2012 infrastructure and describe
• These skills and knowledge can be obtained by attending the following
typical deployment scenarios.
courses - Configuring, Managing and Maintaining Windows Server
• Plan and deploy a single primary site
2008-based Server (MOC 6419) - Fundamentals of Windows Server
• Plan and configure administrative roles
2008 (MOC 6420) - Administering System Center 2012 Configuration
• Plan and deploy a multiple-site hierarchy including the central
Manager (MOC 10747) or Planning, Deploying and Managing
administration site, primary sites, and secondary sites
Microsoft System Center Configuration Manager 2007 (MOC 6451)
• Describe replication and data types, and monitor the replication of
Length: 3 days
data throughout the hierarchy
• Use various methods to plan and deploy Configuration Manager
2012 clients
• Perform maintenance tasks and monitor site systems
• Perform migration of objects from Configuration Manager 2007 to
Configuration Manager 2012
44
Configuring advanced Windows server 2012 services
(MOC 20412)
Prerequisite: Administering Windows Server 2012 (MOC 20411),
CompTIA Server+, Installing and Configuring Windows Server 2012
Learn how to provision and configure advanced services using
(MOC 20410) or equivalent skills
Windows Server 2012 with this five-day course. This course is
What you need to know:
part three, in a series of three courses that provides the skills and
• Real world hands on experience working with Windows Server 2008,
2008 R2 and 2012
knowledge necessary to implement a core Windows Server 2012
• Knowledge equivalent to that covered in the Installing and Configuring
infrastructure in an existing enterprise environment. The three
Windows Server 2012 (MOC 20410)
courses will collectively cover implementing, managing, maintaining
• Knowledge equivalent to that covered in the Administering Windows
and provisioning services and infrastructure in a Windows Server
Server 2012 (MOC 20411)
2012 environment. Although there is some cross-over of skills and
Length: 5 days
tasks across these three courses, this course primarily covers
advanced configuration of services necessary to deploy, manage
and maintain a Windows Server 2012 infrastructure, such as
(AD DS), identity management, rights management, Federated
Automating administration with Windows PowerShell 3.0
(MOC 10961)
services, network load balancing, failover clustering, business
In this five day course you will learn to execute and monitor scripts
continuity and disaster recovery.
more efficiently through more robust session connectivity, workflow
advanced networking services, Active Directory Domain Services
capabilities, improved job scheduling, and Windows PowerShell
Web Access. Learn Windows PowerShell with greater ease through
This course maps directly to and is preparation material for
improved cmdlet discovery and simplified, consistent syntax across
Microsoft Certified Solutions Associate (MCSA):Windows Server
all cmdlets. Write Windows PowerShell scripts quicker and more
2012 exam “70-412: Configuring Advanced Windows Server 2012
intuitively through the new Integrated Scripting Environment (ISE)
Services”. This course is intended for IT professionals with hands-on
that enables script sharing, which connects IT pros to a larger
experience implementing, managing, and maintaining a Windows
Windows PowerShell user community. Learn all this and more in this
Server 2012 infrastructure in an existing enterprise environment,
five-day Microsoft Official Course in Windows PowerShell v3.0.
who wish to acquire the skills and knowledge necessary to perform
advanced management and provisioning of services within that
Audience Profile
Windows Server 2012 environment. Suitable candidates are typically
This course is intended for IT professionals already experienced
experienced system administrators who have real-world experience
in general Windows Server and Windows Client administration or
working in a Windows Server 2008, Windows server 2008 R2 or
already experienced in administering and supporting Application
Windows Server 2012 environment. The secondary audience for this
servers and services including Exchange, SharePoint, SQL etc It is
course are candidates who plan to take Exam 70-412: Configuring
broadly intended for students who want to use Windows PowerShell
Advanced Windows Server 2012 Services, or who want to acquire
to automate administrative tasks from the command line, using
the Microsoft Certified Solutions Associate (MCSA) credential.
any Microsoft or independent software vendor (ISV) product that
supports Windows PowerShell manageability.
This EdCert workshops uses courseware licensed from Microsoft.
Due to licensing restrictions, only technical staff (which includes
This course is not intended to be a scripting or programming course,
LSPs and UITS staff), currently enrolled IU students, and faculty who
and includes only basic coverage of scripting and programming
teach this topic in academic classes are eligible to register for this
topics. Students are not expected to have prior scripting or
workshop. In this workshop, you will:
programming experience, and are not expected to have prior
• Implement Advanced network services
Windows PowerShell experience. After completing this course,
• Implement Advanced file services
students will be able to:
• Implement Dynamic Access Control
• Understand the basic concepts behind Windows PowerShell
• Implement Failover clustering
• Work with the Pipeline
• Implement Network Load Balancing
• Understand How the Pipeline Works
• Implement Disaster Recovery
• Use PSProviders and PSDrives
• Format Output
• Use WMI and CIM
• Prepare for Scripting
• Moving From a Command to a Script to a Module
• Administer Remote Computers
• Put the various Windows PowerShell components together
• Use Background Jobs and Scheduled Jobs
• Use Advanced PowerShell Techniques and Profiles
45
This EdCert workshop uses courseware licensed from Microsoft.
Prerequisite: CompTIA Security+ or equivalent skills
Due to licensing restrictions, only technical staff (which includes
What you need to know:
LSPs and UITS staff), currently enrolled IU students, and faculty who
• At least two years of IT security experience and a strong working
teach this topic in academic classes are eligible to register for this
knowledge of TCP/IP
workshop. In this workshop, you will:
Length: 5 days
• Understand the basic concepts behind Windows PowerShell
Note: This class uses isolated systems and virtual networks
• Work with Pipeline
• Understand How the Pipeline Works
• Use PSProviders and PSDrives
CompTIA Security+
• Format Output
CompTIA Security+ is an international, vendor-neutral certification
• Use WMI and CIM
that demonstrates competency in:
• Prepare for Scripting
• Network Security
• Moving from Command to a Script to a Module
• Compliance and operational security
• Administer Remote Computers
• Threats and vulnerabilities
• Put the various Windows PowerShell components together
• Application, data and host security
• Use Background Jobs and Scheduled Jobs
• Access control and identity management
• Use Advanced PowerShell Techniques and Profiles
• Cryptography
Prerequisite: PC Hardware: The basics or equivalent skills
What you need to know:
CompTIA Security+ not only ensures that candidates will apply
• Windows Server Administration
knowledge of security concepts, tools and procedures to react to
Length: 5 days
security incidents, it ensures that security personnel are anticipating
security risks and guarding against them. In this workshop, you will:
• Manage network security
Ethical hacking and countermeasures
• Implement compliance and operational security
The CEH V7 teaches those concerned about the security and
• Address threats and vulnerabilities
integrity of their networks infrastructure by learning to enhance
• Understand application, host and data security
your networks defenses. You will begin with perimeter defene work,
• Utilize access control and identity management
then by scanning, you will learn how intruders operate and the
• Use cryptography
steps you can take to secure a system. In the interactive, lab-filled
environment of this ethical hacking course, you will gain in-depth
Prerequisite: PC hardware: The basic or equivalent skills
knowledge and practical experience with current, essential security
Length: 5 days
systems. You will explore common ethical hacking topics, such
as intrusion detection, policy creation, social engineering, DDoS
attacks. buffer overflows and more. In addition to learning how to
Data Center monitoring with system center operations
manager (MOC10964)
scan, test, hack and secure a system, you’ll prepare for the latest
Certified Ethical Hacker exam from EC-Council. Highlights include:
Get hands-on instruction and practice implementing
• A DVD packed with the latest hacking and security tools and more
infrastructure and application monitoring with System Center
than 1000 minutes of videos demonstrating hacking techniques.
2012 SP1 Operations Manager in this 4-day Microsoft Official
• Diagrams of concepts and attacks for clarity and easier interpretation
Course. System Center 2012 SP1 Operations Manager provides
• Key industry-standard tools covered in detail
infrastructure monitoring that is flexible and cost-effective,
• Exclusive section for countermeasures against different attacks
helps ensure the predictable performance and availability of
• Time dedicated to penetration testing
vital applications, and offers comprehensive monitoring for your
• Results-orientated, descriptive and analytical lab manual
datacenter and cloud, both private and public. You will learn the
skills you need to proactively monitor and respond to server
In this workshop, you will:
and service availability, low performance, and security issues for
• Footprinting and reconnainssance
servers in the datacenter. You will learn key Operations Manager
• Hacking web servers, web applications and wireless networks
concepts such as Management Packs, Overrides, and Distributed
• Cryptography
Application Models. You will learn how to configure some of the
• Penetration testing
key new features in Operations Manager such as Application
• Social engineering
Performance Monitoring (APM), Network Device Monitoring,
• Trojans, viruses and worms
Dashboards, and Widgets. As part of the learning experience, you
• Evading IDS, firewalls and honeypots
will perform hands-on exercises in a virtual lab environment.
• Enumeration
• Burrer overflows
46
This course is designed for experienced IT professionals who
Prerequisite: PC Hardware: The Basic or equivalent skills
support medium to large enterprises and have experience
What you need to know
administering Windows Server 2012. In this workshop, you will:
• One year of experience installing, configuring and supporting
• Describe the key features and functionality of System Center 2012
Windows XP desktop operating systems
Length: 3 days
SP1 Operations Manager
• Describe the various methods of deploying Agents with SC 2012
Operations Manager
• Configure notifications, reporting and service level tracking
Hardware
• Configure audit collection services, agentless exception monitoring
PC hardware: The basics
• Configure application performance monitoring and network device
In this workshop, participants will get the opportunity to open a
monitoring
• Configure dashboard and widgets in SC 2012 Operations Manager
computer case, and see how to perform common upgrades and
• Configure integration between SC 2012 Operations Manager and
repairs, without risking their own system. Acronyms and obscure
terms are explained, and participants will be able to take out
other System Center components
individual components of the computer, and examine them in detail.
Prerequisites: CompTIA Server+, Configuring, managing and
This workshop is intended for anyone wanting to make upgrades on
maintaining Windows Server 2008-based Server (MOC6419),
their own computers, and looking for a safe environment to practice.
Installing and configuring Windows Server 2012 (MOC20410).
In this workshop, you will:
What you need to know
• Perform basic maintenance on a computer
• Real world hands on experience working with Windows Server 2008,
• Replace and upgrade common computer components like RAM, hard
drives and expansion cards
2008 R2 and 2012
• Understand current computer terminology
• Good Knowledge and undertanding of Active Directory and
• Recognize common hardware problems
Networking Infrastructure
• Knowledge equivalent to that covered in the Installing and Configuring
Prerequisite: PC Hardware: The basics, or equivalent skills
Windows Server 2012 (MOC 20410)
Length: 4 days
What you need to know
Note: This course is based on System Center 2012 SP1
• Use a Windows-based computer
Length: 3 hours
Installing and configuring Windows 7 Client (MOC6292)
This three-day instructor-led course is intended for IT professionals
High performance computing
who are interested in expanding their knowledge base and technical
Introductory parallel programming or supercomputers
skills about Windows 7 Client. In this course, students learn how
This workshop will introduce the concepts of threads and message
to install, upgrade, and migrate to Windows 7 client. Students
passing to harness multiple processors to accomplish a single task.
then configure Windows 7 client for network connectivity, security,
Both a lecture and hands-on lab will be included. In this workshop,
maintenance, and mobile computing. This course helps students
you will:
prepare for the Exam 70-680, TS: Windows 7, Configuring. In this
• Begin to write threads and message passing into simple programs to
workshop, you will:
speed up their execution
• Perform a clean installation of Windows 7, upgrade to Windows 7, and
migrate user-related data and settings from an earlier version
Prerequisite: Windows: Basic computing skills or equivalent skills
Of Windows
What you need to know:
• Install windows 7 using various methods
• A basic understanding of UNIX or LINUX
• Configure disks, partitions, volumes, and device drivers to enable a
Length: 7 hours
Windows 7 client computer
• Configure file access and printer access on a Windows 7 client computer
• Configure network connectivity on a Windows 7 client computer
• Configure wireless network connectivity on a Windows 7 client computer
• Secure windows 7 desktops
• Optimize and maintain the performance and reliability of a Windows 7
client computer
• Configure mobile computing and remote access settings for a
Windows 7 client computer
47
Programming
Web programming
Python: The basics
SQL: Data retrieval
This workshop introduces the Python programming language.
Relational databases and the data they store are increasingly at the
Participants will spend time learning the basics of the language
core of how we understand our world and make decisions in it. SQL
with variables, loops and print statements, and then will move on to
(Structured Query Language) is the standard programming language
creating an application designed to allow a user to search for movie
used for querying databases and answering questions about the data
times from an external file. In this workshop, you will learn:
in databases. Most relational databases, such as Access, SQL Server,
• Learn basic Python syntax
Oracle, MySQL, Sybase, and FoxPro, can all be queried using SQL.
• Capture user input
Participants will learn how to use SQL to retrieve a variety of data
• learn about different variable types
for building reports or powering Web and desktop applications. This
• Control flow with conditionals and loops
workshop is intended for participants with a good understanding of
• Access data from an internal file
relational databases but limited to no experience using SQL. In this
• Create user defined functions
workshop, you will:
• Learn basic SQL concepts
Prerequisite: Outlook 2013: Email basics or equivalent skills
• Retrieve records from a single table
What you need to know:
• Use joins to retrieve records from multiple related tables
• Use a text editor
• Use WHERE to search for or limit records returned by a query
• Recognize and correct syntax editors
• Use aggregate functions and field operations
Length: 3 hours
• Work with null values in queries
Prerequisite: Windows: Basic Computing Skills or equivalent skills
PHP: The basics
What you need to know
In this workshop, participants will create a simple program in the
• Understand and work with database relationships
PHP programming language. Along the way, the participants will
Length: 3.5 hours
learn basic programming terminology and techniques including
loops, control structures, variables, commenting, and creating php
templates. While learning these techniques, participants will create a
XML: The basics
simple application that pulls information from a text-based data file.
As a common tool for Web development, and a universal medium
In this workshop, you will learn:
for information storage and exchange, XML is a key technology
• Write basic PHP syntax
for those entering a wide variety of technology professions. This
• process user input using the $_GET array
workshop will focus on two major areas of XML. First, it will cover the
• control flow with control structures
basic syntactic rules that make up an XML document and include
• make decisions with conditional structures
concepts such as elements, attributes, entities and namespaces.
• Access data from an external data source
Second, it will cover validation of XML documents using a Document
• create and use functions
Type Definition (DTD).In this workshop, you will:
• Understand the syntactic rules of XML
Prerequisite: Dreamweaver CS6: The basics or equivalent skills
• Author an XML document
What you need to know:
• Create an XML Document Type Definition
• Work comfortably with HTML code
• Validate XML using a Document Type Definition
• Create a well-structured web document
• Incorporate namespaces into XML documents
• Work with Dreamweaver in Code View
• Upload files to a server using Dreamweaver
Prerequisite: XHTML: Structure & Description or equivalent skills
Length: 2 hours
What you need to know:
• How to create a well formed XHTML document
• How to use XHTML markup tags to format data
Length: 3 hours
48
SQL: Advanced data retrieval and data modification
SharePoint 2013 site administration: The basics
Building on what was covered in SQL: Data retrieval, this workshop
Participants will continue from the skills they learned in SharePoint:
is intended for anyone wants to learn how to use SQL to add, update,
The basics. They will learn how to create and manage sites in the IU
and delete data and learn advanced data retrieval techniques.
environment, work with content types, lists and library views, and
In addition, participants will learn basic concepts of database
work with forms and web parts among other skills We will also briefly
transaction processing. In this workshop, you will:
discuss SharePoint security concepts, how workflows are created
• Use UNION to select similar types of information from at IU, and list and library features. Participants will also have the
opportunity to ask questions about their own SharePoint systems. In
unrelated tables
• Use HAVING to filter results when doing grouping
this workshop, you will:
• Use SELF-JOINs to create a relationship between a table and itself
• Manage lists in a site collection
• Use INSERT to add data to a table
• Manage document libraries
• Use UPDATE to modify existing records in a table
• Manage form libraries
• Use DELETE to delete existing records from a table
• Manage content types in a site collection
• Work with transactions to control data modification operations
• Work with forms
• Work with web parts
Prerequisite: SQL: Data Retrieval or equivalent skills
Prerequisite: SharePoint 2010: The basics or equivalent skills
What you need to know:
• Retrieve records from a single table
What you need to know:
• Use joins to retrieve records from multiple related tables
• The basics of SharePoint
• Use WHERE to search for or limit records returned by a query
• How to create a custom list
• Use aggregate functions and field operations
• How to create a document library
• Work with null values in queries
• How SharePoint lists are structured
Length: 3 hours
• Basic SharePoint permission settings
Length: 1 day
SharePoint 2010: Workflows with Nintex
In this session, participants will see how to create workflows in
Unix: The basics
Nintex to automate SharePoint functionality. These workflows are
Unix is a popular operating system used on many central systems
very powerful and can make business processing much easier by
and web servers. This workshop is intended for people who have
automating file creating, task completion, and notifying stakeholders
little or no experience working with Unix from the command
in a site. We will see how to create workflows, where to create them,
line. It gives a quick overview of how Unix works, explains the
and create a few simple workflows and see examples of more
directory structures, and provides guided practice with core file
complex workflows. In this workshop, you will:
management commands and setting file permissions. File archiving,
• Create workflows in Nintex
file compression, and file transfer (FTP) are also covered. In this
• Explore the Nintex interface
workshop, you will:
• See how to use workflows to automate SharePoint processes
• Manage files and directories
• Set file permissions
Prerequisites: SharePoint 2010: The basics and SharePoint 2010
• Share and copy files
site administration: The basics.
• Archive and compress files
What you need to know:
• Get files from another machine using FTP
• Create a SharePoint site
• Get help
• Create libraries and lists in SharePoint
Length: 3.5 hours
Prerequisite: Windows: Basic computing skills or equivalent skills
What you need to know:
• Use a keyboard to perform typing tasks
• Use a mouse
Length: 3 hours
Note: At IU, Unix is the operating system used to run research
systems, central Web servers storage systems (MDSS), and many
enterprise information systems.
49
Web development
Web design
Cascade Server: Site managers
See Design & media section
Cascade Server is Indiana University’s Web Content Management
Web development
knowledge of web design languages or standards. Using Cascade
System (WCMS). Maintaining content in a WCMS doesn’t require any
Server, a site manager can put the power of editing content into the
Web publishing: An overview of tools & resources
hands of content experts, and focus on maintaining the structural and
Intended for anyone new to web publishing, this workshop and
presentation provides an overview of basic web publishing
issues and resources. Emphasis is placed on web accounts
and support at IU. While participants will get hands-on practice
transferring files to a web server, this workshop is primarily
lecture focused. Participants will not create completed web
pages in this workshop. In this workshop, you will:
visual aspects of a site. Cascade Server: Site Managers is a three day,
eighteen hour workshop that will teach an experienced web designer
everything they need to know to start creating a working site within
Cascade Server.
Before coming to the training, a Site Manager should have an intimate
working knowledge of their group’s website including a knowledge
• Review common terminology associated with Web pages
of at least XHTML, CSS, and transforming XML documents into
• Discuss the required applications and accounts for publishing XHTML using XSLT. Day one begins an in-depth look at the process of
on the web
converting an existing website into a Cascade Server site, beginning
• Explore the pros and cons of different web authoring from nothing and finishing with a functional, albeit rough, site. Day
and editing tools
two focuses on refining the site using Data Definitions, Workflows,
• Learn about university-supported training options
multiple publishing configurations (PDF, HTML, XML, RTF, etc.), as
• Practice transferring files to a web server
well as setting up a site using pre-defined templates.
Prerequisite: Windows: Basic computing skills or
equivalent skills
What you need to know:
This workshop is not intended for novice web designers as a deep
understanding of XHTML, CSS, and XML use and syntax is expected
of all participants. An understanding of the structure and the inner
• Use a mouse
workings of your group’s existing website is helpful, but not necessary.
• Use Windows command menus
In this workshop, you will:
• Save and organize files
• Create, edit, and publish content using the WCMS
Length: 75 minutes
Note: The content of this workshop is available as an online
tutorial for self study.
• Use workflows to control a series of review steps for a document
• Bring common assets into your site
• Use XPath to navigate through an XML document
• Transform XML data into an XHTML document
• Learn strategies for applying XSLT and XML to a Cascade Server site
Cascade Server: Contributors, approvers,
and publishers
• Convert a traditional site to a Cascade Server site
• Organize the building blocks of a site
This workshop teaches a content contributor, approver and/or
publisher how to use the authoring functions within Cascade
Server. It covers basic content creation, editing, and publishing.
Participants will learn how to create pages, use asset factories,
create external links, edit pages, manipulate workflows. In this
workshop, you will:
• Learn the diverse vocabulary of Cascade Server
• Create and manage Asset Factories, Data Definitions, Configuration
Sets, Transports, Targets, Destinations, Blocks, Users, Groups,
Metadata Sets, and Publish Sets
• Create and manage static assets such as images
• Create PDF, Printable, and XML versions of pages
• Create content within Cascade Server
• Understand user roles
• Edit content within Cascade Server
• Manage multiple users
• Use workflows within Cascade Server
• Manage user groups
• Publish content within Cascade Server
• Create new site structures with the Managers’ Tools interface
• Create a site from pre-existing templates
Prerequisite: Web publishing: An overview of tools & resources
or equivalent skills
What you need to know:
• Navigate a web page
• Use a word processor
• Publish a web document
Length: 3 hours
50
Cascading Style Sheets: Layout & design
Prerequisite: Cascading Style Sheets: Layout & design and XML:
The basics or equivalent skills
This workshop is intended for web developers who are already
What you need to know:
familiar with XHTML and Cascading Style Sheets (CSS). In this
• Design a website using standards-compliant XHTML and CSS
workshop, participants will learn how to gain more precise control
• Create and edit XML documents
over web document layout, achieve dynamic functions with CSS,
• Transform XML content using XSLT and XPath
and explore additional features that will make their websites easier
• The organization and structure of your group’s existing website
to maintain. In this workshop, you will:
• The business rules surrounding the publishing of content in your
• Control visual display of elements
group’s existing site
• Control positioning of elements
Length: 2 days
• Provide better accessibility
• Create a consistent design
• Simplify site maintenance
HTML5 and CSS: The basics
• Eliminate the need for tables and frames for layout
HTML and CSS are languages used in order to build web pages. This
• Provide dynamic effects without scripting
is a beginner’s workshop on learning how to read and code these
languages. Participants will learn how to structure content for the web,
Prerequisite: Cascading Style Sheets: The basics or
incorporate graphics, and style a web page. In this workshop, you will:
equivalent skills
• Structure text and image content for the web using HTML5
What you need to know:
• Learn semantic markup new to the HTML standard
• Understand mark-up languages (i.e. XHTML, HTML)
• Style a web page using Cascading Style Sheets (CSS)
• Understand Cascading Style Sheets basics
• Create hyperlinks to link to other pages
Length: 3 hours
• Learn the box model for basic layout
• Make web pages accessible and well-formed
Dreamweaver CS6: The basics
Prerequisite: Windows: Basic Computing Skills or equivalent skills
Dreamweaver is used to create web pages and manage websites;
What you need to know:
perfect for beginners, it allows you to design pages graphically
• Type well
without having to write XHTML. This workshop is intended for
• Save and organize files
people with little or no experience using Dreamweaver, and it covers
Length: 3.5 hours
how to build basic web pages that include text, images and links.
In this workshop, you will:
• Design a CSS based website
Cascading Style Sheets: The basics
• Explore page layout options
Introduces CSS (Cascading Style Sheets), which are used to
• Insert graphics
control style and layout of XHTML pages and to help in website
• Re-use content from external text files
maintenance. This design solution gives web authors more power
• Work with CSS styles
and flexibility for creating and controlling the appearance of multiple
• Insert links
web documents. In this workshop, you will:
• Upload a completed site to a web server
• Create individual styles and style sheets
• Apply styles to XHTML
Prerequisite: XHTML: The basics or equivalent skills
• Use CSS to control a consistent layout across multiple pages
What you need to know:
• Use CSS to make global changes to a site
• Navigate a web page
• Use CSS to control fonts, text, color and positioning
• Understand XHTML code
Length: 3 hours
Prerequisite: XHTML: Structure & description or equivalent skills
What you need to know:
• Use a text editor to structure a document with HTML/XHTML mark up
• Publish documents to the Web using an FTP client
Length: 3 hours
51
Dreamweaver CS6: Using templates to standardize
your site
Perl: The basics
This workshop is intended for participants with experience using
working with files, web programming, and systems administration.
Dreamweaver and familiarity with markup code (HTML or XHTML).
This workshop is intended for people who have little or no
It explores how to use Dreamweaver templates to make controlling
programming experience. It quickly covers basic programming
and updating page content a snap. In this workshop, you will:
concepts, Perl in a Unix environment, and Perl syntax. It then
• Implement templates to reduce website maintenance time
provides guided exercises involving data structures, flow control,
• Create editable regions
and read-only file access. Participants will build a command line
• Create optional regions
price check program in the course of the workshop. This workshop
• Create nested templates
works in a Unix environment, but because Perl is available for most
• Make attributes editable
all modern operating systems, nearly everything covered in this
Perl is a general purpose programming language that is popular for
workshop works equally well in any other operating system. In this
Prerequisite: Dreamweaver CS6: The basics or equivalent skills
workshop, you will:
What you need to know:
• Learn basic Perl syntax
• Understand using CSS to handle layout
• Capture user input
• Create editable regions
• Use scalars, arrays and associative arrays
• Create optional regions
• Control flow with conditionals and loops
• Create nested templates
• Access data from an external file
• Make attributes editable
Length: 75 minutes
Prerequisite: Unix: The basics or equivalent skills
What you need to know:
• Transfer files using sFTP
Website development Project Lab
• Manage files, directories and permissions in a Unix environment
In this 3-hour lab session, you will integrate the skills you learned
• Debug code or markup with a text editor
in Dreamweaver and Fireworks to independently create a design
Length: 4 hours
project. You will work with predetermined materials and your own
design ideas. In this workshop, you will:
Perl: Dynamically created web pages
• Gain additional practice and experience working with web design and
In this workshop, participants will examine how Perl allows you to
development tools
create a web page. We can use this programming language to create
• Get reinforcement on concepts and skills learned in the prerequisite
web pages through the Common Gateway Interface (CGI). This way,
workshops
we can update the pages based on user feedback. This language is
• Use an individualized, creative, and explorative approach to frequently used to process form data that the user provides. In this
web design
workshop, you will:
• Gain experience integrating Adobe Dreamweaver and Fireworks
• Generate scripted HTML output in Perl
Prerequisites: Fireworks CS6: The basics; Dreamweaver CS6: The
• Use form data from within a script
basics; Dreamweaver CS6: Using Templates to Standardize your Site
• Learn the role CGI plays on the Web
• Design a CSS based website using Dreamweaver
• Create a simple lookup script in Perl
• Work with CSS
• Understand how to insert links
Prerequisite: Perl: The basics or equivalent skills
• Work with templates in Dreamweaver
What you need to know:
• Create graphics incorporating text, vector paths, strokes and fills
• Transfer files using FTP
using Illustrator
• Manage files, directories and permissions in a Unix environment
• Optimize and export graphics for use on the web
• Basic Perl syntax
Length: 3 hours
Length: 1.5 hours
Note: You can only register for this workshop as part of the website
development fundamentals IT Training Certificate Series.
52
Web graphics
HTML5: Using geolocation, local storage, canvas,
and video
Illustrator CS6: The basics
HTML5 is the future of the web. We will discuss what’s available
This workshop lasts 3 hours, and is part of the certificate series
now and what can be expected in the future including looking at
Desktop Publishing Fundamentals. In this workshop, participants
examples from around the web. This session will discuss basic
will learn how the basics of Adobe Illustrator, a drawing program.
HTML5 and some JavaScript. Topics include embedding video, using
Participants will spend time building basic skills like drawing with
geolocation, and canvas. In this workshop, you will:
brushes, creating and combining shapes, and using gradients, and
• Use Geolocation in a web application
will then use those skills to create a professional looking business
• Store values locally using local storage
logo. What you’ll learn:
• Draw items on a canvas
• Explore the shape creation tools
• Embed video into a web page
• Combine and alter shapes
• Understand the different codecs that are used in HTML5 for video
• Create gradients
• Understand the different selection tools
Prerequisite : HTML5: Using semantic markup or equivalent skills
• Understand stroke and fill
What you need to know:
• Create a professional looking logo
• Basic HTML5 structure
Length: 90 minutes
Prerequisite: Windows: Basic computing skills or equivalent skills
What you need to know:
• Basic HTML5 structure
User-centered web design & usability testing
Length: 3 hours
Intended for anyone involved in planning, designing, or creating
a medium to large website. Uses lecture, video, and discussion to
introduce the importance of incorporating user-centered design
Illustrator CS6: Creating graphics for the web
principles and usability testing in web design and implementation.
This workshop introduces the different tools Illustrator offers to
In this workshop, you will:
create web graphics. What you’ll learn:
• Explore user-centered Web design
• Learn the difference between vector and bitmap graphics
• See and discuss examples of usability testing
• Create graphics for a website, including a banner, buttons, • Learn about ADA Web guidelines
and a background
• Learn a four-part Website design method
• Import and manipulate graphics in Illustrator
• Examine specific guidelines and
• Choose and apply filters to objects
Considerations at each stage
• Optimize images for the web
• Learn where to find resources for Web design
Prerequisite: Windows: Illustrator CS6: The basics or equivalent
Prerequisite: XHTML: The basics or equivalent skills
skills
What you need to know:
What you need to know:
• Understand basic HTML code
• Navigate the Illustrator interface
• Understand Web colors and graphic formats
• Edit and manipulate art elements
• Monitor image sizes and Web page load time
• Work with shapes and text in Illustrator
• Encode Web pages for text-only Web browsers
Length: 3 hours
Length: 3 hours
53
Adobe CS6: Pen tool basics for advanced graphic design
Photoshop CS6: Restoring old photos
In this workshop, participants will learn about paths. Paths are used
In this session, participants will look at some techniques to restore
as the building block for all vector objects in many graphic design
old photographs in Photoshop. We will look at using healing tools,
programs. Once participants are comfortable with paths, we will
sharpening, contrast adjustments, and color correction. In this
learn how to use one of the most challenging and powerful path
webinar, you will:
creation tools: the Pen tool. This tool is difficult to master, but in this
• Work with old photographs
workshop, we will build up specific skills slowly, and by the end of
• Learn techniques for restoring photographs
the workshop, participants will be comfortable using the tool. We will
• Work with healing tools
also examine differences of the tool in several Adobe applications,
• Work with adjustment layers
including InDesign, Fireworks, Flash, and Photoshop.
Prerequisite: Photoshop CS6: The basics or equivalent skills
Length: 60 minutes
This workshop will run for 3 hours, with an additional half hour of lab
time for practice of new skills with the instructor present. Participants
are free to use as much of the practice time as they like. In this
workshop, you will:
Python: The basics
• Use the Pen tool proficiently in the Adobe Creative Suite
This workshop introduces the Python programming language.
• Understand paths and path creation in the Adobe Creative Suite
Participants will spend time learning the basics of the language
• Create simple and complex shapes using the Pen tool
with variables, loops and print statements, and then will move on to
• Alter paths to create new shapes
creating an application designed to allow a user to search for movie
• Examine path creation with multiple tools
times from an external file. In this workshop, you will learn:
• Examine how the Pen tool would be used in Photoshop, InDesign,
• Learn basic Python syntax
Flash, and Fireworks
• Capture user input
• learn about different variable types
• Control flow with conditionals and loops
Prerequisite: Illustrator CS6: The basics or equivalent skills
Length: 3 hours
• Access data from an internal file
Photoshop CS6: The basics
Prerequisite: Outlook 2013: Email basics or equivalent skills
• Create user defined functions
In this workshop, participants will learn the basics of Adobe
Photoshop, the premiere image editing application. Particpants
will learn how to retouch a photo while building skills that will help
them go further with the application. Participants will also work on
a more complex photo compositing project, and learn about layers,
selections, healing tools, and image adjustments. In this workshop,
you will:
What you need to know:
• Understand the Photoshop interface
Fireworks was built from the ground up for the creation of web
• Use a text editor
• Recognize and correct syntax editors
Length: 3 hours
Fireworks CS6: The basics
• Retouch and blend two images
graphics. This workshop is intended for anyone who wants to
• Understand layers
use Fireworks to create beautiful, editable graphics from scratch,
• Use effects and filters
intended for use on the web. This workshop also provides basic
• Use the History Panel
coverage of optimizing graphics for web distribution. In this
• Save a file for the web
workshop, you will:
• Use basic healing tools
• Learn the difference between vector and bitmap graphics
• Create art using vector paths, strokes, fills, and Fireworks Live Effects
Prerequisite: Windows: Basic computing skills or equivalent skills
• Use the Pen Tool to draw vector shapes and lines
What you need to know:
• Bend text around paths
• Use the mouse and keyboard proficiently
• Use Fireworks’ Live Filters, such as shad-ows, bevels, and textures
Length: 3 hours
• Use Fireworks’ Layers panel to control which elements obscure other
elements
• Optimize and export graphics for use on the Web
Prerequisite: Windows: Basic computing skills or equivalent skills
Length: 3 hours
54
PHP: The basics
SQL: Advanced data retrieval and data modification
In this workshop, participants will create a simple program in the
Building on what was covered in SQL: Data retrieval, this workshop
is intended for anyone wants to learn how to use SQL to add, update,
PHP programming language. Along the way, the participants will
and delete data and learn advanced data retrieval techniques. In
learn basic programming terminology and techniques including
addition, participants will learn basic concepts of database transaction
loops, control structures, variables, commenting, and creating php
processing. In this workshop, you will:
templates. While learning these techniques, participants will create a
• Use UNION to select similar types of information from
simple application that pulls information from a text-based data file.
Unrelated tables
In this workshop, you will learn:
• Use HAVING to filter results when doing grouping
• Write basic PHP syntax
• Use SELF-JOINs to create a relationship between a table and itself
• Process user input using the $_GET array
• Use INSERT to add data to a table
• Control flow with control structures
• Use UPDATE to modify existing records in a table
• Make decisions with conditional structures
• Use DELETE to delete existing records from a table
• Access data from an external data source
• Create and use functions
• Work with transactions to control data modification operations
Prerequisite: Dreamweaver CS6: The basics or equivalent skills
What you need to know:
• Retrieve records from a single table
What you need to know:
• Use joins to retrieve records from multiple related tables
• Work comfortably with HTML code
• Use WHERE to search for or limit records returned by a query
• Create a well-structured web document
• Use aggregate functions and field operations
• Work with Dreamweaver in Code View
• Work with null values in queries
• Upload files to a server using Dreamweaver
Length: 3 hours
Length: 2 hours
XML: The basics
Web programming
As a common tool for Web development, and a universal medium
SQL: Data retrieval
for information storage and exchange, XML is a key technology for
those entering a wide variety of technology professions.
Relational databases and the data they store are increasingly at
the core of how we understand our world and make decisions in it.
SQL (Structured Query Language) is the standard programming
This workshop will focus on two major areas of XML. First, it will
language used for querying databases and answering questions
cover the basic syntactic rules that make up an XML document
about the data in databases. Most relational databases, such as
and include concepts such as elements, attributes, entities and
Access, SQL Server, Oracle, MySQL, Sybase, and FoxPro, can all be
namespaces. Second, it will cover validation of XML documents
queried using SQL. Participants will learn how to use SQL to retrieve
using a Document Type Definition (DTD). In this workshop, you will:
a variety of data for building reports or powering Web and desktop
• Understand the syntactic rules of XML
applications.
• Author an XML document
• Create an XML Document Type Definition
This workshop is intended for participants with a good
• Validate XML using a Document Type Definition
understanding of relational databases but limited to no experience
• Incorporate namespaces into XML documents
using SQL. In this workshop, you will:
• Learn basic SQL concepts
What you need to know:
• Retrieve records from a single table
• How to create a well formed XHTML document
• Use joins to retrieve records from multiple related tables
• How to use XHTML markup tags to format data
• Use WHERE to search for or limit records returned by a query
Length: 3 hours
• Use aggregate functions and field operations
• Work with null values in queries
What you need to know:
• Understand and work with database relationships
Length: 3.5 hours
55
XML: Transforming content with XSLT and XPath
XSLT (Extensible Stylesheet Language Transformations) is used to
transform XML documents into other data types, such as XHTML.
XPath (XML Path) is a language used to query the data stored in an
XML document.
This workshop will teach participants to transform XML data into
valid XHTML using XSLT and XPath. With a growing amount of data
being stored in XML format, being able to view and manipulate
that XML data becomes necessary. XSLT allows a developer to
transform one XML document into a variety of different formats
including XHTML, PDF, and even other types of XML documents.
Being able to transform XML data allows for easy reuse of
information and enables a developer to display the information in
numerous formats for analysis and viewing. While the focus of this
workshop is on transforming XML to XHTML, the same principles
can be applied to transform XML into any other document type. In
this workshop, you will:
• Review XML structure, navigation, and terminology
• Learn XSLT syntax
• Use XPath to navigate through an XML document
• Learn strategies for creating XSLT templates
• Transform XML data to an XHTML document
What you need to know:
• How to create a well formed XHTML document
• How to use XHTML markup tags to format data
Length: 3 hours
56
Two campuses – One program
About our program
UITS IT Training offers instructor-led computing workshops and
Our goal is to provide you with excellent technology training and
provides self-study training resources to the Indiana University
customer service. While we enjoy our national recognition, we
community and beyond. We deliver training to more than 30,000
continue to be dedicated first and foremost to meeting the training
participants each year across all campuses through our instructor-
needs of all of our participants, from the true beginner to the
led workshops, webinars, and self-study courses and tutorials.
more advanced user. We look forward to helping you meet your
technology training needs in the year to come.
We partner with many departments and individual faculty and
staff members across all Indiana University campuses to provide
IT Training develops and delivers workshops on the Bloomington
broad support for the technology education needs of the entire
(IUB) and Indianapolis (IUPUI) campuses and delivers online
university community. Beyond the university, IT Training has won
instructor-led workshops and webinars which can be taken from
several national awards for our materials and services, and our
anywhere. Our staff on both campuses are dedicated to making sure
staff members have chaired programs, judged competitions, and
that your training experience is the best it can be. Remember that if
presented papers at national conferences. Additionally, universities
the workshop you want is not offered at a convenient time for you on
and organizations from around the world are using our class
your primary campus, you can check the online and other campus’s
materials in their own training programs.
schedule to find training that better fits your schedule.
Management
Management
Chris Payne, Manager
Donna Jones, Assistant manager
Carol Rhodes, Assistant manager
IUPUI professional staff members:
IUB professional staff members:
Denise Brown
Jennifer Oakes
Greg Hanek
Tom Mason
Robert De Roeck
Phil Shaw
Andy Hunsucker
Jessica Samuel
Kimmaree Murday
Kathy Wade
Chabane Maidi
Part-time instructors & assistants
Part-time instructors & assistants
Iryna Ashby
April Law
Mayme Fravel
Veronica Mount
Andrew Behringer
Sarah McAfoose
Rachel Frend
Lori Wright
Sandra Doell
Kelly McNamara
Ben Leatherbury
Jason Fickel
Rebecca Phillips
David Heald
Laura Reed
Roger Henry
Brandon Spahn
Beth Hoey
57
Bloomington workshop locations
Most IUB workshops meet in the Wells Library (at 10th and Jordan),
either in the Information Commons IC 103 Classroom or a nearby
classroom. The Project Management EdCert course meets in the
CIB building, which is located at the intersection of 10th Street and
the State Road 46 Bypass.
Parking on the Bloomington campus
Anyone may park in a campus pay parking lot or at a pay meter
without a permit. The closest pay lot to the library is the 11th Street
and Fee Lane parking garage. All campus parking spaces except
for the pay lots and metered spaces require that your vehicle be
registered with the university. This registration is in effect 24 hours
a day. If you pay to park in the 11th Street and Fee Lane parking
garage to attend a workshop in the library, notify the workshop
instructor if you would like to purchase a visitor’s parking clip for $7
to save on parking expenses.
Additional information including maps and directions, can be found
by clicking the “Directions & Parking” link at:
ittraining.iu.edu/about
Indianapolis campus workshop locations
Our workshop locations are noted in red on the map at the right.
Most IUPUI workshops meet in the Informatics & Communications
Technology Complex, room IT 121, and most EdCert courses meet
in the same building in room IT 125. Parking lots on the map at right
are noted by numbers and buildings are noted by letters.
Parking on the Indianapolis campus
Students may park in lots 71, 73, 83, and 85. Faculty and staff may
park in lots 71, 77, 81, 83, and 85. Visitors and physically disabled
patrons may park in the Gateway garage (XF). All campus parking
spaces except for the designated visitor spots require that your
vehicle be registered with the university. This regulation is in effect
24 hours a day.
Additional Information including maps and directions, can be found
by clicking the “Our Facilities” link at:
ittraining.iu.edu/about
58
1/--pages
Пожаловаться на содержимое документа