27 Jun Complete Project

Project Description:

You are the recruiter for a company (this could be a company you would like to work for in the

future.) You will research the company and positions within the company that are of interest to

you. Based on your research, create a report in Word that gives thorough information on the

information you find. For example, you could write a report that describes the companys

history/background, structure/organization, departments, products/services, positions/job titles,

employees qualifications, job benefits, or job outlook/trend. Create an Excel workbook based

on data you believe the company would want to compile and perform calculations on.

Information must be relevant to the type of business/industry you choose. Create a PowerPoint

presentation summarizing your Word report and information in your Excel workbook. You will

also be integrating information between these files. 

Part 1 – Microsoft WORD

1. After doing your research on the company, create a Word report that thoroughly and

clearly explains the information you find for example an overview of your company,

background information, employment trends. (You can use the Internet and various job

sites to help in your research.)

Your report should be at least two pages but no more than four pages (before you add

other objects to it).

2. You should format the report (using APA guidelines or format)

a. Type your report. Include placeholders for objects that you will insert/integrate from

Excel. Your report should include at least two Excel objects (ex: chart or

worksheet).

b. Ensure that your paper includes at least two citations to credit sources you quoted

in the report (using APA format for the citations).

c. Your report should have a formatted title.

Page 2 of 3

d. Your name should appear to the left in the footer. The date should appear in the

right of the footer.

3. Save you report using an appropriate filename.

Part 2 Microsoft EXCEL

1. Think of the types of calculations that your company will need to do. Think about what

data will be needed to perform those calculations. Create an Excel workbook with

information that is relative to your Word report. For example, you can create a workbook

showing items ordered, or weekly sales, or weekly services. Make sure to include a

worksheet heading along with appropriate column and row headings.

2. Add the following as a minimum to your workbook:

o The worksheet title should be formatted and merged and centered across the

columns in your worksheet.

o Format all column headings/titles to be Bold and Centered.

o There should be calculations using relative references.

o There should be calculations using absolute references.

o There should be calculations using 5 of these functions: SUM, AVERAGE, MIN,

MAX, COUNT, COUNTA, ROUND.

o Format all monetary values to show appropriately.

o Create at least 2 charts to depict information on your worksheet. Include

appropriate chart titles.

o Attention to detail and design will be considered in scoring.

3. Include your name in the left section of the header and the filename and date in the left

and right sections respectively of the footer. Set the worksheet to vertical and horizontal

centering, and landscape orientation for printing.

4. Save your workbook using an appropriate name of your choice.

Part 3 MS POWERPOINT

Create a PowerPoint Presentation highlighting the information included in your Word document

and Excel workbook (minimum of 8 slides):

1. The presentation should have a title slide with the name of your companys, your name,

name of course, professors name, and the current date.

2. Create slides summarizing the information in your Word Report. The presentation slides

should be very concise highlighting points in your report.

3. Make sure to have a conclusion slide.

4. Integrate at least 1 Excel object into one of your slides.

Page 3 of 3

5. Your slides should include text boxes and pictures.

6. There should be between 8 10 slides.

7. The entire presentation should have a slide design/theme, transitions, animations, and

timings.

8. Save the file using an appropriate file name.