ITCS 1400 - Micros in Business

Prerequisite: ITCS-1010

Objectives: Students will:

1. Demonstrate a working knowledge of the skill standards focused on Productivity Tools including templates, themes, and mail merge.
2. Demonstrate a working knowledge of Desktop Publishing.
3. Demonstrate a working knowledge of forms, document security, and macros.
4. Demonstrate a working knowledge of Word and the Internet including Web pages, XML, and Blogs.

Outcome 2: Upon completion of this course, the student will have a working knowledge of Microsoft Office Specialist Expert Certification Skill Sets for Microsoft Excel.

Objectives: Students will:

1. Demonstrate a working knowledge of converting data to information using data tables, conditional formatting, PivotTables, and PivotCharts.
2. Demonstrate a working knowledge of data tables and amortization tables.
3. Demonstrate a working knowledge of data consolidation, links, formula auditing.
4. Demonstrate a working knowledge of What-If Analysis (goal seek, solver, scenario manager).
5. Demonstrate a working knowledge of collaboration and workbook distribution.
6. Demonstrate a working knowledge of templates, styles, the Web, and macros.

Outcome 3: Upon completion of this course, the student will have a working knowledge of Microsoft Office Specialist Expert Certification Skill Sets for Microsoft Access.

Objectives: Students will:

1. Demonstrate a working knowledge of Data Mining (PivotTables, and PivotCharts).
2. Demonstrate a working knowledge of Data Protection (Integrity, validation, and reliability).
3. Demonstrate a working knowledge of Advanced Queries.
4. Demonstrate a working knowledge of managing a database (bulletproofing the Database, as well as table and switchboard design.

Outcome 4: Upon completion of this course, the student will have a working knowledge of Microsoft Office Specialist, Specialist Certification Skill Sets for Microsoft PowerPoint.

Objectives: Students will:

1. Demonstrate a working knowledge of how to create charts and graphs working with text and statistical charts/graphs.
2. Demonstrate a working knowledge of presentation customization, collaboration, management, and delivery.

1. Microsoft Office Specialist Expert Level Skills for Microsoft Word
   1. Formatting Content
   2. Organizing Content
   3. Formatting Documents
   4. Collaborating
   5. Customizing Word
2. Microsoft Office Specialist Expert Level Skills for Microsoft Excel
   1. Organizing and Analyzing Data
   2. Formatting Data and Content
   3. Collaborating
   4. Managing Data and Workbooks
   5. Customizing Excel
3. Microsoft Office Specialist Expert Level Skills for Microsoft Access
   1. Structuring Databases
   2. Entering Data
   3. Organizing Data
   4. Managing Databases
4. Microsoft Office Specialist Expert Level Skills for Microsoft PowerPoint
   1. Creating Content
   2. Formatting Content
   3. Collaborating