non-profit org.
us Postage Paid
Science Museum
of minnesota
Computer Education Center
120 West Kellogg Boulevard
Saint Paul, Minnesota 55102
Computer Education
Training for you and your business
Winter
2015
Classes
Winter
2015
Classes
30 Years of Computer Education
Access • Acrobat • Blogging for Business • Captivate • Crystal Reports
• Database Basics • Desktop Publishing Fundamentals • Dreamweaver •
Essential Computer Skills • Excel • Facebook • Facebook for Business
• HTML • Illustrator • InDesign • InfoPath • Internet and E-Mail
• JavaScript • Job Hunting Online • jQuery • LinkedIn • Lync •
Macintosh • Mobile Website Design • Mobile Web Basics–Websites & Apps
• Office 2013–What’s New • OneNote • Outlook • Photoshop • Photoshop
Elements • PowerPoint • Premiere Elements • Project • Publisher •
QuickBooks • Search Engine Optimization • SharePoint • Social Media
• SQL Language • “Terrified” of Computers • Twitter for Business • Visio •
Web Graphics Fundamentals • Website Basics • Websites–Responsive Design
• Windows 7 • Windows 8 • Windows 8–What’s New • Word • WordPress
January–April >>>
A Few of the Many
Companies We’ve
Clicked With:
3M
Aero Systems Engineering, Inc.
Affinity Plus Federal Credit Union
Andersen Corporation
Augsburg Fortress Publishers
Bailey Nurseries
Barr Engineering
Best Buy
Boston Scientific
City of Bloomington
City of Minneapolis
City of St. Paul
Colle + McVoy
Dakota County
Dorsey & Whitney
Eagle Brook Church
Ecolab, Inc.
Education Minnesota
Faegre Baker Daniels
HealthEast
Seward Co-op and Deli
HealthPartners
St. Jude Medical
Hennepin County
St. Olaf College
Honeywell
St. Paul Chamber Orchestra
Kowalski’s Markets
State of Minnesota
Kraus-Anderson Construction
Target Corporation
LeJeune Steel Company
TCF Bank
Macalester College
The McKnight Foundation
Marquette Real Estate Group
The Mosaic Company
Mayo Clinic
The TAPEMARK Company
Medtronic
Thomson Reuters Corporation
Merrill Corporation
Twin Cities Public Television
Metropolitan Council
UnitedHealth Group
Minneapolis Public Schools
United Parcel Service
Minneapolis Star Tribune
University of Minnesota
Minnesota Historical Society
University of St. Thomas
Minnesota Public Radio
US Bank
Minnesota State Senate
USPS
MnSCU
Walker Art Center
Northern Star Council
Wells Fargo
Park Nicollet Health Services
Welsh Companies
Ramsey County
Xcel Energy
Fairview Pharmacy Services
Fredrikson & Byron, P.A.
Gander Mountain
H.B. Fuller Company
Hazelden Foundation
Group training saves you time and money!
Flexible scheduling of dates and times
Select your specific course content
Call 651.221.4722 for more information
Microsoft, Windows, Access. Active Directory, Excel, InfoPath, OneNote, Outlook, PivotTable, PowerPoint, Project, SharePoint, Visio, and Word are either registered trademarks or trademarks of Microsoft
Corporation in the United States and/or other countries. Adobe and Acrobat, Acrobat Reader, Captivate, Distiller, Dreamweaver, Flash, Illustrator, InDesign, Premiere Elements, Photoshop, Photoshop Elements,
PostScript, and Reader are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States and/or in other countries. Apple, Mac, Macintosh, Mac OS, and TrueType are registered
trademarks of Apple Computer, Inc. QuickBooks and QuickBooks Pro are registered trademarks and/or registered service marks of Intuit Inc., or one of its subsidiaries, in the United States and other countries.
Crystal Reports is a trademark or registered trademark of Business Objects SA or its affiliated companies in the United States and other countries. Facebook® is a registered trademark of Facebook Inc., registered
in the United States and other countries. LinkedIn is a registered trademark of LinkedIn Corporation, registered in the United States and other countries. Twitter is a trademark of Twitter Inc., registered in the
United States and other countries. JavaScript is a registered trademark of Sun Microsystems, Inc. WordPress is a registered trademark of Automattic Inc., registered in the United States and other countries. The
companies whose trademarks are listed above do not sponsor, affiliate, or endorse the Science Museum of Minnesota nor its Computer Education Center’s computer training.
WHY USE THE SCIENCE MUSEUM AS YOUR COMPUTER TRAINER?
At the Science Museum’s adult Computer Education Center, we
believe in active learning. We make every minute of training
relevant to the student. Classes are small. Training is interactive.
Instructors bring real-world experience to the classroom and use
everyday language, even humor, to help students cut through the
techno-jargon and get a full hands-on experience. As a result, students
learn faster and retain more!
TOP 10 BENEFITS
1. One-stop shopping
From Windows to Macintosh, we offer more than 150 courses covering
more than 60 subjects. Over 2,000 classes are conveniently scheduled
during the year with a broad range of the most popular products.
2. Company-wide training solutions
Our class offerings range from “Absolutely Terrified” to Microsoft Office,
desktop publishing, digital imaging, database management, networking,
web development, and more.
3. Interactive teaching style
We accelerate your learning with instructor-led, focused, hands-on
classes. Our class size provides a low student-to-teacher ratio.
4. Convenient half-day classes
Our half-day classes are designed to fit your busy schedule. You can attend
one half-day class and immediately apply what you learned back on the job
or take two half-day sessions on the same day for more intensive learning.
5. Education is our only mission
The Science Museum Computer Education Center is the oldest computer
training center in the Twin Cities, using effective learning methods that
are time tested. Plus, all proceeds go directly to supporting children’s
programs, new exhibits, and other educational opportunities.
6. Science Museum of Minnesota - a name you know and trust
We have a solid reputation for providing quality training. We focus on
features that make you more efficient, giving you greater value for your
training dollars.
7. Get training when and where you need it
We offer a large selection of computer classes, with a variety of dates and
times, and provide training in St. Paul or at your location.
8. Customized training saves time and money
Our group classes, client-site options, and portable laptop lab allow you
to select the training that matches your needs. We’ll even tailor classes to
your needs and schedule.
Everything
You Like in
Computer
Training
The most popular classes
Convenient dates and times
Small, hands-on classes
Free refresher classes
Portable lab
Customized classes
9. Your satisfaction is guaranteed
Our class format ensures quick learning and outstanding results. In
addition, we offer free refresher classes.
10. Enjoy the museum atmosphere
You will receive a complimentary Exhibit Pass for use on the day of your class.
3
Table of Contents
Windows and Macintosh Classes
Windows and Macintosh Classes
FastTrack Classes
Introductory Classes
Information Management
Absolutely Terrified of Computers........ 6
Essential Computer Skills....................... 6
Internet and E-Mail Introduction.......... 6
Macintosh OS X Introduction................ 7
Microsoft Surface Tablet......................... 7
Office 2010 - What’s New (Seminar)..... 7
Office 2013/365 - What’s New (Seminar)..... 7
Windows 7................................................. 6
Windows 8 / 8.1......................................... 6
Windows 8/8.1 - What’s New (Seminar)... 7
InfoPath................................................... 19
Lync.......................................................... 19
OneNote................................................... 19
Outlook.................................................... 19
SharePoint............................................... 20
SharePoint Designer.............................. 21
SharePoint 2013 - What’s New (Seminar).... 21
In FastTrack classes, the pace is much
quicker than our standard classes. To
decide if a FastTrack class is right for
you, answer the questions located at the
beginning of the class description. If you
are unsure, take our standard classes.
FastTrack classes will not slow down for
slow students.
Accounting
QuickBooks............................................... 8
Database Management
Access....................................................... 10
Access - FastTrack.................................. 10
Access: Advanced Design (Seminar).... 11
Crystal Reports......................................... 9
Crystal Reports - FastTrack..................... 9
Database Basics (Seminar)..................... 8
SQL Language.......................................... 11
Desktop Publishing and Digital Imaging
Acrobat.................................................... 12
Desktop Publishing Fundamentals..... 12
Illustrator.................................................. 14
InDesign................................................... 16
InDesign - Digital Publishing................ 16
InDesign - PDF Accessibility................. 16
InDesign - FastTrack............................... 17
Photoshop................................................. 14
Photoshop Elements.............................. 15
Premiere Elements................................. 13
Publisher................................................... 17
Web Graphics Fundamentals............... 12
4
Presentation Graphics
PowerPoint.............................................. 18
PowerPoint - FastTrack.......................... 18
PowerPoint Pizzazz (Seminar)............. 18
Process Management
Visio.......................................................... 24
Project Planning
Project...................................................... 24
Spreadsheets
Excel......................................................... 22
Excel - FastTrack..................................... 23
Excel - Working the Workbook............. 23
Word Processing
Word......................................................... 25
Word Accessibility and PDFs................ 25
Word - FastTrack.................................... 25
Access - FastTrack.................................. 10
Crystal Reports - FastTrack..................... 9
Excel - FastTrack..................................... 23
InDesign - FastTrack............................... 17
PowerPoint - FastTrack.......................... 18
Word - FastTrack.................................... 25
New
Classes
Seminars
Internet Classes
Seminars offer the same high-quality
information and individualized attention
as our regular classes but do not employ
“hands-on” training. Because our seminar
classes can accommodate more people,
we are able to offer them at a significantly
reduced price.
Internet Basics
InDesign - Digital Publishing
Internet and E-Mail Introduction........ 26
Job Hunting Online (Free Seminar).... 26
InDesign - PDF Accessibility
Web Development and Design
Lync Introduction
Access: Advanced Database Design..... 11
Database Basics........................................ 8
Facebook Introduction (Free)............... 28
Facebook for Business........................... 28
Job Hunting Online (Free)..................... 26
Mobile Website Design.......................... 33
Office 2010 - What’s New........................ 7
Office 2013/365 - What’s New................ 7
PowerPoint with Pizzazz....................... 18
Search Engine Optimization................. 32
SharePoint 2013 - What’s New ............ 21
Social Media Overview.......................... 28
Twitter for Business............................... 29
Windows 8 / 8.1 - What’s New................. 7
Website Basics......................................... 26
Acrobat - PDF Accessibility.................. 27
Blogging for Business............................ 29
Captivate.................................................. 32
Dreamweaver.......................................... 31
Facebook Introduction (Free Seminar).... 28
Facebook for Business (Seminar)........ 28
HTML....................................................... 30
InDesign - PDF Accessibility................ 27
LinkedIn Introduction........................... 28
Mobile Website Design (Seminar)....... 33
Mobile Web Basics - Websites & Apps.... 34
JavaScript................................................. 34
jQuery...................................................... 34
PDF Accessibility.................................... 27
Premiere Elements................................. 33
Search Engine Optimization (Seminar).... 32
Social Media Overview (Seminar)....... 28
Twitter for Business (Seminar)............ 29
Website Basics (Seminar)...................... 26
Websites - Responsive Web Design...... 32
Web Graphics Fundamentals............... 26
Word - PDF Accessibility....................... 27
WordPress - Designing Your Website...... 29
WordPress - for Blogging...... See Blogging
jQuery
Mobile Web Basics - Websites & Apps
Office 2013 - What's New (Seminar)
SharePoint 2010 for End Users
SharePoint 2013 for End Users
Twitter Introduction (Seminar)
Websites - Responsive Web Design
Windows 8/8.1
Windows 8/8.1 - What's New (Seminar)
Word Accessibility and PDFs
Registration
General Information.............................. 36
Registration Form.................................. 39
Map and Directions
Map and Directions............................... 35
Free Public Service Classes
Facebook Introduction.......................... 28
Job Hunting Online................................ 26
Index
Index of Classes...................................... 38
5
INTRODUCTORY CLASSES
Absolutely Terrified of Computers
Brand new to computers? Does starting up a
computer make you want to shut down? This
class takes everything slow and easy. No
pressure, no bother, no hassle.
Prerequisites: None.
•
•
•
•
Using the keyboard and mouse
Understanding basic Windows features
Using common Windows programs
Learning computer jargon
Registration information–see page 36
Absolutely Terrified of Computers
ABS-Computer
Mon Jan 05
ABS-Computer
Mon Mar 02
8-11 am
8-11 am
$75
$75
Windows 7
Windows 8/8.1
Essential Computer Skills
For Business
This course is designed for people who are
new to the Windows environment or for
those who have been exposed to Windows
but never had any formal training.
Windows 7 and Windows 8 are offered as
separate classes - please make sure you sign
up for the correct version.
Note: If you are an experienced Windows user
transitioning to Windows 8/8.1, please take
the Windows 8/8.1 - What’s New Seminar.
Part 1 - Introduction
Prerequisites: None.
Searching for files
Creating a custom look
Customizing the taskbar
Shortcuts
Customizing the Start menu and desktop
Registration information–see page 36
8-11:45 am
1-4:45 pm
$139
$139
Windows 8/8.1
WI8-Part 1
Mon Jan 12
WI8-Part 2
Mon Jan 12
8-11:45 am
1-4:45 pm
$139
$139
WI8-Part 1
WI8-Part 2
6
Check our website for additional classes and schedules
Thu Mar 05
Thu Mar 05
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$50
$50
$50
Internet and e-mail skills are critical to
communication. The Internet is filled with
useful information for those who can make
sense of the maze and e-mail has become the
typical method for business communication.
This class will take you through the ins
and outs of browsing the Internet as well as
writing and sending an e-mail.
Students will be working in Windows. Most
topics discussed also apply to Macintosh.
Prerequisites: Experience using a computer.
Wed Jan 07
Wed Jan 07
Mon Mar 09
Mon Mar 09
Using menus, taskbar, toolbars
Setting up your own filing system
Creating, moving, and saving files
Working with CDs and flash drives
Internet and E-Mail Introduction
Prerequisites: Windows Part 1 or equivalent
experience.
WI7-Part 1
WI7-Part 2
•
•
•
•
Essential Computer Skills for Business
ECS-Essential
Thu Jan 15
9-11 am
ECS-Essential
Thu Feb 19
9-11 am
ECS-Essential
Tue Mar 24
9-11 am
Part 2 - Intermediate
Windows 7
WI7-Part 1
WI7-Part 2
Prerequisites: Experience using a computer.
Registration information–see page 36
• What is an operating system?
• The Windows environment:
the desktop and taskbar
• Start menu and programs
• Windows Explorer/My Computer:
file and disk management
• Cut, copy, and paste
•
•
•
•
•
This class is for current Windows users who
want to develop a better understanding of
their computer. Discover the computer skills
used daily in the workplace. Learn tips and
shortcuts that will increase your efficiency
and save time.
$139
$139
$139
$139
•
•
•
•
•
•
Feeling comfortable with the Internet
Searching for the information you want
Returning to your favorite places
Sending and receiving e-mail
E-mail attachments
Deleting unwanted e-mail
Registration information–see page 36
Internet and E-Mail Introduction
IEM-Inter/E-mail
Thu Feb 19
1-4 pm
$75
INTRODUCTORY CLASSES
Windows 8/8.1 What’s New (Seminar)
If you are a current Windows XP or
Windows 7 user and would like to transition
to Windows 8/8.1, this class is for you.
In this seminar we will explore the new
features available in Windows 8/8.1.
This class is taught in seminar format.
Prerequisites: Experience with Windows.
•
•
•
•
•
•
Windows 8 Start screen
Home screen and tiles
New desktop
Charms bar
Sidebar
Additional Windows 8 features
Microsoft Surface Tablet
If you would like a visual overview of
Office 2013/365, this class is for you. This
seminar will help you feel comfortable with
the new look and feel of Office 2013/365.
Note: If you are a new user of Microsoft
Office or want to learn detailed features of a
particular software, please register for those
specific classes.
This class is taught in seminar format.
Prerequisites: Experience with any
previous version of Microsoft Office.
Registration information–see page 36
Windows 8/8.1 - What’s New (Seminar)
WN8-What’s New
Wed Jan 28
1-3 pm
WN8-What’s New
Mon Mar 23
1-3 pm
Microsoft Office 2013/365 What’s New (Seminar)
$75
$75
Surface tablets are lightweight devices that
keep you connected on the go, making them
a great choice for businesses today that need
versatile, productive, and portable solutions.
Surface uses the Windows 8.1 operating system.
To learn more about using your Surface, take
our Windows 8/8.1 – What’s New seminar.
•
•
•
•
•
•
Landing Page/Start screen
Touch screen interface
File tab/Backstage view
Sharing option - SkyDrive/OneDrive
User modes and live preview
New features
Macintosh OS X Introduction
This course is designed for people who are
new to the Macintosh OS X environment.
Prerequisites: None.
• The Mac OS environment:
the desktop and dock
• Window buttons and options
• Setting up your own filing system
• Creating, moving, and saving files
• Changing system preferences
• What is RAM?
• Universal techniques for working with text
• Searching for files
Registration information–see page 36
Macintosh OS X Introduction
MAC-Intro
Wed Feb 04
1-4 pm
$139
Registration information–see page 36
Microsoft Office 2013/365 - What’s New (Seminar)
MO3-What’s New
Thu Jan 15
1-3 pm
$75
MO3-What’s New
Mon Mar 02
1-3 pm
$75
Microsoft Office 2010 What’s New (Seminar)
If you are a Microsoft Office 2003 user and
would like a visual overview of Office 2010,
this class is for you. This seminar will help
you feel comfortable with the new look and
feel of Office 2010.
Note: If you are a new user of Microsoft
Office or want to learn detailed features of a
particular software, please register for those
specific classes.
This class is taught in seminar format.
Prerequisites: Experience with any
previous version of Microsoft Office.
•
•
•
•
•
•
The Ribbon - “control central”
Contextual tabs
Grouped commands
Galleries
Quick Access Toolbar
Saving and sharing 2010 files
Call 651.221.4722 to get more details about
group classes.
Phone–651.221.4722  Web–comped.smm.org
7
ACCOUNTING
QuickBooks
QuickBooks is a popular financial
management software. Use it to pay bills,
print checks, and track expenses.
Part 1 - Introduction
Prerequisites: Macintosh or Windows
Introduction or equivalent experience.
DATABASE MANAGEMENT
QuickBooks
QBK-Part 1
QBK-Part 2
QBK-Part 1
QBK-Part 2
QBK-Part 3
QBK-Part 4
• QuickBooks and accounting basics
• Understanding QuickBooks lists, forms, reports
• Chart of accounts
• Items list
• Customers, vendors, and employees
• Checks, bills, and invoices
• Balance sheets and income statements
Part 2 - Customizing for
Your Company
Prerequisites: QuickBooks Part 1 or
equivalent experience.
•
•
•
•
•
•
Setting up a new company
Defining preferences
Revising/Finalizing key lists
Sales receipts, credit memos, credit cards
Reconciling bank accounts
Sales reports
Part 3 - Advanced Features
Prerequisites: QuickBooks Parts 1 and 2 or
equivalent experience.
•
•
•
•
•
•
Inventory management
Sales and use taxes
Estimates and progress invoicing
Time cards and paychecks
Job costing
Time and job reports
Part 4 - Planning Payroll and
Tax Preparation
Prerequisites: QuickBooks Parts 1, 2, and 3
or equivalent experience.
•
•
•
•
•
•
Setting up payroll
Payroll tax liabilities
Payroll tax reports/W-2s
Budgets and projections
Setting up multiple users
Accountant copies and backups
Registration information–see page 36
8
Check our website for additional classes and schedules
Tue Jan 27
Tue Jan 27
Tue Mar 17
Tue Mar 17
Tue Mar 31
Tue Mar 31
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$139
$139
$139
$139
$139
$139
Database Basics (Seminar)
This seminar explores the basics of
databases and helps create a foundation for
your database work.
This class is taught in seminar format.
Prerequisites: None
•
•
•
•
•
What is a database?
Identifying database parts
Creating tables and organizing data
Using queries, forms, and reports
Designing relational databases
Registration information–see page 36
Database Basics (Seminar)
DBS-Data Basics
Wed Jan 07
DBS-Data Basics
Wed Mar 11
9-11 am
9-11 am
$75
$75
DATABASE MANAGEMENT
Crystal Reports
Crystal Reports works with nearly
any database to produce sophisticated,
professional reports.
Part 1 - Introduction
Prerequisites: Windows Introduction or
equivalent experience.
Recommended: Working knowledge of
your database software or the Database
Basics Seminar or equivalent experience.
•
•
•
•
Introduction to database reporting
Formatting objects
Sorting and grouping
Exporting
Part 2 - Introduction
Prerequisites: Crystal Reports Part 1 and
experience creating custom reports or
equivalent experience.
•
•
•
•
Formulas
Record selection
Section formatting
Other report layouts
Part 3 - Intermediate
Prerequisites: Crystal Reports Parts 1 and 2
or equivalent experience.
•
•
•
•
Using variables
Running totals
Conditional formatting
Parameters
Part 4 - Intermediate
Prerequisites: Crystal Reports Parts 1, 2,
and 3 or equivalent experience.
• Subreports
• Advanced crosstabs
• Charting and graphs
Registration information–see page 36
Crystal Reports
CRY-Part 1
Tue Jan 13
CRY-Part 2
Tue Jan 13
CRY-Part 3
Tue Jan 20
CRY-Part 4
Tue Jan 20
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$159
$159
$159
$159
CRY-Part 1
CRY-Part 2
CRY-Part 3
CRY-Part 4
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$159
$159
$159
$159
CRY-Part 1
CRY-Part 2
Thu Feb 26
Thu Feb 26
Wed Apr 01
Wed Apr 01
Wed Apr 08
Wed Apr 08
8-11:45 am
1-4:45 pm
$159
$159
Crystal Reports - FastTrack
In the FastTrack classes, the pace is much
quicker than our standard classes. To decide
if the FastTrack class is right for you, answer
yes or no to the following statements:
When using a computer, I’m...
• one of the first to understand concepts.
• skilled using the mouse, menus, toolbars, etc.
• familiar with relational databases.
• familiar with basic database terms:
tables, queries, records, fields.
If you answered yes to these statements, our
FastTrack class is for you. If you are unsure,
take our standard classes. The FastTrack
classes will not slow down for slow students.
FastTrack - Part 1
This class will cover most of the material
taught in Crystal Reports Parts 1 and 2.
Prerequisites: Yes answers to the above
four statements.
•
•
•
•
•
Formatting objects
Sorting and grouping
Record selection
Formulas
Section formatting
FastTrack - Part 2
This class will cover most of the material
taught in Crystal Reports Parts 3 and 4.
Prerequisites: Crystal Reports Parts 1 and
2 or Crystal Reports FastTrack Part 1 or
equivalent experience.
•
•
•
•
•
Advanced formulas
Using variables
Parameters
Subreports
Charting
Registration information–see page 36
Crystal Reports - FastTrack
CRF-FT Part 1
Thu Jan 22
CRF-FT Part 2
Thu Feb 05
CRF-FT Part 1
CRF-FT Part 2
Thu Mar 19
Thu Mar 26
8-11:45 am
8-11:45 am
8-11:45 am
8-11:45 am
Phone–651.221.4722  Web–comped.smm.org
$229
$229
$229
$229
9
DATABASE MANAGEMENT
Access
2010/2013/365
Microsoft Access is a powerful relational
database program used for storing, organizing,
and manipulating information of any kind.
Note: Topics taught in these classes apply to
versions 2010, 2013, and 365.
Introduction
Prerequisites: Windows Introduction or
equivalent experience.
Recommended: Database Basics Seminar
or equivalent experience.
• Database concepts
(tables, records, fields, relationships)
• Designing and creating tables
• Sorting and filtering data
• Creating relationships
• Introduction to queries, forms, and reports
Access
AC1-Intro
AC1-Queries
AC1-FR1
AC1-FR2
Wed Jan 14
Wed Jan 14
Wed Jan 21
Wed Jan 21
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$159
$159
$159
$159
AC1-Intro
AC1-Queries
AC1-FR1
AC1-FR2
Wed Feb 18
Wed Feb 18
Wed Feb 25
Wed Feb 25
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$159
$159
$159
$159
AC1-Intro
AC1-Queries
AC1-Intro
AC1-Queries
AC1-Intro
AC1-Queries
AC1-FR1
AC1-FR2
AC1-Intro
AC1-Queries
Queries
Prerequisites: Access Introduction or
equivalent experience.
•
•
•
•
Calculation and concatenation queries
Summary queries and parameters
Action queries
Importing data
Forms and Reports - Part 1
Prerequisites: Access Introduction and
Queries or equivalent experience.
• Moving, adding, and aligning controls
• Setting and changing properties
• Adding list boxes, combo boxes,
and buttons
• Section formatting
Forms and Reports - Part 2
Prerequisites: Access Introduction, Queries,
and Forms and Reports Part 1 or equivalent
experience.
•
•
•
•
Creating calculated fields
Building subforms
Working with groups and subtotals
Multicolumn reports
Registration information–see page 36
Wed Feb 04
Wed Feb 04
Mon Mar 09
Mon Mar 09
Thu Apr 02
Thu Apr 02
Thu Apr 16
Thu Apr 16
Mon Apr 20
Mon Apr 20
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$159
$159
$159
$159
$159
$159
$159
$159
$159
$159
Access FastTrack
2010/2013/365
In the FastTrack classes, the pace is much
quicker than our standard classes. To decide
if the FastTrack class is right for you, answer
yes or no to the following statements:
When using a computer, I’m...
• one of the first to understand concepts.
• skilled using the mouse, menus, toolbars, etc.
• familiar with relational databases.
• familiar with basic database terms:
tables, queries, records, fields.
If you answered yes to these statements, our
FastTrack class is for you. If you are unsure,
take our standard classes. The FastTrack
classes will not slow down for slow students.
Note: Topics taught in these classes apply to
versions 2010, 2013, and 365.
Access FastTrack Part 1
2010/2013/365
This class will cover most of the material
taught in Access Introduction and Queries.
Prerequisites: Yes answers to the above
four statements.
Recommended: Database Basics seminar or
equivalent experience.
•
•
•
•
Designing and creating tables
Importing data
Creating relationships
Select and action queries
Access FastTrack Part 2
2010/2013/365
This class will cover most of the material taught
in Access Forms and Reports Part 1 and 2.
Prerequisites: Access Introduction and
Queries or Access FastTrack Part 1 or
equivalent experience.
•
•
•
•
Adding, moving, and aligning controls
Setting and changing properties
Creating calculated fields
Subforms and multicolumn reports
Registration information–see page 36
Access FastTrack
AF1-FT Part 1
Thu Feb 12
AF1-FT Part 2
Thu Feb 26
AF1-FT Part 1
AF1-FT Part 2
10
Check our website for additional classes and schedules
Wed Mar 18
Wed Mar 25
8-11:45 am
8-11:45 am
8-11:45 am
8-11:45 am
$229
$229
$229
$229
DATABASE MANAGEMENT
Access: Advanced Database Design
(Seminar)
Have you been given the task of designing a
new Access database and don’t know where
to begin? Have you inherited a database
nightmare and want to make it better? This
class explores the concepts of relational
database design and normalization in
Access. It is geared toward users familiar
with working in Access but are unsure of
how to put it all together.
This class is taught in seminar format.
Prerequisites: Access Introduction, Queries,
and Forms and Reports Parts 1 and 2 or
equivalent experience.
• The path of perfect database design
• Achieving database normalization
• Using queries to reorganize a database
Registration information–see page 36
Access: Advanced Database Design (Seminar)
AAD-Adv Design Tue Mar 17
9-11 am
$75
SQL Language
SQL is a universal language that interacts
with practically every database program.
SQL can be used within databases like
Access or with web programming languages
like ASP, ColdFusion, and PHP.
This class will cover the basics of coding
your own SQL statements using MySQL.
MySQL is an open-source database
management system.
Part 1 - Introduction
Prerequisites: Working knowledge of your
database software.
Recommended: Database Basics Seminar
or equivalent experience.
•
•
•
•
Retrieval queries
Setting criteria
Sorting and grouping
Joining tables
Part 2 - Introduction
Prerequisites: SQL Language Part 1 or
equivalent experience.
• Union queries
• Inserting, updating, and deleting data
• Creating and removing tables, fields,
and indexes
• Subqueries
Registration information–see page 36
SQL Language
SQL-Part 1
Tue Jan 06
SQL-Part 2
Tue Jan 06
8-11:45 am
1-4:45 pm
$159
$159
SQL-Part 1
SQL-Part 2
8-11:45 am
1-4:45 pm
$159
$159
SQL-Part 1
SQL-Part 2
Mon Feb 02
Mon Feb 02
SQL-Part 1
SQL-Part 2
Mon Mar 23
Mon Mar 23
SQL-Part 1
SQL-Part 2
Wed Mar 04
Wed Mar 04
Thu Apr 09
Thu Apr 09
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$159
$159
$159
$159
$159
$159
Phone–651.221.4722  Web–comped.smm.org
11
DESKTOP PUBLISHING AND DIGITAL IMAGING
Desktop Publishing Fundamentals
For those who are new to desktop
publishing, this class will teach what
everyone should know but few have had
explained in a sensible way.
Students will be working in Windows. Most
topics discussed also apply to Macintosh.
Prerequisites: Macintosh or Windows
Introduction or equivalent experience.
Would you like to add high quality images
to a web page without users suffering
through long downloads? Need to know the
difference between a .gif and .jpg file? Want
to convert or resize a print file for the web?
This class is for you.
Students will be working in Windows. Most
topics discussed also apply to Macintosh.
Prerequisites: Macintosh or Windows
Introduction or equivalent experience.
• Graphic software: Photo editing,
drawing, and layout programs how do they work together?
• Graphic file formats: .eps, .tif, etc. what’s the difference?
• Fonts: PostScript vs. TrueType
• Clip art - buying and using
• Putting it all together
• Graphic file formats: .eps, .tif, .gif, .jpg what’s the difference?
• Convert print graphics for the web
• Resize and crop images
• Learn what works and what doesn’t
• View download times
Registration information–see page 36
Desktop Publishing Fundamentals
DSK-Desktop
Tue Jan 06
8-11:45 am
DSK-Desktop
Wed Mar 18
1-4:45 pm
Web Graphic Fundamentals
Registration information–see page 36
$139
$139
Web Graphic Fundamentals
WGF-Web G
Wed Feb 04
WGF-Web G
Wed Mar 25
8-11:45 am
8-11:45 am
$139
$139
Acrobat
Adobe Acrobat easily converts any documents
you now publish on paper into electronic files.
You can then distribute these files over the
Internet for online viewing or printing.
Students will be working in Windows. Most
topics discussed also apply to Macintosh.
Part 1 - Introduction
Prerequisites: Macintosh or Windows
Introduction or equivalent experience.
• Overview of the Acrobat product family:
Reader, Distiller, Acrobat
• Creating a PDF document
• Viewing and modifying a PDF document
• Customizing Acrobat Distiller’s options
• Adding, deleting, and extracting pages
• Using Acrobat for bookmarks, security,
and controlling how PDF documents open
Part 2 - Intermediate
Prerequisites: Adobe Acrobat Part 1 or
equivalent experience.
•
•
•
•
•
•
Using the Comment and Markup tools
Working with common links
Advanced editing tools
Adding sounds and movies
Creating forms
Scanning directly to a PDF file
Part 3 - Additional Features
Prerequisites: Adobe Acrobat Parts 1 and 2
or equivalent experience.
•
•
•
•
•
PDF document formatting
Additional commenting and reviewing
Creating a slide show
Digital signatures
Exporting options
Part 4 - PDF Accessibility
Does your company have PDF files on your
website? Do you know if these files are
accessible to your entire audience? This
class will focus on creating PDF files that
are accessible to all users.
Prerequisites: Adobe Acrobat Parts 1 and 2
or equivalent experience.
•
•
•
•
•
Accessibility issues
Understanding document structure and tags
Checking current PDFs for accessibility
Working with reading order
Creating accessible forms
Registration information–see page 36
12
Check our website for additional classes and schedules
DESKTOP PUBLISHING AND DIGITAL IMAGING
Acrobat
ACR-Part 1
ACR-Part 2
Tue Jan 13
Tue Jan 13
8-11:45 am
1-4:45 pm
$139
$139
ACR-Part 1
ACR-Part 2
ACR-Part 3
ACR-Part 4
Tue Mar 17
Tue Mar 17
Tue Apr 07
Tue Apr 07
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$139
$139
$139
$139
ACR-Part 1
ACR-Part 2
ACR-Part 3
ACR-Part 4
Mon Feb 09
Mon Feb 09
Mon Feb 23
Mon Feb 23
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$139
$139
$139
$139
Adobe Design Classes
Other classes to consider...
Illustrator - InDesign - Photoshop
See individual class descriptions for details
Premiere Elements
Adobe Premiere Elements is a powerful
and easy-to-use software that allows you to
edit video, audio, and still images on your
computer. Completed movies can then be
optimized for DVD distribution or uploaded
to the Internet.
Note: Premiere Elements and Premiere Pro
are different software products. Though
they share similar concepts, many class
topics focus on features found exclusively in
Premiere Elements.
Part 1 - Introduction
Prerequisites: Windows Introduction or
equivalent experience.
• Importing, managing, and organizing
video clips
• Timeline editing
• Multiple track editing
• Exporting options
Part 2 - Introduction
Prerequisites: Premiere Elements Part 1 or
equivalent experience.
• Advanced editing features
• Transitions and effects
• Creating and animating titles
Registration information–see page 36
Premiere Elements
PRE-Part 1
Mon Jan 26
PRE-Part 2
Mon Jan 26
PRE-Part 1
PRE-Part 2
Mon Mar 23
Mon Mar 23
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$139
$139
$139
$139
Phone–651.221.4722  Web–comped.smm.org
13
DESKTOP PUBLISHING AND DIGITAL IMAGING
Illustrator
Illustrator is the industry leading software
for creating illustrations, logos, or other
graphics for print media or the web.
Features taught in these classes apply to
most versions of Illustrator.
Part 1 - Introduction
Prerequisites: Macintosh or Windows
Introduction or equivalent experience.
•
•
•
•
•
Introduction to vector graphics
Changing views and moving around
Drawing lines and curves
Object and text basics
Mastering the pen tool
Illustrator
ILL-Part 1
ILL-Part 2
ILL-Part 3
ILL-Part 4
ILL-Part 1
ILL-Part 2
ILL-Part 3
ILL-Part 4
$159
$159
$159
$159
Acrobat - InDesign - Photoshop
See individual class descriptions for details
Drawing shapes
Transformations
Making colors
Gradients
Painting tools: blob brush, pencil, smooth
Part 3 - Intermediate
Prerequisites: Illustrator Parts 1 and 2 or
equivalent experience.
Productivity tools
Appearance panel
Artistic text
Distortion tools and live effects
Live paint
Advanced paths
Part 4 - Intermediate
Prerequisites: Illustrator Parts 1, 2, and 3 or
equivalent experience.
•
•
•
•
•
•
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$159
$159
$159
$159
Other classes to consider...
Prerequisites: Illustrator Part 1 or
equivalent experience.
•
•
•
•
•
•
Tue Mar 24
Tue Mar 24
Tue Mar 31
Tue Mar 31
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
Adobe Design Classes
Part 2 - Introduction
•
•
•
•
•
Tue Jan 27
Tue Jan 27
Mon Feb 02
Mon Feb 02
Precision tools
Productivity with layers
Introduction to transparency
Custom brushes
Creating patterns
Combining and dividing shapes
Registration information–see page 36
Photoshop
Adobe Photoshop is a professional image
editing software used to improve, enhance,
and modify photographs.
Features taught in these classes apply to
most versions of Photoshop.
Note: Photoshop and Photoshop Elements
are different software products - please
make sure you sign up for the correct class.
Part 1 - Introduction
Prerequisites: Macintosh or Windows
Introduction or equivalent experience.
•
•
•
•
Learning the tools - how and when to use
Selection techniques
Enhancing and manipulating photos
Understanding size, resolution, color
mode, and file formats
Part 2 - Introduction
Prerequisites: Photoshop Part 1 or
equivalent experience.
•
•
•
•
•
•
Additional selection techniques
Transformations: scale, rotate, skew
Basic use of the History panel
Introduction to layers
Basic color
Rulers, guides, and grids
Part 3 - Intermediate
Prerequisites: Photoshop Parts 1 and 2 or
equivalent experience.
•
•
•
•
•
Advanced selection techniques
Clipping paths
Saving selections
Additional History panel features
Action panel
Part 4 - Special Effects
Prerequisites: Photoshop Parts 1 and 2 or
equivalent experience.
•
•
•
•
Merging multiple images
Filters features
Lighting effects
Removing/replacing backgrounds
Part 5 - Color Adjustments
Prerequisites: Photoshop Parts 1 and 2 or
equivalent experience.
•
•
•
•
•
Working with the Histogram
Color enhancement options
Levels and Curves
Creating duotones
Using adjustment layers
Registration information–see page 36
14
Check our website for additional classes and schedules
DESKTOP PUBLISHING AND DIGITAL IMAGING
Photoshop
PHO-Part 1
PHO-Part 2
PHO-Part 3
PHO-Part 4
PHO-Part 5
Wed Jan 14
Wed Jan 14
Wed Jan 21
Wed Jan 21
Wed Jan 28
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
$159
$159
$159
$159
$159
PHO-Part 1
PHO-Part 2
PHO-Part 3
PHO-Part 4
PHO-Part 5
Mon Mar 09
Mon Mar 09
Mon Mar 16
Mon Mar 16
Mon Mar 23
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
$159
$159
$159
$159
$159
PHO-Part 1
PHO-Part 2
PHO-Part 1
PHO-Part 2
Mon Feb 09
Mon Feb 09
Mon Apr 06
Mon Apr 06
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$159
$159
$159
$159
Adobe Design Classes
Other classes to consider...
Acrobat - Illustrator - InDesign
See individual class descriptions for details
Photoshop Elements
Photoshop Elements is an easy-to-use
editing tool that lets you correct and enhance
photos. Your improved images can be
printed, e-mailed, or placed on the web.
Note: Photoshop Elements and Photoshop
are different software products - please
make sure you sign up for the correct class.
Students will be working in Windows. Most
topics discussed also apply to Macintosh.
Part 1 - Introduction
Prerequisites: Macintosh or Windows
Introduction or equivalent experience.
•
•
•
•
•
Basic tools and panels
Modifying appearances
Touch-up and repairing photos
Cropping and resizing
Special effects
Part 2 - Introduction
Prerequisites: Photoshop Elements Part 1
or equivalent experience.
•
•
•
•
Additional tools
Feathering and filters
Introduction to layers
Advanced special effects
Registration information–see page 36
Photoshop Elements
PHE-Part 1
Wed Feb 04
PHE-Part 2
Wed Feb 04
PHE-Part 1
PHE-Part 2
Wed Apr 15
Wed Apr 15
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$139
$139
$139
$139
Phone–651.221.4722  Web–comped.smm.org
15
DESKTOP PUBLISHING AND DIGITAL IMAGING
InDesign
Adobe InDesign is a sophisticated page
layout software used for professional-level
desktop publishing and design. InDesign
works seamlessly with other Adobe products
like Illustrator and Photoshop.
Features taught in these classes apply to
most versions of InDesign.
Part 1 - Introduction
Prerequisites: Macintosh or Windows
Introduction or equivalent experience.
Recommended: Desktop Publishing
Fundamentals or equivalent experience.
•
•
•
•
Tools and panels
Text, graphics, and frames
Character formatting
Placing text and graphics
Part 2 - Intermediate
Prerequisites: Adobe InDesign Part 1 or
equivalent experience.
•
•
•
•
•
Master pages
Spell checking and Find/Change
Advanced character/paragraph formatting
Rotating text and graphics
Wrapping text around an object
Part 3 - Advanced
Prerequisites: Adobe InDesign Parts 1 and
2 or equivalent experience.
•
•
•
•
•
Pages panel and multiple master pages
Styles
Rules and lines
Library
Setting colors and gradients
Part 4 - Advanced Features
Part 5 - Digital Publishing
Adding Interactive Elements
Using InDesign, it is now possible to move
beyond simple print publications and create
interactive digital documents. Easily add
buttons, insert media, and create hyperlinks.
Features taught in this class apply to
InDesign CS5 or higher.
Prerequisites: Adobe InDesign Parts 1, 2, 3,
and 4 or equivalent experience.
•
•
•
•
•
Creating hyperlinks
Using interactive elements
Adding media
Creating forms
Exporting Interactive PDFs and SWF files
Part 6 - Digital Publishing
Creating and Exporting for
Mobile Devices
If you are creating files specifically for
mobile devices, InDesign has an extensive
set of interactive features. Easily add
slideshows, create scrollable text frames,
embed website data, and more. This class
also shows how InDesign can create
dynamic layouts that can automatically
adjust to fit any mobile device or e-reader.
Features taught in this class apply to
InDesign CS5 or higher.
Prerequisites: Adobe InDesign Parts 1, 2, 3,
4 and 5 or equivalent experience.
•
•
•
•
Creating digital publications
Converting existing print files
Using Liquid Layout Rules
Exporting DPS and EPUB files
Prerequisites: Adobe InDesign Parts 1, 2,
and 3 or equivalent experience.
Part 7 - InDesign PDF Accessibility
Registration information–see page 36
Features taught in this class apply to
InDesign CS5.5 or higher.
•
•
•
•
•
Advanced styles
Drop shadow, feather, and transparency
Tables and layers
Export to a PDF file
Package for printing
InDesign can now create documents that
retain their accessibility features, even when
exported to a PDF. The majority of the PDF
workflow can be executed in InDesign, with
only a few final steps required in Acrobat.
This class will focus on creating PDF files
that are accessible to all users.
Prerequisites: InDesign Parts 1, 2, 3, 4 or
equivalent experience.
•
•
•
•
•
Paragraph Styles and Tags
Images - Alt text and Anchoring
Content order/Articles panel
Working with Bookmarks, Links, TOC
Export options and Acrobat steps
Registration information–see page 36
16
Check our website for additional classes and schedules
InDesign
IND-Part 1
IND-Part 2
IND-Part 3
IND-Part 4
Thu Jan 08
Thu Jan 08
Thu Jan 15
Thu Jan 15
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$159
$159
$159
$159
IND-Part 1
IND-Part 2
IND-Part 3
IND-Part 4
IND-Part 5
IND-Part 6
IND-Part 7
Tue Feb 03
Tue Feb 03
Tue Feb 10
Tue Feb 10
Tue Feb 17
Tue Feb 17
Tue Feb 24
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
$159
$159
$159
$159
$159
$159
$159
IND-Part 1
IND-Part 2
IND-Part 1
IND-Part 2
IND-Part 1
IND-Part 2
IND-Part 3
IND-Part 4
IND-Part 5
IND-Part 6
IND-Part 7
Thu Jan 29
Thu Jan 29
Tue Mar 10
Tue Mar 10
Wed Apr 01
Wed Apr 01
Wed Apr 08
Wed Apr 08
Wed Apr 15
Wed Apr 15
Wed Apr 22
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
$159
$159
$159
$159
$159
$159
$159
$159
$159
$159
$159
Adobe Design Classes
Other classes to consider...
Acrobat - Illustrator - Photoshop
See individual class descriptions for details
DESKTOP PUBLISHING AND DIGITAL IMAGING
InDesign - FastTrack
In the FastTrack classes, the pace is much
quicker than our standard classes. We
will cover most of the material taught in
InDesign Parts 1 and 2. To decide if the
FastTrack class is right for you, answer yes
or no to the following statements:
When using a computer, I’m...
• one of the first to understand new concepts.
• skilled using the mouse, menus, toolbars, etc.
• able to easily highlight text, cut, copy,
and paste.
• familiar with using other layout programs
(PageMaker, QuarkXPress, Publisher) to
create page layout designs.
If you answered yes to these statements, our
FastTrack class is for you. If you are unsure,
take our standard classes. The FastTrack
classes will not slow down for slow students.
Features taught in these classes apply to
most versions of InDesign.
Prerequisites: Yes answers to the above
four statements.
•
•
•
•
•
•
•
•
Text, graphics, and frames
Character formatting
Placing text and graphics
Master pages
Spell checking and Find/Change
Advanced character/paragraph formatting
Rotating text and graphics
Wrapping text around an object
Registration information–see page 36
InDesign - FastTrack
INF-FT
Mon Jan 12
INF-FT
Mon Mar 02
INF-FT
Mon Mar 30
8-11:45 am
8-11:45 am
8-11:45 am
Publisher
2007/2010/2013
Microsoft Publisher is a simple-to-use, allinclusive solution for any kind of desktop
publishing project.
Note: Topics taught in these classes apply to
all versions.
Part 1 - Introduction
Prerequisites: Windows Introduction or
equivalent experience.
Recommended: Desktop Publishing
Fundamentals or equivalent experience.
•
•
•
•
•
Adding and formatting text
Drawing and formatting shapes
Linking text boxes
Page setup and layout guides
Creating templates
Part 2 - Introduction
Prerequisites: Microsoft Publisher Part 1 or
equivalent experience.
•
•
•
•
Master pages
Headers and footers
Advanced character/paragraph formatting
Creating styles
Registration information–see page 36
Publisher
PUB-Part 1
PUB-Part 2
PUB-Part 1
PUB-Part 2
Mon Jan 12
Mon Jan 12
Mon Mar 16
Mon Mar 16
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$139
$139
$139
$139
$229
$229
$229
Phone–651.221.4722  Web–comped.smm.org
17
PRESENTATION GRAPHICS
PowerPoint
2010/2013/365
PowerPoint creates dynamic presentations
by effectively combining text, pictures,
sound, and other media into a slide show
format. Presentations using PowerPoint help
audiences stay focused and retain more.
Note: Topics taught in these classes apply to
versions 2010, 2013, and 365.
Students will be working in Windows. Most
topics discussed also apply to Macintosh.
Part 1 - Introduction
Prerequisites: Macintosh or Windows
Introduction or equivalent experience.
•
•
•
•
•
•
Tools and views
Creating a presentation
Using an outline
Working with text and bullets
Working with graphics and clip art
Masters and templates
Prerequisites: PowerPoint Part 1 or
equivalent experience.
Customizing individual slides
Creating custom templates
Advanced text and graphic commands
Adding organizational charts and tables
Slide show transitions and techniques
Registration information–see page 36
PowerPoint
PP1-Part 1
PP1-Part 2
Thu Jan 08
Thu Jan 08
8-11:45 am
1-4:45 pm
$139
$139
PP1-Part 1
PP1-Part 2
Thu Mar 12
Thu Mar 12
8-11:45 am
1-4:45 pm
$139
$139
PP1-Part 1
PP1-Part 2
PP1-Part 1
PP1-Part 2
18
Wed Feb 11
Wed Feb 11
Tue Apr 14
Tue Apr 14
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
PowerPoint with Pizzazz (Seminar)
In the FastTrack classes, the pace is much
quicker than our standard classes. We
will cover most of the material taught in
PowerPoint Parts 1 and 2. To decide if the
FastTrack class is right for you, answer yes
or no to the following statements:
When using a computer, I’m...
• one of the first to understand new concepts.
• skilled using the mouse, menus, toolbars, etc.
• able to easily highlight text, cut, copy,
and paste.
• experienced with saving, moving,
copying, and deleting files.
If you answered yes to these statements, our
FastTrack class is for you. If you are unsure,
take our standard classes. The FastTrack
classes will not slow down for slow students.
Note: Topics taught in these classes apply to
versions 2010, 2013, and 365.
Students will be working in Windows. Most
topics discussed also apply to Macintosh.
Part 2 - Intermediate
•
•
•
•
•
PowerPoint FastTrack
2010/2013/365
$139
$139
$139
$139
PowerPoint FastTrack
2010/2013/365
Prerequisites: Yes answers to the above
four statements.
•
•
•
•
•
•
Tools and views
Working with text and bullets
Working with graphics and clip art
Adding organizational charts and tables
Masters and templates
Slide show transitions and techniques
Registration information–see page 36
PowerPoint FastTrack
PF1-FT
Mon Jan 26
PF1-FT
Wed Mar 25
Check our website for additional classes and schedules
8-11:45 am
8-11:45 am
$199
$199
Lots of people know how to use PowerPoint,
but how many can use it effectively? What
can you do to separate your PowerPoint
presentations from thousands of others,
while still maintaining a clear focus? This
seminar will discuss the necessary skills to
best grab (and keep) an audience’s attention.
By using real-world examples, students will
learn what all presentations need to have, the
common mistakes to avoid, and how best to
inform and entertain an audience.
This class is taught in seminar format.
Prerequisites: Experience with PowerPoint.
•
•
•
•
Design strategies and techniques
Making the most of the master slides
Effective animation and sound
Common presentation blunders
Registration information–see page 36
PowerPoint with Pizzazz (Seminar)
PPZ-Pizzazz
Mon Feb 02
PPZ-Pizzazz
Thu Apr 02
9-11 am
9-11 am
$75
$75
INFORMATION MANAGEMENT
Outlook
2010/2013/365
Outlook users can easily manage their e-mail
accounts, schedules, appointments, and more.
Let us train your entire staff. Call
651.221.4722 for special group rates.
Note: Topics taught in these classes apply to
versions 2010, 2013, and 365.
Part 1 - Introduction
This is a basic course designed for people
who have little experience using Outlook.
It does not cover advanced features (i.e.,
public folders) or configuration of hardware.
Prerequisites: Windows Introduction or
equivalent experience.
In this class you will be working with
Outlook on an Exchange Server. If you are
using Outlook as a stand-alone application,
some of the topics covered in this class will
not apply to you.
Prerequisites: Outlook Introduction or
equivalent experience.
Registration information–see page 36
OL1-Part 1
OL1-Part 2
Thu Mar 26
Thu Mar 26
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
Note: Topics taught in these classes apply to
versions 2010 and 2013.
Part 1 - Introduction
Note: Topics taught in these classes apply to
versions 2010, 2013, and 365.
Prerequisites: Windows Introduction or
equivalent experience.
Creating a Notebook
Adding and editing notes
Linking content
Organizing and searching
OneNote Introduction
ONT-OneNote
Mon Feb 02
ONT-OneNote
Mon Apr 06
$139
$139
$139
$139
Prerequisites: Windows Introduction or
equivalent experience.
•
•
•
•
•
Designing a form
Form fields and controls
Rules and conditions
Form templates
Submitting and publishing options
Part 2 - Intermediate
Prerequisites: InfoPath Part 1 or equivalent
experience.
1-4 pm
1-4 pm
• Additional input, object, and
container controls
• Formatting and action rules
• Using sections
• Working with data
• Forms and SharePoint form libraries
$95
$95
Lync Introduction
2010/2013/365
Microsoft Lync is a collaboration and
communication software that connects you
to your co-workers. Talk, share, and work
together in real time. Easily access your
contact lists and instant messages. Lync
helps you and your team work together and
stay connected.
Contact tracking
Customizing Outlook
Distribution/Group lists
Out of Office rules
Sharing calendars
Working with public folders
Wed Jan 14
Wed Jan 14
Microsoft InfoPath is a form-creation tool
that helps streamline business processes.
Without writing code, you can design
electronic forms to quickly and costeffectively gather information.
Registration information–see page 36
Part 2 - Intermediate
Outlook
OL1-Part 1
OL1-Part 2
InfoPath 2010/2013
Microsoft OneNote allows users to digitally
organize information, videos, images and
web pages for any kind of project. Whether
developing a new product or planning
a travel itinerary, users can effortlessly
collect information across many different
applications, then manage and search
through the information quickly and easily
using the OneNote interface.
•
•
•
•
• Sending and receiving e-mail
• Creating appointments and events on
the calendar
• Creating contacts, tasks, and notes
•
•
•
•
•
•
OneNote Introduction
2010/2013/365
Registration information–see page 36
InfoPath
INP-Part 1
INP-Part 2
INP-Part 1
INP-Part 2
Thu Jan 22
Thu Jan 22
Wed Mar 25
Wed Mar 25
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$139
$139
$139
$139
Note: Topics taught in these classes apply to
versions 2010, 2013, and 365.
Prerequisites: Windows Introduction or
equivalent experience.
•
•
•
•
•
Setting status and location
Managing contacts
Sending messages
Schedule meetings
Sharing and collaboration
Registration information–see page 36
Lync Introduction
LY1-Lync
Tue Feb 03
LY1-Lync
Tue Apr 07
8-11 am
1-4 pm
$95
$95
Phone–651.221.4722  Web–comped.smm.org
19
INFORMATION MANAGEMENT
SharePoint 2010 - End Users
SharePoint 2013 - End Users
For many organizations, SharePoint has
become a key ingredient in how coworkers
communicate and coordinate together.
As a result, being a valuable participant
on a SharePoint site is often critical to a
team’s success. This class will help take
the mystery out of SharePoint and teach the
skills required to effectively contribute to a
SharePoint site.
SharePoint versions 2010 and 2013 are
offered as separate classes - please make
sure you sign up for the correct version.
Prerequisites: Windows Introduction or
equivalent experience.
•
•
•
•
•
•
Using site navigation
Adding to existing lists
Working with libraries/documents
Switching views
Connecting to Outlook
Participating in Discussion Boards/
Wikis/Blogs
• Using Community Sites
• Setting up profiles
SharePoint 2013 - End Users
SE3-End User
Mon Feb 02
SE3-End User
Mon Apr 06
Microsoft SharePoint sites improve
workplace productivity by providing a place
to capture and share ideas, information,
communications, and documents.
In class, students will learn the skills
required to modify and enhance an existing
SharePoint site, as well as the steps necessary
to create new lists, libraries, and subsites.
SharePoint versions 2010 and 2013 are
offered as separate classes - please make
sure you sign up for the correct version.
Part 1 - Introduction
Prerequisites: Windows Introduction or
equivalent experience.
Registration information–see page 36
SharePoint 2010 - End Users
SE1-End User
Mon Jan 26
SE1-End User
Mon Mar 23
SharePoint 2010 Power Users/Site Owners
SharePoint 2013 Power Users/Site Owners
1-4:45 pm
1-4:45 pm
$139
$139
8-11:45 am
8-11:45 am
$139
$139
• Creating lists/apps: Announcements,
Calendars, Links, Tasks, Contacts
• Customizing the Quick Launch
• Document libraries: uploading, check-in
and out, version history
• Building custom libraries
• Developing sites and subsites
• Customizing pages
• Adding Web Parts
Part 2 - Intermediate
Prerequisites: SharePoint Part 1 or
equivalent experience
•
•
•
•
•
•
•
Additional library options
Creating new views
Surveys and discussion boards
Wikis and blogs
Integrating with Outlook
Requiring check-out in a library
Managing permissions
Registration information–see page 36
20
Check our website for additional classes and schedules
Part 3 - Additional Design Options
Note: SharePoint Designer is required for some
topics covered in class. SharePoint Designer is
offered as a free download from Microsoft.
Prerequisites: SharePoint Parts 1 and 2
or previous experience creating subsites,
custom libraries, new list views, and
working with Web Parts.
• Customizing a subsite as a template
• CSS (Cascading Style Sheets) introduction
• Applying / Modifying Styles to a Site
with CSS
• Creating custom content types
• Other navigation options
Part 4 - Data Management
and Workflows
Note: SharePoint Designer is required for some
topics covered in class. SharePoint Designer is
offered as a free download from Microsoft.
Prerequisites: SharePoint Parts 1, 2, and 3
or equivalent experience.
•
•
•
•
•
•
Creating Site Columns
Importing and relating data
Introduction to workflows
Workflow conditionals and actions
Filtering/Sorting/Grouping in views
Developing list templates
Registration information–see page 36
INFORMATION MANAGEMENT
SharePoint 2010 - Power Users/Site Owners
SH1-Part 1
Tue Jan 20
8-11:45 am
SH1-Part 2
Tue Jan 20
1-4:45 pm
SH1-Part 3
Tue Jan 27
8-11:45 am
SH1-Part 4
Tue Jan 27
1-4:45 pm
SH1-Part 1
SH1-Part 2
SH1-Part 3
SH1-Part 4
SH1-Part 1
SH1-Part 2
SH1-Part 3
SH1-Part 4
Thu Feb 19
Thu Feb 19
Wed Feb 25
Wed Feb 25
Mon Apr 13
Mon Apr 13
Mon Apr 20
Mon Apr 20
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
SharePoint 2013 - Power Users/Site Owners
SH3-Part 1
Tue Jan 06
8-11:45 am
SH3-Part 2
Tue Jan 06
1-4:45 pm
SH3-Part 3
Tue Jan 13
8-11:45 am
SH3-Part 4
Tue Jan 13
1-4:45 pm
SH3-Part 1
SH3-Part 2
Wed Jan 28
Wed Jan 28
8-11:45 am
1-4:45 pm
SH3-Part 1
SH3-Part 2
SH3-Part 3
SH3-Part 4
Wed Feb 18
Wed Feb 18
Mon Feb 23
Mon Feb 23
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
SH3-Part 1
SH3-Part 2
SH3-Part 1
SH3-Part 2
SH3-Part 1
SH3-Part 2
SH3-Part 3
SH3-Part 4
SH3-Part 1
SH3-Part 2
SH3-Part 1
SH3-Part 2
SH3-Part 3
SH3-Part 4
Mon Feb 09
Mon Feb 09
Tue Mar 03
Tue Mar 03
Tue Mar 10
Tue Mar 10
Tue Mar 17
Tue Mar 17
Tue Mar 31
Tue Mar 31
Tue Apr 14
Tue Apr 14
Tue Apr 21
Tue Apr 21
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
$149
SharePoint Designer
SharePoint 2013 What’s New (Seminar)
SharePoint Designer is a powerful editing
tool for customizing your SharePoint
site, creating more effective company
collaboration and productivity.
In SharePoint Designer, many functions are
only able to be modified with complex code.
Because many of our students prefer
using SharePoint without needing to
learn complex code, we have combined
SharePoint Designer into our SharePoint
classes: SharePoint Part 3 and Part 4. These
classes allow you to further enhance your
SharePoint site using built-in features and
simple coding techniques.
If you are a SharePoint user and would like
a visual overview of SharePoint 2013, this
class is for you. In this seminar you will
learn the new ways to share, organize, and
communicate in SharePoint 2013.
Note: This class is for users familiar with
SharePoint. If you are new to SharePoint,
please take the standard SharePoint classes.
This class is taught in seminar format.
Prerequisites: Experience with any
previous version of SharePoint.
•
•
•
•
•
•
SharePoint versions 2010 and 2013 are
offered as separate classes - please make
sure you sign up for the correct version.
Note: SharePoint Designer is required
for some topics covered in these classes.
SharePoint Designer is offered as a free
download from Microsoft.
Navigation enhancements
SharePoint Apps
Organization and Tracking options
Social Computing features
Design Manager
Search Center
Registration information–see page 36
SharePoint Designer has been combined
into our SharePoint Part 3 and Part 4 classes
- see page 20.
SharePoint 2013 - What’s New (Seminar)
SHW-What’s New
Mon Jan 05
1-3 pm
SHW-What’s New
Thu Mar 12
9-11 am
$75
$75
$149
$149
$149
$149
$149
$149
Phone–651.221.4722  Web–comped.smm.org
21
SPREADSHEETS
Excel
2010/2013/365
Use Excel to better collect, organize, and
utilize your data. Excel quickly and simply
calculates totals, finds averages, creates
charts, and more.
Charting
Prerequisites: Excel Introduction or
equivalent experience.
Note: Topics taught in these classes apply to
versions 2010, 2013, and 365.
• Making the following types of charts:
area, line, bar, column, pie
• Adjusting data: axis and scale
• Editing text: fonts, sizes, and color
• Placing charts in other programs
Introduction
PivotTables & Database Features
Prerequisites: Macintosh or Windows
Introduction or equivalent experience.
•
•
•
•
•
•
Navigating the worksheet
Entering and editing data
Manipulating cells, columns, and rows
Basic formatting
Using formulas and functions
Working with AutoFill
Intermediate
Prerequisites: Excel Introduction or
experience developing spreadsheets from
scratch, creating formulas, working with
functions, and knowledge of the AutoFill tool.
•
•
•
•
•
Advanced formatting
Basic styles
Using multiple worksheets
IF statements
3-D cell referencing
Prerequisites: Excel Introduction or
equivalent experience.
•
•
•
•
Creating and editing lists
Sorting lists
Extracting data
PivotTables
Macros
Prerequisites: Excel Introduction and
Intermediate or equivalent experience.
•
•
•
•
•
•
Macro concepts
Macro commands and tools
Recording and writing macros
Documenting macros
Adding macros to menus and buttons
Command macros and function
(user-defined) macros
Registration information–see page 36
Advanced
Prerequisites: Excel Introduction and
Intermediate or equivalent experience.
•
•
•
•
•
Customizing the program
Advanced linking
Consolidating data
Outlining
Protecting your work
Registration information–see page 36
22
Check our website for additional classes and schedules
Excel
EX1-Intro
EX1-Inter
Wed Jan 14
Wed Jan 14
8-11:45 am
1-4:45 pm
$139
$139
EX1-Intro
EX1-Inter
EX1-Chart
EX1-Pivot/Data
Tue Feb 03
Tue Feb 03
Thu Feb 05
Thu Feb 05
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$139
$139
$139
$139
EX1-Intro
EX1-Inter
EX1-Adv
EX1-Macro
EX1-Intro
EX1-Inter
EX1-Intro
EX1-Inter
EX1-Adv
EX1-Macro
EX1-Pivot/Data
EX1-Intro
EX1-Inter
EX1-Chart
EX1-Pivot/Data
EX1-Intro
EX1-Inter
EX1-Intro
EX1-Inter
EX1-Intro
EX1-Inter
EX1-Intro
EX1-Inter
EX1-Chart
EX1-Pivot/Data
EX1-Adv
EX1-Macro
EX1-Intro
EX1-Inter
EX1-Pivot/Data
Thu Jan 22
Thu Jan 22
Thu Jan 29
Thu Jan 29
Mon Feb 09
Mon Feb 09
Wed Feb 18
Wed Feb 18
Wed Feb 25
Wed Feb 25
Thu Feb 26
Tue Mar 03
Tue Mar 03
Tue Mar 10
Tue Mar 10
Wed Mar 11
Wed Mar 11
Thu Mar 19
Thu Mar 19
Wed Apr 01
Wed Apr 01
Mon Apr 06
Mon Apr 06
Thu Apr 09
Thu Apr 09
Mon Apr 13
Mon Apr 13
Mon Apr 20
Mon Apr 20
Wed Apr 22
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
$139
$139
$159
$159
$139
$139
$139
$139
$159
$159
$139
$139
$139
$139
$139
$139
$139
$139
$139
$139
$139
$139
$139
$139
$139
$159
$159
$139
$139
$139
SPREADSHEETS
Excel FastTrack
2010/2013/365
Excel: Working the Workbook
In the FastTrack classes, the pace is much
quicker than our standard classes. We will
cover most of the material taught in Excel
Introduction and Intermediate. To decide if
the FastTrack class is right for you, answer
yes or no to the following statements:
When using a computer, I’m...
• one of the first to understand new concepts.
• skilled using the mouse, menus, toolbars, etc.
• able to easily highlight text, cut, copy,
and paste.
• experienced with saving, moving,
copying, and deleting files.
If you answered yes to these statements, our
FastTrack class is for you. If you are unsure,
take our standard classes. The FastTrack
classes will not slow down for slow students.
Note: Topics taught in these classes apply to
versions 2010, 2013, and 365.
Do you feel like your data is trapped in
Excel? Is it time to move beyond simple
rows and columns and into more specialized
and stylized formats? Take control of
your workbook. Utilize PivotTables and
PivotChart reports. Learn more efficient
ways to mine your data. Taking this class
will ensure that your spreadsheets don’t
become “dreadsheets”!
Prerequisites: Experience with Excel.
• Creating functional and effective data
• Advanced data functions
• Basic PivotTables and PivotCharts
Registration information–see page 36
Excel: Working the Workbook
EWK-Workbook
Tue Feb 10
EWK-Workbook
Thu Apr 16
9-11 am
9-11 am
$75
$75
Students will be working in Windows. Most
topics discussed also apply to Macintosh.
Excel FastTrack
2010/2013/365
Prerequisites: Yes answers to the above
four statements.
•
•
•
•
•
Formulas and functions
Printing features
Using multiple worksheets
IF statements
3-D cell referencing
Registration information–see page 36
Excel FastTrack
EF1-FT
Mon Jan 05
EF1-FT
Thu Feb 12
EF1-FT
Mon Mar 23
EF1-FT
Tue Apr 07
1-4:45 pm
8-11:45 am
8-11:45 am
8-11:45 am
$199
$199
$199
$199
Phone–651.221.4722  Web–comped.smm.org
23
PROCESS MANAGEMENT
PROJECT PLANNING
Visio 2010/2013
Project 2010/2013
Visio allows you to design sophisticated
diagrams for organizational charts, floor
plans, process flow management, and more.
Note: Topics taught in these classes apply to
versions 2010 and 2013.
Part 1 - Introduction
Prerequisites: Windows Introduction or
equivalent experience.
Prerequisites: Macintosh or Windows
Introduction or equivalent experience.
Part 2 - Intermediate
Prerequisites: Visio Part 1 or equivalent
experience.
• Creating templates, stencils, and
customized shapes
• Organizational charts
• Working with layers
• Background pages
Visio
VIS-Part 1
VIS-Part 2
Tue Jan 06
Tue Jan 06
8-11:45 am
1-4:45 pm
$139
$139
VIS-Part 1
VIS-Part 2
Tue Mar 24
Tue Mar 24
8-11:45 am
1-4:45 pm
$139
$139
8-11:45 am
1-4:45 pm
•
•
•
•
•
•
•
Description of screen elements
Entering tasks
Linking tasks
Changing task relationships
Adding lag time
Deadlines and constraints
Critical paths
Part 2 - Introduction
Outlines, Resources, and Reports
Registration information–see page 36
Wed Mar 04
Wed Mar 04
Note: Topics taught in these classes apply to
versions 2010 and 2013.
Part 1 - Introduction
Setting Up a Plan
• Fundamentals of the program
• Basic text and shape formatting
• Creating process flow drawings
VIS-Part 1
VIS-Part 2
Whether moving your business to a new
location, developing a product, or outlining
a construction plan, Microsoft Project allows
users to manage tasks, track deadlines, and
assign resources.
$139
$139
Prerequisites: Microsoft Project Part 1 or
equivalent experience.
•
•
•
•
•
•
•
Working with views
Creating outline levels
Entering resources
Assigning resources
Working with cost
Printing
Reports
Registration information–see page 36
24
Check our website for additional classes and schedules
Part 3 - Intermediate
Managing a Plan
Prerequisites: Microsoft Project Parts 1 and
2 or equivalent experience.
•
•
•
•
•
•
Filtering
Baselining
Adjusting tasks and resource assignments
Entering actuals
Customizing tables
Using the Organizer
Part 4 - Intermediate
Sharing Plans and
Creating Master Plans
Prerequisites: Microsoft Project Parts 1, 2,
and 3 or equivalent experience.
• Importing and exporting data to
other programs
• Subprojects
• Sharing resources across plans
• Customizing reports
Registration information–see page 36
Project
PR1-Part 1
PR1-Part 2
PR1-Part 3
PR1-Part 4
Wed Jan 21
Wed Jan 21
Wed Jan 28
Wed Jan 28
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$159
$159
$159
$159
PR1-Part 1
PR1-Part 2
PR1-Part 3
PR1-Part 4
Thu Apr 09
Thu Apr 09
Thu Apr 16
Thu Apr 16
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$159
$159
$159
$159
PR1-Part 1
PR1-Part 2
Tue Mar 03
Tue Mar 03
8-11:45 am
1-4:45 pm
$159
$159
WORD PROCESSING
Word
2010/2013/365
Word allows users to create, edit, and
quickly format text documents of all types.
Produce letters, labels, multicolumn layouts,
and more.
Note: Topics taught in these classes apply to
versions 2010, 2013, and 365.
Students will be working in Windows. Most
topics discussed also apply to Macintosh.
Part 1 - Introduction
Prerequisites: Macintosh or Windows
Introduction or equivalent experience.
• Working with text: entering, selecting,
editing, cut, copy, and paste
• Basic formatting: margins, paragraphs,
fonts, and type sizes
• Creating bulleted and numbered lists
Part 2 - Intermediate
Prerequisites: Word Part 1 or equivalent
experience.
•
•
•
•
•
•
•
Find and Replace
Format Painter
Headers and footers
Customizing bullets and numbers
Tabs: setting, moving, and changing
Working with tables
Setting up columns
Part 3 - Advanced
Prerequisites: Word Parts 1 and 2 or
equivalent experience.
• Customizing AutoCorrect and
AutoFormat
• Adding graphics
• Using styles
• Table of Contents
• Working with sections
Part 5 - Word Accessibility
and PDFs
Using Word, it is now possible to create
documents that are accessible and will retain
accessibility when exporting to a PDF. In
this class you will learn the features and
steps for creating accessible files.
Prerequisites: Word Parts 1, 2, and 3 or
equivalent experience.
•
•
•
•
•
Accessibility features and issues
Understanding structure and language
Working with styles and tags
Alternate text and order
Converting Word files into accessible PDFs
Registration information–see page 36
Word
WD1-Part 1
WD1-Part 2
WD1-Part 3
WD1-Part 4
WD1-Part 1
WD1-Part 2
WD1-Part 3
WD1-Part 4
WD1-Part 5
WD1-Part 1
WD1-Part 2
WD1-Part 1
WD1-Part 2
WD1-Part 3
WD1-Part 4
WD1-Part 5
Thu Jan 29
Thu Jan 29
Thu Feb 05
Thu Feb 05
Tue Feb 10
Tue Feb 10
Tue Feb 17
Tue Feb 17
Tue Feb 24
Wed Mar 11
Wed Mar 11
Wed Apr 08
Wed Apr 08
Wed Apr 15
Wed Apr 15
Wed Apr 22
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
1-4:45 pm
$139
$139
$139
$139
$139
$139
$139
$139
$139
$139
$139
$139
$139
$139
$139
$139
Word FastTrack
2010/2013/365
In the FastTrack classes, the pace is much
quicker than our standard classes. We will
cover most of the material taught in Word
Parts 1 and 2. To decide if the FastTrack
class is right for you, answer yes or no to the
following statements:
When using a computer, I’m...
• one of the first to understand new concepts.
• skilled using the mouse, menus, toolbars, etc.
• able to easily highlight text, cut, copy,
and paste.
• experienced with saving, moving,
copying, and deleting files.
If you answered yes to these statements, our
FastTrack class is for you. If you are unsure,
take our standard classes. The FastTrack
classes will not slow down for slow students.
Note: Topics taught in these classes apply to
versions 2010, 2013, and 365.
Students will be working in Windows. Most
topics discussed also apply to Macintosh.
Word FastTrack
2010/2013/365
Prerequisites: Yes answers to the above
four statements.
•
•
•
•
•
Formatting paragraphs and documents
Find and Replace
Text selection shortcuts
Tabs, columns, and tables
Headers and footers
Registration information–see page 36
Word FastTrack
WF1-FT
Wed Jan 21
WF1-FT
Wed Mar 18
1-4:45 pm
8-11:45 am
$199
$199
Part 4 - Mail Merge, Macros,
and More
Prerequisites: Word Parts 1 and 2 or
equivalent experience.
•
•
•
•
•
•
Using mail merge
Mailing labels
Printing envelopes
Tracking revisions
Macro basics
Working with templates
Registration information–see page 36
Phone–651.221.4722  Web–comped.smm.org
25
INTERNET BASICS
WEB DEVELOPMENT AND DESIGN
Internet and E-Mail Introduction
Internet and e-mail skills are critical to
communication. The Internet is filled with
useful information for those who can make
sense of the maze and e-mail has become the
typical method for business communication.
This class will take you through the ins
and outs of browsing the Internet as well as
writing and sending an e-mail.
Students will be working in Windows. Most
topics discussed also apply to Macintosh.
Prerequisites: Experience using a computer.
•
•
•
•
•
•
Feeling comfortable with the Internet
Searching for the information you want
Returning to your favorite places
Sending and receiving e-mail
E-mail attachments
Deleting unwanted e-mail
Registration information–see page 36
Internet and E-Mail Introduction
IEM-Inter/E-mail
Thu Feb 19
1-4 pm
Job Hunting Online (Free Seminar)
Website Basics (Seminar)
This seminar is free, but registration is required.
Prerequisites: None.
The Internet is filled with websites dedicated
to helping you find a job, but which site is
right for you? This class cuts through the
clutter and focuses on the best places to find
jobs, post resumes, and search for new careers.
This class is taught in seminar format.
Prerequisites: Experience with web
browsing and searching.
•
•
•
•
Online tools for a job search
Finding quality job sites
Best job search methods
Submitting resumes online
$75
•
•
•
•
Essential design considerations
Choosing a hosting service
Navigation and layout
Selecting the right tool to build your site
Registration information–see page 36
Website Basics (Seminar)
WSB-Website
Wed Jan 21
WSB-Website
Tue Mar 10
Registration information–see page 36
Job Hunting Online (Free Seminar)
JHO-Job
Thu Jan 29
1-4 pm
JHO-Job
Tue Mar 24
1-4 pm
Are you interested in learning what is
necessary to create your own website?
Not sure where to start? This seminar will
demonstrate what’s needed to build and
maintain a website.
Free
Free
1-4 pm
1-4 pm
$75
$75
Web Graphic Fundamentals
Would you like to add high quality images
to a web page without users suffering
through long downloads? Need to know the
difference between a .gif and .jpg file? Want
to convert or resize a print file for the web?
This class is for you.
Students will be working in Windows. Most
topics discussed also apply to Macintosh.
Prerequisites: Macintosh or Windows
Introduction or equivalent experience.
• Graphic file formats: .eps, .tif, .gif, .jpg what’s the difference?
• Convert print graphics for the web
• Resize and crop images
• Learn what works and what doesn’t
• View download times
Registration information–see page 36
Web Graphic Fundamentals
WGF-Web G
Wed Feb 04
WGF-Web G
Wed Mar 25
26
Check our website for additional classes and schedules
8-11:45 am
8-11:45 am
$139
$139
WEB DEVELOPMENT AND DESIGN
Acrobat PDF Accessibility
Word PDF Accessibility
Note: This class is the final class in our Acrobat
series. If you are new to Acrobat, please see
page 12 for the complete class series.
Note: This class is the final class in our Word
series. If you are new to Word, please see
page 25 for the complete class series.
Students will be working in Windows. Most
topics discussed also apply to Macintosh.
Students will be working in Windows. Most
topics discussed also apply to Macintosh.
Part 4 - PDF Accessibility
Part 5 - Word PDF Accessibility
Does your company have PDF files on your
website? Do you know if these files are
accessible to your entire audience? This
class will focus on creating PDF files that
are accessible to all users.
Prerequisites: Adobe Acrobat Parts 1 and 2
or equivalent experience.
•
•
•
•
•
Accessibility issues
Understanding document structure and tags
Checking current PDFs for accessibility
Working with reading order
Creating accessible forms
Registration information–see page 36
Acrobat Part 4 - PDF Accessibility
ACR-Part 4
Mon Feb 23
1-4:45 pm
ACR-Part 4
Tue Apr 07
1-4:45 pm
Using Word, it is now possible to create
documents that are accessible and will retain
accessibility when exporting to a PDF. In
this class you will learn the features and
steps for creating accessible files.
Features taught in this class apply to
InDesign CS5.5 or higher.
Part 7 - InDesign PDF Accessibility
Accessibility features and issues
Understanding structure and language
Working with styles and tags
Alternate text and order
Converting Word files into accessible PDFs
Registration information–see page 36
$139
$139
Additional Acrobat classes - see page 12.
Word Part 5 - PDF Accessibility
WD1-Part 5
Tue Feb 24
WD1-Part 5
Wed Apr 22
1-4:45 pm
1-4:45 pm
InDesign can now create documents that
retain their accessibility features, even when
exported to a PDF. The majority of the PDF
workflow can be executed in InDesign, with
only a few final steps required in Acrobat.
This class will focus on creating PDF files
that are accessible to all users.
Note: This class is the final class in our
InDesign series. If you are new to InDesign,
please see page 16 for the complete class series.
Prerequisites: Word Parts 1, 2, and 3 or
equivalent experience.
•
•
•
•
•
InDesign PDF Accessibility
$139
$139
Additional Word classes - see page 25.
Prerequisites: InDesign Parts 1, 2, 3, 4 or
equivalent experience.
•
•
•
•
•
Paragraph Styles and Tags
Images - Alt text and Anchoring
Content order/Articles panel
Working with Bookmarks, Links, TOC
Export options and Acrobat steps
Registration information–see page 36
InDesign Part 7 - PDF Accessibility
IND-Part 7
Tue Feb 24
8-11:45 am
IND-Part 7
Wed Apr 22
8-11:45 am
$159
$159
Additional InDesign classes - see page 16.
Phone–651.221.4722  Web–comped.smm.org
27
WEB DEVELOPMENT AND DESIGN
Social Media for Business
Introduction (Seminar)
What are the different social media options
and how will they help your business? Learn
the most common methods for reaching out
to your audience. This seminar will show the
benefits of social media and discover the best
approach to help your company “go viral.”
This class is taught in seminar format.
Prerequisites: None.
Facebook Introduction
(Free Seminar)
Wondering what’s up with Facebook?
It’s never too late to participate in social
networking! This seminar will help you
overcome your Facebook fears and begin
networking with millions of users from
around the world.
This seminar is free, but registration is required.
This class is taught in seminar format.
• Social media options blogs, networks, multimedia
• Twitter, LinkedIn, and Facebook overview
• Building a relationship with your customers
• Syncing your social media communications
• Monitoring comments about your company
• Keeping up with social media trends
Prerequisites: None.
Registration information–see page 36
Registration information–see page 36
Social Media for Business Introduction (Seminar)
SMA-Media
Mon Jan 05
1-4 pm
$75
SMA-Media
Mon Mar 02
1-4 pm
$75
LinkedIn Introduction
• Overview of Facebook
• How to create a profile
• Connecting to friends, family, businesses,
and the community
• Joining networks
• Security and privacy settings
Facebook Introduction (Free Seminar)
FBI-Facebook
Wed Jan 07
1-4 pm
FBI-Facebook
Wed Mar 04
1-4 pm
Free
Free
Facebook: For Business Introduction
(Seminar)
Facebook isn’t just for keeping tabs on
friends and family; it can also be a highly
effective business tool. It’s a great way to
market your products and connect with
customers. Facebook drives the “viral
spread” of information through a network
of friends. This seminar will teach the
necessary steps to start using Facebook to
successfully promote your business.
This class is taught in seminar format.
Prerequisites: Facebook Introduction
Seminar or equivalent experience.
•
•
•
•
•
•
Understanding Facebook’s business options
Establishing a business account
Creating a Facebook page
Customizing your URL
Options for engaging your customers
Additional features
Registration information–see page 36
Facebook: For Business Introduction (Seminar)
FBU-Facebook/Bus Wed Jan 14
1-4 pm
FBU-Facebook/Bus Wed Mar 11
1-4 pm
28
Check our website for additional classes and schedules
$75
$75
Have you received a request to join
LinkedIn from a friend or associate?
Did you join and then think, “Okay, I’m
LinkedIn... now what?” If you did, you’re
not alone. This class will cover what all the
buzz is about and how you can make the
most of your membership. LinkedIn is a
powerful tool for finding a job, locating new
clients, and growing your business.
Students will be working in Windows. Most
topics discussed also apply to Macintosh.
Prerequisites: Macintosh or Windows
Introduction or equivalent experience.
•
•
•
•
•
•
Set up your LinkedIn account
Create a power-packed profile
Add colleagues to your network
Join groups and follow companies
Search for jobs
Set your privacy & settings
Registration information–see page 36
LinkedIn Introduction
LNK-Linked
Mon Feb 02
LNK-Linked
Mon Mar 30
1-4 pm
1-4 pm
$75
$75
WEB DEVELOPMENT AND DESIGN
Twitter for Business Introduction
(Seminar)
Twitter is a free and popular social networking
and microblogging service that enables users
to send and read messages as well as create,
discover, and share ideas. Not only is it an
effective way to keep up-to-date with the
latest news, it can also help in the promotion
of your business. This seminar will teach you
the steps necessary to start using Twitter.
This class is taught in seminar format.
Twitter overview
Setting up a Twitter account
Searching out and following others
Understanding the lingo
Sending a tweet
Best uses of Twitter
Blogging For Business Using WordPress
BBW-Blog
Wed Jan 21
8-11 am
BBW-Blog
Mon Mar 16
8-11 am
$75
$75
WordPress Designing Your Website
WordPress is not just for blogging anymore!
You can use WordPress to quickly and
easily set up and manage your own website.
This class will get your site up and running
quickly, and give you the tools to take
control of the look and feel of your site.
Part 1 - Introduction
Prerequisites: Familiarity with the web.
HTML and CSS knowledge helpful.
•
•
•
•
Set up your home page
Create a main menu
Use widgets to customize a side bar
Work with plug-ins to add extra features
Part 2 - Intermediate
Registration information–see page 36
Registration information–see page 36
Twitter for Business Introduction (Seminar)
TWR-Twitter
Mon Jan 26
8-11 am
TWR-Twitter
Wed Mar 18
8-11 am
Have you heard the buzz about blogging and
wondered how your business or organization
could benefit from having a blog? If so, this is
the course for you. Using WordPress, you will
learn the step-by-step procedures for creating
and launching your own successful blog.
Prerequisites: Macintosh or Windows
Introduction or equivalent experience.
• Using WordPress to create your blog
• Setting up and organizing your blog
• Turning your blog into a search
engine magnet
• Creating keyword-relevant links
• Avoiding blogger’s block
Prerequisites: None
•
•
•
•
•
•
Blogging For Business
Using WordPress
$75
$75
Prerequisites: WordPress Part 1 or
equivalent experience.
•
•
•
•
Customize your site
Choose a theme framework
Set up your page layout
Change look and feel
Registration information–see page 36
WordPress - Designing Your Website
WPR-Part 1
Thu Feb 05
8-11:45 am
WPR-Part 2
Thu Feb 05
1-4:45 pm
$139
$139
WPR-Part 1
WPR-Part 2
$139
$139
WPR-Part 1
WPR-Part 2
Mon Mar 02
Mon Mar 02
Thu Apr 23
Thu Apr 23
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
Phone–651.221.4722  Web–comped.smm.org
$139
$139
29
WEB DEVELOPMENT AND DESIGN
HTML
HyperText Markup Language (HTML) is the
code used to create web pages and control
how text, images, and links will be displayed
in a web browser.
Note: To learn to build mobile websites
and apps, consider our Mobile Web
Basics - Websites & Apps, JavaScript,
and jQuery classes.
Students will be working in Windows. Most
topics discussed also apply to Macintosh.
Part 5 - Page Layout with Tables
Prerequisites: HTML Parts 1, 2, 3, and 4 or
equivalent experience.
• Creating tables
• Templates
• SSI (Server Side Includes)
Part 6 - Page Layout with
Cascading Style Sheets
Prerequisites: HTML Parts 1, 2, 3, 4, and 5
or equivalent experience.
Part 1 - Introduction
• Resizing - liquid vs. elastic
• Positioning boxes
• Fixing layout display differences
Recommended: Website Basics Seminar
and Web Graphics Fundamentals or
equivalent experience.
Registration information–see page 36
Prerequisites: Macintosh or Windows
Introduction or equivalent experience.
•
•
•
•
•
Basic HTML tags
Lists
Adding titles for search engines
Creating hyperlinks
Adding images
Learn to build sites that can automatically
adapt to varied end user's devices.
Responsive Web Design - see page 32.
Part 2 - Intermediate
Prerequisites: HTML Part 1 or equivalent
experience.
•
•
•
•
Standards for effective page formatting
Background color
Publishing
External styles
Part 3 - Cascading Style Sheets
Introduction
Prerequisites: HTML Parts 1 and 2 or
equivalent experience.
•
•
•
•
Local styles
Internal styles
External styles
Creating classes
Part 4 - Cascading Style Sheets
Intermediate
Prerequisites: HTML Parts 1, 2, and 3 or
equivalent experience.
•
•
•
•
Creating rollover buttons
Creating pop-ups
Drop-down menus with lists
Page layout basics using CSS
Registration information–see page 36
30
Check our website for additional classes and schedules
HTML
HTM-Part 1
HTM-Part 2
HTM-Part 3
HTM-Part 4
HTM-Part 5
HTM-Part 6
Tue Jan 13
Tue Jan 13
Tue Jan 20
Tue Jan 20
Tue Jan 27
Tue Jan 27
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$139
$139
$139
$139
$139
$139
HTM-Part 1
HTM-Part 2
HTM-Part 3
HTM-Part 4
HTM-Part 5
HTM-Part 6
Thu Mar 12
Thu Mar 12
Thu Mar 19
Thu Mar 19
Thu Mar 26
Thu Mar 26
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$139
$139
$139
$139
$139
$139
HTM-Part 1
HTM-Part 2
HTM-Part 1
HTM-Part 2
Tue Feb 17
Tue Feb 17
Tue Apr 07
Tue Apr 07
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$139
$139
$139
$139
WEB DEVELOPMENT AND DESIGN
Dreamweaver
Dreamweaver allows users to create and
manage a professional website without the
need to learn any complex programming
or code.
Features taught in these classes apply to
most versions of Dreamweaver.
Note: To learn to build mobile websites
and apps, consider our Mobile Web
Basics - Websites & Apps, JavaScript,
and jQuery classes.
Students will be working in Windows. Most
topics discussed also apply to Macintosh.
Part 1 - Introduction
Prerequisites: Macintosh or Windows
Introduction or equivalent experience.
Recommended: HTML Parts 1 & 2,
Website Basics Seminar, and Web Graphic
Fundamentals or equivalent experience.
•
•
•
•
•
Creating basic web pages
Standards for formatting text
Adding titles for search engines
Working with images and image maps
Creating links
Part 3 - Layout with Tables
Prerequisites: Dreamweaver Parts 1 and 2
or equivalent experience.
•
•
•
•
Using tables for layout
Inserting rollover images
Creating navigation bars
Creating and managing templates
Dreamweaver
DRM-Part 1
DRM-Part 2
DRM-Part 3
DRM-Part 4
Thu Jan 22
Thu Jan 22
Thu Jan 29
Thu Jan 29
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$159
$159
$159
$159
DRM-Part 1
DRM-Part 2
DRM-Part 3
DRM-Part 4
Tue Mar 24
Tue Mar 24
Tue Mar 31
Tue Mar 31
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$159
$159
$159
$159
DRM-Part 1
DRM-Part 2
Part 4 - Layout with Cascading
Style Sheets (CSS)
Thu Feb 19
Thu Feb 19
8-11:45 am
1-4:45 pm
$159
$159
Prerequisites: Dreamweaver Parts 1, 2, and
3 or equivalent experience.
•
•
•
•
•
•
External, internal, and inline style sheets
Tag and class styles
Box model and properties
Using CSS and div tag for layout
Positioning: static, relative, absolute, fixed
Changing Z-index
Registration information–see page 36
Learn to build sites that can automatically
adapt to varied end user's devices.
Responsive Web Design - see page 32.
Part 2 - Intermediate
Prerequisites: Dreamweaver Part 1 or
equivalent experience.
•
•
•
•
•
Page properties
Site management: local and remote
External, internal, and inline style sheets
Tag and class styles
Formatting text and images with CSS
Registration information–see page 36
Phone–651.221.4722  Web–comped.smm.org
31
WEB DEVELOPMENT AND DESIGN
Search Engine Optimization
(Seminar)
Scoring high in search engine results can
determine the success of your website and can
mean more visitors, customers, and revenue.
This seminar teaches you the basics of Search
Engine Optimization (SEO) and how to help
your website become search engine friendly.
You will learn how search engines work, the
criteria used, and proven techniques to raise
your website’s search ranking.
This class is taught in seminar format.
Prerequisites: None.
•
•
•
•
•
Search engine overview
Site design and set up issues
Selecting keywords and search phrases
Using tags wisely
Good copywriting
Registration information–see page 36
Search Engine Optimization (Seminar)
SEO-Search
Tue Feb 17
1-4 pm
SEO-Search
Tue Apr 07
1-4 pm
$75
$75
Websites - Responsive Web Design
Introduction
As more people are using mobile devices
to view websites, it is important to make
sure your site provides an easy reading and
navigation experience no matter what kind
of device they are using. Responsive Web
Design (RWD) allows you to create sites that
can adapt automatically to the needs of the
end user’s device. In this class, you will learn
how to build sites that take full advantage of
the RWD approach to designing.
Prerequisites: Significant experience with
CSS for layout.
•
•
•
•
Designing for multiple devices
Creating a flexible grid
Sizing images
CSS Styles for multiple device types
Registration information–see page 36
Websites - Responsive Web Design Introduction
RD1-RWD Intro Mon Jan 26
8-11:45 am $139
RD1-RWD Intro Mon Mar 30
8-11:45 am $139
Captivate
Captivate lets you create software
demonstrations, quizzes, and tutorials
with ease. Options include adding audio,
captions, and importing movie files.
Tutorials made with Captivate can be used
in eLearning applications, as part of a Flash
movie, on a website, or on a CD.
Part 1 - Introduction
Prerequisites: Familiarity with PowerPoint,
Word, or Excel.
•
•
•
•
•
Recording a movie
Using different recording modes
Editing timeline objects
Adding sound
Exporting options
Part 2 - Intermediate
Prerequisites: Captivate Part 1 or
equivalent experience.
• Importing video, Flash, and PowerPoint files
• Inserting buttons and other
interactive elements
• Customizing skins
• Branching movies into different paths
• Inserting quizzes
Registration information–see page 36
Captivate
CAP-Part 1
CAP-Part 2
CAP-Part 1
CAP-Part 2
32
Check our website for additional classes and schedules
Wed Feb 11
Wed Feb 11
Tue Apr 07
Tue Apr 07
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$159
$159
$159
$159
WEB DEVELOPMENT AND DESIGN
Premiere Elements
Mobile Website Design (Seminar)
Note: Premiere Elements and Premiere Pro
are different software products. Though
they share similar concepts, many class
topics focus on features found exclusively in
Premiere Elements.
Note: To learn to build mobile websites
and apps, consider our Mobile Web
Basics - Websites & Apps, JavaScript,
and jQuery classes.
Adobe Premiere Elements is a powerful
and easy-to-use software that allows you to
edit video, audio, and still images on your
computer. Completed movies can then be
optimized for DVD distribution or uploaded
to the Internet.
Part 1 - Introduction
In today’s mobile society, your website
needs to work well on all kinds of devices,
including smartphones, tablets, and desktop
PCs. This seminar will help you learn how
to make your website more mobile device
friendly.
This class is taught in seminar format.
Prerequisites: Familiarity with basic web
page design.
Prerequisites: Windows Introduction or
equivalent experience.
• Importing, managing, and organizing
video clips
• Timeline editing
• Multiple track editing
• Exporting options
•
•
•
•
•
•
Part 2 - Introduction
Registration information–see page 36
Prerequisites: Premiere Elements Part 1 or
equivalent experience.
• Advanced editing features
• Transitions and effects
• Creating and animating titles
How mobile devices vary
Adapting an existing site for mobile users
Designing for a small screen
Using a mobile emulator for testing
Detecting device types
Mobile device conventions
Mobile Website Design (Seminar)
MWB-Mobile
Mon Jan 26
MWB-Mobile
Mon Mar 16
1-4 pm
1-4 pm
$75
$75
Learn to build Mobile Websites & Apps see page 34.
Registration information–see page 36
Premiere Elements
PRE-Part 1
Mon Jan 26
PRE-Part 2
Mon Jan 26
PRE-Part 1
PRE-Part 2
Mon Mar 23
Mon Mar 23
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$139
$139
$139
$139
Phone–651.221.4722  Web–comped.smm.org
33
WEB DEVELOPMENT AND DESIGN
Mobile Web Basics Websites & Apps
JavaScript
This course teaches the basics of building
a mobile web app using jQuery Mobile. It
is an easy to use development framework
designed to make sites and apps that work
well on all popular smartphone, tablet, and
desktop devices. If you know basic HTML
and CSS, you can start building mobile web
apps without needing any additional coding
or programming experience.
Note: To take your mobile websites and
apps further, consider our JavaScript, and
jQuery classes.
Part 1 - Introduction
Prerequisites: HTML Parts 1, 2, 3, and 4 or
equivalent experience.
•
•
•
•
•
•
Types of mobile apps
Setting up jQuery Mobile
Pages and menus
Transitions
Headers and footers
Collapsible sections
Note: This class does not cover Java
programming.
Part 1 - Introduction
Prerequisites: Significant experience with
HTML and CSS.
•
•
•
•
Object model
JavaScript syntax
Images swapping
Introduction to conditionals
(If statement)
• Passing parameters
Prerequisites: Mobile Web Basics - Websites
& Apps Part 1 or equivalent experience.
Customizing look and feel
Searchable lists
Simple static map page
Links to phone, email, and text messages
JAV-Part 1
JAV-Part 2
Registration information–see page 36
Mobile Web Basics - Websites & Apps
MAP-Part 1
Tue Feb 03
8-11:45 am
MAP-Part 2
Tue Feb 03
1-4:45 pm
MAP-Part 1
MAP-Part 2
Wed Apr 01
Wed Apr 01
8-11:45 am
1-4:45 pm
$139
$139
$139
$139
Note: To take your mobile websites
and apps further, consider our
JavaScript and jQuery classes.
34
Check our website for additional classes and schedules
Wed Apr 08
Wed Apr 08
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
Prerequisites: JavaScript Parts 1 and 2 or
equivalent experience.
•
•
•
•
Registration information–see page 36
Tue Feb 10
Tue Feb 10
Part 1 - jQuery Basics
Document Object Model (DOM)
Selecting and changing page elements
Responding to events
Changing page content and style
Prerequisites: jQuery Part 1 or equivalent
experience.
For loops
Arrays
Introduction to form validation
Date to a page
JavaScript
JAV-Part 1
JAV-Part 2
jQuery is a lightweight, “write less, do
more” JavaScript library. The purpose of
jQuery is to make it much easier to use
JavaScript on your website. jQuery takes
common tasks and simplifies them into
methods that you can call with a single line
of code. In addition, jQuery has plugins for
almost any task.
Part 2 - jQuery and AJAX:
Making Your Site Interactive
Part 2 - Introduction
•
•
•
•
jQuery
•
•
•
•
Prerequisites: JavaScript Part 1 or
equivalent experience.
Part 2 - Introduction
•
•
•
•
JavaScript is a scripting language used to
add dynamic content to web pages. While
JavaScript uses programming concepts, it is
not Java programming.
Using plugins
Special effects and animations
Image galleries
AJAX basics
Registration information–see page 36
$159
$159
$159
$159
jQuery
JQY-Part 1
JQY-Part 2
JQY-Part 1
JQY-Part 2
Tue Feb 24
Tue Feb 24
Wed Apr 15
Wed Apr 15
8-11:45 am
1-4:45 pm
8-11:45 am
1-4:45 pm
$139
$139
$139
$139
MAP AND DIRECTIONS - ST. PAUL
Computer Education Center – St. Paul
Located at:
Science Museum of Minnesota
120 West Kellogg Boulevard
Saint Paul, Minnesota 55102
N
c
Wa
ou
ta
The above map shows the general location of the Science Museum of Minnesota.
Your confirmation letter will have detailed instructions for getting to the
Science Museum’s parking ramp. For more complete directions, call our main
phone at 651.221.4722 or visit our website at comped.smm.org.
Phone–651.221.4722  Web–comped.smm.org
35
REGISTRATION
FEES & PARKING
POLICIES
How to Register
Class Fees
Rescheduling
Payment by Credit Card
Class fees may be charged to your
VISA, MasterCard, American Express,
or Discover Card by providing the credit
card number and expiration date.
Cancellations
You may register for class in three
convenient ways:
Online Registration
comped.smm.org
Our entire course catalog is available online
and you may register using our secure system.
Check our website often, as we frequently add
new class dates due to strong student demand.
Fax Registration
651.224.5092
Complete the registration form on page 39
and be sure to include a method of payment.
If your business will be invoiced for the class,
check the “Invoice” box and write in your
purchase order number. You must fax a copy
of the purchase order with the registration form
to complete and secure your registration.
We are unable to invoice private individuals.
Mail
Complete the registration form on page 39
and include a method of payment—enclose
a check, fill in a major credit card number,
or select invoice. If your business will be
invoiced for the class, check the “Invoice”
box and write in your purchase order number.
You must send a copy of the purchase order
with the registration form to complete and
secure your registration.
We are unable to invoice private individuals.
General Information
651.221.4722
Call for answers to any of your questions.
Gift Certificates
A gift certificate for computer classes
makes the perfect gift for the person who
has everything. We offer gift certificates in
any amount for computer classes. For more
details, call 651.221.4722.
Vouchers
Prepaid vouchers are available for purchase
and will save you money! For more details,
call 651.221.4722.
36
Fees are listed at the end of each class
description. Please check these carefully
when registering. No reservations may be
made without full payment in advance or
arrangement to invoice.
Your registration can be secured with a
check, credit card, or purchase order number.
Payment by Invoice
Class fees may be invoiced by providing
a purchase order number. You must send
a copy of the purchase order with the
registration form to complete and secure
your registration.
We are unable to invoice private individuals.
Payment by Check
Please enclose your check with registration
form. Make checks payable to: Science
Museum of Minnesota.
Confirmations
Once you are registered for classes, you
will receive a class confirmation. Please
call 651.221.4722 at least one business day
before your class (or even sooner) if you
don’t get a prompt confirmation.
Parking - St. Paul
Class fees do not include parking costs.
Your class confirmation will have
detailed instructions for finding the
Science Museum’s parking ramp.
See general map on page 35.
Rate: $10
Rate is subject to change.
Individuals needing to reschedule from
one class to another may do so with no
penalty up to five (5) business days before
a class begins. The full fee is due for a class
rescheduled five or fewer days in advance,
but there will be no additional fee for the
rescheduled class. To reschedule a class,
please call 651.221.4722 to speak with a
customer service representative.
If an individual cancels at least five (5)
business days before a class begins, class
fees will be refunded in full. The full class
fee remains due for a class canceled five
(5) or fewer business days in advance.
If a class must be canceled, please call
651.221.4722 to speak with a customer
service representative.
Missed Your Class
Full class fees are due for any missed class.
Please call 651.221.4722 to speak with
a representative to determine if we can
reschedule your class.
Late Arrivals
We reserve the right to reschedule anyone
arriving more than 30 minutes late to class.
Full class fees are due for late arrivals. If
you anticipate being late for a class, call
651.221.4722.
Guarantee
All classes are offered with a money-back
satisfaction guarantee.
Refresher Classes
We offer free refresher classes for students
who have taken the regular adult computer
classes from the Science Museum. This
refresher policy does not apply to custom or
group classes. Your refresher class must be
on the same software version, taken within
six months of the original class date. Each
refresher class can be taken only one time.
All refresher classes are subject to space
availability. If a registered student fails to
attend a refresher class without giving the
required five (5) business days notice, we
reserve the right to limit registration for
future refresher classes.
Please sign up for refresher classes by
calling 651.221.4722.
SPECIAL SERVICES
COMMUNICATIONS
RESOURCES
Special Services
General Information
651.221.4722
Help Desk
For your convenience, a variety of group
training options are available. We have six
Windows-based computer classrooms and
one Macintosh classroom, each equipped
with ten to twelve state-of-the-art computers.
Call 651.221.4722
Contact us for more details on any of
these options.
Custom Classes
You may book one of our classrooms for
the exclusive use of your employees—we
will provide the instructor, equipment, and
materials. We can teach any of our classes
as described in this catalog, or we can
customize the training to meet the needs of
your employees.
Client-Site Training
If you would like to train at your workplace,
we can bring our training to you. We will
provide the instructor, materials, and even
computers, if none are available at your site.
Lab Rental
If you are simply looking for a place to do
your own training, our facilities are available
for rental. You provide your own teachers,
students, materials, and software. Our
technicians are available to help you install
software or configure the systems to suit
your requirements. A complete selection of
visual aids including a high-resolution color
projector are available for your use.
Group Discounts
We offer group discounts for most of our
classes. Please call 651.221.4722 for details.
Call for answers to any of your questions.
E-Mail
[email protected]
For your convenience, general questions can
be directed to our e-mail address.
Web Page
comped.smm.org
Our entire course catalog is available online.
Volunteer Positions
The Science Museum needs people ages 14
and older for a wide variety of volunteer
positions. Work as an information booth
volunteer, exhibit interpreter, group
greeter, or in behind-the-scenes roles.
Training is provided. Volunteers receive
discounts on adult classes, reduced fees
on computer classes, free passes to the
museum and Omnitheater, and free parking
while volunteering. Become a part of the
excitement at the Science Museum.
Call 651.221.4703 for information.
Employment Opportunities
Join the staff at the Science Museum.
We have a variety of part-time and fulltime positions available. Visit the Science
Museum’s website - www.smm.org to
learn about our current job openings and
application process. The museum is an
exciting place to work! We have competitive
pay rates and great benefits.
The Help Desk is a free service we offer
exclusively for our students. If you have a
question about a topic covered in class, you
can get the answers you need simply by
calling the Help Desk. Details are available
from your instructor.
Continuing Education Credits
A letter of completion is available upon request.
Youth Computer Classes
Children and teens take the next step
with computers at the Science Museum
of Minnesota’s Learning Technologies
Center. Students use new technology to
develop creative projects in art, science,
and engineering. Workshops range from
computer starters for preschoolers to 3D
animation for teens. Call for information
on the latest offerings, including school
vacation week programs and Science
Learning Network hands-on technology
workshops for students and teachers.
For more information about youth computer
classes call 651.221.4511.
Accessibility
We will make reasonable accommodations
for students with disabilities. Please call
651.221.4722 for more information.
Large-print Catalogs
A large-print catalog is available
upon request. We will make
reasonable accommodations for
students with disabilities.
37
CLASS INDEX
A
I
P
Absolutely Terrified of Computers
6
Access10
Access - FastTrack
10
Access: Advanced Design (Seminar)
11
Adobe Acrobat
12
Adobe Dreamweaver
31
Adobe Illustrator
14
Adobe InDesign
16
Adobe InDesign - Digital Publishing
16
Adobe InDesign - PDF Accessibility
16
Adobe InDesign - FastTrack
17
Adobe Photoshop
14
Adobe Photoshop Elements
15
Adobe Premiere Elements
13
Illustrator14
InDesign16
InDesign - Digital Publishing
16
InDesign - PDF Accessibility
16
InDesign - FastTrack
17
InfoPath19
Internet and E-Mail Introduction
26
PDF Accessibility
27
Photoshop14
Photoshop Elements
15
PowerPoint18
PowerPoint - FastTrack
18
PowerPoint Pizzazz (Seminar)
18
Premiere Elements
13
Project24
Publisher17
B
Blogging for Business
29
J
JavaScript34
Job Hunting Online (Free Seminar)
26
jQuery34
Q
L
S
LinkedIn Introduction
28
Lync19
Search Engine Optimization (Seminar) 32
SharePoint20
SharePoint Designer
21
SharePoint 2013 - What’s New (Seminar) 21
Social Media Overview (Seminar)
28
SQL Language
11
Surface Tablet
7
C
M
Captivate32
Crystal Reports
9
Crystal Reports - FastTrack
9
Macintosh OS X Introduction
Microsoft Access
Microsoft Excel
Microsoft InfoPath
Microsoft Lync
Microsoft OneNote
Microsoft Outlook Microsoft PowerPoint
Microsoft Project
Microsoft Publisher
Microsoft SharePoint
Microsoft SharePoint Designer
Microsoft Surface Tablet
Microsoft Visio
Microsoft Word Mobile Website Design (Seminar)
Mobile Web Basics - Websites & Apps
D
Database Basics (Seminar)
8
Desktop Publishing Fundamentals
12
Dreamweaver31
E
Essential Computer Skills
6
Excel22
Excel - FastTrack
23
Excel - Working the Workbook
23
F
Facebook Introduction (Free Seminar)
Facebook for Business (Seminar)
28
28
H
HTML30
38
7
10
22
19
19
19
19
18
24
17
20
21
7
24
25
33
34
O
Office 2010 - What’s New (Seminar) 7
Office 2013/365 - What’s New (Seminar) 7
OneNote19
Outlook 19
QuickBooks 8
T
Twitter for Business (Seminar)
29
V
Visio24
W
Website Basics (Seminar)
26
Websites - Responsive Web Design
32
Web Graphics Fundamentals
26
Windows 7
6
Windows 8 /8.1
6
Windows 8 /8.1 - What’s New (Seminar) 7
Word 25
Word Accessibility and PDFs
25
Word - FastTrack
25
WordPress - Designing Your Website
29
WordPress - for Blogging
See Blogging
REGISTRATION FORM
Student Registration Information
Computer Class Information
Name _____________________________________________
Class Code
Class Date
Price
Company __________________________________________
Address ___________________________________________
__________________________________________________
City ___________________State ______Zip ______________
Day # (Area Code) ___________ (Number) ___________________
Evening # (Area Code) ________ (Number) ___________________
Fax # (Area Code) ____________ (Number) __________________*
E-mail address _____________________________________*
Billing Address
Total
(If different from address above)
Company __________________________________________
Attention __________________________________________
Mail to:
Address ___________________________________________
Science Museum of Minnesota • Computer Education Center
120 West Kellogg Boulevard
Saint Paul, MN 55102 • 651.221.4722
__________________________________________________
City ___________________State ______Zip ______________
Day # (Area Code) ___________ (Number) ___________________
Fax to:
Fax # (Area Code) ____________ (Number) __________________*
You may fax registration(s) to 651.224.5092.
Method of Payment
Website
 Check Enclosed
