Information Technology SBA 2026–2027 | Student Guide

Display settingsNight mode is on. If the switch does not respond, JavaScript may be blocked.
NAPARIMA COLLEGE • CSEC INFORMATION TECHNOLOGY

Information Technology SBA 2026–2027

Your complete student guide: choose a school club, prepare the group proposal, complete all five project components, and check exactly what to submit and how it is marked.

Groups of 5One school club per group5 SBA componentsBased on the June 19, 2026 document

Prepared by Vedesh Kungebeharry. This page reorganises the supplied SBA document for phone and laptop viewing, while retaining its requirements and marking criteria.

Find what you need

Select a section below. Each component includes its task, required files, marking scheme and related links.

Read this first

Introduction and group rules

This School Based Assessment applies skills from the CSEC Information Technology syllabus in productivity tools, web design, database management, problem-solving and programming.

Theme: Your group’s project must be based on a school club. Use IT to improve how it is managed, promoted, organised or analysed.

Rules: Work in teams of five (5). Select ONE school club per group. Once assigned, another group cannot choose the same club without the teacher’s approval. Your project proposal must be approved before beginning the SBA.

Cultural and artistic

  • African Cultural Club (A.C.C.)
  • Indian Cultural Club
  • Art Club
  • Drama Club (NCDC)
  • Sign Language Choir

Academic and technology

  • Astronomy Club
  • Geography Club
  • IT Club
  • Science Club

Special interest

  • Audio-Visual Club
  • Chess Club
  • Culinary Club
  • Literary and Debating Society

Service, leadership and others

  • Interact Club
  • Big Brother Programme
  • Sea Scout Troop
  • Diving Club

Your group might work on member registration, event planning, attendance, equipment and assets, budgeting, fundraising, communication, promotion or analysis of participation.

Brainstorm with your teacher to ensure your club has sufficient activities, documents and meaningful data to complete all five SBA components. You might manage members, events, finances and resources, and/or analyse club data for students, teachers and club leaders.

Before proposing a club: Check the Word Processing, Website, Spreadsheet, Database and Programming tasks. The proposal must be realistic for all of them.
Approval required before the SBA begins

Project proposal — template and example

Identify your selected club, theme and proposed IT tasks. Submit this proposal to your teacher for approval.

Proposal template

Topic: [Name of your chosen school club]

Theme/Subheading: [Your group’s project theme]

Detail: [What club problem or opportunity IT will address]

Explain a proposed task for every row:

  • Word Processing — automatic table of contents
  • Word Processing — fillable form
  • Word Processing — mail merge
  • Web-Based Design
  • Spreadsheet
  • Database Management
  • Problem Solving and Programming

All three Word Processing rows must be completed in the proposal, even though only two of these three tasks are required for final submission.

Worked proposal: Naparima College Diving Club

Topic: Naparima College Diving Club

Theme/Subheading: Managing Our School’s Diving Club

Detail: Improve management of the school’s SCUBA diving club using a website, financial and equipment management, student registration and other activities.

Word Processing — automatic table of contentsExample
Create a Diving Club Handbook covering club rules, safety, membership, equipment use and upcoming activities. Use heading styles and an automatically generated table of contents.
Word Processing — fillable formExample
Create a fillable registration form students use to apply to join the Diving Club.
Word Processing — mail mergeExample
Use mail merge to generate personalised sponsorship and donation request letters to businesses and organisations that might support activities and equipment purchases.
WebsiteExample
Create a Diving Club website: a homepage introducing the club and future events; an information page about SCUBA diving, safety and certification; and a downloads page for the handbook and registration form.
SpreadsheetExample
Track finances with columns such as Date, Description, Category, Income, Expense and Balance. Include membership fees, sponsorship, transport, equipment purchases and maintenance. Use functions and formulas for totals and balances; two different chart types; and a pivot table showing amounts spent and received by category.
Database ManagementExample
Manage equipment inventory, including items, replacement cost, maintenance status and members borrowing equipment.
Problem Solving and ProgrammingExample
Develop a program to calculate recommended dive duration from planned depth and available air supply. It accepts input, processes the data and displays a user-friendly result. This is a conceptual SBA example, not real-world dive planning guidance.

Choose a club capable of producing comparable meaningful information and documents for every section. Link your proposal and your final tasks to the same club throughout.

