Editing Your Video: Cuts, Sound, Transitions and Titles

What is the black-and-white board in this picture, and why do film crews clap it shut at the start of every shot?

A film clapperboard with black and white striped clapper sticks on top and a slate below for writing the scene and take numbers.
A clapperboard. Writing on the slate names the scene and take, and the loud “clap” helps the editor line up the sound with the picture later.

Image source: File:Clapperboard, O2 film, September 2008.jpg (Wikimedia Commons)

In this post:

  • Trimming, cutting (splitting) and joining clips
  • Adding music and your own voice
  • Transitions between clips
  • Titles and credits
  • Exporting the finished video, plus activities, a project checklist and a quiz

Cutting and joining clips

In the last post, you imported your clips and placed them on the timeline. Now it is time to edit them. The tools below are from Clipchamp, but iMovie, Shotcut and other editors have the same ideas.

ToolWhat it doesHow (Clipchamp)
TrimShortens the start or end of a clip, e.g. to remove the part where you pressed Record.Click the clip, then drag its left or right edge inwards.
Split (cut)Cuts one clip into two pieces at the playhead, so you can remove a part from the middle.Move the playhead (the line) to the spot, then click the scissors (Split) button, or press S.
DeleteRemoves a clip or piece from the timeline.Click it and press Delete.
JoinPlaces clips one after another so they play as one video.Drag clips next to each other on the timeline. Close any gaps.
UndoReverses your last change.Ctrl + Z

Adding sound and voice

  • Music: drag a music file onto the audio track below your video. Use music you are allowed to use, such as the free stock music in Clipchamp’s content library or music with a Creative Commons licence. Using a popular song without permission breaks copyright.
  • Voiceover (narration): record yourself explaining what is happening. In Clipchamp, the Record & create section lets you record with your computer’s microphone or webcam, or turn typed text into speech. You can also record on your phone and import the file.
  • Volume: click the audio clip and lower the music’s volume, so voices can be heard clearly over it.

Transitions

A transition is the effect that moves the video from one clip to the next. A cut jumps straight to the next clip. A fade goes through black, a cross-fade (dissolve) blends one clip into the next, and a wipe slides one away. In Clipchamp, open Transitions on the left and drag one between two clips.

Tip: professionals mostly use plain cuts and the odd fade. If every clip has a spinning, sparkling transition, viewers notice the effects instead of your story.

Titles and credits

  • A title at the start tells viewers what the video is about. Use Text in Clipchamp and drag a title style onto the timeline.
  • Credits at the end list who made the video and who did what (filming, editing, narration), and name the music you used and where it came from.
  • Keep text on screen long enough to read: about 3–5 seconds for a short title.

Export and save

When you are happy, click Export and choose a quality such as 1080p. The editor builds one video file (usually an MP4) that you can share. Your project is not the same as the video file, so keep the project too in case you need to make changes.

Watch: editing in Clipchamp

This video gives a tour of Clipchamp, the video editor that comes with Windows 11. Watch it with the editor open and pause to try each step.

Video: How to Use Clipchamp Video Editor in 2026 – Microsoft ExpertZone UKI – https://www.youtube.com/watch?v=6r0Wlh8uc3A

Activity: which editing tool?

Try it: fix the problem

Which tool fixes each problem?

Your clip begins with five seconds of you walking back from the camera
You want to remove a sneeze from the middle of a clip
The video jumps suddenly from the classroom to the field
Viewers do not know what the video is about
You want to thank everyone who helped and name the music
The music is so loud nobody can hear the narrator

Activity: put the editing steps in order

Try it: editing order

Put these steps in a sensible order, then click Check.

▲ First

  1. Import the clips
  2. Arrange the clips in storyboard order
  3. Trim and split the clips
  4. Add transitions between clips
  5. Add music and voiceover
  6. Add a title and credits
  7. Export the video as an MP4

▼ Last

Project: your occasion video

Use the clips from your storyboard project, or film new ones, to make a 1–2 minute video about an occasion, such as Sports Day, Independence Day, Divali, Eid, Christmas or your school’s anniversary. Check your work with this list before you hand it in:

Checklist✔
At least four clips, in a sensible order
Clips trimmed: no fumbling at the start or end
At least two transitions
Music or voiceover that can be heard clearly
A title at the start
Credits at the end, including where the music came from
Exported as an MP4 and played all the way through

Self-check quiz

Click the best answer. You get feedback straight away; only your first click counts towards your score.

1. What does trimming a clip do?

2. To remove a part from the middle of a clip, you should…

3. A cross-fade is a type of…

4. What usually goes in the credits?

5. Why lower the music volume under a voiceover?

6. Which button turns your project into one video file you can share?

Related posts on islandclass.org

Next: Using Information Responsibly

Syllabus link: Forms 1–3 ICT curriculum, Module 3, Objective 3.15 – prepare a video production on a specified topic/ occasion.

Attributions to media used in this post:

Updates

2026/10/21

– Fixed the activity code so its buttons keep working.

© 2026 Vedesh Kungebeharry. All rights reserved.

Planning and Capturing a Video

Look at the drawing below. It looks a bit like a comic strip, but it is really a plan for a film. Why do you think film makers draw their film before they shoot a single second of it?

