Step 1: Import and Clean Up Text FileDownload starting student Excel file and the text file. Open the starting Excel file and navigate to Sheet1.Import the text file by using the Get External Data function on the Data Ribbon. When the Text Import Wizard displays, select My Data has headers and use a comma delimiter to organize the data.Insert a new column in between A and B and use the Text to Columns command to separate first and last name. Be sure to revise or add appropriate column names.Insert a column to the right of the HOME ADDRESS column and use a function to capitalize just the first letter in the address names. Then hide the original Address column.Insert two new columns in between City State Zip and the Unit column, and then use Text to Columns to separate these fields. Adjust column widths appropriately.On the right of the Agent column, add a column and use the Substitute function to replace "JG" with "Jesse Gonzales," and then hide the original Agent column and display the full name.Add statistics to add up all sales, and then apply a 7% commission to calculate the Gonzales commission.Change the sheet name to Gonzales.Under Page Layout, select Themes and choose a business-like theme and possibly a color combination to apply professional formatting and column widths to all of this data using the image below as a guide. Using the Gonzales sales data, create a Pivot Table showing his total sales by development. Format appropriately. Step 2: Create the Macro in the X Games Ticket CalculatorIn this section, we will actually build a macro. A macro is simply a recording of every keystroke you perform while the Macro Recorder is turned on. You are quite simply automating keystrokes and building efficiency into your Excel file.Select the X Game Calc sheet.In order to have the Macro Tools available to you, you must have the Developer Tools. If you do not see the Developer Tab, click the File and select Options.Locate the Developer checkbox option in the Custom Ribbon tab in the Options menu, make sure it is checked, and then click OK.DeveloperYou will need to set the Macro Security level in order to develop Macro code. From the Developer Tab, click on Macro Security in the Code group. Check the Enable all macros and then click OK.Enable All MacrosRemember, a macro records every keystroke you perform while the Macro Recorder is turned on. For this Macro, we will clear the values from the ticket type and ticket quantity cells in our X Game Calculator sheet. We will turn on the Macro Recorder, delete the data in Cells E4 and E6, and then turn the Macro Recorder off.Click the Record Macro button from the Developer Tab, Code group. The Macro Recorder dialog window will open.Macro Name: Provide a user-friendly name for this recording such as CalcWipe. Note: Do not use spaces in the name.Shortcut key: Designate a shortcut key the user can press to start the macro. Try using the letter w as your shortcut key. Note: Avoid using a shortcut commonly used in Windows applications, such as CTRL-C or CTRL-P. The macro shortcut will overwrite the Windows shortcut and your users will not understand why the key combination is not copying or pasting.Store: Store the macro in this Workbook. Note: It can be stored in the Personal Macro Workbook so it can be used by other applications. Macros for common actions such as printing a workbook can be stored in the personal workbook, but they will only be available on the computer on which they are stored.Description: Provide an explanation of the functionality of the macro. Use something such as Clear input cells for X Game Calculator. See image below.Record MacroWhen you click OK, the Macro Recording begins. Select Cell E4, press the Delete key, and then select Cell E6 and press the Delete key.Then turn the Macro Recorder off by clicking the Stop Recording button from the Macro group.Step 3: View the Macro and Assign a Macro Button in the X Games Calculator SheetBehind the scenes, Excel has written a little Visual Basic for Applications (VBA) program, which you may access by clicking the Macros command. Select the Macro you just created, and then click the Edit buttonMacro NameVBA will open with your code.VBA CodeTranscriptIn later courses, you may learn more about programming; however, you can follow the code and see how it instructs Excel to select a range and clear its contents. Click the X in the top-right corner of this MS VBA screen to close macro editing and return to the Excel file.Begin to add a macro button to make it easy for users to run this code. Add a Button Shape to your application using the Insert Tab, Shapes.Add a Button ShapeDraw the shape onto the application, using your mouse or drawing tool.Draw the ShapeAdd a text description to the button: "Clear calculator values!"Associate this button with the macro. Right-click on the shape and select Assign Macro from the menu.Associate Button With MacroSelect CalcWipe and click OK to assign the macro to the buttonTo prepare to test the macro, provide input into cells E4 and E6 by selecting a ticket type in cell E4 and enter a quantity in cell E6 for starting values. Then test your macro by simply clicking the button. Did it clear the contents of your input cells? If yes, congratulations on creating your first macro. If no, please return to Step 2, Part E to build the macro again.Step 4: Save the Macro-Enabled File and Turn on Protection in the X Games Calculator SheetYou will need to save this file as a macro-enabled workbook. Click the File tab and select Save As.Select Excel Macro-Enabled Workbook, which is also the .xlsm file type.By default, all cells in a worksheet are locked. This means that when the worksheet is protected, the users will not be able to enter or change data in those cells. We will protect the worksheet, but first we must unlock the user input cells. Select cells E4 and E6. Right-click and select Format Cells from the menu. In the Protection tab, uncheck the box labeled Locked.Protect the worksheet. From the Home Menu Cells group, select Format, Protection, Protect sheet. DO NOT add a password. Protect SheetRemember to save the file as an .xlsm (Macro-enabled) file. Step 5: Create a Documentation Sheet and Apply a Footer With Watermark Ski ImageClean up the formatting of your Excel workbook, taking into account professional appearance. The Minimum Requirement (per the Grading Rubric) Insert a new sheet into the workbook, name it Documentation, and move it to be the first sheet.As always, properly document all contents of the workbook on this sheet including names and brief descriptions of each sheet.Apply a business such as formatting to all of these cells.Create a watermark footer containing an experts-only ski image by first searching the Internet for an appropriate free image and save it. Use something such as the following.Experts OnlySelect Page Layout and then open the Page Setup window.Page LayoutSelect Custom Footer and then use the icon on the right side to insert the image saved above into the Center section of the Footer.Once the &[Picture] is displayed in the Center section, the Format Picture icon on the far right will be available. Click it.In the Format Picture pop-up window, select the Picture tabUnder the Image control section, select the drop-down option by Color and select Washout, and then click OK to accept it. Click Print Preview on the Page Setup window to view the results!Print Preview TranscriptIMPORTANT: Remember to save this file as a Macro-enabled workbook.Step 6: Summarize and Write MemoReturn to the worksheet named Gonzales. The analysis on this worksheet needs to be summarized in a short memo. Here are some details and ideas about the memo to be written.The memo should be written to Jesse Gonzales. Your name should also be in the From portion of the memo. Include a summary of the analysis completed.Possible thoughts to include: target sales for new fiscal period, sales for new developments, sharing expertise with others in sales, and a thank you for good work. The memo needs to be written professionally and placed on the last sheet in the workbook. Name the last worksheet Memo. Finish and SubmitSave your Excel file as a Macro-enabled workbook!! Your Excel file should contain four worksheets.DocumentationGonzalesX Games CalcMemoSubmit one Macro-enabled Excel file. When submitting the file, provide a comment in the comments area explaining what you learned from completing this lab activity. File naming convention: If your name is Jane Doe, then your file should be named very similar to Doe_J_Week7Lab.xlsm.PreviousNext