SBA component 01

Word Processing

Produce a document or documents for your intended audience. Complete any TWO of Parts A, B and C. Apply suitable document-formatting features to make the work attractive and readable.

Part A · Manual or explanatory document

Create a manual, contract or explanatory document of at least two pages, with a cover page and an automatically generated table of contents in a suitable location. Use at least two heading levels.

GroupNN-WordProcessing-PartA

Part B · Mail merge

Complete a mail merge with appropriate merge fields. Save all three: data source, primary/template document and merged document.

GroupNN-WordProcessing-PartB-DataSourceGroupNN-WordProcessing-PartB-PrimaryGroupNN-WordProcessing-PartB-Merged

Part C · Fillable form

Create a fillable form to collect information from your audience, such as a club membership registration form or survey.

GroupNN-WordProcessing-PartC-FillableForm

Group04 is only an example. Replace NN with your own group number, for example Group01, Group02 or Group03. Use the correct file extension for your software.

Submission example

The original document illustrates submission of Parts A and B in one folder:

Example folder showing Group 04 Word Processing Part A and the mail merge data source, primary and merged documents
Original Word Processing submission screenshot. Tap or click to view full size.

Mark scheme — Word Processing

Open each heading to see the source assessment criteria and individual mark allocation.

S4: SO3 — Document formatting features4 marks

The following is compulsory. No more than four features will be tested:

  • Any TWO: bold, underline, italics
  • Justification (centre, right, full)
  • Changes in line spacing
  • Superscript and/or subscript
  • Changes in font or font size
  • Page numbering
S4: SO3 — Page layout2 marks
Any change in margins, page orientation, paper size or text orientation1
Correct use of a header OR footer OR footnotes OR endnotes1
S4: SO1 / SO2 — Select any TWO of inserting files, columns or tablesUp to 2 marks each

Inserting/importing files (SO1)

Graphic or chart in the document1
Graphic, chart or table appropriately sized to fit location/margins1

Columns (SO2)

Correct use throughout the document or selected text2
Mostly correct use1

Tables (SO2)

Correct number of rows and columns1
Correct table formatting, e.g. borders, shading, colour1
S4: SO6 / SO7 / SO8 — Select any TWO of the three special features5 marks each

Automatic table of contents (SO6)

Automatically generated1
Suitable location1
At least two levels of headings1
Suitable headings chosen (1 each)2

Mail merge (SO7)

Required merge fields selected/created in data source1
Primary document consistent with merged document1
Correct merge field inserted in appropriate section1
Correct merge2

Fillable forms (SO8)

At least three controls used appropriately: option boxes, check boxes, text boxes, date picker, drop-down lists and/or command buttons3
Clear, easy-to-follow layout2
Some aspects of layout not clear/easy to follow (alternative)1

Source: CSEC® Information Technology Syllabus, Specimen Paper, Mark Scheme and Subject Reports eBook (2019), p. 36; reproduced in the provided 2026 SBA instructions.

SBA component 02

Web-Based Design

Create a website explaining the theme of your group project. You may use an online website-building service or build the site manually using a web-authoring tool / word processor.

Required website features

  • A logo relevant to your club/project
  • A menu with working navigation links
  • At least TWO different hyperlink types: links to a location within a page, an email address, another web page, or a user-created file
Online website submissions: Create one word processing document with a link to your site on its first page. Name the document GroupNN-Website. Group04 is only an example. Replace NN with your own group number, for example Group01, Group02 or Group03. The source also permits a locally created website; no additional local-file naming instruction was specified in the provided document.
Screenshot of a Windows folder containing Group 04-Website.docx for an online website submission
Original example of the website link document. Tap or click to enlarge.

Mark scheme — Web-Based Design

S4: SO9 — Appropriate design features3 marks
Graphics and text both included1
Appropriate use of text1
Appropriate use of graphics1
S4: SO9 — Intended audience2-mark subsection
Layout suitable for intended audience1
Layout mostly suitable for intended audience1

These describe performance levels in the source scheme.

S4: SO12 — Information matches the requirements3 marks
Majority of information consistent with requirements3
Somewhat consistent with requirements2
A few aspects consistent with requirements1
S4: SO11 — Hyperlinks2 marks

Provide links of any TWO of the following types:

  • To another webpage
  • To a location within the same webpage
  • To an email address
  • To a user-created file

