Computer Science
Grade 3
20 min
Sorting Data: Putting Things in Order
Students will learn how to sort data in ascending or descending order.
Tutorial Preview
1
Introduction & Learning Objectives
Learning Objectives
Define the term 'sort' as putting data in a specific order.
Identify if a list of numbers is sorted from smallest to biggest (ascending).
Identify if a list of words is sorted alphabetically from A to Z (ascending).
Explain the difference between sorting A-Z and sorting Z-A.
Follow steps to sort a simple list of data in a spreadsheet column.
Predict the first and last item in a list after it has been sorted.
Have you ever tried to find a book in a library where all the books are mixed up? 📚 Sorting is like being a super librarian for our computer data!
Today, we will learn how to be data detectives and put information in order. This is called sorting! Using sorting helps us find things quickly and understand our data much better.
Real-World A...
2
Key Concepts & Vocabulary
TermDefinitionExample
DataInformation we can look at, like words, numbers, or pictures.A list of your friends' names is data. The number of pets each friend has is also data.
SortTo put data into a special order.Taking a mixed-up list of numbers (5, 1, 9) and sorting it to be (1, 5, 9).
ColumnA list of data that goes up and down in a spreadsheet.In a list of pets, all the animal names (Dog, Cat, Fish) would be in one column.
RowA line of data that goes from left to right in a spreadsheet, keeping related information together.A row might have a pet's name, 'Buddy', and his age, '4', next to each other.
Ascending OrderSorting from the beginning, smallest, or first. It's like climbing UP a ladder.For numbers: 1, 2, 3, 4, 5. For letters: A, B, C, D, E.
Desce...
3
Core Syntax & Patterns
Sort A to Z (Ascending)
Click the column with words you want to sort, then choose the 'Sort A → Z' button.
Use this rule when you want to put words in alphabetical order, like a dictionary.
Sort Smallest to Biggest (Ascending)
Click the column with numbers you want to sort, then choose the 'Sort A → Z' or 'Sort Smallest to Biggest' button.
Use this rule when you want to see numbers go from low to high, like counting up.
Sort Biggest to Smallest (Descending)
Click the column with numbers you want to sort, then choose the 'Sort Z → A' or 'Sort Biggest to Smallest' button.
Use this rule when you want to see numbers go from high to low, like a countdown or a high score list.
4 more steps in this tutorial
Sign up free to access the complete tutorial with worked examples and practice.
Sign Up Free to ContinueSample Practice Questions
Challenging
You have a table with student names and their scores: (Leo, 80), (Mia, 95), (Sam, 70). If you sort the table by Score from biggest to smallest, whose name will be at the top of the list?
A.Leo
B.Mia
C.Sam
D.The names will not move
Challenging
A list of numbers is sorted from smallest to biggest. The first number is 5 and the last number is 50. Which of these numbers could NOT be in the middle of the list?
A.10
B.25
C.4
D.45
Challenging
You need to sort this list of words A-Z: Car, Cat, Can, Cab. What will the correct order be?
A.Car, Cat, Can, Cab
B.Cab, Can, Car, Cat
C.Cat, Car, Can, Cab
D.Cab, Car, Can, Cat
Want to practice and check your answers?
Sign up to access all questions with instant feedback, explanations, and progress tracking.
Start Practicing Free