Project Assignment
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 company's 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 I: Microsoft WORD
• 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.)
Part II: Microsoft EXCEL
• 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.
• Add the following as a minimum to your workbook:
1. The worksheet title should be formatted and merged and centered across the columns in your worksheet.
2. Format all column headings/titles to be Bold and Centered.
3. There should be calculations using relative references.
4. There should be calculations using absolute references.
5. There should be calculations using 5 of these functions: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, ROUND.
6. Format all monetary values to show appropriately.
7. Create at least 2 charts to depict information on your worksheet. Include appropriate chart titles.
8. Attention to detail and design will be considered in scoring.
• 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.
Part 3 - MS POWERPOINT
Create a PowerPoint Presentation highlighting the information included in your Word document and Excel workbook (minimum of 8 slides):
• The presentation should have a title slide with the name of your company's, your name; name of course, professor's name, and the current date.
• Create slides summarizing the information in your Word Report. The presentation slides should be very concise highlighting points in your report.
• Make sure to have a conclusion slide.
• Integrate at least 1 Excel object into one of your slides.
Format your assignment according to the give formatting requirements:
1. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the course title, the student's name, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.