IT Training News & Schedule 2008

IT Training is conducting training in Microsoft Office Version 2007. This updated version has a new look and feel to the layout of the menus and tool bars. Tools have been reorganized into a ribbon which displays at the top of the screen now. The familiar Menus and Toolbars of previous versions have a completely new look, feel and navigation. See the schedule below for details.

Sign-Up is required.  To register for a class, click the class date in which you want to enroll. The IT Training Class registration form displays for the class selection.

For question or other information contact us at training@csun.edu or call x1700.

August 2008

Access 2007 – Basics	OV18-O	August 5, 2008	10:00AM – 11:30AM
PowerPoint 2007 – Basics	OV18-O	August 6, 2008	9:00AM – 10:30AM
*NEW* Office 2008 (Mac) Highlights, New Features & How to configure for email	OV 30	August 7, 2008	2:00PM – 3:00PM
Office 2007 – New Look and Feel	OV18-O	August 14, 2008	9:45AM – 10:30AM
Office 2007 – New Look and Feel	OV18-O	August 14, 2008	11:00AM – 11:45AM
Word 2007 – Creating & Using Tables	OV18-0	August 15, 2008	9:00AM – 11:00AM
MyNorthridge – Portal Login & Personalization	OV18-0	August 19, 2008	9:00AM – 9:45AM
Outlook 2007 – Using Email, Calendaring, Tasks, Notes & Contacts	OV18-O	August 20, 2008	9:00AM – 11:00AM
Excel 2007 – Data Query & Management	OV18-O	August 21, 2008	9:30AM – 11:00AM
Outlook 2007 – Calendaring	OV18-O	August 28, 2008	9:00AM – 11:00AM
PowerPoint 2007 – Working with Themes, Layouts and Masters (intermediate)	OV18-O	August 28, 2008	2:00PM – 3:30PM
SOLAR SA – Student Inquiry & Advisement	OV18-O	August 29, 2008	2:00PM – 3:30PM

Class Descriptions

Access 2007 – Basics

Data Base Management System – This course is designed to give users an overall view of the main functions of this popular database program. You will learn to create a database table, design a data entry form, perform a query, and create a professional looking report. Microsoft Access uses powerful tools to manage your data, find and retrieve information quickly, and take advantage of automated, pre–packaged solutions to create and utilize databases. This interactive and hand–on workshop will show you how to employ some of the tools contained within Access to create, format, navigate, sort, and manipulate data within the database .

Instructor: Sandra Ceasar. Class length 2.0 hours .

Access 2007 – Intermediate

Data Base Management System – The focus of this course is to introduce different methods of database search criteria and queries. Retrieve specific records using comparison and logical operators. Learn to use wildcard characters, the expression builder, and query filters. Find records with high and low values in specific fields. Create expressions that calculate new field values. Use functions to select records by groups. Run a query with different criteria each time. Combine two or more fields into one field. Create a new table consisting of data from other tables and queries. Copy records from one table to another. Apply criteria to select and delete groups of records at one time. Hands–on exercises cover all topics introduced in this course.

Instructor: Sandra Ceasar. Class length 1.5 hours.

Accessible Power Point

Conversion of Power Point files into an accessible web format. Learn how to create documents in PowerPoint and convert them for accessible use on the web. LecShare will be the conversion software used in this hands–on workshop. To see the full schedule of classes offered for ATI or for more information please visit http://www.csun.edu/accessibility/training.

Instructors: Sue Cullen, Randal Cummings. Class length 1.5 hours.

Accessible Text Materials

Hands on workshop to learn how to create accessible Word documents, and baseline accessible PDF documents. To see the full schedule of classes offered for ATI or for more information please visit http://www.csun.edu/accessibility/training.

Instructors: Sue Cullen, Robert O’Keefe. Class length 2.0 hours.

*ATI: Accessible Technology Initiative

Learn how to use tools to validate your website and review it for common accessibility errors. To see the full schedule of classes offered for ATI or for more information please visit http://www.csun.edu/accessibility/training.

Excel 2007 – Basics

