The Spring 2008 Education Series is available, please see the below for the schedule. New Brunswick Computing Services offers free hands-on computer training for University faculty, staff and students in the HR class rooms on Livingston campus and in Davidson Hall and the ARC computer lab on Busch Campus. If you are interested in attending any of our classes, advance registration is required. Because the classes are hands-on, seating is limited, and registration is on a first-come, first-served basis. For some classes you will need to access your Rutgers computer account. Please make certain you can access your account (RCI, Eden, Andromeda, Pegasus, Crab, or Clam) prior to arrival. It is unlikely that passwords will be able to be changed or checked the day of the class. If you can not get on your account at the start of the class, you most likely will need to look on with another attendee. If you need assistance with this please contact the Help Desk (732) 445-4357 or E-mail edseries@nbcs.rutgers.edu . * Free virus protection software is available to all current faculty, staff, and students at Rutgers University. * Spring 2008 schedule. CALENDAR OF CLASSES REGISTER FOR A CLASS POTENTIAL CLASS OFFERINGS (see schedule above for exact offerings) The Basics of SAS/PC Intermediate SAS The Basics of SPSS for Windows An Introduction to PHP Introduction to Data-driven Web Site Design Mailman Basics UNIX I, Getting Started UNIX II, The Basics UNIX III, Intermediate Topics Creating a Web Page Using Nvu E-managing Your E-mail Account  Microsoft Access Microsoft Excel Basics Microsoft Excel Intermediate Using the RULink Calendaring System Advanced RULink Calendaring for Unit Computing Specialists Introduction to Computer Security Identity Theft: Prevention and Recovery Linux Incident Response Other Training Opportunities Camden Education Series Newark Education Series Center for the Advancement of Teaching (for faculty/staff) Libraries An Introduction to PHP Instructor: Chris Jarocha-Ernst NOTE: this is a 2 part class PHP is a server side web scripting language that is setting the standard in the creation of dynamic websites. This hands-on class teaches PHP programming for non-programmers. Attendees will leave this session able to: Create a basic dynamic website Learn basic programming constructs Create online forms that send email Prerequisites: Experience in writing HTML, basic UNIX commands, using a text editor on RCI/Eden (Emacs, vi, Pico), and an RCI or Eden account. Introduction to Data-driven Web Site Design Instructor: Joe Donato NOTE: this is a 2 part class This course covers the basics of web development in php and MySQL. Attendees will leave this session knowing the basics of: SQL DML DDL Database design How PHP and MySQL interact Automatic form generation Creating interfaces (public and private) to a database IMPORTANT NOTES: Participants must contact help@rci.rutgers.edu or help@eden.rutgers.edu (depending on where their accounts are) at least two weeks before class in order to request a MySQL database. They must also know their MySQL passwords after their databases have been created to participate in the class. Please include in your MySQL DB request: Name of account the DB will be associated with Name of the DB in the form "netid_name" where netid matches the NetID of the account it is to be associated. A phone number to call you to give you the DB password Prerequisites: Successful completion of "An Introduction to PHP" and creation of a MySQL DB BEFORE coming to class. Mailman Basics Instructors: Michael Gradin & Joe Moore This class teach the basics of how to administer a list using Mailman. Some of the topics to be covered will be: Requesting new lists Joining and Leaving lists Changing Owners and Moderators How to set up a moderated list Mailman webtools Bulk subscribe/unsubscribe UNIX I, Getting Started Instructor: Joseph Donato or Dan Koft This hands-on class is an introduction to UNIX at Rutgers. Attendees will leave knowing about: NetID/usernames and passwords How to log in and out Introductory UNIX commands How to get Help UNIX Files, Directories and Paths Prerequisites: Some familiarity with computers. An account on RCI, Eden, Andromeda, Pegasus, Crab, or Clam is an absolute requirement. An on-line tutorial for this course is here. UNIX II, The Basics Instructor: Dan Koft or Joe Donato This hands-on class picks up where the UNIX I, Getting Started class left off. Attendees will leave knowing about: Metacharacters Editors Command Line Editing File and Directory Access and Protections Basic UNIX Commands This class is recommended for those who plan to serve their Web pages on a UNIX machine. Prerequisites: Familiarity with computers, UNIX I, Getting Started or equivalent, and an RCI, Eden, Andromeda, Pegasus, Crab, or Clam account. An on-line tutorial for this course is here. UNIX III, Intermediate Topics Instructor: Dan Koft or Joe Donato This hands-on class is designed for those interested in in-depth usage of UNIX and using UNIX for programming. Attendees will leave knowing about: Shells, Shell Variables, and Shell Scripts Processes Multitasking Input/Output Redirection On-line Documentation Prerequisites: Familiarity with computers, UNIX I, Getting Started and UNIX II, The Basics or equivalent, an RCI, Eden, Andromeda, Pegasus, Crab, or Clam account. An on-line tutorial for this course is here. The Basics of SAS/PC Instructor: Rob Bowell Note: an RCI, Eden, Andromeda, Pegasus, Crab, or Clam account is not required for this class. This two-part hands-on class will provide attendees with the ability to : Understand the Display Manager Windows Read and Understand SAS Error Messages Understand the Structure of SAS Files and How SAS Uses Them Obtain Simple Statistics on a SAS Dataset Produce Reports Create and Manipulate Datasets within SAS Prerequisites: Familiarity with computers, Windows Operating System. A knowledge of Windows file structure and understanding of basic statistical concepts. NOTE: THIS IS A TWO-DAY COURSE. Attendance is expected on BOTH days. Intermediate SAS Instructor: Rob Bowell Note: an RCI, Eden, Andromeda, Pegasus, Crab, or Clam account is not required for this class. This course is designed to provide hands-on training in some intermediate SAS topics, including some statistical procedures, and more advanced data set programming than the SAS Basics class. At the end of this course, students will be able to: Use PROC CHART to Produce Bar and Pie Charts Use PROC CORR to Find Out Correlation Coefficients for Data Use PROC IMPORT to Read External Files, Including Excel Files Perform Conditional Processing on SAS Data Sets Merge and Concatenate SAS Data Sets Prerequisites: Familiarity with computers and the Windows operating system in particular. Knowledge of Windows file structure. Understanding of basic statistical concepts (mean, standard deviation, significance levels, etc.). Completion of SAS/PC Basics Education Series course, or equivalent level of knowledge. The Basics of SPSS for Windows Instructor: Rob Bowell Note: an RCI, Eden, Andromeda, Pegasus, Crab, or Clam account is not required for this class. This is a beginner's course, intended to provide a basic familiarity with SPSS for Windows. At conclusion of the course, attendees will be able to: Create New Data Sets Convert Data from Other File Formats Format Data Sets With Value Labels and Missing Data Assignments Recode Data Create New Variables in Existing Data Sets Produce Report and Chart and Cross-tabs Output Prerequisites: Familiarity with computers and Windows Operating System in particular, knowledge of the windows file structure and an understanding of basic statistical concepts (mean, standard deviation, significance levels, etc.). Netscape Messenger Electronic Mail Version 7 Instructor: Chris Jarocha-Ernst Netscape is a World Wide Web browser, and Netscape Messenger is the electronic mail component. This hands-on class will demonstrate how electronic mail works, how to configure your Messenger Mailbox, check your electronic mail, compose and send messages, manage your electronic mail, use the address book, read and send attachments. Prerequisites: Familiarity with computers, Windows, using a mouse, and a Web browser, and an RCI, Eden, Andromeda, Pegasus, Crab, or Clam account. On-line tutorial for setting up and using the Netscape Messenger E-mail Program Creating a Web Page Using Nvu Instructor: Chris Jarocha-Ernst Nvu is a web page editing program available for Windows, Macintosh, and Linux systems. It provides many tools for page construction, eliminating the need to write in HTML (the web page language), but still allows access to the page's HTML code for users who wish it. This hands-on class will cover: Setting up a web directory on your account Creating and publishing basic pages Adding links and images Organizing text with tables Prerequisites: Familiarity with computers, Windows, using a mouse, and a Web browser, and an RCI, Eden, Andromeda, Pegasus, Crab, or Clam account. Knowledge of HTML is not required. Macintosh Basics Instructor: Brian Boccardi or Jimi Oleksiak This hands-on class will cover the basics of using Apple Macintosh computers. Topics will include concepts that define the Macintosh including: The Desktop, Finder, and Applications Menu How to run programs How to save, load, and manage files and folders How to create program aliases How to use the Macintosh's built-in networking features to share printers and files with other Macintoshes How to be a Mac Power User  Instructor: Brian Boccardi or Jimi Oleksiak This hands-on class goes beyond the basics and shows you tips and tricks to make your use of the Macintosh more efficient. Understand your Macintosh better and learn how to make it work best for your needs. Examples will use the latest Mac OS X (version 10.x). Topics include: How to keep your Mac running at optimal performance level  How to configure system settings for efficiency  How to customize the Macintosh  How to deal with problems on the Mac  How to prevent your Mac from crashing  Care and feeding of the hard drive  Using Macintosh utilities: Disk First Aid, Norton Disk Doctor, Conflict Catcher.  How to translate file formats between applications for Mac and Windows using MacLink Plus.  Using iMovie with a Macintosh Instructor: Jimi Olekiak Desktop video editing is the greatest computing innovation since desktop publishing. Using a digital camera, a Macintosh computer with a firewire data port, and the iMovie video editing software, you can create high quality educational videos. Desktop video editing gives you the ability to eliminate the boring or irrelevant scenes, to rearrange the sequence of the video segments or clips, and to add titles, transitions and sound as well as special effects. The results can either be exported back to the digital video tape, saved as a file to be used on the web or burned onto a recordable DVD disk on Macs with the new Superdrive. The power to create interesting and valuable videos is now in your hands. Imagine the possibilities for teaching and research! This class is a detailed live demonstration that will make it clear exactly how to use iMovie. Attendees can expect to learn how to edit a digital video and can depend on continued consultation support from the instructor. The class is also available for presentation within individual departments. Presentation time: about an hour. E-managing Your E-mail Account  Instructor: Joseph Donato If you are having problems with your disk quota, or if you just want to learn how to stay below your disk quota this class is for you. In this class, you will learn to: How to maintain your email accounts on the OIT systems. Main reasons why people go over their disk quota How to avoid going over your quota What to do if and when you do go over your quota This class is open to anyone from beginner to expert. The only requirement is that you have an RCI, Eden, Andromeda, Pegasus, Crab, or Clam account. Linux Incident Response   Instructor: Beth Binde Discussion and demonstration of current "best practices" for data collection and analysis in the event of a computer incident. Hands-on lab session. Prerequisites: Familiarity with UNIX Intended audience: Departmental computer staff with responsibility for UNIX systems, others welcome as space permits Microsoft Excel Basics Instructor: Marcie Anszperger (Center for the Advancement of Teaching) This workshop is being offered with the Center for the Advancement of Teaching (CAT) for the NBCS Education Series. Excel: Basic - This workshop will orient the new user to the concept of the spreadsheet (or worksheet) in Excel. Attendees be able to: Understand the structure of an Excel spreadsheet and how a cell functions Explore different methods of populating cells: autofill, clipboard management, and cutting & pasting techniques Formatting numeric and text information in a cell Understand the "rules" for creating Excel formulas and how to apply them appropriately Understand the difference between autosum formulas, simple formulas and functions, and when to use them appropriately Understand relative vs. absolute cell reference and how to apply them in Excel formulas Microsoft Excel Intermediate Instructor: Marcie Anszperger (Center for the Advancement of Teaching) This workshop is being offered by the Center for the Advancement of Teaching (CAT) for the NBCS Education Series. Excel: Intermediate - This workshop will extend an Excel users knowledge. Attendees be able to: Explore Additional Excel Functions Use Excel as a Database Management Tool Use the Subtotal Function Produce Graphs and Charts Start Using Pivot Tables Start Using Macros Microsoft Access Instructor: Marcie Anszperger (Center for the Advancement of Teaching) This workshop is being offered with the Center for the Advancement of Teaching (CAT) for the NBCS Education Series. Access: Basic - This workshop will acquaint the new user with the basic tools in Access. This class explores many of the functions in Access. Attendees will be able to: Understand the Database Structure in Access How to Create and Manage Data in Tables Import Data From Outside Applications to Tables How to Use Queries to Prepare Data for Reports, Mail Merge and Other Applications Create Forms and Reports Using the Built-In Wizards Using the RULink Calendaring System Instructor: Joe Donato RULink is an on-line time management tool. RULink works well with Microsoft Outlook as well as many other tools spanning most major operating systems. The prerequisite is knowing how to use a web browser such as Internet Explorer, Firefox, Mozilla or Netscape. Participants will leave this course knowing how to: Scheduling appointments Scheduling tasks Subscribing to other calendars Using RULink in conjunction with other time management tools Course prerequisite: an active RCI, Eden, Andromeda, Pegasus, Crab, or Clam account. Advanced RULink Calendaring for Unit Computing Specialists Instructor: Rob Bowell RULink is a powerful tool that allows for the scheduling of events University-wide. This course is designed to familiarize computer support providers at the University with the more advanced functions of RULink and to equip them to effectively support the use of this system in their operating environment. Attendees will be able to: Synchronize RULink and Palm-type devices Configure their calendars How to request a domain Change the way a person receives mail on the system Create, delete and manage shared-resource calendars Create email lists and shared file storage areas Create non-Rutgers users for your domain Create and manage shared mailboxes Find help and assistance managing their calendar domains This course assumes an intermediate level of familiarity with computing in general, and while we will be covering the basics of the RULink calendaring system, they will only be covered in brief. For more thorough coverage of the calendaring system, consider attending the class Using the RULink Calendaring System. Course prerequisite: Using the RULink Calendaring System Introduction to Computer Security Instructor: Bruce Rights This course will show you why you should maintain a security awareness and some basic steps you can take to improve the security of your computer usage. Who Should Attend This Course: End users Secretaries Computer users with computer support personnel in their department Everyone (general awareness) Identity Theft: Prevention and Recovery Instructor: Bruce Rights This course will show you how to take preventative measures to protect yourself from Identity Theft. In addition, we will cover how to respond if you actually become a victim. For additional information on our classes or for special requests on departmental training, please contact: E-mail: edseries@nbcs.rutgers.edu or Contact the Help Desk Phone: 732-445-HELP (4357) Suggestions for new or existing classes are always welcome! Copyright © 2007 Rutgers, The State University of New Jersey. All rights reserved.