Practical Paper 2004

Here is the 2004 Practical paper:

http://www.italic.ky/lv/johngray/hp.nsf/8f22e9637c74849a8025685f006a90bb/fd61c5abcbf2a299052570f5006400ca/$FILE/practical2004.doc

And the files to use:
Crime:
http://www.italic.ky/lv/johngray/hp.nsf/8f22e9637c74849a8025685f006a90bb/fd61c5abcbf2a299052570f5006400ca/$FILE/CRIME.XLS

Ministers:
http://www.italic.ky/lv/johngray/hp.nsf/8f22e9637c74849a8025685f006a90bb/fd61c5abcbf2a299052570f5006400ca/$FILE/MINISTERS.XLS

Notes:

GENERAL: MAKE SURE YOU SAVE REGULARLY, AND HAVE SAVED COPIES OF THE FOLLOWING AS YOU GO ALONG. (PUT YOUR NAME AND THE FILENAME IN THE HEADER OR FOOTER)

CRIME1 (SPREADSHEET), YEARLYCRIMES (BAR CHART), CRIMETYPE (PIE CHART)

A WORD DOCUMENT WITH THE FOLLOWING DATABASE TABLES OR QUERIES PASTED INTO IT: MINISTERS (DATABASE QUERY OR TABLE), ACTION (DATABASE TABLE), GDP, BUGAVG, BUGMAX, BUGMIN, TRAINING (QUERIES). THE REPORT (RECOM) DOES NOT NEED TO BE PASTED INTO THE DOCUMENT, BUT MUST HAVE YOUR NAME AT THE TOP. USE A LABEL TO INSERT YOUR NAME.

MAIN IS THE PRIMARY MAILMERGE DOCUMENT (WITH THE "ARROWS" OR FIELDNAMES IN IT). MINLETTERS SHOULD BE THE FIRST AND LAST MAILMERGED LETTERS.

Other notes:

Spreadsheet question i. (v) - System date: use =now()
l. Make sure the bar chart shows the years on the X axis. Make the chart by highlighting the data WITHOUT selecting the years. Then right click the chart and choose SOURCE DATA. Choose SERIES and look for X Axis Labels. This is where you put the range that contains the years. Try it!

Database: create a database called EXAM. Use the import wizard (GET EXTERNAL DATA) to import MINISTERS.

Question e. (ii) - Use a query with the field you want to average (SECURITY BUDGET). Right click on it and choose TOTALS. You can then select MIN, MAX and AVG - create 3 separate queries!

Question e. (iii) - Don't forget to use both tables and JOIN them on the common field.

Question f. - Report. The title should be on 2 lines (make 2 separate labels)


Word Processing: The mailmerge letter (called MAIN) uses your database table MINISTERS. Rather than type in TITLE, FirstName, LastName, save time by inserting the fields from the database.
Make sure you complete the merge and use the resulting document (which should contain 10 letters). Delete everything except the first and the last letter - if you make a mistake go back to MAIN and run the merge again. When you have the first and last letters make sure your name is in the header or footer.

TRY EVERY QUESTION ON THIS PAPER - if you email me completed attempts I will correct and return as soon as I can. If stuck, send me a question!

Good luck!