Answers For Software

These are notes made by my ICT teacher. GOD BLESS HER! i hope these help

HideShow resource information
  • Created by: mar-rii
  • Created on: 07-06-09 19:42
Preview of Answers For Software

First 398 words of the document:

Software exam questions
Here are some examples of past exam questions:
1) A computer user enters data into a database. The user has to enter a four-figure serial number e.g. 1234.
a) Give one method used to verify the serial number. [1]
One answer from:
Double entry
Visual verification/proof-read/manual/double-check.
b) Why is the data verified? [1]
To check that the data has been entered accurately.
(Note there is no mark for saying "To check it is accurate" because the user might have been told the wrong serial
number in the first place, all the user can verify is that what they enter matches what they were told to enter.)
c) Give two methods that could be used to validate the serial number. [2]
Two answers from:
Range check OR checking it is between 2 values e.g. between 1000 and 9999
Checking it is data type number/integer
Length check - checking it contains four characters.
Presence check - checking something has been entered, checking the field isn't empty
Use a check digit.
d) Why is the data validated? [1]
To check that the data is reasonable. (No mark for writing "to check it is accurate/correct").
2) A designer is using a graphics package to create a diagram. The `Resize' feature can be used to change the size
of the image. Describe what these four other features do:
a) Flip
One answer from:
swap the image from left to right or from top to bottom
turn the image over
reflect/mirror the image
b) Crop
reduce the visible area OR chop/cut a bit off.
c) Fill
put a colour into a shape OR colour in.
d) Layer
One answer from:
Stacking layers on top of each other or behind each other
One of a series of planes in which you can place objects in a drawing
3) A writer has used a word processor to change the draft version of an article. Identify four ways that the format
of the draft article has been clearly altered. [4]
Four answers from:
Centre.
Bold.
Justify.
Change the size of the text.
Change font style.
Move picture.

Other pages in this set

Page 2

Preview of page 2

Here's a taster:

Size of text box changed.
4) A travel company is producing a page of a brochure that is illustrated. Explain when each of the following is the
most suitable method of obtaining the information. [4]
a) Scanner
If the image exists in non-digital form.
b) Digital camera
One answer from:
To collect your own image/take your own photograph.
If the image is too big to scan.…read more

Page 3

Preview of page 3

Here's a taster:

The image has been change using the flip (mirror, reflect, reverse) tool
The image has been changed using the crop/cut/erase/solid fill tool.
c) Give one reason why it may be wrong to scan an image from a school library book. [1]
It's breaking the copyright law because you have to permission from the person who owns the copyright.…read more

Page 4

Preview of page 4

Here's a taster:

Reduce the line spacing so it is single line spacing
Add hyphenation so words can be split over two lines
Use the shrink to fit to 1 page option
Edit the letter so it contains fewer words and/or uses abbreviations instead of full words
c) Give two advantages to the company of using mail merge to produce the letters.…read more

Page 5

Preview of page 5

Here's a taster:

Computer can take more accurate readings (will make less errors) than counting manually.
Computer will record every time it is supposed to as won't forget to record one of the readings.
Data recorded by computer is already in digital format so is ready to be used on the computer, for example for
displaying in a graph, therefore no need to manually enter the data into computer to use it.
Computers do not get tired or distracted like a person recording the data manually might.…read more

Page 6

Preview of page 6

Here's a taster:

CB9 AP3
22 Lower West St
Anne-Marie Smith F Cambridge 16-5-1993 13 Yes
CB13 6AT
66 Southside
Sian Williams F Cambridge 12-4-1991 4 No
CB4 7SD
101 Hull Rd
Darren Martin M Cambridge 18-3-1991 161 Yes
CB1 2TY
a) Give the most suitable field type for each of these fields:
i) Stay for School Dinners
One answer from:
Boolean
YES/NO
ii) Pupil ID Number
One answer from:
Number
Integer
Whole number
Numeric
Autonumber
iii) Address
One answer from:
Alphanumeric
Text
String
iv) Contact Telephone Number…read more

Page 7

Preview of page 7

Here's a taster:

A history teacher is writing a book on the history of the school. She is using her school computer & her home
computer to write the book. She spends many hours at a computer &, as a result, has some health problems.
State one possible problem & explain how this problem might be reduced. [4]
Choose one problem (I mark) and then give 3 ways it can be reduced (3 marks)
Eye problems:
Regular breaks away from the computer.
Blink regularly to avoid eye problems.…read more

Page 8

Preview of page 8

Here's a taster:

When the database was designed, each field was given a field type. Tick ( ) one box in each row to show the
most suitable field type for each of the fields. [4]
Field type chosen
Field name Boolean Alphanumeric Numeric
Price
Sold
Car stock code
Type of car
b) Which field would be most suitable as a key field? [1]
Car Stock Code
c) The data in the table could be sorted into ascending order of Year of manufacture.…read more

Page 9

Preview of page 9

Here's a taster:

Give two reasons why she would use a spreadsheet for this task. [2]
Two answers from:
Automatically recalculates answers when variables are changed.
Can use formulae & functions to work out answers
Can replicate/drag down formulae so that don't have to keep retyping them when you are doing several similar
calculations
Can use a spreadsheet to answer "What if" scenarios
Can create graphs/charts to display the data graphically.…read more

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all resources »