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 2010 with Wanda Plawer. After an introduction to database concepts, the Access environment, and Help systems, you ll 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 Sep 4 & 11, 2014
Deadline: Aug 28
Build on the skills and concepts you learned in Access 2010 Level 1 with Wanda Plawer. Discover how to normalize data,
manage table relationships, and enforce referential integrity; 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 PivotChart.
Prerequisite: Microsoft Access 2010 Level 1 or equivalent knowledge.
Thu Oct 2 & 9, 2014
Deadline: Sep 29
Extend the skills and concepts you acquired in Access 2010 Level 2 with Wanda Plawer. 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 2010 Level 2 or equivalent knowledge.
Thu Nov 6 & 13, 2014
Deadline: Oct 30
Discover how to use Adobe Acrobat XI Pro to accss and manage information in PDF files. Learn how to add features like navigation and security, how to create an interactive form from a simple document, and many ways to share and control PDF documents with Paul Young. Book is available for $30 at Business Training.
Fri Sep 12 & 19, 2014
Deadline: Sep 5
Review the basic functions and features of Excel 2010 with Wendy Barker. After an introduction to spreadsheet terminology and Excel's window components, learn how to use the Help system and navigate worksheets and workbooks; enter and edit text, values, formulas, and pictures; save workbooks in various formats; move and copy data; learn about absolute and relative references; and work with ranges, rows, and columns; cover simple functions, basic formatting techniques, and printing; create and modify charts; and manage large workbooks. Prerequisite: Windows XP/Vista/7 or equivalent knowledge.
Tue Sep 9 & 16, 2014
Tue Sep 23 & 30, 2014
Deadline: Sep 2
Deadline: Sep 16
Build on the skills and concepts you learned in Excel 2010 Level 1. Wendy Barker will teach you to use multiple worksheets
and workbooks efficiently; work with advanced formatting
options including styles, themes, and backgrounds; create
outlines and subtotals; create and apply cell names; work with
tables; save workbooks as web pages; insert and edit hyperlinks;
share workbooks by email; practice advanced charting techniques
using trendlines and sparklines; worksheet auditing and
protection; file sharing and merging; and creating workbook
Prerequisite: Microsoft Excel 2010 Level 1 or equivalent knowledge.
Tue Oct 7 & 14, 2014
Tue Oct 21 & 28, 2014
8am – 12:30pm
Deadline: Sep 30
8am – 12:30pm
Deadline: Oct 14
Extend the skills and concepts you acquired in Excel 2010 Level 2 with Wendy Barker. Practice advanced formulas and lookup functions such as VLOOKUP, HLOOKUP, IF, SUMIF, SUMIFS, MATCH, and INDEX. Learn about data validation and database functions such as DSUM. Also discover how to work with PivotTables and PivotCharts, import and export data, and query external databases; analytical features of Excel such as Goal Seek and Solver, running and recording macros, SmartArt graphics, and conditional formation with graphics.
Prerequisite: Microsoft Excel 2010 Level 2 or equivalent knowledge.
Mon Nov 3 & 10, 2014
8am – 12:30pm
Deadline: Oct 27
Review the basic functions and features of PowerPoint 2010 with Gina Isabelli. After an introduction to PowerPoint's window components and Help system, learn to create, save, and rearrange presentations. Discover how to format text; use drawing
objects; work with graphics; insert tables and charts; use templates
and themes, slide masters, and transition effects; and how to proof, run, and print presentations.
Prerequisite: Windows XP/Vista or equivalent knowledge.
Sat Oct 11, 2014
8am – 5pm
Deadline: Oct 4
Review the basic functions and features of Word 2010 with Wendy Barker. After an introduction to Word's window components, learn how to use the Help system and navigate documents. Practice entering and editing text; creating and saving documents; enhancing the appearance of a document by using various formatting options; creating tables; inserting headers and footers; proofing and printing documents; and inserting graphics.
Prerequisite: Windows XP./Vista/7 or equivalent knowledge.
Thu Sep 18 & 25, 2014
Deadline: Sep 11
Build on the skills and concepts you learned in Word 2010 Level 1 with Wendy Barker. Work with styles, sections, and columns and use the Navigation pane to work with outlines. Format tables; print labels and envelopes; work with graphics; use document templates; manage document revisions; and work with web features.
Prerequisite: Microsoft Word 2010 Level 1 or equivalent knowledge.
Thu Oct 16 & 23, 2014
Deadline: Oct 9
Extend the skills and concepts you acquired in Word 2010 Level 2 with Wendy Barker. Perform mail merges; create and use forms and master documents that include a table of contents, a table of figures, footnotes, endnotes, index, bookmarks, cross-references, and web frames; create macros; customize the ribbon and Quick Access tool bar; and work with XML documents.
Prerequisite: Microsoft Word 2010 Level 2 or equivalent knowledge.
Wed Nov 5 & 12, 2014
Deadline: Oct 29