K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators Google Classroom
Graphic Organizers
Google Classroom
Spreadsheets
iPad Classroom Tech Integration iPad - Mac
Graphic Organizers
Excel Word Word - Graphic Organizers PowerPoint MultiMedia Internet Research Apple Mac Keynote Apple Mac Pages Apple Mac Numbers Apple Mac Multimedia Coding For Kids Resources

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

 

excel-as-database-for-sorting

 

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.


excel-as-database-sorting-lesson

 

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

More Ideas
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
    Rules
  • Computer Lab Rules Essentials
  • California Regions
    Brochure
  • California Regions Brochure
  • Amazing Animals
    PowerPoint
  • Amazing Animals
  • I Am
    Poem Generator
  • I Am Poem Generator
  • "Floater"
    Animation
  • I Can Float Animation
  • Learn PowerPoint
    in One Minute
  • Learn PowerPoint in One Minute
  • Copy and Paste
    Practice
  • Copy and Paste Practice
  • M & M
    Excel Chart
  • Excel Pie Chart
  • Newspaper
    Template
  • Newspaper Template