Desktop Applications
|
![]() |
| Quick Links: | |
|
|
|
|
Access 2010 Level 1 |
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 will 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.
Tue/Thu Jun 4 & 6 CIS 716-002Z |
8am – 12:30pm Deadline May 28 |
Access 2010 Level 2 |
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.
Tue/Thu Jul 9 & 11 CIS 717-002Z |
8am – 12:30pm Deadline: Jul 2 |
Access 2010 Level 3 |
Extend the skills and concepts you acquired in Access 2010 Level 2 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
and properties.
Prerequisite: Microsoft Access 2010 Level 2 or equivalent knowledge.
Tue/Thu Aug 6 & 8 CIS 718-002Z Fee: $165 |
8am-12:30pm Deadline: Jul 30 |
Excel 2010 Level 1 |
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/Thu Jun 11 & 13 CIS 720-004Z Fee: $165 |
8am – 12:30pm Deadline: Jun 4 |
Excel Level 1 Practice Lab |
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.
Coming Soon! |
|
Excel 2010 Level 2 |
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
templates.
Prerequisite: Microsoft Excel 2010 Level 1 or equivalent knowledge.
Tue/Thu Jun 25 & 27 CIS 721-003Z
|
8am – 12:30pm Deadline: Jun 18
|
Excel Level 2 Practice Lab |
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.
Coming Soon! |
|
Excel 2010 Level 3 |
Extend the skills and concepts you acquired in Excel 2010 Level 2 with Wendy Barker. Practice advanced formulas and lookup functions such as VLOOKUP, 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 16 & 23 CIS 722-001Z Fee: $165
Tue/Thu Jul 30 & Aug 1 CIS 722-002Z Fee: $165 |
8am-12:30pm Deadline: Apr 9
8am-12:30pm Deadline: Jul 23
|
PowerPoint 2010 Level 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 15 & 17 Fee: $165 |
8am - 5pm Deadline: Jul 8 |
PowerPoint 2010 Level 2 |
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.
Coming Soon! |
|
Project 2010 Level 1 |
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
conflicts.
Prerequisite: Windows XP/Vista or equivalent knowledge and an understanding of project management concepts.
Coming Soon! Classroom: Online: CIS 725 Fee:$229 |
|
Project 2010 Level 2 |
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: Thu Mar 28 Online: Thu Mar 28-Apr 11 CIS 726-002HZ Fee:$229
Classroom: Fri Jun 14 Online: Jun 14-27 CIS 726-003HZ Fee:$229
|
1 - 5:30pm Deadline: Mar 21
12:30 - 5pm Deadline: Jun 7
|
Project 2010 Level 3 |
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 contigency plans and risk mitigation strategies effectively with enhanced confidence using industry risk-managment software.
Prerequisite: CIS 726 or equivalent knowledge.
Classroom: Wed Aug 14 Online: Aug 14-27 CIS 701-001HZ Fee:$229
|
12:30 - 5pm Deadline: Aug 7
|
Word 2010 Level 1 |
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.
Tue/Thu Jun 18 & 20 |
8am-12:30pm Deadline: Jun 11 |
Word 2010 Level 2 |
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/Wed Jul 8 & 10 CIS 730-002Z Fee: $165 |
8am-12:30pm Deadline: Jul 1 |
Word 2010 Level 3 |
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.
Tue/Thu Aug 13 & 15 CIS 731-002Z Fee: $165 |
8am-12:30pm Deadline: Aug 6 |