---
title: "Week 0"
space: "Teacher's Handbook"
url: "https://portal.cs17.org/teachers-handbook/q1/w0"
updated: "2026-06-04"
---

## Day 1

### Introduction to the program

- Give a bird's eye view of the 6 quarters 
- Start and the end
- The facilities

### Laptop Distribution

- Ubuntu pre-installed laptop
- First homework: change the password and wallpaper

## Day 2

### Basics of Computers

- From huge rooms to personal computers
- Components of their own laptop (trackpad, keyboard, etc.)
- Hardware Components of Computer:
  - CPU
  - RAM
  - ROM
  - Motherboard
  - Bus
  - I/O Devices
- The Internet
  - Example of connecting laptops and "hopping" from one student laptop to another
  - "World Wide Web"
- Software:
  - System Software
    - Operating System (sits between Hardware and Application Software)
  - Application Software (with examples)
    - Games
    - Word Processing Software
    - Spreadsheets
    - Slides
    - SM apps

> Homework: Download and install Chrome, find about Bill Gates and MS



### Live Demo (with follow along)

- UI Overview of the Ubuntu (basic)
- Folders and Files
- Creating folders
- Understanding extensions: png, jpeg, mp3, mp4, pdf

> Homework: create six folders, Q1...Q2. And some more inside Q1 for this quarter.

- LibreOffice writer basic overview with menu bar and tool bar

> Homework: copy your hand written notes to a LibreOffice Writer document

## Day 3

- Continued with LibreOffice writer
- Taught them basic tools:
  - Text Alignment
  - Header / Footer
  - Lists: Ordered, Unordered
  - Download and installed a font (also explained what a ZIP file it, they later asked to elaborate)

> Homework: download and install some fonts from Google fonts

- Spent quite sometime explaining what keyboard shortcuts are and the important ones:
  - Ctrl + S
  - Ctrl + C, Ctrl + V
  - Ctrl + B, I, U for basic formatting
  - The most important: Ctrl + Z (Undo)
  - Ctrl + Y (redo)
- Showed them the inside of a CPU live (took an old CPU)
- Showed them Find & Replace feature
- Inserting Tables
- Ended with exporting a PDF and why PDF explanation

BONUS: showed them how to take screenshots in Ubuntu, what clipboard is (as the screenshot was copied to clipboard) and inserting those in LibreOffice Writer.

- Brief introduction to LibreOffice calc (got connected with Tables)

> Homework: copy notes to writer, also use screenshots!

## Day 4

### LibreOffice Calc

- Rows, Columns, Cells (Cell Address too)
- Data Entry process (with some sample data: Kirana store sales example)
- **Formula** (start simple: =2+2, etc., show basic operators, specially *, /, ^)
- Then show how you can use address like E2 in formulas (change the cell data, calculation updates)
- The apply on the sample data (I used sales - purchase - expense to get profit)
- Then pull to autofill, magic
- Then show functions: SUM, AVG, etc. with ranges, e.g. E2:E11
- Explain Sorting (ascending, descending) and filtering on the board first
- Then show how to do sorting in Calc
- Show auto filter (Data > AutoFilter)
- E.g. less than 18 etc.
- Show charts
  - Types of charts: Line, Pie, Bar
  - Chart elements (Legends, title, axes labels, etc.)
  - Color customisations
  - Data Series

### Day 5

- [Was a Saturday] But this seemed like a good point to revise 
- We had all hands, where everyone shared their weekly updates and learnings

**Give Q1P1 assignment.**

