SHORT COURSES
The following short courses and Trainings are offered at the Department of Information Technology:
· Certificate in Computer Applications (CCA)
· Computer Repair and Maintenance ( CRM)
· Website Designing and Development (WDD)
· Computerized Records and Data Management (RDM)
· Audio and Video Editing and Production (AEP/VEP)
· Practical Skills Development, etc
· ETC
E-Learning Section
Module 1 Sample Part-Test 1.1
This is a sample test only.
Test 1
1.1.1
Which type of computer is used to operate large corporate systems and databases
1. Desktop computer
2. Personal Digital Assistant (PDA)
3. Mainframe
4. Laptop
1.1.2
Which of the following describes the essential components of Information Technology?
1. Primary, secondary and cache memory
2. RAM and ROM
3. Hardware, software and communications technologies
4. Hardware and shareware
1.1.3
The speed of the CPU is measured in:
1. Megahertz (MHz)
2. Bits per second (Bps)
3. Gigabytes (GB)
4. Megabytes (MB)
1.1.4
Which of the following statements about formatting a floppy disk for the first time is true?
1. Formatting prepares a floppy disk to store data
2. Formatting backs up data onto a floppy disk
3. Formatting copies a floppy disk
4. Formatting unlocks a floppy disk
© ECDL Foundation 2003 ref: 310803spt
12
1.1.5
Which of the following tasks is a function of the operating system?
1. Adding data to a spreadsheet
2. Producing a database report
3. File management
4. Producing a presentation
1.1.6
Which software would you use to create a mailshot letter?
1. Web browsing software
2. Spreadsheet software
3. Accounting software
4. Word processing software
1.1.7
The computers in your office building are connected together so staff can share files and
printers. What is this arrangement of computers called?
1. FTP
2. LAN
3. WWW
4. HTTP
1.1.8
An intranet is:
1. A network operating system
2. A network filing system
3. A private company network
4. A private company network that includes external specified users
© ECDL Foundation 2003 ref: 310803spt
13
1.1.9
Which of the following devices do you need to be able to communicate with other computers
using the telephone network?
1. CD-ROM
2. Modem
3. Plotter
4. Speakers
1.1.10
Which of the following tasks would be more suited to a person rather than a computer?
1. Tasks that are repetitive
2. Tasks that require speed
3. Tasks that require complex mathematical processing
4. Tasks that require imagination
1.1.11
Which of the following is NOT a use of computer applications in a school?
1. Class timetabling
2. Student registration
3. Computer based training
4. Stock Control
1.1.12
Which of the following is NOT a feature of electronic commerce?
1. Goods can be advertised and prices compared
2. There is physical contact between buyer and seller
3. Transactions can be processed quickly
4. Services are available 24 hours a day
© ECDL Foundation 2003 ref: 310803spt
14
1.1.13
Computer use can cause repetitive strain injury (RSI). Which of the following is the best way
to avoid this?
1. Ensure your computer is in a well-lit area
2. Use an operator chair without arms
3. Place your monitor at the correct height
4. Work with your wrists level with the keyboard
1.1.14
Which of the following statements describes a good approach to information security for an
organisation?
1. No procedures for reporting security lapses
2. Staff passwords are not changed regularly
3. Sensitive data is available to everyone
4. Computer systems are backed up on a regular basis
1.1.15
Which of the following is a good password policy for an organisation?
1. All passwords are changed regularly
2. All passwords are never changed
3. All passwords are made up of less than four characters
4. All passwords are made up of less than four numbers
1.1.16
What is the best way of preventing your computer from being infected with a virus?
1. Only virus-check e-mail attachments
2. Have updateable anti-virus software running on your computer
3. Have anti-virus software running on your computer
4. Never open any e-mail attachments
© ECDL Foundation 2003 ref: 310803spt
15
1.1.17
Which of the following statements describes shareware?
1. Shareware is software without copyright protection
2. Shareware is free software
3. Shareware is software you may pay for after an initial time period of use
4. Shareware is software you can use in any way
1.1.18
There are rules governing the storage and supply of computer-based information. What are
these rules called?
1. Data Privacy Policy
2. Data Management Act
3. Data Protection Act
4. Data Publicity Law
Module 1 Sample Part-Test 1.2
This is a sample test only.
Test 1.2
1.2.1
Which of the following would be considered a portable computer?
1. Workstation
2. Mainframe
3. Laptop
4. Desktop computer
1.2.2
Which of the following would improve computer performance?
1. Using a larger monitor
2. Increasing the number of applications running
3. Using a faster printer
4. Increasing the RAM size
1.2.3
Which of the following is NOT a function of the Central Processing Unit?
1. Executing program instructions
2. Ensuring program instructions are executed in the correct sequence
3. Sending e-mail
4. Carrying out calculations
1.2.4
Which of the following is both an input and output device
1. Touch screen
2. Keyboard
3. Printer
4. Scanner
© ECDL Foundation 2003 ref: 310803spt
17
1.2.5
Disk formatting is used to:
1. Find files on a disk
2. Lock a disk
3. Unlock a disk
4. Prepare a disk to store files
1.2.6
Which of the following is an operating system?
1. Lotus 123
2. PowerPoint 2000
3. Windows XP
4. Netscape
1.2.7
Which of the following four activities is normally carried out last as part of a Systems
Development process?
1. Design
2. Programming
3. Testing
4. Analysis
1.2.8
Which of the following statements about the Internet is TRUE?
1. The Internet is a global network that links many computer networks
together
2. The Internet is a private company network
3. The Internet is a visual representation of linked documents
4. The Internet is a network operating system
© ECDL Foundation 2003 ref: 310803spt
18
1.2.9
What is ISDN?
1. Integrated Standard Digital Networks
2. Integrated Services Digital Network
3. Interactive Standard Dynamic Networks
4. Internet Services Data Network
1.2.10
What type of computer application would be used in a hospital to maintain patient medical
details?
1. A desktop publishing application
2. A database application
3. An accounting application
4. A presentation application
1.2.11
Which of the following is a use of the Internet in the home?
1. Managing household accounts
2. Formatting a disk
3. Electronic mail (e-mail)
4. Creating a database
1.2.12
If you were working from home, what software application could be used to communicate
directly with colleagues and customers?
1. Presentation
2. Electronic mail (e-mail)
3. Database
4. Spreadsheet
© ECDL Foundation 2003 ref: 310803spt
19
1.2.13
Which of the following practises helps create a good ergonomic working environment?
1. Protecting computer monitors from reflections and glare by correct positioning
2. Taking infrequent breaks away from the computer
3. Keeping the office cold and using low overhead lighting
4. Use of non-adjustable chairs when working with computers
1.2.14
Why is it necessary for an organisation to adopt a good password policy?
1. To allow easy sharing of files across the company network
2. To make it easier for the computer to connect to a network
3. To protect files against unauthorized use
4. To make it easier to find files on a computer
1.2.15
Which of the following can be an advantage of electronic documents?
1. They can never be lost
2. They can always be e-mailed regardless of size
3. They can reduce the usage of paper
4. They can never be copied
1.2.16
Which of the following devices is suitable for backing up data from a networked
file server?
1. Modem
2. Tape cartridge
3. Plotter
4. Scanner
© ECDL Foundation 2003 ref: 310803spt
20
1.2.17
Which of the following activities could lead to the spread of a computer virus?
1. Using floppy disks from unknown sources to exchange data
2. Using a standalone computer to output a hard copy letter
3. Using retail software that has been checked for viruses
4. Using a Graphical User Interface (GUI)
1.2.18
An End User License Agreement:
1. Is a form of advertising between a software application author or publisher and the
user
2. Gives the user the exclusive right to copy and sell the software to other potential
users
3. Grants ownership of the software to the user of the software
4. Is a legal contract between a software application author or publisher and the user
with regard to terms of distribution, resale, and restricted use.
Module 2 Sample Part-Test 2.1
This is a sample test only.
The following is a sample test for Module 2, Using the Computer and Managing Files. In the
test you are required to answer questions associated with operating and using your computer.
You are also asked to create a folder structure that will help organise a new folder system in
your badminton club and to carry out various operations associated with manipulating files
and folders within this folder structure.
1. Locate the answer folder on your Candidate Disk. Open the answerfile contained
in the answer folder. [2 Marks]
2. Enter your Candidate Identification in the space provided on row 1 of the table on
the answerfile and save the answerfile on your Candidate Disk.
[2 Marks]
3. Which of the following is the correct name for the screen image shown below?
Enter your answer (a, b, c, or d) in the answerfile (Q. 3 space provided). [1 Mark]
(a) Title Bar (b) Scroll Bar (c) Status Bar (d) Menu Bar
4. Which file type below is often used for word processing documents? Enter your
answer (a, b, c, or d) in the answerfile (Q. 4 space provided) and save. [1 Mark]
(a) .xls (b) .mp3 (c) .doc (d) .gif
5. Which of the following is an advantage of a virus scanning application? Enter your
answer (a, b, c, or d) in the answerfile (Q. 5 space provided).
[1 Mark]
(a) It will help to spread viruses
(b) It makes the computer run faster
(c) It detects and removes viruses
(d) It prevents software from being copied
6. Locate the file goods.doc in the ecdltest folder and rename the file stock.doc [1
Mark]
7. Create a shortcut icon for the ecdltest folder on your Candidate Disk.
[1 Mark]
8. Locate the folder badminton on your Candidate Disk and create the
followingsubfolder structure as represented by the diagram below.
[2 Marks]
© ECDL Foundation 2003 ref: 310803spt
23
9. Copy the files fees.xls and female members.doc from the ecdltest folder to the
female subfolder. [1 Mark]
10. Change the attribute of the badminton report.doc file in the ecdltest folder to
Read-only. [1 Mark]
11. Count the number of files (including any files in subfolders) contained in the
ecdltest folder. Enter your answer in the answerfile and save. (Q. 11 space
provided). [2 Marks]
12. Print one copy of the answerfile to a printer if available or save as a print file in the
answer folder. (Use the file name printfile.prn if you are adding a print file to your
Candidate Disk.) Save and close the answerfile.doc document. [1 Mark]
© ECDL Foundation 2003 ref: 310803spt
24
Module 2 Sample Part-Test 2.2
This is a sample test only.
The following is a sample test for Module 2, Using the Computer and Managing Files. In the
test you are required to answer questions associated with operating and using your computer.
You are also asked to create a folder structure that will help organise files for an amateur
football club and to carry out various operations associated with manipulating files and folders
within this folder structure.
1. Locate the answer folder on your Candidate Disk. Open the answerfile contained in
the answer folder. [2 Marks]
2. Enter your Candidate Identification in the space provided on row 1 of the table on the
answerfile and save the answerfile on your Candidate Disk. [2 Marks]
3. Which of the following options will allow you to change from the current installed
printer to another installed printer? Enter your answer (a, b, c, or d) in the answerfile
(Q. 3 space provided) and save. [1 Mark]
(a) Set as Default
(b) Pause Printing
(c) Add Printer
(d) Capture Printer Port
4. Which of the following icons represents a folder? Enter your answer
(a, b, c, or d) in the answerfile (Q. 4 space provided). [1 Mark]
(a) (b) (c) (d)
5. Which of the following devices can be used by the operating system to store files and
folders? Enter your answer (a, b, c, or d) in the answerfile
(Q. 5 space provided). [1 Mark]
(a) Modem
(b) Video Card
(c) Hard Disk
(d) Plotter
6. Select the Recycle Bin icon on the desktop and move it to the upper right corner of
the desktop screen. [1 Mark]
7. Capture the current desktop as a screen image and paste it into page 2 in the
answerfile [2 Marks]
8. Locate the football folder on your Candidate Disk and create the following subfolder
structure as represented by the diagram below. [2 Marks]
© ECDL Foundation 2003 ref: 310803spt
25
9. Move the two most recently modified files from the ecdltest folder to the Juniors
subfolder. [1 Mark]
10. Copy the file panel.doc from the ecdltest folder to the juniors subfolder.
[1 Mark]
11. Delete the files issue.doc and sales.doc from the ecdltest folder. [1 Mark]
12. Print one copy of the answerfile to a printer if available or save as a print file in the
answer folder. (Use the file name printfile.prn if you are adding a print file to your
Candidate Disk.) Save and close the answerfile.doc document.
[1 Mark]
Module 3 Sample Part-Test 3.1
This is a sample test only.
Your task is to prepare a circular letter giving notice about an upcoming annual general
meeting of your local badminton club. In the test you are asked to modify the letter, to apply
various formatting actions to it; and to carry out a mail merge operation so that the circular
can be delivered to all the members of the badminton club.
1. Open the Word Processing application and open the file called test31.doc from your
Candidate Disk. [1 Mark]
2. Save the document to your Candidate Disk using the file name agm.doc
[1 Mark]
3. Create a new paragraph at the text beginning….This is a call…. and create a new
paragraph at the text beginning…Election of the Treasurer… [1 Mark]
4. Centre align the text To the members of the Keepfit Badminton Association and
save. [1 Mark]
5. Apply the font colour blue to the text To the members of the Keepfit Badminton
Association [1 Mark]
6. Make the title To the members of the Keepfit Badminton Association bold.
[1 Mark]
7. Change the font size for the entire document to 12-point and save. [1 Mark]
8. Apply bullets to the agenda items from Election of the treasurer… down to New
badminton court… [1 Mark]
9. Apply double line spacing to the agenda items from Election of the treasurer… down
to New badminton court… [1 Mark]
10. Enter the text Keepfit Badminton Association in the header of the document.
[1 Mark]
11. Print 1 copy of the document to an output printer if available, or as a print file to your
Candidate Disk. (Use the file name test31.prn if you are adding a print file to your
Candidate Disk.) [1 Mark]
12. Mail Merge: Use the current version of agm.doc as a form letter and save.
[1 Mark]
13. Use the file addrlst.doc from your Candidate Disk as the data source to be merged
with the agm.doc form letter. [1 Mark]
14. Replace the existing name and address lines with the merge fields.
<
<
>
<
15. Merge the address list data source file with the letter to create the mail-merged
document. Save the mail merge document as mergd31.doc Save and close all open
documents. [1 Mark]
16. Open the file called memorandum.doc from your Candidate Disk. Save the
memorandum.doc document to your Candidate Disk in template format as memo.dot
Close the memo.dot template and close the word processing application. [1 Mark]
Module 3 Sample Part-Test 3.2
This is a sample test only.
© ECDL Foundation 2003 ref: 310803spt
28
Your task is to prepare an information sheet providing tips about hill walking. In the test you
are asked to edit the information sheet, to apply various formatting actions to it, and to create
a simple table.
1. Open the Word Processing application and open the file called test32.doc from your
Candidate Disk. [1 Mark]
2. Save the document to your Candidate Disk using the file name hill walking.doc [1
Mark]
3. Zoom the hill walking document down to 100%. [1 Mark]
4. Select all the text in the document and change the font to Arial. [1 Mark]
5. Select all the text in the document and apply 6 point spacing above and below each
paragraph and save. [1 Mark]
6. Underline the title text Hill walking for amateurs [1 Mark]
7. Change the text Hill walking for amateurs to upper case and save. [1 Mark]
8. Edit the text sweating in the paragraph beginning Make sure that…. to read
dehydration [1 Mark]
9. Apply the italblue style to the text Hill Walking tips for summer: [1 Mark
10. Create a table with two columns and four rows below the paragraph beginning Make
sure that … [1 Mark]
11. Insert the following text into the table as below:
Warmest summer months for hill walking Degrees Celsius
June 20
July 25
August 24
[1 Mark]
12. Set the line width for all the borders in the table to 1 point. [1 Mark]
13. Centre align all the text in column 2 (Degrees Celsius column) in the table.
[1 Mark]
14. Change the top and bottom margins in the documents to 3 cms and save.
[1 Mark]
15. Use a spell-check program and make changes if necessary. (Proper names are not
included in this spell checking and may be ignored) and save. [1 Mark]
16. Print one copy of the hill walking.doc document to an output printer if available, or as
a print file to your Candidate Disk. (Use the file name walking.prn if you are adding a
print file to your Candidate Disk.) Save and close the document and the word
processing application. [1 Mark]
Module 4 Sample Part-Test 4.1
This is a sample test only.
The following sample test for Module 4, Spreadsheets, is based on creating a spreadsheet for
improvements to your house. In the test you are asked to develop a budget for improvements
to your house, to carry out various formatting actions, and to make some calculations before
presenting the spreadsheet to your bank manager.
16 Marks
1. Open the file called improvements.xls from your Candidate Disk. [1 Mark]
2. Save the improvements.xls spreadsheet as costings.xls to your Candidate Disk. [1
Mark]
3. On the projection worksheet zoom the display to 100% [1 Mark]
4. Widen column A as appropriate so that entered data is fully visible. [1 Mark]
5. Enter 2,000 in cell C7 [1 Mark]
6. Enter a formula in cell B11 to calculate the sum of the cell range B5 : B10
[1 Mark]
7. Copy the formula in cell B11 to the cell range C11 : F11 and save. [1 Mark]
8. Enter a formula in cell B13 that subtracts cell B11 from cell B3 Copy the formula in
cell B11 to the cell range C11 : E11 [1 Mark]
9. Enter a formula in cell F5 with an absolute cell reference (for one cell only), that divides
cell E5 by cell E11 Copy the formula in cell F5 to the cell range F6 : F10 [1 Mark]
10. Enter a formula in cell B15 to calculate the minimum cost of the cell range B5 : B10.
Copy the formula in cell B15 to the cell range C15 : D15 [1 Mark]
11. Enter a formula in cell B17 to calculate the maximum cost of the cell range B5 : B10.
Copy the formula in cell B17 to the cell range C17 : D17 [1 Mark]
12. Format the cell range B3 : E17 to € currency with no decimal places. [1 Mark]
13. Format the cell range F5 : F11 as a percentage with no decimal places and save. [1
Mark]
14. Rename the loan worksheet as bank loans and save. [1 Mark]
15. On the bank loans worksheet create a column chart, (accept default column chart)
from the cell range A3 : D5 [1 Mark]
16. Print 1 copy of the contents of the projection worksheet to an output printer if
available, or as a print file to your Candidate Disk. (Use the file name costs.prn if you
are adding a print file to your Candidate Disk.) Save all open spreadsheets and close
the spreadsheet application. [1 Mark]
© ECDL Foundation 2003 ref: 310803spt
31
Module 4 Sample Part-Test 4.2
This is a sample test only.
The following sample test for Module 4, Spreadsheets, is based on an analysis of revenues at
the Jupiter ice-rink. In the test you are asked to create a small spreadsheet for the ice-rink
management showing receipts over the four quarters of the trading period just passed, to
carry out various formatting actions and to make some calculations.
16 Marks
1. Open the file called arena.xls from your Candidate Disk. [1 Mark]
2. Save the arena.xls spreadsheet as rink.xls to your Candidate Disk. [1 Mark]
3. On the revenue worksheet adjust the height of row 6 as appropriate so that entered
data is fully visible. [1 Mark]
4. Enter 250 into cell C5 and 275 into cell D5 [1 Mark]
5. Change the number in cell D7 from 155 to 160 and save. [1 Mark]
6. Enter a formula in cell B8 to calculate the sum of the cell range B4 : B7
[1 Mark]
7. Copy the sum formula in cell B8 to the cell range C8 : G8 [1 Mark]
8. Enter a formula in cell B10 to calculate the average of the cell range B4 : B7 Copy the
average formula to the cell range C10 : E10 [1 Mark]
9. Enter a formula in cell G4 with an absolute cell reference that divides cell F4 by cell F8
Copy the formula in cell G4 to the cell range G5 : G7 [1 Mark]
10. Format the cell range G4 : G8 to percentage with no decimal places and save.
[1 Mark]
11. Enter a formula in cell B12 that displays the text Above Budget if the number in cell
F8 is greater than 2500 and otherwise displays the text Below Budget
[1 Mark]
12. On the sales details worksheet, create a pie chart (accept default pie chart) from the
data contained within the cell range A4 : B8 [1 Mark]
13. Delete the 2002 worksheet. [1 Mark]
14. On the names worksheet sort the cell range A4 : C135 by Surname in ascending
order and save. [1 Mark]
15. Print the contents of the revenue worksheet to an output printer if available, or as a
print file to your Candidate Disk. (Use the file name rev.prn if you are adding a print file
to your Candidate Disk.) Save and close the rink.xls spreadsheet. [1 Mark]
16. Open the file called yearly.xls from your Candidate Disk. Save the yearly.xls
spreadsheet as a template called yearly results.xlt to your Candidate Disk. Close the
yearly results.xlt template and close the spreadsheet application. [1 Mark]
