Be able to edit a table and its contents including insert row(s) and column(s), delete row(s) and column(s), merge cells

ICT 0417 – Layout: Editing Tables

Learning Objective

Students will be able to create, edit and format tables and their contents, including inserting and deleting rows/columns, merging and splitting cells, sorting data, converting tables to text, applying styles, adding headers/footers, checking spelling and data validity, linking formulas, converting tables to charts, exporting/importing data, and producing accessible HTML equivalents.

Why This Matters (Cambridge IGCSE 0417 Syllabus)

• AO2 – Produce ICT‑based solutions: Build invoices, timetables, experiment results, etc., that require accurate table manipulation.
• AO3 – Evaluate solutions: Verify that calculations, layout, and accessibility are correct after any edit.
• Tables are covered in Sections 13.2 (Tables), 13.3 (Headers & Footers), 14 (Styles), 15 (Proofing), 16 (Charts), 18 (Databases), 21 (Web authoring). Mastery of table editing therefore supports many exam tasks.
• Real‑world relevance: invoices, class schedules, lab reports, data export for databases, web pages, and presentations.

Software Context

Instructions are written for Microsoft Word (2016 +), LibreOffice Writer and Google Docs. Keyboard shortcuts are given for Word (the most common exam platform). Where a command differs, an alternative is noted.

Sample Table (used in all examples)

1. Inserting Rows and Columns

1. Place the cursor in any cell of the row/column that will be above/below or left/right of the new one.
2. Choose Insert → Table → Insert Rows Above/Below or Insert Columns Left/Right.

   • Word shortcut: Alt + J, T, R (rows) or C (columns).
   • LibreOffice/Google Docs: Table → Insert Row/Column Above/Below/Left/Right.

3. A blank row/column appears. Enter the required data.

2. Deleting Rows and Columns

1. Select the entire row(s) or column(s) – click the row selector (left margin) or column selector (top of the table).
2. Word: Layout → Delete → Delete Rows/Columns.
   

   LibreOffice/Google Docs: right‑click → Delete Row/Column.

3. The table contracts automatically; any data in the selected rows/columns is removed.

3. Merging and Splitting Cells

Merging

1. Select two or more contiguous cells (must be in the same row or column).
2. Choose Table Tools → Layout → Merge Cells (or right‑click → Merge Cells).
3. The content of the upper‑left cell is retained; all other content is discarded.

Splitting

1. Select the merged cell you wish to divide.
2. Word: Table Tools → Layout → Split Cells.
   

   LibreOffice: Table → Split Cells.
   

   Google Docs: Table → Split cell.

3. Specify the number of rows and columns required and click OK.

Important Note

When a table will be exported to a spreadsheet or database, avoid merged cells in the data area. Use merging only for headings or grouping labels.

4. Sorting Table Data

1. Select any cell within the column you want to sort by.
2. Word: Layout → Sort.
   

   LibreOffice: Table → Sort.
   

   Google Docs: Table → Sort range.

3. Choose Ascending or Descending and confirm.
4. Sorting updates the order of rows but does not affect formulas; refresh totals afterwards (see Section 7).

5. Converting a Table to Plain Text

Useful when the data must be imported into a database that expects CSV or when creating a simple list.

1. Select the entire table.
2. Word: Layout → Convert to Text. Choose a delimiter (Tab, Comma, or Custom).
   

   LibreOffice: Table → Convert → Convert to Text.
   

   Google Docs: Right‑click → Table properties → Convert to text.

3. The table is replaced by plain text separated by the chosen delimiter.

6. Styling Tables (Section 14 – Styles)

Applying a Pre‑defined Table Style

• Word: Table Tools → Design → Table Styles. Hover to preview, click to apply.
• LibreOffice: Table → AutoFormat → Choose a style.
• Google Docs: Table → Table properties → Table style.

Creating a Custom Table Style (Word example)

1. Open the Table Tools → Design tab.
2. Click New Table Style.
3. Define:

   • Font (type, size, colour)
   • Cell shading (background colour)
   • Border style and thickness
   • Header row formatting

4. Give the style a name (e.g., “Corporate‑Blue”) and click OK. Apply it to any table via the Table Styles gallery.

7. Headers & Footers (Section 13.3)

1. Insert → Header (or Footer) → Choose a style.
2. Place the cursor in the header/footer area and type the table title, document title, or page number.
3. For a table title that repeats on each page, use a merged header cell (see Section 3) and then Layout → Repeat Header Rows.

8. Proofreading & Data Validation (Section 15)

• Spell‑check: Press F7 (Word) or use the spell‑check button to scan table text.
• Data Validation (numeric entry):

  • Word: Insert a Content Control – Plain Text and set its properties to “Number”.
  • LibreOffice: Table → Cell → Validation → Allow → Whole number, set minimum/maximum.
  • Google Docs: No built‑in validation; use a linked Google Sheet for numeric checks.

9. Updating Formulas & Linked Fields (AO3 – Evaluation)

When rows are added or removed, totals must be refreshed.

• Word field codes (e.g., { =SUM(ABOVE) }):

  1. Select the field and press F9 to update.
  2. To force an update of all fields in the document, press Ctrl + A then F9.

• Linked Excel objects:

  1. Right‑click the embedded Excel table → Worksheet Object → Update Link.
  2. Or press Alt + F9 to toggle field codes, then F9 to refresh.

