K5 Computer Lab Lesson Plans

Excel as a Database for Sorting and Filtering

This lesson teaches students how excel can be used as a database for sorting and filtering data.

This example uses Office for Mac, but the process is common to Office for Windows as well.



1) Students will enter simple planetary data into Excel.

2) Students will then sort the data by Planet.

3) Students will sort the data by Moons.

4) Students will sort the data by Rotation Period by Days.

5) Students will sort the data by Rotation Period by Hours.

6) Students will filter the data to find planets whose rotation period is shorter than 17.9 hours.


Step One:

Enter the following planetary data into an excel worksheet.


using excel for sorting



Step Two:

Sort the data by Planet.

Is the data for the remaining columns still correct? When the column for Planet was sorted, what happened to the other columns data?
The data in the remaining columns is still correct. The other columns data was sorted with the Planet column




Step Three

Sort the data by Moons

Which 2 planets have the least moons? Which 2 planets have the most moons? What happened to the data in the Rotation period columns?
Mercury and Venus have the least moons. Uranus and Saturn have the most moons. The rotation period columns were sorted to match the change in Planet column.



Step Four

Students will continue to sort the remaining columns by Rotation Periods.

Which 2 planets have the shortest rotation periods? Longest ?
Jupiter and Saturn have the shortest. Mercury and Venus have the longest.


Step Five

Custom Filtering - Filter Planets to show only those whose rotation period is less than 17.9 hours.

Which planets have shorter rotation periods than 17.9 hours?
Jupiter and Saturn.


excel database-for-filtering-lesson

For PC's and Microsoft Office

  • Excel
    Bar Chart

    Excel Bar Chart
  • Thanksgiving
    Copy and Paste

    Thanksgiving Copy and Paste
  • Green Screen
    Photo Editing

    Green Screen Photo Editing
  • Computer Lab

    Computer Lab Rules Essentials
  • California Regions

    California Regions Brochure
  • Amazing Animals

    Amazing Animals
  • I Am
    Poem Generator

    I Am Poem Generator
  • "Floater"

    I Can Float Animation
  • Copy and Paste

    Copy and Paste Practice
  • Learn PowerPoint
    in One Minute

    Learn PowerPoint in One Minute
  • M & M
    Excel Chart

    Excel Pie Chart
  • Newspaper

    Newspaper Template