Skill and Career Search

I-Assignment objectives 1-Familiarize student with employment management position opportunities 2-Connect skill and knowledge train" rel="nofollow">inin" rel="nofollow">ing in" rel="nofollow">in course work with management position requirements 3-Develop skills in" rel="nofollow">in quantitative data analysis and in" rel="nofollow">interpretation 4-Practice math calculations used for data stratification and decision makin" rel="nofollow">ing 5-Practice construction visual outputs (graphs, charts, etc-) in" rel="nofollow">in presentation format in" rel="nofollow">instructions 1- Access onetcenter database a www-onetcenter-org 2- Access lin" rel="nofollow">ink ONet onlin" rel="nofollow">ine 3- Access 3 data bases and Onet SOC code data base to familiarize yourself with search capabilities a- Fin" rel="nofollow">ind occupations 5 b- Advanced search c- Cross walks 4- Identify 5 marketin" rel="nofollow">ing positions (i-e- marketin" rel="nofollow">ing analyst, marketin" rel="nofollow">ing manager, social media analyst, market researcher, advertisin" rel="nofollow">ing manager, etc-) 5- When searchin" rel="nofollow">ing for marketin" rel="nofollow">ing positions search for in" rel="nofollow">industry sectors that Applied Management majors are qualified for when completin" rel="nofollow">ing BS degree (retail, logistics, distribution, manufacturin" rel="nofollow">ing, health care, bank/fin" rel="nofollow">inance, food service, etc-)- 6- Review each position description- Review 7 areas (tasks, tools and technology, knowledge, skills, abilities, work activities, work context, works styles, and work values) pay rate, projected job openin" rel="nofollow">ings in" rel="nofollow">in the future- Each position has a large amount of in" rel="nofollow">information-review all the in" rel="nofollow">information that pertain" rel="nofollow">ins to the positions you selected- III-Analysis 1-Usin" rel="nofollow">ing Excel to set up a spread sheet file that you will use to analysis data on the 5 positions you selected- a-Set up one spreadsheet file with 7 tabs/worksheetslsheets- b-Each tab will represent the areas of tasks, tools and technology, knowledge, skills, abilities, work activities, work context, work styles, and work values- 2- For each tablworksheetslsheets a-Put the 5 positions in" rel="nofollow">in the columns/vertical axis b-List the top 5 important tasks for each of the 5 positions (then tools and technology sheet, then knowledge sheet, etc-) in" rel="nofollow">in the rows! horizontal axis c-Note that as you list the tasks (then tools and tech, knowledge, etc-) you will have more than 5 tasks (then tools, etc-) on your horizontal access because each position will likely have different tasks (tools, knowledge, etc-)- d-As you in" rel="nofollow">input the data...use 25 poin" rel="nofollow">ints for a skill (then tools, etc) that is ranked highest, 15 poin" rel="nofollow">ints for a skill ranked second, 10 poin" rel="nofollow">ints for third ranked, 5 poin" rel="nofollow">ints for 4th ranked, and 1poin" rel="nofollow">int for 5th ranked- This means that you only record the top 5 skills (then tools, etc-) for each position that you review. The rankin" rel="nofollow">ing on Onet is obvious by the order and the % of respondents rankin" rel="nofollow">ing it first, second, third, etc- 3-Analyze data for each position and for all 5 positions- a-Your spreadsheet (each worksheet) should be set up usin" rel="nofollow">ing formulas that calculate the rankin" rel="nofollow">ing poin" rel="nofollow">ints (so if active listenin" rel="nofollow">ing received 25 . . in" rel="nofollow">ints for one marketin" rel="nofollow">ing position, 10 for another, and then 5 for another (with 2 not havin" rel="nofollow">ing them in" rel="nofollow">in the top 5 at all) then the column total for active