10. Converting a Table into a Chart (Section 16)

1. Select the table (or the range of cells you need).
2. Word: Insert → Chart. Choose the chart type (e.g., Column, Bar, Pie) and click OK. The data is automatically transferred to an embedded Excel sheet which you can edit.
3. LibreOffice: Insert → Chart → Choose type → Select “Data range” = selected cells.
4. Google Docs: Copy the table, paste into Google Sheets, then use Insert → Chart. Copy the chart back into Docs if required.

11. Exporting / Importing for Databases (Section 18)

Export as CSV

1. Click inside the table.
2. Word: File → Save As → Choose “Plain Text (*.txt)”. In the File Conversion dialog, select Comma‑delimited and click OK. Rename the file with a .csv extension.
3. LibreOffice: File → Save As → CSV. Confirm the delimiter (comma) and character set (UTF‑8).
4. Google Docs: File → Download → Comma‑separated values (.csv).

Import into a Relational Database (e.g., Microsoft Access)

1. Open the database and choose External Data → Import → Text File.
2. Browse to the saved .csv file.
3. In the Import Wizard:

   • Choose “Delimited”.
   • Select “Comma” as the delimiter.
   • Ensure the first row is marked as “Field Names”.
   • Check that no column contains merged‑cell data (the CSV format cannot represent merges).

4. Finish the wizard; the data appears as a new table ready for queries.

12. HTML & CSS Representation (Section 21 – Web Authoring)

HTML Markup (mirroring the final edited table)

<table summary="Stationery order – item, quantity, unit price and total">
<caption>Stationery Order</caption>
<thead>
<tr>
<th>Item</th>
<th>Quantity</th>
<th>Price (£)</th>
<th>Total (£)</th>
</tr>
</thead>
<tbody>
<tr>
<td>Notebook</td>
<td>2</td>
<td>1.50</td>
<td>3.00</td>
</tr>
<tr>
<td>Pen</td>
<td>5</td>
<td>0.80</td>
<td>4.00</td>
</tr>
<tr>
<td>Ruler</td>
<td>1</td>
<td>0.60</td>
<td>0.60</td>
</tr>
<tr>
<td colspan="2" style="text-align:right; font-weight:bold;">Subtotal</td>
<td colspan="2" style="font-weight:bold;">7.60</td>
</tr>
</tbody>
</table>

CSS Styling Example

table {
width: 100%;
border-collapse: collapse;
font-family: Arial, sans-serif;
}
th, td {
border: 1px solid #444;
padding: 6px;
text-align: left;
}
th {
background-colour: #e0e0e0;
}
caption {
caption-side: top;
font-weight: bold;
margin-bottom: 8px;
}

13. eSafety & Data Security (Sections 8.2/8.3)

• Never store personal or sensitive data (e.g., student ID numbers) in a table that will be shared publicly.
• When the document contains confidential information, protect the file:

  • Word: File → Info → Protect Document → Encrypt with Password.
  • LibreOffice: File → Save As → Save with password.
  • Google Docs: Share with specific people only and set “Viewer” or “Commenter” rights.

• Use the “Restrict Editing” feature (Word) to allow only data entry in designated cells, preventing accidental deletion of rows/columns.

14. Assessment Objective (AO) Mapping Checklist

15. Tips & Common Pitfalls (“Tips & Traps” Box)

• Undo/Redo: Ctrl + Z / Ctrl + Y.
• Data loss when merging: Only merge cells that contain the same text or are empty; otherwise lower‑right content is discarded.
• Formulas after insert/delete: Refresh field codes (Word) or recalculate linked Excel sheets.
• Hidden rows/columns: View → Show/Hide → ensure nothing is hidden before deleting.
• Consistent column width: Use “AutoFit to Contents” before printing to avoid truncated data.
• Exporting to CSV: Open the CSV in a text editor to confirm commas are used and no stray quotation marks remain.
• Accessibility: Provide concise alt‑text and a summary attribute for HTML tables.

16. Validation Checklist (post‑editing)

1. All required rows and columns are present.
2. Header row is correctly labelled and set to repeat on each page (if the table spans multiple pages).
3. Cell alignment, shading, borders and table style follow the design brief.
4. All totals or calculated fields have been refreshed.
5. Alt‑text (Word/LibreOffice) or summary (HTML) added.
6. If the table will be exported, verify that the data area contains no merged cells.
7. Spell‑check completed and numeric validation applied where required.
8. Document protected (password or restricted editing) when containing sensitive data.

Resulting Table After Full Editing

Summary Checklist

• Insert rows/columns where additional data is needed.
• Delete rows/columns to remove unnecessary information.
• Merge cells for headings only; split cells when you need separate data fields.
• Sort data to meet the brief and verify that formulas still refer to the correct cells.
• Apply a pre‑defined or custom table style that matches the corporate or exam specification.
• Add a header/footer containing the table title or page numbers.
• Proofread text, run spell‑check and apply numeric validation where appropriate.
• Refresh all totals, field codes or linked Excel data after structural changes.
• Convert the table to a chart if visual representation is required.
• Export as CSV for database import; ensure no merged cells remain in the data area.
• Produce an HTML version with proper <th> tags, a summary attribute and matching CSS.
• Secure the file with a password or restricted editing when it contains sensitive data.
• Run the final validation checklist before submission.