Skills for the Electronic Workplace (SEW) course brochure

SEW courses (updated bi-monthly)

The courses in the Skills for the Electronic Workplace (SEW) teach recommended computing skills to a general audience

Course name Course code Date Time Location
Intro to API's SEW126 July 11 9:00am - 12:00pm MC2060
Google Analytics 101 SEW128 July 6 1:30pm - 3:30pm EC5, 1111
Social Media Measurement SEW127 July 20 1:30pm - 3:30pm EC5, 1111
WCMS for Content Maintainers SEW099

 July 5 & 6

Aug 1 & 2

9:00am - 12:00pm

9:00am - 12:00pm

MC1078
WCMS for Site Managers SEW100

July 13

Aug 11

9:00am - 12:00pm

MC1078
WCMS Web Form Creation SEW101

July 18

Aug 15

9:00am - 12:00pm MC1078

Note: 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 to your portable device (i.e., laptop) before the class. Attendees will be emailed a reminder and the link to the materials two business days before the course.

Course registration

Cost

  • $50 charge imposed to the department for no-show.
  • All charges are billed to the department by Information Systems & Technology.

Facilities

  • Presentation room in MC 2009, EC5, 1111
  • Hands-on labs (MC 2060, 1078): 20 Windows 10 workstations; instructor workstation; instructor controlled workstations with presentation option
  • No food in labs; covered drinking containers allowed

Cancellation

  • 72 hours cancellation with no penalty - reply to your registration confirmation or contact ISTSEW

Questions or comments about courses, course materials, facilities?

Course descriptions

The courses in the Skills for the Electronic Workplace (SEW) teach recommended computing skills to a general audience.

Back to top

Excel Level 1 [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

Date: Not being offered
Time:
Location:
Instructor: Jennifer Keir, Information Systems & Technology

Back to top

Excel Level 2 [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 Level 1 or equivalent Excel experience

Date: Not being offered
Time:
Location:
Instructor: Jennifer Keir, Information Systems & Technology

Back to top

Excel Level 3 [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).
  • Using slicers and sparklines in tables and pivot tables.
  • Create charts from a pivot table.
  • Introduction to What-If Analysis and Goal Seek
  • Graphing.
  • Using VLOOKUP with tables to find exact or approximate values.
  • Use text to speech features of Excel.

Pre-requisite: Excel Level 1 or 2 or equivalent experience recommended

Date: Not being offered
Time:
Location: 
Instructor: Reg Leland & Cassie Bechard, Information Systems & Technology

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 hour 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

Date: Not being offered
Time:
Location:
Instructor: Shayne Dyck, Information Systems & Technology

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

Date: Not being offered
Time:
Location:
Instructor: Keith Peck, Information Systems & Technology

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

Date: Not being offered
Time:
Location:
Instructor:

Back to top

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.

Date: Not being offered
Time:
Location:
Instructor:

Back to top

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.

Date: Not being offered
Time:
Location:
Instructor: Stephen Markan, Information Systems & Technology

Back to top

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.

Date: Not being offered
Time:
Location:
Instructor:

Back to top

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.

Date: Not being offered
Time:
Location:
Instructor: Stephen Markan, Information Systems & Technology

Back to top

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.

Date: Not being offered
Time:
Location:
Instructor: Stephen Markan, Information Systems & Technology

Back to top

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.

Date: Not being offered
Time:
Location:
Instructor: Stephen Markan, Information Systems & Technology

Back to top

Telephone Services - Billing and Administration [SEW125]

This course is for Telephone Services (TS) Admin Contacts. You will have an overview of the various services and the monthly billing process.

Deciphering the Telecommunication billing report can be perplexing and time consuming. Learn tips on reading your billing statement, finding errors before they become budget problems, and reducing phone costs.

In addition, learn how to create and manage your Telephone Service requests by optimizing completion time, reducing lengthy email threads, and knowing when and how to escalate your requests.

Pre-requisite: Be a member of the TS Admin Contact Group assigned to reviewing monthly telephone statements and requesting telephone services for your department.

Date: Not being offered
Time:
Location:
Instructor: Carol Hoffer, Information Systems & Technology

Back to top

 Telephone Services - Mobile Support and Administration [SEW130]

This course is for Telephone Services (TS) Admin Contacts. You will have an overview of the various mobile services and the monthly invoices.

Deciphering the wireless invoices can be perplexing and time consuming. Learn tips on reading your billing statement, finding errors before they become budget problems, and reducing phone costs.

Pre-requisite: Be a member of the TS Admin Contact Group assigned to reviewing monthly wireless statements and requesting telephone services for your department.

Date: Not being offered
Time:
Location:
Instructor: Kathleen Ebrahimi, Information Systems & Technology

Back to top

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.

Date:  Not being offered
Time:
Location:
Instructors: Cassandra Bechard, Information Systems & Technology

Back to top

Social Media Event Planning [SEW116]

Leveraging social media for events is becoming a crucial component to the event planning process. Cutting marketing costs, creating new levels of engagement and increased measurement are a few of the benefits social media can easily provide for your next function. This course will help users understand how social media can help in the planning, promotion and execution of on-campus events. We will also take you through real-life examples of how social media was used effectively at campus events and help you avoid common social media mistakes.

Pre-requisite: Familiarity with the use of social media (ie. Facebook, Twitter, YouTube, LinkedIn).

Date: Not being offered
Time:
Location:
Instructor: Aaron Miller, Marketing and Strategic Initiatives

Back to top

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

Date: July 11
Time: 9:00am to 12:00pm
Location: MC2060
Instructor: Pavol Chvala, Information Systems & Technology

Back to top

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

Date: Not being offered
Time:
Location:
Instructor: Liam Morland, Web Accessibility Consultant, Information Systems & Technology

Back to top

Accessible Digital Design [SEW108]

All content on our websites, published as of January 1, 2012, needs to be accessible as per the Accessibility for Ontarians With Disabilities Act (AODA) as of January 1, 2014 (Web Content Accessibility Guidelines (WCAG) 2.0 Level AA, or Level A where Level AA is not feasible).

This course will show you how to use (and how not to use) colour, contrast, text size and style, visual effects (known to cause seizures), alternate text, and accessible versions to create accessible designs and web graphics and enhance comprehension of websites. It will also provide tips and resources for checking your design for accessibility. This is a non-technical course that covers the requirements and guidelines as per the AODA and WCAG 2.0, however, some technical concepts, such as colour values and contrast ratios, will be used as they pertain to design.

This course is presentation style with a group exercise to apply the concepts covered in the course material.

Pre-requisite: None

Date: Not being offered
Time:
Location:
Instructor: Andrea Sweet, Digital Initiatives, Marketing and Strategic Initiatives

Back to top

Communicating With Graphs [SEW134]

This workshop will explain how you can use charts to enhance your reports, websites, advertisements, and other communications. Discussing both the theory of design and practical examples, the topics covered will include:

  • How to determine when charts are a good option for conveying your message
  • How to design a chart that your audience will understand
  • 20+ types of charts and when they should be used
  • The pros and cons of some of the tools available for making charts

Pre-requisite: None

Date: Not being offered
Time:
Location: 
Instructor: Sarah Vela, Information Systems & Technology

Back to top

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

Date: Not being offered
Time:
Location:
Instructor: Barb Yantha, Information Systems & Technology

Back to top

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]

Date: Not being offered
Time:
Location:
Instructor: Liam Morland, Information Systems & Technology

Back to top

Accessible Word and PDF Files [SEW106]

Word and PDF files on our websites, published as of January 1, 2012, need to be accessible as per the Accessibility for Ontarians With Disabilities Act (AODA) as of January 1, 2014 (WCAG 2.0 Level A).

This course will introduce you to accessible Word and PDF files, and will provide guidelines for making Word files, and PDF files created from Word files, accessible.

Note: This is an introductory course intended for beginners in using templates and styles in Word. This course does not cover creating accessible PDFs in Adobe Acrobat Pro.

Pre-requisite: Familiarity with Microsoft Word for Windows. Introduction to Web Accessibility [SEW026] is recommended.

Date: Not being offered
Time:
Location:
Instructor: Andrea Sweet, Digital Initiatives, Marketing and Strategic Initiatives

Back to top

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).

