Create manual business documents
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, Access files,
PowerPoint, and integration among the four 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.)
Part 1 – MSWORD – 17% of practical exam grade
1. Company letterhead with logo (you may use clipart or symbols, include
address and phone number)
2. Cover page (Title page for the entire project)
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:
• Research essay writing service – MLA format or any other professional format required by your professor
• 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
• Your report should be 2 to 3 pages
4. Create a placeholder for the Employee Contact Listfrom Accessandthe
Organizational Chartfrom PowerPoint.
5. Print each part of the Word component.
Part 2 – MS ACCESS – 20% of practical exam grade
Create a database for the business/company:
1. Save the database as Employee Data (followed by your name).
2. Create a table in the database with a minimum of 15 employees; save it as
Staff Information (followed by your name). The table will include the following
fields: Employee ID, Last Name, First Name, Department, Address, City, State, Zip
Code, and Phone Number (use AutoNumber for the ID. You can make up the phone
numbers, department, address, etc.)
3. Create a Query listing Last Name, First Name, Department, and Phone Number.
Save the query as Employee Contact List (followed by your name). Export this query
to an appropriate place in the WORD report.
4. Create a second query and save it as Payroll Data (followed by your name);
include the following fields: Last Name, First Name, and Department.
5. Print the Table and Queries.
Part 3 – MS EXCEL – 22% of practical exam grade
Create a spreadsheet by importing/integrating the Payroll Data query from Access.
1. Add the following column headings: Hours, Pay Rate, Gross Pay, Withholding
Taxes, and Net Pay.
2. Calculate Gross Pay, Taxes (the tax rate is 22%), and Net Pay. Pay special
attention to your formulas.
3. 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.
4. Format the spreadsheet attractively. Follow the information on the attached
rubric.
5. Setup the spreadsheet with a header or footer, vertical and horizontal
centering, and print in landscape orientation.
6. Print the spreadsheet, formula sheet, and chart.
Part 4 – MS POWERPOINT – 22% of practical exam grade
Create a PowerPoint Presentation about the business/company:
1. The presentation should have a Title slide with the name of your company,
your name, professor’s name, name of course, and the due date.
2. The presentation should be very concise. (Use bullets/number, not
sentences).
3. Create a slide with the company’s organizational chart. Integrate this
slide in your WORD report.
4. Include slides showing the Employee Data table from Access, and the chart
that you used in the Excel part of the project.
5. Your slides should include graphics (Clip Art, charts, or pictures).
6. There should be 8 to 10 slides.
7. Include slide design, transition, animation, and sound.
8. Print in handouts (multiple slides per sheet).
9. Oral Presentation must be done by each student.
PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET A GOOD DISCOUNT 🙂
