College of Staten Island
 The City University of New York

Office of Information Technology Services
 Faculty & Staff Training Schedule

Winter 2017 Training

Tuesday Sessions 10:00am – 11:30am.

PowerPoint  January 10th, 2017
Windows Movie Maker January 17th, 2017
Illumira (formerly known as NJVID) January 24th, 2017

Please contact the OTS Training Team at extension 2345 to register for a session.

Hands-On Meet, Greet, & Learn One-on-One Session

One-on-One is a 20-minute session based on your choice of topic. Sessions will be held on the following dates:

Tuesday Sessions 2:30pm – 4:00pm 

December 20th, 2016
January 17th, 2017

You must register online for a One-on-One session. Someone will follow up with you to confirm the date and time of your registration. Please reserve your One-on-One session at least 1 week in advance.

Topics Offered

MS Access I

  • how to create, open & save a database
  • import/export text files
  • create tables

MS Access II

  • create basic queries

MS Access III

  • create basic forms
  • create basic reports

Adobe Acrobat

  • convert MS Office documents to a PDF
  • how to create a form
  • create a writable PDF document

MS Excel I

  • difference between a workbook and a worksheet
  • set up a document
  • change default settings

MS Excel II

  • create a template
  • apply conditional formatting to cells
  • group data
  • link cells within a document
  • import/export data
  • filter

MS Excel III

  • create a pivot table
  • create macros
  • perform functions

MS Excel Charts

  • create a chart
  • create a graph

General Computer Skills

  • different parts of the computer
  • add icons to the start bar (task bar)
  • create/delete shortcuts on the desktop
  • folder management structure
  • and more...

Online File Storage System (CSI MyFiles)

  • accessing the system
  • navigation
  • uploading files
  • sharing files

MS Outlook/Instant Messaging

  • create a distribution list/contact/group/address book
  • create a task
  • create a calendar
  • create an appointment
  • add attachments to appointments
  • scheduling assistant
  • message colleagues using IM

MS PowerPoint

  • create a presentation
  • how to import graphics to slides
  • create hyperlinks
  • custom animation
  • transitions

Reduced Sign On

  • accessing the system
  • setting up the password wallet

Windows Movie Maker/NJVID 

  • how to create videos using Windows Movie Maker
  • upload videos to NJVID digital media repository
  • information on using NJVID for Blackboard

MS Word I 

  • how to set up a document
  • create tables
  • create/customize ribbons/default settings
  • create hyperlinks

MS Word Mail Merge 

  • create a template
  • create mail merge