---
title: "Week 2"
space: "Teacher's Handbook"
url: "https://portal.cs17.org/teachers-handbook/q1/w2"
updated: "2026-06-14"
---

## Day 1

- Refernce Sheet: [https://portal.cs17.org/files/sales.ods](https://portal.cs17.org/files/sales.ods)
- Intermediate LibreOffice Calc
- Merging Cells
- Conditional Formatting
  - Simple equal to
  - "Formula is"
  - Format entire row
- `COUNTIF` 
- VLOOKUP
- XLOOKUP (after explaining the caveat of `VLOOKUP`)
- AND, OR functions
- IFERROR combined with XLOOKUP
- Explain `$` , A$2 will remain A$2 even if auto filled etc. $A$2 will freeze the column too in case of horizontal auto-fill

```
=VLOOKUP(E13, B1:D9, 3, 0) # ALWAYS looks up in B column (first)
=XLOOKUP(E13, B2:B9, D2:D9) # Much cleaner and flexible too!!
```

## Day 2

Practice with: [https://portal.cs17.org/files/school_practice.ods](https://portal.cs17.org/files/school_practice.ods) .

## Day 3

- Boolean Algebra
  - Who? What? Why relevant to the field of CS?
- Basic operators: `AND` , `OR` , `NOT` 
- Truth Table
- Boolean "expressions"
- Boolean Laws:
  - Identity (A `AND` 1 = A, A `OR` 0 = A)
  - Idempotent (A `AND` A = A, A `OR` A = A)
  - Double Negation `~~A` = `A`)
  - DeMorgan's Laws (IMP)
- Practice
- Give problem set 2: https://portal.cs17.org/student-handbook/assignments/q1-p2

## Day 4

- Logic Gates
- NAND, NOR
- Why NAND is a very powerful gate?
  - Show them OR, AND, NOT using NAND
- Circuit diagrams
- Questions:
  - Draw TT of expression: X.~Y + Y.~Z
  - If X = 0, Y = 1, Z =0, what is the value of the above expression?
- Draw the circuit diagram and ask them to write expression and draw TT

## Day 5

- Time to work on Problem Set 2