Printable Loopcards | Mastering sorting and filtering in Microsoft Excel | iGCSE ICT

What are loop cards?

Loop cards are a great game that can be played individually or as a class. They are perfect for review key vocabulary or questions at the end of a topic or when revising for an exam.

Instructions

  1. Cut out the cards from the paper horizontally (but don't cut them in half!) and then shuffle them.
  2. Now start joining each question on the right hand side of the card to the matching answer on the next card.
  3. Carry on until all the cards loop together and you have competed the game!

Hint: Make sure that you set your paper to portrait to print 4 cards per sheet of A4 paper.

Edit Vocab

The process of arranging data in a particular order, such as ascending or descending.
Filtering
The process of displaying only a certain set of data based on specific criteria.
Microsoft Excel
A spreadsheet program developed by Microsoft.
Worksheet
A single page or tab within an Excel workbook that contains cells.
Cell
The intersection of a row and column on an Excel worksheet, used to store data.
Column
A vertical group of cells identified by a letter in Excel.
Row
A horizontal group of cells identified by a number in Excel.
Header row
The top row of data in a worksheet, often used to identify the column names.
Data
The values or information that is stored within cells on an Excel worksheet.
Ascending order
Arranging data in order from smallest to largest.
Descending order
Arranging data in order from largest to smallest.
Filter criteria
The specific conditions used to display a subset of data.
Filter dropdown
The dropdown menu in Excel that allows for filtering based on specific criteria.
Clear filter
Removing all filter criteria from a worksheet.
Auto filter
A feature in Excel that automatically applies filters based on the data within the worksheet.
Custom filter
A filter created by the user to display data based on specific criteria.
Advanced filter
A filter used to display data based on complex criteria using multiple criteria ranges.
Sort order
The arrangement of data in either ascending or descending order based on specific criteria.
Sort criteria
The specific conditions used to arrange data in a particular order.
Multiple sort
The ability to sort data based on multiple criteria at the same time.
Sorting