Learn how to use this powerful software program. This class will cover the basics of Excel 2007, including how to create a simple spreadsheet, move around in Excel, edit your data, enhance the look of your spreadsheet, and more.

Instructor: Tina Purtee. Class length 2.5 hours.

Excel 2007 – Creating and Using Pivot Tables

(advanced skills class)

The Pivot Tables feature of Microsoft Excel can be used to summarize large collections of data into easy to read and comprehend reports. This tool allows you to work with your data dynamically. It will allow you to reorganize and filter data on the fly. It is a tool every large data sheet Excel users should know!

Instructor: Tina Purtee. Class length 1.5 hours.

Excel 2007 – Data Query & Management

(advanced skills class)

Save yourself time, energy, keystrokes and headaches. Learn some of Excel's more advanced functions to help you manage and query large or multiple data worksheets.

Instructor: Tina Purtee. Class length 1.5 hours.

Excel 2007 – Using Basic Macros

Find out what a macro can do for you. Save yourself time, energy, keystrokes and headaches. Learn how Macros can help you perform frequently repeated tasks quicker and easier.

Instructor: Tina Purtee. Class length 1.5 hours.

Excel 2007 – Working with Multiple Worksheets & Books

(Intermediate Skills Class)

Excel is a very powerful program. It is nearly impossible to know everything about Excel. However, this class will provide you with some additional information and techniques to effectively utilize multiple workbooks & worksheets simultaneously. Understanding these techniques and functions will help you save time, energy, keystrokes and headaches.

Instructor: Tina Purtee. Class length 2.5 hours.

Faculty Focused Excel 2007 Workshop

Offered at the beginning of each semester

Using Excel to change the SOLAR class roster download into an electronic grade book and attendance roster. Keeping a grade book and doing it manually? This workshop is specifically designed for faculty. Learn the Excel tools required to take the SOLAR class roster download and change it into an electronic grade book and even automatically calculate your students grades for you. Create a grade book template and create an electronic attendance roster from the SOLAR roster. Learn techniques that can really save you time and energy

Instructor: Tina Purtee. Class length 2.0 hours.

Intro to Accessibility

Discussion of the Accessible Technology Initiative. Overview of what it means to access web materials using Assistive Technology. To see the full schedule of classes offered for ATI or for more information please visit http://www.csun.edu/accessibility/training.

Instructor: Sue Cullen. Class length 1.5 hours.

Meeting Maker

A calendar and scheduling software used primarily by faculty. This is a Hands–on Meeting Maker basics class. Learn to coordinate and schedule meetings with other CSUN faculty. Keep your own calendar, schedule tasks and To Do lists.

Instructor: Dorothy Ramirez. Class length 2.0 hours

Microsoft Office 2008 (Mac) – Highlights, New Features & How to Configure Email

Description: Microsoft Office 2008 for the Apple MacIntosh computer system is the latest release of Microsoft's productivity suite. It includes tools for word processing, spreadsheet, presentation, email and calendaring. It features a radical interface overhaul, which combines the best of Office's previous features. This presentation style class will highlight the new features available in 2008 as well as go over how to configure entourage email for CSUN.

Instructors: Chris Sales & Linda Llanes. Class Length 1 hour.

myNorthridge – How to Login & Personalize your Portal Home Page

A new campus portal was launched June 28, 2007. It's new look and feel, streamlined navigation, and ability to personalize your portal homepage are just a few of its features. Come learn how to view and personalize your portal home page.

Instructor: Dorothy Ramirez. Class length 45 minutes.

Outlook 2007 Calendaring

Learn to share, view, delegate and create additional calendars as well as how to use/manage department calendars.

Instructor: Linda Llanes. Class Length 2 hours.

Outlook Exchange 2007 – Using Email, Calendaring, Tasks, Notes & Contacts

Outlook is an integrated email, calendaring, tasks and contacts program used by all University employees and auxiliaries. This hands–on class covers how to use all the Microsoft Outlook 2007 features such as; email, calendaring, contacts, tasks and notes. (the instructor and time allotment stays the same)

