ACSC 101: INTRODUCTION TO INFORMATION TECHNOLOGY

Lecturer: Muigai Samuel

Email: muigaimuiruri@[Link]

WEEK 1: INTRODUCTION
Topic Overview
Introduction to computers, their functions, and benefits in modern society.
Learning Objectives
• Define key computing terms
• Understand the primary functions of computers
• Recognize the benefits of computer usage
Teaching Notes
1.1 Definitions
Computer: An electronic device that accepts input, processes data according to a set of
instructions, stores information, and produces output.
Information Technology (IT): The use of computers, networking, software, and
other equipment to manage and process information.
Data: Raw facts and figures without context (e.g., numbers, text, images).
Information: Processed data that has meaning and context.
Hardware: Physical components of a computer system.
Software: Programs and instructions that tell the computer what to do.
1.2 Functions of Computers
Primary Functions:
1. Input - Accepting data from input devices (keyboard, mouse, scanner)
2. Processing - Performing operations on data using the CPU
3. Storage - Saving data and programs for future use
4. Output - Presenting processed information (monitor, printer)
Secondary Functions:
• Communication (networking, internet)
• Control (automated systems)
• Entertainment (gaming, multimedia)
1.3 Benefits of Using Computers
Speed: Computers process millions of instructions per second, completing tasks much
faster than humans.
Accuracy: Computers perform calculations with high precision, reducing human error.
Storage Capacity: Can store vast amounts of data in small physical spaces.
Automation: Repetitive tasks can be automated, increasing efficiency.
Connectivity: Enable global communication and information sharing.
Versatility: Can perform multiple different tasks with appropriate software.
Productivity: Increase workplace efficiency and output.

WEEK 2: COMPUTER HARDWARE

Topic Overview
Understanding the physical components of computers and their organization.
Learning Objectives
• Identify functional components of a computer
• Understand structural organization
• Explain memory hierarchy
Teaching Notes
2.1 Functional Components
Central Processing Unit (CPU):
• The "brain" of the computer
• Contains: Control Unit (CU), Arithmetic Logic Unit (ALU), Registers
• Controls all operations and performs calculations
• Measured in GHz (processing speed)
Input Devices:
• Keyboard - text and command entry
• Mouse - pointing and clicking
• Scanner - converts documents to digital format
• Microphone - audio input
• Webcam - video input
• Touch screen - direct interaction
Output Devices:
• Monitor/Display - visual output
• Printer - hard copy output
• Speakers - audio output
• Projector - large-scale display
Storage Devices:
• Primary Storage: RAM (volatile), ROM (non-volatile)
• Secondary Storage: Hard Disk Drive (HDD), Solid State Drive (SSD)
• Removable Storage: USB flash drives, external HDDs, memory cards
2.2 Structural Organization
Von Neumann Architecture:
• Input Unit → Processing Unit → Output Unit
• Memory Unit (stores both data and instructions)
• Control Unit coordinates all activities
System Bus:
• Data Bus - transfers data
• Address Bus - carries memory addresses
• Control Bus - carries control signals
Motherboard: Main circuit board connecting all components.
Power Supply Unit (PSU): Provides electrical power to components.
2.3 Memory Hierarchy
Level 1 - Registers:
• Fastest, smallest capacity
• Located in CPU
• Stores immediately needed data
Level 2 - Cache Memory:
• Very fast, small capacity
• L1, L2, L3 cache
• Reduces CPU wait time
Level 3 - Primary Memory (RAM):
• Fast access, moderate capacity
• Volatile (loses data when power is off)
• Currently running programs and data
Level 4 - Secondary Storage:
• Slower access, large capacity
• Non-volatile (permanent storage)
• HDDs, SSDs
Level 5 - Tertiary Storage:
• Slowest, largest capacity
• Removable media, cloud storage
• Backup and archival purposes
Assessment Questions
1. Draw and label the functional components of a computer system.
2. Explain the memory hierarchy with examples.
3. Differentiate between RAM and ROM.
WEEKS 3 & 4: INFORMATION SYSTEMS
Topic Overview
Understanding data processing, information systems, and their components.
Learning Objectives
• Understand data processing models
• Identify components of information systems
• Classify different types of information systems
Teaching Notes
3.1 Data Processing Models
Manual Processing:
• Human-based processing
• Slow, error-prone
• Example: Manual record keeping
Batch Processing:
• Data collected over time and processed together
• Efficient for large volumes
• Example: Payroll processing, bank statements
Online/Real-time Processing:
• Immediate processing as data arrives
• Essential for time-critical applications
• Example: ATM transactions, airline reservations
Distributed Processing:
• Processing divided among multiple computers
• Increases efficiency and reliability
• Example: Cloud computing
3.2 Information Systems
Definition: A combination of hardware, software, data, people, and procedures that
work together to provide information for organizational decision-making.
Purpose:
• Collect, store, and process data
• Provide information to users
• Support organizational operations
• Facilitate decision-making
3.3 Components of Information Systems
1. Hardware: Physical devices (computers, servers, networking equipment)
2. Software: Programs and applications (operating systems, databases, applications)
3. Data: Raw facts organized into databases
4. People:
• End users
• System analysts
• Programmers
• Database administrators
• Network administrators
5. Procedures: Rules and methods for using the system effectively
6. Networks: Communication infrastructure connecting components
3.4 Types of Information Systems
Transaction Processing Systems (TPS):
• Handle routine daily transactions
• Example: Point of Sale (POS), payroll systems
Management Information Systems (MIS):
• Provide reports for middle management
• Support tactical decision-making
• Example: Sales reports, inventory summaries
Decision Support Systems (DSS):
 • Support complex decision-making
