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.
Prepared by Vedesh Kungebeharry. This page reorganises the supplied SBA document for phone and laptop viewing, while retaining its requirements and marking criteria.
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.
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.
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
Word Processing — fillable formExample
Word Processing — mail mergeExample
WebsiteExample
SpreadsheetExample
Database ManagementExample
Problem Solving and ProgrammingExample
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.
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-PartAPart 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-MergedPart 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-FillableFormGroup04 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:

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
S4: SO1 / SO2 — Select any TWO of inserting files, columns or tablesUp to 2 marks each
Inserting/importing files (SO1)
Columns (SO2)
Tables (SO2)
S4: SO6 / SO7 / SO8 — Select any TWO of the three special features5 marks each
Automatic table of contents (SO6)
Mail merge (SO7)
Fillable forms (SO8)
Source: CSEC® Information Technology Syllabus, Specimen Paper, Mark Scheme and Subject Reports eBook (2019), p. 36; reproduced in the provided 2026 SBA instructions.
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
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.
Mark scheme — Web-Based Design
S4: SO9 — Appropriate design features3 marks
S4: SO9 — Intended audience2-mark subsection
These describe performance levels in the source scheme.
S4: SO12 — Information matches the requirements3 marks
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.
Spreadsheet
Create a spreadsheet that analyses data captured for your club and/or manages a relevant budget.
Required features
- Use at least two worksheets; store constants in a worksheet named
Constants. - Use three different predefined functions (e.g. COUNT, SUM, AVERAGE, MAX) and three different formulas you create yourself.
- Copy formulas using absolute addressing (including a reference to a constant in the Constants worksheet) and relative addressing.
- Use at least two of decimal places, currency, commas and percentages; use suitable alignment/font sizing; and use merging or wrapping if appropriate.
- Sort at least one table.
- Extract data using a simple filter and criteria.
- Build a pivot table to summarise data.
- Build two different chart types (e.g. bar and pie, or line and bar), with appropriate titles, axes and data labels.
- 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-SpreadsheetGroup04 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
S5: SO4 — Arithmetic formulas3 marks
S5: SO5 — Replicate formulas2 marks
S5: SO6 — Formatting4 marks
S5: SO7 — Sorting1 mark
S5: SO7 — Extracting data2 marks
S5: SO7 — Pivot tables1 mark
S5: SO8 — Charting3 marks
S5: SO9 — Multiple sheets1 mark
Source: CSEC® Information Technology Syllabus, Specimen Paper, Mark Scheme and Subject Reports eBook (2019), p. 38.
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
- Create at least three related tables, forming a many-to-many relationship.
- 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.
- Create one form with a subform for data entry or record browsing.
- Create one report using TWO or THREE tables, with grouping, summaries (totals/counts) and sorting. It should summarise most entities in the database.
File to submit
Submit one database file, named in this format:
GroupNN-DatabaseGroup04 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
S6: SO3 — Simultaneous use of tables2 marks
S6: SO4 — Queries5 marks
Create forms2 marks
S6: SO4 — Sorting1 mark
S6: SO5 — Reports5 marks
Source: CSEC® Information Technology Syllabus, Specimen Paper, Mark Scheme and Subject Reports eBook (2019), pp. 33, 40.
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
- A clear problem statement.
- An algorithm in pseudocode or flowchart.
- Trace tables that test the algorithm.
- Your program code.
- 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.
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
Processing:
S7: SO7 — Trace table4 marks
S8: SO2 — Program execution1 mark
S8: SO5 — Programming language features3 marks
S8: SO7 — Documentation1 mark
Source: CSEC® Information Technology Syllabus, Specimen Paper, Mark Scheme and Subject Reports eBook (2019), p. 41.
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
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
Database
- At least 3 related tables; many-to-many structure
- Simple, complex and calculated-field queries
- Form and subform; grouped, sorted summary report
Programming
- Problem statement
- Pseudocode or CSEC-standard flowchart
- Trace tables
- Readable program code
- Screenshots of the running program
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.