Steps in Problem-Solving and the Divide-and-Conquer Approach

Every day you solve problems without thinking much about it – planning how to get to school when the maxi taxi is late, or working out how to share the cost of a pizza among friends. In IT we solve problems in a more organised way, so that the solution can later be turned into a computer program. In this post you will learn the steps in problem-solving and how to use the divide-and-conquer approach to break a big problem into smaller ones.

Build on what you learned in Forms 1–3

These Lower School ICT posts cover the basics of this topic:

In this post:

  • The five steps in problem-solving
  • A worked example: planning a class fundraiser
  • Divide and conquer (top-down design)
  • Drawing a simple structure (top-down) chart

The five steps in problem-solving

The CSEC syllabus lists these steps. Learn them in order:

  1. Define the problem – say clearly what has to be solved. What information do you have (inputs)? What result is needed (outputs)?
  2. Propose and evaluate solutions – think of more than one way to solve the problem and look at the good and bad points of each.
  3. Determine the most efficient solution – choose the solution that works best, using the least time, effort or resources.
  4. Develop the algorithm – write the chosen solution as a set of clear, step-by-step instructions (in pseudocode or a flowchart).
  5. Test and validate the solution – check the algorithm with test data (for example, using a trace table) to make sure it gives the correct results for every case.

A quick way to remember them: Define → Propose → Choose → Develop → Test.

Worked example: the class fundraiser

Form 4 wants to raise money by selling doubles at lunchtime. The form teacher wants to know how much profit is made each day.

StepWhat the class does
Define the problemInputs: number of doubles sold, selling price, cost price. Output: the profit for the day.
Propose and evaluate solutions(1) Count the money in the box at the end of the day and subtract what was spent. (2) Record each sale and calculate profit = number sold × (selling price − cost price). Option 1 is quick but cannot show mistakes; option 2 is more accurate.
Determine the most efficient solutionOption 2 – it can be done on a computer each day with very little effort.
Develop the algorithm• Read number sold, selling price and cost price
• calculate profit
• display profit
Test and validateTry 40 doubles at $6 selling and $4 cost: profit should be 40 × 2 = $80. Check the algorithm gives $80.

Divide and conquer

Big problems are hard to solve all at once. Divide and conquer (also called top-down design or stepwise refinement) means:

  1. divide the problem into a number of smaller sub-problems;
  2. solve each sub-problem on its own; and
  3. combine the solutions to the sub-problems to get the solution to the original problem.

Example: preparing a three-course Sunday lunch. Instead of thinking of “make lunch” as one huge task, break it down: prepare the starter (callaloo soup), prepare the main course (stew chicken, rice and peas, macaroni pie), prepare the dessert (sweet bread or ice cream). Each of these can be broken down again – the main course becomes season the chicken, cook the rice and peas, bake the pie. When every small task is done, lunch is ready.

Another example from the syllabus is finding the exit in a hotel: find the nearest stairway sign, follow the corridor to the stairs, go down to the ground floor, then follow the exit signs to the door.

Prepare Sunday lunchStarterMain courseDessertSeason chickenCook riceBake pie
A top-down (structure) chart: the big task at the top is broken into smaller and smaller tasks.

Programmers use exactly the same idea. A school report-card program might be split into: enter marks, calculate averages, work out positions in class, and print the reports. Each part can be written and tested separately. You can see more on this in Introduction to Top-Down Stepwise Refinement.

Big programs are broken into smaller pieces that teams can build separately – divide and conquer in real life.

Video: Software Engineering: Crash Course Computer Science #16 – https://www.youtube.com/watch?v=O753uuutqH8

Try it: Which problem-solving step is it?

For each activity, choose the step of problem-solving it belongs to.

Deciding that the output must be the total cost of the class trip
Listing three different ways to collect money for the trip
Picking the cheapest and quickest way to collect the money
Writing the steps out in pseudocode
Running the steps with sample numbers to check the answer

Related

Related: Introduction to Top-Down Stepwise Refinement

Paper 1 practice (multiple choice)

Choose the best answer for each question. Try them all before you check.

1. Which is the FIRST step in problem-solving?
(A) Develop the algorithm
(B) Define the problem
(C) Test the solution
(D) Choose the best solution

2. Breaking a large problem into smaller sub-problems is called
(A) divide and conquer
(B) debugging
(C) compiling
(D) validation

3. Which step comes immediately AFTER “determine the most efficient solution”?
(A) Define the problem
(B) Propose solutions
(C) Develop the algorithm
(D) Test and validate

4. In divide and conquer, after the sub-problems are solved, their solutions are
(A) deleted
(B) combined
(C) compiled
(D) ignored

5. Checking an algorithm with sample data to see if it gives correct results is part of
(A) defining the problem
(B) testing and validating the solution
(C) proposing solutions
(D) dividing the problem

Show answers

1. B
2. A
3. C
4. B
5. B

Paper 2 practice (structured question)

A small parlour in Chaguanas wants a program to work out how much each customer must pay. Customers buy several items, and a discount is given when the bill is over $200.

(a) List, in the correct order, the FIVE steps in problem-solving. (5 marks)

(b) Explain what is meant by the “divide-and-conquer” approach. (2 marks)

(c) Using the parlour problem, identify:

(i) ONE sub-problem (1 mark)

(ii) ANOTHER sub-problem (1 mark)

(d) State ONE benefit of breaking a problem into sub-problems. (1 mark)

Total: 10 marks

Show answers

(a)
• Define the problem (1 mark)
• Propose and evaluate solutions (1 mark)
• Determine the most efficient solution (1 mark)
• Develop the algorithm (1 mark)
• Test and validate the solution (1 mark)

(b) A large problem is divided into smaller sub-problems that are solved individually (1 mark); the solutions are then combined to solve the original problem (1 mark).

(c)

(i) Read the price of each item and add up the bill (1 mark)

(ii) Check whether the bill is over $200 and apply the discount / display the amount to pay (1 mark)

(d) Any one:
• smaller problems are easier to understand and solve
• different people can work on different parts
• each part can be tested separately (1 mark)

Next: Defining a Problem with an IPO Chart: Input, Processing and Output

Syllabus link: This post is relevant to the CSEC® Information Technology Syllabus (CXC 30/G/SYLL 17), Section 7: Problem-Solving and Program Design, Specific Objectives 1 and 2 (“outline the steps in problem-solving” and “use the divide-and-conquer approach to decompose large everyday problems into smaller tasks”).

Attributions to media used in this post:

No third-party images are used in this post. Embedded videos are credited on YouTube to their channels.

© 2026 Vedesh Kungebeharry. All rights reserved.

Databases: Primary, Candidate, Secondary and Foreign Keys, Data Types and Relationships

In a school database, how does the computer know which student borrowed which library book, without typing the student’s name and address again on every loan? The answer is keys and relationships. This post fills in the database terms you must know – the different keys and data types – and shows how to create one-to-one and one-to-many relationships in Microsoft Access.

Build on what you learned in Forms 1–3

These Lower School ICT posts cover the basics of this topic:

In this post:

  • A quick reminder: tables, records and fields
  • Primary, candidate, secondary (alternate) and foreign keys
  • Data types
  • Relationships: one-to-one and one-to-many
  • Creating a relationship in Access, step by step

A quick reminder

A database is an organised collection of related data. Data is stored in tables; each row is a record (one student) and each column is a field (Surname, Date of birth). For the basics see Introduction To Databases and Database Terminology in Context.

Keys

KeyMeaningExample (Students table)
Candidate keyAny field (or fields) that could uniquely identify each recordStudentID, NationalID, Email – each is unique
Primary keyThe candidate key chosen to uniquely identify each record. It must be unique and cannot be emptyStudentID
Secondary (alternate) keyA candidate key that was not chosen as the primary key; or a field used to search and sort (often not unique)NationalID, Email (alternate); Surname (secondary, for searching)
Foreign keyA field in one table that is the primary key of another table; it links the tablesStudentID in the Loans table

