SAVE ALL ASSIGNMENTS AS THERE JOB NUMBER (Job 1, Job …



SAVE ALL ASSIGNMENTS AS THERE JOB NUMBER AND YOUR LAST NAME Example: (Job1 LastName, Job2 LastName, Job3 LastName, etc.)<< You can use any student names to complete the Jobs >>JOB 1 (Word)Create an organizational chart for you company. There are seven major positions at your company:PresidentV.P. of OperationsFood & Beverage ManagerFinance ManagerV.P. of GamingDay ManagerNight ManagerJOB 2 (Word)Complete the Employee List using a table. You must use the amounts in the Pay RateAn example is below.Include the following positions:President YouPayrollV.P. of OperationsMaintenanceV.P. of GamingServiceFood & Bev. ManagerSecurityFinance ManagerOfficeDay ManagerNight ManagerJOB 3 (Excel) EXAMPLE BELOW Calculate the Payroll Sheet to determine weekly pay. << HOURS WORKED PER DAY >>TITLEMONTUEWEDTHUR FRIPresident1213121114VP Operations109987VP Gaming810869Food/Bev Mgr99798Finance Mgr88888Day Mgr1189109Night Mgr1210101110Maintenance99899Payroll881099Security1010111214Service9810910Office891098EXAMPLE:Pay Rate refer to Job 2JOB 4 (PowerPoint) EXAMPLE BELOW You hire new employees all the time. They need an introduction to the company and the various services offered. Create a PowerPoint to be viewed by people that are newly hired. Go to the following categories: Create two slides per topic and include a title slide.Make slides for: Title Casino (2) Resort (2) Dining (2) FOR EXAMPLE: The CASINO menu has 7 menu items. (Located at the bottom in gray)Pick TWO items and create two slidesJOB 5 (Word) EXAMPLE BELOW Create an Ad for a real upcoming event at the Casino.Here’s an example, but you must design your own Click on EntertainmentLook below Events For SaleJOB 6 (Excel) EXAMPLE BELOW Create a spreadsheet for sales in each of the work areas:DAY SHIFT MON TUE WED THU FRIArea 11358712674145081187915745Area 21987520312209932174022768Area 3935472557640835910324Area 42865633652309012957434658NIGHT SHIFTArea 11465211352136951035814569Area 21368519652183242235923695Area 31063987458963974111655Area 42789834699312652865334960EXAMPLECalculate the Totals and Averages per day and for each Area.Answer these questions in your spreadsheet:1. Which Shift had the highest overall Sales?2. What Day had the highest Sales?3. What Day had the lowest Sales?JOB 7 (PowerPoint) BE SURE TO CREATE A “CORRECT & WRONG” SLIDE FOR EACH QUESTION Design a 5 question Test based on (Job 4). We have to make sure our new employees understand what is offered at our company.JOB 8 (Excel)Open Job 3 and calculate the Net Pay for each employee. You will need to SAVE AS Job 8.Include the following deductions before calculating Net Pay:Federal Tax = 4? % of Gross PayState Tax = 3% of Gross PayMedical = 2 % of Gross PayDental = 1? % of Gross PayInclude a column for TOTAL DEDUCTIONS & NET PAYJOB 9 (Word)Create a two-column Brochure (it doesn’t have to look exactly like the sample). Use the information from the following website ; Change the point size to 14 for the column text >>Include 2 pictures per columnCopy/Paste this informationand LEARN MOREClick here and copy/paste into brochureJOB 10 (Excel)Create a spread sheet that calculates how old YOU are based on:Years, Months, Weeks, Days, Hours, Minutes, Seconds*Change the Worksheet name tab to MY BIRTHDAYNow change Sheet 2 to Employee DaysNow calculate the number of days until each employee’s next birthday Calculate this assignment using the Employee Days worksheetVP of Operations 8/04/85VP of Gaming 1/16/88Food/Bev. Mgr. 4/11/86Finance Mgr. 2/27/89Day Mgr. 5/05/87Night Mgr. 12/19/85Maintenance 8/6/72Payroll 4/22/77Security 9/12/82Service 1/17/85Office 3/15/80JOB 11 (PowerPoint)Click on the hyperlink below to view the information for each of the Catering Floor Plans: have complained that it’s too difficult to read. Your job is to design an interactive PowerPoint that will allow customers to click on a room and view the information on a separate slide. (see example below)JOB 12 (Excel)You just received a reservation for a Luncheon. Go to the following website below to find the cost of each meal: a spreadsheet similar to this one:ORDERS:ItemQtyAsian Chicken Salad4Pechanga Caesar Salad8TOTAL = Quantity x PriceCasino Cobb Salad6El Indio36Little Italy41Backyard Barbeque34Ultimate Salad Bar46Rancho Cal33Shanghai Express38The Resort9The Casino12Temecula Torpedo4The Winery3JOB 13 (Excel)Open the File located on the Computer Careers website Job 13Complete each assignment on each Worksheet. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download