IT 100 Final Project Guidelines and Rubric

Overview

The final project for this course is the creation of a polished business presentation consisting of a formatted and revised business letter, a dynamic spreadsheet,

and a formatted and revised slide presentation.

In the professional environments of today, one of the most important and frequently used tools for communicating information is an office productivity suite

such as Microsoft Office. Office productivity suites consist of bundled applications designed to help users create various deliverables such as word-processing

documents, spreadsheets, and slide presentations. Your ability to select an appropriate application based on key specifications and to use various tools and

functions within the application to create polished professional deliverables will be critical for successful communication and collaboration with clients and

stakeholders in any field you pursue.

In this project, you will take the role of a business analyst and apply essential skills and techniques within office productivity applications to prepare three

related professional deliverables: a business letter, a spreadsheet, and a slide presentation. Review the Final Project Scenario document to learn more about the

simulated business case.

The project is divided into two milestones, which will be submitted at different points throughout the course to scaffold learning and ensure a quality final

submission. These milestones will be submitted in Modules Two and Four. The final submission is due in Module Seven.

In this assignment, you will demonstrate your mastery of the following course outcomes:

 Apply appropriate tools within office productivity applications for supporting the creation of professional-quality documents, spreadsheets, and

presentations

 Integrate key business specifications into a variety of office productivity suite applications for ensuring effective deliverables

 Apply appropriate style and formatting conventions in creating professional documents, spreadsheets, and presentations

 Apply fundamental best practices for revision within office productivity applications for the finalization of a professional-quality document and

presentation

1 

Prompt

As you prepare to communicate the next steps in the consulting partnership between your organization, Business Consultants, and your client, New Hampshire

Business Products (NHBP), you will prepare three deliverables using office productivity applications: a business letter to stakeholders at NHBP to share your

findings and request a follow-up meeting, a spreadsheet that will allow you to organize and manipulate the given sales data with basic calculation functions, and

a slide presentation that will help you communicate your findings to your team at Business Consultants.

Specifically, the following critical elements must be addressed:

I. Business Letter: Apply audience-appropriate formatting and style conventions to a follow-up business letter for New Hampshire Business Products.

Revise and submit the business letter you completed for Milestone One, which was based on the content in this document.

A. Incorporate the business letter content into a business letter template.

B. Apply formatting conventions appropriate for the intended audience.

1. Select a standard and consistent font and font size.

2. Format the document with standard and consistent line spacing, margins, and indentation.

3. Configure the data provided into a table.

C. Apply revisions to the provided draft to produce a document that is clear of typographical and formatting errors.

II. Spreadsheet: Create a spreadsheet that clearly and functionally displays the numerical data provided in the scenario.

A. For current sales, display sales by category and total.

B. For projected sales, display sales by category and total.

C. Apply formatting conventions appropriate for a business audience.

1. Select a consistent font and font size.

2. Format the spreadsheet with row and column spacing, row and column alignments, and cell formatting.

3. Apply labels that identify the values contained in each row and column.

D. Apply formulas to calculate totals for current sales as well as projected sales.

E. Embed a bar chart that accurately displays the total sales for the current year.

F. Embed a bar chart that accurately displays the projected sales for the next five years.

G. Embed a line graph that accurately displays the projected sales growth over the next five years.

III. Slide Presentation: Apply appropriate formatting and revision conventions and visuals to the content on the provided slides to create a presentation

that addresses the needs of the audience within Business Consultants as well as your needs as the speaker preparing to convey the information to a

business audience. Revise and submit the slide presentation you completed in Module Six, which was based on the unformatted slides in this

presentation.

A. Apply consistent slide templates and color schemes that help organize and convey your message.

2 

B. Insert charts and graphs from your spreadsheet into the slide presentation where indicated.

C. For each slide, select a font style and size of text that are appropriate for the specified audience and support your message.

D. Revise the existing slide content to reflect an appropriate amount of text on each slide for conveying your message to the specified audience.

E. Revise excess slide text into speaker notes, shaping them into a tool to support yourself, the speaker, in delivering your message.

F. Incorporate slide transitions and graphics that support the message.

Milestones

Milestone One: Business Letter (Draft of Section I)

In Module Two, you will submit a draft of your formatted and revised business letter. Using Microsoft Word, you will summarize the findings of your initial

meeting with the client and request a follow-up meeting. Formatting and style conventions must be appropriate for the identified audience. This milestone will

be graded with the Milestone One Rubric.

Milestone Two: Spreadsheet (Draft of Section II)

In Module Four, you will submit a draft of your Excel spreadsheet. You will create a spreadsheet that clearly and functionally displays key numerical data about

the client organization, using formatting conventions, labeling, formulas, and style conventions appropriate for the business audience. This milestone will be

graded with the Milestone Two Rubric.

Final Submission: Business Presentation

In Module Seven, you will submit your revised business letter, Excel spreadsheet, and slide presentation. Your submission should be a complete, polished

artifact containing all of the critical elements of the final project. It should reflect the incorporation of feedback gained throughout the course. This submission will be graded with the Final Project Rubric. 

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.