• Analyze data using models
• Example: Financial forecasting, "what-if" analysis
Executive Information Systems (EIS):
• Provide strategic information to top management
• Dashboard views, key performance indicators
• Example: Company performance overview
Expert Systems:
• Capture expert knowledge
• Provide recommendations
• Example: Medical diagnosis, loan approval
Office Automation Systems:
• Support office activities
• Example: Email, word processing, scheduling
Knowledge Management Systems:
• Create, store, and share organizational knowledge
• Example: Document management, wikis
Practical Activities
• Identify information systems used in the university
• Case study analysis of an organization's information system
• Group discussion on the importance of each component
Assessment Questions
1. Explain the difference between batch and real-time processing with examples.
2. Describe the six components of an information system.
3. Compare Transaction Processing Systems and Management Information
Systems.
WEEK 5: INFORMATION TECHNOLOGY (Part 1)
Topic Overview
IT management, objectives, functions, and impacts.
Learning Objectives
• Understand IT management principles
• Identify IT objectives and functions
• Analyze the impacts of IT
Teaching Notes
5.1 Management of IT
IT Management Definition: The process of overseeing all technology operations and
ensuring IT resources align with organizational goals.
Key Areas:
1. Strategic Planning: Aligning IT with business objectives
2. Resource Management: Managing hardware, software, and personnel
3. Project Management: Overseeing IT projects from inception to completion
4. Risk Management: Identifying and mitigating IT risks
5. Budget Management: Allocating financial resources effectively
IT Governance:
• Policies and procedures for IT use
• Compliance with regulations
• Security and privacy standards
5.2 Objectives of IT
Primary Objectives:
1. Efficiency: Automate processes, reduce time and costs
2. Effectiveness: Improve quality of services and products
3. Competitive Advantage: Gain market edge through innovation
4. Decision Support: Provide timely, accurate information
5. Communication: Facilitate internal and external communication
6. Innovation: Enable new products, services, and business models
5.3 Functions of IT
Operational Functions:
• Data processing and storage
• Transaction processing
• System maintenance and support
• User training and assistance
Strategic Functions:
• Business process improvement
• Innovation and development
• Digital transformation
• Competitive intelligence
Support Functions:
• Help desk services
• Network management
• Security management
• Backup and disaster recovery
5.4 Impacts of IT
Positive Impacts:
Business:
• Increased productivity and efficiency
• Reduced operational costs
• Expanded market reach (e-commerce)
• Improved customer service
• Better decision-making through data analytics
Society:
• Access to information and education
• Global connectivity
• Improved healthcare delivery
 • Enhanced government services (e-government)
