Excel-based Candidate Short-lister Essay Example | Topics and Well Written Essays - 1000 words

Excel-based Candidate Short-lister - Essay Example The intelligent rule is based on the numbers of ‘A’ grades in the essential criteria requirements which is then sorted again by the number of ‘A’s in the desired criteria. This gives a more scrutinized level of sorting, for selecting the most qualified candidates in case of huge number of candidates satisfying the requirements. Moreover, each page is enhanced with a ‘Save’ and ‘Print’ option so as to ease the operation of saving the work and printing them whenever required, during the process. The below screen shot shows the initial screen of the tool. Figure1. Initial screen of the Candidate short-lister tool For easy navigation, View application data and view shortlisted data options are added in the initial sheet, which when clicked will take us to the respective sheet. The desired and the essential criteria for the job description are added in the respectively columns without any space between the cells and also between the head ing and the data as shown in figure 2 and ‘Generate Application_data Sheet’ is clicked. This will create template for the Application data sheet for entering the application data (shown in figure 3). Figure2. Entering the essential and desired criteria for the job description Figure3. ... p, which when clicked will shortlist all the candidates satisfying the given requirements based on their grade and creates a report in the shortlisted Candidates sheet(figure 5). The minimum qualifying grade used in this selection process is also given in the Shortlisted Candidates sheet in pink line. If the user is not satisfied with the number of shortlisted candidates and want to maximize or minimize the result, they can edit the field and refine the search (figure 6). Figure4. Data are entered manually in the application data sheet In case, if we want to sort the report to choose a required number of candidates, we can use the Intellisort option in the shortlisted candidates sheet, which will internally perform a sort based on the number of ‘A’ grades in the essential criteria and again on the number of ‘A’ grade in desired criteria. This is shown in figure 7. Figure 5. Short-listed candidates Figure6. Refine search by editing the options in pink line Fi gure7. Sorting the candidates using Intellisort If we want to shortlist only the top 5 candidates for interview scheduling, we can click the Shortlist Top 5 button on the Shortlisted Candidates sheet which will internally perform an intellisort and selects the top 5 candidates and creates a report on the Top 5 Candidates sheet (figure 8). Figure8. Selecting the top 5

AN INQUIRY INTO THE EFFICIENCY OF CELEBRITY ENDORSEMENT AS A MARKETING Dissertation

AN INQUIRY INTO THE EFFICIENCY OF CELEBRITY ENDORSEMENT AS A MARKETING COMMUNICATIONS STRATEGY IN MORDERN SOCIETY - Dissertation Example Furthermore, factors such as the gender and age of the focus group were also taken into consideration as it greatly affects the findings of the study. On the basis of this study, it was observed that findings regarding the effect of celebrity endorsements as a marketing communications strategy could be divided into three key areas, namely – the perception of consumers with regard to a particular celebrity and his /her association with a brand / product or service; key factors which must be taken into consideration while choosing a celebrity for endorsing a particular brand or product; and finally develop a strategic model for Data Analysis: In order to measure the attitudes and perception of consumers towards a product celebrity endorsements various variables will be studied such as - their views on the advertisement; perception of the brand based on that advertisement; and the influence on their purchase decision. The differences in their perceptions with regard to the celebr ity endorsements will be measured on the basis of their attitudes towards single celebrity ads (i.e. a product endorsed by one celebrity) and multiple celebrity ads (i.e. same product endorsed by multiple celebrities). The data will be then analyzed on the basis of percentage of respondents in accordance with these variables such as gender, age, educational background etc. On the basis of the literature review, and the observations likely to be made on the basis of the personal interviews, it could be stated that the success or failure of any celebrity endorsement is a result of several attributes, which will be presented in the questionnaire. This includes - match between the product and the celebrity endorsing it; the choice of celebrity and the target audience; the popularity of the celebrity; the credibility or image of that celebrity in the industry; the values they endorse; their physical appearances; their appeal i.e. locally as well as globally; the likelihood of the risk of them (celebrities) getting involved in a conflict or a controversy; and the number of brands endorsed by the said celebrity. These attributes play a key role in influencing the consumer’s purchase decision and hence must be taken into consideration by the marketers / organizations prior to associating themselves with a celebrity. This information will be presented in the form of graphs, for better clarification the same is depicted in the figure below: Figure 1: Factors taken into consideration while selecting a celebrity for endorsing a given brand / product: The rating will be shown on the x axis while the attributes will be shown on the Y axis. The numbers 1 to 9 indicate the attributes mentioned above, which are taken into consideration by marketers while endorsing a product. The findings in this chart will be based on the observations made as well as on the findings observed in literature review section. In recent times, the global business has become highly complicated and hence the choice of a right celebrity for the product is extremely crucial for the organizations. Their decision strategy may