Posted: January 17th, 2023

Create manual business documents

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 🙂

Order | Check Discount

Tags: Assessment Homework Help Online, Australia essays, Best Ideas for Research Paper Topics in, Best Research Paper Topics for Examples, Dissertation Help App