IT Training 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 how 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 hands–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(s): Dorothy Ramirez. 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(s): Dorothy Ramirez. Class Length: 2.0 hours.

Clicker - Working with a Student Response System (Beginner) Classes offered for PC and Mac Users

Bring the Digital Age into the Classroom - Classroom response systems—commonly referred to as "clickers" — have become popular as a means to promote interactivity, increase student participation, and streamline course administration. This hands–on introduction using Turning Point Clickers will provide faculty with steps in using clickers, recording response data, attendance tracking, digital exams, and/or research. General hints from faculty on effective use will be shared.

Instructor(s): TBA. Class Length: 2.0 hours.

Elluminate Live! – Using a Synchronous Web Conferencing Environment (Introduction)

Hands–on introduction to Elluminate Live! real-time virtual environment for e-learning.  This class will teach you how to schedule a session, imbed it in a LMS system, use audio, load PPT files, use whiteboard tools, test audio, and use polling for interaction.  Best practice tips from faculty on effective use to increase interaction will be shared.

Instructor(s): Prof. Ashley Skyler & Kate Berggren. Class Length: 1.5 hours.

Elluminate Live! – Using Advanced Tools in a Web Conferencing Environment (Advanced) – Sessions are Held Online

Hands–on advanced workshop in Elluminate Live real–time virtual learning environment. This class will teach you how to use break–out rooms, web tours, and application sharing. This class will take place online. Make sure and test your audio before the session. Best practice tips from faculty will be shared.

ONLINE SESSIONS

Instructor(s): Prof. Ashley Skyler & Kate Berggren. Class Length: 1.5 hours.

Excel 2007 – Basics

Learn how to use this powerful 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(s): Tina Purtee. Class Length: 2.5 hours.

Excel 2007 –Creating and Using Pivot Tables – Basics

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(s): Tina Purtee. Class Length: 1.5 hours.

Excel 2007 – Data Query & Management (Intermediate skills class)

Save time, energy, keystrokes and headaches. Learn some of Excel's more advanced functions to help you manage and query large or multiple data worksheets such as sorting data, filtering & querying data, creating & removing subtotals, and data validation.

Instructor(s): Tina Purtee. Class Length: 1.5 hours.

Excel 2007 – Creating and Using Basic Macros

Find out what a macro can do for you. Save yourself time and keystrokes on repetitive functions. Learn how to create Macros to 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)

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 work with and utilize multiple workbooks & worksheets simultaneously. Learn how to hide & unhide worksheets, move or copy entire worksheets, create & work with graphic objects, create basic charts, protect your data as well as linking data.  Understanding these techniques and functions will help you save time, keystrokes and headaches.

Instructor(s): Tina Purtee. Class Length: 2.5 hours.

Faculty Focused Excel 2007 Workshop – Excel 2007 – Using the SOLAR class roster download to create a grade sheet and an attendance roster

Offered at the beginning of each semester

Keeping a grade book and doing it manually?  Learn how to use Excel to change the SOLAR class roster download into an electronic grade book and attendance roster. 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(s): Tina Purtee. Class Length: 2.0 hours.

Integrating Web Communication Technologies into your Curriculum

This workshop will demonstrate how the latest Web technology can be integrated into the classroom to help instructors better connect with their students. These technologies aim to facilitate communication, secure information sharing and collaboration on the World Wide Web. Concepts such as web-based communities, hosted services, and applications such as social– networking sites and video–sharing sites like YouTube, Facebook, MySpace, wikis, and blogs are a few examples of the types of technologies.

Instructor(s): Talin Saroukhanian & Hillary Kaplowitz. Class Length: 1.5 hours.

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

Microsoft Office 2008 for the Apple computer system is the latest release of Microsoft's productivity suite. It includes tools for word processing, spreadsheet, presentation, and email & 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 cover how to configure entourage email for CSUN.

Instructor(s): Chris Sales/Linda Llanes. Class Length: 1.0 hour.

Office 2007 – New Look & Feel

The Office 2007 suite 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(s): Dorothy Ramirez. Class Length: 1.0 hour.

Outlook 2007 – Using Calendar Features

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

Instructor(s): Linda Llanes. Class Length: 2.0 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(s): Linda Llanes. Class Length: 2.0 hours.

Podcasting – Introduction

Hands–on introduction on turning your PPT lectures into annotated podcasts for your classes. Faculty will share their experiences in using podcasts with an English class.

Instructor(s): Mira Pak & Ahsley Skylar. Class Length: 1.5 hours.

PowerPoint 2007 – Basics (Best Practices)

Hands–on introduction to Microsoft PowerPoint presentation software. Learn best practices for creating screens, inserting text and graphics, and combining elements for a simple and accessible presentation.

Instructor(s): Linda Llanes. 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.

Instructor(s): Linda Llanes. Class Length: 2.0 hours.

Publisher 2007 – Creating Professional Flyers & Brochures

Learn how simple it is to create professional looking flyers and brochures using Publisher.

