The data collected during the application had the selection process in mind.
A spreadsheet has since been developed of all entries with the time stamps and corresponding information requested.
Therefore, the serial numbers will follow accordingly.
1. The entries will initially be filtered by the Local Government initially. Entries with more than one Local Government Area will be automatically disqualified at this stage.
2. Data will be replicated in five different spreadsheets, one for each Local Government Area in Cross River North.
3. The data for each Local Government will be revalidated to remove multiple entries.
4. Thereafter, the RANDARRAY function on Excel 365 will be used to randomly generate numbers matching the total entries for each Local Government Area.
5. For example, Yala Local Government has 743 entries, therefore, numbers randomly generated will vary from 1 to 743. Thereafter, the first 100 generated will be copied.
6. The SHOWROWS function will automatically highlight the entries whose numbers are generated.
7. Then comes the hard work! Each entry will be carefully checked for the following three key uploads;
i. How do you verify identity? (Name of applicant and their Local Government of Origin).
ii. How are you sure the person is a student? (Hence the Admission letter).
iii. Is the person active as a student? (Evidence of payment of fees in the current session).
8. Each selected entry must scale through this hurdle before the bank details will be checked to ascertain it is not a proxy.
9. If the process does not return 100 beneficiaries among the first randomly generated numbers, the process from Number (4) will be repeated to generate the remaining beneficiaries.
Now you know how it will work. And like I said previously, this process may not be perfect or full-proof, but it will definitely return results that are better than what was done previously.
This initiative is powered by Sen Jarigbe Agom, representing Cross River North Senatorial District.
Yours sincerely,
Citizen Agba Jalingo.
#JariCare
#JariBurs
#JariEnterprise
#JariLeads
Disclaimer: The opinion expressed in this article is strictly that of the author, Agba Jalingo, and does not represent TheLumineNews, its agent or the organization the author works for.