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.
Based on multidisciplinary backgrounds in Project Management, Engineering and Construction, DR. BO PARK has worked for more than 15 years in the data-driven decision making area using computer simulation, optimization and modeling techniques to enhance professional decision processes and outcomes. He has published more than 20 refereed articles in these areas and taught several related courses at various institutions for more than 10 years. His work was recognized in 2003 as the best paper in the 3rd International Conference on Information Systems in Engineering and Construction. He received a Ph. D. in Environmental Design and Planning at Virginia Tech in 2002 and is currently Associate Professor in the Department of Technology at Illinois State University.
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 Jun 5 & 12, 2014
Deadline: May 29
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 Jul 10 & 17, 2014
Deadline: Jul 2
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 Aug 7 & 14, 2014
Deadline: Jul 31
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 Jun 10 & 17, 2014
Deadline: Jun 3
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 Jun 24 & Jul 1, 2014
8am – 12:30pm
Deadline: Jun 17
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.
Tue Jul 8 & 15, 2014
8am – 12:30pm
Deadline: Jul 1
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.
Mon/Wed Jul 21 & 23, 2014
8am – 12pm
Deadline: Jul 14
Create and develop a realistic project plan and schedule by incorporating internal and external project risks. Discover, with Dr. Bo Park, how to quantify your project's risks and determine key factors in scheduling. Learn how to produce contingency plans and risk mitigation strategies effectively with enhanced confidence using industry risk-management software.
Prerequisite: CIS 726 or equivalent knowledge
Classroom: Sat May 17, 2014
Online: May 17-30
Deadline: May 9
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 Jun 19 & 26, 2014
Deadline: Jun 12
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.
Mon Jul 7 & 14, 2014
Deadline: Jun 30
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.
Mon/Wed Aug 4 & 6, 2014
Deadline: Jul 28