Project Description:
You are hired to manage a business office. Your first project on the job is to create a
manual of business documents. The manual will provide
basic samples of documents used in the business.
The company uses Microsoft Office in the business. Your project will include samples of Word documents, Excel files, PowerPoint and integration among these three applications.
Pre-Planning Activities:
Determine the type of business enterprise where you would like to work. Determine what the specialty is for this business. Be very specific – (Insurance, Marketing, Medical, Accounting, Law, Automobile, Computer, Criminal Justice, or as it relates to your major, etc.) Y
ou may make up your own business.
Part 1 - MS WORD – 34% of practical exam grade
- Company letterhead with logo (you may use clipart or symbols, include address and phone number)
- Cover page (Title page for the entire project). This should include project name, the names of each group member, instructor’s name, name of course, and due date/semester.
3.
Research paper about the company. Use the Internet to research information on your type of business. You will consider the following for the report:
·
You must format the report using APA guidelines.
·
Background information about your company
·
Structure of company (number of employees, departments, job positions, and an organizational chart, etc.)
·
Company’s mission statement, and projections for the next two years—growth, and product/service expansion
·
A minimum of two sources is required (at least 2 citations)
·
Your report should be a minimum of two pages, but no more than four pages.
- Include placeholders for objects that you will insert/integrate from other applications. Your Word report should include
Excel
objects—chart and/or worksheet data;
Power Point
object—slide with
organizational chart.
- Submit the completed
Word document
to the Drop box.
Part 2 – MS EXCEL - 33% of practical exam grade
Create a spreadsheet
called
Employee Data
which contains the following:
1. Information for 10 to 15 employees; name the sheet
Staff Information.
2. The worksheet should include the following columns:
Employee ID, Last Name, First Name, Department, Address, City, State, Zip Code, and Phone
Number
. You can make up the data for each field. Remember, the Employee ID must be unique.
- Add the following column headings:
Hours, Pay Rate, Gross Pay, Withholding Taxes,
and
Net Pay
.
- Calculate Gross Pay, Taxes (the tax rate is
12%), and Net Pay.
Pay special attention to your formulas.
- Create a pie or column chart to show the employees’ net pay. Use the employees’ names and Net Pay in the chart.
Place the chart on a chart sheet by itself,
name it
NetPay Chart
.
- Format the spreadsheet and chart to look professional; save the file.
(Follow information on the rubric)
.
Pay attention to detail and design, which will be considered in scoring
.
- Make sure that you include a
Total row
and a
Total column
on your spreadsheet.
- Export the Spreadsheet or Chart to appropriate places in the
Word report.
Format the spreadsheet with a header or footer, vertical and horizontal centering, and print in landscape orientation.
- Submit the
Employee Data
spreadsheet to the Drop box.
Part 3 – MS POWERPOINT – 33% of practical exam grade
Create a PowerPoint presentation highlighting your project--business/company:
- The presentation should have a
Title slide
with the name of your company, (logo is optional), your name, professor’s name, name of course, and the due date.
- The presentation should be very concise. (Use bullets/numbers,
no
sentences).
- Create a slide with the company’s organization chart. Integrate this slide in your
Word report.
- Include slides showing a portion of the
Employee Data, and the chart that you used in the Excel part of the project.
- Your slides should include graphics (Online pictures, the chart that you used in the Excel part of the project).
- There should be
8 to 10 slides.