A hand-drawn pencil storyboard with six numbered frames. The sketches show a person walking home, a hand holding a phone, a person entering a house and a group of surprised friends, with short notes in Spanish under each frame.
A hand-drawn storyboard by Iván López Fuente. The notes are in Spanish: under each sketch they name the shot type (for example plano medio, medium shot, and plano detalle, a close-up of a detail) and say what happens.

Image source: File:Storyboard – Iván López Fuente.jpg (Wikimedia Commons)

In this post:

  • The steps in making a video
  • Planning with a storyboard, and three types of shot
  • Filming your clips (source files) on a phone or camera
  • Getting the files onto a computer and into a video editor
  • Two activities, a group project and a quiz

How a video is made

  1. Plan: decide on the topic, who will watch it and the main message.
  2. Storyboard: sketch each shot in order.
  3. Capture: film the clips and record any sound. These recordings are your source files.
  4. Import: copy the files onto the computer and bring them into a video editor.
  5. Edit: arrange, cut and join the clips; add sound, transitions, titles and credits (see the next post).
  6. Export: save the finished video as one file, such as an MP4, to share.

Planning with a storyboard

A storyboard is a set of boxes, one for each shot. In each box you draw a quick sketch (stick figures are fine!) and write notes underneath:

  • What happens in the shot
  • What kind of shot it is (see below)
  • Any words, sound or music
  • About how many seconds it lasts
Shot typeWhat you seeUse it to…
Wide shot (long shot)The whole scene and the people in itShow where the action takes place
Medium shotA person from the waist upShow someone talking or doing something
Close-upJust a face, or a small object filling the screenShow feelings or important details

Capturing your clips

Most phones and tablets record good video. Some tips:

  • Hold the phone sideways (landscape), so the video fills a computer screen.
  • Keep it steady: use both hands, lean on something or use a stand.
  • Film where there is good light, with the light behind the camera, not behind the person.
  • Find a quiet place, and get close to the person speaking so the microphone picks up their voice.
  • Start recording a second or two before the action and stop a second after. This gives you room to trim.
  • Film short clips, one for each storyboard box, rather than one long recording.
  • Always ask permission before you film someone.
A smartphone held sideways in a mount, filming a group of dancers in a park. The dancers can be seen on the phone screen.
A phone held sideways (landscape) in a mount, filming dancers in Yuanshan Park, Taiwan. The mount keeps the shot steady, and the sideways phone fills a wide screen.

Image source: File:ViVi’s smartphone recording video at Yuanshan Park 20231125.jpg (Wikimedia Commons)

From phone to computer

  • Connect the phone with a USB cable and copy the files across, or take out the memory card and use a card reader.
  • Or upload the clips to a cloud service such as Google Photos, OneDrive or Google Drive, then download them on the computer.
  • Put all your clips, photos and music for one project in one folder with a clear name. Videos are usually .mp4 or .mov files.

Video editing programs

Windows Movie Maker was the free editor that many schools used, but Microsoft stopped offering it in 2017. Today you can use Clipchamp (included with Windows 11 and also in a web browser), iMovie on Apple devices, or free programs such as Shotcut and OpenShot. They all work in a similar way:

  • Import: click Import media (or drag your files in). They appear in your media library.
  • Add clips: drag each clip down onto the timeline, the strip along the bottom where your video is built, in storyboard order. (Movie Maker called this the storyboard.)
  • Delete a clip: click it on the timeline and press Delete. It is removed from the video, but the original file is still safe in your folder.
  • Move a clip: drag it to a new place on the timeline.

Watch: what is a storyboard?

This short video from ACMI, a museum of film and screen culture, explains what a storyboard is.

Video: What is a storyboard? – ACMI – Australia’s museum of screen culture – https://www.youtube.com/watch?v=6aTnEanIXBk

Activity: put the steps in order

Try it: making a video

Use the arrows to put the steps in the right order, then click Check.

▲ First

  1. Choose a topic and the main message
  2. Draw the storyboard
  3. Film the clips on a phone or camera
  4. Copy the clips onto the computer
  5. Import the clips into the video editor
  6. Arrange the clips on the timeline
  7. Export the finished video as an MP4

▼ Last

Activity: which shot?

Try it: choose the shot type

Which type of shot would you use?

Show the whole school field before sports day starts
Show a runner’s face as she crosses the finish line
Show the principal giving a speech at the podium
Show the medal in someone’s hand
Show all the classes lined up for the march past

Group project: storyboard and film

In groups of three or four, plan a 1-minute video on a topic such as How to wash your hands properly or A tour of our school garden. Copy this storyboard into your book (make four boxes), fill it in, then film one clip for each box. Keep your clips safe: you will edit them in the next post.

ShotSketchWhat happensShot typeSound / wordsSeconds
1
2
3
4

Self-check quiz

Click the best answer. You get feedback straight away; only your first click counts towards your score.

1. A storyboard is…

2. The video clips, photos and sounds you record for a project are called…

3. Which shot shows a person’s face filling the screen?

4. Why should you hold the phone sideways when filming?

5. Which program comes with Windows 11 for editing videos?

6. You delete a clip from the timeline. What happens to the original file?

Related posts on islandclass.org

Next: Editing Your Video: Cuts, Sound, Transitions and Titles

Syllabus link: Forms 1–3 ICT curriculum, Module 3, Objective 3.14 – develop a video production.

Attributions to media used in this post:

Updates

2026/10/21

– Fixed the activity code so its buttons keep working.