Tip: a composite key is a primary key made of two or more fields together, e.g. StudentID + BookID + LoanDate.

Video: Primary & Foreign Keys – https://www.youtube.com/watch?v=B5r8CcTUs5Y

Data types

Data type (Access)StoresExample field
Short TextLetters, symbols and numbers not used in calculations (up to 255 characters)Name, Phone number, StudentID like “S0123”
Long TextLong textComments, Address notes
NumberNumbers used in calculationsQuantity, Age
CurrencyMoney valuesPrice, Fees
Date/TimeDates and timesDateOfBirth, LoanDate
Yes/No (Boolean)Only two valuesPaid? Returned?
AutoNumberA unique number added automatically to each new recordLoanID
OLE Object / AttachmentPictures and filesStudent photo

Why does a phone number use Short Text? It is not used in calculations, and it may start with 0 or contain +, – or spaces.

Video: Setting Up Data Types in Microsoft Access – https://www.youtube.com/watch?v=MAu7lbjl2CM

Relationships

  • One-to-one (1:1): each record in table A matches at most one record in table B. Example: each Student has one Locker; each Locker belongs to one Student.
  • One-to-many (1:M): one record in table A matches many records in table B. Example: one Student can have many Loans; each Loan belongs to one Student. The primary key on the “one” side (Students.StudentID) appears as a foreign key on the “many” side (Loans.StudentID).
  • Relationships avoid data redundancy (typing the same details again and again) and keep data consistent.
Students (one)Loans (many)
StudentID (PK)1 ──── ∞LoanID (PK)
FirstNameStudentID (FK)
SurnameBookID (FK)
FormLoanDate

Step by step: create a one-to-many relationship in Access

In Microsoft Access:

  1. Create the Students table in Design View: add the fields and data types, select StudentID and click Primary Key. Save.
  2. Create the Loans table with LoanID (AutoNumber, primary key) and a StudentID field of the same data type and size as Students.StudentID. Save and close both tables.
  3. Database Tools → Relationships. Add both tables.
  4. Drag StudentID from Students onto StudentID in Loans.
  5. In the Edit Relationships box, tick Enforce Referential Integrity (so you cannot add a loan for a student who does not exist), then Create.
  6. Access shows a line marked 1 and ∞. Save the relationships layout.

Video: MS Access Tutorial – Lesson 6 – Creating Relations with Primary Key and Foreign Key – https://www.youtube.com/watch?v=IG1RwVVgFqI

If both linked fields are primary keys (or unique), Access creates a one-to-one relationship instead. LibreOffice Base: Tools → Relationships works the same way.

Next, practise entering and using the data: Creating Forms in Microsoft Access, Creating Queries – multiple criteria, calculated fields and totals and Database reports.

Try it: Name the key or data type

Choose the correct term for each description.

StudentID, chosen to uniquely identify each student
StudentID stored in the Loans table to link to Students
Email – unique, but not chosen as the primary key
The best data type for a Fees field
The best data type for a “Book returned?” field
The best data type for a phone number

Related

Related: Modifying An Existing Database, Understanding Cascade Delete

Related: Importing Data From Excel into An Access Database

Related: Real World Database Development Example – Inventory (recorded class, Part 1)

Paper 1 practice (multiple choice)

Choose the best answer for each question. Try them all before you check.

1. A field that uniquely identifies each record in a table is the
(A) foreign key
(B) primary key
(C) secondary key
(D) index

2. A primary key from one table that appears in another table to link them is a
(A) candidate key
(B) foreign key
(C) composite key
(D) record

3. Which data type is MOST suitable for a telephone number?
(A) Number
(B) Currency
(C) Short Text
(D) Yes/No

4. One customer can place many orders. This is a
(A) one-to-one relationship
(B) one-to-many relationship
(C) many-to-one table
(D) composite key

5. Fields that could each be used as the primary key are called
(A) candidate keys
(B) foreign keys
(C) secondary tables
(D) data types

Show answers

1. B
2. B
3. C
4. B
5. A

Paper 2 practice (structured question)

A community library in Linstead stores data in two tables: MEMBERS (MemberID, Name, Phone, DateJoined) and BORROWINGS (BorrowID, MemberID, BookTitle, DateBorrowed, Returned).

(a) Identify:

(i) the primary key of MEMBERS (1 mark)

(ii) the foreign key in BORROWINGS (1 mark)

(b) State the relationship between MEMBERS and BORROWINGS and justify your answer. (2 marks)

(c) Suggest a suitable data type for EACH field:

(i) DateJoined (1 mark)

(ii) Returned (1 mark)

(d) Explain why Phone should NOT be the Number data type. (2 marks)

Total: 8 marks

Show answers

(a)

(i) MemberID (1 mark)

(ii) MemberID (1 mark)

(b) One-to-many (1) – one member can borrow many books, but each borrowing belongs to only one member (1).

(c)

(i) Date/Time (1 mark)

(ii) Yes/No (Boolean) (1 mark)

(d) Phone numbers are not used in calculations (1), and may begin with 0 or contain symbols such as +, – or spaces, which a Number field would remove/reject (1).

Next: Steps in Problem-Solving and the Divide-and-Conquer Approach

Syllabus link: This post is relevant to the CSEC® Information Technology Syllabus (CXC 30/G/SYLL 17), Section 6: Database Management, Specific Objective 2 (“use terminology commonly associated with a database”); Specific Objective 3 (“create a database”).

Attributions to media used in this post:

No third-party images are used in this post. Embedded videos are credited on YouTube to their channels.

© 2026 Vedesh Kungebeharry. All rights reserved.

Spreadsheets: Choosing, Creating and Formatting Charts

“A picture is worth a thousand numbers.” A chart lets a reader see patterns and comparisons at a glance. In this post you will learn to choose the right type of chart, create it in Excel, and format it with titles, labels and a legend.

Build on what you learned in Forms 1–3

These Lower School ICT posts cover the basics of this topic:

In this post:

  • Types of chart and when to use each
  • Creating a chart step by step
  • Parts of a chart
  • Formatting and changing a chart
  • Common mistakes

Choosing the right chart

ChartBest forExample
Column / bar chartComparing amounts across categoriesRainfall in each Caribbean island; marks of each student
Line graphShowing change over time (trends)Temperature each month; sales over a year
Pie chartShowing parts of a whole (percentages), one data series onlyHow a family budget is divided; votes per candidate
Scatter (XY) chartRelationship between two sets of numbersHours studied vs exam mark

Creating a chart

AB
1MonthVisitors (thousands)
2Jan42
3Feb58
4Mar47
5Apr35

Practice data – type this into a new worksheet.

In Excel:

  1. Select the data including the headings (A1:B5). To select columns that are not next to each other, hold Ctrl.
  2. Insert → choose a chart type in the Charts group (e.g. Clustered Column), or Insert → Recommended Charts.
  3. The chart appears on the worksheet. Drag it to position it; drag the corners to resize.
  4. To put the chart on its own sheet: Chart Design → Move Chart → New sheet.

Video: Excel: Charts – https://www.youtube.com/watch?v=_Wu7jYTr1Pk

Parts of a chart

  • Chart title – says what the chart shows.
  • Axis titles – label the x-axis (categories, e.g. Month) and y-axis (values, e.g. Visitors in thousands).
  • Legend – explains the colours when there is more than one data series.
  • Data labels – show the actual value or percentage on each bar or slice.
  • Data series – the set of values being plotted.
  • Gridlines – help read values.

