| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||
2 | ||||||||||
3 | 1. Track what you want. Edit the column headings and descriptions as needed to track relevant candidate information for your district. | |||||||||
4 | 2. Stick to standard language. To help with sorting and filtering later, use standard language and drop downs when possible. (Ex: Hiring Status: No application; Application issues; No Longer Interested; Application submitted; Interviewing; Hired) To add a dropdown menu: 1. Click Data. 2. Click Data Validation. 3. Select Add Rule. 4. Select Dropdown and enter each item to include in the list in each row. 5. If desired, select a different color for each item 6. Enter the range of cells or use the + option in the bottom right corner of the cell and drag to the rows where the dropdowns are needed. | |||||||||
5 | 3. Determine your candidate categories. Know which candidates need more of your attention and which need less by categorizing them as high-, medium-, or low-touch candidates. Enter a simple description for each category in A2 to keep tracking consistent. | |||||||||