© 2026 Vedesh Kungebeharry. All rights reserved.

Making Charts from Spreadsheet Data

Look at the three pie charts in the picture. Can you tell which slice is the biggest in each one? Now look at the column charts underneath, made from exactly the same numbers. Easier, right? Choosing the right chart matters.

Three pie charts labelled A, B and C, each with five slices that look almost the same size. Under each pie is a column chart of the same data, where the differences between the five values are easy to see.
Three pie charts (top) and column charts of the same data (bottom). In the pies, the slices look almost equal. The column charts show clearly that the values rise in A, stay about the same in B and fall in C.

Image source: File:Piecharts.svg (Wikimedia Commons)

In this post:

  • Why we turn numbers into charts
  • Column, bar, line and pie charts, and when to use each
  • The parts of a chart: title, axis labels and legend
  • Making and printing a chart in Excel
  • A chart-building lab, a matching activity and a quiz

Why use a chart?

A chart (or graph) turns a table of numbers into a picture. It helps people see patterns quickly: which is biggest, which is smallest, and whether things are going up or down.

Choosing the right chart

Chart typeWhat it looks likeBest forExample
Column chartUpright barsComparing a few groupsMarks for five students
Bar chartBars lying sidewaysComparing groups with long names, or lots of groupsVisitors to different attractions
Line chartPoints joined by a lineShowing change over timeRainfall each month
Pie chartA circle cut into slicesShowing parts of one whole (only a few slices)How the class voted for a trip

The parts of a chart

  • Chart title: says what the chart is about, e.g. Favourite Fruits in Form 2B.
  • Horizontal (x) axis: along the bottom, usually the groups or the times (e.g. months).
  • Vertical (y) axis: up the side, usually the numbers (e.g. rainfall in mm).
  • Axis titles (labels): words that explain each axis, including units.
  • Legend: a key that explains the colours. A pie chart needs one; a chart with only one set of data often does not.

Making a chart in Excel

  1. Select the data, including the headings.
  2. Go to the Insert tab and choose a chart in the Charts group (or click Recommended Charts).
  3. Click the chart title and type a better one.
  4. Add axis titles: click the chart, then the + (Chart Elements) button → tick Axis Titles. In Excel 2007 and 2010, use Chart Tools → Layout → Axis Titles.
  5. Drag the chart to move it, or drag a corner to resize it.
  6. To print just the chart, click it first, then File → Print.
A LibreOffice Calc window with a small table of numbers and a column chart made from it, placed next to the data.
A simple column chart made from spreadsheet data in LibreOffice Calc. Excel and Google Sheets work in the same way: select the data, then insert a chart.

Image source: File:LibreOffice Calc screenshot showing a simple chart.png (Wikimedia Commons)

Watch: charts in Excel

This video shows how to insert a chart in Excel and change how it looks.

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

Activity: chart lab

Try it: build the best chart

For each data set, choose the chart type, type a title and label the axes. Click Draw chart to preview it, then Check my chart. (The numbers are made up for practice.)

Chart type:
Chart title:
Horizontal (x) axis label: Vertical (y) axis label:

Activity: which chart?

Try it: choose the chart type

Which chart would suit each set of data best?

Your height measured on your birthday every year from age 5 to 13
How you spend the 24 hours in a day (sleep, school, play, meals)
The number of goals scored by four football teams
The populations of 12 Caribbean countries
The temperature at noon every day for a week
How the class split its votes between three trip choices

Self-check quiz

Click the best answer. You get feedback straight away; only your first click counts towards your score.

1. Which chart is best for showing change over time?

2. A pie chart is best for showing…

3. What is the vertical axis also called?

4. Before inserting a chart in Excel, you should…

5. Why should every chart have a title and axis labels?

6. How do you print only a chart in Excel?

Related posts on islandclass.org

For later, in Forms 4–5 (CSEC IT): these go deeper and are for when you reach CSEC Information Technology.

Next: Planning and Capturing a Video

Syllabus link: Forms 1–3 ICT curriculum, Module 3, Objective 3.13 – demonstrate data visually by creating appropriate charts using spreadsheet data.

Attributions to media used in this post:

Updates

2026/10/21

- Fixed the activity code so its buttons keep working.

© 2026 Vedesh Kungebeharry. All rights reserved.

Sorting Data and Absolute Cell References

Look at the photo below. A library once kept a card for every book in drawers like these. How could anyone find one card among thousands? Everything was kept in alphabetical order. Spreadsheets can put data in order for you in one click.

A wall of small wooden drawers in a library card catalogue. Each drawer has a label showing the range of words inside, in alphabetical order, from Lover to Luma.
A card catalogue at the Indiana State Library. Each drawer is labelled with the first and last headings inside, so the cards are in alphabetical order.

Image source: File:Card catalog at the Indiana State Library (Wikimedia Commons)

In this post:

  • Sorting data in ascending and descending order
  • Two sorting mistakes to avoid
  • Relative cell references, which change when you copy a formula
  • Absolute cell references with $ signs, which stay fixed
  • A sorting lab, a fill-down challenge and a quiz

Sorting data

Sorting means putting rows in order, using one column to decide the order. (That column is the criterion.)

OrderWordsNumbersDates
AscendingA → ZSmallest → largestOldest → newest
DescendingZ → ALargest → smallestNewest → oldest

