INFO 2948 - Office Professional Capstone

5.0 Credits

This course allows students to apply all skills and knowledge gained from previous office technology courses. Students focus on advanced-level usage of the Microsoft Office Suite to work independently and in teams on tasks common in a business environment. Students prioritize and manage project tasks; research ideas; and find information to make informed decisions, problem solve, and develop critical-thinking skills. Students also practice their presentation and leadership skills by creating and delivering presentations. Students must have extensive MS Office experience and should take this course toward the end of their program. This course is offered Fall and Spring quarters.

Prerequisites: (2) Instructor approval, INFO 1001

Lecture Hours: 5.0
Lab Hours: 0.0
Internship Hours: 0.0
Clinical or Practicum Hours: 0.0

Course Objectives

Create and correctly format a variety of business documents using MS Word software. This includes letters, memorandums, agendas, tables, reports, invitations, labels and envelopes, mail merge documents, and specialized forms. Enhance document design through the use of styles, charts, tables, graphics, headers and footers, and SmartArt.
Create and edit slide shows to run manually and automatically using the MS PowerPoint presentation software. Enhance slide presentations using the following features: SmartArt, hyperlinks, charts and graphs, tables, images, animation, sound effects, transitions, and linking and embedding.
Construct and modify publications using MS Publisher. This includes creating and formatting a newsletter; using a template to create a postcard; applying a color and font scheme; inserting a Building Block, Design Accent, and images; and inserting business information.
Build and edit worksheets and workbooks using MS Excel spreadsheet software. This includes entering and editing data; using formulas and functions; filtering and sorting data; formatting cell data, columns and rows; adding and deleting columns and records; creating and formatting charts; inserting footers and hyperlinks; and creating PivotTable and PivotChart reports.
Create and edit MS Access databases. This includes adding, updating, filtering and sorting records; creating and running queries; creating and modifying reports; editing data field definitions; creating forms using Wizards, using mail merge to create mailing envelopes; and creating relationships.
Compose original text and edit information using the MS Office applications or online templates, reference tools, and grammar checkers.
Prepare and manage document storage on personal computer and OneDrive for Business including creating zipped files, sending files as e-mail attachments and sharing files via OneDrive link.
Integrate data between the MS Office Access, Excel, PowerPoint, Publisher, and Word applications.
Access the Internet and use the browse, search, and hyperlink capabilities of Web browsers to research topics.
Demonstrate effective task management techniques to track project tasks.

View Class Schedule