Association of Information Technology Professionals
Region 3 Student Conference hosted by
Amarillo College
andOklahoma Panhandle State University

AITP Region 3 Student Conference

Building a Future in Information Technology

Microsoft (MS) Office Solutions

Summary/Overview

The MS Office Solutions competition will allow teams of one to two students to utilize their MS Office skills and apply them to a real business problem within an approximate three hour time frame.

Contestants will be given a problem statement and data for analysis and problem solving. From this, they will be required to develop a recommendation and solution. The results of their analysis, the supporting documentation, the recommendation, and solution are to be put together so they are suitable for presentation to the President of any Fortune 500 company. MS Access and MS Excel will be used to gather and analyze data for creation of spreadsheets and databases, MS PowerPoint will be used to produce presentations and recommendations, and MS Word will be used to produce documents and reports. Teams will be expected to be skilled in the core programs of MS Office 2010 or 2013 including Access, Excel, PowerPoint, and Word.

Team Composition

Teams for this contest can consist of 1-2 Students. Each member can bring your own computer(BYOC).

Schedule

This contest will take place on Friday, October 21, 2016 from 12:00 ‐ 3:00 PM

Recommended Skills

MS Excel: Create spreadsheets that display data in various tabular and visual formats. The recommended required skills include, but are not limited to: Export external data lists, Pivot Tables, Charts, Scenario Manager, Solver, Conditional Formatting, Subtotals, Sorting, Macros and Buttons, Validation.

MS Power Point: Create multimedia presentations to display information in a graphical format. The recommended required skills include, but are not limited to: Template Presentations, Slide Master, Summary Slide, Insert Charts, Tables, Clipart, Pictures and Drawings, Backgrounds.

MS Access: Create databases that store information that can be manipulated, sorted, and filtered to meet your specific needs. The recommended required skills include, but are not limited to: Import/Export external Data, Table creation and Data Queries (Criteria, Calculated Fields, Summarization, Sorting, etc.), Relationships, Reports.

MS Word: Create documents and reports to display data as meaningful information. The recommended required skills include, but are not limited to: File management and layout, Macros, Merges, Tables and Diagrams, Templates.

Contest Page