How to sort in Excel

  1. Click any cell inside your table (or select the whole table, headings included).
  2. For a quick sort: Home tab → Sort & Filter → Sort A to Z or Sort Z to A. This sorts by the column of the cell you clicked.
  3. For more control: Data tab → Sort. Pick the column in Sort by, then the Order.
  4. Make sure My data has headers is ticked, so your heading row stays at the top.
  5. Click OK. In Excel 2003, use the Data menu → Sort….
Two sorting traps:
1. If you select just one column and sort it, Excel shows a Sort Warning. Always choose Expand the selection. Otherwise the names get mixed up with the wrong marks!
2. If My data has headers is not ticked, your heading row gets sorted in with the data.

Watch: sorting data

This video shows how to sort data in Excel.

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

Activity: sorting lab

Try it: sort the class list

Choose the column and the order, then click Sort. Click Check to see if you are right. Try the “Sort this column only” option once, just to see what goes wrong!

Sort by: Order:
 

Relative cell references

When you copy a formula down a column, the cell addresses in it change to match the new row. =B2*C2 in row 2 becomes =B3*C3 in row 3, then =B4*C4, and so on. These are called relative references, because they are relative to where the formula is. Usually this is exactly what you want.

Absolute cell references

Sometimes one cell must not change, for example a cell holding a tax rate or an exchange rate that every row uses. Put a $ sign in front of the column letter and the row number: $F$1. This is an absolute reference. It stays exactly the same wherever you copy the formula.

Formula in C2Copied to C3 becomesWhy
=B2*F1=B3*F2Both addresses moved down a row. F2 is empty, so the answer is 0. Wrong!
=B2*$F$1=B3*$F$1B2 moved to B3, but $F$1 stayed fixed. Right!

Shortcut: while typing a formula, click the address and press F4 to add the $ signs. LearnFree’s video Relative and Absolute Cell References explains this well.

Activity: fill-down challenge

Try it: work out the VAT

VAT in Trinidad and Tobago is 12.5%, and that rate is in cell F1. Type a formula in C2 that multiplies the price by the VAT rate, then click Enter and fill down to copy it to C3:C6. First try it without $ signs and see what happens.

C2 fx

ABCDEF
1
2
3
4
5
6

Self-check quiz

Click the best answer. You get feedback straight away; only your first click counts towards your score.

1. Sorting numbers in ascending order puts them…

2. Why should you tick “My data has headers” when sorting?

3. Excel shows a Sort Warning when you select one column. What should you choose?

4. =B2*C2 is copied from row 2 to row 5. What does it become?

5. Which reference stays exactly the same when copied?

6. Which key adds $ signs to the address you are typing in Excel?

Related posts on islandclass.org

For later, in Forms 4–5 (CSEC IT): these go deeper and are for when you reach CSEC Information Technology.

Next: Making Charts from Spreadsheet Data

Syllabus link: Forms 1–3 ICT curriculum, Module 3, Objective 3.12 – perform a sort operation using one criteria.

Attributions to media used in this post:

Updates

2026/10/21

- Fixed the activity code so its buttons keep working.

© 2026 Vedesh Kungebeharry. All rights reserved.

Spreadsheet Formulas and Functions: SUM, AVERAGE, MIN and MAX

A vendor sells 48 doubles at $6 each, 35 aloo pies at $5 each and 20 drinks at $8 each. Could you work out the total in your head? What if the prices changed every day? In a spreadsheet you type the calculation once, and it updates itself.

In this post:

  • Writing formulas with + − * / and cell addresses
  • The SUM, AVERAGE, MIN and MAX functions
  • Copying formulas to other cells
  • Number formats: number, currency, percentage and date
  • A formula lab, two matching activities and a quiz

Formulas: let the spreadsheet do the maths

A formula is a calculation in a cell. Every formula starts with an equals sign (=). You type it in the cell, press Enter, and the cell shows the answer. The formula itself shows in the formula bar.

OperationSymbolExampleMeaning
Add+=B2+C2B2 plus C2
Subtract−=B2-C2B2 minus C2
Multiply*=B2*C2B2 times C2
Divide/=B2/4B2 divided by 4
Power^=B2^2B2 squared
Use cell addresses, not numbers. If B2 holds 48, you could type =48*6. But =B2*C2 is better: if the number in B2 changes, the answer changes too. Spreadsheets also follow BODMAS, so =2+3*4 gives 14, while =(2+3)*4 gives 20.

Functions: ready-made formulas

A function is a built-in formula with a name. You give it a range in brackets.

FunctionWhat it gives youExample
SUMThe total of all the numbers=SUM(B2:B6)
AVERAGEThe mean: the total divided by how many numbers there are=AVERAGE(B2:B6)
MINThe smallest number=MIN(B2:B6)
MAXThe largest number=MAX(B2:B6)

Shortcut: click the cell under a column of numbers and click AutoSum (Σ) on the Home tab. The little arrow next to Σ also gives you Average, Min and Max. In Excel 2003, AutoSum is on the Standard toolbar.

A LibreOffice Calc window. Cell A6 is selected and the formula bar shows =SUM(A1:A5). The functions panel on the right lists SUM, AVERAGE, MIN and MAX among the most recently used functions.
The SUM function in LibreOffice Calc. The cell holds =SUM(A1:A5), and the panel on the right lists other functions, including AVERAGE, MIN and MAX.

Image source: File:SUM formula in LibreOffice Calc.png (Wikimedia Commons)

