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 Feb 6 & 13, 2014
Deadline: Jan 30
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 Mar 6 & 13, 2014
Deadline: Feb 27
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.
Deadline: Oct 31
Deadline: Mar 27
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 Feb 4 & 11, 2014
Tue Feb 18 & 25, 2014
Deadline: Jan 28
Deadline: Feb 11
Expand on what you learned in Excel Level 1 by applying it to a specific personal or work project. Bring specific questions and examples to the lab for one-on-one assistance.
Prerequisites: Microsoft Excel 2010 Level 1.
Fri Feb 28, 2014
8am – 10am
Deadline: Feb 21
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 Mar 4 & 11, 2014
Tue/Thu Mar 18 & 20, 2014
8am – 12:30pm
Deadline: Feb 25
8am – 12:30pm
Deadline: Mar 11
Discover a deeper understanding and fluidity working in Excel during this practice session. Bring specific questions and examples to the lab for one-on-one assistance.
Prerequisites: Microsoft Excel 2010 Level 2.
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 Apr 1 & 8, 2014
8am – 12:30pm
Deadline: Mar 25
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 Mar 1, 2014
8am - 5pm
Deadline: Feb 21
Build on the skills and concepts taught in PowerPoint 2010 Level 1 with Gina Isabelli. Practice customizing PowerPoint by
modifying the ribbon and changing application settings; applying
themes and templates; working with SmartArt graphics and tables; adding multimedia content and interactive elements to slides; learning about presentation distribution options including
PDF, HTML, and online broadcasts. Finally discover how to integrate PowerPoint with Word and Excel.
Prerequisite: Microsoft PowerPoint 2010 Level 1 or equivalent knowledge.
Review the basic commands and features of Microsoft Project
2010 with Dr. Bo Park. Create and modify task lists;
establish a project schedule; create calendars; assign resources
to tasks; track costs; work with different views and tables; apply
filters and groups; sort task and resource data; and resolve resource
Prerequisite: Windows XP/Vista or equivalent knowledge and an understanding of project management concepts.
Classroom: Sat Mar 29, 2014
Online: Mar 29-Apr 11
Deadline: Mar 22
Build on the concepts and skills you learned in Project 2010 Level 1 with Dr. Bo Park. Work with templates; create
baseline plans; monitor and update projects; analyze project
statistics; handle delays and conflicts; create reports; consolidate
project files; share resources; customize Project; learn to communicate
project information by using Project Server 2010; and
integrate Project data with other Office applications.
Prerequisite: CIS 725 or equivalent knowledge.
Classroom: Sat Apr 26, 2014
Online: Apr 26-May 9
Deadline: Apr 18
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: Fri Dec 6
Online: Dec 6 - 19
Classroom: Sat May 17, 2014
Online: May 17-30
Deadline: Nov 27
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 Feb 20 & 27, 2014
Deadline: Feb 13
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 Mar 3 & 10, 2014
Deadline: Feb 24
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.
Deadline: Nov 26
Deadline: Apr 10