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.
Thu Oct 6 & 13
CIS 716 003Z
Deadline: Sep 29
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.
Thu Nov 3 & 10
CIS 717 003Z
Deadline: Oct 27
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.
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.
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.
Oct 4 & 11
CIS 721 005Z
8am – 12:30pm
Deadline: Sep 27
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.
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 organization or service.
Prerequisites: Intermediate-level experience working with Excel 2013 tables and functions.
Wed Oct 19
WBT 327 002z
Deadline: Oct 12
Excel PivotTables and PivotCharts are powerful, 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 002Z
Deadline: Oct 19
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, discover how to use Outlook to perform an email merge and explore the use of rules.
Prerequisite: Microsoft Word Level 1 or equivalent knowledge.
WBT 307 002Z
Deadline: Oct 26