Filtering and conditional logic in No-Code - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is filtering in the context of data or information?

Filtering means selecting only the items that meet certain criteria and ignoring the rest. It helps focus on important or relevant data.

beginner

What does conditional logic allow you to do?

Conditional logic lets you make decisions based on whether something is true or false. It helps control what happens next depending on conditions.

beginner

Give a simple real-life example of filtering.

Choosing only red apples from a basket of mixed apples is filtering. You pick only the red ones and leave the others.

beginner

How does conditional logic work in everyday decisions?

For example, if it is raining, you take an umbrella; else, you don’t. This 'if-else' decision is conditional logic.

beginner

Why is filtering useful when working with large amounts of data?

Filtering helps you find only the data you need quickly, saving time and making it easier to understand or use the information.

What does filtering do?

A Selects items based on criteria

B Changes all items to the same value

C Deletes all data

D Adds new items randomly

Filtering means selecting only the items that meet certain criteria.

Which of these is an example of conditional logic?

A Counting all items in a list

B Mixing all fruits together

C If it is cold, wear a jacket; else, wear a t-shirt

D Ignoring all conditions

Conditional logic involves making decisions based on conditions, like choosing clothes based on weather.

Why is filtering helpful?

A To focus on important data

B To make data confusing

C To delete all data

D To add errors

Filtering helps focus on important or relevant data by selecting only what meets criteria.

Which statement is true about conditional logic?

A It copies all data exactly

B It helps make decisions based on true or false conditions

C It deletes data without reason

D It randomly changes data

Conditional logic is about making decisions depending on whether conditions are true or false.

Filtering is like:

A Mixing all fruits together

B Counting all fruits

C Throwing away all fruits

D Picking only ripe fruits from a basket

Filtering means selecting only the items you want, like ripe fruits.

Explain in your own words what filtering means and give a simple example.

Think about choosing only certain things from a group.

Describe what conditional logic is and how it helps in making decisions.

Consider how you decide what to do based on conditions.

Practice

1. What is the main purpose of filtering in data processing?

easy

A. To select only the data that meets certain conditions

B. To change all data values to uppercase

C. To add new data entries randomly

D. To delete all data permanently

Solution

1. Step 1: Understand filtering concept

   Filtering means choosing only data that fits a rule or condition.

2. Step 2: Match purpose with options

   Only To select only the data that meets certain conditions describes selecting data based on conditions, which is filtering.

3. Final Answer:

   To select only the data that meets certain conditions -> Option A

4. Quick Check:

   Filtering = selecting data by condition [OK]

Hint: Filtering means picking data that fits rules [OK]

Common Mistakes:

• Confusing filtering with changing data values
• Thinking filtering deletes all data
• Assuming filtering adds random data

2. Which of the following is the correct way to write a simple IF condition in pseudocode?

easy

A. WHILE condition THEN action OTHERWISE other_action

B. WHEN condition DO action OTHERWISE other_action

C. FOR condition THEN action ELSE other_action

D. IF condition THEN action ELSE other_action

Solution

1. Step 1: Recall IF condition syntax

   A simple IF condition uses IF, THEN, and optionally ELSE to decide actions.

2. Step 2: Compare options to standard IF syntax

   Only IF condition THEN action ELSE other_action uses IF, THEN, ELSE correctly; others use wrong keywords.

3. Final Answer:

   IF condition THEN action ELSE other_action -> Option D

4. Quick Check:

   IF-THEN-ELSE syntax = IF condition THEN action ELSE other_action [OK]

Hint: IF-THEN-ELSE is the basic conditional format [OK]

Common Mistakes:

• Using FOR or WHILE instead of IF for conditions
• Mixing keywords like WHEN or OTHERWISE incorrectly
• Omitting THEN or ELSE keywords

3. Given this pseudocode:
FOR each number IN [1, 2, 3, 4, 5]
IF number % 2 == 0 THEN print(number)
What will be printed?

medium

A. 1 3 5

B. 2 4

C. 1 2 3 4 5

D. No output

Solution

1. Step 1: Understand the loop and condition

   The loop goes through numbers 1 to 5. The condition checks if number is even (number % 2 == 0).

2. Step 2: Identify even numbers in the list

   Even numbers are 2 and 4, so only these get printed.

3. Final Answer:

   2 4 -> Option B

4. Quick Check:

   Even numbers printed = 2 4 [OK]

Hint: Print only numbers divisible by 2 [OK]

Common Mistakes:

• Printing all numbers instead of only even
• Confusing even and odd numbers
• Thinking no output occurs

4. Find the error in this pseudocode:
IF score > 50
print('Pass')
ELSE IF score > 40
print('Retake')

medium

A. Missing THEN keyword after IF conditions

B. Incorrect use of ELSE IF instead of ELSEIF

C. Missing ELSE keyword before ELSE IF

D. No error, code is correct

Solution

1. Step 1: Check IF condition syntax

   In pseudocode, IF conditions usually require THEN after the condition to separate it from actions.

2. Step 2: Identify missing THEN keywords

   Both IF and ELSE IF lines lack THEN, which is needed for clarity and correctness.

3. Final Answer:

   Missing THEN keyword after IF conditions -> Option A

4. Quick Check:

   IF conditions need THEN keyword [OK]

Hint: IF conditions need THEN before actions [OK]

Common Mistakes:

• Assuming ELSE IF is invalid syntax
• Thinking ELSE must always be alone
• Ignoring THEN keyword requirement

5. You have a list of products with prices: [{"name": "Pen", "price": 5}, {"name": "Book", "price": 15}, {"name": "Bag", "price": 25}].
Using filtering and conditional logic, which pseudocode correctly selects products priced above 10 and prints their names?

hard

A. FOR each product IN productsIF product.price == 10 THEN print(product.name)

B. FOR each product IN productsIF product.price < 10 THEN print(product.name)

C. FOR each product IN productsIF product.price > 10 THEN print(product.name)

D. FOR each product IN productsprint(product.name) IF product.price > 10

Solution

1. Step 1: Understand the filtering condition

   We want products with price greater than 10 only.

2. Step 2: Check each option's condition

   FOR each product IN products
   IF product.price > 10 THEN print(product.name) correctly uses IF product.price > 10 to filter and print names. Others use wrong conditions or syntax.

3. Final Answer:

   FOR each product IN products
   IF product.price > 10 THEN print(product.name) -> Option C

4. Quick Check:

   Filter price > 10 and print names = FOR each product IN products
   IF product.price > 10 THEN print(product.name) [OK]

Hint: Use IF price > 10 to filter products [OK]

Common Mistakes:

• Using wrong comparison operators (< or ==)
• Printing all products without filtering
• Incorrect syntax like placing IF after print