2005 Practical Paper

If you have not done so, try the 2004 Practical (http://jghscxc.blogspot.com/2006/04/practical-paper-2004.html) before this. It gives suggestions on how to save your work as you go along so you save time.

Here is the 2005 Practical. Try EVERY QUESTION and email me your answers (or questions you may have). I will try to reply as soon as I can.

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

And the files:

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

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

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

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

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!

The 2005 Theory paper - other questions

2005 Theory paper - for those of you who lost it - is here. It is split into different pages, so you can tackle one page per day for practice (or more if you wish!)

Page 1: Questions 1-3 (Year 11 work):
http://www.italic.ky/lv/johngray/hp.nsf/8f22e9637c74849a8025685f006a90bb/fd61c5abcbf2a299052570f5006400ca/$FILE/theory%2005%20page1.pdf

Page 2: Questions 4-6 (Year 11 work):
http://www.italic.ky/lv/johngray/hp.nsf/8f22e9637c74849a8025685f006a90bb/fd61c5abcbf2a299052570f5006400ca/$FILE/theory%2005%20page2.pdf

Page 3: Questions 7-11 (Year 12 work):
http://www.italic.ky/lv/johngray/hp.nsf/8f22e9637c74849a8025685f006a90bb/fd61c5abcbf2a299052570f5006400ca/$FILE/theory%2005%20page3.pdf

Page 4: Questions 12-13 (Year 11/12 Programming work):
http://www.italic.ky/lv/johngray/hp.nsf/8f22e9637c74849a8025685f006a90bb/fd61c5abcbf2a299052570f5006400ca/$FILE/theory%2005%20page4.pdf

Page 5: Questions 14-15 (Year 11/12 Programming work):
http://www.italic.ky/lv/johngray/hp.nsf/8f22e9637c74849a8025685f006a90bb/fd61c5abcbf2a299052570f5006400ca/$FILE/theory%2005%20page5.pdf

Please email with questions (or if you have difficulty downloading the files)

2005 Past Paper - programming question12

As promised! Start with the programming question: Section 3, question 12.

Write an algorithm using pseudocode to do the following sequence of tasks:

a) read in 2 values
b) multiply both values by the number 10 and add the results
c) square both values and add the squares
d) check if the answer to (b) is greater than the answer to (c)
e) if the (c) answer is greater, print a statement indicating that "The squares have won". If the (b) answer is greater print "The products have produced a win"

It's worth 8 marks!

NOTE - this was an unusual question, as the problem is actually broken down into steps for you already. Normally, the question would be more like this:

B
Write an algorithm to read in 2 values. You should first multiply both values by the number 10 and add the results, then square both values and add the squares. If the answer to the multiplication is greater than the answer to the squares, print a statement indicating that "The products have produced a win", otherwise print "The squares have won".

TASK ONE
I would suggest for practice that you look at B and try now to write down the steps needed (the ALGORITHM) to produce the program.

HINT: Print out or copy the question and underline what you think are the key words. For example, the first key words are "read in 2 values".

When you have finished, you should have around 5 steps needed to write the code. If you get stuck, look back at the original question.

TASK TWO
Now try the pseudocode. Pseudocode is close to real code (such as Visual Basic), but does not need the exact syntax of any particular language. You can use words like INPUT and PRINT, and it will help you to write the actual code when you are ready.

Don't forget - READ IN 2 VALUES simply means you need to get 2 numbers INTO the computer. This is an input statement using variables. You MUST get each number in separately - in other words it is best to first write one input statement and then another one on a new line. (1 mark)

Carrying out the multiplication part involves making up a variable name for the answer. Do it correctly and you get 2 marks.

Carrying out the squares is the same kind of problem - also worth 2 marks.

Using an IF statement correctly gets 1 more mark.

Getting the correct logic in the IF statement (i.e. printing the correct phrase depending on the numbers typed in) gets 2 more marks.


If you have ANY problems with part A or part B please email me and I will try to point you in the right direction. Remember, it's not as hard as it first appears; GIVE IT A GO!

I will not be going over this question in class!