Source: CSEC® Information Technology Syllabus, Specimen Paper, Mark Scheme and Subject Reports eBook (2019), p. 38; hyperlink types cited from p. 33.

SBA component 03

Spreadsheet

Create a spreadsheet that analyses data captured for your club and/or manages a relevant budget.

Required features

  1. Use at least two worksheets; store constants in a worksheet named Constants.
  2. Use three different predefined functions (e.g. COUNT, SUM, AVERAGE, MAX) and three different formulas you create yourself.
  3. Copy formulas using absolute addressing (including a reference to a constant in the Constants worksheet) and relative addressing.
  4. Use at least two of decimal places, currency, commas and percentages; use suitable alignment/font sizing; and use merging or wrapping if appropriate.
  5. Sort at least one table.
  6. Extract data using a simple filter and criteria.
  7. Build a pivot table to summarise data.
  8. Build two different chart types (e.g. bar and pie, or line and bar), with appropriate titles, axes and data labels.
  9. Link data between worksheets, for example a summary worksheet that refers to another worksheet or a constant.

Formula examples in the document

=(E3*F3)/(A3+B3)=(G12*F12)/COUNT(A2:E10)

Predefined functions differ from user-created formulas. Your work needs both.

File to submit

Submit one spreadsheet file.

GroupNN-Spreadsheet

Group04 is only an example. Replace NN with your own group number, for example Group01, Group02 or Group03.

Mark scheme — Spreadsheet

S5: SO3 — Predefined functions3 marks
Correct use of any THREE different predefined functions3
S5: SO4 — Arithmetic formulas3 marks
Correct use of any THREE different arithmetic formulas3
S5: SO5 — Replicate formulas2 marks
Absolute addressing or range names — two different examples2
S5: SO6 — Formatting4 marks
Any TWO: decimals, currency, comma or percentage2
Justification or appropriate font/font size1
Advanced formatting such as merged cells or wrapped text1
S5: SO7 — Sorting1 mark
Data sorted correctly ascending/descending as required1
S5: SO7 — Extracting data2 marks
Simple filter applied1
Evidence of filtering criteria, e.g. B3 < 201
S5: SO7 — Pivot tables1 mark
Pivot table summarises a large group of data1
S5: SO8 — Charting3 marks
Appropriate selection of adjacent/non-adjacent source cells1
Suitable chart type (bar/column, line, pie etc.)1
Appropriate chart title, axes and/or data labels1
S5: SO9 — Multiple sheets1 mark
Cells linked across two or more worksheets1

Source: CSEC® Information Technology Syllabus, Specimen Paper, Mark Scheme and Subject Reports eBook (2019), p. 38.

SBA component 04

Database Management

Create a database to record and manage assets relevant to your chosen club: equipment inventory, contact details, catalogues and similar information.

Database task requirements

  1. Create at least three related tables, forming a many-to-many relationship.
  2. Make three context-relevant queries: one simple query using one criterion from a single table; one complex query with at least two criteria and two tables; and one query containing a calculated field.
  3. Create one form with a subform for data entry or record browsing.
  4. Create one report using TWO or THREE tables, with grouping, summaries (totals/counts) and sorting. It should summarise most entities in the database.
Important distinction: The task itself requires three related tables forming a many-to-many relationship. The marking scheme below separately awards one mark for a minimum of two tables. Follow the more demanding task requirement; do not assume two tables are sufficient.

File to submit

Submit one database file, named in this format:

GroupNN-Database

Group04 is only an example. Replace NN with your own group number, for example Group01, Group02 or Group03.

Mark scheme — Database Management

S6: SO3 — Create a database5 marks
Appropriate field names1
Appropriate data types1
Tables populated with data1
At least two database tables/files1
Suitable primary key1
S6: SO3 — Simultaneous use of tables2 marks
Joins between pairs of tables/files1
Evidence of relationship (1:1 or 1:M)1
S6: SO4 — Queries5 marks
Simple query with one criterion1
Complex query: multiple criteria and more than one table2
Correct calculated field and result in a query2
Create forms2 marks
Form with subform1
Appropriate fields in subform1
S6: SO4 — Sorting1 mark
Evidence of sorting in a table, file or report1
S6: SO5 — Reports5 marks
Appropriate fields selected for report1
Summary/statistical feature such as count, sum or average1
Required fields grouped1
Specific, correct report title2
Generic title only (alternative)1

