|
|
It
is recommended that you take the Introduction before you take any
others. |
| Introduction |
Overview
of Access Database Components (Tables, Queries, Forms, Reports, Macros,
Modules) -- Creating a Table in Access -- Data Types (Text, Numeric,
Date, Memo…) -- Input Masking -- Simple Query -- Demo of Input Form
-- Demo of Report |
| Forms
|
Using
a Database with Multiple Tables -- Creating an Input Form -- Formatting
the Input Form -- Standardizing Data for Input -- Data Entry Error
Reduction |
| Queries
& Reports
(prerequisite: Intro) |
Running
Queries on a Single Table -- Linking Tables -- Running Queries on
Multiple Tables -- Creating a Report from a Query -- Formatting a
Report |
| Advanced
Queries & Reports
(prerequisite: Queries & Reports) |
Using
Calculations in a Query -- Creating New Fields in a Query --Using
Calculations in a Report -- Summing v Averaging -- Counting -- Creating
a Summary Report --Sorting and Grouping in a Report -- Changing the
Format of an Existing Report |
| Action
Queries
(prerequisite: Advanced Queries &
Reports) |
Update
Queries -- Append Queries -- Delete Queries -- Make Table Queries
-- Exporting Data to Excel |
Importing
& Exporting
(prerequisite: Intro)
|
Data
Types That May be Imported -- Steps to Import Data -- Steps to Export
Data -- Publishing Access Reports in Word -- Publishing Access Reports
in Excel
Date
& Times |
top
|
|
|
|
Want
to avoid lawsuits? Ignorance of the law is no excuse! Fair Use does
NOT cover every aspect of copyright for faculty. Find out the myths,
urban legends and then the truth! Why is it vital for faculty to
know and understand such terms as fair use, educational, not for
profit, spontaneity, and use of proportions of a variety of formats?
Date
& Times
|
top
| Introduction
to Web Design |
Introduction
to Web Design: What to know before you jump in! |
|
How
the World Wide Web works; resources available at SCSU; the process
of designing a Web site; planning and layout tips; avoiding common
mistakes; and publishing your Web site. This workshop is lecture-based
and provides an opportunity for participants to ask questions about
the Web site development process.
Date
& Times
|
top
| Dreamweaver
MX-I |
Macromedia
Software
(limit 8 per class) |
|
Dreamweaver
MX: Part1 – Basic Introduction
Dreamweaver MX is a
Web editing software program. Dreamweaver is available for both
PC and Macintosh, and the program is very similar for both platforms.
All Dreamweaver workshops will be taught using both platforms. Participants
should have general computer skills. Please arrive promptly for
all workshops, as there is much material to be covered.
This workshop is a basic introduction to the program. It focuses
on creating a new page, inserting and formatting text, inserting
an image, adding links, and previewing the page.
Date
& Times
|
top
| Dreamweaver
MX-II |
Macromedia
Software
(limit
8 per class)
|
|
Dreamweaver
MX: Part 2 – File Management and Uploading
Prerequisite:
Dreamweaver I
This workshop is a continuation of Dreamweaver MX I. You will activate
your SCSU Web space account at the beginning of the workshop. Then
you will learn how to define and edit a site, manage files and folders,
create a navigation bar, and upload the site to a server. Please
arrive on time.
Date
& Times
|
| top
|
|
| Dreamweaver
MX-III |
Macromedia
Software
(limit
8 per class)
|
| |
Dreamweaver
MX: Part 3 – Page Layout
Prerequisite:
Dreamweaver I
This workshop provides more details pertaining to images and links.
It teaches participants how to create and modify tables, view source
code, and use other features.
Date
& Times
|
| top
|
| Dreamweaver
MX-IV |
Macromedia
Software
(limit
8 per class)
|
| |
Dreamweaver
MX: Part 4 - Interactive Images
Prerequisite:
Dreamweaver I
Workshop participants learn how to create an image map, a rollover
image, and interactive navigation bar.
Date
& Times
|
| top
|
|
| Dreamweaver
MX-V |
Macromedia
Software
(limit
8 per class)
|
| |
Dreamweaver MX: Part
5 – Creating Efficiencies
Prerequisite:
Dreamweaver IV.
Participants will learn how to create and use library items and
cascading style sheets (CSS), and create links to other files such
as PDF, PowerPoint, and MS Word.
|
| top
|
|
| Date
& TimesDreamweaver
CourseBuilder |
Macromedia
Software |
|
Prerequisite:
Dreamweaver I & 2.
Make interactive Java applets based Web pages, without knowing Java
or Java Script. Great for active and interactive learning
Date
& Times
|
Date
& Times
Macromedia Captivate |
Do your own interactive handouts! |
| |
Captivate is another Macromedia/Adobe product that goes hand-in-hand with your Web-based materials. It is an intutive software that creates engaging online interactive handouts, tutorials and simulations. The output is on Flash format, which guarantees Internet-friendly documents. The use of the software can increase course value through better communication and comprehension of material
Date
& Times |
top
|
Microsoft Excel
|
It
is recommended that you take the Introduction before you take any
others. |
| Introduction |
Overview
of Workbook and Worksheets -- Terminology -- Navigating in a Worksheet
-- Entering Data in a Worksheet -- Using Toolbar Functions -- Copying
Data -- Copying Formulas -- Naming a Workbook -- Naming a Worksheet
|
| Charting
(prerequisite:
Intro) |
Overview
of Types of Charts -- Chart Terminology -- Creating the Chart -- Changing
the Chart's Appearance v Pie Charts -- Bar and Column Charts |
| Formatting
& Formulas
(prerequisite:
Intro) |
Setting
up Formulas using Paste Function -- Sum, Average, Min, Max -- Typing
Formulas -- Nesting Formulas -- Formatting Cells -- Number Formatting
-- Text Formatting |
| Macros |
Recording
a Simple Macro -- Running a Macro -- Understanding the Code -- Writing
Simple Code -- Using Range Names in Macro Code |
| Using
Multiple Worksheets |
Creating
and Naming Multiple Worksheets -- Creating Identical Worksheets --
Creating Formulas Across Worksheets -- Naming Cells and Cell Ranges
-- Using a Summary Sheet |
Vlookup
& Pivot Tables / Grade Books
(prerequisite:
Intro)
|
Defining
Range Names -- Using the Vlookup Function in a Grade sheet -- Defining
a Database -- Filtering Data in a Spreadsheet -- Using Pivot Tables
Date
& Times
|
top
| PowerPoint
I |
Presentation
Software |
| |
Introductory
instruction in creating a PowerPoint presentation. Hands on in choosing
presentation templates, using the view buttons, overview of basic
tools, creating an outline, changing templates and layouts, and
adding clipart. Prerequisite to PowerPoint II.
Date
& Times
|
top
| PowerPoint
II |
|
| |
Prerequisite:
PowerPoint I.
Hands on instruction in customizing and adding special effects to
PowerPoint presentations. Learn how to customize the slide master
and to apply color schemes, animation's, transitions, and hyperlinks.
Date
& Times
|
top
| PowerPoint
Tips & Tricks |
|
| |
Hands
on instruction in customizing and adding special effects to PowerPoint
presentations. Learn how to customize the slide master and to apply
color schemes, animation's, transitions, and hyperlinks.
Date
& Times
|
top
| PowerPoint
Audio Streaming |
|
| |
Add
audio to PowerPoint presentation and export it as a Streaming
file.
Date
& Times
|
|
|
| |
|
| Scanning |
Basic
Principles of Scanning |
| |
Hands-on
experience of some scanning basics! Learn about adjusting and manipulating
your images, scanning applications, saving as different file formats,
using your scanned images, and copyright issues. Bring a few images
for workshop practice.
Date
& Times
|
| |
|
| SmartBoards |
Instructional
Enhancements |
| |
View
and experience a few of the many option that portable Smart Board
technology has to offer. Connect a laptop, data projector and software
to create dynamic, interactive and interesting lessons and presentations.
Date
& Times
|
top
| |
Online
Classroom Management |
| |
It
is recommended that you take one of the following three sessions before
you take any of the other sessions. With the exception of the Exploring
D2L workshop, you will need a D2L account for these sessions. It is
also to your benefit to bring floppy or zip
disks with the course files and/or images that you wish to
include in your D2L course -- the sessions provide opportunities for
practical hands-on activity. Handouts will be available on most topics
covered |
| Crash
Course for experienced WebCT Users |
A
course for experienced WebCT Users that explores similarities and
differences between D2L and WebCT. Don’t expect to learn how
to do things in D2L in this workshop if you don’t already
know how to do it in WebCT. This workshop is meant to help bridge
the gap in features and terms going from WebCT to D2L.
Length of Workshop: 2 hr.
|
| Exploring
D2L |
Overview
of D2L features. Enter a D2L course as a student and explore some
of D2L’s features. Receive information about training, documents
and how to request a D2L course. This workshop can be taken at any
time to see what Desire2Learn is all about.
Length of Workshop: 1 hr.
|
Intro
to D2L
|
Prerequisite
to all other D2L workshops (except Exploring D2L which is a stand
alone) This course should be taken before any other workshops. All
other workshops can be taken in any order. You will set preferences,
learn basic terminology, explore My Home, Home Course and Edit Course
pages, setup a personal Homepage, create a personal profile.
Length of Workshop: 1 hr.
|
| |
Series
of nine D2L Workshops
(individual registration required for workshops) |
| 1-
Customizing your Course |
Prerequisite:
Intro to D2L
You
will customize your course colors, add/remove/rename course tools,
set up top navigation bar, create custom links, edit help files,
and make available tools to your participants
Length of Workshop: 1 hr.
|
2-
Communication Tools (Part 1)
|
Prerequisite:
Intro to D2L
Learn about these
D2L features:
-Calendar is a tool used to display upcoming events.
Add course information such as project due dates, office hours,
in-class events, etc.
News is a place to post important events. Post announcements or
important notices.
-Pager informs you who is online and allows you
to contact them (like an instant messenger)—introduced in
Intro
-Class list is a directory of names, emails, and
group settings for quick access to students.
Length of Workshop: 1 hr.
|
| 3
-
Communication Tools (Part 2) |
Prerequisite:
Intro to D2L
Learn about these
D2L features:
-Email
can send and receive messages (either internal or HuskyNet
email)
-Discussions is a place to read and add messages
to discussions. Create new discussion rooms, set group permissions,
and view discussion statistics.
-Chat is a synchronous area where you can talk
in online real-time discussions.
Length of Workshop: 1 hr. |
| 4
-
Quizzing |
Prerequisite:
Intro to D2L
Create quiz questions
in Question Library, set up quiz, link grade to gradebook, set up
the quiz properties. (Optional – Surveys)
Length of Workshop: 1 hr.
|
| 5
-
Dropbox (Assignment Tool) |
Prerequisite:
Intro to D2L
The Dropbox is
an exchange of files between the instructor and students. Set up and
manage this Dropbox or assignment tool.
Length of Workshop: 1 hr. |
| 6
-Gradebook |
Prerequisite:
Intro to D2L
Post grades associated
with assessments. (Optional – Statistics and Checklist)
Length of Workshop: 1 hr. |
| 7
-
Content 1 (Creating and Managing Files) |
Prerequisite:
Intro to D2L
Create, upload
and organize files. (Optional – WebDAV, Web Pages from Word)
Length of Workshop: 1 hr. |
| 8
-
Content 2 (Organizing and Managing Content) |
Prerequisite:
Intro to D2L
Link and Organize
files (topics) into Modules (Optional – Glossary, FAQ and Links)
Length of Workshop: 1 hr. |
| 9-
Teacher and Student Tools |
Prerequisite:
Intro to D2L
Manage Students,
Course Feedback, Broken Link Viewer, Classlist (managing groups),
Locker and Journal. These tools can be incorporated into your course.
Length of Workshop: 1 hr. |
top
|
Microsoft Word
|
It
is recommended that you take the Introduction before you take any
others |
| |
Hands-on
experience of some scanning basics! Learn about adjusting and manipulating
your images, scanning applications, saving as different file formats,
using your scanned images, and copyright issues. Bring a few images
for workshop practice. |
| Introduction |
Office
Assistant--Overview of Toolbars--Views--Margins--Tabs--Spellchecker
--Alignment --AutoCorrect Features--Autosaving --Saving and Saving
As |
| Formatting
(prerequisite: Intro) |
Fonts
[Default font, Types of fonts, Size of fonts, Special Effects (Animation,
Drop Cap, Attributes)] -- Borders & Shading -- Line Spacing -- Widows
and Orphans -- Format Painter -- Bullets |
| Graphics
& Word Art |
Using
Drawing Tools -- Formatting Graphic Objects -- Grouping and Ungrouping
Objects -- Working With Text Boxes -- Using Word Art -- Using AutoShapes
|
| Indexes
& Tables of Contents |
Setting
Styles for Table of Contents -- Inserting Table of Contents -- Updating
Table of Contents -- Overview of Creating an Index -- Marking Index
Entries -- Creating an Index |
| Macros |
Overview
of Macros -- Planning a Macro -- Recording a Macro -- Running a Macro
-- Assigning a Macro to a Keyboard Shortcut -- Assigning a Macro to
a Toolbar Button -- Editing a Toolbar Button -- Deleting a Macro and
a Toolbar Button |
| Mail
Merge
(prerequisite: Intro) |
Creating
the Main Document -- Creating the Source Document -- Merging to Printer
-- Merging to New Document -- Selecting Specific Records |
Mail
Merge
Excel & Access
(prerequisite: Intro)
|
Creating
the Main Document in Word -- Using the Source Data from Access --
Using the Source Data from Excel |
| Sections,
Headers/Footers, Page Numbering
(prerequisite: Intro) |
Using
Sections -- Creating Headers and Footers -- Simple Page Numbering
-- Special Page Numbering in Different Sections |
| Tables
(prerequisite: Intro) |
Creating
a Table -- Working with Columns and Rows -- Splitting and Merging
Cells -- Formatting Cells -- Sizing Cells |
Templates
(prerequisite: Intro)
|
Using
Existing Templates -- Creating a template -- Saving a Template --
Editing a Template -- Using Custom Templates -- Creating Checkboxes
on Template Forms -- Creating Fields on Template Forms -- Creating
Drop-Down Lists on Template Forms
Date
& Times
|
top
| MS
Outlook
Beginner |
Windows
and Macintosh |
|
Learn
about the new email program with an in depth series of two-hour
workshops to get you off and running in the new Outlook software.
Date
& Times
|
|
MS Outlook
Advanced
|
WINDOWS
ONLY!
These are intended for ADVANCE users.
If you need and INTRO workshops see above! |
| Outlook
Calendar Sharing
(prerequisite:
Intro)
Outlook
Customization
(prerequisite:
Intro)
Outlook
Tips & Tricks
(prerequisite:
Intro) |
Your
calendar in Outlook can be shared with another user, at your discretion.
If you are in a position where someone else puts appointments on
your calendar, you can grant that person permission to view and/or
update your calendar. Because calendar information is stored on
the Exchange server, that person can access your electronic calendar
from his/her own computer. It is most beneficial if BOTH people
attend class together--the one who is granting the sharing permission
and the one receiving the permission.
Topics:
-Grant Permission for another user to view and/or update your calendar.
-View and/or update another user’s calendar
-Remove view/update permission
-Designate another user as your delegate
-Send e-mail on behalf of another user
-Request a meeting on behalf of another user
You can change some Outlook settings to fit your needs. These customizing
changes will be saved on the computer’s local hard drive.
Topics:
-Change E-mail Settings
-Create Multiple Signatures
-Customize Calendar Settings
-Customize Outlook Bar
-Customize Outlook Today
Learn how to move around in Outlook and save time performing messaging
and scheduling tasks. Learn how to quickly find messages and calendar
entries. Work with views and toolbars to optimize the features of
Outlook
Topics:
-Navigating in Preview Pane
-Finding a message
-Finding a calendar entry
-Changing Views for Inbox
-Understanding the Toolbar Buttons
Date
& Times
|
top
|
Photoshop |
Photo
Manipulation Software |
| |
This
class features the tools you need to create and edit any image or
photo to your specifications. You will master skills like filtering,
masking, retouching, color keying and more that you need to grasp
the powerful tools of this program.
Date
& Times
|
top
| Video
Production |
Learn
the advantages to incorporating video into your instruction
or personal use
(limit 12 per class) |
| Basic
Ideography
(limit 6)
Beginning Digital Video Editing
(limit 6)
Compressing
Existing Video for Computer Use |
Learn
to control technical and aesthetic elements of video recording.
Explore camera controls and help to ensure that this year's holiday
videos will be watchable. Bring your own camcorder or use IMS's
new DV format digital camcorders.
Learn the basics
of iMovie, a powerful entry-level non-linear video editing application.
Work on creating sequences, adding graphics and titles and outputting
the final product to video tape. Bring your won video material to
edit or work with prerecorded tapes. (If you plan to bring videotape
in any format other than DV, contact the instructor ahead of time
to arrange for conversion.
Learn about
"repurposing" and compressing video images for use in
computer applications or on the World Wide Web. Bring short video
clips or sequences to convert to computer-friendly formats or use
prerecorded material to explore the possibilities.
Date
& Times
|
top
| e-Portfolio |
|
|
A
conceptual framework
How to create an electronic portfolio – using different programs
Publishing on the Web or burning into a CD
Date
& Times
|
| CD
Burning |
An
introduction to burning a CD |
|
Work
with CD-Rs and CD-RWs
CD Burning: Pc and Mac Platforms
CD-burning tips
Creating autostart CDs
Advise on CD-Burning software
Date
& Times
|
| Online
Funding |
Make
Online Funding Resources Work for You |
|
Hosted
by the Office of Sponsored Programs, this hands-on workshop is for
faculty and staff interested in using online resources to identify
potential funding sources for research, travel, curriculum development,
collaborative projects, and other activities. Attendees will learn
how to:
-- Perform simple database searches using keywords,
-- Conduct complex database searches using many fields and conditions,
-- Generate automatic email updates about funding opportunities
that match their research interests and expertise.
Date
& Times
|
|
top |
|
| Flash |
Macromedia
Software |
|
Liven
up the Web pages. Multimedia and Interactive opportunities to enhance
learning and teaching. Learn how to create a “movie,”
use the templates and existing shortcuts in Flash. Practice basic
and advance scripting and learn how to upload the production on
the Internet.
Date
& Times
|
|
top |
|
| Fireworks |
Macromedia
Software |
|
Fireworks
MX: Introduction
Fireworks is
a powerful tool for creating and manipulating Web graphics. During
this workshop participants will get acquainted with basic Fireworks
tools. Participants will manipulate images and optimize an image
for use in a Web page.
Date
& Times
|
|
top |
|
| VR
Worx |
Virtual
Reality |
|
Virtual
Reality in 18 snapshots. Use digital camera to bring 360* view on
your the Web page
Date
& Times
|
|
top |
|
| e-Portfolio |
Macromedia
Software |
|
Create
self starting CD with textual and multimedia material
Date
& Times
|
|
top |
|
| HuskyNet |
File Space & Web Space (for Windows) |
|
FILE
SPACE
Everyone (faculty,
staff, students) has it, but everyone doesn't know how to use it.
Faculty and staff have a combined total of 100 megabytes of web
space and file space available to use. This filespace is on the
campus network, so the files you place there are backed up for you.
(Unlike your hard drive, which you must remember to back up yourself).
The beauty of this file space is that it is accessible to you from
multiple locations across campus. If you teach in an electronic
classroom (e-classroom--formerly known as "smart" classroom),
you can work in your office, save your files to your HuskyNet file
space, and then access those files from an electronic classroom.
You can also access those files from a training lab on campus.
Learn how to:
Automatically connect to your file space
Move files to your file space
Access files from remote locations
Check your file space quota
Delete files from your file space
Rename files from your file space
Create a shortcut to your file space on your Outlook bar
HuskyNet
WEB
SPACE
FTP is file
transfer protocol. FTP software enables you to transfer files from
one location to another. An example would be .html files that you
create on your hard drive and then need to transfer to a server
that will display your files as web pages for others to view. Faculty
and staff have a combined total of 100 megabytes of web space and
file space available to use. The beauty of this file space is that
it is accessible to you from multiple locations across campus. If
you teach in an electronic classroom (e-classroom--formerly known
as "smart" classroom), you can work in your office, save
your files to your HuskyNet file space, and then access those files
from an electronic classroom. You can also access those files from
a training lab on campus.
Learn How To:
Initialize Your Web Space
Save html files to your web space
Move html files to the server
Change html files and move them to server
Install WS-FTP on your computer
Create a shortcut to your web space on your Outlook bar
Check Web space quota
Date
& Times
|
| Zip
Files |
|
|
What
are zip files? They are large size files that are compressed (zipped).
These compressed files can then be saved to floppy disks, or sent
to other people. Then, the files are unzipped so they can be used.
This process is used to enable people to send each other large files
in a format that is more quickly sent via e-mail. You will also
find that some files you download from the Internet are zipped.
When you download them, you need to have a program that will unzip
them for you. EasyZip, a freeware software, will be used in class
and you will learn how to install it on your own computer.
Learn How To:
Install EasyZip on your computer
Unzip a zipped file
View and unzipped file
Save an unzipped file
Zip a large file
Mail a zipped file
Date
& Times
|
| Outlook
Calendar |
Intro
& Advanced for Windows |
|
INTRO
This class will
introduce you to the calendar that is part of Microsoft Outlook.
You will learn several ways to view the calendar, and how to enter
appointments, recurring meetings, and all-day events on your calendar.
You will also learn how to invite people to a meeting and how to
accept or decline meeting invitations that others send to you.
Learn how to:
View calendar in different ways
Navigate to specific dates
Add appointments
Add recurring appointments and meetings
Add All-Day events
Add reminders
Invite people to a meeting
Accept or decline an invitation that you receive
Outlook
Calendar
ADVANCED
If you already
know how to use your own Outlook calendar, you can move on to more
advanced options. One is to create additional calendars where you
can keep department information (staff vacations, birthdays, special
events, etc.) You can share these additional calendars with others
in your office. You can also save these additional calendars as
a web pages to make them accessible to anyone via the web (even
people who don't use Outlook). Great way to advertise events for
your department.
Learn how to:
Create additional calendars
Share the calendars with other Outlook users
Save the calendar as a web page
Make changes to calendar and update web page
Date
& Times
|
| ITV |
Interactive
Television at SCSU |
|
Date
& Times
|
|