Copying formulas

Once one formula works, you don’t need to type it again for every row. Copy the cell (Ctrl + C) and paste it (Ctrl + V), or drag the fill handle (the small square at the bottom-right corner of the cell) down. The addresses change by themselves: =SUM(B2:D2) in row 2 becomes =SUM(B3:D3) in row 3. You will learn more about this in the next post.

Number formats

A number format changes how a number looks, not its value. Find them on the Home tab in the Number group, or right-click → Format Cells… (Ctrl + 1).

FormatThe cell holdsIt shows
Number (2 decimal places)3.53.50
Currency25$25.00
Percentage0.1515%
Date17/10/202617-Oct-2026 or 17/10/2026

Watch: functions in Excel

This video explains what functions are and how to use them in Excel.

Video: Excel: Functions – LearnFree – https://www.youtube.com/watch?v=-9d4m79twdA

Activity: formula lab

Try it: the class marks sheet

Each task highlights a cell. Type a formula in the fx box and press Enter. The spreadsheet checks your answer. Stuck? Click Show a hint.

fx

ABCDEF
1
2
3
4
5
6
7
8

Activity: which function?

Try it: choose the function

Which function answers each question?

How much money did the class collect altogether?
What was the hottest temperature this week?
What is the typical (mean) score for the test?
Which runner had the fastest (smallest) time?

Activity: which number format?

Try it: match the number format

Which format makes each cell look like this?

0.25 shows as 25%
12 shows as $12.00
4.5 shows as 4.50
A birthday shows as 05-Mar-2014

Self-check quiz

Click the best answer. You get feedback straight away; only your first click counts towards your score.

1. Every formula in a spreadsheet must start with…

2. Which symbol means multiply in a spreadsheet?

3. What does =AVERAGE(B2:B5) give if the cells hold 10, 20, 30 and 40?

4. Which function finds the smallest number in a range?

5. Why is =B2*C2 better than =48*6?

6. A cell holds 0.4. Which format makes it show 40%?

Related posts on islandclass.org

For later, in Forms 4–5 (CSEC IT): these go deeper and are for when you reach CSEC Information Technology.

Next: Sorting Data and Absolute Cell References

Syllabus link: Forms 1–3 ICT curriculum, Module 3, Objective 3.11 – apply formulas and functions in a spreadsheet to solve a problem.

Attributions to media used in this post:

Updates

2026/10/21

- Fixed the activity code so its buttons keep working.

© 2026 Vedesh Kungebeharry. All rights reserved.

Your First Spreadsheet: Cells, Rows and Columns

Your class is collecting money for a trip. Thirty students, five payments each… How would you keep track of who has paid what, without getting lost in a pile of paper? A spreadsheet is built for exactly this job.

In this post:

  • What a spreadsheet is, and some popular spreadsheet programs
  • Cells, cell addresses, rows, columns and ranges
  • Creating, opening, saving and closing a workbook
  • Inserting and deleting rows and columns, and changing their size
  • A cell address game, a practice task and a quiz

What is a spreadsheet?

A spreadsheet is a grid of boxes for storing numbers and words, and for doing calculations with them. Change one number and every answer that uses it updates by itself. Popular spreadsheet programs include Microsoft Excel, Google Sheets and the free LibreOffice Calc.

A spreadsheet file is called a workbook. Each workbook can hold several worksheets (pages), shown as tabs at the bottom of the screen, such as Sheet1, Sheet2.

A LibreOffice Calc window. Column letters A, B, C run across the top, row numbers run down the left side, and the grid of cells holds a small table of numbers and a chart.
A spreadsheet in LibreOffice Calc. Notice the column letters across the top, the row numbers down the side and the sheet tabs at the bottom. Excel and Google Sheets look very similar.

Image source: File:LibreOffice Calc 6.4.png (Wikimedia Commons)

Spreadsheet words you need

WordMeaningExample
ColumnA line of cells going down. Columns are named with letters.Column C
RowA line of cells going across. Rows are numbered.Row 4
CellOne box, where a column and a row meet.The box in column C, row 4
Cell address (cell reference)The name of a cell: its column letter, then its row number.C4
Active cellThe cell you have selected. It has a thick border, and its address shows in the Name Box.–
RangeA block of cells next to each other, written as first cell : last cell.B2:D5 (12 cells)
Formula barThe long box above the grid that shows what is really inside the active cell.=B2+C2
Memory trick: columns hold up a building, so they go up and down. Rows of seats in a cinema go across. And a cell address is always letter first, then number: C4, never 4C.

Create, open, save and close

  • Create: open Excel and choose Blank workbook, or press Ctrl + N.
  • Enter data: click a cell, type, then press Enter (moves down) or Tab (moves right). To change a cell, double-click it or press F2. Delete clears it.
  • Save: Ctrl + S. Give the file a clear name, like Trip_Payments. Excel files end in .xlsx.
  • Open: File → Open (Ctrl + O), then find your file.
  • Close: File → Close. Excel asks you to save if you have unsaved changes.

Rows and columns: insert, delete and resize

To…Do this (Excel)
Select a whole row or columnClick its number (row) or letter (column) heading.
Insert a row or columnRight-click a row number or column letter → Insert. A new row appears above; a new column appears to the left.
Delete a row or columnRight-click the heading → Delete. Everything in it is removed!
Change column widthDrag the line on the right of the column letter. Double-click the line to make the column fit its longest entry (AutoFit).
Change row heightDrag the line below the row number.
Set an exact sizeHome tab → Format (in the Cells group) → Row Height… or Column Width…. In Excel 2003: Format menu → Row or Column.

