Project OverviewScenario: You have been tasked with helping to recruit students to Hampton University; specifically you want them to choose your major (i.e. Nursing, Business, Computer Science, etc.). This project will consist of the creation of a spreadsheet (Excel), presentation (PowerPoint), word processing document (Word), and a database (Access).Using Microsoft Word (5 pts)Create a one page flyer that will be posted in high schools around the country that will advertise your major/department:Must include: a Text box w/fill color, a Border, Clipart/Picture, SmartArt, at least 3 Font styles/sizes, Bullets or Numbering, a Table, and various formatting (bold, italics, underlining, etc.)File naming convention: LastNameFirstinitial_WordFlyer.docx (i.e. BrownK_WordFlyer.docx)Using Microsoft Excel (10 pts)Create a spreadsheet that displays the current salary range for at least 5 positions in your career field:List 5 job positions in your career fieldIn separate columns, list the low, median, and high salary range for your 5 job positions (use http://hotjobs.yahoo.com/salaryhttp://hotjobs.yahoo.com/salary or any other salary website)Create a graph (of your choice) that illustrates the low, median, and high salary range for your 5 job positions for a totalInclude a relevant clipart/picture in your spreadsheet Include a shape on your graph to emphasize your ideal position and salary Formulas must be used for all calculations Format all numerical values to currency and 2 decimal placesBold all of the labelsUse at least 2 Fill Colors in spreadsheet (make sure text is lighter than fill color)File naming convention: LastNameFirstinitial_Excel.xlsx (i.e. BrownK_Excel.xlsx)Using Microsoft PowerPoint (5 pts)Create a Presentation to include the following: You will create a minimum of 10 slides that will be shown to prospective students. When you were in your decision state, think about the factors that contributed to you selecting HU? Imagine this presentation being used at high…
Attachments:
