For support: call extension 5-Help (212-305-4357), email us,
or instantly connect to a technician with
CUbhis eSupport
Computer Classes :
Information Commons and the Health Sciences Library offer a wide variety of free Computer Classes for CUMC Faculty,
Staff and Students. The list below has specific information on classes taught by Information Commons staff, to view the schedule
of all classes and register please go to:
Information Commons is also happy to offer computer classes at your request - just contact us to work out a date and time that
is best for your department or school if you don't see a time on the calendar that fits your schedule. We do require a minimum attendance
of five people for these specially scheduled classes.
Information Commons Class List :
All classes require the basic computer skills of using a mouse and keyboard and opening and saving files.
All are one hour long except for Access I and Excel II and III, which are one and a half hours.
You must have a Columbia UNI to register and attend.
All classes take place at the Health Sciences Library 2nd floor Computer Classroom.
Classes offered by the Health Sciences Library include:
Ovid (Medline), PubMed, EndNotes, PowerPoint, Photoshop, and Poster Making
Please see the Class Calendar for details on these classes.
Class Details:
Access I: Prerequisites: Familiarity with Microsoft Word and Excel.
An introduction to Microsoft's Access database program that covers:
How tables store data
Components of a table
Using the Table Wizard
Working with existing tables
Using relationships to link tables and data
Types of relationships
Using forms to process data
Creating queries to collect data
Computer Security:
Today's best practices for keeping your data and computer secure, including special services offered by CUMC. Topics covered include:
Physical Security
Password Safety
Understanding Today's Security Threats
Using AntiVirus and AntiSpyware Programs
Firewall Software Programs
Backing Up Your Data
Corporate Time I and II:
Corporate Time is the calendar program offered by CUbhis and used widely in CUMC departments.
The beginner's class (I) includes:
Setting up your preferred Calendar view
Scheduling entries in your Calendar
Inviting others to meetings
Managing another Calendar as a Designate
Using Shared Resources in your department such as Conference Rooms
The advanced class (II) includes:
Setting default Options in your Calendar
Viewing other Calendars
Setting Viewing Access Levels for your Calendar
Using Groups
Generating suggested Meeting Times for Groups
Attaching Files to an Event
Email Essentials:
A hands-on tutorial for your Columbia email account including:
General account rules and limitations
Using CubMail
Things to consider when setting up an email program
Installing the Columbia Directory
Filtering your mail
Resolving common problems with Columbia email accounts
The future of email at Columbia
Excel I:
This class covers the basic concepts of Excel 2000:
The Excel program
The paper spreadsheet
The workbook environment
Saving a file
Entering data and navigating worksheets
Entering and correcting data
Using formulas
Opening a second file
Navigation and movement techniques
Modifying a workbook
Working with ranges
Working with functions
Editing cell content
Excel II: Prerequisite: Excel I or basic experience and knowledge of the program.
This class covers formulas, formats, charts, maps, printing and previews in Excel 2000:
Working with ranges
Working with functions
Moving and copying data
Inserting rows and ranges
Absolute references
Using the fill series feature
Formatting a worksheet
Number and text formatting
Copying and pasting formats
Special and custom formatting
Creating charts
Creating a chart sheet
Creating an embedded chart
Chart sheets vs. embedded charts
Excel III: Prerequisite: Excel I and II or intermediate experience and knowledge of the program.
This class covers the skills and concepts necessary to create charts and to use the list-management capabilities of Excel 2000:
Chart types
Modifying charts
Modifying embedded charts
Adding and deleting chart items
Moving and sizing chart items
Formatting a chart
Formatting chart text
Formatting labels
Printing chart sheets
Adding graphic objects
Formatting graphic objects
Sorting data
Sort options
Filtering data and lists
Custom and multiple option criteria
Introduction to Windows XP:
Introductory tips and tricks for using and troubleshooting Windows XP including:
Understanding the components of Windows
Configuring your Desktop
Using the Taskbar
Using the Control Panel
Finding out about your computer's resources using System Properties
Using My Network Places
Tips for web browsing with Internet Explorer
Configuring Outlook Professional for your Columbia Email account
Useful links for more XP tips and tricks
Searching your computer for files and data
XP's Help and Support Center
Introduction to Macintosh OS X:
Introductory tips and tricks for using and troubleshooting Macintosh OS X including:
Mac OS terminology
Useful Mac keyboard shortcuts
Configuring you Dock
Using Expose
Enabling the Classic Environment
Mac Menu Extras
Using System Preferences
Mac tips on the CUMC Network
Mac Mail and your Columbia email account
Configuring your Mac to print to Library printers
Useful Mac links for more tips and tricks
Remedy Help Desk Ticketing Software:
Technical Support departments and staff at CU can use Remedy to track
their work and route problems between other CU departments. Contact
Information Commons if you need access to Remedy and would like to find
out more - existing staff with Remedy accounts can come to our free
monthly training session and find out how to:
Using Remedy accounts
Creating and modifying help desk tickets
Update and track ticket status
Using problem categories
Using the work log
Creating quickfills for common problems
Viewing system Outages and linking tickets
Ticket routing to other departments
Searching tickets
Gathering ticket statistics
Information Commons also offers optional customer call back to provide courtesy follow up on any tickets your technicians mark as resolved,
insuring user satisfaction for your department.
Introduction to Scanning:
This class offers the basics of image and text scanning:
Basics of the scanner
Scanning images into Photoshop
Adjusting image size and colors
Cropping and sharpening images
Straightening and rotating images
Adjusting image brightness and contrast
Saving in different image formats
Using Optical Character Recognition for text scanning
Editing and saving in text formats
Scanning text for printing
Importing images into documents and presentations
Wireless@CUMC:
Tips and tricks for using your wireless card and being on the CUMC wireless network, Rome.
Home