comped.smm.org
Our entire course catalog is available online.
You may register using our secure system.
Check #_____________________
Credit Card #_____________________________________
 VISA  American Express  MasterCard  Discover
Expiration Date________ Signature_____________________
Science Museum of Minnesota
Computer Education Center
Name on Card (Please Print)________________________________
Billing Address _______________________________________
City_____________________State_______ Zip_____________
*
 Invoice
 Yes, I would like to receive occasional information about
P.O. # required___________________________________
Note: We send class confirmations via e-mail or fax. Please provide
this information on the registration form. Check box below to
receive information on new classes and special offers via e-mail.
new classes/special offers via e-mail.
You must include a copy of the purchase order to complete and secure your registration.
39
non-profit org.
us Postage Paid
Science Museum
of minnesota
Computer Education Center
120 West Kellogg Boulevard
Saint Paul, Minnesota 55102
Computer Education
Training for you and your business
Winter
2015
Classes
Winter
2015
Classes
30 Years of Computer Education
Access • Acrobat • Blogging for Business • Captivate • Crystal Reports
• Database Basics • Desktop Publishing Fundamentals • Dreamweaver •
Essential Computer Skills • Excel • Facebook • Facebook for Business
• HTML • Illustrator • InDesign • InfoPath • Internet and E-Mail
• JavaScript • Job Hunting Online • jQuery • LinkedIn • Lync •
Macintosh • Mobile Website Design • Mobile Web Basics–Websites & Apps
• Office 2013–What’s New • OneNote • Outlook • Photoshop • Photoshop
Elements • PowerPoint • Premiere Elements • Project • Publisher •
QuickBooks • Search Engine Optimization • SharePoint • Social Media
• SQL Language • “Terrified” of Computers • Twitter for Business • Visio •
Web Graphics Fundamentals • Website Basics • Websites–Responsive Design
• Windows 7 • Windows 8 • Windows 8–What’s New • Word • WordPress
January–April >>>

Masjid As-Sunnah

2015 Busy Season Calendar FINAL

Echtdampf-Hallentreffen - Schmalspur Europa

MET APR080S遅延④ - NYK Container Line

MET CAB192S遅延① - NYK Container Line

Prayer Time Table Click Here

【アジア輸出】 V. (VLS) MARE FOX 023S -2 - NYK Container Line

Enrollment Form for WMI Programs

Feb 2015

FINAL EXAM SCHEDULE: SPRING 2015