Source: CSEC® Information Technology Syllabus, Specimen Paper, Mark Scheme and Subject Reports eBook (2019), pp. 33, 40.

SBA component 05

Problem Solving and Program Design

Choose a unique programming problem related to your club. Implement a working solution using the programming language taught in class, and submit documentation alongside it.

Your documentation must include

  1. A clear problem statement.
  2. An algorithm in pseudocode or flowchart.
  3. Trace tables that test the algorithm.
  4. Your program code.
  5. Screenshots of the running program.

Flowgorithm / flowchart requirements

  • Screenshots must be readable at the intended size.
  • Use connector symbols for every arrow that continues from one page to the next.
  • The starting terminator must read “Start”, not “Main”.
  • Configure Flowgorithm to the standard used for CSEC IT.

See the IslandClass Flowgorithm CSEC configuration guide.

How to include code

  • If using Flowgorithm, export the code as an image or use readable screenshots.
  • If using another language, copy and paste code directly into the document.
  • Maintain correct code indentation and line spacing.

Also include screenshots demonstrating the program actually running.

Mark scheme — Problem Solving and Programming

S7: SO5 — Flowchart or pseudocode6 marks
Start of algorithm1
User-friendly variable names1
Variables initialized1

Processing:

Request for data (prompt) and read/store data1
Appropriate selection structure1
Appropriate looping structure1
S7: SO7 — Trace table4 marks
Variables identified1
Appropriate test data1
Changes in values correctly demonstrated2
Some errors in trace values (alternative award)1
S8: SO2 — Program execution1 mark
Working program1
S8: SO5 — Programming language features3 marks
Variable initialization1
Appropriate selection statements: if/then, if/then/else or case1
Loop: while, repeat or for1
S8: SO7 — Documentation1 mark
Author, creation date, problem statement, suitable inline comments etc.1

Source: CSEC® Information Technology Syllabus, Specimen Paper, Mark Scheme and Subject Reports eBook (2019), p. 41.

Use before handing in

Submission checklist and file naming

Check each requirement against your teacher’s directions. Save frequently, store all SBA files in the relevant folders within your project package, and keep backups on another device, drive or cloud service. Avoid losing work due to hardware failure or accidental deletion.

Proposal

  • Group of five with an approved club
  • Topic, theme, detail and proposed task for every component
  • All three Word Processing options described in proposal

Word Processing

  • Submit any TWO of Parts A, B and C
  • If Part A: 2+ pages, cover and automatic contents
  • If Part B: three mail merge files (data source, primary, merged)
  • If Part C: functional fillable form
  • Suitable document formatting

Web-Based Design

  • Logo, navigation menu, two hyperlink types
  • If hosted online, a document with the URL on page one
GroupNN-Website

Spreadsheet

  • Two or more sheets including Constants
  • 3 functions and 3 formulas; absolute/relative references
  • Formatting, sorting, filter, pivot table
  • Two different charts; links between sheets
GroupNN-Spreadsheet

Database

  • At least 3 related tables; many-to-many structure
  • Simple, complex and calculated-field queries
  • Form and subform; grouped, sorted summary report
GroupNN-Database

Programming

  • Problem statement
  • Pseudocode or CSEC-standard flowchart
  • Trace tables
  • Readable program code
  • Screenshots of the running program
Group numbers: File names are shown as GroupNN. Group04 is only an example. Replace NN with your own group number, for example Group01, Group02 or Group03. The task document does not prescribe an additional filename for the programming documentation.

For additional school submission guidance, see Information Technology SBA Originality Report Instructions. These are separate website instructions; refer to your teacher for current applicability.

Updates

2026/10/30
– File-name examples now show GroupNN instead of Group04 in Word Processing (Parts A, B and C), Web-Based Design, Spreadsheet, Database and the submission checklist.
– Added a note in each part: Group04 is only an example; replace NN with your own group number, for example Group01, Group02 or Group03.

© 2026 Vedesh Kungebeharry. All rights reserved.

School Based Assessment document dated June 19, 2026 · Naparima College. Mark schemes cited from the CSEC® Information Technology Syllabus, Specimen Paper, Mark Scheme and Subject Reports eBook, 2019.