• Social networking and collaboration
Education:
• E-learning platforms
• Access to digital libraries
• Interactive learning tools
• Distance education
Employment:
• New job categories (IT professionals, digital marketers)
• Remote work opportunities
• Skill development through online training
Negative Impacts:
• Job displacement due to automation
• Digital divide (inequality in access)
• Privacy concerns
• Cybersecurity threats
• Health issues (eye strain, sedentary lifestyle)
• Social isolation
• Information overload
Assessment Questions
1. Explain the key objectives of Information Technology in organizations.
2. Discuss four positive and four negative impacts of IT on society.
3. What is IT governance and why is it important?
WEEK 6: INFORMATION TECHNOLOGY (Part 2)
Topic Overview
IT's impact on communication, media practices, issues, and automation.
Learning Objectives
• Analyze IT's role in communication and media
• Identify issues posed by IT
• Understand automation concepts
Teaching Notes
6.1 Communication and Media Practices
Traditional Media vs. Digital Media:
Traditional Media:
• Print (newspapers, magazines)
• Broadcast (TV, radio)
• One-way communication
• Limited reach
Digital Media:
• Websites, blogs, social media
• Streaming services
• Interactive, two-way communication
• Global reach
Impact on Communication:
Speed: Instant global communication via email, messaging apps, social media
Cost Reduction: Lower cost than traditional methods (postal mail, long-distance
calls)
Multimedia: Combine text, images, audio, video
Accessibility: 24/7 access from anywhere
Collaboration: Tools like video conferencing, shared documents, project management
software
Social Media Impact:
 • Citizen journalism
• Viral content spread
• Influencer marketing
• Real-time news updates
• Community building
Business Communication:
• Email and instant messaging
• Video conferencing (Zoom, Teams)
• Collaborative platforms (Slack, Microsoft 365)
• Virtual meetings
• Digital marketing
6.2 Issues Posed by IT
1. Privacy Concerns:
• Personal data collection
• Surveillance
• Data breaches
• Lack of control over personal information
2. Security Threats:
• Malware, viruses, ransomware
• Phishing attacks
• Identity theft
• Cyber warfare
3. Digital Divide:
• Unequal access to technology
• Urban vs. rural disparities
• Economic barriers
• Educational gaps
4. Intellectual Property:
• Software piracy
• Digital content theft
• Copyright infringement
• Plagiarism
5. Ethical Issues:
• Inappropriate content online
• Cyberbullying
• Misinformation and fake news
• Online addiction
6. Health Concerns:
• Repetitive strain injuries
• Eye strain and vision problems
• Sleep disruption
• Sedentary lifestyle effects
7. Environmental Impact:
• E-waste
• Energy consumption
• Carbon footprint of data centers
8. Dependence on Technology:
• System failures impact operations
• Skill loss
• Over-reliance on automation
6.3 Automation
Definition: The use of technology to perform tasks with minimal human intervention.
Types of Automation:
Fixed Automation:
• High production volumes
• Single operation repeated
• Example: Assembly lines
Programmable Automation:
• Can be reprogrammed for different tasks
• Batch production
• Example: CNC machines
Flexible Automation:
• Easily modified for various products
• Example: Robotic manufacturing
Applications:
Manufacturing:
• Industrial robots
• Quality control systems
• Inventory management
Services:
• Automated teller machines (ATMs)
• Self-checkout systems
• Chatbots for customer service
Office:
• Document management systems
• Automated email responses
• Workflow automation
Transportation:
• Traffic control systems
• Automated vehicle systems
• Railway signaling
Benefits:
• Increased productivity
• Improved accuracy
• Cost reduction
• 24/7 operations
• Dangerous task performance
Challenges:
• Initial investment costs
• Job displacement
• Technical complexity
• Maintenance requirements
Practical Activities
• Survey on social media usage patterns
• Case study on a security breach incident
• Demonstration of automation tools
• Discussion on ethical IT issues
Assessment Questions
1. Compare traditional and digital media practices.
2. Identify and explain five major issues posed by IT.
3. Discuss the benefits and challenges of automation in organizations.
WEEK 8: COMPUTER SOFTWARE
Topic Overview
Understanding software concepts, types, and acquisition methods.
Learning Objectives
• Define software and understand its importance
• Classify different types of software
• Understand software acquisition schemes
Teaching Notes
8.1 Software Concepts
Definition: A collection of instructions that tells the computer hardware what to do.
Characteristics:
• Intangible (cannot be touched)
• Developed through programming
• Can be copied without loss of quality
• Subject to licensing agreements
Software Development Process:
1. Requirements analysis
2. Design
3. Implementation (coding)
4. Testing
5. Deployment
6. Maintenance
Programming Languages:
• Low-level: Machine language, Assembly
• High-level: Python, Java, C++, JavaScript
8.2 Types of Software
A. System Software
Operating Systems:
• Manage hardware resources
• Provide user interface
• Examples: Windows, macOS, Linux, Android, iOS
Utility Programs:
• Disk cleanup and defragmentation
• Antivirus software
• File compression tools
• Backup utilities
• System monitors
Device Drivers:
• Enable communication between OS and hardware
• Printer drivers, graphics drivers, etc.
B. Application Software
General Purpose Applications:
• Word processors (Microsoft Word)
• Spreadsheets (Microsoft Excel)
• Presentation software (PowerPoint)
• Databases (Access)
• Web browsers (Chrome, Firefox)
Specialized Applications:
• Accounting software (QuickBooks)
• Graphics design (Adobe Photoshop)
• Video editing (Adobe Premiere)
• CAD software (AutoCAD)
• Statistical analysis (SPSS)
C. Programming Software
• Compilers
• Interpreters
• Debuggers
• Integrated Development Environments (IDEs)
D. Middleware
• Connects different applications
• Database middleware
• Application servers
8.3 Software Acquisition Schemes
Commercial Software:
• Purchased with license
• Full vendor support
• Regular updates
• Examples: Microsoft Office, Adobe Creative Suite
Freeware:
• Free to use
• No access to source code
• Limited or no support
• Examples: VLC Media Player, Adobe Reader
Shareware:
• Free trial period
• Pay for continued use
• Limited features in trial version
• Examples: WinRAR, WinZip
Open Source Software:
• Source code freely available
• Can be modified and redistributed
 • Community support
