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.

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.

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

IMAP/POP3 Settings for Exchange 2010:

Incoming Mail Server: mail.marshall.usc.edu
Outgoing Mail Server: smtp.usc.edu

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 / 2010 - Cheat Sheets
Find where the Office 2003 Commands were Moved to in Office 2007 and Outlook 2010

Excel 2007 Cheat Sheet

PowerPoint 2007 Cheat Sheet

Outlook 2010 Cheat Sheet

Word 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.

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.

Forward Outlook to Another Account

1.  Login to MyMarshall (https://mymarshall.usc.edu)
2.  Click "My Account".
3.  Click "Email Forwarding".
4.  Check "Forward a Copy of Incoming Email to".
5.  Specify whether or not to leave a copy on the server.
6.  Click "Save".

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.

• Inserting Business Cards
• Using Signatures as Canned Email Responses
• Inserting Lines, Images, and Backgrounds
• Using Tables for Newletter Layout

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 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.

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.

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