If you see ##### in a cell, don’t panic! The number is just too wide for the column. Make the column wider and it appears.

Watch: cell basics

This video covers the basics of working with cells in Excel. Try each step as you watch.

Video: Excel: Cell Basics – LearnFree – https://www.youtube.com/watch?v=6mSKsaquTAM

Activity: cell address game

Try it: find the cell

Rounds 1–5: click the cell named. Rounds 6–10: type the address of the yellow cell. Ten rounds in all.

ABCDEFGH
1
2
3
4
5
6
7
8
9
10

Activity: ranges

Try it: count the cells

Work out each answer, then click Check.

1. How many cells are in the range A1:A10?

2. How many cells are in the range B3:E3?

3. How many cells are in the range B2:D5?

4. What is the address of the cell in column F, row 7?

5. You insert a new column to the left of column B. What letter does the old column B now have?

Practice: a simple budget

Open a blank workbook and make a pretend weekly budget for a family. Type the headings in row 1 and the items below. Save it as My_Budget.

AB
1ItemCost ($)
2Groceries650
3Electricity120
4Water45
5Transport200
6Phone99
  • Make column A wide enough to show every item.
  • Insert a new row above row 4 and add Internet, 150.
  • Delete the Phone row.
  • Make row 1 taller, then save and close the workbook.
  • Open it again to check that your changes were saved.

Self-check quiz

Click the best answer. You get feedback straight away; only your first click counts towards your score.

1. Columns in a spreadsheet are named with…

2. What is a cell?

3. Which is a correct cell address?

4. How many cells are in the range A1:B3?

5. A cell shows ##### instead of a number. What should you do?

6. To insert a new column in Excel, you can…

Related posts on islandclass.org

For later, in Forms 4–5 (CSEC IT): these go deeper and are for when you reach CSEC Information Technology.

Next: Spreadsheet Formulas and Functions: SUM, AVERAGE, MIN and MAX

Syllabus link: Forms 1–3 ICT curriculum, Module 3, Objective 3.10 – create a simple spreadsheet document.

Attributions to media used in this post:

Updates

2026/10/21

- Fixed the activity code so its buttons keep working.

© 2026 Vedesh Kungebeharry. All rights reserved.

Proofing Your Work: Spelling, Grammar, Thesaurus and Find and Replace

Read this sentence: “Their going two the beach tomorow.” How many mistakes can you find? And which ones would a computer catch? (Answer at the end of the next section!)

In this post:

  • Spelling and grammar checks, and what they miss
  • Using the thesaurus to find synonyms
  • Find and Replace, including Match case and Whole words only
  • Three hands-on activities, a peer check and a quiz

Spelling and grammar checks

  • As you type, Word underlines possible spelling mistakes with a wavy red line, and possible grammar mistakes with a double blue line (green in Word 2010 and earlier).
  • Right-click an underlined word to see suggestions. Click the right one to fix it.
  • To check the whole document, press F7, or go to the Review tab → Spelling & Grammar (called Editor in newer versions of Microsoft 365). In Word 2003, use Tools → Spelling and Grammar.
  • Ignore skips a word that is correct, such as a name. Add to Dictionary teaches Word a word you use often, like your surname or village.
A spelling checker window titled Spelling. It shows the sentence The quick brown fox jumps over the lazy dog with brown misspelled as bwron, a Change to box containing brown, a list of suggestions, and buttons for Add, Ignore, Ignore All, Change and Change All.
A spelling checker (this one is from AbiWord, a free word processor). It found a misspelled word in the sentence and offers suggestions, with buttons to Change, Ignore or Add the word to the dictionary. Word’s checker works in the same way.

Image source: File:English-language screenshot of Enchant, AbiWord’s spell checker (Wikimedia Commons)

The computer is not perfect! In “Their going two the beach tomorow” there are three mistakes: Their → They’re, two → to, and tomorow → tomorrow. A spell checker only catches tomorow, because their and two are real words. The grammar checker might catch them. Always proofread your work yourself, too.

Unclear sentences

Some sentences have no spelling or grammar mistakes but are still confusing. “I saw the boy with the binoculars.” Who had the binoculars? Rewrite it so it has only one meaning: “I used binoculars to see the boy.” No checker will spot this for you, so read your work as if you were the reader.

Using the thesaurus

A thesaurus lists synonyms (words with a similar meaning) and often antonyms (words with the opposite meaning). It helps you avoid repeating the same word and choose a more exact one.

  • In Word: select a word, then press Shift + F7, or go to Review → Thesaurus. You can also right-click a word → Synonyms.
  • In Word 2003: Tools → Language → Thesaurus.
  • Check that the synonym fits your sentence. “Big”, “huge” and “important” are all listed for large, but they do not mean exactly the same thing.
The title page of an old book reading Thesaurus of English Words and Phrases by Peter Mark Roget.
The title page of an 1894 edition of Roget’s Thesaurus, first published in 1852. Today, the same idea is built into your word processor.

Image source: File:Roget’s Thesaurus (book cover).jpg (Wikimedia Commons)