• Examples: Linux, LibreOffice, Firefox, GIMP
Public Domain Software:
• No copyright restrictions
• Free to use, modify, and distribute
• No support
Software as a Service (SaaS):
• Cloud-based delivery
• Subscription model
• Accessible via internet
• Examples: Google Workspace, Microsoft 365, Salesforce
Proprietary vs. Open Source:
Proprietary:
• Pros: Professional support, guaranteed updates, user-friendly
• Cons: Cost, vendor lock-in, limited customization
Open Source:
• Pros: Free, customizable, community-driven, no vendor lock-in
• Cons: Variable quality, limited support, steeper learning curve
Practical Activities
• Install and compare different operating systems (virtual machines)
• Explore open source alternatives to commercial software
• Software licensing discussion
Assessment Questions
1. Differentiate between system software and application software with examples.
2. Explain five software acquisition schemes.
3. Compare proprietary software and open source software.
WEEK 9: APPLICATIONS (Part 1)
Topic Overview
Word processors and spreadsheet applications.
Learning Objectives
• Master word processing features
• Understand spreadsheet functionality
• Apply both tools to practical scenarios
Teaching Notes
9.1 Word Processors
Definition: Software for creating, editing, formatting, and printing text documents.
Common Word Processors:
• Microsoft Word
• Google Docs
• LibreOffice Writer
• Apple Pages
Key Features:
Text Formatting:
• Font type, size, color
• Bold, italic, underline
• Alignment (left, center, right, justify)
• Line spacing
• Paragraph indentation
Page Layout:
• Margins
• Page orientation (portrait/landscape)
• Page size
• Headers and footers
• Page numbers
Editing Tools:
• Cut, copy, paste
• Find and replace
• Spell check and grammar check
• Thesaurus
• Word count
• Track changes
Advanced Features:
• Tables
• Images and graphics
• Hyperlinks
• Table of contents
• Mail merge
• Styles and templates
• Comments and reviewing
• Footnotes and endnotes
• Bibliography management
Practical Uses:
• Reports and essays
• Letters and memos
• Resumes and CVs
• Newsletters
• Books and manuscripts
9.2 Spreadsheet Applications
Definition: Software for organizing, analyzing, and storing data in tabular form.
Common Spreadsheet Applications:
• Microsoft Excel
• Google Sheets
 • LibreOffice Calc
