MONROE COLLEGE General Education IT118-Final Project Documents must be completed by APRIL 9 Recording of Oral Presentation must be completed by APRIL 13 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: Identify a company you desire to research and present to your professor and classmates. Imagine you are responsible for representing a company to receive a $100,000 grant. Select ANY company (you could choose one based on your major or one of interest). You may choose your OWN company, but you will still be responsible for all information. Part 1 - LETTERHEAD Create a Company letterhead with logo (you may use clipart or symbols, including address and phone number) - Be Creative (When done, submit to a dropbox for letterhead) Part 2 - MS WORD 1) Type a Research paper about the company. Use the Internet to research information on your type of business. Include In Your Research: Background information about your company (nature of business, international or local business?) . What is the structure of the company (number of employees, departments, job positions, and an organizational chart, etc.)? - try to find as much information as possible What is the company's mission statement, vision statement, what are they passionate about, and projections for the next two years -growth, and product/service expansion?7-) 3) 4) 0 Any new news about the company.r m the media? Good or had Start typing/formatting your information. a) You must format the report using APA guidelines. (doublespaced, 12 font, I inch margins) b) Cover page [Title page for the entire project). This should include project name, the names of each group member, professor's name, name of course, and due date/semester. c) Include placeholders for objects (or empty spaces) that you will insert/integrate from other applications. Your Word report should include Excel objects chart and PowerPoint object organizationalthierarchy chart. (I) A minimum of two sources is required (at least 2 citations} a) Your report should be a minimum of 4 pages, but no more than 10 pages. Save the file. Do not submit in dropbox until you are done with EXCEL and POWERPOINT. After completingpart 2 (Excel) and part 3 (PowerPoint), insert the following: a) Excel Chart* (chart only, not the columns) b) PowerPoint organizational or hierarchy chart. '9' (not a picture, must he a chart created from Poroe rPoi a t) c) Submit the completed 1Word document to dropbox. Part 3 MS EXCEL Create a Spreadsheet (file) and save it as Employee Data which contains the following: 1) 2) 3) 4) Name sheetl as Staff Information. Type the name of the company in cell A1. Create these COLUMNS using the headings: (start in. cett A2) a) Employee ID 13) Employee Name [Last name and first name) c) Position d) Department e) Street f} City g) State h) Zip Code i) Phone Number j) Weekly Hours k) Hourly Pay Rate 1) Weekly Gross Pay m} Withholding Taxes 11) Weekly Net Pay Enter information for 10 (ten) employees. You can make up the datafor each field. Remember, the Employee ID must be unique. 5) Go to cell P], then type Tax Rate. Go to cell Q1 and type 12%. 6) Calculate the following: a) Gross Pay (multiply hours worked by pay rate) b) Withholding Taxes (the tax rate is located in cell Q1) (multiply gross pay by the tax rate; change to absolute as necessary) Pay special attention to yourformutas. c) Weekly Net Pay for each employee. (Net Pay is your take home pay) 7) In cell A13, enter the word Total. Calculate the total for the following columns: Weekly Gross Pay, Withholding Taxes and Weekly Net Pay. 8) Format the following data: a) Center the company name from cell A1 through cell N1, bold it, and change to font size 14. b) Bold all column headings/titles and change to red font. c) Format the following columns as currency. 0 Hourly Pay Rate 0 Weekly Gross Pay 0 Withholding Taxes 0 Weekly Net Pay d) Format cells with "all borders\". 9) Copy this sheet to a new sheet, disglayishow the formulas, and rename the sheet as "Formula Sheet\". Adjust column width, as necessary. 10) Create a column chart to show the employees' net pay. Use the employees' names and weekly net pay in the chart located in the Staff Information sheet. Move the chart on a new sheet and name it NetPay Chart. Change the chart title to Weekly Net Pay. 11) Format the spreadsheet: a) with a footer (type your name in the center and date on the right side) b) change layout orientation to landscape 12) Save your file. 13) Submit the Employee Data spreadsheet to the Drop box. 14) Export the column chart to appropriate place in the Word report.* Part 4 MS POWERPOINT Create a PowerPoint presentation highlighting your projectbusiness/company: 1. 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. 2. The presentation should be very concise. (Use bulletsumbers, no sentences). 3. Create a slide with the company's organization chart (hierarchy) at least 3 levels showing the employee names and position. 4. Include the chart (from Excel) 5. Your slides should include graphics (Onliue pictures) 6. There should be 8 to 10 Slides. 7. You must include slide a. design theme b. transitions c. animations (graphics) d. sound