Instructor: Linda Llanes. Class Length 2 hours.

PowerPoint 2007 – Basics

Hands on introduction to Microsoft PowerPoint presentation software: how to create screens, insert text and graphics, and combine elements for a simple presentation. General hints on effective presentation.

Instructor: Tina Reed. Class length 2.0 hours.

PowerPoint 2007 – Working with Themes, Layouts and Masters (Intermediate Skills Class)

With multiple slides to manage, it is important to maintain consistency in both the look and feel of your presentation. This class will teach you how to customize your presentation by using Themes, Layouts and Masters. Topics discussed: Applying a theme, customizing themes, modifying slide layouts, adding a logo or background to a master slide. Prerequisite: PowerPoint 2007 – The Basics. Class Length: 2 hours.

Instructor: Tina Reed

Publisher 2007 – Creating Professional Flyers & Brochures

Does your department need to create brochures, handouts or flyers ?? Come learn how simple it is to create professional looking flyers and brochures.

Instructor: Tina Purtee. Class length 2.5 hours.

Recording Grades in SOLAR

This session is an "open lab" format geared towards instructors and anyone that has been approved to enter and/or submit grades in the SOLAR Student Administration module. If you need assistance with recording class grades or just a place to sit and enter class grades visit our Open Lab sessions. SOLAR Support Staff will be on hand to assistance you if needed, in entering your grades for the semester. Don’t forget to bring your class information and Portal User ID and password.

Instructor: SOLAR SA Support Staff.

SOLAR Drop – In Lab – Faculty Access, View & Print Class Rosters

Faculty Access, View & Print Class Rosters – Need assistance in Accessing, Viewing or printing a class roster? Drop in anytime during the posted hours to get personalized assistance. If you have questions come see our SOLAR SA Staff who are here to help you.

Instructors: Tina Reed & Sandra Caesar. Class length 2.0 hours.

SOLAR Student Inquiry & Advisement

This session provides an overview of the SOLAR Student Inquiry & Advisement module and is geared towards users that will be advising students or anyone that is responsible for viewing or updating a student’s personal record. This includes term and course info, eligibility requirements and transcripts. Current access to the module is not required.

Instructor: Sandra Caesar. Class length 2.0 hours.

SOLAR SA – Schedule of Classes (SOC)

This class is primarily geared towards staff responsible for the class build, or towards those that are functioning as back-up to the scheduling staff within the department or College. The class reviews the major components of the Schedule of Classes pages within SOLAR SA. Including maintaining classes within the Schedule of Classes, class meetings, adjusting class associations, permission numbers, updating sections of a class, instructor advisor information, generating reports, scheduling a new class, etc.

Instructor: Tina Reed. Class length 1.5 hours.

Use of the Template System in Contribute and Quick Accessibility Check

Learn how to use the University Templates to create an accessible website. To see the full schedule of classes offered for ATI or for more information please visit http://www.csun.edu/accessibility/training.

Instructors: Sue Cullen, Kimon Rethis, David Gerard Mascarina. Class length 3.0 hours.

Webmail

Access Your Mail from the Internet – Webmail allows a user to access their CSUN email mailbox via the world wide web from anywhere. The university recently rolled out a new version of webmail. This new version has a new look & feel, and more features. Come learn about what is now available to users.

Instructors: Dorothy Ramirez. Class length 2.0 hours.

Word 2007 – Creating & Using Tables in Your Document

Tables are great to organize data in a word document, align columns of data, structure a word document page, and much, much more. Learn how to create and use tables in your word document and learn a few tips along the way.

Instructor: Dorothy Ramirez. Class length 2.0 hours.

Word 2007 – Creating & Using Mail Merge Functions

Learn how to use the Mail Merge Function in Word to create Mailing Labels, Form Letters, Print Envelopes. Import contact files from other applications to use with mail merge.

Instructor: Dorothy Ramirez. Class length 2.0 hours.

Tell us what kind of technology training would spark your interest at CSUN by contacting us at x1700 or by writing us at training@csun.edu.