• Apple Numbers
Basic Concepts:
Workbook: Collection of worksheets
Worksheet: Grid of cells organized in rows and columns
Cell: Intersection of row and column (e.g., A1, B2)
Cell Reference: Address of a cell
Range: Group of cells (e.g., A1:D10)
Key Features:
Data Entry and Formatting:
• Numbers, text, dates
• Cell formatting (borders, colors, alignment)
• Number formatting (currency, percentages, decimals)
• Column width and row height adjustment
Formulas and Functions:
• Basic operators (+, -, *, /)
• Common functions:
o SUM() - adds values
o AVERAGE() - calculates mean
o MAX(), MIN() - finds maximum and minimum
o COUNT() - counts numeric values
o IF() - conditional logic
o VLOOKUP() - searches for values
o TODAY() - current date
Data Analysis:
• Sorting data (ascending/descending)
• Filtering data
• Pivot tables
 • Data validation
• Conditional formatting
Charts and Graphs:
• Column/Bar charts
• Line graphs
• Pie charts
• Scatter plots
• Chart customization
Advanced Features:
• Macros (automation)
• What-if analysis
• Goal seek
• Solver
• Data import/export
Practical Uses:
• Budgets and financial planning
• Grade calculations
• Inventory management
• Data analysis and reporting
• Scheduling
• Statistical analysis
Assessment Questions
1. List and explain five features of word processors.
2. Write the formulas to calculate: total, average, maximum value.
3. Explain the use of VLOOKUP function with an example.
WEEK 10: APPLICATIONS (Part 2)
Topic Overview
Presentation graphics, web browsers, and desktop publishers.
Learning Objectives
• Create effective presentations
• Navigate and use web browsers efficiently
• Understand desktop publishing basics
Teaching Notes
10.1 Presentation Graphics
Definition: Software for creating visual presentations using slides.
Common Applications:
• Microsoft PowerPoint
• Google Slides
• LibreOffice Impress
• Apple Keynote
• Prezi
Key Features:
Slides:
• Title slide
• Content slides
• Section headers
• Summary slides
Design Elements:
• Themes and templates
• Background colors and images
• Fonts and color schemes
• Layouts
Content Types:
• Text (titles, bullet points)
• Images and clipart
• Shapes and SmartArt
• Tables
• Charts and graphs
• Videos and audio
• Hyperlinks
Animations and Transitions:
• Slide transitions (effects between slides)
• Object animations (effects on individual elements)
• Timing controls
• Custom animation paths
Presentation Features:
• Slide show mode
• Presenter view (notes visible to presenter)
• Slide timing
• Rehearsal mode
• Remote presentation
• Export to PDF/video
Best Practices:
• Keep text minimal (6x6 rule: 6 words per line, 6 lines per slide)
• Use high-quality images
• Consistent design throughout
• Readable fonts (minimum 24pt)
• High contrast for readability
• Visual hierarchy
• Tell a story
 • Practice delivery
10.2 Browsers
Definition: Software for accessing and viewing websites on the internet.
Common Browsers:
• Google Chrome
• Mozilla Firefox
• Microsoft Edge
• Safari
• Opera
Key Features:
Navigation:
• Address bar (URL entry)
• Back/Forward buttons
• Refresh/Reload
• Home button
• Stop loading
Tab Management:
• Multiple tabs
• Tab grouping
• Pin tabs
• Reopen closed tabs
Bookmarks/Favorites:
• Save frequently visited sites
• Bookmark folders
• Bookmark bar
• Import/export bookmarks
Security Features:
• HTTPS indication
 • Pop-up blocker
• Private/Incognito mode
• Password manager
• Security warnings
• Cookie management
Advanced Features:
• Extensions/Add-ons (ad blockers, password managers, etc.)
• Developer tools
• Download manager
• Print to PDF
• Reading mode
• Translation
• Sync across devices
Search Capabilities:
• Search from address bar
• Search engines (Google, Bing, DuckDuckGo)
• Voice search
• Image search
Browser Settings:
• Homepage configuration
• Default search engine
• Privacy settings
• Cache and cookies
• Zoom level
• Download location
10.3 Desktop Publishers
Definition: Software for creating professional-quality publications and marketing
materials.
Common Applications:
• Adobe InDesign
• Microsoft Publisher
• Scribus (open source)
• QuarkXPress
• Canva
Key Features:
Page Layout:
• Multiple page documents
• Master pages (templates)
• Grid systems
• Margins and guides
• Bleed areas
Typography:
• Advanced text formatting
• Text frames and columns
• Drop caps
• Text wrapping around images
• Kerning and tracking
Graphics:
• Image placement and manipulation
• Vector graphics
• Color management
• CMYK vs. RGB
• Image resolution (DPI/PPI)
Design Elements:
• Shapes and lines
• Colors and gradients
 • Layers
