Week 0

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.