CSEC Information Technology Revised2020 PDF
CSEC Information Technology Revised2020 PDF
CSEC Information Technology Revised2020 PDF
Education Certificate®
SYLLABUS
INFORMATION TECHNOLOGY
CXC 30/G/SYLL 17
SYLLABUS
Effective for examinations from May–June 2020
INFORMATION TECHNOLOGY
CXC 30/G/SYLL 17
Correspondence related to the syllabus should be addressed to:
The Pro-Registrar
Caribbean Examinations Council
Caenwood Centre
37 Arnold Road, Kingston 5, Jamaica
CXC 30/G/SYLL 17
Contents
RATIONALE.. .......................................................................................................................................... 1
AIMS………………….. ................................................................................................................................. 2
NOTES TO TEACHERS............................................................................................................................. 6
CXC 30/G/SYLL 17
This document CXC 30/G/SYLL 17 replaces CXC 30/G/SYLL 08 issued in 2008.
Revised 2000
Revised 2008
Amended 2013
Revised 2017
CXC 30/G/SYLL 17
Information Technology Syllabus
RATIONALE
Information Technology (IT) continues to evolve in response to the need for more efficient techniques
to manage the significantly increased volume and sophistication of the knowledge reservoir of
mankind. It merges the study of Computer Science, Information and Communications Technology (ICT)
and Office Automation. It involves the collection, processing, storage, retrieval, and dissemination of
information, and impacts both work and social activities. The evolution of the field of Information
Technology continues at a rapid pace. New technologies are constantly emerging and existing ones
become obsolete soon after they appear. The rapid advances in technology undoubtedly have a
profound effect on information technology education and, as such, Information Technology curricula
must be refreshed to remain relevant.
Information Technology is the key to development and productivity in this modern era and as such,
Information Technology education must be seen as integral to meeting the developmental needs of
our region. All citizens should have practical exposure to the applications of Information Technology
in order to narrow the gap between Caribbean and developed nations. Consequently, this programme
of study in Information Technology promotes the development of computer-related skills and
encourages the development of analytical and design skills which are applicable in all subject areas,
the work environment and the wider society. The syllabus aims to provide a blend of knowledge and
practical experience that fosters innovation, self-confidence, together with critical thinking skills that
will prepare students to meet the ICT needs of the region and beyond.
The Information Technology syllabus is based on objectives, skills and content which will cultivate the
attributes of the Ideal Caribbean Person as articulated by CARICOM. That is, a Caribbean person who
demonstrates multiple literacies, as well as independent and critical thinking, and questions the beliefs
and practices of the past and brings this to bear on the innovative application of science and technology
to problem-solving. Such a person will inevitably demonstrate a high level of self-confidence and self-
esteem, a positive work ethic, and display and nurture creative imagination in the economic and
entrepreneurial spheres and other areas of life. Also, in keeping with the UNESCO Pillars of Learning,
this course of study will contribute to the development of a person who will learn to be, learn to know,
learn to do, learn to live together, and learn to transform oneself and society.
CXC 30/G/SYLL 17 1
AIMS
The syllabus aims to:
4. facilitate the development and application of problem-solving and other twenty-first century
skills;
(a) Word-Processing.
5. Spreadsheets.
6. Database Management.
8. Program Implementation.
CXC 30/G/SYLL 17 2
SUGGESTED TIMETABLE ALLOCATION
It is estimated that the syllabus can be covered in approximately 160 hours or four periods per
week during the fourth and fifth years in the secondary school. A suggested time allocation (in
hours) is shown below for each section. The laboratory hours indicated are calculated on a per
student basis.
5. Spreadsheets 5 10 - 15
6. Database Management 5 13 - 18
8. Program Implementation 15 20 - 35
Allied Subjects
Paper 02 Four compulsory structured questions drawn from all areas of the
(2 hours) syllabus. Marks will be allocated as follows: 35 marks toward the
Theory profile, 30 marks toward the Productivity Tools profile
and 25 marks toward the Problem-Solving and Programming
profile. Knowledge of a specific programming language will not
be tested.
CXC 30/G/SYLL 17 3
consisting of five questions: four on Productivity Tools, worth 35
marks, and one on Problem-Solving worth 15 marks.
School-Based Assessment
Paper 031 The SBA component will comprise a practical project testing
Section 4, Word-Processing and Web Page Design; Section 5,
Spreadsheets; Section 6, Database Management; Section 7,
Problem-Solving and Program Design; and Section 8, Program
Implementation.
The Project will carry 50 marks which will account for 25 per cent
of the final grade. This 50 marks will be distributed as follows: 10
for Word-Processing; 5 for Web Page Design; 10 for
Spreadsheets; 10 for Database Management; and 15 for
Problem-Solving. The project will be marked by the teacher in
accordance with CXC® guidelines and the marks should be
submitted to CXC®. The assignment should be administered as
specified in the instructions contained in the Guidelines to the
Conduct of the SBA, on pages 31–42.
CERTIFICATION
The subject will be examined for certification at the General Proficiency. The School-Based Assessment
component for this syllabus is aligned to selected units within the regional qualification of the
Caribbean Vocational Qualification (CVQ). Through this integration, once all requirements for issuing
the CVQ are met, every student with acceptable grades will receive a Statement of Competence to
recognize their competencies in selected units from the Level 1 Caribbean Vocational Qualification
(CVQ) in Data Operations – Level 1 (CCITI10106). The decisions to award competencies will be based
on the quality and relevance of the pieces of evidence presented for the occupational area.
In addition to an overall grade, there will be a profile report that reflects the performance of each
candidate under the following headings.
Productivity Tools The ability to apply standard features in the following areas:
CXC 30/G/SYLL 17 4
Problem-Solving and The ability to use analytical skills in the development of algorithms,
Programming expressed as flowcharts or pseudo code, that can then be implemented
as applications or computer programs.
1. It is the responsibility of schools presenting candidates for the examinations to ensure that
the required hardware and software are in place to achieve the syllabus objectives.
2. Candidates are advised to try out solutions to a variety of different problems on a computer
using a programming language of their choice; no particular programming language will be
assumed in this syllabus.
3. From the list provided below, teachers may select appropriate software for the Word-
Processing, Spreadsheets, Database Management, and Web Page Design components of the
syllabus.
CXC 30/G/SYLL 17 5
RECOMMENDED SOFTWARE
NOTES TO TEACHERS
1. Students should be aware of the input/process/storage/output cycle as it pertains to
hardware and software components in Section 1.
2. Section 7 should be taught before Section 8. Students should learn how to develop
algorithms before they are introduced to writing code in a programming language.
3. In Section 7, the focus should be on the development of solutions in the form of algorithms
(pseudocode/flowchart). The problem-solving skills acquired in this section serve as a
foundation for programming in Section 8.
(a) familiarise the student with the features of the recommended translator;
(b) identify and correct syntax errors;
(c) identify and correct logic errors; and,
(d) execute program and display results.
It is recommended that students develop the algorithms on paper before converting into
source code. This allows for more efficient utilization of computer time.
6. While it is expected that students will gain skills in the use of productivity tools through
practice on specific packages, teachers should ensure that students have an appreciation of
the generic operations of each of the productivity tools so that skills are transferable to
other packages.
7. Although not a requirement of the course, it may be useful to apprise students of the
history of computers.
CXC 30/G/SYLL 17 6
of recommended texts. However, the reading list provided is not exhaustive and additional
references should be consulted.
Resit candidates may enter through schools, recognized educational institutions or the Local
Registrar’s Office.
2. Paper 032 is a practical examination designed for candidates whose work cannot be monitored
by tutors in recognized educational and approved private institutions. The Paper will be of 2
hours’ duration and will consist of five questions. Questions will test the Productivity Tools and
Problem-Solving and Programming profiles.
3. Candidates entered for the examination through private institutions and who opt to complete
the SBA project must note the following:
(a) Candidates’ work must be monitored by tutors in the institution and feedback given
before the final assessment of that component. Tutors must also monitor candidates’
project to determine the veracity of work submitted. Tutors should not accept projects
which were not monitored during development. The marks recorded in the four
components will be collated to form the final SBA mark for submission by 30 April, in
the year of the examination.
(b) Marks must be submitted to the Caribbean Examinations Council on the School-Based
Assessment forms provided online. The forms should be submitted electronically via
the SBA data capture module on the Online Registration System (ORS) on the Council’s
website. Candidates who do not fulfil the requirements for the School-Based
Assessment will be reported as “ungraded”.
(c) Candidates as well as tutors must retain a copy of the completed component as part
of their portfolio.
CXC 30/G/SYLL 17 7
SECTION 1: COMPUTER FUNDAMENTALS AND INFORMATION
PROCESSING
GENERAL OBJECTIVES
1. develop an understanding of the fundamental hardware and software components and the
interrelationship among them;
3. explain the functions of the major Major components: input, central processing
hardware components of a computer unit, primary memory (RAM and ROM),
system; secondary storage, output.
CXC 30/G/SYLL 17 8
SECTION 1: COMPUTER FUNDAMENTALS AND INFORMATION PROCESSING (cont’d)
4. explain how the major hardware Input processing output storage (IPOS) cycle.
components of a computer system
interrelate;
5. evaluate the relative merits of cloud Definition of cloud and local storage.
storage and local storage; Assessment criteria: capacity, cost,
accessibility; security issues.
6. select appropriate input/output devices Associate the following devices with suitable
to meet the needs of specified applications:
applications;
(a) Input: Optical mark reader (OMR),
character readers (OCR, MICR), mouse,
joystick, bar code reader, document
scanner, light-pen, touch terminals,
voice response unit, Touch Screens
(tablets, point of sale, ATM), keyboard,
digital camera, biometric systems,
sensors, remote control, sound capture,
pointing devices, webcam.
7. explain the role of the different types of System Software: Operating System, Utilities.
software in computer operation;
Application software: general-purpose and
special-purpose; integrated package; source:
off the shelf, custom-written, and customized.
8. discuss the relative merits of the various Hardware: touch screens, specialized
types of user interface; keyboards.
CXC 30/G/SYLL 17 9
SECTION 1: COMPUTER FUNDAMENTALS AND INFORMATION PROCESSING (cont’d)
Criteria:
10. troubleshoot basic computer hardware Cable problems (for example, loose cables).
problems;
Monitor problems (for example, improperly
adjusted monitor controls).
11. distinguish between data and Data as raw unprocessed facts; information as
information; processed data.
CXC 30/G/SYLL 17 10
SECTION 1: COMPUTER FUNDAMENTALS AND INFORMATION PROCESSING (cont’d)
15. select appropriate file organization for File access methods: sequential, serial, direct
particular application. and random.
To facilitate students’ attainment of the objectives of this Section, teachers/facilitators are encouraged
to engage students in the teaching and learning activities below.
2. Arrange visits to local Computer Technology businesses to expose students to different system
specifications needed, for example, running a video game, web browsing, graphic design,
video editing, and desktop publishing.
3. Teachers should arrange for practical sessions in a computer laboratory. After demonstrations
by the teacher and/or professional, students should be arranged in pairs to carry out activities
such as attaching a monitor, keyboard, and mouse to the computer’s system unit, fixing loose
cables, and changing printer cartridges.
4. Use a video tutorial to illustrate the various types of user interfaces. Allow students to identify
merits of using each interface.
CXC 30/G/SYLL 17 11
SECTION 1: COMPUTER FUNDAMENTALS AND INFORMATION PROCESSING (cont’d)
5. Organize students in groups and assign the task of collecting samples of the different
categories of input and output devices. They should then set up an exhibition area and be
encouraged to invite the school population to visit booths.
7. Allow students to mount a display on the major types of computers systems, using pictures
and other relevant information.
8. Encourage students to create a scrapbook with samples of information, data, sources of data
and information, as well as different document types.
9. Arrange visits to local archives, libraries and media houses to expose the students to the work
of appropriate file organization and access.
10. Engage students in activities during a class session to write scenarios for their colleagues to
identify the appropriate data verification and validation checks that should be applied.
CXC 30/G/SYLL 17 12
SECTION 2: COMPUTER NETWORKS AND WEB TECHNOLOGIES
GENERAL OBJECTIVES
CXC 30/G/SYLL 17 13
SECTION 2: COMPUTER NETWORKS AND WEB TECHNOLOGIES (cont’d)
Hyperlinks.
Web Server.
Web Page.
Web Browser.
Email.
To facilitate students’ attainment of the objectives of this Section, teachers/facilitators are encouraged
to engage students in the teaching and learning activities below.
2. Engage students in a matching activity where they match the functions of the basic
components of a network.
3. Engage students in role play activities where they illustrate how the different networks
operate.
4. Invite someone with expertise in computer networks and web technologies to address the
class and explain some of the concepts.
CXC 30/G/SYLL 17 14
SECTION 3: SOCIAL AND ECONOMIC IMPACT OF INFORMATION AND
COMMUNICATIONS TECHNOLOGY (ICT)
GENERAL OBJECTIVES
1. develop an understanding of the various elements of computer security, and data misuse and
the impact on individuals and organizations;
3. assess the impact of technological advancements on different fields, disciplines and jobs.
CXC 30/G/SYLL 17 15
SECTION 3: SOCIAL AND ECONOMIC IMPACT OF INFORMATION AND COMMUNICATIONS
TECHNOLOGY (ICT) (cont’d)
4. assess the effect of automation on job Job loss vs productivity gains in skilled and
security; unskilled job categories.
CXC 30/G/SYLL 17 16
SECTION 3: SOCIAL AND ECONOMIC IMPACT OF INFORMATION AND COMMUNICATIONS
TECHNOLOGY (ICT) (cont’d)
For example:
CXC 30/G/SYLL 17 17
SECTION 3: SOCIAL AND ECONOMIC IMPACT OF INFORMATION AND COMMUNICATIONS
TECHNOLOGY (ICT) (cont’d)
To facilitate students’ attainment of the objectives of this Section, teachers/facilitators are encouraged
to engage students in the teaching and learning activities below.
2. Allow students to observe short clips about various forms of computer systems misuse (for
example, hacking and identity theft) then engage in discussions on cybersecurity.
3. Encourage students to write a report to be placed on the school’s notice board to describe the
threats associated with each specific vulnerability discussed in class.
5. Engage students in a poster-making competition in which they illustrate good personal security
practices.
6. Engage students in a web quest where they explore different scenarios that will culminate in
obtaining authentic and reliable online sources.
7. Engage students in a debate where they explore the implications of companies utilizing
automated kiosks to transact business. Have students discuss the effects of job loss versus
productivity gained in skilled and unskilled categories.
8. Engage students in a project where they visit/research various businesses to determine the
extent to which technology is being used in different positions.
9. Have students conduct research on cybersecurity and then present their information in a panel
discussion format. (Students should be able to pose questions to the panel members).
CXC 30/G/SYLL 17 18
SECTION 4: WORD-PROCESSING AND WEB PAGE DESIGN
GENERAL OBJECTIVES
1. have hands-on experience in the use of Word-Processing and Web Page Design in the
development of computer-generated documents; and,
WORD-PROCESSING
2. use appropriate document formatting Formatting features: font types and sizes,
features; colour, underline, bold, italics, superscript and
subscript, tab stops, bullets and numbering,
line spacing, justification (left, right, centre,
full), highlight, uppercase, word wrap, page
size, margins, page and section breaks, page
numbers, headers, footers, footnotes and
endnotes.
3. use appropriate editing features to Drag and drop editing: perform block
structure and organize a document; operations on selected areas of text within a
document.
CXC 30/G/SYLL 17 19
SECTION 4: WORD-PROCESSING AND WEB PAGE DESIGN (cont’d)
WORD-PROCESSING (cont’d)
4. use the review feature of a word Spell and grammar check, thesaurus, word
processor to enhance document count, language setting, comments, and track
readiness; changes.
5. appropriately use features that allow Automatic save and backup copy, edit
the protection of a document; restrictions – password protection.
7. use mail merge feature in the Creation of primary documents and data files
preparation of a document for a in mail merge application.
variety of situations;
Field names.
8. create a fillable electronic form for Use of content controls, such as check boxes,
online use; text boxes, date picker, drop-down lists, and
command buttons.
This section provides students with hands-on experience in the use of web design tools to create a
simple website.
10. create simple web pages using a Choosing an appropriate design for a page.
variety of design features;
Inserting and deleting text and graphics.
(The use of HTML coding is not
required.) Wrap text with image.
CXC 30/G/SYLL 17 20
SECTION 4: WORD-PROCESSING AND WEB PAGE DESIGN (cont’d)
12. evaluate a website for accuracy, user Considerations for publishing a website:
friendliness and effective display.
Verify that all the hyperlinks work correctly.
3. Arrange for students to perform the duties of the School Secretary for the Week, for example,
students should prepare: notices for parent conferences, gate/corridor passes, and letters
seeking sponsorship for a school activity.
4. Organize students in small groups to develop and create club or school web pages using a word
processor or free online web services. Investors and/or Stakeholders should be invited to
critique as students give their presentations.
5. Demonstrate how to add the Developer tab in different productivity tools to access Visual Basic
for Applications (VBA) (for example, Microsoft Excel or Word).
CXC 30/G/SYLL 17 21
SECTION 5: SPREADSHEETS
GENERAL OBJECTIVE
On completion of this Section, students should develop expertise in the use of a spreadsheet package
in the development of computer applications.
3. use basic pre-defined systems Including sum, average, date, max, min, count,
functions; counta, countif, vlookup, pmt, if.
6. manipulate columns and rows; Insert, delete and modify columns and rows.
CXC 30/G/SYLL 17 22
SECTION 5: SPREADSHEETS (cont’d)
8. perform charting operations; and, Select appropriate chart types: Column charts,
Bar charts, line graphs, pie charts.
To facilitate students’ attainment of the objectives of this Section, teachers/facilitators are encouraged
to engage students in the teaching and learning activities below.
1. Teachers should engage students in using feedback on class activities towards completing their
SBA.
2. Encourage students to complete exercises that use functions and formulas to effect a more
efficient and effective solution.
3. Demonstrate examples of locating text and data on a spreadsheet so that data is not lost if
rows or columns are inserted or deleted.
4. Encourage students to practise pasting versus moving various types of charts to a new sheet;
inserting titles and axes labels. Students should also practise pasting charts to a word-
processed document and adjusting the chart on the page.
5. Encourage students to practise entering test data for their programs to see the results and
reinforce these concepts from Sections 7 and 8.
CXC 30/G/SYLL 17 23
SECTION 6: DATABASE MANAGEMENT
GENERAL OBJECTIVES
On completion of this Section, students should develop expertise in the design of a database
management system in the development of computer applications.
Purpose of database.
(b) Queries:
CXC 30/G/SYLL 17 24
SECTION 6: DATABASE MANAGEMENT (cont’d)
(c) Reports:
To facilitate students’ attainment of the objectives of this Section, teachers/facilitators are encouraged
to engage students in the teaching and learning activities below.
1. Highlight various paper-based databases of which students may be aware and discuss
advantages of digitizing these paper-based records. From the discussion, have students
generate definitions of a database and terminologies associated with a database.
2. Engage students in exercises where they create database tables and practise changing the
general properties of database tables.
3. Engage students in activities where they practise manipulating table-editing features such as
sorting, inserting and deleting records and fields.
4. Engage students in activities where they use given criteria to create simple queries that will
pull specific records from a table or tables.
5. Engage students in activities where they create presentable reports based on tables and/or
queries that can be distributed. Students should also practise generating additional report
details such as summary options.
CXC 30/G/SYLL 17 25
SECTION 7: PROBLEM-SOLVING AND PROGRAM DESIGN
GENERAL OBJECTIVES
CXC 30/G/SYLL 17 26
SECTION 7: PROBLEM-SOLVING AND PROGRAM DESIGN (cont’d)
7. test algorithms for correctness. Desk checks/dry run: construction and use of
trace tables to verify results. Trace tables
consist of variable names (identifiers) as
column headings and values in the cells, one
row for each pass.
To facilitate students’ attainment of the objectives of this Section, teachers/facilitators are encouraged
to engage students in the teaching and learning activities below.
1. Provide students with simple everyday scenarios which would allow them to practise the steps
in problem-solving and logical thinking. Examples of scenarios include giving directions to a
particular location; or determining which mode of transportation (for example, airplane,
bicycle, vehicle, walking) is best suited for travelling to a specific location based on weather
conditions; or determining which of three groups of CSEC® subjects (for example, languages,
sciences, arts) should be chosen given that a favourite subject is included in two of the groups.
CXC 30/G/SYLL 17 27
SECTION 7: PROBLEM-SOLVING AND PROGRAM DESIGN (cont’d)
2. Illustrate using everyday problems, such as finding the exit within a hotel or preparing a three-
course meal.
(c) combine the solutions to the sub-problems to generate the solution for the original
problem.
3. Present simple scenarios to help students appreciate the difference between variables and
constants by using everyday values such as the percentage of road tax, amount of school fees,
cost of bus tickets, cost of today’s lunch, or time taken to walk from one class to another.
4. Present students with visuals to encourage them to identify flowchart symbols (for example,
rectangular symbol to represent a process). Teachers can also use exercises to match
pseudocode statements with select symbols (for example, start of algorithm (start/stop
symbol), input (read/write symbol), and a condition (decision symbol).
5. Engage students in an activity to help them identify relational, logical and arithmetic operators
and how a decision is transformed into a flowchart symbol or a pseudocode statement using
suitable operators.
CXC 30/G/SYLL 17 28
SECTION 8: PROGRAM IMPLEMENTATION
GENERAL OBJECTIVES
Debugging techniques.
CXC 30/G/SYLL 17 29
SECTION 8: PROGRAM IMPLEMENTATION (cont’d)
To facilitate students’ attainment of the objectives of this Section, teachers/facilitators are encouraged
to engage students in the teaching and learning activities below.
1. Provide students with various examples of codes that represent high-level and low-level
programming languages.
2. Use programming examples to demonstrate to students the effect of not declaring variables,
constants, or arrays, and the advantage of initializing them to avoid processing erroneous
data.
3. Provide opportunities for students to practise identifying test data for sample programs to
understand the use of appropriate data (for example, negative, positive, or decimal values,
text) for declared variables and the types of errors produced as a result of incorrect input.
4. Encourage students to use the selected programming language to practise writing code for
simple applications based on flowcharts and pseudocode as practice towards their SBA
assignment.
CXC 30/G/SYLL 17 30
GUIDELINES FOR THE CONDUCT OF THE SCHOOL-BASED
ASSESSMENT
School-Based Assessment is an integral part of student assessment in the course covered by this
syllabus. It is intended to assist students in acquiring and using certain knowledge, skills and attitudes
that are associated with the subject. The activities for the SBA are linked to the syllabus and are part
of the learning activities to enable the student to achieve the objectives of the syllabus. Students are
encouraged to work in groups.
During the course of study for the subject, students shall obtain marks for the competence they
develop and demonstrate in undertaking their SBA assignments. These marks contribute to the final
marks and grades that are awarded to students for their performance in the examination.
The guidelines provided in this syllabus for selecting appropriate tasks are intended to assist teachers
and students in designing assignments that are valid for the purpose of SBA. These guidelines are
intended also to assist teachers in awarding marks that are reliable estimates of the achievement of
students in the School-Based Assessment component of the course. In order to ensure that the scores
awarded by teachers are in line with the CXC® standards, the Council undertakes the moderation of a
sample of the School-Based Assessment assignments.
The Caribbean Examinations Council seeks to ensure that the SBA scores are valid and reliable
estimates of accomplishment. Candidates are provided with the guidelines below in order to
successfully complete the SBA.
The School-Based Assessment seeks to provide students with the opportunity to demonstrate their
problem- solving and programming skills as well as their ability to use productivity tools effectively
in:
2. simulating a worksheet;
3. entering data, performing simple analysis on data and presenting data using a database
management tool; and,
ASSIGNMENT
The School-Based Assessment consists of one practical project consisting of five related components,
prepared and marked by the teacher in accordance with CXC® guidelines.
CXC 30/G/SYLL 17 31
The components will test Problem- Solving and Programming as well as the application of processes
involved in the use of Database Management, Spreadsheets and Word-Processing and Web Page
Design. The five components will therefore cover the Specific Objectives in Sections 4, 5, 6, 7 and
8.
Types of Projects
Teachers should develop assignments that expose the students to realistic applications which
involve, but are not limited to the following areas:
(a) business (for example, storing and managing employee, customer and sales records,
marketing);
(b) banking (for example, creation of different types of accounts, loans, interest, payments
on loans, fixed deposits, investments);
(d) entertainment (for example, analysis of data on distribution and sales of movies, music,
electronic games);
(e) environment (for example, records of storms and hurricanes over specific periods and
in named territories, calculation of cost of damage to infrastructure, housing, livestock,
farms);
(f) law enforcement (collection and management of crime statistics collection and analysis
of data on offenders, cost of maintaining prison populations);
(g) medicine (for example, managing patient records collection and analysis of data on diseases
over a period of time and in various locations);
(h) monitoring ( for example, analysis of data on accidents at intersections, counting and
categorising visitor arrivals in Caribbean territories); and,
(i) sports (for example, collection and processing of data on athletes’ sport meetings).
Word-Processing
This assignment should consist of the formatting, importing and/or documentation of information.
The assignment must be chosen from TWO of the following:
(a) a document containing a table of contents and/or prepared for mass mailing;
(b) use of templates (such as memos, reports, faxes, simple brochures, flyers) or newspaper
articles; and,
(c) a fillable form using the Developer. It should comprise no more than four controls (for example,
text box, drop-down list, check box or date picker). The controls can be used more than once
when designing the form. Manipulation of the controls should be limited to renaming labels
and prompts (tags), and adding drop-down list properties.
CXC 30/G/SYLL 17 32
Web Page Design
This assignment should be limited to one web page that is designed using a word processor or a free
online web service. Students can insert screenshots or create the design of the web page at the end of
the word-processed document. Alternatively, they can use the last page in their word-processed
document to paste the link to the online web page. Only the candidate number placed near the top of
the page should be used as a form of identification for the web page.
(b) defined areas on the page for navigational links and content; and,
link to another web page (which may or may not exist); and,
Spreadsheet
This assignment should be saved as one workbook (comprising two or more worksheets). The tasks
should be limited to:
(a) a maximum of TWO major tasks (for example, create the spreadsheet; modify the spreadsheet)
consisting of no more than THREE requirements (for example, sorting of data and use of
functions and formulas on data); and,
Database Management
This assignment should be saved as one database file. The tasks should be limited to no more than:
(b) TWO queries (using criteria from one table, and more than one table).
(d) ONE form, showing a main and sub-form (for example, to search for a record, or to move to
the next or previous record).
(e) ONE report, with grouping and sorting involving TWO or THREE tables.
CXC 30/G/SYLL 17 33
Problem-Solving and Programming
This assignment should use programming language selected by the centre. Examples include but are
not limited to:
(a) prompting for data entry with appropriate validation with suitable messages output to the
user; and,
Requirements Guidelines
Problem definition Students should provide the statement of the problem, that
part of the problem that was chosen for coding in the
spreadsheet.
Trace Table using test data Students are required to supply the test data that produced
the output. This information would be necessary to
determine whether the tasks have been performed correctly.
(b) Provide guidance throughout the life of the projects. The teacher should work with candidates
to develop a project management chart with definite timelines for achieving clearly
identified objectives, from project inception to project completion.
CXC 30/G/SYLL 17 34
(c) Guide students through the SBA by helping to clarify the problem or by discussing
possible approaches to solving the problem. Teachers, while giving guidance, should guard
against providing a complete solution to the problem for the candidate or prescribing a specific
format that should be followed.
(d) Assess student’s skills in problem- solving and algorithm development using flowcharts or
pseudocode, coding an algorithm using the selected programming language and the
effective use of productivity tools to perform prescribed activities. The development of
the project is a continuous exercise that occurs during scheduled class hours as well as
outside class times. At a time to be determined by the teacher the relevant component
will be assessed and the marks recorded. C opies of the completed documents should be
kept by both the teacher and students. The teacher should use the mark scheme provided
by CXC® and include any comments pertinent to the conduct of the assessment.
(e) Guide students through the SBA by helping to clarify the problem or by discussing
possible formats.
(f) Ensure that students are allowed sufficient access to equipment to allow successful
completion of their projects.
The project should be the size and complexity for candidates to satisfactorily complete during
the second year of the two-year course.
The WP and WBD, SS and DB sections of the project should each have approximately the same
number of tasks and degree of complexity such that each project requires the same amount of
preparation. The project should encompass some advanced processes in Sections 4, 5 and 6. Problem-
Solving and Program Implementation should be based on the project and not attempted in
isolation. It must, therefore, be an actual implementation of a simple aspect of the project.
Teachers are encouraged to design their School-Based Assessment at the commencement of the
academic year. This would allow for the completion of sections of the project as topics are addressed.
It is suggested that the Problem-Solving component be attempted when the teacher has completed
Section 7 of the syllabus, and the Program Implementation component at the completion of Section
8.
ASSESSMENT CRITERIA
The following is the mark scheme for assessing SBA assignments. Teachers must clearly indicate the
breakdown of the marks allocated for each question on the candidates’ SBA paper.
Note to Teachers: The marks for the WP and WPD, SS and DB are to be summed and divided by 2 in
order to provide the Productivity Tools mark out of 35.
CXC 30/G/SYLL 17 35
WORD-PROCESSING – Maximum of 20 marks
Since teachers may vary the focus of their SBA from year to year, the Word-Processing component
offers some choice. To obtain the 20 marks for Word-Processing, teachers may:
Choose TWO of the three features: tables, columns, and inserting/importing files. (2 marks
each)
Choose TWO of the three advanced features: Mail merge, table of contents and fillable
forms. (5 marks each)
CXC 30/G/SYLL 17 36
S4: SO6 Table of Contents (5)
Auto-generation of table of contents 1
In suitable location 1
At least TWO levels of headings 1
Suitable headings chosen (1 mark EACH) 2
CXC 30/G/SYLL 17 37
WEB-BASED DESIGN (10 marks)
SPREADSHEET – 20 marks
S5: SO4 Arithmetic formulas – 1 mark each for any THREE formulas (3)
Correct use of any THREE different formulas 3
CXC 30/G/SYLL 17 38
Specific The effectiveness with which candidate(s) use(s) or Mark Maximum
Objective manipulate Allocation marks per
sub-section
S5: SO7 Sorting data in the spreadsheet (1)
Data sorted in ascending/descending order as 1
required
CXC 30/G/SYLL 17 39
DATABASE MANAGEMENT – 20 marks
CXC 30/G/SYLL 17 40
PROBLEM-SOLVING AND PROGRAMMING (15 marks)
Processing
Request for data (prompt) 1
Storing data (reading data)
Appropriate and logical use of structures
– Selection 1
– Looping 1
S7: SO7 Trace table (4)
Variables identified in trace table 1
Appropriate test data 1
Changes in values correctly demonstrated 2
– Some errors in manipulating the trace 1
table
S8: SO2 Program Execution (1)
Working program 1
CXC 30/G/SYLL 17 41
PROCEDURES FOR REPORTING AND SUBMITTING SCHOOL- BASED ASSESSMENT
(a) Teachers are required to record the mark awarded to each candidate under the
appropriate profile dimension on the mark sheet provided by CXC®. The completed mark
sheets should be submitted to CXC® no later than 30 April of the year of the examination.
Note: The school is advised to keep a copy of all projects as well as copies of the mark
sheets.
(b) Teachers will be required to submit to CXC® electronic copies of the projects of a sample of
candidates as indicated by CXC®. This sample will be re-marked by CXC® for moderation
purposes.
Note: The SBA Data Capture Module of the Online Registration System (ORS) must be used
for the submission of ALL SBA marks.
The candidate’s performance on the project will be moderated. The standard and range of marks
awarded by the teacher will be adjusted where appropriate. However, the rank order assigned
by the teacher will be adjusted only in special circumstances and then only after consideration
of the data provided by the sample of marked projects submitted by the teacher and re-marked by
CXC®.
EQUIPMENT
The equipment should include an IBM-compatible computer with software that is capable of
integration among word-processing, spreadsheet and database management applications. CXC® will
not be responsible for partial assignments submitted due to software i n compatibility and/or
integration problems.
CXC 30/G/SYLL 17 42
RECOMMENDED TEXTS
Birbal, R. and Taylor, M. Log On to IT for CSEC. Essex: Pearson/Longman,
2005.
WEBSITES
http://www.gcflearnfree.org/subjects/technology/
http://www.excel-easy.com/vba.html
https://support.office.com/en-us/article/Create-a-fillable-form-39a58412-107e-426b-a10b-
ac44937e3a9f
http://bigdata-madesimple.com/5-advantages-and-disadvantages-of-cloud-storage/
https://www.saylor.org/site/textbooks/Information%20Systems%20for%20Business%20and%20Bey
ond.pdf
CXC 30/G/SYLL 17 43
GLOSSARY OF INFORMATION TECHNOLOGY CONCEPTS
WORD DEFINITION
Bar code A series of thick and thin black bars separated by spaces of
varying widths representing data.
Bistable device A device which can exist in two discrete stable states.
CXC 30/G/SYLL 17 44
WORD DEFINITION
Cloud Computing The use of a network of remote servers hosted on the Internet to
store, manage, and process data, rather than a local server or a
personal computer.
Cloud Storage A cloud computing model in which data is stored on remote servers
and can only be accessed via the Internet, or "cloud." It is
maintained, operated and managed by a cloud storage service
provider.
Data corruption The introduction of errors into data stored in a computer system.
Database Programs and database files that allow timely and easy controlled
management access to data by a number of users.
system
Ergonomics A field of study dealing with the comfort and safety of the human
body by adjusting different designs in equipment, furniture,
workstations and routines to fit the worker. (Ergonomics is used in
the workplace to help prevent repetitive injuries.)
CXC 30/G/SYLL 17 45
WORD DEFINITION
Hard disk A rigid disk used for storing data magnetically. Its rigid construction
allows for higher storage densities. Access times for a hard disk are
much faster than for floppy disks.
Home page The file available for access at a website intended chiefly to greet
visitors, provide information about the site, and direct them to other
sites with related information.
Internet The Internet is the largest computer network system in the world. It
consists of many smaller networks connected together by a global
public network. The Internet is often called the information
superhighway or cyberspace.
CXC 30/G/SYLL 17 46
WORD DEFINITION
Joystick An input device that uses a lever to control movement of the cursor
or graphic images.
Justification This is the adjustment of alignment of one or more lines of text with
a particular margin, for example, alignment with the left margin, the
right margin or both. The term justification often is used to refer to
full justification of the alignment of text along both margins.
Keyboarding The process of rapidly and accurately entering data into a computer
via the keyboard as an input device.
Light pen A light-sensitive input device which when it touches the screen
detects the presence or absence of light. It is used to select an entry
or indicate a position.
Magnetic disk A mylar (floppy disk) or metallic (hard disk) circular plate on which
electronic data can be stored magnetically. Suitable for direct or
random access data storage and retrieval.
Margins Space provided to the left, right, top and/or bottom of a page of text
or data.
CXC 30/G/SYLL 17 47
WORD DEFINITION
Merge The combination of two or more files on the basis of common field
(key field).
Microprocessor A single chip which contains the arithmetic/logic unit (ALU) and
the control unit (CU).
Multitasking The concurrent execution (at the same time) of two or more related
tasks. A group of cooperating tasks is executed simultaneously to
achieve a common goal.
Online The term is used to describe peripheral devices under the control of
the processor.
CXC 30/G/SYLL 17 48
WORD DEFINITION
Operating system A set of programs that control and supervise the resources of a
computer system. It also acts as an interface between the user and
the computer.
Point of sale A device that reads data at the source of a transaction (for
terminal example. a supermarket checkout) and stores it for subsequent
transmission directly to the computer system for processing.
Source code Program written in high level language or assembly level language.
Source document A document used for the initial recording of data relating to business
transactions. Very often source data needs to be converted into
machine-readable form for example, punched cards or paper tape,
before it can be processed by a computer.
CXC 30/G/SYLL 17 49
WORD DEFINITION
Touch terminal Also called a touch screen. A device that allows data to be input by
touching a screen with the finger or other object. The surface of
the screen consists of a number of programmed touch points each
of which may trigger a different action when selected by the user.
Upload Process of reading data from a user’s computer storage and sending
it to another computer via communication channels.
URL Each page on the World Wide Web has a unique address called the
Uniform Resource Locator (URL).
Verification Specific checks that ensure that the data entered matches (or is
identical to) the data at the original source.
CXC 30/G/SYLL 17 50
WORD DEFINITION
Web browser A programme that allows users to view and explore information on
the World Wide Web. Examples of popular browsers are Microsoft
Internet Explorer and Mozilla Firefox.
Web server A computer that delivers (serves up) Web pages. When a request is
made to access a website, the request is sent to the web server. The
server then fetches the page and sends it to your browser.
World Wide Web The World Wide Web commonly referred to as the ‘Web’, is a
(WWW) graphical easy-to-use system of inter-linked files on the Internet.
Vast amounts of information can be obtained through the use of the
www.
CXC 30/G/SYLL 17 51
GLOSSARY OF BEHAVIOURAL VERBS USED IN THE INFORMATION
TECHNOLOGY EXAMINATIONS
Analyse Examine key factors and constituent parts critically and in detail and
suggest possible results/outcomes.
Evaluate Explain the evidence for or against a given topic or concept and come
to a conclusion.
CXC 30/G/SYLL 17 52
Outline Give basic steps, organize information concisely to provide main
points or features only.
CXC 30/G/SYLL 17 53
APPENDIX
In preparation for the actual exercise, the Trinbarjam Elections Commission has hired you to simulate
the elections exercise as a test run, prior to the actual elections which are to take place shortly in your
country. You are required to utilize suitable word-processing, web page design, spreadsheet, database
management as well as a programming application to design and implement computer-based
solutions to the tasks involved in the simulation of the election process.
Spreadsheet
The Elections Commission has mandated that you design a spreadsheet that will accept pertinent data
on constituencies and candidates’ votes and generate information that would enable the outcome of
the elections to be divulged to the population in the shortest possible time. Four parties contest the
elections: The Democratic Action Party (DAP), the Workers National Alliance (WNA), the United
Progressive Movement (UPM), and the People’s Democratic Revolution (PDR). The spreadsheet is
design to accept data from seven constituencies.
Task 1
CXC 30/G/SYLL 17 54
constituency by a noted pollster. Each candidate in a given constituency has a
unique rating.)
Party name
You must enter data for each candidate in each of the seven constituencies. Use the Percentage Voter
Turnout data to determine the number of votes cast (number of voters * percentage voter turnout).
Task 2
Duplicate the Elections Data worksheet. Rename the duplicate as Elections Data Backup.
1. (Insert a column before the one which displays the name of the political party. Using an
appropriate column title, determine the votes received by each candidate in a given
constituency. The candidate’s rating represents the percentage of votes received by the
candidate in a given constituency. For example, given that 6400 votes were cast and a
candidate has a rating of 20, the votes received by the candidate would be 20/100*6400.
2. Sort the data first on party (ascending order) and secondly on votes received (descending
order).
Elections Data
Party Total Votes Received Percentage of Votes Cast
CXC 30/G/SYLL 17 55
Note the following:
Format the Percentage of Votes Cast to one decimal place with the percent symbol.
Centre the data in the worksheet.
Merge and centre the cells in the row with the label “Elections Data”
Create a pivot table showing the constituencies, the candidates’ names and the total number of votes
the candidates received.
Database Management
You are asked to use a suitable application to manage data on candidates nominated to contest seats
in the general elections. Three tables must be used to store the data. The table with relevant personal
data on each candidate should include: name, address, date of birth, gender, profession, constituency,
constituency number, party and votes received. The constituency data table should include: the
constituency name, constituency number and the number of voters in each constituency. An elections
data table should include: the constituency number and the percentage voter turnout for each
constituency.
The data to populate the tables must be sourced from the spreadsheet section of your project.
You should test your database by generating queries, reports and control forms:
Queries:
1. List the name, sex, age and profession of all candidates from the People’s Democratic
Revolution (PDR).
2. List the candidate name, party, number of voters and number of votes received for
candidates in constituencies with more than 6500 voters and where the candidates received
less than 1000 of the votes. Sort the data in descending order on the number of votes received
by the candidate.
3. Using a calculated field determine the total votes cast in each constituency.
Report
4. Generate a report which lists the constituency, number of voters in the constituency, name of
candidates, gender, party and number of votes received. The report should be grouped by
constituency. Within each constituency the report should be sorted in descending order by
number of votes received by each candidate. It should also give the total and average number
of votes in each constituency. The report should have a two-line title as follows:
“Official Results
Trinbarjam National Elections”
CXC 30/G/SYLL 17 56
Control Forms
5. Create a form to display information about the candidates.
Word-processing
Document 1
1. Each candidate must complete and submit a nomination form to the Trinbarjam Elections
Commission. You are required to:
(a) Design a fillable nomination form. It must allow for the entry of relevant data on the
candidate, including the constituency which he/she intends to contest.
(i) The letter head (with company Logo) of the Trinbarjam Elections Commission
should be placed at the top.
Document 2
2. The results of the national elections must be delivered to each candidate. Using a suitable
feature of your word processing application:
(a) Create a document which should be mailed to the candidates. The requirements for
the letter are:
(i) It must be design on letter sized paper and must have a 0.7” margin on the
left and right sides.
(ii) The commission’s letterhead (with company Logo) should be placed as the
header in the letter. The font in the letterhead should be appropriately
formatted for emphasis.
(iii) Candidate’s address.
(iv) Salutation.
(v) The first paragraph should congratulate and thank the candidates (insert
candidate’s name in the letter) for the manner in which he/she conducts his
or her campaign.
(vi) A summary table of results should be included with at least seven rows and
three columns, with appropriate formats.
(vii) The third paragraph inviting him/her to view the complete listing of the
results on the commission’s website and conclude the letter.
(viii) Close with your name, your position is Chief Electoral Officer.
CXC 30/G/SYLL 17 57
Data used in the web page should be sourced from the spreadsheet section of the project.
Problem-Solving
1. Develop an algorithm to print the names of the candidates who should receive a refund. A
refund is due if the candidate’s votes received equals or exceeds 20 per cent of the votes cast
in the constituency. The algorithm should also determine and print the number of candidates
who received a refund. Test the algorithm with data from ten candidates. The algorithm must
accept as input the names of the candidates, votes received and the votes cast in the
constituency. The algorithm should print the name of the candidate and the words “Refund
Due” or “No Refund” and the number of candidates who received a refund. Data to test the
algorithm must be sourced from the spreadsheet section of the project.
2. Design and execute a trace table to test the algorithm developed in question (1) above. The
table should have a maximum of ten iterations.
Program Implementation
1. (a) Develop a problem statement for the algorithm developed in question (1) above.
(b) Using the programming language Pascal or VBA, write code to implement/automate
the algorithm in question (1) above.
CXC 30/G/SYLL 17 58
CARIBBEAN EXAMINATIONS COUNCIL
INFORMATION TECHNOLOGY
INFORMATION TECHNOLOGY
TABLE OF SPECIFICATIONS
1. Theory
Theory 35
TOTAL no. 60 60
of ITEMS
PAPER QUESTION PROFILE COGNITIVE LEVEL NUMBER TOTAL
OF MARKS PER
MARKS SECTION
Theory Knowledge and 8
1. Comprehension 20
Productivity Tools
Use of Knowledge 12
TOTAL no. 50 50
of MARKS
CANDIDATE – PLEASE NOTE!
01229010
PRINT your name on the line below and return
this booklet with the answer sheet. Failure to doTEST CODE
so may result in disqualification.
SPEC 2017/01229010
CAR I B B EAN E XAM I NAT I O N S C O U N C I L
INFORMATION TECHNOLOGY
1. This test consists of 60 items. You will have 1 hour and 15 minutes to answer them.
3. Each item in this test has four suggested answers lettered (A), (B), (C), (D). Read each item
you are about to answer and decide which choice is best.
4. On your answer sheet, find the number which corresponds to your item and shade the space
having the same letter as the answer you have chosen. Look at the sample item below.
Sample Item
The best answer to this item is “Spreadsheet and database software”, so (A) has been shaded.
5. If you want to change your answer, erase it completely before you fill in your new choice.
6. When you are told to begin, turn the page and work as quickly and as carefully as you can. If
you cannot answer an item, go on to the next one. You may return to that item later.
01229010/CSEC/SPEC2017
- 2 -
1. When the computer is working on given 5. Which of the following storage media
instructions, it is called uses laser technology to store data?
2. Which of the following types of 6. Which of the following is an example of
computers would process information at an embedded computer system?
the fastest rate?
(A) Desktop
(A) Embedded (B) IBM z system
(B) Super computer (C) Smart television
(C) Main Frames (D) Laptop
(D) Mobile devices
7. Which of the following input devices is
3. Which of the following are functions of used to read pencil or pen marks on a
the control unit? multiple choice answer sheet?
I. Read instruction (A) OCR
II. Direct operations (B) OMR
III. Execute instruction (C) POS
(D) MICR
(A) I and II only
(B) I and III only
(C) II and III only 8. The MOST suitable device for the output
(D) I, II and III of architectural drawings is a
(A) plotter
4. Which of the following is a disadvantage (B) laser printer
of cloud storage? (C) graphics tablet
(D) light pen
(A) Accessibility (offline/without
internet)
(B) Reduction of storage cost to 9. Which of the following output is an
organization example of a hard copy?
(C) Increased possibility for disaster
recovery (A) An oral speech delivered by a
(D) Efficient management of stored speaker
data (B) A bill produced from a printer
(C) The display on a monitor
(D) A picture on a wall produced
from a multimedia projector
10. Which of the following tasks would MOST 14. Desreen has a desktop computer system.
likely require an advance graphics card? She turns on the system and waits five
minutes but no image is displayed. During
(A) Program development troubleshooting, which of the following is
(B) Web browsing MOST likely to be identified as the
(C) SBA development problem?
(D) Video editing
(A) Keyboard is disconnected
(B) The power cable to the monitor is
11. In modern computers, the CPU speed is loose
measured in (C) The battery power connected to the
system is loose
(A) kilohertz (D) Touchscreen is disabled
(B) gigabytes
(C) kilobytes
(D) gigahertz 15. Which of the following is the name of
the interface used by blind persons to
perform operations on a computer?
12. Quality Developers is a company that
writes programs to do specific jobs for (A) Icon
other companies. These programs are (B) Sensor
called (C) Braille
(D) Touchscreen
(A) general-purpose software
(B) special-purpose software
(C) custom-purpose software 16. John is required to email a copy of his
(D) off-the-shelf software SBA to his teacher. This emailed copy is
referred to as
18. Which of the following would be the BEST 23. Each website on the Internet can be accessed
option to expand your laptop’s storage by entering a unique address. This address
capacity? is referred to as the
20. Which of the following statements BEST 25. Teachers are able to mark class registers
describes the term 'information'? online and provide instant feedback on
assessment through the use of
(A) It is raw facts.
(B) It is meaningful. (A) social media tools
(C) It does not have any value. (B) m-learning devices
(D) It is not the result of processing. (C) simulation software
(D) computer assisted learning
(A) blogging
(B) instant messaging
(C) Internet relay chat
(D) file transfer protocol
27. You received an email from someone who 31. Which of the following is a job task of a
claims to be a representative from your social media specialist?
school. The email asked you to click on a
link to reset your password. You should (A) Maintaining a website
proceed with caution because the email (B) Developing software for social
may be a use
(C) Installing or upgrading social
(A) spam threat media software on a computer
(B) malware attack system
(C) phishing attack (D) Generating and sharing content
(D) legitimate request daily over a social media network
28. Using electronic devices to view a chat 32. Which of the following are physical
conversation between two friends, in real restrictions with respect to data security?
time, without their knowledge is
I. Firewall
(A) propaganda II. Locking up the hardware
(B) a violation of privacy III. Biometric systems
(C) a denial of service attack
(D) an electronic eavesdropping (A) I and II only
(B) I and III only
(C) II and III only
29. The use of “*********” to hide a password (D) I, II and III
being entered into a computer system is
termed
33. Which of the following actions is NOT
(A) antivirus considered a computer crime?
(B) phishing
(C) biometrics (A) Piracy
(D) encryption (B) Hacking
(C) Encryption
(D) Industrial espionage
30. In an effort to secure data on a system, users
are required to set a password in a specific
format. Which of the following types of 34. Including material obtained from online
measures is this an example of? sources in an assignment and then
submitting the assignment without giving
(A) Physical credit to the online sources is referred to as
(B) Software
(C) Hardware (A) plagiarism
(D) Personal (B) e-learning
(C) fraternization
(D) collaboration
35. Telecommuting can BEST be described as 39. Which of the following should be done
before publishing a website?
(A) communicating between two
companies (A) Compile the source code.
(B) working from home by (B) Create the algorithm for the
connecting home and office website.
(C) working from home by (C) Ensure that all hyperlinks are
having employees at home working correctly.
(D) communicating between home and (D) Purchase the software needed
office to develop the website.
36. In word processing, an efficient way to 40. What is the name of the highlighted word
move the third paragraph in order to place or picture in a webpage that a user can click
it after the fifth paragraph is on to go to another webpage?
37. The two files used to produce merged letters 41. Text entered into a spreadsheet is aligned
during a mail merge are the towards the left by default. These entries
are called
(A) primary document and data
source (A) labels
(B) primary document and (B) values
merged letters (C) formulae
(C) data source and merged (D) functions
letters
(D) primary document and
current letter 42. Which of the following formatting features
is unique to numbers in spreadsheets?
38. Which of the following should be (A) Bold
considered when creating a website? (B) Italics
(C) Custom
(A) Cost of each webpage (D) Indent
(B) Position of the homepage in
the website
(C) Compiler needed to develop 43. To centre the title rows of a spreadsheet
the website across the columns
(D) Intended audience for the
website (A) centre align the title rows
(B) centre align the title columns
(C) merge and centre the title rows
(D) merge and centre the title columns
44. Which of the following is an example of 48. Which database feature can be used to
a spreadsheet function? list the names of the male students from
a particular class?
(A) function sum(A1, A2, A3)
(B) sum = A1 + A2 + A3 (A) Table
(C) = sum(A1:A3) (B) Form
(D) = A1 + A2 + A3 (C) Query
(D) Report
47. A field in a table that appears as a match 51. The following variables s, t and u, have
of the primary key in another table is been assigned the values shown.
called a
s = 5
(A) foreign key t=6
(B) candidate key u=3
(C) secondary key
(D) composite key Which of the following statements does
NOT evaluate to true?
(A) u > 7 and t < = 7
(B) s < t or u < = s − 2
(C) t <> 4 or s = 5
(D) u – 2 >= 1
52. Based on the following algorithm, what 54. The representation of the pseudocode
would be displayed for k? statement “Read number” in a flowchart
symbol is
j=5
k=j
j=j+k
k=j+3
display k
(A) 10
(B) 11
(C) 13
(D) 14
(D) f=6
while f < 3 56. Which of the following are high-level
display f languages?
f=f–1
I. Pascal
II. COBOL
III. ASSEMBLY
(A) I and II only
(B) I and III only
(C) II and III only
(D) I, II and III
57. Program implementation involves a 59. Errors that occur in a program when the
number of steps. Which of the following rules of the programming languages are
steps is NOT legitimate? NOT obeyed are called
(A) Linking (A) syntax errors
(B) Bonding (B) logical errors
(C) Executing (C) run-time errors
(D) Compiling (D) execution errors
58. Which of the following languages is only 60. Which of the following is an example of a
understood by computers? conditional construct?
(A) 4 GLs (A) For – Next
(B) Machine language (B) For – endfor
(C) Natural language (C) If – then– else
(D) Procedural language (D) While – endwhile
END OF TEST
IF YOU FINISH BEFORE TIME IS CALLED, CHECK YOUR WORK ON THIS TEST.
01229010/CSEC/SPEC/2017
DO
NO
W T
RI
TE
TH ON
IS
PA
G E
DO
NO
W T
RI
TE
TH ON
IS
PA
G E
CANDIDATE’S RECEIPT
INSTRUCTIONS TO CANDIDATE:
TEST CODE: 0 1 2 2 9 0 1 0
PROFICIENCY: GENERAL
REGISTRATION NUMBER:
Signature: ____________________________________________________________________
Date: ________________________________________________________________________
2. Ensure that this slip is detached by the Supervisor or Invigilator and given to you when you
hand in this booklet.
INSTRUCTION TO SUPERVISOR/INVIGILATOR:
Sign the declaration below, detach this slip and hand it to the candidate as his/her receipt for this booklet
collected by you.
I hereby acknowledge receipt of the candidate’s booklet for the examination stated above.
Signature: _____________________________
Supervisor/Invigilator
Date: _________________________________
Syllabus Syllabus
Question Key Profile Question Key Profile
Objective Objective
1 C 1.4 P1 31 D 3.5 P1
2 B 1.2 P1 32 D 3.5 P1
3 C 1.3 P1 33 A 3.2 P1
4 A 1.5 P1 34 A 3.6 P1
5 C 1.3 P1 35 B 3.6 P1
6 C 1.2 P1 36 A 4.3 P2
7 B 1.6 P1 37 A 4.7 P2
8 A 1.6 P1 38 D 4.9 P2
9 B 1.6 P1 39 C 4.12 P2
10 D 1.9 P1 40 C 4.11 P2
11 D 1.9 P1 41 A 5.2 P2
12 B 1.7 P1 42 D 5.7 P2
13 D 1.8 P1 43 D 5.6 P2
14 B 1.10 P1 44 C 5.2 P2
15 C 1.8 P1 45 C 5.1 P2
16 A 1.11 P1 46 B 6.2 P2
17 C 1.13 P1 47 D 6.2 P2
18 B 1.4 P1 48 C 6.4 P2
19 C 1.14 P1 49 B 6.2 P2
20 B 1.11 P1 50 C 6.2 P2
21 A 2.1 P1 51 A 7.1 P3
22 D 2.4 P1 52 C 7.8 P3
23 D 2.4 P1 53 D 7.8 P3
24 C 2.2 P1 54 C 7.6 P3
25 D 2.3 P1 55 A 7.4 P3
26 B 3.2 P1 56 D 8.3 P3
27 C 3.1 P1 57 B 8.2 P3
28 D 3.2 P1 58 B 8.1 P3
29 D 3.3 P1 59 A 8.3 P3
30 B 3.3 P1 60 C 8.5 P3
CARIBBEAN E XAM I NAT I O N S COUNCIL
TEST CODE 0 1 2 2 9 0 2 0
PROFICIENCY GENERAL
REGISTRATION NUMBER
SCHOOL/CENTRE NUMBER
NAME OF SCHOOL/CENTRE
DATE OF BIRTH D D M M Y Y Y Y
Current Bar Code
SIGNATURE __________________________________________________
‘‘*’’Barcode Area”*”
Sequential Bar Code
DO
NO
W T
RI
TE
TH ON
IS
PA
GE
TEST CODE 01229020 SPEC/2017
SPEC 2017/01229020
CARIBBEAN E XAM I NAT I O N S COUNCIL
INFORMATION TECHNOLOGY
2 hours
4. If you need to rewrite any answer and there is not enough space to do so on the
original page, you must use the extra lined page(s) provided at the back of this
booklet. Remember to draw a line through your original answer.
5. If you use the extra page(s) you MUST write the question number clearly
in the box provided at the top of the extra page(s) and, where relevant,
include the question part beside the answer.
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
Answer ALL questions.
1. Elaine wants to place her gluten-free recipes on the Internet and access them using a web address.
She wants users to register in order to access her recipes and plans to store their information in an
online database. She also needs to manage any emails and interact with her online clients when
new recipes are uploaded.
(a) State the name of the computer-related professional that would be most suitable for
.............................................................................................................................................
.............................................................................................................................................
(2 marks)
.............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
(2 marks)
(c) Elaine soon receives hundreds of emails with strange email addresses and other requests
to visit other websites. Explain two security practices that she should consider before
responding to these emails.
.................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
.................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
(4 marks)
(d) Describe two measures that can be used to prevent against software attacks on Elaine’s
website.
.............................................................................................................................................
.............................................................................................................................................
.............................................................................................................................................
(2 marks)
(e) Users’ data are stored in an online database. Apart from first and last name, list two fields
that should be used to capture data on users who register for Elaine’s recipes.
.............................................................................................................................................
.............................................................................................................................................
.............................................................................................................................................
(2 marks)
(f) Elaine wants to extract some information from the database. Complete the table by
selecting the most suitable database feature from the list below.
Calculated
Form Query Report Sort
Field
(4 marks)
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
(g) A user searches for Elaine’s recipes and locates the following layout:
.............................................................................................................................................
.............................................................................................................................................
a web address
.............................................................................................................................................
.............................................................................................................................................
an email address
.............................................................................................................................................
.............................................................................................................................................
a hyperlink
.............................................................................................................................................
.............................................................................................................................................
(4 marks)
Total 20 marks
2. John Taylor is the systems administrator at St Joseph’s High School. He has been asked by the
principal to prepare a report that will show the requirements for the computers and other equipment
to be purchased for a new computer lab.
(a) List ANY FOUR of the major components that each computer system should have.
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
(2 marks)
(b) State the function of ANY ONE of the major components of a computer system.
..............................................................................................................................................
..............................................................................................................................................
(1 mark)
(c) John intends to create a network that spans the computer lab. State the name of the type
of network that he needs to create.
..............................................................................................................................................
..............................................................................................................................................
(1 mark)
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
(d) In preparing his report, John uses the Internet to assist him in finding the specifications of
computers best suited for the computer lab.
Discuss ANY TWO approaches he could use to evaluate the reliability of the information
he retrieves.
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
(6 marks)
The required report must include a well-organized spreadsheet outlining all the needs of the lab,
and the expected costs in terms of equipment. The incomplete spreadsheet is shown below.
A B C D
1 Expected Costs for New Computer Lab
2 Description Item Units Cost per Unit Total
3 Student computer 30 $ 5 , 000.00
4 Computer Table 30 $ 800.00
5 Teacher Computer 1 $ 5,500.00
6 Teacher Table 1 $ 750.00
7 Student Chairs 30 $ 500.00
8 Teacher Chairs 1 $ 650.00
9 20ft UTP Cabling 15 $ 80.00
10 Projector 1 $ 3,000.00
11 Screen 1 $ 2,400.00
12 White board 2 $ 380.00
13 TOTAL Expected Costs
14
15 Average Item Cost
(i) State the name of the formatting feature used to achieve this.
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
(2 marks)
(ii) Write the text for the formula to be inserted in D3 to calculate the TOTAL cost for
student computers.
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
(2 marks)
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
(iii) Write the text for the function to be inserted in D13 to calculate the TOTAL expected
costs.
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
(2 marks)
(iv) Write a function that would insert the average cost per unit of an item in cell B15.
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
(2 marks)
(v) John decides that he wants the rows reorganized so that they are in order of the
most expensive to the least expensive.
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
(2 marks)
Total 20 marks
3. Kara wants to buy a $350.00 costume for the upcoming carnival. She decides to sell some cakes
in order to raise the funds for the costume.
(a) (i) Kara’s friend ordered some cakes. Write an algorithm using pseudocode to prompt
for the quantity of cakes ordered, then calculate and output the total, if the price
for each cake is $5.00.
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
(6 marks)
(ii) Kara sold 25 cakes at $5.00 each. Explain how Kara would determine whether
she has raised enough funds to purchase her costume.
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
.................................................................................................................................
(4 marks)
GO ON TO THE NEXT PAGE
01229020 SPEC/2017
‘‘*’’Barcode Area”*”
Sequential Bar Code
- 12 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
(b) Kara wants to create the spreadsheet shown below to track the orders placed for the
items.
A B C D E F
1 Cost of
Costume
2 $350.00
3 Date Item Cost Quantity Total Due
Ordered
(i) Using the spreadsheet above, write the functions and/or formulas in cell E8 or E9
to illustrate whether Kara has raised enough funds.
......................................................................................................................
.................................................................................................................................
(6 marks)
(ii) Write the function that would be entered in cell E10 to output ‘Yes’ if Kara would
be able to purchase the costume, or ‘No’ if she has not raised enough funds.
......................................................................................................................
.................................................................................................................................
(3 marks)
(iii) Kara wants to insert another order for 10 July, in row 4. Explain what would
happen to the data in row 4.
......................................................................................................................
.................................................................................................................................
(1 mark)
(c) Kara does not want others to see her sales from the cakes. Explain how she could protect
her spreadsheet.
..............................................................................................................................................
..............................................................................................................................................
(1 mark)
(d) Kara is now very interested in learning more about spreadsheets. The courses that she
prefers are offered during the day. Since she works during the day, she cannot register for
them.
Suggest, with reasons, two other options that Kara could consider in order to take a similar
course.
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
(4 marks)
Total 25 marks
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
4. (a) A local area network may be wired or wireless. Jennifer has a small apartment and has
decided to set up a network that will connect all the devices in her home that she uses
frequently. These devices are
• 1 desktop computer
• 1 laptop computer
• 1 android cellphone
• 1 android tablet
• 1 printer.
Draw lines that correctly map the devices on the left side of the table to the explanation
on the right side of the table.
(5 marks)
GO ON TO THE NEXT PAGE
01229020 SPEC/2017
‘‘*’’Barcode Area”*”
Sequential Bar Code
- 15 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
(b) Explain ONE advantage and ONE disadvantage of using a wireless network over a wired
network.
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
(4 marks)
(c) State the name of the protocol (technology) most commonly used to provide wireless
computer networking in a home or office.
..............................................................................................................................................
..............................................................................................................................................
(1 mark)
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
(d) Algorithms are used to express the steps required to solve a problem. Write an algorithm
using simple pseudocode to do the following
Please enter positive integers one at a time and “–1” to indicate no further input.
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
............................................................................................................................................
(10 marks)
GO ON TO THE NEXT PAGE
01229020 SPEC/2017
‘‘*’’Barcode Area”*”
Sequential Bar Code
- 17 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
Begin
Declare selected, number, count
count = 0
print “enter your integers”
read number
selected = number
while (count < 10)
if(number < selected)
selected = number
count = count+1
read number
end while
print selection
End
State the problem the algorithm solves and explain how it solves it.
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
.............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
(5 marks)
Total 25 marks
END OF TEST
IF YOU FINISH BEFORE TIME IS CALLED, CHECK YOUR WORK ON THIS TEST.
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
EXTRA SPACE
If you use this extra page, you MUST write the question number clearly in the box provided.
Question No.
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
01229020 SPEC/2017
‘‘*’’Barcode Area”*”
Sequential Bar Code
DO
NO
W T
RI
TE
TH ON
IS
PA
GE
CANDIDATE’S RECEIPT
INSTRUCTIONS TO CANDIDATE:
TEST CODE: 0 1 2 2 9 0 2 0
PROFICIENCY: GENERAL
REGISTRATION NUMBER:
Signature: ____________________________________________________________________
Date: ________________________________________________________________________
2. Ensure that this slip is detached by the Supervisor or Invigilator and given to you when you
hand in this booklet.
INSTRUCTION TO SUPERVISOR/INVIGILATOR:
Sign the declaration below, detach this slip and hand it to the candidate as his/her receipt for this booklet
collected by you.
I hereby acknowledge receipt of the candidate’s booklet for the examination stated above.
Signature: _____________________________
Supervisor/Invigilator
Date: _________________________________
01229020/KMS/MAY/SPEC 2017
C A R I B B E A N E X A M I N A T I O N S C O U N C I L
INFORMATION TECHNOLOGY
SPECIMEN PAPER
2017
- 2 -
01229020/KMS/SPEC 2017
Information Technology
Paper 02 – General Proficiency
Key and Mark Scheme
SPECIMEN PAPER
SECTION I
email address
types of recipes user requests
country 2
username
TOTAL 20
- 3 -
01229020/KMS/SPEC 2017
Information Technology
Paper 02 – General Proficiency
Key and Mark Scheme
SPECIMEN PAPER
(ii) =B4*C4
1 mark Correct cells
2
1 mark for *
(iii) =Sum(D4:D13))
[1 for correct function and 1 for correct
2
parameter in the function]
- 4 -
01229020/KMS/SPEC 2017
Information Technology
Paper 02 – General Proficiency
Key and Mark Scheme
SPECIMEN PAPER
TOTAL 20
- 5 -
01229020/KMS/SPEC 2017
Information Technology
Paper 02 – General Proficiency
Key and Mark Scheme
SPECIMEN PAPER
Declarations and
Price = 5.00 1 mark
initialisation
Prompt “Enter
Prompt 1 mark
Quantity”
Correct calculation of
TotalDue = Quantity total due
2 marks
* Price Error in
calculation -1
7.2 (ii) 4
Information Technology
Paper 02 – General Proficiency
Key and Mark Scheme
SPECIMEN PAPER
Correct SUM
Cell E8: function:
=SUM(E4:E7) Correct
Range: 1 mark
OR Correct
1 mark
brackets and
=SUM(E4..E7)
equal sign 1 mark
OR and (colon or
two dots):
=E4+E5+E6+E7
5.4
Cell E9
Possible options to
calculate the Both cell
difference: references 1 mark
correct
=F2-E8 1 mark
Equal sign
OR 1 mark
Minus sign
=$F$2-E8
5.3 (ii) 3
=IF(E9>F2,”Ye
s”,”No”) =IF
1 mark
OR Condition
1 mark
=IF(E9>0,”No” Y/N Options
,”Yes”) 1 mark
- 7 -
01229020/KMS/SPEC 2017
Information Technology
Paper 02 – General Proficiency
Key and Mark Scheme
SPECIMEN PAPER
5.6
Explanation showing
Data in row 4 would move to row 5 that data is row 4
1 mark
Or becomes data in row
5
is pushed down by one row
(c) 3.3 1
Encrypt or
She could Password
encrypt her
file or use a (other 1 mark
password to suitable/appropriat
protect it e responses can be
accepted)
(d) 3.6 4
TOTAL 15
- 8 -
01229020/KMS/SPEC 2017
Information Technology
Paper 02 – General Proficiency
Key and Mark Scheme
SPECIMEN PAPER
1.9 (a)
Used to send messages to the
Switch right computer on a single
network
(c) WiFi
1
- 9 -
01229020/KMS/SPEC 2017
Information Technology
Paper 02 – General Proficiency
Key and Mark Scheme
SPECIMEN PAPER
TOTAL 25
CARIBBEAN E XAM I NAT I O N S COUNCIL
TEST CODE 0 1 2 2 9 0 3 2
PROFICIENCY GENERAL
REGISTRATION NUMBER
SCHOOL/CENTRE NUMBER
NAME OF SCHOOL/CENTRE
DATE OF BIRTH D D M M Y Y Y Y
Current Bar Code
SIGNATURE __________________________________________________
‘‘*’’Barcode Area”*”
Sequential Bar Code
DO
NO
W T
RI
TE
TH ON
IS
PA
G E
TEST CODE 01229032
SPEC 2017/01229032
CARIBBEAN E XAM I NAT I O N S COUNCIL
INFORMATION TECHNOLOGY
2 hours
1. This paper consists of FIVE questions, both Theory and Practical. Answer ALL
questions.
4. If you need to rewrite any answer and there is not enough space to do so on
the original page, you must use the extra lined page(s) provided at the back of
this booklet. Remember to draw a line through your original answer.
5. If you use the extra page(s) you MUST write the question number clearly
in the box provided at the top of the extra page(s) and, where relevant,
include the question part beside the answer.
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
Answer ALL questions.
1. WORD PROCESSING
Below is a sample letter which is to be sent to customers of Cars Inc. As the secretary of the
organization, you are to prepare ten letters for appropriate customers using mail merge.
Total 10 marks
2. SPREADSHEET
(a) Retrieve the workbook DEALERSHIP, and perform the following tasks on the STOCK
worksheet. The data should reflect what is shown below.
A B C D E
1 REVENUE
OPENING CLOSING
MANUFACTURER PRICE FROM
STOCK STOCK
SALES
2 NISSAN 5 3 85 000
3 TOYOTA 5 4 100 000
4 MITSUBISHI 5 1 90 000
5 MAZDA 5 5 75 000
6 SUZUKI 5 2 55 000
7
8
9
(i)
Format the labels in row 1 to Arial font, bold, 12 point, and centre the data in the
cells horizontally and vertically.
(2 marks)
(ii) Insert a formula in cell E2 to calculate the REVENUE FROM SALES for cars
from the Nissan Manufacturer, and replicate your formula in cells E3:E6.
(2 marks)
(iii) In the range A8:A9, enter the following text:
TOTAL REVENUE
AVERAGE REVENUE
Then insert appropriate functions in range B8:B9 which will compute the total and
average revenue from the sales of all vehicles.
(2 marks)
(iv) Apply currency and two decimal places to the data in cells D2:E6.
(1 mark)
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
(b) Retrieve the worksheet SALES. A copy of the worksheet is provided below. Using this
worksheet, perform the following tasks.
SALES
A B
1 2018 Revenue
2 QUARTER REVENUE ($)
3 Quarter 1 1 155 000.00
4 Quarter 2 925 000.00
5 Quarter 3 1 290 000.00
6 Quarter 4
(i)
Link the missing value in cell B6 with cell B8 from the STOCK sheet in the
DEALERSHIP workbook to complete the 2018 Revenue.
(1 mark)
(ii) Filter the REVENUE data for the quarters where the revenue was less than
$1 000 000.00. Set up the extraction range in a blank area of the STOCK sheet in
the DEALERSHIP workbook.
Total 10 marks
3. DATABASE
The owner of a car dealership uses a stock card system to record the details of vehicles in his
inventory. Retrieve the database called DEALER and perform the following tasks on the table
STOCKCARD. The data should reflect what is shown below.
Make Model Registration Number Colour
Audi A4 PCE 427 Silver
Audi S4 PCS 4 White
BMW X3 PBH 2340 Red
BMW X5 PCY 888 Blue
Mercedes C180 PBB 3962 Green
Mercedes E200 PBR 4747 Black
Mercedes E200 PCT 6531 Gold
Mercedes S500 PDM 1 Black
(a) Insert a primary key using the MOST appropriate field. (2 marks)
(b) Add ONE appropriate field name and data type to the table. (2 marks)
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
(d) Suggest ONE database feature that can be used by the dealer to simplify the entry of new
vehicles and their details into his inventory.
..............................................................................................................................................
(1 mark)
(e) Describe ONE validation check that could be used on the Registration Numbers as they
are entered.
..............................................................................................................................................
..............................................................................................................................................
(1 mark)
(f) Identify the database feature that could be used to arrange the registration number of
vehicles in ASCENDING order.
..............................................................................................................................................
(1 mark)
Total 10 marks
4. WEBPAGE DESIGN
Amery created a website for his small photography business and was eager to have it published.
However, he was told that he should consider completing some checks before doing so.
(a) Insert 1st, 2nd and 3rd in the following table to indicate the order in which the activities
must be completed.
Activity Rank
Use a test audience.
Maintain a website.
Verify that all the hyperlinks work correctly.
(3 marks)
(b) Give ONE example of a hyperlink that could be used on the webpage. Explain its purpose.
. .............................................................................................................................................
..............................................................................................................................................
(2 marks)
Total 5 Marks
Mr Smith is the CEO of Techno Store, which is a local distributor for computers and other
electronic devices. He has solicited your help to make his business efficient.
Using pseudocode, write an algorithm to
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
..............................................................................................................................................
Total 15 Marks
END OF TEST
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
EXTRA SPACE
If you use this extra page, you MUST write the question number clearly in the box provided.
Question No.
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
...........................................................................................................................................................................
01229032 SPEC/2017
‘‘*’’Barcode Area”*”
Sequential Bar Code
DO
NO
W T
RI
TE
TH ON
IS
PA
G E
CANDIDATE’S RECEIPT
INSTRUCTIONS TO CANDIDATE:
TEST CODE: 0 1 2 2 9 0 3 2
PROFICIENCY: GENERAL
REGISTRATION NUMBER:
Signature: ____________________________________________________________________
Date: ________________________________________________________________________
2. Ensure that this slip is detached by the Supervisor or Invigilator and given to you when you
hand in this booklet.
INSTRUCTION TO SUPERVISOR/INVIGILATOR:
Sign the declaration below, detach this slip and hand it to the candidate as his/her receipt for this booklet
collected by you.
I hereby acknowledge receipt of the candidate’s booklet for the examination stated above.
Signature: _____________________________
Supervisor/Invigilator
Date: _________________________________
01229032/CSEC/SPEC/MS/2017
C A R I B B E A N E X A M I N A T I O N S C O U N C I L
INFORMATION TECHNOLOGY
PAPER 032
MARK SCHEME
SPECIMEN
01229032/CSEC/SPEC/MS/2017
- 2 –
INFORMATION TECHNOLOGY
PAPER 032
MARK SCHEME
1. Specific Objectives:
a) 1 mark for typing the letter accurately
1 mark
b) 1 mark for the logo placed in the header
1 mark for use of another formatting feature.
2 marks
c) 1 mark for every two field names entered correctly.
(There are 10 fields to be entered)
5 marks
d) 1 mark for merging the documents.
1 mark
e) 1 mark for use of protection feature.
1 mark
Total 10 marks
2. Specific Objectives:
INFORMATION TECHNOLOGY
PAPER 032
MARK SCHEME
3. Specific Objectives:
a) Primary key inserted (1), Registration number (1)
2 marks
b) Cost, currency 2 marks
c) All fields (1) Data grouped (1); Correct report
format (1) 3 marks
d) Form 1 mark
a)
Item Rank
Maintain a website 3
3 marks
01229032/CSEC/SPEC/MS/2017
- 4 –
INFORMATION TECHNOLOGY
PAPER 032
MARK SCHEME
b)
Link to a location
BacktoTop
within the webpage.
Link to user-created
Download Here
files.
2 marks
Total 5 marks
5. Specific objectives:
Constant
Variables
Body
INFORMATION TECHNOLOGY
PAPER 032
MARK SCHEME
Step3: Read name1 use of Input statement (1)
Step 4: Print(Enter the cost of, name1)
Step 5: Read cost
Step 6: Print (Enter “Y” if item is taxable or “N” if it is non-taxable)
Step 7: Read Response
Step 8: If (Response = “Y”)then (use conditional branching
1 mark for If-then and 2 marks for If-then-else)2mks
Set vat Vatpercent * cost
Else
Set vat 0
Endif
Step 9: set total_cost vat + price
1 mark for assignment variable and 1 for correct variables used
Step 10: Print ( The total cost for a , name1 , is, total_cost)
1 mark for each output (2 marks)
Step 11: Print (Do you have another item?)
Step 12: Read Answer
Step 13: Until ( answer = “No”)
Step 14: Stop Terminator 1 mark
INFORMATION TECHNOLOGY
PAPER 032
MARK SCHEME
Body:
Step 1: Start (1)
Step 2 : Print (how many items did you purchase?)
Step 3: Read num
Step 4: For I = 1 to num do appropriate use of iteration (1)
Step 4i:Print (Enter the name of device) use of Output statement (1)
Step4ii: Read name1 use of Input statement (1)
Step 4iv: Print(Enter the cost of, name1)
Step 4v: Read cost
Step 4vi: Print (Enter “Y” if item is taxable or “N” if it is non-
taxable)
Step 4vii: Read Response
Step 4viii: If (Response = “Y”)then
(use conditional branching - 1 for If-then and 2 for If-then-else)2mks
Set vat Vatpercent * cost
Else
Set vat 0
Endif
Step 4ix: set total_cost vat + price
(1 for assignment variable and 1 for correct variables)
Step 4x: Print ( The total cost for a , name1 , is, total_cost)
(Output results 1 mark for each output) 2 marks
Step 4xi: Endfor
Step 5: Stop Terminator (1)
INFORMATION TECHNOLOGY
PAPER 032
MARK SCHEME
Response of char
Num, count of integer
Body:
Step 1: Start (1)
Step 2 : Print (how many items did you purchase?)
Step 3: Read num
Step 4: While count<=num do appropriate use of iteration (1)
Step 4i: Print (Enter the name of device) Output statement (1)
Step4ii: Read name1 Input statement (1)
Step 4iv: Print(Enter the cost of, name1)
Step 4v: Read cost
Step 4vi: Print (Enter “Y” if item is taxable or “N” if it is non-
taxable)
Step 4vii: Read Response
Step 4viii: If (Response = “Y”)then
(use conditional branching - 1 for If-then and 2 for If-then-else)
Set vat Vatpercent * cost
Else
Set vat 0
Endif
Step 4ix: set total_cost vat + price calculation
(1 for assignment variable and 1 for correct variables used)
Step 4x: Print ( The total cost for a , name1 , is, total_cost)
(1 mark for each output) 2 marks
Step xi Count count +1
Step 4xii: Endwhile
Step 5: Stop Terminator (1)
Total 15 marks