Date: July 6
Time: 1:30pm - 3:30pm
Location: EC5, 1111
Instructor: Joe Kwan, Digital Initiatives, Marketing and Strategic Initiatives

Back to top

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.

Date: Not being offered
Time:
Location:
Instructor: Joe Kwan, Digital Initiatives, Marketing and Strategic Initiatives

Back to top

Social Media Measurement [SEW127]

Social media has become an important tool in communicating on campus. Our efforts in pushing content, engaging with our audiences and promotion of events can take a large investment of time, but is it worth it? By understanding social media measurement techniques and concepts we can better show the return on investment to justify continued social media use.

This workshop will outline some basics on how to measure your social media efforts using Hootsuite, Google Analytics and other tools.

Pre-requisite: A basic understanding of social media is required.

Date: July 20
Time: 1:30pm - 3:30pm
Location: EC5, 1111
Instructor: Aaron Miller, Marketing and Strategic Initiatives

Back to top

Understanding Information Architecture [SEW119]

If you have ever been involved in organizing the content on your website then you are doing what is known as “information architecture.” This course will introduce you to the basic principles of information architecture so that you are better equipped to make sound decisions about how to organize your content. You will also learn several best practices and participate in a group exercise that will tie together concepts learned in the course. This course is for everyone who has a role in maintaining a website regardless of whether it is in the WCMS or not.

Note: this course was titled Organizing your Website Content [SEW118] and some of the course content has changed.

Pre-requisite: None

Date: Not being offered
Time:
Location:
Instructor:

Using Email Safely [SEW136]

Email is an indispensable tool in the University of Waterloo office environment.  However, its use does pose threats to the security of University data and computers.  This course will discuss the information security issues around email use and advise attendees on how to safely use it on a daily basis.  We will discuss the ways in which malicious email threatens computers and how hackers target victims.  We will look at ways to recognize malicious email.  There will also be discussion of the use of email with sensitive information.  There will be hands-on computer activities and a short video presentation.

Date: Not being offered
Time:
Location:
Instructor: Terry Labach, Information Systems & Technology

Back to top

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]

Date: Not being offered
Time:
Location:
Instructor: Elizabeth Rogers, Digital Initiatives, Marketing and Strategic Initiatives

Back to top

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. Please note: two half-day course.

Pre-requisite: None

Date - July 5 & 6,  August 1 & 2
Time: 9:00am - 12:00pm
Location: MC1078
Instructors: Elizabeth Scott, WCMS Training & Support, Information Systems & Technology

Back to top
 

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]

Date - July 13,  August 11

Time: 9:00am - 12:00pm
Location: MC 1078
Instructors: Elizabeth Scott, WCMS Training & Support, Information Systems & Technology

Back to top
 

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]

Date - July 18,  August 15

Time: 9:00am - 12:00pm
Location: MC1078
Instructors: Elizabeth Scott, WCMS Training & Support, Information Systems & Technology

Back to top

Questions?

Please email ISTSEW

SEW handouts

The 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.

Microsoft Office and other applications

Need to learn now? Try the web-based training by Lynda.com or Microsoft e-learning.