 |
|
| Home | About MC | Academics | Admission | Alumni | Resources | Sports | Student Life | Search | |
|
Home > Resources > Computer Help > Training > Workshop Descriptions |
This workshop introduces you to Microsoft Access
2007. In this workshop, you'll learn how to create a simple
database. You'll also learn how to create basic forms, queries, and
reports in order to enter, retrieve, and view your data.
This workshop focuses on running, viewing, printing, and exporting
Datatel reports. In this workshop, you'll learn how to search for a
report in Report Manager, specify report parameters, sort a report
by one or more columns, export a report to Excel and to a CSV file,
prepare an Excel worksheet for printing, and access report
documentation. In this workshop, you'll learn how to create a
clustered column, pie, and line chart in Excel using the Chart
Wizard. You'll also learn how to format and modify charts and how to
create combination charts.
A PivotTable is an interactive table that you can
use to view and analyze large amounts of data in different ways. A
PivotChart is an interactive chart that allows you to view and
analyze large amounts of data in a graphical format. In this
workshop, you'll learn how to create and modify a PivotTable and
PivotChart report in Excel. Learn how you can quickly sort data in a list, rotate
cell contents vertically, show or hide gridlines, freeze parts of a
worksheet, add headers and footers, copy ranges of cells, use
shortcut keys, print ranges of cells, resize multiple columns and
rows, and more.
This workshop introduces you to Microsoft
Excel 2007. In this workshop, you’ll learn
how to format and print a worksheet, enter and format data, create
simple formulas, and more. In this workshop, you'll learn how to set up a grade
book in Excel that automatically calculates total scores, averages,
and weighted grades so that you don’t have to! In this workshop, you'll learn how to sort data by
multiple columns, use AutoFilter to display the largest or smallest
numbers in a column and to display numbers greater than, equal to,
or less than a specified number. You'll also learn how to create an
advanced filter for use with complex criteria. In this workshop, you'll learn how to create formulas
using relative and absolute cell references. You'll also learn how
to use the SUM, AVERAGE, COUNT, MIN, MAX, COUNTIF, VLOOKUP, HLOOKUP,
and CONCATENATE functions as well as how to create IF and nested IF
statements. Goal Seek is an Excel command that
calculates a variable in order to produce a desired result.
Scenarios are stored values that you can substitute in a worksheet
to perform a "what if" analysis. In this workshop, you'll
learn how to set up a worksheet in order to use the Goal Seek
command, run the Goal Seek command, and create scenarios using the
Scenario Manager. This workshop is designed for faculty who
have never used Moodle before or who would like to review basic
material. In this workshop, you'll learn how to set up a new course,
enroll and unenroll students, upload files, link to Web pages, and
create graded assignments. This workshop is designed for
faculty who
would like to use the online quiz feature in Moodle. In
this workshop, you'll learn about the different types of
questions that you can create (e.g., multiple-choice,
true/false, essay, etc.) and quiz options (e.g., time
limits, multiple attempts, question shuffling, feedback,
etc.). You'll also learn how to create a quiz and quiz
questions, how to review quiz results, and how to override a
student's quiz grade. In this session, you'll learn about the new Office 2007
user interface and the new Office 2007 file format.
Major changes to Outlook, Word, Excel, and PowerPoint also
will be summarized.
If multiple people in your department,
organization, or group are using the Outlook calendar, then you can
create a group schedule to quickly view all of their schedules at
once. In this workshop, you'll learn how to create and edit a group
schedule. In this workshop, you'll learn ways that you can
manage junk e-mail in Outlook, such as adding e-mail addresses to
your Blocked Senders list and setting up a rule to move messages
sent from off-campus to your Junk E-Mail (or other) folder. You'll
also learn some tips for avoiding junk e-mail and what NOT to do if
you receive it.
This workshop introduces you to Microsoft Outlook 2007. In this
workshop, you'll learn about Outlook's main features and
capabilities.
In this workshop, you’ll learn how to organize and save your e-mail
in personal folders, keep your e-mail space from filling up, handle
junk e-mail, use rules, and more.
Find out ways to configure the navigation pane to suit your personal
preference, sort and view messages in your Inbox, flag messages for
follow up, use search folders to find messages, work with
distribution lists, create signatures, and more.
Do you receive a lot of messages from mailing lists, colleagues, or
your students? If so, then you may want to create rules to direct
these types of messages into their own folders in order to keep your
Inbox from getting full. In this workshop, you'll learn about the
types of rules that you can create in Outlook to help manage your
e-mail, how to create rules based on single and multiple conditions,
and how to modify rules.
In this workshop, you'll learn how to quickly create a new contact
from an e-mail message, group contacts by category (e.g., personal
or off-campus colleagues), link emails and/or documents to a
contact, flag a contact for follow-up action. You'll also learn how
to view and print contact information in a variety of ways.
Adding animation to a PowerPoint presentation can help you emphasize
important points, control the delivery of information, and add
visual interest to your presentation. In this workshop, you’ll learn
how to animate objects on slides and how to add transition effects
between slides.
In this workshop, you'll learn how to add music and sound effects
(from your own audio files, CDs, or Clip Art) to slides in a
presentation. You'll also learn how set up a presentation so that
music plays automatically across multiple slides or all slides.
You can quickly create a presentation of pictures using PowerPoint's
Photo Album wizard. In this workshop, you'll learn how to create and
modify a photo album. You'll also learn how to post a photo album on
the Web so that all you can easily share it with others.
This workshop introduces you to Microsoft PowerPoint 2007. In this
workshop, you'll learn how to create a presentation from scratch
complete with a design, pictures, and speaker notes.
If you want to run a large PowerPoint presentation on a different
computer, put it up on the Web, or e-mail it, then you may run into
problems. In this workshop, you'll learn how to reduce the file size
of a PowerPoint presentation by cropping, resizing, and compressing
pictures.
It’s easy to make global changes to the slides in your PowerPoint
presentation, when you edit the Slide Master. In this workshop,
you’ll learn what the Slide Master is, how to change it, and how to
work with multiple Slide Masters.
This workshop introduces you to Microsoft Publisher 2007. In this
workshop, you’ll learn how to create publications, such as
newsletters, brochures, postcards, and greeting cards, from scratch
and using the Publisher templates. A SharePoint Web site allows a group to easily share
documents and communicate online. This workshop covers how
use a SharePoint Web site's Shared Documents folder,
discussion board, and calendar.
This workshop introduces you to VAR Grade for Windows, which is a
program that you can use to keep track of grades, attendance, and
student information. In this workshop, you'll learn how to create a
basic grade book for a class.
In this workshop, you'll learn how to insert,
resize, resample, and position pictures on a Web page. You'll also
learn how to add alternative text descriptions to pictures and
create thumbnails. In this workshop, you'll learn how to create and edit web
pages using Microsoft's Expression Web. You'll also learn
how to add pictures, link pages together, and more.
Cascading style sheets are used to control the appearance of Web
pages and make updating your Web pages a snap! In this workshop,
you'll learn how to create and modify inline, embedded, and linked
cascading style sheets. Would you like to create your own logo, banner, or custom buttons
for your Web site? In this workshop, you'll learn how to create your
own graphics for the Web using Microsoft's Image Composer. This workshop covers how to create vertical and horizontal
navigation bars for your Web site from scratch and using FrontPage
link bars. You'll also learn how to create server-side include pages
for your navigation bars and how to insert these pages on the other
pages in your Web site. Web forms are a convenient way to collect
feedback, conduct surveys, and more. In this workshop, you'll learn
how to create a basic online form that your site visitors can fill
out and submit.
In this workshop, you'll learn how to create a basic Web page using
Hypertext Markup Language (HTML) code. You'll also learn how to
format and align text, insert paragraph and line breaks, insert and
format horizontal lines, create bulleted and numbered lists, cerate
hyperlinks, add pictures, and create tables using HTML code.
This workshop is designed for those who have little to no experience
working in a Windows environment. In this workshop, you'll learn how
to use the Windows XP desktop, access programs, work with files and
folders, and more. In this workshop, you'll learn what
the F: drive is, why you should save your files there, where
you should save your files on it, how much space you have to
save your files, what to do if you run out of space, and how
to organize your files in folders so that they will be
easier to locate. You'll also learn tips for creating
meaningful file names and different ways that you can view
your files within folders. Find out ways you can view and search for files,
customize your desktop, create a slide-show screen saver, work with
multiple open windows, create shortcuts, and more. In this workshop, you’ll learn about
different types of headers and footers (e.g., first page or
different odd and even) and how to add them. You'll also learn how
to insert page numbers and dates, create different headers and
footers for each section in a document, and more.
Did you know that Word can automatically generate a table of
contents when you use heading styles to define the different parts
of a document? In this workshop, you'll learn how to apply heading
styles, how to create and modify a table of contents, and how to
format a table of contents.
In this workshop, you'll learn important form design tips and how to
create forms that can be distributed and completed electronically in
Word.
This workshop introduces you to Microsoft
Word 2007. Topics covered include
formatting text, page setup options, printing, mail merges, creating
envelopes and labels, adding headers and footers, and working with
tables.
In this workshop, you'll learn how to use Word to perform mail
merges for letters, envelopes, labels, and directories. You'll also
learn how to create and modify data source files.
When multiple authors are working on a single document, Word's
Comments and Track Changes features can help everyone quickly
communicate suggestions and identify who made what changes to the
document. In this workshop, you'll learn how to insert and view
comments and how to use the Track Changes feature.
A macro is a series of steps that you can execute
in Word as a single step. For example, if you perform a task
repeatedly in Word, such as inserting a table with a certain number
of columns and rows and a certain type of formatting, then you can
create a macro for this task and assign the macro to a keyboard
shortcut. When you press the keyboard shortcut, Word will
automatically create the table and format it for you. In this
workshop, you'll learn how to create and use macros to automate
tasks in Word.
A style is a group of formatting instructions that you apply all at
once to a paragraph or to individual characters. Styles help ensure
that your document is formatted consistently, and they make your
documents easier to modify. For example, if you need to make a
change to a style, you can change it one place and the change will
appear all throughout your document where the style is used. In this
workshop, you’ll learn how to create and use styles in Microsoft
Word.
Tables are a fantastic tool for formatting tabular information in
Word documents. They allow you to wrap text in columns and make
updating tabular information a breeze. In this workshop, you’ll
learn how to create and use tables in Word.
The Outline view in Word enables you to easily create document
outlines and modify them using the Outlining tools. In this
workshop, you'll learn how to create, modify, and view outlines.
Learn how to work with toolbars, use shortcut keys, create tabs and
indents using the ruler, add page numbers to headers and footers,
format text using the Format Painter, view documents in different
ways, change bullet types, use styles, and more.
In this workshop, you'll learn how to insert, resize, crop, and
position pictures in Word documents. You'll also learn how to create
watermarks, wrap text, and create your own pictures using Word's
Drawing Canvas and drawing tools. Section breaks enable you to change the format
and/or layout of a document within a page or between pages. For
example, section breaks can be used to change the orientation of one
page in a multi-page document to landscape. In this workshop, you'll
learn about different types of section breaks (e.g., next page,
continuous, even page, and odd page) and how to insert, view, and
delete them. |
