Technology Services Calendar

-

Tuesday, July 2, 2019

    • 1:00 - 3:00 pm   Tues afternoon
    • UIUC -- location to be announced

    A properly designed database makes it easier to work with up-to-date, accurate information. Investing the time required to learn the principles of good relational database design ensures that you will end up with a database that meets your needs and can easily accommodate change. This new workshop provides guidelines for planning an Access database.

Monday, July 8, 2019

    • 1:00 - 3:00 pm   Mon afternoon
    • Illini Hall, Room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    In this 2-hour workshop, participants will learn how to create and open InDesign documents, navigate the user interface, modify a document, import graphics, and manipulate basic text and text frames.

Tuesday, July 9, 2019

    • 9:00 am - 4:00 pm   Tuesday (lunch on your own)
    • Illini Hall, room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    InDesign is a desktop publishing program that combines incredible power and flexibility with a surprisingly easy-to-use interface -- for creating or editing everything from simple posters and brochures to multi-chapter books. We will do the basics in this 6 hour class.

    • 1:00 - 4:00 pm   Tues/Thurs afternoons
    • UIUC -- location to be announced

Wednesday, July 10, 2019

    • 9:00 am - 12:00 pm   Wed/Fri mornings
    • UIUC -- location to be announced

    In this 6-hour course, you will import and export data into Excel 2016, work with conditional formatting, and learn about macros. Additional topics will include summarizing data using subtotals and data validation; and analyzing data using Goal Seek and Solver along with what if scenarios. Prerequisite: Completion of Excel 2016 Level 1 or equivalent knowledge

    • 9:00 am - 4:00 pm   Wednesday (lunch on your own)
    • Illini Hall, Room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    Extend your InDesign skills even further by learning to use InDesign's more advanced features effectively. We'll work more deeply with styles. You'll use clipping paths to reveal only part of an image, create type outlines, and create Bezier paths. We'll also import layered files, merge data into documents and create a book with table of contents and references.

Tuesday, July 16, 2019

Wednesday, July 17, 2019

    • 9:00 am - 4:00 pm   Wednesday (lunch on your own)
    • Illini Hall, Room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    This 6-hour course introduces the basics of Adobe Lightroom. Participants will work on the organization and management of photos, learning the Lightroom environment, managing images and workflow, reviewing images, sorting and organizing images as well as managing an image catalog.

Thursday, July 18, 2019

    • 9:00 am - 12:00 pm   Thurs morning
    • UIUC -- location to be announced

    In this 3-hour course learn how to create and work with Access forms. Create a new form using the form wizard and explore layout and design view. Add and modify form controls including a calculated control and lookup control. Learn about control properties, form properties and setting tab order.  Create a subform and learn about switchboard and navigation forms.

    • 9:00 am - 4:00 pm   Thurs (lunch on your own)
    • Illini Hall, Room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    Lightroom Level 2 is the second course in Lightroom, utilizing the Develop module, to concentrate on making image corrections in a non-destructive manner. Topics include: Develop module basics, Image adjustment basics, working with color, fixing common image problems like straightening and cropping, as well as more advanced topics like creating snapshots and panoramas.

Friday, July 19, 2019

    • 10:00 am - 12:00 pm   Fri morning
    • UIUC -- 27 Illini Hall

    In this 2-hour workshop, participants will access, organize, and share creative assets for use in your Adobe desktop and mobile apps. We will practice using Adobe’s CC Libraries in applications as well as using the Web interface to load frequently used assets, such as logos, wordmarks and colors. We will explore sharing and collaborating with colleagues.

Monday, July 22, 2019

    • 1:00 - 3:00 pm   Mon afternoon
    • UIUC -- location to be announced

    In this 2-hour short course you will learn how to comfortably move around in the Excel 2016 environment. Additional topics will include entering text and values in a worksheet, basic formatting, printing and using Help.

Tuesday, July 23, 2019

    • 9:00 am - 12:00 pm   Tues. morning
    • UIUC -- location to be announced

    This 3-hour class introduces the query object.  Topics include working in design view; creating a simple query by adding and removing fields and adding criterion. We will create multi-table queries; calculated fields and set field properties; explore a totals query, parameter query, action queries, find duplicates query, unmatched records query and basic SQL query.

    • 10:00 am - 12:00 pm   Tues. morning
    • Illini Hall, room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    In this 2-hour workshop, participants will learn how to create and open Illustrator documents, navigate the user interface, use vector shapes to create a logo that looks good on screen and in print. No prior knowledge of Illustrator is required.

    • 1:00 - 3:00 pm   Tues afternoon
    • UIUC -- location to be announced

    Attendees will become familiar with the Outlook 2016 calendar interface (including the enhanced Ribbon tools). You will also learn how to schedule and edit an appointment; work with calendar labels and tasks displayed on the Calendar. We will schedule meetings with the Scheduling Assistant and practice scheduling a conference room.

    • 1:00 - 4:00 pm   Tues/Thurs afternoons
    • UIUC -- location to be announced

    This six-hour course is intended for Mac users who want to learn basic Word 2016 skills such as creating, editing, and formatting documents; working with tabular text; and employing a variety of techniques for improving the appearance and accuracy of document pages. Finally, we will learn about printing documents.

    • 3:00 - 5:00 pm   Tues afternoon
    • UIUC -- location to be announced

    Wish you had a smarter, more efficient way to arrange your Outlook 2016 email and more? In this two-hour workshop, you will learn how to use the conversation view; how to insert a screenshot into a message; sorting messages; advanced searching techniques, including filters; working with folders; using flags, color categories, and rules.

Wednesday, July 24, 2019

    • 10:00 am - 12:00 pm   Wed morning
    • Illini Hall, room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    In this 2-hour workshop, participants will learn the basics of using the drawing tools in Adobe Illustrator CC, including how to use the Pencil and Curvature tools, how to edit paths. Then we will look at layers, including how to create, edit, and organize content. We will also learn the basics of transforming and editing artwork in Adobe Illustrator CC.

    • 1:00 - 3:00 pm   Wed afternoon
    • UIUC -- location to be announced

Thursday, July 25, 2019

    • 9:00 - 11:00 am   Thurs morning
    • UIUC -- location to be announced

    In this 2-hour short course you will learn how to add, divide, multiply, and subtract by entering formulas into Excel 2016 worksheets. Other topics will include an exploration of just a few of the hundreds of functions available in Excel. We will learn how to find a specific function, as well as how to get help while entering arguments.

    • 10:00 am - 12:00 pm   Thurs morning
    • Illini Hall, Room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    In this 2-hour workshop participants will learn how to use Photoshop to do basic photo correction, use selection tools, manipulate, save, and store images. No prior knowledge of Photoshop is required.

Monday, July 29, 2019

Tuesday, July 30, 2019

Wednesday, July 31, 2019

    • 9:00 am - 4:00 pm   Wednesday (lunch on your own)
    • Illini Hall, Room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    • 1:00 - 3:00 pm   Wed afternoon
    • UIUC -- location to be announced

    In this 2-hour workshop we will explore the whole set of features for managing information in tables in Excel 2016. These features make all the typical tabular manipulations—sorting, filtering, analyzing, and formatting, easier than ever.

Thursday, August 1, 2019

    • 9:00 - 11:00 am   Thurs morning
    • Illini Hall, Room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    • 10:00 am - 12:00 pm   Thurs morning
    • UIUC -- location to be announced

    In this short course you will learn how to use some of the data analysis features and tools in Excel 2016. Topics will include learning the basics of PivotTables; using subtotals in a list of data; setting up data validation rules; using Goal Seek, Solver, Scenarios and more.