• Effects and filters
• Styles and swatches
Output:
• Print-ready PDFs
• Color separation
• Proofing
• Export to various formats
Common Publications:
• Brochures and flyers
• Newsletters
• Magazines and books
• Business cards
• Posters
• Annual reports
• Catalogs
Difference from Word Processors:
• DTP focuses on visual design and layout
• Precise control over element placement
• Professional printing capabilities
• Better handling of graphics
• Multi-page publication management
Practical Activities
• Create a 10-slide presentation on a given topic
• Browse and bookmark educational websites
• Design a simple brochure or flyer
• Compare different browsers
WEEK 12: APPLICATIONS (Part 3)
Topic Overview
Databases, database management systems, and SQL basics.
Learning Objectives
• Understand database concepts
• Work with tables, records, and queries
• Learn basic SQL commands
Teaching Notes
12.1 Databases
Definition: An organized collection of structured data stored electronically in a
computer system.
Why Use Databases?
• Efficient data storage
• Easy data retrieval
• Data integrity
• Security
• Multi-user access
• Reduced redundancy
• Data consistency
Database vs. File System:
File System:
• Data stored in separate files
• Data redundancy
• Difficult to maintain consistency
• Limited data sharing
Database:
• Centralized data storage
• Minimal redundancy
• Easy data sharing
 • Better security
• Data independence
Types of Databases:
Relational Databases:
• Data in tables (rows and columns)
• Relationships between tables
• Examples: MySQL, Oracle, SQL Server, PostgreSQL
NoSQL Databases:
• Flexible schema
• Handles unstructured data
• Examples: MongoDB, Cassandra
Distributed Databases:
• Data spread across multiple locations
• Increased reliability
Cloud Databases:
• Hosted in cloud
• Scalable
• Examples: Amazon RDS, Google Cloud SQL
12.2 Database Management Systems (DBMS)
Definition: Software for creating, managing, and manipulating databases.
Common DBMS:
• Microsoft Access
• MySQL
• Oracle Database
• Microsoft SQL Server
• PostgreSQL
• SQLite
Functions of DBMS:
• Data definition (structure)
• Data manipulation (add, modify, delete)
• Data retrieval (queries)
• Data security and access control
• Backup and recovery
• Concurrency control
• Transaction management
Database Users:
• Database Administrators (DBAs)
• Application developers
• End users
DBMS Components:
• Database engine
• Query processor
• Database schema
• Query optimizer
• Report writer
12.3 Database Concepts
Table (Relation):
• Collection of related data
• Organized in rows and columns
• Example: Students table, Courses table
Record (Tuple/Row):
• Single entry in a table
• Contains data for one entity
• Example: One student's information
Field (Attribute/Column):
 • Single piece of data
• Example: Student name, Student ID, Date of birth
Primary Key:
• Unique identifier for each record
• Cannot be null
• Example: Student ID
Foreign Key:
• Links tables together
• References primary key in another table
• Example: Student ID in Enrollment table
Data Types:
• Text/String (VARCHAR, CHAR)
• Number (INT, FLOAT, DECIMAL)
• Date/Time (DATE, DATETIME)
• Boolean (TRUE/FALSE)
• Binary (BLOB)
Relationships:
• One-to-One
• One-to-Many (most common)
• Many-to-Many
12.4 Queries
Definition: Request for data from database.
Types of Queries:
• Select queries (retrieve data)
• Action queries (modify data)
• Parameter queries (user input)
• Aggregate queries (calculations)
Query Design:
 • Select fields to display
