Beginner
60 mins
Teacher/Student led
+135 XP
What you need:
Chromebook/Laptop/PC

Manipulating Table Data

In this lesson, we will learn how to manipulate table data by updating and deleting rows. We will continue working on our superhero table and make changes to their powers and aliases.

Teacher Class Feed

Load previous activity

    1 - Step 1: Reviewing Our Table

    Before we start manipulating our table data, let's review our superhero table. It should look like this:

    Name       | Alias          | Power
    -----------|----------------|--------------
    Superman | Clark Kent | Flight
    Spider-Man | Peter Parker | Web-slinging
    Iron Man | Tony Stark | Genius Engineer

    2 - Step 2: Updating a Row

    Let's say we want to update Spider-Man's power to 'Web-slinging and Wall-crawling'. To do this, find the row with Spider-Man, and replace 'Web-slinging' with 'Web-slinging and Wall-crawling' in the 'Power' column. Your table should now look like this:

    Name       | Alias          | Power
    -----------|----------------|---------------------
    Superman | Clark Kent | Flight
    Spider-Man | Peter Parker | Web-slinging and Wall-crawling
    Iron Man | Tony Stark | Genius Engineer

    3 - Step 3: Deleting a Row

    Now, let's say we want to remove Iron Man from our table. To do this, simply delete the entire row containing Iron Man's information. Your table should now look like this:

    Name       | Alias          | Power
    -----------|----------------|---------------------
    Superman | Clark Kent | Flight
    Spider-Man | Peter Parker | Web-slinging and Wall-crawling

    4 - Step 4: Adding More Rows

    Let's add two more superheroes to our table. Add the following rows to your table:

    Name         | Alias           | Power
    -------------|-----------------|----------------
    Wonder Woman | Diana Prince | Super Strength
    Batman | Bruce Wayne | Detective Skills

    Your table should now look like this:

    Name         | Alias           | Power
    -------------|-----------------|---------------------
    Superman | Clark Kent | Flight
    Spider-Man | Peter Parker | Web-slinging and Wall-crawling
    Wonder Woman | Diana Prince | Super Strength
    Batman | Bruce Wayne | Detective Skills
    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