Microsoft Word (Basics and Shortcuts)
The standard word-processing features, along with numerous shortcuts for making the daily word-processing tasks easier and more efficient, are covered in this course. These features include: Creating and saving a document; selecting, formatting, and aligning text; moving, copying, pasting text; maneuvering in large documents; using the Autocorrect feature; proofing and printing the document and envelopes.
Microsoft Word (Tables, Tabs, Columns, and Pictures)
This course assumes that the Basics course was taken, or that the user is sufficiently familiar with the features covered in that course. The course includes the proper setup and use of tabular information in Word. It includes the setup of multi-column documents, newspaper and parallel formats. Inserting and graphic images is also covered.
Microsoft Word (Lists and Merging)
The use of lists (particularly mailing lists) together with form letters to produce a customized letter for each addressee is covered. It includes the proper setup of the list and the associated documents, and sorting and printing options.
Microsoft Word (Desktop Publishing)
Within Microsoft Word there is a wide variety of tools which allow you to go well beyond the standard word processing features. These tools can be utilized for desktop publishing, allowing the MS Word user to create flyers, brochures, announcements, etc., with various typographical effects, graphics, reverse text, lines, boxes, and frames.
Microsoft Excel (Creating Spreadsheets)
The standard features of the spreadsheet are covered here. Entering and editing data; using the toolbars: inserting, deleting, and re-sizing columns and rows: creating common formulas and functions; formatting text and numbers; are covered.
Microsoft Excel (Functions, Lists, Charts)
This course assumes that the Basics course was taken, or that the user is sufficiently familiar with the features covered in that course. More advanced and useful functions are introduced. Lists are created, and techniques for organizing them are shown. Finally a simple chart is created from existing data using the chart wizard.
Microsoft Excel (Charts)
This course goes beyond the simple automated features of the Excel chart wizard. It presents the many features that can be customized in a variety of chart types. Features include: changing titles, adding data labels, modifying legends, customized use of colors and patterns, tick marks, text formatting.
Microsoft Excel (Protecting Spreadsheets; Macros)
Once a spreadsheet is created, it is often advisable to assign certain levels of protection. The entire file, a particular sheet, or particular sections of the spreadsheet can be protected from unauthorized alterations or viewers. The course shows the application of passwords and write protection. Backup issues are discussed, and printed copy as a backup and auditing tool are demonstrated.
Spreadsheets often involve routine and repetitious steps that can be consolidated by use of a macro. Use of macros can save time and eliminate the monotony of repetitious manual operations. The course demonstrates how to record, save, and play a macro: as well as how to assign a macro to a button.
Microsoft Excel (Printing)
Excel spreadsheets have many varied options, unlike word processing documents, for printing. Spreadsheets often are not confined to the standard 8 1/2 x 11 inch format, that we see in MS Word. This class shows how to deal with large spreadsheets and organize them for printing. The features covered in the course include: freezing and splitting screens, assigning range names, zooming, previewing, set up options, page breaks, scaling printouts, setting headers and footers, setting the print area, showing/hiding gridlines and row/column headings, printing formulas and functions.
Microsoft PowerPoint (Creating Presentations)
The class works with the tools and techniques within PowerPoint to create a presentation. Creating, formatting, and editing text; choosing options and working with the wizard; applying templates; adding art and changing color schemes; printing and proofing the presentation, are covered.
Microsoft PowerPoint (Enhancing Presentations)
This course assumes that the Creating Presentations course was taken, or that the user is sufficiently familiar with the features covered in that course. It focuses on additional features that can be added to a presentation, such as the use of the outliner, master slides, drawing images, creating graphs and organization charts.
Windows
This course is intended for those who are new to the Windows interface, those who were previously using the Macintosh computers or older Windows platforms. It covers the new features on the screen; its icons, menus, and taskbar and how to control the appearance of Windows. The use of multiple windows, accessories, applications, and the control panel are covered. The viewing , and organizing of files and folders in Windows are also demonstrated.
Microsoft Access (Creating Databases and Tables)
This course acquaints the new user with the standard features of Access. It includes planning the database and tables; creating tables; modifying fields in a table; adding, editing, and formatting data; sorting; searching for data with the find feature; and printing data.
Microsoft Access (Queries)
This course assumes that the Creating Databases and Tables course was taken, or that the user is sufficiently familiar with the features covered in that course. It discusses table relationships and demonstrates how to create them. The set up of queries manually, and the use of wizards is covered. Queries will be used to sort, and select records in the database tables.
Microsoft Access (Forms)
This course assumes that the Creating Databases and Tables, and the Queries courses were taken, or that the user is sufficiently familiar with the features covered in those courses. The creation and the modification of forms are covered. Forms are used for viewing, inputting, and editing data.
Microsoft Access (Reports)
This course assumes that the Creating Databases and Tables, Queries and Forms courses were taken, or that the user is sufficiently familiar with the features covered in those courses. The creation and the modification of printed reports are covered. Reports are created with wizards and customized. Standard reports are produced for all records, summaries or records, and mailing labels.
Microsoft Access (Converting Filemaker Lists)
There are many lists that have, in the past, been maintained in different versions of FileMaker. The FileMaker program has many limitations and Access has become the standard database among the desktop applications. Access has greater capacity, power, and flexibility, and is much more compatible when integrating with other programs, particularly in the MS Office Suite. This course shows how to export existing lists from FileMaker, and then import them into MS Access.
Introduction to CSUSM Computing
This course is intended for new faculty and staff at CSUSM. It gives a concise overview of the standard features of your desktop computer. It also includes information on getting around on the CSUSM network, using Email, Netscape, and News, File Management, etc.. There is also a discussion of etiquette and security issues.
ERF100 Electronic RFU (Request for Facilities Use) - Meetings/Events on the Web
Required for staff or faculty member who wants to request event/meeting space via the web. Reviews the process that event scheduling uses to schedule the many meetings/events requested on campus. Introduction to the meetings/events website. This class covers also the general navigation and various searches (such as room availability, room features, and general meeting/event information).
Banner Navigation (All Banner Users)
Designed for the inexperienced or first-time Banner user, this class concentrates on the navigational aspects of the Banner system. Introduction to basic navigation, concepts, and useful screens for new Banner users. Depending on the needs of each attendee, the class covers basic screens for both the Banner Student and/or Banner Finance user. (Training conducted on a one-to-one basis. Users must have access to Banner before being trained.)
Class Schedule Build (Banner)
General overview of building the upcoming term's class schedule in Banner. Includes information about building basic class sections (with and without labs), adding days/times, adding location or location requested, and adding instructor. Available only to those employees with appropriate Banner permissions.
PPS100 PeopleSoft Introduction (replaces PPS001, PPS002, and PPS010)
Designed for the inexperienced or first-time PeopleSoft user, this class concentrates on the navigation aspects of the PeopleSoft system. Introduction to basic navigation, concepts, and useful screens for new PeopleSoft users. Learn to inquire on General Ledger, Accounts Payable, Purchasing, and Budgets.
PPS003 PeopleSoft HR nVision Reports
Basic navigation for HR users. Introduction to two HR reports: Actuals Projection Report and the HR Actuals Report. Completion of PPS100 is required before attending this training.
PPS005 Campus Web Portal (my.csusm.edu)
The campus web portal is how PeopleSoft users will access PeopleSoft Finance, PeopleSoft HR, and other information that is vital for campus faculty and staff. This training will introduce you to the functions available in the portal, such as accessing your HR information (leave balances, emergency contact); campus announcements and alerts; department and employment directories; and local traffic. The training also covers general navigation through the portal, customizing the content, and personalizing the layout of your web portal. Class Handout: ../webstuff/Web Portal Class Handout2.doc
PPS011 Budget Transfers - End Users
How to process budget journals online, how to perform budget journal inquiries and reports, and review business processes. Completion of PPS100 is required before attending this training.
PPS013 On-Line Requisitions - End Users
How to enter on-line requisitions, review of business processes, and requisition inquiries and reports. Completion of PPS100 is required before attending this training.
PPS014 Finance nVision - End Users
How to review departments budget vs. expenditures using nVision, how to run trial balances using nVision, and drilling down to the transaction detail with nVision. Completion of PPS100 is required before attending this training.
PPS050 Executive Summary – for Faculty and MPPs
An overall picture of how PeopleSoft is used at Cal State San Marcos. MPPs will see the reports available to PeopleSoft users, the steps required to run those reports, how we are currently using different parts of PeopleSoft (web portal, finance, and human resources), as well as what is planned for the future. There will be built-in time for questions and answers.
ESP100 Employee Status Page
If you used to use Snappy (for new employees, moving employees, or exiting employees), this training covers the new "ESP" -- the Employee Status Pages. Class Handout: ../webstuff/Employee Status Pages.doc. This page will be updated in August 2005 to include employee moves. For now, continue to use the Snappy for employee moves.
Altiris (For IITS/Help Desk Only)
Learn how to write up a Help Desk incident using Altiris. Covers the basics of creating Altiris incidents, including an explanation of which of the Category, Type, and Item (CTI) to use and determining which workgroup to use when assigning the tickets.