Spreadsheet Project: Tracking Class Data

Learning Objectives Write a `for` loop to iterate through a list of class data, like student names or grades. Use `if` statements to check if a student's data meets a specific condition (e.g., if a grade is passing). Construct an `if-elif-else` chain to sort data into multiple categories (e.g., letter grades A, B, C). Combine loops and conditionals to analyze an entire list of data. Use a counter variable inside a loop to count how many items in a list meet a certain criteria. Explain the difference between the assignment operator (`=`) and the equality operator (`==`). Ever wonder how your teacher can instantly find out who has perfect attendance or who made the honor roll? 🧑‍🏫 Let's learn the secret code that makes it happen! In this lesson, we'll learn a...

TermDefinitionExample Control StructureA block of code that decides the order in which other code runs. It controls the 'flow' of the program, like a traffic light controls the flow of cars.An `if` statement is a control structure because it decides *if* a certain piece of code should run. ConditionalA statement that runs code only if a certain condition is true. We use `if`, `elif` (else if), and `else` for this.`if score > 90: print('Excellent!')` This code only prints 'Excellent!' if the value in the `score` variable is greater than 90. LoopA structure that repeats a block of code over and over. A `for` loop repeats the code for each item in a list.`for student in names: print('Hello, ' + student)` This will greet every single student in the `...

The `if-elif-else` Structure if condition1: # code to run if condition1 is True elif condition2: # code to run if condition1 is False and condition2 is True else: # code to run if all above conditions are False Use this to check a series of conditions. Python checks them in order and only runs the code for the *first* one that is True. The `else` block is a catch-all for when nothing else matches. The `for` Loop Structure for variable_name in list_name: # code to run for each item # use variable_name to access the current item Use this to perform an action on every single item in a list. The `variable_name` is a temporary variable that holds one item from the list at a time, for each iteration of the loop. The Counter Pattern counter = 0 for item in...