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 so please email us at training@csun.edu or call x1700.

April 2008

SOLAR Schedule of Classes	OV Room 33	April 30, 2008	9:00AM – 11:00AM

May 2008

Recording Grades in SOLAR (Open Lab)	OV Room 33	May 12 – 23, 2008	Monday – Friday Only 8:00AM – 5:00PM
Word 2007 – Creating & Using Mail Merge Functions	OV Room 33	May 27, 2008	9:00AM – 11:00AM
Outlook Exchange 2007 – Using Email, Calendaring, Tasks, Notes & Contacts	OV Room 33	May 27, 2008	1:00PM – 3:00PM
Office 2007 – New Look and Feel	OV Room 33	May 28, 2008	9:30AM – 10:15AM
** NEW ** Access 2007 – Intermediate	OV Room 33	May 28, 2008	2:00PM – 3:30PM
** NEW ** PowerPoint 2007 – Working with Themes, Layouts and Masters – Intermediate	OV Room 33	May 30, 2008	9:00AM – 11:00AM

June 2008

** NEW ** Access 2007 – Basics	OV Room 33	June 3, 2008	10:00AM – Noon
Word 2007 – Creating & Using Tables	OV Room 33	June 10, 2008	2:00PM – 4:00PM
Excel 2007 – Basic	OV Room 33	June 11, 2008	10:00AM – 12:30PM
PowerPoint 2007 – Basics	OV Room 33	June 12, 2008	9:00AM – 10:30AM
MyNorthridge – Portal Login & Personalization	OV Room 33	June 18, 2008	10:00AM – 10:45AM
** NEW ** Excel 2007 – Creating Basic Macros	OV Room 33	June 23, 2008	10:00AM – 11:30AM
Outlook Exchange 2007 – Using Email, Calendaring, Tasks, Notes & Contacts	OV Room 33	June 24, 2008	9:00AM – 11:00AM
Outlook 2007 – Calendaring	OV Room 33	June 25, 2008	9:00AM – 11:00AM

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

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.

Office 2007 – New Look & Feel

Office 2007 suite of software now has a new look and feel to the layout of the menus and toolbars.  This class will orient you to the new items,  terminology used and where to locate necessary elements. 

Instructor: Tina Purtee. Class length 40 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.

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.