Formatting and changing a chart

  • Click the chart, then the + (Chart Elements) button to add or remove the title, axis titles, legend and data labels.
  • Chart Design → Change Chart Type to switch, e.g., from column to line.
  • Chart Design → Select Data to change the range or add a series.
  • Switch Row/Column swaps what is on the x-axis and in the legend.
  • Double-click any element to format its colour, font or number format.

Google Sheets: Insert → Chart, then use the Chart editor (Setup and Customize). LibreOffice Calc: Insert → Chart opens a step-by-step wizard.

Common mistakes

  • Using a pie chart for data that does not make up a whole, or with too many slices.
  • Forgetting the chart title or axis titles (marks are often lost here).
  • Selecting a total row along with the data, which distorts the chart.
  • Using a line graph for categories that are not in time order.

Try it: Choose the chart

Choose the most suitable chart for each set of data.

Monthly rainfall in Barbados over one year, to show the trend
The percentage of a school’s students in each house
Comparing the population of five Caribbean islands
Whether taller students tend to have bigger shoe sizes

Related

Related: Excel Charts, Pivot Tables Intro (recorded class)

Paper 1 practice (multiple choice)

Choose the best answer for each question. Try them all before you check.

1. Which chart is BEST for showing how a whole is divided into parts?
(A) Line graph
(B) Pie chart
(C) Scatter chart
(D) Column chart

2. The part of a chart that explains what each colour represents is the
(A) title
(B) legend
(C) axis
(D) gridline

3. To show a trend in temperature over twelve months, the best chart is a
(A) pie chart
(B) line graph
(C) bar chart of categories
(D) table

4. Before inserting a chart you should first
(A) save the file
(B) select the data, including headings
(C) sort the data descending
(D) freeze panes

5. Values shown directly on the bars of a chart are called
(A) data labels
(B) legends
(C) axis titles
(D) gridlines

Show answers

1. B
2. B
3. B
4. B
5. A

Paper 2 practice (structured question)

A Form 5 class recorded the number of tourists (in thousands) arriving in Tobago each month for one year, and how the tourists travelled (air or sea).

(a) Recommend a suitable chart for showing the monthly trend and give a reason. (2 marks)

(b) Name a chart for showing the proportion who came by air and by sea, and give a reason. (2 marks)

(c) State TWO chart elements that should be added to make the chart in (a) easy to understand. (2 marks)

(d) Outline the steps to create the chart in (a) on a separate sheet. (2 marks)

Total: 8 marks

Show answers

(a) Line graph (1) – shows change over time/trends clearly (1).

(b) Pie chart (1) – shows parts of a whole/percentages (1).

(c) Any two (1 each):
• chart title
• axis titles (Month, Tourists in thousands)
• legend
• data labels

(d) Select the month and tourist data with headings and Insert → Line chart (1); Chart Design → Move Chart → New sheet (1).

Next: Databases: Primary, Candidate, Secondary and Foreign Keys, Data Types and Relationships

Syllabus link: This post is relevant to the CSEC® Information Technology Syllabus (CXC 30/G/SYLL 17), Section 5: Spreadsheets, Specific Objective 8 (“perform charting operations”).

Attributions to media used in this post:

No third-party images are used in this post. Embedded videos are credited on YouTube to their channels.

Updates

2026/10/16

– Lists and algorithms laid out line by line.

© 2026 Vedesh Kungebeharry. All rights reserved.

Spreadsheets: Number Formats, Sorting, Filtering and Pivot Tables

A spreadsheet full of numbers only becomes useful when the data is easy to read and organised. In this post you will learn to manipulate data: apply number formats (currency, percentage, decimal places, dates), sort records, filter to show only the records you need, and summarise data with a pivot table.

Build on what you learned in Forms 1–3

These Lower School ICT posts cover the basics of this topic:

In this post:

  • Number formats
  • Sorting (single and multi-level)
  • Filtering (AutoFilter and advanced filter)
  • Pivot tables and pivot charts – a quick guide

Number formats

A number format changes how a value looks, not the value itself. Select the cells, then Home → Number group, or right-click → Format Cells → Number.

FormatExampleUse
General1250.5Default
Number (2 decimal places)1250.50Measurements, averages
Currency / Accounting$1,250.50Money (choose the $ symbol for your country)
Percentage12.5%Rates, marks (0.125 shown as 12.5%)
Date16/10/2026 or 16-Oct-26Dates – stored as numbers so they can be sorted and subtracted
Text00123Phone numbers, ID numbers with leading zeros

Use the Increase/Decrease Decimal buttons to change decimal places. Remember: the cell still holds the full value – 3.14159 shown as 3.14 is still 3.14159 in calculations.

Video: Excel: Understanding Number Formats – https://www.youtube.com/watch?v=fjyOG7Ls7BA

Sorting

Sort a list (Excel):

  1. Click any cell in the list (make sure there are no blank rows or columns inside it).
  2. Data → Sort. Tick “My data has headers”.
  3. Sort by: choose the column (e.g. Surname); Order: A to Z (ascending) or Z to A (descending).
  4. For a multi-level sort, click Add Level – e.g. sort by Form, then by Surname within each Form.
  5. Click OK. Whole rows move together, so records stay intact.

Warning: if you select only one column and sort it, Excel may ask to expand the selection – always choose Expand the selection, or the data in other columns will no longer match.

Video: Excel: Sorting Data – https://www.youtube.com/watch?v=Ep5q1cUhQas

Filtering

  • AutoFilter: click in the list → Data → Filter. Drop-down arrows appear in the headings. Choose values to show (e.g. only Form 4A), or use Number Filters (e.g. Greater Than 75) and Text Filters (e.g. Begins With “S”). Other rows are hidden, not deleted.
  • Clear a filter: Data → Clear. Turn filters off: click Filter again.
  • Advanced Filter: type the criteria in a separate criteria range (copy of the headings plus conditions below), then Data → Advanced. You can copy the results to another location.

Video: Excel: Filtering Data – https://www.youtube.com/watch?v=_OdsZR_rL1U

Pivot tables and pivot charts

A pivot table summarises a large list – for example total sales by month and by product – by dragging fields into Rows, Columns, Values and Filters. A pivot chart is a chart based on the pivot table.

Create a pivot table:

  1. Click in the list → Insert → PivotTable → New Worksheet → OK.
  2. Drag a field (e.g. Product) to Rows, another (e.g. Month) to Columns, and a number field (e.g. Sales) to Values (it will Sum by default; change to Average or Count with Value Field Settings).
  3. Insert → PivotChart to chart it.

Video: Excel: Intro to PivotTables – https://www.youtube.com/watch?v=N4K3xjM76kI

For worked examples see A pivot table’s intended use and Using a pivot table to make sense of unknown data.

Google Sheets: Format → Number; Data → Sort range / Create a filter; Insert → Pivot table.
LibreOffice Calc:
Format → Cells; Data → Sort / AutoFilter; Insert → Pivot Table.

Try it: Format, sort, filter or pivot?

Choose the best feature for each task.

Show 0.15 as 15%
List students from highest to lowest mark
Show only the students in Form 5B
Find total sales for each product in each month from 2,000 sales records
Show 1500 as $1,500.00

Related

Related: Pivot tables

Related: Excel Charts, Pivot Tables Intro (recorded class)

Paper 1 practice (multiple choice)

Choose the best answer for each question. Try them all before you check.

1. Which feature displays only the records that meet a condition, hiding the others?
(A) Sort
(B) Filter
(C) Freeze Panes
(D) AutoSum

2. Arranging records from Z to A is a sort in
(A) ascending order
(B) descending order
(C) alphabetical filter
(D) numerical format

3. A cell contains 0.08. Formatted as a percentage it displays
(A) 0.08%
(B) 8%
(C) 80%
(D) 800%

