Week 2

Day 1

• Refernce Sheet: 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 .

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