Beginner
60 mins
Teacher/Student led
+95 XP

Entering Data — Cells, Rows, Columns, Sheets

Teacher Class Feed

Load previous activity

    1 - Welcome and Warm-up

    Warm-up (30 seconds): Think about your Something Real project from Lesson 1. What numbers will you need to track? (costs, dates, quantities, people?)

    This lesson teaches you how spreadsheets are organised and how to enter data accurately for your project budget or timeline.

    By the end of this lesson, you will be able to:

    • Create a spreadsheet and enter numeric and character data
    • Understand cells, references, data types and navigation
    • Enter real project data for your Something Real budget or log
    • Avoid common data entry errors

    2 - Key Concepts

    Spreadsheet basics

    • Cell: One box where you enter data (like A1, B2)
    • Row: Horizontal line of cells (numbered 1, 2, 3...)
    • Column: Vertical line of cells (lettered A, B, C...)
    • Sheet: One page/tab in your spreadsheet file (Sheet1, Sheet2)
    • Cell reference: Column letter + row number (A1 is column A, row 1)

    Why this matters

    Every cell has a unique address like a mailbox. When you add formulas later, you'll tell them which cells to use.

    3 - Explore Spreadsheet Structure

    Follow these steps to explore how spreadsheets are organised and practice basic navigation and data entry.

    4 - Sample Budget Table (guided)

    Follow this complete example of a budget table before creating your own. Notice how we mix text and numbers across rows and columns.

    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 - 2026. 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