4. Which tool is BEST for summarising total sales by region and month?
(A) Pivot table
(B) Freeze Panes
(C) Find and Replace
(D) Text format

5. Changing the number format of 3.456 to show 3.46
(A) changes the stored value to 3.46
(B) only changes how it is displayed
(C) deletes the decimals
(D) rounds it in every formula

Show answers

1. B
2. B
3. B
4. A
5. B

Paper 2 practice (structured question)

A sports club keeps a spreadsheet of 120 members with columns: Member ID, Name, Age, Sport, Fees Paid. The fees appear as 350 instead of $350.00.

(a) Name the number format that should be applied to the Fees Paid column. (2 marks)

(b) Describe how to sort the members by Sport and then by Name within each sport. (2 marks)

(c) Explain how a filter could be used to show only members who play football and are under 16. (2 marks)

(d) The treasurer wants the total fees for each sport. Name the most suitable tool and state ONE advantage. (2 marks)

Total: 8 marks

Show answers

(a) Currency/Accounting format (1) with 2 decimal places (1).

(b) Data → Sort, sort by Sport (1); Add Level, then by Name, both A to Z (1).

(c) Turn on AutoFilter (Data → Filter) (1); choose “Football” in the Sport column and Number Filter “Less Than 16” in the Age column (1).

(d) A pivot table (1); advantage: it summarises large amounts of data quickly/automatically and can be rearranged easily (1). (Accept SUMIF with a suitable advantage.)

Next: Spreadsheets: Choosing, Creating and Formatting Charts

Syllabus link: This post is relevant to the CSEC® Information Technology Syllabus (CXC 30/G/SYLL 17), Section 5: Spreadsheets, Specific Objective 7 (“manipulate data in a spreadsheet”).

Attributions to media used in this post:

No third-party images are used in this post. Embedded videos are credited on YouTube to their channels.

Updates

2026/10/16

– Lists and algorithms laid out line by line.

© 2026 Vedesh Kungebeharry. All rights reserved.

Spreadsheets: Manipulating Rows and Columns – Insert, Delete, Hide, Resize and Freeze

As your spreadsheet grows you will need to add a forgotten row, remove an empty column, widen a column that shows ####, hide working columns, or keep the headings visible while you scroll. This post shows you how to manipulate columns and rows.

Build on what you learned in Forms 1–3

These Lower School ICT posts cover the basics of this topic:

