Intermediate
60 mins
Teacher/Student led
+80 XP
Pupils work on their own device

Borders, Shading and Readability

Tidy your project budget spreadsheet by adding borders, shading to headings and adjusting column widths. Check how readable it is on a phone or when projected and apply a rubric to ensure a clean layout.

Teacher Class Feed

Load previous activity

    1 - Introduction ~5 mins

    Today you will

    • add borders and a shaded heading row to {{code:05_project_budget}}
    • make every column wide enough to read
    • test your sheet at phone size

    Illustration for IntroductionIf you don't have {{code:05_project_budget}}, tell your teacher now. Make a new sheet in {{code:05_budget}} with these headings and eight rows of your own project costs.

    ItemCategoryCost (€)Notes

    Warm-up

    Think of a messy spreadsheet you saw on a phone. What made it hard to read?

    2 - Key Concepts ~5 mins

    Key words

    Borders are thin lines that help the eye follow each row.

    Heading shade is a pale colour on the heading row only.

    Column width must fit the text. Cut-off text or ### means the column is too narrow.

    A readability test checks that your sheet is clear on a phone or from far away.

    Example: a clean budget

    ItemCategoryCost (€)Notes
    Blank hoodies × 20Stock180.00Supplier in Galway
    Market stall feeSelling25.00Saturday market

    3 - Step-by-step Task ~16 mins

    Now you will make {{code:05_project_budget}} easy to read. Pick the tab for your app, then follow the steps in the box below.

    4 - Common Issues ~4 mins

    Common issues

    • The whole sheet turned blue. Press {{kbd:Ctrl+Z}} or {{kbd:Cmd+Z}} to undo. Click only the heading row number, then add the colour again.
    • Borders only show on one column. Select the whole table first, then choose All Borders.
    • I see ### or cut-off text. Drag the column wider, or wrap the text and make the row taller.

    5 - Independent Practice ~20 mins

    Independent Practice

    Your goal: Finish {{code:05_project_budget}} so anyone can read your costs easily.
    Time: ~20 minutes
    Task:
    1. Rewrite one Notes cell as a full, useful phrase, such as "Deposit paid to printer in Athlone, balance due Friday".
    2. Make sure the whole note shows. Widen the column, wrap the text or make the row taller.
    3. Set the zoom to 50%, or open the sheet on your phone, and fix anything you can't read.
    4. Check the file is still called {{code:05_project_budget}} in {{code:05_budget}}.
    Success criteria:
    • My heading row is bold with a pale shade.
    • All text shows, with no ### or cut-off words.
    • My table has an even grid of borders.
    • I can read the headings and first costs at 50% zoom.
    123learn · Online learning platform

    Unlock the full learning experience

    You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.

    Hundreds of curriculum-aligned lessons
    Interactive activities in every lesson
    Printable resources & progress tracking
    Copyright Notice
    This lesson is copyright of Coding Ireland 2017 - 2025. Unauthorised use, copying or distribution is not allowed.
    🍪 Our website uses cookies to make your browsing experience better. By using our website you agree to our use of cookies. Learn more