Instructor(s): Tina Purtee/Linda Llanes. Class Length: 2.5 hours.

Recording Grades in SOLAR - Open Lab for Faculty

This session is conducted in 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 availabe for assistance if needed to assist you in entering your grades for the semester. Don’t forget to bring your class information, CSUN username and password.

Instructor(s): SOLAR SA Support Staff. Class Length: TBA

SoftChalk Lesson Builder – Introduction (for Faculty)

Hands–on workshop turning a small section of your course content into a useable SofChalk module. Learn how to make interactive web pages, self–assessment quizzes, pop–up annotations, and interactive learning games. Prior to the session, visit the Online Instruction Faculty webpage at http://www.csun.edu/~webteach/faculty, enter your Userame and Password and download Lesson Builder. Bring your laptop and some concrete lesson content (PPT notes or Word documents) to the session.

Instructor(s): Rachel Friedman-Narr & Sally Spencer. Class Length: 1.5 hours.

SOLAR SA - 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 for personalized assistance. If you have questions come see our SOLAR SA Staff who are here to help you.

Instructor(s): SOLAR SA Support Staff. Class Length: 2.0 hours.

SOLAR SA 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(s): Sandra Caesar. Class Length: 2.0 hours.

SOLAR SA Schedule of Classes (SOC)

This class is geared primarily 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(s): Sandra Caesar. Class Length: 1.5 hours.

SOLAR SA - Creating SOC Reports

This class is a hands–on training that will cover how to run an SOC report in SOLAR. Topics include, selecting the appropriate report, working with parameters, specifying the output format and distribution method. An overview of the reports that are available will also be provided. Users must have access to run SOC Reports in SOLAR.

Instructor(s): Sandra Caesar. Class Length: 1.0 hour.

Turnitin – Check Your Student’s Work for Originality (Beginner)

Have you ever wondered if your student’s work was plagiarized/original? Hands–on introduction to Turnitin: Learn how to set up an account, check student’s work for improper citation or plagiarism, how to edit and grade papers online. General tips from faculty on effective use will be shared.

Instructor(s): Prof. Pat Swenson & Nancy Taylor. Class Length: 1.0 hour.

WebCT 4.1 – Introduction

WebCT is an e–learning tool which offers a wide range of options. This course is for Faculty who want to learn about and how to utilize a courseware product containing 20 online teaching tools.

Instructor(s): Kate Berggren, Barry Cleveland, Angie Giordano, Ashley Skylar or Anne Cleveland. Class Length: 1.5 hours.

WebCT 4.1 – Using Assessment Tools (Intermediate)

Hands–on intermediate workshop using the assessment tools in WebCT. Learn how to create quizzes (M/C, T/F, matching, and essay), use quiz settings, grade essay items, post grades online, and use the assignment drop-box. Faculty tips on effective use of the assessment tools will be shared.

Instructor(s): Prof. Ashley Skylar. Class Length: 1.5 hours.

WebCT 4.1 – Using Communication Tools (Intermediate)

Hands–on workshop in using the threaded discussion board and chat room in WebCT. Faculty tips on facilitating a chat using the chat rooms (Rooms 1–4, Main) and structuring a threaded discussion in WebCT will be shared. Rubrics for assessing student participation in a chat room and student postings to a discussion will be shared and discussed.

Instructor(s): Prof. Ashley Skylar. Class length 1.5 hours.

Word 2007 – All About Headers, Footers, Pages & Sections *New

A Word document has two layers: the main body layer and the header and footer layer. Headers and footers exist on every page within a document but they remain invisible until you add content. Headers and footers are used for document titles, email or web addresses, page numbers, dates, author information or document file name and path. Documents can contain several components or sections and headers and footers can be customized accordingly. This class will teach you how to make use of headers and footers in a Word document.

Instructor(s): Dorothy Ramirez. Class Length: 1.5 hours.

Word 2007 – Best Practices for Creating & Using Tables

Tables are used to organize data in a word document, align columns of data, structure a word document page, and much more. Learn how to create and use tables in your word document and learn other helpful tips.

Instructor(s): Dorothy Ramirez. Class Length: 2.0 hours.

Word 2007 – Using Mail Merge

Learn how to use the mail merge function in Word to create mailing labels, form letters and print envelopes. Import contact files from other applications to use with mail merge.

Instructor(s): Dorothy Ramirez. Class Length: 2.0 hours.

Word 2007 – Best Practices for Creating Structured & Accessible Documents

Learn the how–tos and what to avoid when creating Microsoft Office documents for conversion. Learn how to create a structured document and tools & functions available in Word. The Microsoft Word file format provides support for addressing most accessibility issues that arise with electronic documents. Learn best practices to utilize MS Word software efficiently.

Instructor(s): Tina Purtee. 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.

(Page Updated: 05-27-09)

• California State University
• Terms and Condidtions for Use
• Emergency Information
• Questions about this page?

• California State University, Northridge at 18111 Nordhoff Street, Northridge, CA 91330 / Phone: 818-677-1200 / © 2007 CSU Northridge