Tuesday, April 25, 2006

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)

Monday, April 17, 2006

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!

Wednesday, March 08, 2006

CXC Mock Theory Exam review

As revision for the mock exam, please try the exam on pages 295 - 297 of the Longman theory book.

Specifically, the exam covers all the work you have done in Years 11 and 12 - the syllabus is posted on a site in earlier blogs.

HOMEWORK: Please look at the Longman book and the syllabus and prepare ONE question that you would like to ask in our class on Thursday 9th March.

Monday, February 27, 2006

Mock Exam preparation

The practical exam takes place on Monday 6th March 2006, 9-11am.

A revision paper has been handed out - to download the files needed to practice for the exam(s) click here: http://www.italic.ky/lv/johngray/hp.nsf/PreviewHomePages/cxcit

You will need Excel, Word and Access on your computer to practice for the exam!

Work through the theory paper before Monday 13th March!

Monday, February 20, 2006

Exam prep and schedule

Theory test Friday 24th February :

Revise

Ways in which Information Technology can assist employees in the performance of their jobs (e.g. police, doctors, teachers, musicians etc.)

Difference between intranet and internet. HTTP:, FTP:, URL, email and newsgroups, DOMAIN NAMES (.com, .org, .gov etc. - also what is meant by ".co.uk" or ".gov.us")

Jobs in an IT department - what job is done by a network administrator, systems analyst etc.)

Timetable for the last weeks of school:

20-Feb 23-Feb 24-Feb
Theory test
27-Feb HALF TERM
6-Mar 9-Mar 10-Mar
MOCKS
13-Mar 16-Mar 17-Mar
MOCKS
20-Mar 23-Mar 24-Mar

27-Mar 30-Mar 31-Mar
SBA DEADLINE
3-Apr 6-Apr 7-Apr

10-Apr EASTER

24-Apr 27-Apr 28-Apr

Wednesday, February 15, 2006

CXC Theory Syllabus Unit 3 (Year 12)

APPLICATIONS AND IMPLICATIONS
GENERAL OBJECTIVES
This Unit seeks to provide students with an awareness of:
(i) (ii)
computer use and the implications of that use; careers in the field of Information Technology.
SPECIFIC OBJECTIVES
CONTENT
The students should be able to:
1.
identify and describe appropriate hardware and software to meet the particular needs of a given application;
Variety of computer systems used in commerce, industry, science and technology, education, law, recreation and entertainment with particular reference to the choice of unique hardware and software such as robots, voice synthesizers, videotex, plotters, scanners, expert systems, mainframes, mini and micro computers.
2.
discuss the reasons for the collection, storage and sharing of information in organizations;
Variety of application areas in which information is used as a commodity, for tactical and strategic decision making, as a tool in controlling, monitoring and supervising operations. Problems associated with shared data.
3.
identify and discuss concepts associated with the internet and intranet;
Electronic mail (e-mail), newsgroups, (Internet Relay Chat) IRC, Telnet, (File Transfer Protocol) FTP, (WorldWide Web) WVW, web browser, (HyperText Markup Language) HTML, web page, website
4.
identify and describe measures to secure data;
Passwords, encryption, physical access restrictions, software access restrictions, back-up and recovery, fireproof cabinets, archiving. Virus protection, data corruption.
5.
discuss possible misuse of information;
Privacy, propriety data and software propaganda, computer fraud.



SPECIFIC OBJECTIVES
The students should be able to:
6. identify and discuss issues which should be addressed by laws to protect individuals and organizations;
7.
discuss current technological trends;
8.
discuss the impact of Information Technology on job skills and careers;
9.
discuss the roles of various personnel in computer related professions.
CONTENT
Privacy, electronic eavesdropping, industrial espionage, surveillance, storage of inaccurate information.
Expert systems, natural language processing, robots, voice synthesis, laser technology, CADD, CAE, CAM, CAI, telemarketing, teleconferencing desktop publishing, commerce on internet.
Computer skills used by office employees, teachers, engineers, - medical personnel, musicians, mass media personnel, law enforcement personnel, movie industry. Loss of jobs. Retraining. Telecommuting, e-commerce.
Structure of a data processing department. The functions of individuals in computer-related fields such as programmers, systems analysts and designers; operators, managers; systems programmers; database administrators; network managers; data entry and control clerks; librarians; technicians; computer engineers. Jobs in service and support industries: software writers; consultants; data communications specialists; computer trainers; EDP auditors; sales staff.

CXC Theory Syllabus Unit 2 (Year 11-12)

Source code, object code, compiling, executing, interpreting, loading.


UNIT 2
INTRODUCTION TO PROGRAMMING
GENERAL OBJECTIVE
This Unit seeks to provide students with an appreciation of the fundamental principles and practices of
Computer Programming.
SPECIFIC OBJECTIVES
CONTENT
The students should be able to:
1.
Identify and describe levels of programming languages;
Characteristics of the following classes of languages: Machine level; Assembly level, High level; Fourth generation.
2.
3.
Partition a simple problem into its components;
Develop pseudocode algorithms to solve simple problem;
Identification of sub-processes in a task: input; process; storage; output.
Use of Read, Write, If-then; If-then-else; For loop; while loop; (questions which require nested conditionals or nested loops will not be asked). Use of simple logical operations: <, >; =; <; > =; < >; Problems can include simple arithmetic formulae (e.g. average) involving variables; +., -, * /. Use of simple data types; integer; real, string.
4.
code solution of problem using a programming language;
Use programming language constructs, data type operators and features to code pseudocode algorithm in specific objective 3 above.
5.
construct and use trace table to test algorithms and programs;
Trace table consisting of variable names (identifiers) as column heading and values in the cells, one row for each pass.
6.
test program and algorithms for correctness and make required changes;
Testing, debugging, logic errors, syntax errors, test data, dry-run.
7.
explain the terms associated with running a program.

