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 Feb 4 & 11
CIS 716 001Z
Deadline: Jan 28
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 Mar 3 & 10
CIS 717 001Z
Deadline: Feb 25
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 Apr 7 & 14
CIS 718 001Z
Deadline: Mar 31
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.
Deadline: Jan 26
Deadline: Jan 26
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.
8am – 12:30pm
Deadline: Feb 23
Deadline: Feb 23
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.
Tue Apr 12 & 19
CIS 722 001Z
8am – 12:30pm
Deadline: Apr 5
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 001Z
Deadline: Feb 9