Training & Classes

Training is offered at no charge to Faculty and Staff of departments within the College of Letters and Science only.  Content is customized to reflect LSIT services.

Seating is limited - reservations required.

To Enroll in a Class:

Decide which class you would like to take, and click Enroll or email help@lsit.ucsb.edu

Please include the following information in your email:

  • Your Name
  • Your Department
  • Class Title/Topic
  • Class Day/Time

These workshops are  from 10AM-11:50AM and are designed to be "hands on". Please see workshop descriptions below for locations.


Here are a few of the topics that we will cover:

Computer Basics

The class will cover basic computer functions that we think will be valuable to staff and faculty.

  • What are the parts of the computer and how do we use them
  • Applications and Programs: What they are, and how to access them
  • Organizing Files and Folders
  • Translating "Techspeak"
  • Tips and tricks for getting around your machine
  • Web browsers, Viruses & Spyware

Backups & Viruses

The class will cover how to backup your data and what to do if you get a virus.
  • What to do when something goes wrong
  • Types of Viruses & Spyware
  • Backup Strategies

Using Word at UCSB [05/29/2012]

Location: SSMS 1303

Prerequisite:

Experience working in the Windows operating system (which includes familiarity with such terms as memory, files, icons, input, output and storage devices; and such skills as using a mouse to point, click and drag, launching an application, saving and opening a file).

Description:

Most of us use MS Word as our word processor, but it right out of the box it is a powerful publishing tool. This workshop highlights some of the futures currently used by some departments to achieve impressive results. We will explore Mail merging, styles [including balloons styles!], commenting, references, table of contents, breaks, great tips and other features. This hands-on workshop promises to change your ideas of what MS Word can do for you while creating documents for your department.

Upon completion of this workshop, participants should be able to:

·       Understand the different types of page breaks.

·       Create and Use custom styles.

·       Create tables of contents.

·       Create and use the Screenshot, References, and Building Blocks tools

·       Create custom mail merge letters.

Introduction to Excel 2010 [Tuesday, 04/19/12]

Location: SSMS 1304

Prerequisite:

Experience working in the Windows operating system (which includes familiarity with such terms as memory, files, icons, input, output and storage devices; and such skills as using a mouse to point, click and drag, launching an application, saving and opening a file).

Description:

This workshop is applicable to all versions of Excel. In this session, designed for the novice spreadsheet user, you will learn the basics of worksheets using Excel. Topics covered include creating spreadsheets, entering values vs. text, tips and technical terms associated with spreadsheets.

Upon completion of this workshop, participants should be able to:

·       Create a basic worksheet by entering text, values, and formulas.

·       Create formulas by using Excel built-in functions.

·       Move, edit, and copy data using a variety of shortcuts, buttons or menus.

·       Change the appearance of worksheet data by using a variety of formatting techniques.

·       Prepare a document for printing using a variety of printing options.

·       Use the three-dimensional aspect of the Excel workbook environment by creating formulas that refer to cells on multiple worksheets. Save an Excel workbook in multiple formats.

Intermediate Excel 2010 [Tuesday, 04/24/2012]

Location: SSMS 1303

Prerequisite:

Familiarity with Excel basics (e.g., entering, correcting, and formatting cells).

Description:

In this workshop you will learn some of Excel’s advanced data management features and. Topics covered include creating a database or table in Excel; using a data form for data entry; sorting; using filters and filtered lists; summarizing data; creating charts; popular functions and formulas.

Upon completion of this workshop, participants should be able to:

·       Sort information using the sort and filter features.

·       Understand how formulas and functions work, where to find and use them.

·       Understand and create tables.

·       Create charts that graphically represent worksheet data. Modify charts.

Using Excel at UCSB [Tuesday, 06/05/2012]

Location: SSMS 1303

Prerequisite:

Experience working in the Windows operating system (which includes familiarity with such terms as memory, files, icons, input, output and storage devices; and such skills as using a mouse to point, click and drag, launching an application, saving and opening a file).

Description:

Come and see how your peers are use MS Excel to do their jobs. This workshop will feature how to do weighted averages, a ledger system and data filtering to achieve interesting reports. In looking at some real life samples we will cover: formulas and functions; tables, filters, pivot tables, and simple macros.

Upon completion of this workshop, participants should be able to:

·       Find, and use functions.

·       Understand, create and use tables.

·       Understand and use advanced filtering.

·       Understand, create and use pivot tables.

Introduction to Access 2010 [SUMMER 2012]

Location: TBA

Prerequisite:

Experience working in the Windows operating system (which includes familiarity with such terms as memory, files, icons, input, output and storage devices; and such skills as using a mouse to point, click and drag, launching an application, saving and opening a file). Participants should have at least 6 months experience with some other Microsoft application (experience with MS Excel is particularly helpful).

Description:

This workshop provides an overview of database management and relational databases and introduces you to various Access objects. You will learn essentials such as basic database design principles, how to create a database, working with tables, defining fields and properties, filtering techniques, creating forms and reports using the wizard, and using data from sources external to Access (spreadsheets, text files, and other databases). You will also learn techniques for working with datasheets, editing and formatting data and how to get started quickly by taking advantage of the various "Wizards" that come with Access.

