Page 1033 - SUBSEC October 2017_Neat

Note the following:
 Format the Percentage of Votes Cast to one decimal place with the percent symbol.
 Centre the data in the worksheet.
 Merge and centre the cells in the row with the label “Elections Data”

Charting and Summary Operations
Generate a column graph that compares the votes cast and abstention data by constituency. Provide
an appropriate title, label the axes and display the data labels.

Create a pivot table showing the constituencies, the candidates’ names and the total number of votes
the candidates received.

Save your spreadsheet as Elections

Database Management
You are asked to use a suitable application to manage data on candidates nominated to contest seats
in the general elections. Three tables must be used to store the data. The table with relevant personal
data on each candidate should include: name, address, date of birth, gender, profession, constituency,
constituency number, party and votes received. The constituency data table should include: the
constituency name, constituency number and the number of voters in each constituency. An elections
data table should include: the constituency number and the percentage voter turnout for each
constituency.

The data to populate the tables must be sourced from the spreadsheet section of your project.

You should test your database by generating queries, reports and control forms:

Queries:

1. List the name, sex, age and profession of all candidates from the People’s Democratic
Revolution (PDR)

2. List the candidate name, party, number of voters and number of votes received for
candidates in constituencies with more than 6500 voters and where the candidates received
less than 1000 of the votes. Sort the data in descending order on the number of votes received
by the candidate.

3. Using a calculated field determine the total votes cast in each constituency.

Report
4. Generate a report which lists the constituency, number of voters in the constituency, name of
candidates, gender, party and number of votes received. The report should be grouped by
constituency. Within each constituency the report should be sorted in descending order by
number of votes received by each candidate. It should also give the total and average number
of votes in each constituency. The report should have a two-line title as follows:

“Official Results
Trinbarjam National Elections”

CXC 30/G/SYLL 17 56