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