CXC Theory Syllabus Unit 1 (Year 11)

UNIT 1
FUNDAMENTALS OF HARDWARE AND SOFTWARE
GENERAL OBJECTIVES:
This Unit seeks to:
(i)
to provide students with an introduction to fundamental hardware and software terminology and concepts;
(ii)
to provide students with hands-on experience of the operation of microcomputer based systems.
SPECIFIC OBJECTIVES
CONTENT
The students should be able to:
1.
state the functions of the basic components of all computers and list examples where applicable;
Control unit, ALU, main memory/immediate access storage, backing store/disk storage, peripheral devices.
2.
explain the functions and uses of primary storage devices and media;
Bistable devices, PROM, EPROM, RAM, ROM, byte, kilobyte bit, megabyte, gigabyte, terabyte, word, wordsize, address, location and address content.
3.
state and compare the characteristics and uses of secondary storage devices and media;
Magnetic tape, floppy disk, rnicro-floppy disk, hard disk (fixed head, moving head, exchangeable), optical disks, Magneto Optical disk, CD, DVD.
4.
explain and use terms associated with backing storage devices and media;
Read/write head, sectors, tracks, buffers, cylinders, access time, sequential access, direct access.
5.
state the characteristics and uses of input devices and media;
Optical mark reader (OMR), character readers (OCR, MICR), mouse, joystick, light-pen, touch terminals, voice data entry (VDE), voice response unit, pads and tablets, point of sale (POS), bar code, keyboard, key-to disk, scanners.
6.
compare the characteristics and functions of output devices and media;
Visual display unit (VDU); resolution, printers,
character, line, page, impact, non-impact, plotters,
voice, microfilm, permanent copy (hard copy), temporary copy (soft copy), speed, print quality, storage capacity, human readable, machine readable.




SPECIFIC OBJECTIVES
The student should be able to:
7.
describe how data are stored and manipulated within the computer;
8.
distinguish between systems and application programs;
9.
discuss the difference between generalized and specialised application packages;
10. distinguish between types of user interface;
Binary number, Binary addition, ASCII, discrete and continuous data, parity, conversion of decimal to binary and binary to decimal. Representation of integers (positive and negative); sign and magnitude; two's complement; characters, BCD representation.
CONTENT
11. describe and apply appropriate file management techniques;
12. use the appropriate operating system functions to:
Operating system functions, batch processing systems, on line systems, disk formatting, file management, data transfer, resource management.
(i) (ii)
Application programs, custom-written software, general purpose software; specialized software package, customization of general purpose software.
create a directory/folder; produce a directory listing of files;
prepare a diskette to store data;
copy single files from one diskette to another;
create a backup copy of a diskette;
delete unwanted files;
(iii)
Command driven, menu driven, HELP facilities, pull- down and pop-up menus, icons. Hardware: touch screens, pivoted monitors, antiglare screen.
(iv)
(v)
Directories, naming of files, labelling of diskettes, storage of files on diskettes, user back-up; user check point.
(vi)
13. recognize and use the terms commonly associated with data communication;
14. detect and rectify low level problems with the computer hardware.
Point-to-point and broadcast transmission computer network, modem, bandwidth, simplex, duplex, half duplex protocol, local area network, wide area network, up-load, down-load, e-mail, bulletin board, data transfer mode, voice band.
Loose interfacing cables, improperly adjusted monitor controls, changing ribbons/cartridges.

Programming - an important test program

You have covered all of the skills needed to pass the programming test. The following program helps practice all of the skills:

  • Input
  • Loops (where you DON'T know the number of times to repeat at the start)
  • Conditions
  • Sums and Counters
  • Output

Here's the problem:

  • Write a program to ask for a number of prices to be input.
  • The prices should be added up so that a final total can be given at the end.
  • The input of prices should continue until a price of 0 (zero) is entered.
  • At the end, the following should be printed:

Total Price
Average Price
Highest Price
Lowest Price


How to start???

1. I always think it's easier to plan around the "main" idea of the program: input a price.

(These blanks will be filled in after the homework is submitted!)

2. Build the loop around the input. First of all decide whether it is a FOR...NEXT loop or a WHILE...WEND loop (remember to leave spaces so you can add other things inside the loop):



3. Add a counter so you can check the number of prices entered (so you can work out the average price)



4. Add the price to the running total



5. Check if the price is the highest so far



6. Check if the price is the lowest so far



7. Print the total, average, highest and lowest.

Saturday, January 28, 2006

SBA deadline 1 and theory test

Please note the first portion of the SBA (Wordprocessing letters and list of Participants/Presenters) is being marked 28th-31st January. Anyone who has not yet handed in this work can send the finished files by email to jmshillito@yahoo.com. Work submitted by Tuesday 31st January will still be marked and returned to students so that grades can be improved. If you have not submitted this work by Tuesday, you can still get a grade as long as it is handed in - but you won't get the chance to improve your grade (the work is not returned to you).

Some students were unaware of the importance of the SBA. You must realise that the SBA is the easiest way to build up a store of marks before you go into the exam. Also, if you DON'T hand in the SBA, CXC will fail you, even if you get A's on the other papers.

On Thursday February 2nd there is a programming test. This counts towards your Session 2 grade. The topics for revision are: Counters, loops (For..Next and Do..While), IF..ENDIF, and Trace Tables. The programming booklet is available on the Italic website at this link: (temporarily unavailable). Also check the programming section of the Longman book.
A prep will be held Wednesday 1st February at lunchtime from 1-1.30pm in Room 20.