• Specify criteria (conditions)
• Sort results
• Perform calculations
12.5 Brief SQL (Structured Query Language)
Definition: Standard language for managing relational databases.
SQL Command Categories:
DDL (Data Definition Language):
• CREATE - create database objects
• ALTER - modify database objects
• DROP - delete database objects
DML (Data Manipulation Language):
• SELECT - retrieve data
• INSERT - add new records
• UPDATE - modify existing records
• DELETE - remove records
Basic SQL Commands:
1. SELECT Statement:
SELECT column1, column2 FROM table_name;
SELECT * FROM Students;
SELECT Name, Age FROM Students WHERE Age > 20;
2. INSERT Statement:
INSERT INTO Students (StudentID, Name, Age)
VALUES (1, 'John Doe', 22);
3. UPDATE Statement:
UPDATE Students
SET Age = 23
WHERE StudentID = 1;
4. DELETE Statement:
DELETE FROM Students
WHERE StudentID = 1;
5. CREATE TABLE:
CREATE TABLE Students (
StudentID INT PRIMARY KEY,
Name VARCHAR(50),
Age INT,
Email VARCHAR(100)
);
6. WHERE Clause (Filtering):
SELECT * FROM Students WHERE Age >= 21;
SELECT * FROM Students WHERE Name = 'John Doe';
7. ORDER BY (Sorting):
SELECT * FROM Students ORDER BY Name ASC;
SELECT * FROM Students ORDER BY Age DESC;
8. Aggregate Functions:
SELECT COUNT(*) FROM Students;
SELECT AVG(Age) FROM Students;
SELECT MAX(Age), MIN(Age) FROM Students;
SELECT SUM(Fees) FROM Students;
9. GROUP BY:
SELECT Course, COUNT(*) FROM Enrollments
GROUP BY Course;
10. JOIN (Combining Tables):
SELECT [Link], [Link]
FROM Students
INNER JOIN Enrollments ON [Link] = [Link]
INNER JOIN Courses ON [Link] = [Link];
Assessment Questions
1. Define database and explain its advantages over file systems.
2. Differentiate between primary key and foreign key.
3. Write SQL queries to: (a) Select all students, (b) Insert a new record, (c) Update a
student's age.
4. Explain the purpose of a Database Management System.

WEEK 13: NETWORKS & INTERNET

Topic Overview
Communication networks, network types, and internet applications.
Learning Objectives
• Understand computer networking concepts
• Identify different types of networks
• Explore internet applications and services
Teaching Notes
13.1 Communication Networks
Definition: A system of interconnected computers and devices that share resources
and information.
Network Components:
Hardware:
• Computers/Workstations
• Servers (provide services/resources)
• Network Interface Cards (NICs)
• Switches (connect devices in a network)
• Routers (connect different networks)
• Hubs (basic connection devices)
• Cables (Ethernet, Fiber optic)
• Wireless access points
Software:
• Network Operating Systems (NOS)
• Network protocols
• Network management software
• Security software (firewalls, antivirus)
Transmission Media:
Wired:
• Twisted Pair Cable (Ethernet - Cat5, Cat6)
• Coaxial Cable
• Fiber Optic Cable (highest speed)
Wireless:
• Radio waves (Wi-Fi)
• Microwave
• Satellite
• Infrared
Network Topology:
Bus Topology:
• Single cable backbone
• All devices connected to the cable
• Pros: Simple, inexpensive
• Cons: Single point of failure
Star Topology:
• Central hub/switch
• All devices connect to center
• Pros: Easy to manage, failure isolation
• Cons: Hub failure affects all
Ring Topology:
• Devices in circular arrangement
 • Data travels in one direction
• Pros: Equal access
• Cons: Break affects entire network
Mesh Topology:
• Every device connected to every other
• Pros: Highly reliable
• Cons: Expensive, complex
Hybrid Topology:
• Combination of topologies
13.2 Types of Networks
A. Based on Geographic Scope:
Personal Area Network (PAN):
• Coverage: Within 10 meters
• Connects personal devices
• Examples: Bluetooth connections, connecting phone to laptop
• Technologies: Bluetooth, USB, Infrared
Local Area Network (LAN):
• Coverage: Building or campus (up to few kilometers)
• High speed, low cost
• Examples: Office network, school computer lab
• Technologies: Ethernet, Wi-Fi
• Typical speed: 100 Mbps - 10 Gbps
Metropolitan Area Network (MAN):
• Coverage: City or metropolitan area
• Connects multiple LANs
• Examples: City-wide Wi-Fi, cable TV networks
• Technologies: Fiber optic, WiMAX
Wide Area Network (WAN):
 • Coverage: Country, continent, or worldwide
