1 - Databases 2
2 - Field Types 2
3 - Validation 2
4 - Databases 3
5 - Database Revision Questions 4
6 - Websites 5
7 - Information Systems 6
8 - Coding and Markup Languages 7
9 - Media Questions – Text and Sound Files 8
10 - Storage Requirements 8
11 - Graphic Files 9
12 - Video and .pdf Files 11
13 - Hardware and Software requirements 12
14 - Output Devices 13
15 - CPU 14
16 - Device Types 15
17 - Software 15
18 - Backing Storage 16
19 - Networks 17
20 - Security Risks 18
21 - Security Precautions 19
22 - Legal Implications 20
23 - Environment 21
1 - Databases
1 Describe the difference between flat file databases and linked databases or relational databases. (2)
2 Explain what is meant by the terms given below: (3)
(a) Database File
(b) Record
(c) Field
3 What should the contents of a primary key field always be? (1)
4 Give 2 examples of data which would be suitable for a primary key. (2)
5 Explain the difference between a primary key and a foreign key. (2)
6 What is used to link database tables (files) together? (1)
Total Marks: 11
2 - Field Types
List the eight field types which you may include in a database and give example for each. (8)
Total Marks: 8
3 - Validation
List four validation checks which may be carried out on data being entered into a database and give an example for each. (8)
Total Marks: 8
4 - Databases
1 Suggest two reasons why a database table might have to be amended. (2)
2 Explain the difference between a simple sort and a complex sort. (2)
3 Give two ways in which database tables can be sorted. (2)
4 Explain the difference between a simple search and a complex search. (2)
5 Give four criteria which could be included in a search condition. (4)
6 Explain the benefit of doing a complex search rather than a simple search. (1)
Total Marks: 13
5 - Database Revision Questions
1 Explain the difference between a file, record and field is in a database. (3)
2 What is the difference between a flat file and linked tables? (1)
3 Give seven field types and give an example of the type of information which might be held in each field type that you have given. (7)
4 What type of key uniquely identifies each record in a database? (1)
5 What is the purpose of a foreign key? (1)
6 Explain why you would use and give an example for: (4)
7 What can be used to link database tables together to avoid duplication of data? (1)
8 Suggest a way in which a database table can be amended. (1)
9 What two ways can a database table be sorted? (2)
10 Why might you include a linked field in a database? (1)
11 How many values can a Boolean field contain? (1)
12 Explain the difference between a simple sort and a complex sort. (1)
13 How many fields are involved in a simple search? (1)
14 What is a complex search based upon? (1)
15 Explain the difference between list view and form view. (1)
16 What tool can be used to help create reports and forms? (1)
Total Marks: 29
6 - Websites
1 Give five media types which can be used to give information on web pages. (5)
2 What is a URL? (1)
3 Explain what http is used for. (1)
4 Explain what a domain name is? (1)
5 Give four domain types and explain what type of website they would represent. (4)
6 What are hyperlinks used for? (1)
7 Describe how a hyperlink can be created using either a piece of text or a graphic. (2)
8 Explain the difference between an internal hyperlink and an external hyperlink. (2)
9 Which kind of addressing would an internal hyperlink use? Relative or absolute? (1)
10 Give an example of an absolute web address. (1)
11 What are browsers used for? (1)
12 Which two features of browsers can be used to navigate websites? (2)
13 What is a search engine? (1)
14 Why are keywords important when using a search engine? (1)
15 Suggest a keyword or keywords which could be used in a search engine, to find your school’s website. (1)
Total Marks: 24
7 - Information Systems
1 What factors must be considered about the target audience for an information system? (2)
2 Suggest three ways that can be implemented in an information system to make is usable and accessible. (3)
3 Why should the names of internal hyperlinks be sensible? (1)
4 What can inclusion of a search facility do? (1)
5 Detail two considerations which should be given for visual layout of an information system. (2)
6 Suggest a way in which the interactivity with an information system can be kept consistent. (1)
7 What should be tested in an information system? (1)
8 Explain the difference between alpha and beta testing. (2)
9 What six features can be used for navigation in a website? (6)
10 What is usability? (1)
11 Describe three ways in which you can make your website consistant. (3)
12 Explain readability (1)
13 Explain accessability (2)
14 When might you use a linear navigation ion a web site. (1)
Total marks: /27.
8 - Coding and Markup Languages
1 Why do people use WYSIWYG web authoring software to create web pages? (1)
2 What is HTML short for? (1)
3 What two things does HTML use to create web pages? (2)
4 Give two examples of HTML elements syntax. (2)
5 What is an HTML element? (1)
6 Which HTML tag starts a heading? (1)
7 Which HTML tag ends a paragraph? (1)
8 Write the HTML code for a hypterlink to St Joseph’s College ‘
9 Write the tag that ends an HTML document? (1)
10 What are scripts used for? (2)
11 Give the name of the default scripting language used for HTML. (1)
12 Suggest an advantage of using a keyboard macro? (1)
13 Give two ways in which macros can be activated. (2)
14 Give two other advantages of macros. (2)
15 Give two disadvantages of macros. (2)
Total Marks: 23
9 - Media Questions – Text and Sound Files
1 List four different media types (4)
2 What is the advantage of using the standard file formats .txt and .rtf to save text files? (1)
3 Suggest why it might be better to save a file in rich text format (.rtf) rather than .txt. (2)
4 What are the two standard file formats for sound files? (2)
5 Why do audio, graphic and video files need to be compressed? (1)
6 What is sampling depth? (1)
7 What effect does increasing the sampling depth have on the size and quality of a sound file? (2)
8 How many different sound levels would you have with a bit depth of:- (2)
824
9 How much more backing storage would a bit depth of 16 require for the same sound file compared to bit depth of 8? (1)
10 What is sampling frequency? (1)
11 What effect does increasing the sampling frequency have on the size and quality of a sound file? (2)
12 What is WAV file format? (1)
13 Explain fully how WAV files are encoded (2)
14 How much smaller can a WAV file be? (1)
15 Explain how lossy compression works when applied to an .mp3 file. (2)
16 How much compression can the MP3 format achieve? (1)
17 Give two advantages of lossy compression for MP3 files. (2)
10 - Storage Requirements
Calculate the storage requirements in Mb for the following graphics:
1 A 5 inch x 5 inch graphic with a resolution of 300 x 300 pixels using a bit depth of 8 bits. (3)
2 A 2 inch x 2 inch graphic with a resolution of 200 x 200 pixels using a bit depth of 24 bits. (3)
3 A 6 inch x 4 inch graphic with a resolution of 400 x 400 pixels using a bit depth of 24 bits. (3)
4 A 3 inch x 2 inch graphic with a resolution of 200 x 200 pixels using a bit depth of 8 bits. (3)
11 - Graphic Files
1 List four standard file formats for graphics files? (4)
2 Give two reasons why graphics files need to be compressed (2)
3 Apart from using compression, what can be done to reduce the size of a graphic file? (2)
4 Write down how much storage per pixel is needed for the following bitmap files (5)
Black and White image / 1 bit per pixel16 colour image / 4 bits (minimum 1 byte) per pixel
256 colour image / 2 ^ 8 = 1 byte per pixel
65, 536 colour mage / 2 ^ 16 = 65, 536 = 2 bytes per pixel
16, 777, 216 / 16, 777, 216 = 3 bytes per pixel
5 Why are bit map (.bmp) files very large? (1)
6 How does lossy compression work in .jpeg files? (1)
7 Explain why lossy compression works in .jpeg files (2)
8 Below is a .jpeg picture of a cat, where the level of compression varies in the photo.
Draw three lines on your page, similar to the one shown, in any direction you choose.
a. One line should show the direction of ‘rate of compression increasing’.
b. One should show the direction of ‘file size increasing’.
c. One should show the direction of ‘quality increasing’. (3)
9 What type of graphics are best saved in .gif format? (1)
10 Write out and complete the following sentence.
When a graphic file is saved as a .gif file, the file size will ______but quality will ______. (2)
11 How many bits are used to store every pixel in a .jpeg? (1)
12 Explain fully why a .gif file can only have 256 colours (2)
13 What kind of files are .gif files most suitable for? (1)
14 What do .gif and .png files have in common regarding compression? (1)
15 Give the number of colours are available in: (2)
(a) .gif files
(b) .jpeg files
16 Why is the .gif file format not suitable for storing photographs? (1)
Total Marks: 31
12 - Video and .pdf Files
1 What are the two standard file formats for video files (2)
2 What is a video (1)
3 Give three reasons why video files are compressed (3)
4 How many colours are videos usually captured in? (1)
5 How many bits does true colour require? (1).
6 If colour depth in a video is reduced what three changes to the video occur? (3)
7 What two changes to a video occur if the resolution is increased? (2)
8 What two changes to a video occur if the resolution is decreased? (2)
9 What does fps stand for? (1)
10 What is the standard rate for a video clip (1)
11 What effect would reducing the fps in a video have on the size and quality of the video? (1)
12 Which video file format is uncompressed?
13 Give two limitations of AVI (2)
14 Give the video file format which uses lossy compression? (1)
15 Explain how lossy compression works in a video file. (3)
16 What file format was developed as a means of publishing and sharing documents across networks? (1)
17 If you open a .pdf file what can you normally not do with it unless you have permission? (1)
18 What does ‘portable’ mean when referring to a file?
Total Marks: 28
13 - Hardware and Software requirements
1 What is the most common input device used with a computer? (1)
2 What is a mouse used for? (2)
3 Which type of computer uses a touchpad instead of a mouse? (1)
4 Which input device can be used with voice recognition software to input instructions or data into a computer? (1)
5 Give two input devices which use a sensor called a charged coupled device to capture data? (2)
6 Suggest a suitable input device which could be used for video conferencing? (1)
7 Which input device used for capturing images, has the lowest resolution? (1)
8 Which input device can be used to capture handwritten signatures? (1)
9 Give two input devices which can be used to control video games. (2)
10 Explain what a scanner is used for. (1)
11 Which type of software is needed with a scanner to enable documents to be captured in a format which allows computer editing? (1)
Total Marks: 14
14 - Output Devices
1. Name two types of printers (2)
2. What is the resolution of a printer measured in? (1)
3 How is the speed of printing measured? (1)
4 How can pictures from a digital camera be easily printed out? (1)
5 What is a monitor? (1)
6 What is an LCD screen? (1)
7 Where would you usually find LCD screens being used? (1)
8 What is a TFT screen and what is the main advantage of using one? (2)