Find and Replace

  • Find (Ctrl + F) highlights every place a word appears.
  • Replace (Ctrl + H) swaps one word for another. Replace All changes every match at once.
  • Click More >> for options. Match case only finds words with the same capital letters. Find whole words only stops “cat” from matching the “cat” inside “catch”.
  • In Word 2003, use Edit → Find or Edit → Replace.

Watch: check spelling and grammar

This video shows how to use the spelling and grammar tools in Word. LearnFree also has a short video on using Find and Replace.

Video: Word: Check Spelling and Grammar – LearnFree – https://www.youtube.com/watch?v=uzrpa-gwN1A

Activity: be the spell checker

Try it: fix the report

Click each underlined word and choose the right suggestion. Watch out: some suggestions are real words that do not fit!

wavy red = possible spelling mistake   double blue = possible grammar mistake

Last wensday our school held its sports day. The weather was beautifull and everyone was exited. My friends was in the relay race, and there team came first. Me and my brother ran in the 100 metres. I recieved a medal wich I will keep forever.

Mistakes fixed: 0 of 8

Activity: Find and Replace challenge

Try it: use Find and Replace

Do the three tasks below using Find all and Replace All. Then click Check my document. If something goes wrong, use Undo.

  1. The boy’s name is really Arjun. Replace Ravi with Arjun everywhere.
  2. Pepper is really a dog! Replace the word cat with dog, but do not break “catch” or “category”. (Hint: Find whole words only.)
  3. Use the spelling we use in Trinidad and Tobago: replace color with colour. (This one should also fix “colorful”.)
Find what: Replace with:
 

Activity: pick a synonym

Try it: thesaurus match

Choose the best synonym for each word in bold.

The lime was very sour.
The cruise ship was big.
Please begin the test now.
The runner was very fast.
She was happy with her result.
The old house was scary.

Peer check

Your teacher will give you a practice document full of mistakes. Fix it using the spelling and grammar check, the thesaurus and Find and Replace. Then swap with a partner and score each other:

CheckYesPartlyNo
No spelling mistakes left
No grammar mistakes left
At least two repeated words replaced with synonyms
Unclear sentences rewritten so they have one meaning
Names were not “corrected” by mistake

Self-check quiz

Click the best answer. You get feedback straight away; only your first click counts towards your score.

1. A wavy red underline in Word usually means…

2. Which key starts the spelling and grammar check in Word?

3. Why might a spell checker miss the mistake in “I want two go”?

4. A synonym is a word that…

5. You want to replace “art” with “music”, but not change “start” or “party”. Which option helps?

6. What does Add to Dictionary do?

Related posts on islandclass.org

For later, in Forms 4–5 (CSEC IT): these go deeper and are for when you reach CSEC Information Technology.

Next: Your First Spreadsheet: Cells, Rows and Columns

Syllabus link: Forms 1–3 ICT curriculum, Module 3, Objective 3.9 – adjust a document using advanced features of a word processor.

Attributions to media used in this post:

Updates

2026/10/21

- Fixed the activity code so its buttons keep working.

© 2026 Vedesh Kungebeharry. All rights reserved.

Paragraph Formatting: Design an Invitation

You have been asked to make the invitation for your class’s end-of-term party. You type all the words… and it looks like one big grey block. How do you turn plain text into an invitation people actually want to read?

In this post:

  • What paragraph formatting is
  • Alignment, line spacing, bullets, numbering and indentation
  • Where to find these tools in Word (old and new versions)
  • An invitation makeover activity, a group project and a quiz

What is a paragraph?

In a word processor, a paragraph is everything you type before you press Enter. A heading is a paragraph, and so is each line of a list. Paragraph formatting changes the whole paragraph at once: where it sits on the line, how far apart the lines are, and whether it is part of a list. (Font formatting, from Form 1, changes the letters themselves.)

Tip: click the ¶ Show/Hide button (or press Ctrl + Shift + 8 in Word) to see a ¶ mark at the end of every paragraph.

The paragraph tools

ToolWhat it doesUse it forWord shortcut
Align leftLines start neatly at the left margin; the right edge is ragged.Most normal textCtrl + L
CentreEach line is centred between the margins.Titles and headings, the event name on an invitationCtrl + E
Align rightLines line up at the right margin.Dates and addresses at the top of a letterCtrl + R
JustifyLines line up at both margins, like a newspaper column. The spaces between words stretch to fit.Paragraphs that should look very neatCtrl + J
Line spacingThe gap between lines in a paragraph: 1.0 (single), 1.15, 1.5 or 2.0 (double).Making text easier to readCtrl + 1, Ctrl + 5 (1.5), Ctrl + 2
BulletsPuts a dot or symbol in front of each item.Lists where the order does not matter, like date, time and venueCtrl + Shift + L
NumberingNumbers each item 1, 2, 3… automatically.Steps or a programme where the order matters–
IndentationMoves the paragraph in from the left margin. You can also indent just the first line.Showing a paragraph is separate, or a list inside a listCtrl + M (increase), Ctrl + Shift + M (decrease)

Where to find them

  • Word 2007 and later, including Microsoft 365: the Home tab, in the Paragraph group. Line spacing is the button with arrows pointing up and down (Line and Paragraph Spacing). The small arrow in the corner of the group opens the full Paragraph box.
  • Word 2003 and earlier: the Format menu → Paragraph… for alignment, indents and spacing, and Format → Bullets and Numbering… for lists. The alignment buttons are also on the Formatting toolbar.
  • Google Docs and LibreOffice Writer have the same tools on their toolbars, with very similar icons.
  • Remember: select the paragraph(s) first, then click the tool. To format just one paragraph, you only need to click inside it.
