Of course!
Here is a consolidated summary of all three documents, organized by
unit, to help you study for your mid-terms. You've got this! 💪
---
ICT Skills Summary
Unit 1: Operating Systems
1. What is an Operating System (OS)?
· Software that acts as an interface between the user and computer hardware.
· Functions:
· Manages devices (keyboard, mouse, printer, etc.)
· Manages memory and file systems
· Allows file operations (create, copy, move, delete)
2. Types of Operating Systems:
· DOS (Disk Operating System): Early command-line OS.
· Windows: GUI-based OS by Microsoft.
· Linux: Open-source OS for PCs and servers.
· Mobile OS: Android, iOS, Symbian, Windows Phone.
3. Categories of OS:
· Interactive (GUI): User-friendly, uses mouse (e.g., Windows).
· Single-User, Single-Task: One user, one task at a time.
· Single-User, Multi-Task: One user, multiple programs (e.g., Windows, macOS).
· Multi-User: Multiple users simultaneously (e.g., UNIX, Linux).
· Distributed: Manages networked computers as a single system.
4. Windows 7 Desktop:
· Desktop: First screen after login.
· Icons: Small pictures representing files/folders/apps.
· Taskbar: Bottom bar with Start button, active apps, notification area.
· Start Button: Opens menu for programs, search, settings, shutdown.
· Recycle Bin: Stores deleted files; can be restored.
5. File Management:
· File: Everything stored on a computer.
· Folder: Group of files.
· Creating/Renaming/Deleting: Right-click → New/Rename/Delete or use keyboard
shortcuts.
· Copying: Ctrl + C, Ctrl + V or right-click → Copy/Paste.
· Moving: Ctrl + X, Ctrl + V or drag-and-drop.
· Permanent Delete: Empty Recycle Bin.
---
Unit 2: Computer Care & Maintenance
1. Importance of Maintenance:
· Prevents system failure, detects issues early, protects against viruses.
2. Basic Care:
· Keep dust-free.
· Avoid eating/drinking near computer.
· Clean hands before using keyboard.
· Handle CDs/DVDs carefully.
· Cover keyboard when not in use.
3. Cleaning Precautions:
· Power off before cleaning.
· Don’t spray liquid directly on components.
· Avoid dripping near circuit boards.
4. Maintenance Activities:
· Run antivirus regularly.
· Disk defragmentation (speeds up computer).
· Regular data backup.
· Upgrade RAM/storage.
· Delete temporary internet files.
5. Computer Viruses:
· What it is: Malicious software that alters program behavior.
· Ways of infection: Infected files, pen drives, CDs, email attachments.
· Signs: Slow computer, changed file sizes, unusual errors, auto-restart.
· Prevention: Install/update antivirus, scan downloads, avoid unknown emails.
---
Entrepreneurial Skills Summary
1. Entrepreneur & Entrepreneurship:
· Entrepreneur: Person who starts a business, bears risks.
· Entrepreneurship: Process of setting up a business.
2. Entrepreneurship & Society:
· Society provides market, raw materials, financial support.
· Types:
· Social Entrepreneurship: Solves social problems.
· Agricultural: Innovations in farming.
· Women Entrepreneurship: Led by women (51% ownership & employment).
· Small Scale: Backbone of developing economies.
3. Qualities of an Entrepreneur:
· Hardworking, Optimistic, Independent, Energetic, Self-Confident, Perseverant.
4. Functions of an Entrepreneur:
· Entrepreneurial: Innovation, Risk-taking, Organization building.
· Promotional: Idea discovery, research, assembling resources, financing.
· Managerial: Planning, organizing, staffing, directing, controlling.
5. Myths of Entrepreneurship:
· Entrepreneurs are born ❌ (can be learned).
· Great ideas alone lead to success ❌ (execution matters).
· High risk always ❌ (calculated risks).
· Need a lot of money ❌ (start small, grow steadily).
· Must know everything ❌ (continuous learning is key).
---
Electronic Spreadsheet (LibreOffice Calc) Summary
1. Data Analysis Tools:
· Consolidate: Combines data from multiple sheets.
· Subtotals: Automatically groups and applies functions (Sum, Avg, etc.).
· Goal Seek: Finds input value for a desired output.
· Solver: Solves equations with multiple variables (min/max results).
2. Macros:
· Macro: Records repetitive tasks.
· Recording: Tools → Macros → Record Macro.
· Naming Rules: No spaces, no special chars (except _).
· Run Macro: Tools → Macros → Run Macro.
· Macro as Function: Use Function...End Function to create custom formulas.
3. Linking Data:
· Reference Other Sheets: ='SheetName'.CellAddress or $[Link]
· Hyperlinks: Jump to other sheets/files/websites.
· Absolute vs. Relative Hyperlinks: Absolute includes full path; relative is based
on current location.
4. Sharing & Reviewing:
· Shared Spreadsheet: Multiple users can edit simultaneously.
· Track Changes: Records edits, comments, and conflicts.
· Comments: Insert → Comment or Edit → Track Changes → Comment.
· Merge/Compare Docs: Combine or compare different versions under Edit → Track
Changes.
5. External Data:
· Import data from web pages or registered databases (e.g., .odb files).
---
Key MCQ Topics to Review:
· ICT = Information and Communication Technology
· Computer = Electronic machine
· Hardware vs. Software (e.g., MS Paint is software)
· BIOS = Basic Input/Output System
· Desktop, Icons, Taskbar, Recycle Bin
· Operating system types and functions
· Virus prevention and signs
· Entrepreneurial myths and qualities
· Spreadsheet functions: Consolidate, Goal Seek, Macros, Hyperlinks
---
Good luck with your exams! You can do it! 📚✨