WANDA PLAWER has been an instructor with Parkland since 2000. She has been teaching and training in Microsoft Office since 1998 and works full time for the University of Illinois at Urbana-Champaign. She enjoys sharing her experience and knowledge of Microsoft Office and other software applications with students to help them become more proficient and comfortable with the software.
WENDY BARKER has been instructing students in a variety of settings since 1995. She moved from Florida where she was a Technology Facilitator at a private high school and began working with teachers throughout Illinois helping them to develop Technology Plans and use Interactive Whiteboards and other emerging technologies in the classroom. Wendy is excited to work with students at Parkland and help them learn new computer skills they can utilize in the workplace and at home.
GINA ISABELLI has been an instructor with Parkland since 1997. In 1996, she started teaching and training Microsoft Office programs at the University of Illinois for the Student Free Computer Program and Education Department, and through the Champaign Unit #4 School District while obtaining her Masters Degree in Secondary Science Education. She has been a science educator with the Champaign Unit #4 School district since 2000. She has taught Microsoft applications to students of all ages and levels starting as young as 10 years old through adults. She enjoys sharing her technology experiences for classrooms, businesses or home environments. Her goal is to pass along everything she can to make her student’s experience with new technology as easy and comfortable as possible.
Review the basic functions and features of Access 2013 with Wanda Plawer. After an introduction to database concepts, the Access environment, and Help systems, you will learn how to design and create databases; work with tables, fields, and records; sort and filter data; set field properties and data entry rules; and create queries, forms, and reports.
Prerequisite: Windows XP/Vista/7 or equivalent knowledge.
Wed Jun 1 & 8
CIS 716 002Z
Deadline: May 25
Discover how to normalize data,
manage table relationships, and enforce referential integrity with Wanda Plawer. Work with Lookup fields and sub datasheets; create join queries,
calculated fields, and summary values; add objects to forms and
create advanced form types; print reports and labels; create and
modify charts; and use PivotTables and PivotCharts.
Prerequisite: Microsoft Access 2013 Level 1 or equivalent knowledge.
Wed Jul 6 & 13
CIS 717 002Z
Deadline: Jun 29
Wanda Plawer will help you perform queries with SQL; create
crosstab, parameter, and action queries; create macros; import,
export, and link database objects; interact with XML documents;
create hyperlink fields; optimize, split, and back up databases;
password-protect and encrypt databases; and set Access options
Prerequisite: Microsoft Access 2013 Level 2 or equivalent knowledge.
Wed Aug 10 & 17
CIS 718 002Z
Deadline: Aug 3
Excel Level 1 will familiarize you with spreadsheet terminology and the fundamental concepts of Microsoft Excel 2013, including identifying Excel window components, navigating worksheets, and downloading templates. In addition, you will learn the basics of entering and editing text, values, and formulas and saving workbooks in the native Excel format as well as in other formats. You will learn how to move and copy data and formulas; determine absolute and relative references; and work with ranges, rows, and columns. Learn how to use simple functions and easily apply formatting techniques to worksheet data. You will create and modify charts and work with graphics. Finally, you will review workbooks for spelling errors, modify page setup, and print worksheets.
Prerequisite: Windows XP, Vista, 7, or equivalent knowledge.
Tue Jun 14 & 21
CIS 720 004Z
Deadline: Jun 7
Excel Level 2 will teach you how to work with large worksheets in Microsoft Excel 2013 and use multiple worksheets and workbooks efficiently. It will introduce you to more advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks. In addition, you will learn how to create outlines and subtotals and create and apply cell names. You will sort and filter data and create and format tables. Learn how to save workbooks as web pages, insert and edit hyperlinks, and share workbooks via email. Audit worksheets for errors, protect worksheets, share and merge workbooks, and track changes in a workbook. Finally, you will customize the Excel environment and create and modify custom templates.
Prerequisite: Microsoft Excel 2013 Level 1 or equivalent knowledge.
Tue Jul 26 & Aug 2
CIS 721 004Z
8am – 12:30pm
Deadline: Jul 19
In Excel Level 3, build on the skills you acquired in the Microsoft Excel 2013 Basic and Intermediate courses. You will work with advanced functions and formulas as well as search functions such as VLOOKUP, MATCH, and INDEX. In addition, learn about data validation and use advanced data filtering. You will apply advanced chart formatting options and create more complex charts. Work with PivotTables and PivotCharts, export and import data, and query external databases. You’ll learn about the analytical features of Excel, such as Goal Seek, and how to create scenarios. Finally, you will run and record macros.
Prerequisite: Microsoft Excel 2013 Level 2 or equivalent knowledge.
Tue Aug 23 & 30
CIS 722 003Z
8am – 12:30pm
Deadline: Aug 16
Presenting the right information to the right people visually in a way that enables actionable decision making is a major goal when working with data. In this fast-paced, hands-on two-hour workshop discover a variety of techniques that will help you create clear and concise information dashboards. Philip Nyman will help you explore data validation, forms and form controls, lookup functions, and conditional logic. You will be able to create and modify charts, use visual slicers, and create key performance indicators and sparklines. These techniques will help you display the current or historical status of your orga- nization or service.
Prerequisites: Intermediate-level experience working with Excel 2013 tables and functions.
Wed Jun 29
WBT 327 001z
Deadline: Jun 22
xcel PivotTables and PivotCharts are pow- erful, interactive methods for organizing, summarizing, and analyzing data. In this fast-paced, hands-on two-hour workshop you will learn what a pivot table is and what it does with Philip Nyman. You will learn how to create and modify PivotTables; connect to external data sources; add cal- culated fields; and sort, group, and filter data using slicers. By the end of the ses- sion you will be able to create, format, and style PivotCharts (based on a PivotTable) that provide maximum understandability of your data.
Prerequisites: Intermediate experience with Excel 2013, including charting. No previous experience with PivotTables or PivotCharts is required.
WBT 328 001Z
Deadline: Jul 6
Already know a lot about Word but need to become more efficient at using mail merge or just need a refresher? Look no further! Learn from Ginna Moore how to set up form letters and labels with data sources such as Excel and Access. In addition, dis- cover how to use Outlook to perform an email merge and explore the use of rules.
Prerequisite: Microsoft Word Level 1 or equivalent knowledge.
WBT 320 001Z
Deadline: Jun 14