Question	Answer	Points
Ring two items which contain personal data. Car park ticket Credit card Digital clock Keyboard Pupil record Remote control	Pupil Record Credit Card	2
Match the software to its use. Spreadsheet: Database: Desk Top Publishing: Measuring program: Word processor: storing pupil records producing the school magazine writing letters to parents keeping school tuck shop accounts recording data in a science experiment	Presentation graphics: preparing a talk to show how a computer works Word processor: writing letters to parents Spreadsheet: keeping school tuck shop accounts Database: storing pupil records Measuring program: recording data in a science experiment Desk Top Publishing : producing the school magazine	5
Give two ways in which a hard disc is different from a CD ROM.	A harddisk has read and write data access A CD-ROM is read-only data access A harddisk stores data in a magnetic way A CD-ROM stores data in an optical way A harddisk can store up to many Gigabytes A CD-ROM can store a maximum of 660 MB	2
Label the parts of the Picture CD-ROM Drive Joystick Keyboard Microphone Midi Interface Monitor Mouse Plotter Printer Processor Speaker Video	CD-ROM Drive=B Keyboard=E Monitor=A Mouse=D Speaker=C	5
Tick whether the following statements are TRUE or FALSE. OMR is used to read data from school registers. OCR is used to read data from bank cheques DTP is used to store pupil records on a school computer system. Regular use of computers improves your eyesight.	OMR is used to read data from school registers. TRUE OCR is used to read data from bank cheques TRUE DTP is used to store pupil records on a school computer system FALSE Regular use of computers improves your eyesight FALSE	4
Describe two features of a mouse.	A mouse can be used to click and select an object A mouse can be used to drag an object (point / click / drag)	2
Describe two precautions you can take to prevent viruses from entering your computer system	Do not use floppy disks or other removable storage media Use a virus scanner at all times Make sure that the virus scanner is always up-to-date Do not open E-Mail attachments that are .exe files (executable)	2
(a) Name two types of software which could be used in a school’s sports department. (b) State how each type of software would be used.	Spreadsheet - to calculate sport achievements (speed, time etc.) and produce charts Database - to store data about pupils and their sport achievements, produce lists Video imaging software - Record video and add sound / pictures to produce a digital sports movie	4
Pupil records are kept on a computer in the school office. Here is a part of a file of year 12 student records. (a) (i) Write down the name of the field which would be used as the key field. (ii) Why would it be used? (b) Which field is most likely to be designed as Boolean/logical data type? (c) Why is it more suitable to use date of birth rather than age? (d) State two ways in which pupil records can be protected from unauthorised use.	a) Exam Number; It identifies the record in a unique way b) Gender (male or female) c) Age can always be calculated (it will change every year, birthday will not change) d) Password protection of the database, personalised access privileges, firewall protection (in a network)	6
State one advantage and one disadvantage of using a laptop computer rather than a desktop computer.	Advantage: portable, can be used anywhere, small device Disadvantage: needs batteries (are limited), more fragile, can be stolen easier	2
You have been asked to set up a science experiment to measure the rates of cooling of different liquids. You must use a computer to do this. You will need a monitor, keyboard and a mouse to help set up the experiment. Name three other items of hardware or software. For each one you will need to say what it will be used for.	Datalogging sofware - to store the recorded data in a digital form Data sensors - to capture the analogue data and covert into digital data A printer or plotter - to output results A database - to store the results long-term A spreadsheet - to calculate the data and produce charts	3
A school uses a database to store records about its students. Describe a situation where a record on the database would need to be: (a) inserted (b) deleted (c) amended	Inserted - when a new student arrives Deleted - when a student graduates and leaves school Amended - when a student changes address or when grades are added	3
(a) Name two household appliances which use computer control. (b) Describe two ways in which the use of such appliances has influenced people’s lifestyles.	A central heating system An air-conditioning system An automated sprinkler system (garden or fire) An anti-burglar system It makes people lives more safe, more convenient, adds quality to living, gives more leisure time, helps saving energy etc.	4
At the end of the school year the head teacher sends a letter home to parents. This letter contains details of their new class teacher. Describe the steps in the production of such a letter using mailmerge.	1. select certain records from the database (find e.g. students / certain class) 2. sort the records (class or surname) 3. save the records in a suitable format (tab-based) 4. add database merge fields in a wordprocessor 5. design a letter, using the merge fields 6. insert the saved records (open / insert) 7. preview the merged letters 8. print the mail merge Some databases allow a direct printing of such letters. One needs to design an appropriate layout with merge fields.	3
Most home computer owners use a modem to connect to the Internet using a telephone line. (a) Why is a modem needed? (b) Give two advantages for individuals of using the Internet in the home.	The modem will convert from digital computer data to analalogue telephone system data (and back). Phoneline systems are mostly analogue. One can find interesting articles One can do home shopping (E-Commerce) One can communicate with others (E-Mail / Chat) One can search specific content (like a recipe) One can find phone numbers, addresses, events etc.	3
(a) Employees in a school office use computers for long periods of time. (i) Describe one health problem which can be caused by such use. (ii) Describe one way in which this might be prevented. (b) The employees print a lot of copies of the same documents. Give two reasons why they should use a laser printer rather than an inkjet printer.	A) (i) One can get RSI, an injury of joints, causing lots of pain; one can get eye strain, due to bad light conditions or bad screens; one can get backpain, due to false adjusted furniture (chair / table) (ii) Use ergonomic designed furniture (adjustable); allow regular breakes from working at the computer B) A laser printer will print faster, is easier to maintain (replace toner cartridges), prints out text sharper (as it uses toner and not ink), produces less noise, can use letterhead (multiple paper draws), can store more paper	4
A school is going to publish its exam results on its website. Describe three stages in the creation of a page, naming the particular type of software which would be used at each stage.	1. Write (insert) the exam results in a suitable package, e.g. a spreadsheet, one could use OCR to achieve this 2. Sort the data, according to classes 3. Export the data as an HTML table 4. Using Webpage design / html editors, insert the html table and finish of the layout / design; one could use a graphical application (e.g. Photoshop) to add / change a school logo or digitise other pictures 5. Use FTP software to upload the webpage(s) to a Website 6. Publish the website using Webserver software (e.g. Apache)	3
A school is going to buy computers to create a new IT room. They will be connected to the existing network. (a) Give two factors other than cost that should be taken into account when choosing suitable computers to add to the network. (b) The purchase of new computers will cause the fileserver to be short of storage space and run more slowly. Describe two solutions to these problems. (c) Apart from the computer, describe one item of hardware which would be needed and explain how it could be connected to the network.	a) Place available -> e.g. laptops need less space; who will be the users -> e.g. primary students need small mice and adjustable monitors; compatibility -> new machines should be compatible to the ones already there a) One could update the server, add more main RAM memory and harddisk space, or one could add another server, with better features (e.g. use the old one as test machine) c) A printer -> would be connected via a network card/cable (ethernet), a Scanner -> connected via a USB cable to a single computer, a	6
A school’s student record system is on a completely separate computer network (the ‘Admin’ network) to the network the students use (the ‘Curriculum’ network). The school is buying a computer for the staff workroom. Discuss the advantages and disadvantages of connecting to each network.	Connect to the Admin network: advt = staff can enter grades, see pupils records, see attendance etc., disadvt = staff cannot monitor what students are doing (observe), cannot send files to students (e.g. class assignments) Connect to the Curriculum network: advt. = staff can communicate directly with students (observe maybe, send files), disadvt = staff cannot see students records. Modern systems allow to login from anywhere. It would require a secure password policy, long ones, that need to be changed regularly.	5
Most school libraries have computers which help the librarian to administer the lending system. Discuss the benefits to the librarian and students caused by the introduction of computers into their libraries.	The librarian can monitor precisely the book stock and plan much better. He can keep track of lending figures, find the ‘hot’ items, print lists of books and sort to usage figures. It makes the work much more efficient and searches will go much faster. Students will find a resource much quicker, and will have an overview of all sources to a certain topic. They might be able to reseach the catalogue from anywhere, and even reserve books. They will also know exactly how long they have items and know about fees to pay.	4
The results and pictures of a school sports day are to be included in a school magazine article. At the moment the results are stored in a spreadsheet. Describe how this article will be produced.	The spreadsheet will most likely store only the names of pupils and the results. One could produce nice overviews of certain activities, sorted to classes or winners. It would look good to also create some charts, showing results in a graphical way. This data can be exported and then imported or pasted into a DTP - desktop publishing - package. The pictures and photo’s of the event can also be added into the DTP program. The design requires to define and set margins, columns, text wrap features and include headers and footers. As the school magazine has probably more articles, it’s likely that the different pages need to be inserted and a general content page is added. A modern system might even allow collaborative work (network based).	4