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 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 3 & 10
CIS 716 003Z
Deadline: Aug 27
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 Oct 1 & 8
CIS 717 003Z
Deadline: Sep 24
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.
Thu Nov 5 & 12
CIS 718 003Z
Deadline: Oct 29
Review the basic functions and features of Excel 2013 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; and 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 SmartArt Graphics. Prerequisite: Windows XP/Vista/7 or equivalent knowledge.
Deadline: Aug 25
Deadline: Aug 25
Build on the skills and concepts you learned in Excel 2013 Level 1. Wendy Barker will teach you to use multiple worksheets
and workbooks efficiently; view and print large workbooks as well protect, share, and save workbooks for distribution. Acquire the skills to format, analyze, and manipulate data in a table including sorting and creating custom and advanced filters and using the lookup functions VLOOKUP, HLOOKUP, MATCH, INDEX, and DGET. Learn how to automate worksheet tasks by creating and editing macros and practice advanced charting techniques using trendlines and sparklines. Finally, generate a scenario summary using what-if-analysis, goal seek , and run solver, and explore the Analysis Toolpak.
Prerequisite: Microsoft Excel 2013 Level 1 or equivalent knowledge.
Tue Oct 6 & 13
CIS 721 004Z
8am – 12:30pm
Deadline: Sep 29
Extend the skills and concepts you acquired in Excel 2013 Level 2 with Wendy Barker. Practice logical functions (if, and, or) as well as sum if and sum ifs functions and work with text and date functions. Plan and design a PivotTable and create a PivotChart. Learn to import text files and database tables, embed and link an excel speadsheet into Word, and link an excel spreadsheet to a PowerPoint slide. Track revisions in a shared workbook and merge workbooks together. Customize toolbars in Excel, work with cell comments, and create and use templates. Also, use charts to create professional looking dashboards for presentations.
Prerequisite: Microsoft Excel 2013 Level 2 or equivalent knowledge.
Tue Nov 3 & 10
CIS 722 003Z
8am – 12:30pm
Deadline: Oct 27
Review the basic functions and features of PowerPoint 2013 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.
Review the basic functions and features of Word 2013 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.
CIS 729 003Z
Deadline: Sep 8
Wendy Barker will show you how to 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 2013 Level 1 or equivalent knowledge.
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 with Wendy Barker.
Prerequisite: Microsoft Word 2013 Level 2 or equivalent knowledge.