Final Project

Final Project Instructions

The first step is to select an organization. The organization can be a company, a school, or a not-for-profit. Pick an organization that interests you. Our scenario is that you have been hired by this organization to help them develop the following documents and tools:

  1. Brochure
  2. Flyer/Webpage
  3. Spreadsheet
  4. Database
  5. PowerPoint Presentation

 

Brochure (six-panels)

The brochure must be created using Microsoft Word. It will be graded based on both professionalism and creativity. The brochure should be highly informational, easy to understand, and pleasing to the eye. Include information about the organization including (but not limited to) brief history, upcoming events, and contact information. You may use a template to get your brochure started.

 

Flyer or Webpage

Create the flyer or a single webpage using Microsoft Word. It should serve as an announcement for an upcoming event. If the organization does not have any upcoming events, then you may create one for them. The flyer or webpage will also be graded based on both professionalism and creativity. Like the brochure, the flyer or webpage should be highly informational, easy to understand, and pleasing to the eye.

 

Spreadsheet

Using Microsoft Excel, create a spreadsheet that outlines the quarterly budget. Think about all of the revenues and expenses that your organization could have. You must complete the following:

  • At least two charts
  • Use formulas for any cells that are calculated
  • Each quarter’s budget should be on a separate sheet
  • A fifth sheet should show the total budget for the year, using formulas for all calculations. You also must calculate the MIN, MAX, and AVERAGE of the four quarters, including this on the fifth sheet.

NOTE: It is not important that you use actual data from the organization.  You may create the data on your own! What’s important is that you create a professional and functional spreadsheet. 

 

Database

Create an employee database using Access. You should create one table using the following fields:

  • Last name
  • First name
  • Address
  • Phone
  • Salary
  • Position

After creating the table, populate it with the information for 10 employees (you may make up this data). Create two queries of your own choosing, and create one report. The report should use at least one graphic or photograph.

 

PowerPoint

Create a PowerPoint presentation that reviews what you have done for this project. You should have at least five slides. Incorporate clip art and other graphics that are consistent with professional design. In other words, don’t go overboard! Create a presentation that is creative yet professional.

Brochure
20.0 points

– Six panels are included in the design – Text is relevant to the organization /topic – Clipart and/or photos are included – Professional yet creative – Design elements are well arranged on the panels. – Colors, fonts, and graphics are well chosen and placed to support the central message – Free from spelling and grammar errors

0.0 

No Marks

 
Flyer or Webpage
20.0 points

– Text is relevant to the organization /topic – Clipart and/or photos are included – Professional yet creative – Design elements are well arranged on the panels. – Colors, fonts, and graphics are well chosen and placed to support the central message – Free from spelling and grammar error

0.0 

No Marks

 
Spreadsheet
20.0 points

– Two charts are included – Formulas are used for calculated values – Five sheets are used – One sheet for each quarter and a yearly total sheet – At least four revenues and four expenses are included – Free from spelling and grammar errors

0.0 

No Marks

 
Database
20.0 points

– A table is defined for employees – Six fields are included – Data for 10 employees is included – Two queries are included – One report is included – The queries and report function – Free from spelling and grammar errors

0.0 

No Marks

 
PowerPoint
20.0 points

– Five slides are included – Clipart and photos are included – Presentation has professional appearance – Free from spelling and grammar errors

0.0 

No Marks

 

 

 

Last Updated on February 11, 2019 by EssayPro