Instructions: Select a small (not a national brand or company) website. Create a 10- to 12-slide Microsoft® PowerPoint® presentation with speaker's notes. The presentation must include the following: SEO audit Analysis of both on-site and off-site optimization of the website Evaluation of the links found throughout the site Listing of at least 10 keywords that the site is using for optimization A minimum of at least 3 suggestions to improve SEO rankings Write a 350-word reflection on your presentation.

Assignment 2: Business Expansion and Sustainability Worth 280 points In order to complete this assignment, refer to the scenario that you chose in Assignment 1. Note: You may create and / or make all necessary assumptions needed for the completion of these assignments. Using the scenario from Assignment 1, seven (7) page paper in which you: Identify three (3) job requirements (e.g., needed certifications, previous work experience, external influences, etc.) that could apply to your chosen scenario. Determine two (2) ways these requirements could impact staffing at your organization. Next, suggest one (1) strategy that you could utilize to ensure that all applicants meet the identified job requirements for your organization. Justify your response. Outline a long-term recruitment plan that contains at least four (4) components, is aligned with your company’s recruitment strategy, but also addresses possible job skill or credential shortages. Note: Consider concepts such as succession planning and hiring retirees. Describe three (3) branding strategies that you would employ to attract qualified applicants to your organization. Next, suggest three (3) communication methods that you would utilize to reach out to applicants. Predict the outcome of integrating your branding strategies and communication methods at your organization. Provide a rationale for your response. Determine two (2) selection processes for recruiting new employees that could apply to your chosen scenario and then identify five (5) selection criteria that you could use when hiring new employees. Next, analyze the effect of the five (5) identified selection criteria on long-term employee retention and preservation of organizational knowledge. Justify your response. Suggest two (2) assessment methods that you could employ to select new employees for your organization and then analyze the validity and reliability of each method in regards to the job your organization is offering. Next, identify four (4) job predictors that you believe can assess candidates’ knowledge, skills, abilities, and other skills and experiences (KSAO’s). Provide support for your rationale. Use at least four (4) quality resources in this assignment. Your assignment must follow these formatting requirements: Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; references must follow APA or school-specific format. Check with your professor for any additional instructions. Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required page length. The specific course learning outcomes associated with this assignment are: Explain the role of staffing to support an organization’s strategy and improve productivity. Explain the planning considerations for staffing organizations, the use of job analysis, and the components of a staffing plan. Develop recruitment plans using both internal and external recruitment. Design a selection process that incorporates a variety of assessment methods and a supporting decision method for candidate selection. Use technology and information resources to research issues in staffing organizations. Write clearly and concisely about staffing organizations using proper writing mechanics. Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using the following rubric. Points: 280 Assignment 2: Business Expansion and Sustainability Criteria Unacceptable Below 60% F Meets Minimum Expectations 60-69% D Fair 70-79% C Proficient 80-89% B Exemplary 90-100% A 1. Identify three (3) job requirements (e.g., needed certifications, previous work experience, external influences, etc.) that could apply to your chosen scenario. Determine two (2) ways these requirements could impact staffing at your organization. Next, suggest one (1) strategy that you could utilize to ensure that all applicants meet the identified job requirements for your organization. Justify your response. Weight: 15% Did not submit or incompletely identified three (3) job requirements (e.g., needed certifications, previous work experience, external influences, etc.) that could apply to your chosen scenario. Did not submit or incompletely determined two (2) ways these requirements could impact staffing at your organization. Did not submit or incompletely suggested one (1) strategy that you could utilize to ensure that all applicants meet the identified job requirements for your organization. Did not submit or incompletely justified your response. Insufficiently identified three (3) job requirements (e.g., needed certifications, previous work experience, external influences, etc.) that could apply to your chosen scenario. Insufficiently determined two (2) ways these requirements could impact staffing at your organization. Insufficiently suggested one (1) strategy that you could utilize to ensure that all applicants meet the identified job requirements for your organization. Insufficiently justified your response. Partially identified three (3) job requirements (e.g., needed certifications, previous work experience, external influences, etc.) that could apply to your chosen scenario. Partially determined two (2) ways these requirements could impact staffing at your organization. Partially suggested one (1) strategy that you could utilize to ensure that all applicants meet the identified job requirements for your organization. Partially justified your response. Satisfactorily identified three (3) job requirements (e.g., needed certifications, previous work experience, external influences, etc.) that could apply to your chosen scenario. Satisfactorily determined two (2) ways these requirements could impact staffing at your organization. Satisfactorily suggested one (1) strategy that you could utilize to ensure that all applicants meet the identified job requirements for your organization. Satisfactorily justified your response. Thoroughly identified three (3) job requirements (e.g., needed certifications, previous work experience, external influences, etc.) that could apply to your chosen scenario. Thoroughly determined two (2) ways these requirements could impact staffing at your organization. Thoroughly suggested one (1) strategy that you could utilize to ensure that all applicants meet the identified job requirements for your organization. Thoroughly justified your response. 2. Outline a long-term recruitment plan that contains at least four (4) components, is aligned with your company’s recruitment strategy, but also addresses possible job skill or credential shortages. Weight: 15% Did not submit or incompletely outlined a long-term recruitment plan that contains at least four (4) components, is aligned with your company’s recruitment strategy, but also addresses possible job skill or credential shortages. Insufficiently outlined a long-term recruitment plan that contains at least four (4) components, is aligned with your company’s recruitment strategy, but also addresses possible job skill or credential shortages. Partially outlined a long-term recruitment plan that contains at least four (4) components, is aligned with your company’s recruitment strategy, but also addresses possible job skill or credential shortages. Satisfactorily outlined a long-term recruitment plan that contains at least four (4) components, is aligned with your company’s recruitment strategy, but also addresses possible job skill or credential shortages. Thoroughly outlined a long-term recruitment plan that contains at least four (4) components, is aligned with your company’s recruitment strategy, but also addresses possible job skill or credential shortages. 3. Describe three (3) branding strategies that you would employ to attract qualified applicants to your organization. Next, suggest three (3) communication methods that you would utilize to reach out to applicants. Predict the outcome of integrating your branding strategies and communication methods at your organization. Provide a rationale for your response. Weight: 20% Did not submit or incompletely described three (3) branding strategies that you would employ to attract qualified applicants to your organization. Did not submit or incompletely suggested three (3) communication methods that you would utilize to reach out to applicants. Did not submit or incompletely predicted the outcome of integrating your branding strategies and communication methods at your organization. Did not submit or incompletely provided a rationale for your response. Insufficiently described three (3) branding strategies that you would employ to attract qualified applicants to your organization. Insufficiently suggested three (3) communication methods that you would utilize to reach out to applicants. Insufficiently predicted the outcome of integrating your branding strategies and communication methods at your organization. Insufficiently provided a rationale for your response. Partially described three (3) branding strategies that you would employ to attract qualified applicants to your organization. Partially suggested three (3) communication methods that you would utilize to reach out to applicants. Partially predicted the outcome of integrating your branding strategies and communication methods at your organization. Partially provided a rationale for your response. Satisfactorily described three (3) branding strategies that you would employ to attract qualified applicants to your organization. Satisfactorily suggested three (3) communication methods that you would utilize to reach out to applicants. Satisfactorily predicted the outcome of integrating your branding strategies and communication methods at your organization. Satisfactorily provided a rationale for your response. Thoroughly described three (3) branding strategies that you would employ to attract qualified applicants to your organization. Thoroughly suggested three (3) communication methods that you would utilize to reach out to applicants. Thoroughly predicted the outcome of integrating your branding strategies and communication methods at your organization. Thoroughly provided a rationale for your response. 4. Determine two (2) selection processes for recruiting new employees that could apply to your chosen scenario and then identify five (5) selection criteria that you could use when hiring new employees. Next, analyze the effect of the five (5) identified selection criteria on long-term employee retention and preservation of organizational knowledge. Justify your response. Weight: 20% Did not submit or incompletely determined two (2) selection processes for recruiting new employees that could apply to your chosen scenario and then did not submit or incompletely identified five (5) selection criteria that you could use when hiring new employees. Did not submit or incompletely analyzed the effect of the five (5) identified selection criteria on long-term employee retention and preservation of organizational knowledge. Did not submit or incompletely justified your response. Insufficiently determined two (2) selection processes for recruiting new employees that could apply to your chosen scenario and then insufficiently identified five (5) selection criteria that you could use when hiring new employees. Insufficiently analyzed the effect of the five (5) identified selection criteria on long-term employee retention and preservation of organizational knowledge. Insufficiently justified your response. Partially determined two (2) selection processes for recruiting new employees that could apply to your chosen scenario and then partially identified five (5) selection criteria that you could use when hiring new employees. Partially analyzed the effect of the five (5) identified selection criteria on long-term employee retention and preservation of organizational knowledge. Partially justified your response. Satisfactorily determined two (2) selection processes for recruiting new employees that could apply to your chosen scenario and then satisfactorily identified five (5) selection criteria that you could use when hiring new employees. Satisfactorily analyzed the effect of the five (5) identified selection criteria on long-term employee retention and preservation of organizational knowledge. Satisfactorily justified your response. Thoroughly determined two (2) selection processes for recruiting new employees that could apply to your chosen scenario and then thoroughly identified five (5) selection criteria that you could use when hiring new employees. Thoroughly analyzed the effect of the five (5) identified selection criteria on long-term employee retention and preservation of organizational knowledge. Thoroughly justified your response. 5. Suggest two (2) assessment methods that you could employ to select new employees for your organization and then analyze the validity and reliability of each method in regard to the job your organization is offering. Next, identify four (4) job predictors that you believe can assess candidates’ knowledge, skills, abilities, and other skills and experiences (KSAO’s). Provide support for your rationale. Weight: 15% Did not submit or incompletely suggested two (2) assessment methods that you could employ to select new employees for your organization and then did not submit or incompletely analyzed the validity and reliability of each method in regard to the job your organization is offering. Did not submit or incompletely identified four (4) job predictors that you believe can assess candidates’ knowledge, skills, abilities, and other skills and experiences (KSAO’s). Did not submit or incompletely provided support for your rationale. Insufficiently suggested two (2) assessment methods that you could employ to select new employees for your organization and then insufficiently analyzed the validity and reliability of each method in regard to the job your organization is offering. Insufficiently identified four (4) job predictors that you believe can assess candidates’ knowledge, skills, abilities, and other skills and experiences (KSAO’s). Insufficiently provided support for your rationale. Partially suggested two (2) assessment methods that you could employ to select new employees for your organization and then partially analyzed the validity and reliability of each method in regard to the job your organization is offering. Partially identified four (4) job predictors that you believe can assess candidates’ knowledge, skills, abilities, and other skills and experiences (KSAO’s). Partially provided support for your rationale. Satisfactorily suggested two (2) assessment methods that you could employ to select new employees for your organization and then satisfactorily analyzed the validity and reliability of each method in regard to the job your organization is offering. Satisfactorily identified four (4) job predictors that you believe can assess candidates’ knowledge, skills, abilities, and other skills and experiences (KSAO’s). Satisfactorily provided support for your rationale. Thoroughly suggested two (2) assessment methods that you could employ to select new employees for your organization and then thoroughly analyzed the validity and reliability of each method in regard to the job your organization is offering. Thoroughly identified four (4) job predictors that you believe can assess candidates’ knowledge, skills, abilities, and other skills and experiences (KSAO’s). Thoroughly provided support for your rationale. 6. 3 references Weight: 5% No references provided Does not meet the required number of references, all references poor quality choices. Does not meet the required number of references, some references poor quality choices. Meets number of required references, all references high quality choices. Exceeds number of required references, all references high quality choices. 7. Clarity, writing mechanics, and formatting requirements Weight: 10% More than 8 errors present 7-8 errors present 5-6 errors present 3-4 errors present 0-2 errors present P.S.The Part 1 of this assignment is attached here.