The Bullets and Numbering window in LibreOffice Writer, showing a grid of list styles such as 1. 2. 3., i. ii. iii., A) B) C) and a) b) c).
The Bullets and Numbering window in LibreOffice Writer. Word has a similar choice of styles: click the small arrow next to the Bullets or Numbering button.

Image source: File:LO writer 7 Bullets and Numbering.png (Wikimedia Commons)

Start from a template

Word comes with ready-made templates. Click File → New and search for “invitation” to see designs you can change. A template is a great starting point, but you still need to know the paragraph tools to make it your own.

Watch: line and paragraph spacing

This short video shows how to change line spacing and the space before and after paragraphs. Pause it and try each step in Word.

Video: Word: Line and Paragraph Spacing – LearnFree – https://www.youtube.com/watch?v=mXWvKHWe2Co

Activity: invitation makeover

Try it: format the invitation

Click a paragraph to select it (it turns blue). Click more paragraphs to select several at once, then use the buttons. Complete all seven tasks, then click Check my invitation.

Your tasks:

  1. Centre the heading “You’re Invited!”
  2. Justify the opening paragraph
  3. Justify the closing paragraph
  4. Set 1.5 line spacing for the whole invitation (use Select all)
  5. Put bullets on the three event details
  6. Number the four programme items
  7. Increase the indent of the opening paragraph once

Line spacing:
You’re Invited!
Join us for a grand celebration as we come together with family and friends to celebrate Grandma Joan’s 50th birthday. We look forward to sharing this special occasion with everyone and creating wonderful memories together.
Event Details
Date: Saturday 14 November
Time: 6:00 p.m.
Venue: Community Centre, Main Road
Programme
Welcome Note
Cake Cutting
Dinner
Dance
We sincerely hope that you will be able to join us for this memorable celebration. Your presence will make the occasion even more special.

    Activity: which tool?

    Try it: choose the paragraph tool

    Which tool would you use for each job?

    Put the title of a poster in the middle of the line
    Make a paragraph line up neatly at both margins
    List the steps for making a sandwich, in order
    List the things to bring on a trip
    Spread the lines out so an essay is easier to read and mark
    Move a paragraph in from the left margin
    Put the date at the right-hand side of a letter

    Group project: an invitation to share

    In a group, plan and make an invitation to a real or pretend school function: a sports day, a concert, a book fair or a class party. Use every paragraph tool from this post. Then swap with another group and score each other with this checklist:

    SkillMarksQuick check
    Heading centred22 = correct; 1 = partly; 0 = not done
    Paragraphs justified22 = all; 1 = some; 0 = none
    1.5 line spacing22 = throughout; 1 = partly; 0 = not done
    Event details bulleted22 = all; 1 = partly; 0 = none
    Programme numbered22 = all; 1 = partly; 0 = none
    Indentation used22 = correct; 1 = attempted; 0 = not done
    Complete, neat and consistent33 = neat; 2 = minor issues; 1 = several issues; 0 = incomplete

    Self-check quiz

    Click the best answer. You get feedback straight away; only your first click counts towards your score.

    1. In a word processor, a new paragraph starts when you…

    2. Which alignment lines text up at both the left and right margins?

    3. The steps in a recipe are best shown with…

    4. In Word 2010 or Microsoft 365, the paragraph tools are on the…

    5. Line spacing of 2.0 is also called…

    6. What does Increase Indent do?

    Related posts on islandclass.org

    Next: Proofing Your Work: Spelling, Grammar, Thesaurus and Find and Replace

    Syllabus link: Forms 1–3 ICT curriculum, Module 3, Objective 3.8 – create an invitation to a function using a word processor (MS Word).

    Attributions to media used in this post:

    Updates

    2026/10/21

    – Fixed the activity code so its buttons keep working.

    © 2026 Vedesh Kungebeharry. All rights reserved.

    Spreadsheets: Introduction, definition & terminology

    See the video below which introduces spreadsheet software

    Terminology

    Spreadsheet – an electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations.


    Oxford English Dictionary via google. (https://www.google.com/search?q=define+spreadsheet&oq=define+spreadsheet&aqs=chrome..69i57j0l7.4183j1j7&sourceid=chrome&ie=UTF-8)

    A Spreadsheet consists as a grid of many cells.

    Cell – A single location in a spreadsheet that can store data. It is the intersection of a row and column

    row – A horizontal arrangement of cells , usually denoted by a number

    column – a vertical arrangement of cells ,usually denoted by a letter, cell,

    value – the data that is stored in a cell.

    formula – a representation for a calculation stored within a cell. The formula itself is not displayed, rather, the results of the calculation is displayed in the cell.

    range – a group of cells; can be a group of horizontal cells, a group of vertical cells, a block of cells, or even many different blocks of cells.

    worksheet – a single spreadsheet in a workbook.

    workbook – a file , consisting of many worksheets (individual spreadsheets). A workbook is a file which is comprised of 1 or more worksheets (spreadsheets)

    (last updated Monday 11th January 2021)

    © 2020  Vedesh Kungebeharry. All rights reserved.