Welcome to the SEW brochure! Here you will find information on our upcoming courses, bi-monthly schedule, how to register, and more!
SEW course schedule
Here is our schedule for upcoming in-class courses (updated bi-monthly):
January
| Course name | Course code | Date | Location | Time |
|---|---|---|---|---|
| Excel 2: Fundmentals | SEW092 | January 30 | MC2060 | 1 p.m. - 4 p.m. |
| WCMS for Content Maintainers | SEW099 |
January 15 & 16 |
MC2060 | 9 a.m. - noon |
| WCMS for Site Managers | SEW100 |
January 22 |
MC2060 | 9 a.m. - noon |
| WCMS Web Form Creation | SEW101 |
January 29 |
MC2060 | 9 a.m. - noon |
Handouts
Handouts and sample files for most of the SEW courses can be found on SharePoint. Use your WatIAM account and password to sign in, and then click on SEW Handouts in the left panel.
If you would like a printed handout for your presentation-style course (i.e., in Mathematics & Computing Building (MC) room 2009), you need to print your own copy and/or download before the class. Attendees will be emailed a reminder and the link to the materials two business days before the course.
Course registration
Cancel your SEW course registration.
Cancellation
72-hour cancellation with no penalty - reply to your registration confirmation or contact istsew@uwaterloo.ca.
Facilities
Presentation rooms: MC 2009, East Campus (EC) 5 room 1111, EC2 room 1021.
Hands-on labs: MC 2060, 1078.
Includes: Twenty Windows 10 workstations; instructor controlled workstation with presentation option.
Important!
There is a $50 charge imposed on the department for each no-show.
All charges are billed to the department by Information Systems & Technology.
No food in the labs; covered drinking containers are allowed.
Course descriptions
The courses in the Skills for the Electronic Workplace (SEW) teach recommended computing skills to university employees.
Computing
Computing@UW [SEW135]
Employee Orientation: Computing at Waterloo
Most employees hired at the university have computer skills, but they are not familiar with the computing environment at the University. The course will help employees familiarize themselves with information ranging from employee computer accounts, workstation set up and security, and connecting from home to IT support, dealing with spam/phishing, computing software, available training, and more. While this course would benefit new employees, everyone is welcome to attend.
Pre-requisite: None
Instructor: Barb Yantha, Information Systems & Technology
Marketing and digital communications
Google Analytics 101: Getting Started [SEW128]
Do you know about Google Analytics but just aren’t sure how to get started or how it fits in with your work? Or have you used Google Analytics in the past and just need a refresher on the basic reports and tools? This course will introduce you to our campus-wide measurement framework and philosophy, review baseline best practices for setting up Google Analytics, and start to dive into basic measurement metrics and what they can tell you about your website.
Prerequisite: Access to an existing Google Analytics account (classic or universal)
Instructor: Joe Kwan, Web Development, Information Systems & Technology
Digital Marketing Analytics [SEW129]
Looking to see how Google Analytics can further your marketing and communications efforts? This course will introduce you to the importance of measurement and our standardized measurement framework. We will then dive into how Google Analytics can support your decision-making about marketing and communications tactics. We will finish with our reporting strategy and some sample reporting you can use in your role
Prerequisites: Access to an existing Google Analytics account. It is also strongly recommended that if you do not have working knowledge of Google Analytics you attend SEW 128 Google Analytics 101 prior to this course.
Instructor: Joe Kwan, Web Development, Information Systems & Technology
Writing for the Web [SEW016]
Do you create or modify online content? Learn how to develop content that meets your users' needs, clearly communicates your message, and achieves accessibility requirements.
Pre-requisite: Introduction to Web Accessibility [SEW026]
Instructor: Elizabeth Rogers, Dean of Arts Office, Faculty of Arts
Microsoft
Select the Microsoft application you would like to learn more about:
Excel | OneNote | Office 365 | Outlook | PowerPoint | SharePoint | Teams | Word
Excel
Excel 1: Getting Started [SEW103]
Want to get started with the basics? In this hands-on two half-day course you will learn the parts of the worksheet, using calculations and functions, creating charts, and more. The lab has Microsoft Excel 2016 Windows although Excel Mac users may benefit as well.
Pre-requisite: None
Instructor: Jennifer Keir, Information Systems & Technology
Back to top | Back to Microsoft application list
Excel 2: Fundamentals [SEW092]
Now that you have mastered the Excel basics, it's time to learn more! Some of the features we will cover include: sorting and filtering, counting cells, viewing spreadsheets, and an introduction to macros.
The lab has Microsoft Excel 2016 Windows although Excel Mac users may benefit as well.
Pre-requisite: Excel 1 or equivalent Excel experience
Instructor: Jennifer Keir, Information Systems & Technology
Back to top | Back to Microsoft application list
Excel 3: Expand Your Skills [SEW132]
Content for this course has been derived from suggestions/questions put forth from members of the University community and will include:
- An introduction to pivot tables. How to create and use a pivot table (managing, sorting, filtering, applying rules and more).
- Create charts from a pivot table.
- Using sparklines and slicers in tables and pivot tables.
- Using VLOOKUP with tables to find exact or approximate values
- Introduction to What-If Analysis and Goal Seek
- Use text to speech features of Excel.
Pre-requisite: Excel 1 or 2 or equivalent experience recommended
Instructor: Reg Leland, Information Systems & Technology
Back to top | Back to Microsoft application list
OneNote
Intro to OneNote [SEW131]
Are you new to OneNote? Unsure of how to use it or what to use it for? This basic course will teach you the fundamentals. During our time together, we will be exploring the user interface of OneNote, integrating OneNote with SharePoint, and working through a few use cases together.
Pre-requisite: None
Instructor: Yufei Du, Information Systems & Technology
Back to top | Back to Microsoft application list
Office 365 (O365)
An Introduction to O365 [SEW145]
The talk will provide an overview of O365, including saving files to OneDrive, file creating and collaborating.
Note: No experience with O365 is required.
Instructor: Barb Yantha, Information Systems & Technology
Back to top | Back to Microsoft application list
Outlook
Outlook Tips & Tricks [SEW001]
Microsoft Exchange (Connect) is the platform used for on-campus email. In this seminar you will learn some helpful tips and tricks to navigate through Outlook 2016. From simple shortcuts to full email templates, you’ll be shown a variety of tools to make email easier.
Pre-requisite: None
Instructor: Will Lewis, Information Systems & Technology
Back to top | Back to Microsoft application list
PowerPoint
Intro to PowerPoint [SEW137]
Microsoft PowerPoint is an electronic program that enables you to create an organized and helpful visual aid for your presentations, or to include additional audio and graphical content for your audience. This course begins by introducing you to the basics many people overlook, important resources, and a hands-on approach to assist you with learning how to create a professional slide show.
Pre-requisite: None
Instructor: Keith Peck, Information Systems & Technology
Back to top | Back to Microsoft application list
SharePoint
Introduction to SharePoint [SEW089]
Are you new to SharePoint? This course will focus on the basics of using SharePoint. How do I navigate a SharePoint site? How can I add and modify content in SharePoint? How are permissions assigned? What are roles? This hands-on course will cover the basics of collaborating in SharePoint 2013 using document libraries and lists, such as announcements and calendar. This course will not cover site administration or site design.
Pre-requisite: Experience using a web browser, and some experience with Microsoft Office is also helpful.
Instructor: Stephen Markan, Information Systems & Technology
Back to top | Back to Microsoft application list
Custom Lists in SharePoint [SEW102]
This advanced course will show you how to use SharePoint as a data-gathering tool by creating your own custom lists for purposes such as event sign-ups or tracking inventory. With a combination of hands-on practice and instructor-led discussion, you will learn process, techniques and best practices - everything you will need to know to get started on your own projects.
Pre-requisite: Introduction to SharePoint or experience using SharePoint and a good understanding of SharePoint roles and permissions.
Back to top | Back to Microsoft application list
SharePoint for Windows/Office [SEW090]
This general course provides an overview of using SharePoint on a Windows desktop. This hands-on course will focus on integrating SharePoint with Windows 7 and Office 2016 with a number of tips and tricks to make accessing files stored on SharePoint easier.
Pre-requisite: Experience with SharePoint and familiarity with MS Office.
Instructor: Stephen Markan, Information Systems & Technology
Back to top | Back to Microsoft application list
Using MySharePoint [SEW122]
MySharePoint is your personal part of SharePoint at the University of Waterloo. MySharePoint is our own hosted OneDrive with space for storing, managing and sharing your documents. This course will focus on the basics of using MySharePoint. How do I navigate a MySharePoint site? How can I add and modify content in MySharePoint? How are permissions assigned? This hands-on course will cover the basics of collaborating in SharePoint 2013 using the MySharePoint service.
Pre-requisite: Experience using a web browser, and some experience with Microsoft Office is also helpful.
Instructor: Stephen Markan, Information Systems & Technology
Back to top | Back to Microsoft application list
SharePoint Admin Topics: Permissions Management [SEW133]
As a SharePoint site owner, you control who can and cannot see your SharePoint site, and the items in your SharePoint site. Most often we use the default SharePoint groups: Owners, Members, and Visitors. Generally those default groups work well for most sites.
You can also create additional groups and permission levels when you need finer control over the actions that your users can take. When your site has specific lists, libraries, folders, etc. containing sensitive data that requires extra security, you can use fine-grained permissions to grant specific permissions to specific groups or individual users.
This course will look at the following SharePoint permissions management concepts:
- Hierarchy and inheritance permissions
- Permission levels and types
- View permissions for users and groups
- Assign users permission
- Create new SharePoint permissions groups
- Edit permission assignments on permissions levels
- Break permission inheritance on an item
- Inherit permissions for an item
- Remove user permissions
Pre-requisite: This course is designed for SharePoint users who have FULL CONTROL permissions on a SharePoint site as a Site Administrator or a SharePoint Site Owner.
Instructor: Stephen Markan, Information Systems & Technology
Back to top | Back to Microsoft application list
SharePoint Site Management: Questions and Answers [SEW140]
Do you have a SharePoint mystery that you need help solving? Is there something about SharePoint you want to understand better?
This course is intended to help you address specific SharePoint design and management issues. You will be required to submit a question or problem that you have in managing SharePoint before the course, and we will design a training session around your question(s). This course is designed for SharePoint Administrators and Owners to explore and share management experiences. We will cover general design principles in the course, including:
- when to use a sub-site,
- when to use a library,
- how to replace an Excel Spreadsheet with a custom SharePoint List, and
- how to use and customize group permissions
Pre-requisite: This is an intermediate level course. Attendees should have experience managing a SharePoint site, or have taken the SharePoint Admin Permissions course. You will be working with your Site in this course.
Instructor: Stephen Markan, Information Systems & Technology
Back to top | Back to Microsoft application list
DeliverPoint – SharePoint Permission Management [SEW143]
DeliverPoint is SharePoint Permissions Management Tool that enables SharePoint farm administrators, site collection administrators and site owners to effectively manage SharePoint permissions within the context of a SharePoint 2016 on-premises environment.
This course will include:
- An introduction to DeliverPoint as a SharePoint in-context tool
- Generating permission reporting
- How to copy, compare and transfer permissions
- Understanding and managing inheritance from DeliverPoint
- General user auditing
Pre-requisite: Experience as a SharePoint site collection administrator and/or site owners
Instructor: Edgar Vieira, Information Systems & Technology
Back to top | Back to Microsoft application list
Teams
Microsoft Teams [SEW146]
Microsoft Teams is now available on campus! Teams is a collaboration tool which brings group chat, file sharing, and much more together in one place. This course will cover what Teams is, and what its capable of, how to use Teams effectively in your group and have hands-on examples of how to use Teams.
Instructor: Matt Harford, Information Systems & Technology
Back to top | Back to Microsoft application list
Word
Word for Long Documents [SEW097]
Are your Word documents larger than a page or two? A long document requires formatting techniques not needed in smaller documents. The following topics will be covered in this course:
- Using Styles
- Numbering headings, including legal style numbering (2.1, 2.2)
- Numbering other document components (tables, figures)
- Adding captions to document components
- Footnotes and endnotes
- Bookmarking text
- Creating cross references to headings, tables, figures, etc.
- Using Outline view
- Creating a table of contents
- Creating a list of figures or tables
- Page numbering/headers and footers
- Using a template
- Making the document more accessible
- Converting the document to PDF format
Note: This course is being taught using Word 2016 but the concepts apply to Word 2013 and Mac Word as well.
Pre-requisite: comfort level with Word basics.
Instructor: Cassandra Bechard, Information Systems & Technology
Back to top | Back to Microsoft application list
Creating Accessible Documents [SEW106]
Now that you have been introduced to web accessibility, this course will provide you with the knowledge and skills needed to create accessible documents. Through hands-on activities and lecture material, you will be able to make Microsoft Word, PowerPoint, and Excel documents, as well as PDFs accessible – therefore contributing towards the University of Waterloo’s commitment in achieving accessibility, and complying with the Accessibility for Ontarians with Disabilities Act (AODA).
Notes: This course does not cover creating accessible PDFs in Adobe Acrobat Pro, and it is highly recommended that participants have previous experience working with Microsoft Word.
Pre-requisite: Introduction to Web Accessibility [SEW026]
Instructor: Cassandra Bechard and Cindy Xayavong, Information Systems & Technology
Open data
Introduction to APIs [SEW126]
Application Programming Interfaces (APIs) are a key technology that helps power the modern web. Find out how they work with this hands on introductory course! You will power-up your “data wrangling” skills using the same tool that powers much of the Student Portal and some WCMS sites. Suggested audiences include:
- People who have no programming experience and wish to be inspired to start programming or seek to inspire others.
- People who work with data in other GUI-heavy tools such as SPSS and Excel and have limited to no lower-level programming experience.
- Novice-intermediate web and database developers who have limited to no exposure with APIs.
Pre-requisite: None
Instructor: Pavol Chvala, Information Systems & Technology
Project management
Intro to Project Management [SEW138]
The purpose of this course is to provide an introductory overview of what project management is and is not, an appreciation of why project management is important, and to discuss some of the tools used to support different phases of project management. In this interactive workshop, participants will complete activities designed to make the course practical and engaging. This course is meant for those who want to learn more about what project management is about or learn what to expect when participating on projects. This project does not offer PDUs towards project management certification and is not meant to replace the more in depth courses offered through CEL.
Pre-requisite: None
Instructors: Pam Fluttert, Jonathan Woodcock and Wendy Hague, Information Systems & Technology
More project management courses coming soon!
Visit the Project & Portfolio Management Community of Practice site if you are interested in learning more about project management on campus.
Request Tracker (RT)
RT4 for Requestors [SEW124]
The Request Tracker (RT) system on campus has been upgraded to version 4.2 (RT4). This course will describe what’s new in RT4 for requestors, including new request forms. There will also be time for questions.
Pre-requisite: None
RT4 for RT Issue Solvers [SEW121]
The Request Tracker (RT) system on campus has been upgraded to version 4.2 (RT4). This course will describe what’s new in RT4, provide an overview of existing and new functionality and also introduce you to the new RT4 knowledge base called ‘Articles’.
Pre-requisite: You currently use the campus RT system to take, edit, update and resolve tickets.
Waterloo Content Management System (WCMS)
WCMS for Content Maintainers [SEW099]
This hands-on course for content maintainers will provide an overview of the main features of the Waterloo Content Management System (WCMS) including creating new content, editing content, uploading and adding images and documents, submitting drafts for review, reviewing drafts, publishing and managing content.
Note: two half-day course.
Pre-requisite: None
Instructors: Sarah White and Cindy Xayavong, WCMS Training & Support, Information Systems & Technology
WCMS for Content Maintainers [LEARN]
We are now offering Content Maintainers (SEW099) online in LEARN!
In this hands-on course you will work through modules at your own pace to complete activities that teach you how to create and edit content within the Waterloo Content Management System. This option requires the successful completion of quizzes and a final test in order to receive course credit.
Note: Self registration available in LEARN.
Pre-requisite: None
WCMS for Site Managers [SEW100]
This hands-on course for Site Managers will provide an overview of site manager specific tasks and functionality in the Waterloo Content Management System (WCMS) including creating site-wide content (promotional items, footers, etc.), managing user access and site permissions, adding Google analytics tracking, managing redirects, and managing workflow.
Pre-requisite: WCMS for Content Maintainers [SEW099 or LEARN]
Instructors: Sarah White and Cindy Xayavong, WCMS Training & Support, Information Systems & Technology
WCMS for Site Managers [LEARN]
We are now offering Site Managers (SEW100) online in LEARN!
In this hands-on course you will work through modules at your own pace to complete activities that will provide you with a review of Content Maintainers (SEW099), an overview of site manager responsibilities, content types, new Dashboard features, managing user access and site permissions, as well as reporting options. This option requires the successful completion of quizzes in order to receive course credit.
Pre-requisite: WCMS for Content Maintainers [SEW099 or LEARN]
Note: Self registration available in LEARN.
WCMS Web Form Creation [SEW101]
In this hands-on course we introduce the WCMS form features and guide you through creating a form, adding form components, configuring email options, and using conditionals and form validation. We'll also talk about security and privacy concerns with collecting data and how you can decide what to collect.
Pre-requisite: WCMS for Content Maintainers [SEW099 or LEARN]
Instructors: Sarah White and Cindy Xayavong, WCMS Training & Support, Information Systems & Technology
WCMS Web Form Creation [LEARN]
We are now offering Web Forms (SEW101) online in LEARN!
In this hands-on course you will work through modules at your own pace to complete activities that will introduce you to Web form creation, including requirements, components, email configurations, as well as conditionals and validation rules. This option requires the successful completion of quizzes in order to receive course credit.
Pre-requisite: WCMS for Content Maintainers [SEW099 or LEARN]
Web accessibility
Introduction to Web Accessibility [SEW026]
What does it mean for a website to be accessible? Your role as a content writer or editor is very important. This presentation will help you understand why accessibility is important and what is needed to make your website accessible. You will learn about the new Accessibility for Ontarians with Disabilities Act (AODA) and the resources available.
Pre-requisite: None
Instructor: Liam Morland, Web Accessibility Consultant, Information Systems & Technology
Creating Accessible Tables [SEW112]
This hands-on course will begin with a review of the HyperText Markup Language (HTML) markup used to create simple tables. We will then explore the features of HTML used to create more complex and accessible tables. Feel free to bring a sample table to work on during this course. No carpentry tools required!
Pre-requisite: Introduction to Web Accessibility [SEW026]
Instructor: Liam Morland, Web Accessibility Consultant, Information Systems & Technology
