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

Excel-based nominee Short-lister - Essay ExampleThe intelligent rule is based on the progenys of A grades in the essential criteria requirements which is then sorted again by the number of As in the craved 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 pickax 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 resources are added in the initial rag, 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 heading an d the data as shown in jut out 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 topic 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 exploiter 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 i nternally 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 Figure7. variety 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