In this post:

  • Selecting rows and columns
  • Inserting and deleting
  • Changing width and height (and why you see ####)
  • Hiding and unhiding
  • Freezing panes
  • Moving rows and columns

Selecting rows and columns

  • Click the column letter (e.g. C) to select the whole column; click the row number (e.g. 5) to select the whole row.
  • Drag across headings, or Shift+click, to select several next to each other; Ctrl+click for ones that are apart.

Inserting and deleting

Insert a row or column (Excel):

  1. Right-click the row number below where you want the new row (or the column letter to the right of where you want a new column).
  2. Choose Insert. (Or Home → Insert → Insert Sheet Rows / Columns.)
  3. A blank row appears above (or a column to the left). Formulas that refer to cells that moved are updated automatically.

Delete a row or column:

  1. Right-click the row number or column letter.
  2. Choose Delete. (Pressing the Delete key only clears the contents – it does not remove the row.)
  3. Check formulas: if a formula used a deleted cell it will show #REF!.

Changing column width and row height

  • Drag the boundary to the right of the column letter (or below the row number).
  • Double-click the boundary to AutoFit to the longest entry.
  • Home → Format → Column Width / Row Height to type an exact size.
  • #### in a cell means the column is too narrow to show the number or date – widen it.
  • Wrap Text (Home tab) lets long labels go on to several lines in a cell.

Video: Excel: Modifying Columns, Rows, and Cells – https://www.youtube.com/watch?v=9s0OdXiuqL0

Hiding and unhiding

  • Right-click a row number or column letter → Hide. The data is still there and formulas still use it – it is just not shown (or printed).
  • To unhide, select the rows/columns on both sides of the hidden ones → right-click → Unhide.
  • Useful for hiding working columns or confidential data before printing.

Freezing panes

Freeze Panes keeps headings visible while you scroll through a long list.

In Excel:

  1. To keep row 1 visible: View → Freeze Panes → Freeze Top Row.
  2. To keep column A visible: View → Freeze Panes → Freeze First Column.
  3. To freeze both rows and columns: click the cell just below and to the right of what should stay (e.g. B2), then View → Freeze Panes → Freeze Panes.
  4. Unfreeze with View → Freeze Panes → Unfreeze Panes.

Video: Excel: Freeze Panes and View Options – https://www.youtube.com/watch?v=zuhsUNBeNHw

Moving rows and columns

Select the row or column, Cut (Ctrl+X), right-click the heading where it should go and choose Insert Cut Cells. Or hold Shift and drag the border of the selection.

Google Sheets: right-click headings for Insert/Delete/Hide; View → Freeze.
LibreOffice Calc:
right-click headings; View → Freeze Cells.

Try it: Which operation?

Choose the operation for each task.

A column shows ##### instead of a date
Keep the headings in row 1 visible while scrolling to row 300
Add a new student between rows 6 and 7
Stop a column of confidential salaries from printing, without losing the data
Remove an empty column C completely

Related

Related: Excel Skills Tutorial Part 1 (recorded class)

Paper 1 practice (multiple choice)

Choose the best answer for each question. Try them all before you check.

1. A cell displays ##### . The most likely reason is that
(A) the formula is wrong
(B) the column is too narrow
(C) the cell is protected
(D) the data was deleted

2. To keep the column headings visible while scrolling down, you would use
(A) Hide
(B) Freeze Panes
(C) Wrap Text
(D) Merge

3. When a row is inserted above row 5, the old row 5 becomes
(A) row 4
(B) row 5
(C) row 6
(D) it is deleted

4. Hiding a column
(A) deletes its data
(B) removes it from formulas
(C) stops it being displayed, but the data remains
(D) sorts it

5. After deleting a row that a formula refers to, the formula may show
(A) ####
(B) #REF!
(C) #VALUE!
(D) 0

Show answers

1. B
2. B
3. C
4. C
5. B

Paper 2 practice (structured question)

A form teacher keeps a spreadsheet of 35 students. Row 1 has headings (Name, Test 1, Test 2, Average, Parent Phone). When she scrolls down, the headings disappear. A new student has joined, and the Average column shows #####.

(a) State the feature that would keep the headings visible while she scrolls. (2 marks)

(b) Describe how she would insert a row for the new student between rows 10 and 11. (2 marks)

(c) Explain why the Average column shows ##### and how to fix it. (2 marks)

(d) She wants to print the list without the Parent Phone column but keep the data:

(i) name the feature (1 mark)

(ii) state ONE reason it is better than deleting the column (1 mark)

Total: 8 marks

Show answers

(a) Freeze Panes (1) – Freeze Top Row / freeze row 1 (1).

(b) Right-click row number 11 (1) and choose Insert, which adds a blank row above it (1).

(c) The column is too narrow to display the numbers (1); widen it by dragging/double-clicking the column boundary (AutoFit) (1).

(d)

(i) Hide the column (1 mark)

(ii) The data is kept and can be unhidden later/formulas that use it still work (1 mark)

Next: Spreadsheets: Number Formats, Sorting, Filtering and Pivot Tables

Syllabus link: This post is relevant to the CSEC® Information Technology Syllabus (CXC 30/G/SYLL 17), Section 5: Spreadsheets, Specific Objective 6 (“manipulate columns and rows”).

Attributions to media used in this post:

No third-party images are used in this post. Embedded videos are credited on YouTube to their channels.

Updates

2026/10/16

– Lists and algorithms laid out line by line.

© 2026 Vedesh Kungebeharry. All rights reserved.

Spreadsheets: Copying Formulas with Relative, Absolute and Mixed Cell References and Named Ranges

One of the biggest time-savers in a spreadsheet is writing a formula once and copying it down a whole column. But copy the wrong kind of formula and every answer is wrong. In this post you will learn how relative, absolute and mixed cell references behave when you replicate (copy) formulae, and how named ranges make formulas easier to read. Steps are for Microsoft Excel, with Google Sheets and LibreOffice Calc notes.

Build on what you learned in Forms 1–3

These Lower School ICT posts cover the basics of this topic:

In this post:

  • Replicating formulae with the fill handle
  • Relative references (A1)
  • Absolute references ($A$1)
  • Mixed references ($A1 and A$1)
  • Named ranges

Replicating a formula

In Excel:

  1. Type the formula in the first cell, e.g. =B2*C2 in D2, and press Enter.
  2. Click D2 and point at the small square in the bottom-right corner (the fill handle) until the pointer becomes a thin black +.
  3. Drag down to the last row (or double-click the fill handle to fill down automatically).
  4. Alternatively: copy (Ctrl+C), select the target cells, paste (Ctrl+V); or select the range and press Ctrl+D (fill down).

Relative references

A normal reference such as B2 is relative: when the formula is copied, the reference changes relative to its new position. Copy =B2*C2 from D2 down to D3 and it becomes =B3*C3. This is what you want for most row-by-row calculations.

ABCD
1ItemPrice ($)QtyTotal
2Roti253=B2*C2 → 75
3Doubles65=B3*C3 → 30
4Sorrel drink152=B4*C4 → 30

The formula in D2 was copied down; Excel changed the row numbers automatically.

Absolute references

Sometimes every formula must use the same cell – for example a VAT rate or exchange rate stored in one place. Put a $ before the column letter and row number to make it absolute: $F$1. It does not change when copied. Press F4 after typing a reference to add the $ signs.

ABCF
1ItemPrice ($)VATVAT rate0.125
2Roti25=B2*$F$1 → 3.13
3Doubles6=B3*$F$1 → 0.75
4Sorrel drink15=B4*$F$1 → 1.88

B changes as it is copied (relative); $F$1 stays fixed (absolute). Without the $ signs, the copy in C3 would use F2, which is empty, giving 0.

Video: Excel: Relative and Absolute Cell References – https://www.youtube.com/watch?v=iDg9s7BJ2m4

Mixed references

  • $A1 – the column is fixed, the row changes.
  • A$1 – the row is fixed, the column changes.
  • Press F4 repeatedly to cycle: A1 → $A$1 → A$1 → $A1 → A1.
  • Useful for tables like a multiplication grid where one value is in a fixed row and the other in a fixed column.

Named ranges

A named range gives a cell or range a meaningful name, such as VATRate or Prices. Formulas become easier to read – =B2*VATRate – and a name always refers to the same cells, so it behaves like an absolute reference when copied.

To create a name in Excel:

  1. Select the cell or range (e.g. F1).
  2. Click in the Name Box (left of the formula bar), type a name with no spaces (e.g. VATRate) and press Enter. Or use Formulas → Define Name.
  3. Use it in formulas: =B2*VATRate, =SUM(Prices).
  4. Manage names with Formulas → Name Manager.

Video: How to Create Named Ranges in Excel – https://www.youtube.com/watch?v=pnSXJC5HJ4c

Google Sheets: $ and F4 work the same; Data → Named ranges.
LibreOffice Calc:
F4 (Shift+F4 in some versions) toggles references; Sheet → Named Ranges and Expressions → Define.

Try it: What does it become?

Each formula is in row 2 and is copied down ONE row to row 3. Choose what it becomes.

=B2*C2
=B2*$F$1
=$B$2+C2
=B$2*C2
=SUM(B2:D2)

Related

Related: Practical Exercise – Range names, Advanced Filters, Linking to other sheets

Related: Advanced formulae – Spreadsheets

Paper 1 practice (multiple choice)

Choose the best answer for each question. Try them all before you check.

1. Which of the following is an absolute cell reference?
(A) B5
(B) $B5
(C) B$5
(D) $B$5

2. The formula =A2*B2 in C2 is copied to C5. It becomes
(A) =A2*B2
(B) =A5*B5
(C) =A3*B3
(D) =$A$5*$B$5

3. Which key toggles a reference between relative and absolute in Excel?
(A) F2
(B) F4
(C) F7
(D) F9

4. The formula =B4*$H$2 is copied from row 4 to row 6. It becomes
(A) =B6*$H$4
(B) =B6*$H$2
(C) =B4*$H$2
(D) =B6*H4

5. A meaningful name given to a cell or group of cells is called a
(A) label
(B) named range
(C) function
(D) field

Show answers

1. D
2. B
3. B
4. B
5. B

Paper 2 practice (structured question)

A small store uses a spreadsheet to calculate the price of goods in US dollars. Prices in TT$ are in B2:B20 and the exchange rate (TT$ per US$1) is in cell E1.

(a) Write a formula for C2 that converts the price in B2 to US dollars and can be copied down to C20. (2 marks)

(b) Explain why an absolute reference is needed in your formula. (2 marks)

(c) The formula =B2/E1 was copied from C2 to C3:

(i) state what it becomes (1 mark)

(ii) explain why the answer is wrong (1 mark)

(d) Describe how a named range could be used for the exchange rate, and give ONE advantage. (2 marks)

Total: 8 marks

Show answers

(a) =B2/$E$1 (1 mark for dividing B2 by E1, 1 mark for the absolute reference $E$1).

(b) The exchange rate is in one fixed cell (1); without the $ signs the reference would change to E2, E3… when copied, which are empty/wrong (1).

(c)

(i) =B3/E2 (1 mark)

(ii) E2 is empty/not the exchange rate, so the result is an error or wrong (1 mark)

(d) Select E1 and type a name such as Rate in the Name Box, then use =B2/Rate (1); advantage: easier to read/understand, or stays fixed when copied (1).

Next: Spreadsheets: Manipulating Rows and Columns – Insert, Delete, Hide, Resize and Freeze

Syllabus link: This post is relevant to the CSEC® Information Technology Syllabus (CXC 30/G/SYLL 17), Section 5: Spreadsheets, Specific Objective 5 (“replicate (copy) formulae into other cells”).

Attributions to media used in this post:

No third-party images are used in this post. Embedded videos are credited on YouTube to their channels.

Updates

2026/10/16

– Lists and algorithms laid out line by line.

© 2026 Vedesh Kungebeharry. All rights reserved.

Hyperlinks in Documents and Web Pages, and How to Evaluate a Website

Hyperlinks are what make the Web a “web”. In this post you will learn the four kinds of hyperlinks the syllabus asks for – to another web page, to a place on the same page, to an email address and to a file – how to insert them in a website builder and in Word, and then how to evaluate a website for accuracy, user friendliness and effective display.

Build on what you learned in Forms 1–3

These Lower School ICT posts cover the basics of this topic:

In this post:

  • What a hyperlink is
  • The four types of hyperlink
  • Inserting hyperlinks in a website builder and in Word
  • Evaluating a website: accuracy, user friendliness and effective display

What is a hyperlink?

A hyperlink is text or an image that you click to go somewhere else – another page, another part of the same page, a new email, or a file to download. Linked text is usually underlined or a different colour, and the mouse pointer changes to a hand.

The four types of hyperlink

TypeGoes toExample
Link to another web pageA page on the same site or on another website“See our Menu” → the Menu page; a link to the CXC website
Link to a location on the same pageA bookmark (anchor) further up or down the pageA “Back to top” link; a list of questions at the top of an FAQ page that jump to each answer
Email linkOpens a new email to an address (a “mailto:” link)“Email us” → a new message to info@rotihut.tt
Link to a user fileA document, PDF, image or other file to view or download“Download our price list (PDF)”

Inserting hyperlinks in a website builder (WordPress.com)

Steps:

  1. Select the text (or image) to turn into a link.
  2. Click the link icon (or press Ctrl+K).
  3. Another page: search for one of your pages or paste the full web address (https://…).
  4. Same page: on the target heading, open Advanced → HTML anchor and type a name such as menu; then link to #menu.
  5. Email: type mailto: followed by the address, e.g. mailto:info@rotihut.tt.
  6. File: upload it with a File block or the Media Library, then link to it.
  7. Preview and click every link to test it.

Inserting hyperlinks in Microsoft Word

Steps:

  1. Select the text and press Ctrl+K (Insert → Link).
  2. Existing File or Web Page: type a web address, or browse to a file.
  3. Place in This Document: choose a heading or a bookmark (create one first with Insert → Bookmark).
  4. E-mail Address: type the address and an optional subject.
  5. Click OK, then Ctrl+click the link to test it.

Video: How to Add Hyperlinks and Bookmarks in Word | Step-by-Step Tutorial – https://www.youtube.com/watch?v=455xogsNMQE

Google Docs: Insert → Link (Ctrl+K); choose “Headings and bookmarks” for a same-document link.

Try it: Sort the hyperlinks

Choose the type of each hyperlink.

“Back to top” at the bottom of a long page
“Contact the principal” opens a new message
“Download the school calendar (PDF)”
“Visit the CXC website”
A list of FAQ questions that jump to each answer below
“Gallery” in the navigation bar

Evaluating a website

When you evaluate a website (yours or someone else’s) use three headings:

CriterionQuestions to ask
AccuracyIs the information correct and up to date? Are there spelling or grammar errors? Are prices, dates and contact details right? Is the source credible?
User friendlinessIs the navigation clear and consistent? Do all links work? Can you find what you need in one or two clicks? Does it load quickly and work on a phone?
Effective displayIs the text readable (font, size, contrast)? Are colours consistent and suitable for the audience? Are images relevant and good quality? Is the layout uncluttered with good use of white space?

Video: 8 Tips to Help Students Evaluate Websites – https://www.youtube.com/watch?v=TVptfuj6_yk

For judging whether information online is reliable, see Can You Trust It? Evaluating Information You Find Online.

Related

Related: Setting up your homepage and adding links

Paper 1 practice (multiple choice)

Choose the best answer for each question. Try them all before you check.

1. A link that opens a new email message to a given address is called
(A) a bookmark
(B) a mailto (email) link
(C) an anchor image
(D) a file link

2. A “Back to top” link at the bottom of a page links to
(A) another website
(B) a location on the same page
(C) an email address
(D) a PDF file

3. In Word, the keyboard shortcut to insert a hyperlink is
(A) Ctrl+H
(B) Ctrl+K
(C) Ctrl+L
(D) Ctrl+B

4. Checking that all links work and pages are easy to find is part of evaluating a website’s
(A) accuracy
(B) user friendliness
(C) copyright
(D) file size

5. Which would REDUCE the effective display of a web page?
(A) Consistent fonts
(B) Bright yellow text on a white background
(C) Relevant images
(D) Clear headings

Show answers

1. B
2. B
3. B
4. B
5. B

Paper 2 practice (structured question)

Students in a Form 4 class have built a website for their school’s Environmental Club. The home page has a long list of events, a link to download a membership form, and the teacher’s email address.

(a) Identify the type of hyperlink needed for EACH of the following:

(i) the membership form (1 mark)

(ii) the teacher’s email address (1 mark)

(b) The events list is very long. Suggest a type of hyperlink that would help visitors, and explain how it helps. (2 marks)

(c) Describe TWO things the students should check when evaluating the website for user friendliness. (2 marks)

(d) Describe TWO things they should check when evaluating it for accuracy. (2 marks)

Total: 8 marks

Show answers

(a)

(i) Link to a user file/document (1 mark)

(ii) Email (mailto) link (1 mark)

(b) Links to locations on the same page/bookmarks, e.g. a list of months at the top and “Back to top” links (1); visitors can jump straight to the event they want without scrolling (1).

(c) Any two (1 each):
• all links work
• navigation bar is clear and consistent
• pages can be reached in one or two clicks
• loads quickly
• works on mobile phones

(d) Any two (1 each):
• event dates/times/venues are correct
• information is up to date
• no spelling/grammar errors
• contact details are correct
• facts are from credible sources

Next: Spreadsheets: Copying Formulas with Relative, Absolute and Mixed Cell References and Named Ranges

Syllabus link: This post is relevant to the CSEC® Information Technology Syllabus (CXC 30/G/SYLL 17), Section 4: Word-Processing and Web Page Design, Specific Objective 11 (“insert hyperlinks within different locations of a typical web page”); Specific Objective 12 (“evaluate a website for accuracy, user friendliness and effective display”).

Attributions to media used in this post:

No third-party images are used in this post. Embedded videos are credited on YouTube to their channels.

Updates

2026/10/16

– Lists and algorithms laid out line by line.

© 2026 Vedesh Kungebeharry. All rights reserved.

Planning and Designing a Website: Site Structure, Page Layout and Design Features

A good website is planned before it is built. In this post you will learn how to plan the structure of a website and the layout of its pages, and how to create simple web pages with good design features using a website builder such as WordPress.com, Google Sites or Wix. The CSEC syllabus does not require HTML coding – you build pages with a WYSIWYG (“What You See Is What You Get”) editor.

Build on what you learned in Forms 1–3

These Lower School ICT posts cover the basics of this topic:

In this post:

  • Planning: purpose, audience and content
  • Site structure: home page, pages and navigation
  • Planning page layout (a storyboard or wireframe)
  • Design features: text, images, colour, navigation bar, consistency
  • Building pages with a website builder, step by step

Planning: purpose, audience and content

  • Purpose – Why does the site exist? (e.g. to advertise a restaurant, share a school club’s events, sell crafts.)
  • Audience – Who will use it? (customers, parents, tourists, students.) This affects language, colours and images.
  • Content – What text, images, videos, contact details and documents are needed for each page?

Site structure

The home page is the first page visitors see; it introduces the site and links to the other pages. A site map (structure diagram) shows all the pages and how they link together. Small sites usually use a hierarchical structure: Home at the top, the main pages below it.

Home
│
About Us
Menu
Gallery
Contact

A simple hierarchical site structure for a small restaurant website. Every page links back to Home through the navigation bar.

  • Keep the number of main pages small (about 3–7).
  • Give pages short, clear names for the navigation bar (Home, About, Services, Contact).
  • Every page should link back to Home.

Video: How to create a sitemap (for any website) – https://www.youtube.com/watch?v=R_UYM9yEuYg

Planning page layout

Sketch each page on paper first (a storyboard or wireframe). Show where each part goes:

  • Header – site name/logo at the top.
  • Navigation bar – links to the main pages, in the same place on every page.
  • Main content – headings, text, images, videos.
  • Footer – contact details, copyright, social media links.

Design features of a good web page

  • Consistency – same colours, fonts, header and navigation on every page.
  • Readable text – clear fonts, short paragraphs, headings, good contrast (dark text on a light background).
  • Suitable images – relevant, good quality, not too large to load, with alternative (alt) text and credit where needed.
  • Colour scheme – two or three colours that suit the purpose and audience.
  • White space – do not crowd the page.
  • Easy navigation – visitors can reach any page in one or two clicks.
  • Mobile friendly – check it on a phone.

Video: Beginning Graphic Design: Layout & Composition – https://www.youtube.com/watch?v=a5KYlHNKQB8

Step by step: build a simple site with a website builder

Using WordPress.com (Google Sites and Wix work in a similar way):

  1. Create a free site and choose a simple theme (design).
  2. Edit the Home page: click the title and type; click + to add blocks such as Heading, Paragraph, Image, Video or Button.
  3. Add pages: Pages → Add new page (e.g. About, Menu, Gallery, Contact).
  4. Set up the navigation menu so all pages appear in the header.
  5. Add images with alt text, and keep colours and fonts consistent.
  6. Preview on desktop and mobile, fix any problems, then Publish.

For detailed walk-throughs with screenshots see Creating a website and choosing a design using wordpress.com, Setting up your homepage and adding links and Adding a Webpage with common website elements.

Try it: Planning or design?

For each item, choose where it belongs.

Deciding the site is for tourists visiting Tobago
Drawing boxes showing Home linked to four pages
Sketching where the header, menu and photos go on a page
Using the same colours and fonts on every page
A set of links to the main pages in the same place on every page

Related

Related: Web Design – WordPress.com Assignment

Related: Website Exercise

Paper 1 practice (multiple choice)

Choose the best answer for each question. Try them all before you check.

1. The first page a visitor normally sees on a website is the
(A) site map
(B) home page
(C) footer
(D) navigation bar

2. A diagram showing all the pages of a website and how they are linked is a
(A) storyboard
(B) site map
(C) table of contents
(D) spreadsheet

3. WYSIWYG stands for
(A) What You See Is What You Get
(B) World Wide Your Information Gateway
(C) Web Your Site In Website Generator
(D) Write Your Script In Web Graphics

4. Which is a good design feature for a web page?
(A) A different colour scheme on every page
(B) Long paragraphs with no headings
(C) A consistent navigation bar on every page
(D) Very large images that load slowly

5. Before building a website, the FIRST thing to decide is
(A) the font colour
(B) its purpose and audience
(C) the copyright notice
(D) the image file sizes

Show answers

1. B
2. B
3. A
4. C
5. B

Paper 2 practice (structured question)

Roti Hut, a small restaurant in Chaguanas, wants a website so customers can see its menu, opening hours, photos and how to contact the owner.

(a) State the purpose and the main audience of the website:

(i) purpose (1 mark)

(ii) audience (1 mark)

(b) Suggest FOUR pages for the website, including the home page. (2 marks)

(c) Draw or describe a suitable site structure for the website. (2 marks)

(d) Describe TWO design features that would make the website user friendly. (2 marks)

Total: 8 marks

Show answers

(a)

(i) To advertise the restaurant/show the menu and contact details (1 mark)

(ii) Customers/people who want to buy food (1 mark)

(b) Home plus any three suitable pages, e.g. Menu, About Us, Gallery/Photos, Contact/Location (½ each, max 2; or 2 marks for four suitable pages).

(c) A hierarchical structure (1) with Home at the top linking to each of the other pages, and each page linking back to Home (1).

(d) Any two (1 each):
• consistent navigation bar on every page
• readable fonts with good contrast
• consistent colour scheme
• relevant, quick-loading images
• contact details in the footer
• works well on mobile phones

Next: Hyperlinks in Documents and Web Pages, and How to Evaluate a Website

Syllabus link: This post is relevant to the CSEC® Information Technology Syllabus (CXC 30/G/SYLL 17), Section 4: Word-Processing and Web Page Design, Specific Objective 9 (“plan a website structure and organization of page”); Specific Objective 10 (“create simple web pages using a variety of design features”).

Attributions to media used in this post:

No third-party images are used in this post. Embedded videos are credited on YouTube to their channels.

Updates

2026/10/16

– Lists and algorithms laid out line by line.

© 2026 Vedesh Kungebeharry. All rights reserved.

Word Processing: How to Generate a Table of Contents

A long report is much easier to use when it has a table of contents (TOC) at the front listing each heading and its page number. Typing one by hand is slow and the page numbers go wrong as soon as you edit. Word can generate a table of contents automatically from your headings and update it in one click.

Build on what you learned in Forms 1–3

These Lower School ICT posts cover the basics of this topic:

In this post:

  • Why use an automatic table of contents
  • Step 1: apply heading styles
  • Step 2: insert the table of contents
  • Step 3: update it after editing
  • Tips and common mistakes

Why generate a table of contents?

  • Page numbers are worked out for you and can be updated instantly.
  • Each entry is a hyperlink – Ctrl+click jumps to that section.
  • It shows the structure of the document (main headings and sub-headings).
  • It looks professional, e.g. for a class project report.

Step 1: Apply heading styles

In Microsoft Word:

  1. Select a main heading, e.g. “Introduction”.
  2. Home → Styles → click Heading 1.
  3. For sub-headings under it, choose Heading 2 (and Heading 3 for the next level).
  4. Repeat for every heading. Tip: View → Navigation Pane shows all your headings – if one is missing, it does not have a heading style yet.

You can change how Heading 1 looks (right-click it in the Styles gallery → Modify) and every Heading 1 updates at once.

Step 2: Insert the table of contents

In Microsoft Word:

  1. Click at the start of the document where the TOC should go (often on its own page after the title page – use Insert → Page Break).
  2. References → Table of Contents.
  3. Choose Automatic Table 1 or Automatic Table 2. (Custom Table of Contents lets you choose how many levels to show and the tab leader dots.)

Video: Creating a Table of Contents in Microsoft Word – https://www.youtube.com/watch?v=0cN-JX6HP7c

Step 3: Update it after editing

When you add, delete or move text:

  1. Click inside the table of contents.
  2. Click Update Table (or References → Update Table, or press F9).
  3. Choose Update page numbers only if you only changed text, or Update entire table if you added or renamed headings.

Google Docs: use Heading 1/2 styles, then Insert → Table of contents; click the refresh icon to update.
LibreOffice Writer:
Insert → Table of Contents and Index → Table of Contents; right-click → Update Index.

Tips and common mistakes

  • Do not type the TOC by hand – it will not update.
  • Do not just make headings bold and large; they must use Heading styles to appear.
  • Update the table before printing or submitting.
  • Do not include the TOC page or title page headings as Heading styles if you do not want them listed.

Try it: Put the TOC steps in order

Choose the step number for each action.

Apply Heading 1 and Heading 2 styles to your headings
Click where the table of contents should go
References → Table of Contents → Automatic Table
Edit the document and add a new section
Click Update Table → Update entire table

Related

Related (more Word skills): Mail Merge; Mail Merge Class Demonstration And Revision

Related (more Word skills): Fillable Forms (CSEC Tutorial in Microsoft Word); Fillable forms – (Microsoft Word) – Live Class

Paper 1 practice (multiple choice)

Choose the best answer for each question. Try them all before you check.

1. Word builds an automatic table of contents from text formatted with
(A) bold font
(B) Heading styles
(C) WordArt
(D) bullets

2. Where is the Table of Contents command found in Word?
(A) Home tab
(B) Insert tab
(C) References tab
(D) View tab

3. After adding a new section with a heading, you should choose
(A) Update page numbers only
(B) Update entire table
(C) Delete the table
(D) Mark as Final

4. An advantage of an automatic table of contents is that
(A) it never needs updating
(B) page numbers can be updated automatically
(C) it adds pictures
(D) it checks spelling

5. Which key updates a selected table of contents in Word?
(A) F1
(B) F5
(C) F7
(D) F9

Show answers

1. B
2. C
3. B
4. B
5. D

Paper 2 practice (structured question)

Keisha has typed a 20-page project report with headings in large bold text. Her teacher asks her to include a table of contents generated by the word processor.

(a) Explain why her current headings will NOT appear in an automatic table of contents. (2 marks)

(b) Outline the steps she should follow to generate the table of contents. (2 marks)

(c) After generating it, she adds two new sections. State what she must do and which option to choose. (2 marks)

(d) State TWO advantages of a generated table of contents over a typed one. (2 marks)

Total: 8 marks

Show answers

(a) Large bold text is only character formatting (1); the TOC is built only from headings formatted with Heading styles (1).

(b) Apply Heading 1/Heading 2 styles to the headings (1); click where the TOC should go and choose References → Table of Contents → Automatic table (1).

(c) Update the table of contents (1), choosing “Update entire table” so the new headings are added (1).

(d) Any two (1 each):
• page numbers are calculated/updated automatically
• entries are hyperlinks to the sections
• saves time
• fewer errors
• consistent appearance

Next: Planning and Designing a Website: Site Structure, Page Layout and Design Features

Syllabus link: This post is relevant to the CSEC® Information Technology Syllabus (CXC 30/G/SYLL 17), Section 4: Word-Processing and Web Page Design, Specific Objective 6 (“generate table of contents for a document”).

Attributions to media used in this post:

No third-party images are used in this post. Embedded videos are credited on YouTube to their channels.

Updates

2026/10/16

– Lists and algorithms laid out line by line.

© 2026 Vedesh Kungebeharry. All rights reserved.

Word Processing: Reviewing and Protecting a Document – AutoSave, Backups, Passwords and Restrict Editing

Before you hand in an important document, you check it. And while you work, you want to make sure an unexpected power cut or a curious classmate cannot ruin it. This post covers the review features briefly (they are covered fully in older posts) and focuses on document protection: AutoSave and AutoRecover, backups, passwords and restricting editing.

Build on what you learned in Forms 1–3

These Lower School ICT posts cover the basics of this topic:

In this post:

  • Review features at a glance: spelling and grammar, thesaurus, word count, comments and track changes
  • AutoSave and AutoRecover
  • Backups and version history
  • Password to open and password to modify
  • Restrict editing and Mark as Final

Review features at a glance

FeatureWhere (Word)Use
Spelling and grammarReview → Spelling & Grammar (F7); red and blue underlinesCatch mistakes – but read it yourself too; the checker misses wrong words spelled correctly (e.g. “their” for “there”)
ThesaurusReview → Thesaurus (Shift+F7)Find a word with a similar meaning to avoid repeating yourself
Word countReview → Word Count, or the status barCheck you are within a word limit
CommentsReview → New CommentLeave a note for someone without changing the text
Track changesReview → Track Changes; then Accept or RejectEvery edit is shown so the author can approve it

For full tutorials see Reviewing Documents – Word Processing and Document Review Tutorial – Track Changes, Comments.

Video: Word: Track Changes and Comments – https://www.youtube.com/watch?v=m7tmsWN6uH0

AutoSave and AutoRecover

  • AutoSave (Microsoft 365, top-left switch) saves every change automatically when the file is stored on OneDrive or SharePoint. Google Docs does this all the time.
  • AutoRecover saves a recovery copy every few minutes. If Word crashes or the power goes, Word offers to recover the file when you reopen it. Set it at File → Options → Save → Save AutoRecover information every 5 minutes.
  • AutoRecover is a safety net, not a replacement for saving – still press Ctrl+S often.

Video: Microsoft Office AutoSave vs. AutoRecover File Saving Options. Which Should You Use? – https://www.youtube.com/watch?v=tgrzbtc3c0A

Backups and versions

  • Keep a backup copy in a second place: a flash drive, an external drive or cloud storage.
  • Use Save As with version numbers (e.g. Report_v1, Report_v2) before major changes.
  • Version history (File → Info → Version History in Word on OneDrive; File → Version history in Google Docs) lets you go back to an earlier copy.
  • LibreOffice: Tools → Options → Load/Save → General → “Always create backup copy”.

Passwords and restricting editing

  • Password to open – File → Info → Protect Document → Encrypt with Password. Nobody can open the file without it. If you forget the password, the file cannot be recovered.
  • Password to modify – File → Save As → Tools → General Options. Others can open it read-only but need the password to save changes.
  • Restrict Editing – Review → Restrict Editing: allow only comments, only tracked changes, only filling in forms, or no changes (read only), then Yes, Start Enforcing Protection and set a password. You can also allow editing in selected parts only.
  • Mark as Final – File → Info → Protect Document → Mark as Final: tells readers the document is finished. It is only a warning – anyone can click “Edit Anyway”.

Video: How to Protect a Word Document with password | Restrict Edit Ms Word – https://www.youtube.com/watch?v=hdI4f-AgIAM

Step by step: protect a class test template

In Microsoft Word:

  1. Finish the document and save it.
  2. Review → Restrict Editing.
  3. Under Editing restrictions, tick “Allow only this type of editing” and choose Filling in forms (or No changes).
  4. Click Yes, Start Enforcing Protection and type a password twice.
  5. Save, then make a backup copy on a flash drive or in the cloud.

Try it: Which protection feature?

Choose the best feature for each situation.

Stop anyone without the password from opening a confidential file
Let classmates add notes but not change your text
Get your work back after a sudden power cut
Keep a copy safe if your laptop is stolen
Show readers the document is finished, as a warning only

Related

Related: Tracking Changes – Live Class Demo

Paper 1 practice (multiple choice)

Choose the best answer for each question. Try them all before you check.

1. Which feature automatically saves a recovery copy of a document every few minutes?
(A) Track changes
(B) AutoRecover
(C) Thesaurus
(D) Mark as Final

2. A user needs a password before a document can be opened. The feature used is
(A) Mark as Final
(B) Encrypt with Password
(C) Word Count
(D) Comments

3. Which feature lets reviewers suggest changes that the author can accept or reject?
(A) Track changes
(B) Find and Replace
(C) AutoSave
(D) Header

4. Mark as Final
(A) permanently locks the document
(B) only warns readers that the document is finished
(C) encrypts the document
(D) deletes comments

5. The BEST protection against losing a document if a laptop is stolen is
(A) spell check
(B) a backup copy kept somewhere else
(C) word count
(D) bold headings

Show answers

1. B
2. B
3. A
4. B
5. B

Paper 2 practice (structured question)

A school secretary prepares the end-of-term report template in Microsoft Word. Teachers will type comments into it, but they must not change the layout. Last term the computer crashed and she lost an afternoon’s work.

(a) State the feature she should use to let teachers type only in certain parts of the template. (2 marks)

(b) Explain how AutoRecover could have helped when the computer crashed. (2 marks)

(c) Distinguish between “password to open” and “password to modify”. (2 marks)

(d) Describe TWO review features a teacher could use before submitting the report. (2 marks)

Total: 8 marks

Show answers

(a) Restrict Editing (1) – allowing only filling in forms/editing in selected areas, enforced with a password (1).

(b) Word saves a recovery copy every few minutes (1); when Word is reopened after the crash, the recovered version is offered, so little work is lost (1).

(c) Password to open – the file cannot be opened at all without the password (1); password to modify – the file can be opened read-only but changes cannot be saved without the password (1).

(d) Any two (1 each):
• spelling and grammar check to correct errors
• thesaurus to vary word choice
• word count to keep within a limit
• comments to note questions
• track changes so edits can be checked

Next: Word Processing: How to Generate a Table of Contents

Syllabus link: This post is relevant to the CSEC® Information Technology Syllabus (CXC 30/G/SYLL 17), Section 4: Word-Processing and Web Page Design, Specific Objective 4 (“use the review feature of a word processor to enhance document readiness”); Specific Objective 5 (“appropriately use features that allow the protection of a document”).

Attributions to media used in this post:

No third-party images are used in this post. Embedded videos are credited on YouTube to their channels.

Updates

2026/10/16

– Lists and algorithms laid out line by line.

© 2026 Vedesh Kungebeharry. All rights reserved.