Our training workshops are offered free-of-charge to all
students, faculty and staff at Sweet Briar College. Throughout the
semester, we will schedule training workshops utilizing the TimeToMeet
scheduling system. Listed below are descriptions of some of the
workshops we offer:
Access
| Audacity
| AVerMedia
Document Cameras | Dreamweaver
| Excel
| Gmail
| Google
Calendar | Google
Docs | Google
Groups | Google
Sites | HTML
& Web Design | iDVD | iMovie |
iTunes
| Photoshop
Elements | PowerPoint|
SMART
Notebook | Word
Access
Access Level 1
In this class we cover some database terminology, how to navigate
through a database, creating, editing and working with tables and using
queries to produce reports.
Access Level 2
This class is intended for people who have taken Level 1 Access or who
are already familiar with the concepts presented in it. The Access:
Tables class will cover designing and maintaining tables in Access in
more detail, including using such features as defining default values,
creating look-up tables and using validation rules.
Access Level 3
In the Access Queries class we will learn the different kinds of queries
that can be created, and we will practice designing them. In addition,
we will focus on Query terminology and how to modify Query properties.
Access Level 4
In this class we explore creating, editing and customizing forms. Using
the formatting toolbar we will discover how to modify fonts, align text,
add borders, apply colors and use special effects. We will learn what
controls are used for and how to create them. We will also work with
headers & footers.
Audacity
Introduction to Audacity
Audacity is a free audio editor. You can use Audacity to record live
audio, convert tapes and records into digital recordings or CD's,
cut/copy/splice sounds together, and even change the speed or pitch of a
recording. It is an extremely powerful audio editor with tons of
features, and a fairly easy-to-use interface. Material covered in this
training will include:
Downloading and Installing Audacity
Recording a Spoken Narration
Discover how to set your input source Become familiar with the Audio Control buttons Learn how to Record and Playback Audio Find out how to Edit your audio by cutting, trimming, adding or
combining audio tracks Explore the secrets of removing white noise Learn how to use the Time Shift tool
Transfer a Tape/LP to CD
Discover how to configure equipment for recording Find out how to open files Explore how to fix pops and remove hiss in your recording Learn how to save files in an MP3 format Become familiar using iTunes to burn a CD
Special Effects:
Find out how to change the pitch on a recording with out changing
the tempo (and vice-versa) Learn how to apply fade-in and fade-out effects Explore other effects such as echo, repeat, and amplify
AVerMedia Document Cameras
Intro to AVerMedia Document Cameras, with a focus on Model 355AF
A document camera is basically an overhead projector on steroids!
Using digital technology this document camera gives you the ability to
project any 2D or even small 3D objects for the entire classroom or
audience to view. It is an invaluable tool for any presenter! There are
many great ways to use this device! Use it to show pages, maps or
diagrams from a book to the whole class without getting photocopies.
Project and record science experiments while you're demonstrating them!
Or, if you're an iPad user... we've found that this is currently one of
the most reliable methods of projecting your iPad's screen! Here's a
brief list of some of the things you'll learn in this comprehensive
class:
Basic Setup and Operation
Discover how easy it is to set up and configure the document
camera Learn how to switch back and forth between the document camera and
a computer screen projection Explore hardware features including an adjustable head, light and
laser guides Find out how to use either the Document Camera buttons or the
Remote to control operations
Adjusting Your Image
Find out how to quickly adjust your brightness Discover the Auto Focus and Auto Image features Learn how to use the Zoom feature to magnify your image by up to
80x Explore how easy it is to mirror or rotate your image Find out how to manually adjust your brightness, color and
contrast
Special Features
Learn how to activate an on-screen timer Find out how to emphasize just a selected area of your image Discover how to use AverVisor to gradually reveal portions of
your image (works kind of like putting a piece of paper over
transparencies on an overhead) Find out how to create Split-screen or Picture in Picture
displays Explore how you can freeze the image being projected
Recording and Playback
Learn how to capture screen shots (pictures) of your projected
image in high resolution (up to 5 MegaPixels) Discover how to create a video recording (with audio!) of your
projection Find out how to store your recordings either internally, or on an
external USB flash drive or SD Card Explore how easy it is to access stored images and videos for
playback Find out how to play back your stored images as a slide show Learn how to delete recorded images or videos
Advanced Features
Explore the device menu for ways to manually adjust the cameras
settings Learn how to return the document camera to factory default
settings (useful if someone else before you put in custom settings!)
Discover how to adjust recording quality and formats Learn how to display transparencies / slides using a light box
device
Dreamweaver
Intro to Dreamweaver CS4
Dreamweaver CS4 is the latest version of the very powerful and
flexible web authoring tool by Adobe. This software gives you the
ability to create professional level websites, utilizing some of the
latest web technologies.
Getting Started
Defining your site Editing your site information Getting to know the workspace Titling your page Adding text to your page Connecting to the server Putting files on the server Getting files from the server
Designing & Viewing
Adding to the font list Inserting special characters Applying headings Changing text color Changing the background color Defining paragraphs Using Text Indent to block quote text Adding a horizontal rule Adding the date & time to your page Using the spell check Using guides Using the Zoom tools Switching view modes Previewing in a browser Using Live View
Images
Adding images Resizing images Using placeholder images Adding a background image Cropping images Adjusting the brightness & sharpness Adding links & alternate text Creating a rollover image Adding a border to an image Setting image alignment Increasing the space around an image
Links
CSS
What is CSS? Using a predefined style sheet Creating a new style sheet Attaching a style sheet Using the Property Inspector to edit CSS rules Deleting a style or style sheet Moving styles
Build AJAX components with Spry
What is AJAX? What is Spry? Adding a Spry widget Adding Spry effects
Lists & Tables
Working with Templates
Managing Site Assets
Finding files in the site Using the Related Files toolbar Jumping straight to code using the Code Navigator Disabling and enabling the Code Navigator
Excel
Excel Basics
Excel is an electronic spreadsheet porgam useful for storing, organizing
and manipulating data. It has extremely powerful number-crunching tools
and is often used in business, statistics and accounting fields. This
class is designed to help you become familiar with the basic operation
of the Microsoft Excel program. Here's a brief list of some of the
things you'll learn in this comprehensive class:
Navigational Overview:
Working with Cells:
Explore how to enter and edit data Learn how to save time with AutoFill and Auto Complete techniques
Become familiar with various shortcuts for copying and clearing
information
Formulas and Functions:
Find out the difference between formulas and functions, and how to
use them Discover the secret of relative and absolute cell references and
how to make them work properly for you Learn how to trouble-shoot your formulas when errors occur
Formatting Cells:
Make your boring black & white Excel spreadsheets look vivid
and exciting by adding color, borders, and formatting your text! Find ways to make your data fit your page better, such as
alignment, rotation and text wrapping
Working with Columns and Rows:
Learn to resize your column width or your row height to fit your
content Discover how to insert or delete columns, rows and cells
Workbook Views & Page Setup:
Find out the difference between various views of your data Explore how to customize your page setup to change your page
orientation, paper size and margins Learn how to utilize headers and footers
Printing:
Excel Charts and Pivot
Tables
Excel is a powerful program... but trying to make sense out of pages and
pages of text can be difficult! That's where charts and pivot tables
come in. These tools allow you to better understand your data. Charts
let you see a graphical representation of your data. There are many
different types of charts that you can use for different kinds of data.
Pivot tables allow you to easily summarize and analyze your data. You
can quickly rearrange pivot tables to show different results making it
much easier than trying to interpret your data by reading it
line-by-line. Here's a brief list of some of the things you'll learn in
this comprehensive class:
Basic Overview of Charts
Selecting chart data in adjacent cells Selecting chart data in non-adjacent cells One step charting Identifying the elements on a chart
Different Types of Charts and How They?re Applied
Creating column and bar charts Creating line charts Creating pie and doughnut charts Creating scatter and bubble charts Creating area charts Creating radar charts Creating surface charts Creating stock charts Changing the chart type
Formatting Your Chart
Adding titles and labels Formatting the chart area Adding a border and/or patterns to the plot area Formatting the axis properties Setting Format options for titles and labels Setting the placement and font for the legend Changing the data series Changing the data series pattern or marker Changing the shape of a 3D data marker Changing the plot order Resizing and repositioning Showing or hiding the data table Changing the gap width and gap depth values Changing the elevation and rotation of 3D charts Pulling out slices in pie or doughnut charts Incorporating a graphic or picture in your chart Creating a chart template for applying custom formatting
Presenting Your Chart
Placing a chart on a separate chart sheet Printing your chart sheet Printing embedded charts Inserting a static copy of your chart Inserting a linked copy of your chart into Word or Powerpoint
Basic overview of Pivot Tables
Creating & Deleting Pivot tables
Working without a pivot table wizard Manually laying out a pivot table Using the classic pivot table layout in the grid Selecting different source data Deleting a pivot table
Customizing the Appearance & Layout of Pivot tables
Adding and removing fields from a pivot table Adding and using a report filter Changing the data area number format Changing how empty cells are displayed Formatting a pivot table Filtering and Sorting a pivot table Viewing detail data for an item Viewing detail for a data cell Grouping pivot table items by dates Printing a pivot table with column & row field names Inserting automatic page breaks after each row item Copying a pivot table
Summarizing Pivot Tables with Totals & Formulas
Displaying grand totals Changing the data summary function Creating a calculated field Inserting a calculated item Listing the existing formulas used in a pivot table Refreshing pivot table data
Pivot Charts (feature not available on Excel 2008 for Apple)
Creating a pivot chart from an existing pivot table Creating a pivot chart from scratch Changing the layout of a pivot chart Converting a pivot chart to a static chart
Excel Level 2
The second level of Excel covers a number of tricks for working with
multiple worksheets. This includes viewing and selecting multiple
worksheets, using formulas that link worksheets together, renaming and
inserting worksheets, sorting and filtering data.
Gmail
Introduction to Gmail
Gmail is a free web-based email platform by Google. Using the resources
that only an internet giant like Google could provide, email can become
fun again! With extremely advanced SPAM filtering technology, you don't
waste your time deleting massive amounts of unwanted emails. Gmail has
mobile access available so you can check your mail with portable devices
like iPod/iPhones, PDA's and Smartphones. Plus, with huge storage
capacity (over 7GB per account!) you don't need to worry about
constantly deleting messages to clear your quota. It is an intuitive,
easy and efficient way to communicate via email. Here's a brief list of
some of the things you'll learn in this comprehensive class:
Getting Started
Your Messages
Understanding your inbox Understanding message size and limits Composing a message Selecting contacts while composing Formatting a message Adding attachments Sending a message Replying to messages Forwarding a message Forwarding an entire conversation Saving drafts Hiding addresses when sending to multiple recipients Sending Web links Reading conversations Understanding sidebar icons Marking messages read or unread Printing messages Understanding calendar links Removing spam Unmarking spam messages Creating spam filters Using "View as Slideshow" Playing MP3 file attachments
Organizing Your Messages
Creating filters Applying the same filter to many senders Creating a filter for the message you're reading Editing & Deleting Filters Creating and using labels Editing labels Changing label colors Applying an action to everything in a label Deleting messages Recovering deleted messages Emptying the trash Archiving mail Understanding All Mail Searching Gmail Using advanced search features Searching in the spam and trash
Your Contacts
Creating contacts Editing contacts Adding photos to a contact Adding a contact group Adding a contact to a contact group Removing a contact from a group Understanding default contact groups Searching for contacts Importing contacts Exporting contacts from other mail providers Exporting Gmail contacts Sending messages to a contact group Printing your contacts
Chat
Chatting with someone Inviting someone to chat Changing your status Seeing who's online and available to chat Chatting with non-Gmail users Turning chat off Keeping contacts visible in the chat list Blocking contacts Customizing the chat list Adjusting AIM buddies' visibility in Chat Joining a group chat Chatting off the record Add Audio / Video Chat Setting sound notifications for chat
Your Settings
Setting Your Language Using Keyboard Shortcuts Setting your Google picture Creating a Signature Enabling a Vacation Responder Learning how to Send Mail from an Alternate Email Address Discovering how to Get mail from other Accounts Changing your Password Forwarding all Messages to another Email Address Enabling POP for use in other e-mail clients Enabling IMAP for use with other e-mail clients Customizing Web Clips for Gmail Experimenting with Google Labs Discovering how to Change Themes
Extras
Downloading the Gmail Notifier or Quick Tools for Google Apps Changing Google Notifier settings Making Gmail your default mail application Viewing your account activity How to Get Additional Help
Google Calendar
Intro to Google Calendar
Google Calendar is an online calendar application. It's an extremely
powerful system, yet very intuitive to operate. One of the most useful
aspects is the ability to share and collaborate on calendars with other
users. It is also nice to be able to access your calendar from any
computer in the world with an Internet connection... plus you can
configure your Mobile Devices to access it too! Here's a brief list of
some of the things you'll learn in this comprehensive class:
Getting Started
Google Calendar Basics
Changing Calendar Views Creating Events Check guest and resource availability Setting Event Notifications Privacy Options Adding Guests Editing Events Repeating events Show a map link Using the Quick Add feature Printing your calendar
Adding Calendars
Subscribing to Public Calendars Adding a friend’s calendar Adding a Calendar from an URL Importing a Calendar from another program Displaying & Hiding Calendars
Creating a New Calendar in Your Account
Learn to Create additional calendars Share your Calendar with Others Change the Color of your Calendar Assigning an Event to a particular calendar in your Account Moving or Copying events between calendars Change owner of event
Settings
General Settings Delete or Unsubscribe from Calendars Learn to Embed your Calendar in a Website Explore Public and Private Calendar addresses Enable notifications to be sent to your mobile device Use Sync to synchronize your calendar with smart-phones Discover extra capabilities in the Google Labs section
Help
How to access Google Help How to get help on campus Additional support resources
Google Docs
Intro to Google Docs, with a Focus on Web Forms
Google Docs is the document portion of Google Apps for Education. With
Google Docs, you can create word processing documents, spreadsheets,
presentations and even web forms online! Google Docs also enables easy
sharing, collaboration, and storage of your files. By using the forms
feature, you can easily create and manage surveys and other forms for
gathering information through your website.
Here's a brief list of some of the things you'll learn in this
comprehensive class:
Basic Operation
Learn how to create new documents, presentations and spreadsheets
from scratch Discover how to organize your files with folders Explore working with templates Become familiar with uploading files Find ways to share your documents with others Discover how to export files in common formats including:
Microsoft Office, PDF, and HTML
Creating Forms
Learn how to create a form from scratch or from a template Explore a variety of different design themes for your form Become familiar with the various question types and options
available for your form
Working with Form Submissions
Discover how to receive notifications of new submissions Find out how to "close" a form so additional responses are not
accepted Learn how to view a summary of responses Find out how to embed your form in any web page
Useful Tools for Documents
Find out how to easily translate documents to other languages Learn to check spelling, in your choice of language Discover how to look up definitions, synonyms, encyclopedia
entries, translations and web search results for individual words
Advanced Features
Learn how to create and insert drawings Find out how to embed a presentation with a player in your website
Discover how to work with Google Docs when you're offline Explore how to customize your Google Docs settings Become familiar with how to access Google Docs with some Mobile
devices
Google Groups
Intro to Google Groups
Google Groups is a customizable area for creating and maintaining
custom groups of members. Your members will have access to discussion
boards and a group list-serve email address, enabling them to easily
communicate with each other via the web or email. Best of all, you have
complete control over your member list and can easily add or remove
members at any time! Here's a brief list of some of the things you'll
learn in this comprehensive class:
How to Find an Existing Group at SBC
Learn what to do if you're invited to join a group via email Discover how to browse existing groups at SBC Find out how to search for groups at SBC
How to Create Your Own Group
Become familiar with the basic settings Learn how to name your groups email and web address Find out how to set access restrictions Check guest and resource availability Discover how to add members
How to Add, View and Reply to posts
Learn how to post to the discussion board via the web or
email Find out how to view and reply to posts Discover how to rate postings Become familiar with sorting and arranging your view of the
posts
How to Adjust Your Personal Membership Settings
Learn to adjust your reading preferences to reduce or
eliminate the number of emails you'll receive Find out how to set a nickname for other members to see when
you post Discover how to unsubscribe from a group
How to Adjust Your Group Settings
Learn about the general settings Discover how to fine-tune the access to your group Explore ways to customize the appearance of your group Find out how to adjust the email delivery options Become familiar with some advanced settings, including
deleting and/or archiving your group
How to Work with Your Management Tasks
Find out how to review pending messages and/or members Explore how to manage each members specific access to your
group Discover how to determine if any member's email address is
bouncing back your messages Learn how to subscribe your entire group to another group
Advanced Tips & Tricks
Discover the trick to sharing your Google Calendar, Google
Sites or Google Docs with all your group members Find out how to transfer the ownership of your group to
another user Learn how to translate posts that are written in a foreign
language
Google Sites
Intro to Google Sites
Google Sites is a free and easy way to create your own websites.
Using their pre-made page templates and themes, you can quickly add your
own content and create professional looking websites. You can even
control who can view or edit your content in your site. It's an
extremely powerful system, yet very intuitive to operate. Here's a brief
list of some of the things you'll learn in this comprehensive class:
Creating a Site
Learn how to work with Site Templates, including one designed
especially for Sweet Briar College! Discover how to name your site Explore how to use different Themes Find out how to create a basic web page
Editing Your Pages
Learn how to use the tool bar Discover how to insert objects into your site, including:
images, links, lines, maps, documents, videos and more! Find out how to format your page Become familiar with tables Explore the different pre-designed layout configurations
available for you to use
Creating Pages Using Templates
Find out how to create an Announcement Page, great for posting
chronological information such as news, blogs, status updates or notable
events Learn about File Cabinet Pages, which allow you to manage and
upload documents from your computer to your website Discover how to use List pages to track information such as
Action Items, Issue Lists, Unit Status or your own custom configuration
Become familiar with creating a Start Page that your website
viewers can customize with their own personalized set of gadgets
Advanced Features
Learn how to work with your revision history Discover how to subscribe to page or site changes Find out how to change your page settings Become familiar with printing, moving, deleting and previewing
your pages Explore the various User Setting options
HTML & Web Design
Intro to Web Design
This class introduces the novice to very basic HTML, web design
principles and web lingo. If you are a newcomer to creating and
maintaining web pages, this is the place to start. Here's a brief list
of things covered in this class:
Know Your Audience
Learn the importance of understanding your Audience Identify who your target audience is Determine why your Audience would be interested in your site Discover what your audience wants
Web Design Principles
Find out how to achieve consistency throughout your site Follow the basic principle of "less-is-more" Learn to apply visual logic to your pages Discover techniques to establish easy-to-navigate pages Review and Assess Web Site Examples Learn how to analyze other web sites Determine the difference between high-quality and low-quality
sites Find out how web design principles could be used to improve sites
Image Files
Servers
Web Site File Management
Discover the importance of good file organization for websites Find out when to use folders to separate your content Learn about proper file & folder naming techniques
HTML
Develop a basic understanding of the coding that makes websites
work Become familiar with the basic structure of HTML tags Find out how to view the code on any website you visit Learn some of the basic and common HTML tags
iDVD
Intro to iDVD
Learn to create DVD video discs complete with full-motion menus
and scene selection buttons and/or DVD slide shows.
iMovie
Intro to iMovie
Apple's iMovie software is a digital video editing application. The
newest version iMovie '09 is completely different from earlier versions
and packed with great new features! With iMovie, you can easily capture
footage from your digital camera, edit your movies, and add audio &
visual effects. It is a powerful tool for the amateur or intermediate
filmmaker. Material covered in this training will include:
Importing Video
Learn how to access video from your iPhoto library Find out how to import videos from your hard drive or USB video
video camera Discover how to import video from a FireWire camcorder
Events Browser Playback
Explore the technique of skimming through your video clips Learn how to make selections and play clips, including how to
change the viewer size Become comfortable working with frames and thumbnails
Managing Events
Learn how to rename, merge, split and create new events
Find out how to move clips to other events Learn about rejecting clips and unmarking rejected clips Discover how to move clips and events to the trash
Projects
Discover how to create new projects Learn how to play your project Explore various trimming techniques Find out how to use the Precision Editor Become comfortable fine tuning a clip, splitting clips and
joining clips
Clip & Video Adjustments
Learn how to crop a clip Discover how to rotate a clip Find out how to apply or remove a Video effect Become familiar with how to change the speed of a clip Learn how to stabalize a clip Explore ways to change brightness & contrast, adjust
saturation and make white balance corrections
Audio Clips & Adjustments
Discover how to change the volume of a clip Learn how to add background music Explore ways to trim audio, add fades and normalize audio Find out how to add sound effects Learn ways to duck, pin, unpin and detach audio Find out how to record a narration Become familiar with how to change the music order
Photos
Learn how to add photos from iPhoto Find out how to fit a photo in the frame Explore how to use the Ken Burns Effect Discover how to change initial Photo Placement properties Learn to change & set the duration of a photo Find out how to make photo adjustments
Titles, Maps & Markers
Discover how to add and delete titles Learn how to edit titles Explore how to add an animated map of your travels Find out how to add Chapter markers
Transitions
Advanced Tools Features
Sharing
Learn how to export your movie Find how to send your movie to iTunes Discover how to export to iDVD Learn how to publish directly to YouTube
iTunes
Intro to iTunes
Learn to organize and listen to all you music and audio on your
computer. You can listen to your CD's, buy individual songs on-line,
create lists of your favorite songs, make your own CD's or DVD's, share
your music library with others and listen to internet radio stations.
Photoshop
Elements
Intro to Photoshop Elements
This class will cover the basics of manipulating images in Photoshop
Elements, using the tools palette, and preparing images for the web.
PowerPoint
PowerPoint Basics
PowerPoint is a presentation software that you can use to provide
visual aids for an oral presentation. Here's a brief list of some of the
things you'll learn in this comprehensive class:
Getting Started
Text Formatting
Selecting, Editing and Formatting Text Using the format painter command Changing the character case Using cut, copy, and paste Working with the Clipboard (Windows) or Scrapbook (Apple) Inserting hyperlinks Using drag and drop editing Using undo and redo Using the spell checker
Paragraph Formatting
Aligning paragraphs horizontally and vertically Changing the line spacing Changing the text direction Setting tabs using the ruler Using bullets in a placeholder Demoting and promoting bullets Customizing bullets Creating numbered lists Indenting paragraphs
Managing Slides in Different Views
Inserting Content Objects into Slides
Inserting a table into a slide Inserting a chart into a slide Inserting a SmartArt graphic into a slide Inserting a picture into a slide Inserting clip art into a slide Inserting a media clip into a slide Inserting Shapes Inserting WordArt Rotating objects and shapes
Slide Design
Changing a Slide Layout Using slide themes Changing background styles Applying animations Applying transitions Changing the page setup Looping the slideshow Adding a music soundtrack Inserting a footer into a slide
Printing and Displaying a Slide Show
SMART Notebook
Intro to SMART Notebook
Did you know that we have touch-screen capabilities in many of our
computer labs and other locations on campus? We use SMART Board and
SMART Podium products to give you interactive capabilities with your
projected display. There are many great features you can use with these
products by learning how to operate the SMART notebook software. These
tools are certainly useful in the classroom for instruction, but are
also beneficial for administrative departments and students giving
presentations. Material covered in this training will include:
Basics
Using SMART Tools
Show how to use pens and erasers Demonstrate various methods for adding text, including handwriting
recognition Explore working with shapes and lines Learn how to use the “Magic Pen” to utilize fading text, zooming
and spotlight features
Explore the object menu
Learn how to copy, paste, cut, delete, move, rotate and resize
objects Find ways to add animation to your object Discover how to group and ungroup objects Learn to change the order of objects by sending them forward or
backward Find out how to add a hyperlink to your object Explore ways to customize your objects by setting object
properties
Working with the Gallery
Learn how to browse and search the gallery to add pictures,
backgrounds, multimedia and other activities to your pages Explore the online resources available to add additional classroom
resources
Capturing
Working with Pages
Discover how to navigate through your pages Become comfortable adding, deleting, renaming and changing the
order of your pages Learn how to use active alignment to orient objects on your page
Advanced Features
Learn how to use and customize the floating tools Discover how to annotate directly over other applications Become comfortable working with the magnifier, screen shade, and
zoom tools Find out how to use the built in recorder to create a video file
of all your activities
Word
Word Level 2: Styles and More
Level 2 Word covers the use of styles, building tables of contents,
bookmarks, cross references, section breaks, headers and footers and
that most mercurial of MS Word phenomena: page numbering. If you would
like to learn a few tricks that will help you make your papers and
reports look more professional, come to this class.
Word Level 3:Templates, Mail Merge and Tables
In Level 3, we focus on Word features that make common office tasks
more efficient. We cover the use of templates and forms as well as how
to generate mailing labels and form letters using mail merge. In
addition we will learn how to use tables to enhance the formatting and
page layout of your information.
|