Upon completion of this workshop, participants should be able to:

·       Understand database concepts and terminology in Access.

·       Design and create tables.

·       Enter and manipulate data in tables.

·       Create data queries.

·       Create data forms for viewing and inputting data.

·       Create reports that summarize and group data.

·       Perform database maintenance procedures.

Introduction to Photoshop [Tuesday, 05/01/2012]

Location: SSMS 1303

Prerequisite:

Experience working in the Windows operating system (which includes familiarity with such terms as memory, files, icons, input, output and storage devices; and such skills as using a mouse to point, click and drag, launching an application, saving and opening a file).

Description:

Learn the basics of Photoshop CS5 including how to utilize layers and master selection tools. Discover how to work with text, apply special effects and how to use blending modes. Learn how to re-size and prepare images for web and print use.

The workshop introduces image layers, including how to combine multiple images into a single "composite" image, and pick the best parts of each.

Upon completion of this workshop, participants should be able to:

·       Understand the basic layers principles.

·       Create, edit, use layers.

·       Use text.

·       Resize, Crop and create a composite.

·       Save images for multiple purposes.

·       Use various filters and effects on layers.

Introduction to Dreamweaver CS5 [Tuesday, 05/15/2012]

Location: SSMS 1303

Prerequisite:

Prior experience with Windows, MacOS and/or word processing tools.

Description:

In this introductory class you will get hands-on experience creating simple web pages. You will learn how to create and manage a site for your website, learn about the different palettes and how to customize settings through Dreamweaver’s preferences. Users will learn how to use the available formatting tools, change the background color, and insert graphics, anchors, hyperlinks, tables and link to files from other applications such as Microsoft Word and Excel.

Upon completion of this workshop, participants should be able to:

·       Understand how websites and webpages work.

·       Create HTML documents, and add images.

·       Create text and graphical links.

·       Format web pages backgrounds, text and create different margin sizes.

·       Setup a new site, and manage web files.

Intermediate Dreamweaver CS5 [Tuesday, 05/22/2012]

Location: SSMS 1303

Prerequisite:

Prior experience with Dreamweaver or completion of the Introduction to Dreamweaver CS5 workshop.

Description:

On the first hour of this two-hour advanced class you will get hands-on experience using some of Dreamweaver’s advanced tools. The second hour will be used to build a site and publish your web pages using Dreamweaver’s built-in FTP program. This class will focus on using the cell layout tool to design a web page, using templates to create consistency of all web pages in your site, inserting a navigation bar and rollover images, and using the swap images effect from the Behaviors panel.

Upon completion of this workshop, participants should be able to:

·       Create tables, embedded tables, and frames.

·       Use and create templates.

·       Create rollovers for images, and image maps.

·       FTPing [transferring web files into a designated server]

·       Manage HTML Files.

Introduction to Creating PDFs with Acrobat [Tuesday, 06/12/2012]

Location: SSMS 1303

Prerequisite:

Experience working in the Windows operating system (which includes familiarity with such terms as memory, files, icons, input, output and storage devices; and such skills as using a mouse to point, click and drag, launching an application, saving and opening a file).

Description:

As you have probably noticed, it is really easy to find already created PDF forms on the Web. Unfortunately, most people do not know how to create PDFs well. Come and learn how to create interactive PDFs for your department without the need of typewriters.

Upon completion of this workshop, participants should be able to:

·       Understand what PDFs can do.

·       Create Field Boxes.

·       Create Editable Fields.

·       Edit previously created PDFs.

·       Secure PDF documents.

Working with Web and Print Images [Tuesday, 05/08/2012]

Location: SSMS 1303

Prerequisite:

Experience working in the Windows operating system (which includes familiarity with such terms as memory, files, icons, input, output and storage devices; and such skills as using a mouse to point, click and drag, launching an application, saving and opening a file).

Description:

This workshop provides an overview of database management and relational databases and introduces you to various Access objects. You will learn essentials such as basic database design principles, how to create a database, working with tables, defining fields and properties, filtering techniques, creating forms and reports using the wizard, and using data from sources external to Access (spreadsheets, text files, and other databases). You will also learn techniques for working with datasheets, editing and formatting data and how to get started quickly by taking advantage of the various "Wizards" that come with Access.

Upon completion of this workshop, participants should be able to:

·       Understand image formats

·       Crop and rotate

·       Conduct simple exposure adjustments

·       Conduct simple color adjustments

·       Prepare images for print

·       Prepare images for digital devices

Scheduled Classes

  • Introduction to Access 2010:
    None Scheduled
  • Introduction to Excel 2010:
    Apr 19, 10:00 AM
  • Intermediate Excel 2010:
    Apr 24, 10:00 AM
  • Introduction to Photoshop:
    May 1, 10:00 AM
  • Working with Web and Print Images:
    May 8, 10:00 AM
  • Introduction to Dreamweaver CS5:
    May 15, 10:00 AM
  • Intermediate Dreamweaver CS5:
    May 22, 10:00 AM
  • Using Word at UCSB:
    May 29, 10:00 AM
  • Using Excel at UCSB:
    Jun 5, 10:00 AM
  • Introduction to Creating PDFs with Acrobat:
    Jun 12, 10:00 AM