National General Elections:
National general elections have been a recurring feature among the democratic territories of the Caribbean. Every year, in one territory or another, citizens exercise their right to elect a government of their choice. However, the exercise is not without its attendant challenges of data management. Thousands of votes are cast on the day of the elections and an anxious, waiting public demands speed, efficiency and accuracy in the determination of results. In preparation for the actual exercise, the Toledo Elections Commission has hired you to simulate the elections exercise as a test run, prior to the actual elections which are to take place shortly in your country. You are required to utilize suitable word-processing, spreadsheet, database management as well as a programming application to design and implement computer-based solutions to the tasks involved in the simulation of the election process.
The Elections Commission has mandated that you design a spreadsheet that will accept pertinent data on constituencies and candidates' votes and generate information that would enable the Outcome of the .elections to be divulged to the population in the shortest possible time. Four parties contest the elections: the Democratic Action Party (DAP), the Workers National Alliance (WNA)'th.e United Progressive Movement (UPM).'And the Peoples Democratic Revolution (PDR). Elections are contested to determine representatives ‘in eleven constituencies. The representative being the candidate who gets the most votes in his/her constituency. The parties field candidates in every constituency except for the PDR, which fields candidates in just six of the eight constituencies. For each constituency^ you are required to:
1. Create a table in your spreadsheet that records the number of Electors, Percentage voter
turnout. Number of votes cast, the percentage of Spoilt ballots and the number of General votes.
The number of electors...