Handout

Description

Support Files

An introduction to Access, this handout covers an overview of the program as well has creating tables. Topics include: creating tables, setting field properties & the primary key, creating table relations, and inputing data.

Topics include single and multitable searches, using wildcards, searching using date and number ranges, calculations in queries, summarizing data, and action queries.

Topics include performing mathematical operations on grouped data, changing join properties to find data which is in one table but missing in another, finding unmatched data between tables, parameter queries, IIF statements in queries, and update, make table, delete, append, and cross tab queries.

The use of forms to enter data. Topics include custom forms, drop down lists, check boxes, calculations in forms, and entering data into two tables from one form.

Topics include mailing labels, form letters, summary and group reports, multitable reports, and calculations in reports.

A switchboard is a screen containing buttons and drop down boxes that can be used as a main menu to control common access functions. Topics covered include placing command buttons on switchboards to open forms, tables, and execute queries; drop down boxes to go to records, and macros to filter data. The DSUM and DLOOKUP function will also be covered as well as macro basics.

Macros2000-Complete
Macros2000.mdb
MacrosXP.mdb

Covers contact screens, navigation, contact lists, lookups, creating groups, performing keyword searches, adding notes and contacts and creating reports.

This is the support page created by ITS and includes written guides by topic, videos, and online instructor led assistance.

Beginning:
XP
2007

An introduction to MS Excel. Topics include navigation, highlighting, selection, entering & editing cells, basic formulas, simple functions, coping, using absolute addresses, and printing.

Covers using solver, goal seeking, mathematical operations between sheets & files, IF, AND, & OR functions as well as the following financial functions: PV, FV, IRR, & PMT.

Solver.xls, Main.xls, Orlando.xls, Tokyo.xls, 4parks.xls, Paris.xls, Anaheim.xls

Covers creating bar, line, area, column, pie, linked pie, XY Scatter, and bubble charts using the wizard and an example of setting ranges manually.

Use Tommys_Cars.xls for the Excel 2000 & XP manuals.

Use Charts.xls for the Excel 2007 manual.

Databases:
XP

2007

Excel XP Handout:
Topics include parsing, transposing, sorting, filtering with autofilter, setting validation rules, using VLookup to pull data out of table & verify data in two different tables, and using the DSUM, DCOUNT, & DAVERAGE functions.

Excel 2007 Handout:
Includes proper database construction, sorting, filtering, advanced filter, database functions (Dsum), tables, data validation, transpose, finding duplicates, vlookup, and working with external data.

For Excel XP, use these files: Movies.xls, Vlookup.xls, and

Combined_Workshops.xls

For Excel 2007, use this file: Excel 2007 Data File

Topics include using exponents, arrays to do summations, combinations, permutations, slope, Y-intercept, regression, frequency, average, median, mode, standard deviation, variance, interval estimation about means, correlation coefficient, the data analysis tookpack, and the following distributions: binomial, hypergeometric, poisson, normal, and standard normal.

Covers using the macro record in both relative & absolute mode, Marco buttons, custom menus, creating custom functions including use of SELECT CASE. Also includes use of a few interactive procedures that prompt the user for input.

Expressions Web is a web authoring tool similar to Dreamweaver. It allows you to create web pages in both WYSIWYG and code view. This handout covers the folloiwng topics:  Overview of HTML & CSS, the Expressions working environment, and how to create sites, web pages, work with text, lines, images, and hyperlinks. It also includes how to publish your web site to USC's web server and some general advice on publishing to other servers. To follow along with the handout, you will need the support files on the right.

Files For Workshop:

Files for Workshop 1 

Completed Examples:

Mama's Kitchen

Covers using Expressions Web to create the following:

Image Hotspots - This allows you to make differnt sections of a photograph clickable as a hyperlink.
Tables - Covers creating tables in code view, using the tables tools, and the Draw Tables tools.
iFrames - an iframes exists as a window on your current page through which you can view other pages. This allows you to stay on the current page while using hyperlinks to change which page is loaded in the iframe.
Frames - This allows you to divide your page up into different windows. Each window can contain a different page. This is most often used for menus.
Interactive Buttons - We will use Expression Web's "interactive" buttons to create image rollover buttons.