• Connects multiple LANs and MANs
• Examples: Internet, corporate networks across cities
• Technologies: Leased lines, satellite, cellular
• Typical speed: Varies widely
B. Based on Ownership:
Private Networks:
• Owned by organization
• Restricted access
• Examples: Corporate intranets
Public Networks:
• Open to general public
• Examples: Internet, public Wi-Fi
C. Based on Architecture:
Client-Server Network:
• Central server provides resources
• Clients request services
• Pros: Centralized control, better security
• Cons: Server dependency, higher cost
Peer-to-Peer (P2P) Network:
• All computers are equal
• Share resources directly
• Pros: Simple, low cost
• Cons: Less secure, difficult to manage
Network Protocols:
TCP/IP (Transmission Control Protocol/Internet Protocol):
• Foundation of internet
• Ensures reliable data transmission
HTTP/HTTPS (HyperText Transfer Protocol):
• Web page transfer
• HTTPS is secure version
FTP (File Transfer Protocol):
• File transfer between computers
SMTP (Simple Mail Transfer Protocol):
• Sending email
POP3/IMAP (Post Office Protocol/Internet Message Access Protocol):
• Receiving email
DNS (Domain Name System):
• Converts domain names to IP addresses
DHCP (Dynamic Host Configuration Protocol):
• Automatically assigns IP addresses
IP Address:
• Unique identifier for devices on network
• IPv4: [Link] (32-bit)
• IPv6: 2001:0db8:85a3:0000:0000:8a2e:0370:7334 (128-bit)
13.3 Internet
Definition: Global network of interconnected networks using TCP/IP protocols.
History:
• 1960s: ARPANET (military research)
• 1980s: TCP/IP adoption
• 1990s: World Wide Web invented (Tim Berners-Lee)
• 2000s: Web 2.0, social media
• 2010s: Mobile internet, cloud computing
Internet Service Providers (ISPs):
• Companies providing internet access
• Examples: Safaricom, Telkom, Airtel (Kenya context)
 • Connection types: DSL, Cable, Fiber, Satellite, Mobile data
World Wide Web (WWW):
• System of interlinked documents accessed via internet
• Uses HTTP protocol
• Components: Web pages, websites, web browsers, web servers
URL Structure:
[Link]
[protocol]://[subdomain].[domain].[extension]/[path]
13.4 Internet Applications
1. Email (Electronic Mail):
• Send/receive messages globally
• Attachments (files)
• Popular services: Gmail, Outlook, Yahoo Mail
• Protocols: SMTP, POP3, IMAP
2. World Wide Web:
• Information sharing platform
• Web browsing
• Search engines (Google, Bing)
3. Social Media:
• Social networking (Facebook, Twitter, LinkedIn)
• Content sharing (Instagram, YouTube, TikTok)
• Communication and collaboration
4. E-commerce:
• Online shopping (Amazon, Jumia)
• Online banking
• Digital payments (M-Pesa, PayPal)
• Auction sites (eBay)
5. Communication:
 • Instant messaging (WhatsApp, Telegram)
• Video conferencing (Zoom, Teams, Skype)
• Voice over IP (VoIP)
6. File Transfer:
• FTP clients
• Cloud storage (Google Drive, Dropbox, OneDrive)
• File sharing services
7. Entertainment:
• Streaming services (Netflix, Spotify, YouTube)
• Online gaming
• Podcasts
8. Education:
• E-learning platforms (Coursera, Udemy, Khan Academy)
• Online libraries
• Virtual classrooms
• Research databases
9. Cloud Computing:
• Infrastructure as a Service (IaaS)
• Platform as a Service (PaaS)
• Software as a Service (SaaS)
10. Internet of Things (IoT):
• Smart home devices
• Wearable technology
• Connected vehicles
Internet Security:
Threats:
• Viruses and malware
• Phishing
 • Identity theft
• DDoS attacks
• Man-in-the-middle attacks
Protection Measures:
• Strong passwords
• Two-factor authentication
• Antivirus software
• Firewalls
• VPN (Virtual Private Network)
• Regular software updates
• HTTPS websites
• Avoid suspicious links
Internet Benefits:
• Global communication
• Information access
• E-commerce and business
• Education and learning
• Entertainment
• Remote work
Internet Challenges:
• Security and privacy concerns
• Digital divide
• Information overload
• Cybercrime
• Addiction
• Misinformation
• Dependence