Free CXC Information Technology Paper 1 May/June 2017 past paper from 2017. Includes a worked answer key. Open the PDF, take a timed test, and study with AI on Caribbean AI.
Answer keys are free on Caribbean AI. View the answers to every past-paper question at no cost - no payment needed - with step-by-step worked solutions and instant AI marking available on Premium.
CSEC Information Technology Paper 1 May/June 2017 - Free CXC Past Paper with Answers
Free CXC Information Technology Paper 1 May/June 2017 past paper from 2017. Includes a worked answer key. Open the PDF, take a timed test, and study with AI on Caribbean AI.
Opening the interactive papers…
Every question from this paper as text. See the answers and worked solutions. Questions are the property of the Caribbean Examinations Council; Caribbean AI is not affiliated with CXC.
Which of the following are considered computer hardware?
Data
Programs
Operating systems
Output devices
Item 2 refers to the following specification about a processor for a laptop.
Intel Pentium V 64-bit 3.6GHZ
What does 64-bit mean in this specification?
The processor can process 8 characters at one time.
The processor can process 4 characters at one time.
The processor can access 8 characters at one time.
The processor can access 4 characters at one time.
In modern personal computers, the CPU speed is measured in
nanoseconds
milliseconds
megahertz
gigahertz
Which of the following devices produces a soft copy?
Printer
Plotter
Monitor
Microfilm
The smallest unit of storage in a computer is a
bit
byte
kilobyte
gigabyte
Which of the following is a hardware interface specially designed for use by a visually impaired person?
Natural language
Braille keyboard
Touch screen
Sensor
How many states can a bistable device assume?
Zero
One
Two
Three
The task of keeping a company's data files and software organized through the cataloguing and storing of tapes and disks is that of
an IT manager
a file librarian
a systems analyst
a database administrator
What does the spellcheck feature attempt to do?
Indicate spelling errors
Restrict unwanted words
Restrict unwanted characters
Indicate spelling and grammatical errors
Which of the following is NOT a function of the control unit (CU)?
To perform arithmetic operations
To read and interpret machine instructions
To coordinate the operation of the internal registers
To control the sequencing of machine instruction
The four-bit binary representation of the decimal number 8 is
0001
0010
0100
1000
Item 12 refers to the following picture.
Which of the following types of documents is shown in the picture?
Source
Turnaround
Machine readable
Human readable
Which of the following printers is MOST suitable for high-speed printing?
Dot matrix
Thermal
Inkjet
Laser
Which of the following is a communication mode that transfers signals between two connected devices in one direction only?
Half duplex
Broadband
Simplex
Duplex
A system that analyses data, and uses rules and previous information to deliver possible decisions is called
a robot machine
an expert system
a biometric machine
a mainframe computer
In the URL http://www.shoes.com, 'shoes.com' stands for the
extension
company name
domain name
Internet company
The primary storage device that holds the data currently being processed by the computer is known as the
read only memory (ROM)
random access memory (RAM)
programmable ROM (PROM)
erasable and programmable ROM (EPROM)
An official of Company X sells confidential information about his company to Company Y. What is the term used for this type of information misuse?
Identity theft
Computer fraud
Industrial espionage
Electronic eavesdropping
Brenda entered 2061 instead of 2016 in a form. What type of error does this represent?
Transpositional
Typographical
Proofreading
Spelling
Data that has been processed and has meaning is termed
information
database
storage
output
Records on magnetic tape are stored
directly
randomly
sequentially
indexed sequentially
Which of the following statements is NOT true of 3½" floppy disks?
Pictures and text can be stored.
Storage capacity is typically around 1.44 MB.
Information can be accessed more quickly than magnetic disks.
Large amounts of data can be stored.
Which of the following protocols allows users in different countries to talk to each other?
IP
VoIP
FTP
HTTP
Which of the following can be termed ‘application software’?
DOS
Linux
Mac Os
Internet Explorer
What is the result of the following operation?
Which of the following is BEST suited to batch processing?
Salary preparation
Online gaming
Flight simulation
Theatre booking
Harry interacts with his computer by entering word based instructions via the keyboard. This is an example of which of the following interfaces?
Menu driven
Graphical user
Keyboard driven
Command driven
Shirt sizes from 8 to 18 were entered into an inventory. Which of the following is a suitable check to ensure that the correct shirt size is entered?
Range
Verification
Inconsistency
Reasonableness
An advantage of electronic information processing is
the retraining of staff
less human intervention
less savings on hardcopies
increased amount of equipment
Which of the following is an example of a physical access restriction used to secure data?
Firewall
Password
Encryption
Biometric system
Selecting or highlighting a paragraph creates a
file
merge
block
document
Which of the following buttons can be used to fully justify text?
Image of text alignment buttons
Image of text alignment buttons
Image of text alignment buttons
Image of text alignment buttons
A primary key that comprises two or more field names is called
a foreign key
an alternate key
a composite key
a candidate key
Which of the following is NOT part of website maintenance?
Selecting a domain name
Adding new pages as needed
Changing web content as necessary
Removing hyperlinks that are no longer required
A student is engaged in preparing a project for submission and is working in MS Word. He wishes to have his student number appear at the top of each evenly numbered page and his name appear at the top of each odd numbered page. Which of the following word processing features should he use?
Header
Footer
Manual typing
Copy and paste
Item 36 refers to the following table containing data on three countries, A, B and C, for 2009 and 2010.
| Country | 2009 | 2010 |
|---|---|---|
| A | 300 | 600 |
| B | 500 | 800 |
| C | 500 | 600 |
Which of the following types of charts is NOT suitable for representing the data above?
Bar
Pie
Line
Column
Which of the following is the default justification of numbers in spreadsheets?
Left
Full
Centred
Right
Slides can be arranged using
slide view
slide sorter
slide master
new slide
The use of speaker notes in a presentation software
helps to organize slides
helps the audience to read them
inserts sound into the presentation
reminds the presenter what to say about each slide
Which of the following types of software should be used for applications that involve repetitive numerical calculations?
Database
Spreadsheet
Presentation
Word processing
Which of the following characteristics must two database tables have in order for them to be linked?
Composite keys
The same data in all tuples
At least two tuples in the table
At least one common attribute name
Which of the following effects is a special animation effect, where the information fades after it has been presented?
Animation
Dimming
Entrance
Emphasis
Items 43-45 refer to the following spreadsheet. A B C D E F PHONE PRICE MODEL NUMBER IN STOCK NUMBER STOCK SOLD BALANCE REORDER LEVEL 1 2 CP292 9.99 26 12 15 3 PC298 29.99 40 26 20 4 CP299 21.99 32 10 20 5 CP304 29.99 20 2 10 6 CP305 32.75 22 2 12 7 CP306 16.99 19 7 10 8 CP307 16.99 17 9 10 9 MB607 4.99 42 20 20 10 MB608 11.99 64 32 20
The values in Column B should be formatted using the
comma format
money format
currency format
percentage format
Which formula should be placed in Cell E2 to obtain the stock balance?
=C2-D2
=C2-F2
=D2-C2
=F2-D2
The function to display the text 'LOW' in cell G2 is
=IF(E2>F2, "LOW")
=IF(E2-F2, "LOW")
=IF(E2<F2, "LOW")
= IF(F2-E2, "LOW")
To which of the following code structures does the IF_THEN_ELSE. construct belong?
Iteration
Selection
Repetition
Sequencing
When breaking down a simple problem into its logical steps, what statement/instruction would the adding of two numbers be?
A process
An output
An input
A storage
What is the name given to an identifier that always holds the same value?
Constant
Variable
Location
Storage
Item 49 refers to the following algorithm. Write ("Enter price: ") (1) Read (price) (2) Vat: price * 15% (3) Write vat (4)
Which line contains a processing statement?
1
2
3
4
The term 'top-down stepwise refinement' used in programming means
breaking down a complex problem into a set of simple subproblems
selecting the best solution to a complex problem
dividing a complex problem into two halves
creating several solutions to a problem
When implementing a program, which of the following steps comes after executing?
Linking
Compiling
Maintaining
Interpreting
Which of the following is NOT a high-level programming language?
C
Java
Pascal
Assembly
The LAST step in solving a problem is to
test the solution
specify the design
evaluate the solution
develop the algorithm
Errors that result from NOT following the rules of the programming language are called
logic errors
syntax errors
run-time errors
execution errors
Item 55 refers to the following pseudocode. Read A, B If A< 2 C-2 Else C-6 End if DC*B+2 Write D
What is printed by the pseudocode if the input values are 5 and 2 respectively?
6
12
14
24
Which of the following statements includes loops?
Sequencing
Repetition
Selection
Ordering
Which of the following is a characteristic of a high-level language?
It is machine dependent.
It uses three-word commands.
It uses English-like statements.
It is harder to write than machine language.
Which of the following statements describes the function of the code above?
Enter 20 countries.
Print the names of 20 countries.
Search for 20 characters in an array.
Read in 20 characters and store them in an array.
A compiler is software that converts the
program to output
source code to assembly code
source code to machine code
program to object code one instruction at a time
A computer programmer is coding an algorithm which calculates the class average for a given exam. He creates a variable called class_avg. Which data type should he specify when declaring this variable?
Integer
Real
Boolean
Character