Files for Workshop:

Files for Workshop 2 

Completed Examples:

Frames

Covers inline, ID, Class, external style sheets and descendent selectors to do the following:

Set page defaults, format text, format images, format hyperlinks, set page background color, create a drop cap, create a column, and use an image as bullets.

Files for Workshop:

Files for Workshop 3 -  Intro to CSS

Completed Examples:

- HTML Selectors (About USC)
- Drop Cap 
- ID Selectors (Mottos)
- Intended Quotes
- External Style Sheets  (Bullet Images).

Expressions Web  4 - Page Layout using CSS

This handout covers how to use CSS styles to layout a page using relative and absolutely positioned div tags as content containers. Some of the topics covered include creating text drop shadows, drop caps, nesting div tags, and overlapping text and images by specifying the z-index, and laying out a page into columns & headers.

Files For Workshop:

CSS_Layout.zip 

Completed Examples:

Text Dropshadows 
Relative Div Columns (The Runaway), 
Absolute Divs (USC Header) 
Absolute Divs (Always Natural)

Covers how to use CSS to display a bulleted list items as both vertical and horizontal menu buttons.

Files for Workshop:
None

Completed Examples:

- Vertical Menu
- Horizontal Menu

This handout covers the following:

• Using Expressions Web to create an RSS feed in your web page that others can subscribe to and read.
• Reading an RSS using the Outlook reader.
• Reading an RSS feed using iGoogle.
• Displaying someone else's RSS feed in your web page.
• Telling the world about your RSS feed.
• Creating an RSS PodCast.

Files for Workshop:

RSS_Todays_Recipes.zip

Completed Examples:

- RSS Feed (Todays Recipes
- RSS PodCast

Covers how to make a YouTube video display and play on your web page and how to insert a flash file and make it play from witin your web page.

Covers how to attach a Word or PDF file to courses which appear online in the USC Schedule of Classes. Also covers linking to a biographical page.

Topics include creating a FrontPage web, importing images and support files, working with text, lines, tables, and images. Creating hyperlinks and using FrontPage to publish to the USC UNIX web server.

Topics covered include using themes, shared borders, creating forms, using hotspots, and working with frames.

Faculty and staff can use FileZilla to transfer files to and from their Marshall and USC network drives to thier home computer.  You can also transfer files using the The FileZilla software can be downlaoded at http://software.usc.edu

Note that you can also transfer files using the "Network Storage" portal locataed on the "Home" tab of MyMarshall or use RemoteDesktop.

An introduction to HTML as a reference guide including such topics as text attributes, pictures, tables, and hyperlinks.

Includes forms, image maps, and frames

Cascading Style Sheets gives users to create master templates that control all web pages and use such features as borders, object positioning, drop shadows, background tiling, etc.

View examples used in the handout

Click here to see the examples shown in JavaScript handouts 1 - 4 in action.
Click here to download a zip file of the pictures used for JavaScript handouts 1 - 4.

An introduction to JavaScript, includes language syntax including an overview on objects, properties, methods, event handlers, and functions. Examples include text and image hyperlinks

Builds on handout 1, includes event handlers, redirecting browsers, image and text rollovers, using forms for input and online calculators.

Builds on handouts 1 & 2 and includes Arrays, writing to a text field, If statements, counters, and time outs. Also includes online slide shows and images that automatically change.

Builds on the previous handouts and includes placing stationary and scrolling text on the status bar, working with dates (formatting and date functions), and countdowns.

Marshall Course Pages - Instructor Guide

Office 2007 - Cheat Sheets
Find where the Office 2003 Commands were Moved to in Office 2007

Excel 2007 Cheat Sheet

PowerPoint 2007 Cheat Sheet

The cheat sheets contain the following information:

• Tips on navigating the Office 2007 environment.
• Tables showing where the buttons on the Office 2003 Standard & Formatting toolbars were moved to in Office 2007.
• Tables showing where the menu commands in Office 2003 were moved to in Office 2007.

Orientation Materials - Graduate Students

How to configure Windows XP, Vista, and Mac laptops to connect to USC's wireless network.

The instructions in this handout cover how to configure the software version of Outlook 2007 to connect to the Marshall Exchange Server using the RPC over HTTP protocol. It does not require VPN and it is intended only for home computers or wireless laptops. If you are a Marshall faculty or staff member, do not follow these instructions for the PC in your office at Marshall.

Covers how to access and use most of Outlook's features (e-mail, calendar, contacts) through a web browser rather than the software.

Covers the following Topics:

• Calendar Components
• Changing Calendar Views
• Using the Calendar
• Creating Appointments
• Creating Meetings
• Creating Events
• Recurring Meetings, Appointments & Events
• Changing Default Options
• Printing Calendars
• >Color Coding Calendar Items
• Sharing Calendars Creating and Sharing Sub Calendars

Covers new and changed features in Outlook 2003 including:

• Navigation
• Desktop Alerts
• Virtual Folders: Search & Favorites
• Viewing Multiple Calendars
• Meet Workspaces
• Placing Images in Contacts
• Sharing Contacts
• Shared Attachments
• HTML Image Loading
• Information Rights Management
• Working Offline (cached mode)

Obsolete Method:
Outlook 2003 using VPN - This is an older method for connecting Outlook to the Marshall Exchange server on a Windows XP Computer.

Covers the following:

• Outlook Overview (Folders & Icons)
• Sending Email & Attachments
• Using Spellchecker
• Email Options
• Receiving Email (Reply, Forward)
• Changing Views
• Deleting Email

Covers the following:

• Find and Advanced Find
• Folders - Creation and Usage
• Flagging Messages
• Coloring Message Header Text
• Using Rules & Alerts to Move and Flag messages
• Managing SPAM using Rules
• AutoArchive & Manual Archive
• Mailbox Cleanup

Configuring the Software Version

2000
XP

Covers how to configure the software version of Outlook. Versions 2000 & XP are for an online only connection while 2003 allows both on and off line access. Note that AIS does not support offline access for versions of Outlook older than 2003.

Archiving - Autoarchive

2000

Autoarchiving frees up space in your Outlook account by automatically moving older email to another location such as your network drive. This handout covers Outlook storage limits at Marshall, determining your current usage, managing your account, setting up autoarchive, and viewing archived items.

Archiving - Manually & Other Alternatives

2000

Like autoarchiving, manually archiving also frees up space in your Outlook account by moving email to another location. The difference is that while Autoarchive performs at set intervals; manually archiving can be done at any time by the user. For example, you have an immediate need to free up space or you are graduating and would like to back up all of your e-mail to a non-Marshall location.

Forwarding Incoming Outlook E-mail to Another Account

Covers how to create a rule in the client version of Outlook XP that will forward all incoming email to another account. Note that although you must use the client (software) version of Outlook to create the rule, the web version of Outlook (OWA) will also be affected because the rule is stored on the server rather than the client.

Introduction to Outlook Email

2000
XP

Covers an overview of most outlook features, basic program navigation, and an introduction to composing and reading e-mail.

More Outlook E-mail Features

2000
XP

Covers using signatures, creating folders, moving & copying mail, mail rules and filters, finding messages, autoreply, voting buttons, HTML mail, and Public folders.

Using Contact & Distribution Lists

2000
XP

Covers manually creating and using contacts, importing contacts from Excel, Access and text files, distribution lists, and personalized mass e-mail using a Word mail merge.

Using Calendars

2000
XP

Covers calendar navigation, creating appointments and meetings, reply options, and creating subcalendars.

Sharing Folders

2000
XP

Covers sharing calendars and e-mail.

Follow the steps in this guide to configure your BlackBerry device to access your Marshall Email account. Please note that Marshall does not utilize a student BlackBerry Enterprise Server.  This means that you will get access to email but will not be able to synchronize your contacts and calendar with the server (as you can do in Outlook, for example).

Setting up a Microsoft Exchange ActiveSync account in VersaMail. For Treo devices.

Marshall IMAP/POP3 Settings are as follows:

Outgoing Mail Server for all Users: 
email.usc.edu  (Use port 587)
Incoming Mail Server - Students: msbmail04.usc.edu
Incoming Mail Server - Faculty & Staff: msbmail03.usc.edu

PINT is a web based application used to create, modify, and manage Marshall web pages. The handout covers most topics.

PINT Training Video

Covers how to scan using PaperPort Deluxe 7.0 scanning software.

PowerPoint 2007

Building a Presentation:

97
XP

Covers title & bullet charts, formatting, building a screenshow, animating slides, and printing.

Graphs:

97
XP

Covers the following graphs: pie, bar, column, line, area, XY Scatter, and bubble. Also covers animating charts.

Drawing Tools:

XP

Covers using the tools on the drawing toolbar.

Beginning:

95

Covers basic project setup, creating tasks and linking them, assigning resources, and different views.

A video introduction to Qualtrics (47min).  System requirments:

PCs

• Windows 2000, XP, or Vista Operating System.
• Internet Explorer 6.0 SP1 or later or Firefox 2.0 or later. (You may need Windows Media Player specifically designed for Firefox.)
• Windows Media Player 9.0 or later.

MACs

• MAC OS X 10.4.8 or later
• Safari 2.0.4 or later or Firefox 2.0 or later
• MS Silverlight 1.0  (Should self-install).

Notes:

• You may need to disable pop-up blockers.
• If your company has a firewall, you may need your technicians to unblock port.  See this table for more info on ports.

Covers how to collect dates using drop down boxes for month, day, and year.
One of the problems of collecting dates is the format that different regions use.  For example, in the US most people type in this format:  mm-dd-yyyy; howerver, in many other countries the month and day are reversed (dd-mm-yyyy).  Qualtrics date validation will not catch any reverses where the day number is under 13. 
This handout covers how to avoid this issue by providing the responder with three separate drop down arrows:  one for day, one for month, and one for year.  ,

Wireless -
Connecting Your Laptop to the Internet While on Campus

Wireless For Windows XP

Wireless For Windows Vista

Wireless allows users to connect their laptops to the Internet while on campus but does not require the user to physically connect using cables. Reception is available within all class rooms in Popovich Hall including the patio, as well as other areas throughout USC and the first floor of the Orange County campus. Please note that this is a 10 Megabit/sec shared connection meaning that depending upon how many users are connecting at once, it can be considerably slower than using ResNet. The handouts cover activating your USC account and how to connect using wireless.

Accessing Your Network Drive - Student Method

Remote Network Drive Access

These instructions cover how Marshall graduate and undergraduate students can acess their Marshall Network drives both on and off campus.

ResNet - Connecting Your Laptop to the Internet While On Campus

2000
XP

ResNet allows users with a registered Network Card to connect their computers to the Internet at a top speed of 10 Megabits/sec (approximately 1 MB/sec) while on campus. There are ResNet jacks located throughout Marshall and the Residence Halls and wireless connectivity will be provided in the near future. To connect to ResNet, you must have a network card, activate your UNIX account, and register your network card with USC via your UNIX account. These handouts cover activating your UNIX account and configuring your laptop for a ResNet connection to USC.

ResNet Troubleshooting:

95 through XP

Covers solutions to some of the more common problems encountered when using ResNet including release & renew instructions. Covers windows 95/98/ME/2000/NT & XP.

ISP -
Using USC as Your Internet Service Provider

2000
XP

As a USC student, you can access the Internet from home via your telephone jack by using USC as your Internet Service Provider. The service is free but you may incur long distance charges from your phone company if USC does not have any dial-up numbers in your location. This service is provided by a USC department outside of Marshall called Information Services Division (ISD) and uses your UNIX username and password. If you would like to use USC as your Internet Service Provider, you will need to activate your UNIX account and then configure your computer for a PPP (Point-to-Point Protocol) connection to USC. The handouts below contain instructions on how to perform both of these tasks.

Information Rights Management (IRM)

Covers how to secure email and files from unwanted access using IRM.

None

TrueCrypt 6.0a

Covers how to encrypt and password protect files using TrueCrypt. 

SharePoint

Covers usage of SharePoint for end users and administrators.

None

Covers how to use indents and tabs in Word 2007.

None

Covers how to send personalized letters or emails to recipients by merging a Word template and data located in an Excel file. Also includes mailing labels, including a file attachment in an e-mail merge, filtering, formatting data from Excel using switches, and using an If-then-else statement to insert conditional text.

None