BASIC COMPUTER PACKAGES – COLLEGE LEVEL
NOTES
1. Introduction to Computers
A computer is an electronic device that accepts data (input), processes it under the control of a set of instructions
known as programs, stores it for future use, and produces information (output). Computers are widely used in
education, business, healthcare, communication, and research due to their speed, accuracy, and reliability.
• Data vs Information: Data refers to raw facts, while information is processed data that is meaningful.
• Characteristics of computers: Speed, accuracy, diligence, versatility, automation, large storage capacity.
• Limitations: Computers cannot think, make decisions independently, or work without instructions and power.
• Generations of computers: First (vacuum tubes), Second (transistors), Third (ICs), Fourth (microprocessors),
Fifth (AI-based systems).
2. Computer Hardware
Computer hardware refers to the physical and tangible components of a computer system. These components
work together to enable input, processing, storage, and output of data.
2.1 Input Devices
• Keyboard – used to enter text, numbers, and commands into the computer.
• Mouse – a pointing device used to select, open, drag, and drop items on the screen.
• Scanner – converts hard copy documents into digital format.
• Barcode reader – reads barcodes for identification and pricing.
• Webcam – captures live video and images.
2.2 Output Devices
• Monitor – displays visual output such as text, images, and videos.
• Printer – produces output on paper (hard copy). Types include inkjet and laser printers.
• Speakers and headphones – output sound.
• Projector – displays output onto a large screen.
2.3 Processing and Storage Devices
• CPU (Central Processing Unit) – executes instructions and controls all computer operations.
• CPU components: Control Unit (CU), Arithmetic Logic Unit (ALU), registers.
• Primary memory: RAM (volatile) and ROM (non-volatile).
• Secondary storage: Hard disk, SSD, flash disk, optical disks, cloud storage.
3. Computer Software
Software refers to a collection of programs and instructions that tell the computer what to do. Without software,
hardware cannot function.
• System software – manages hardware resources and provides a platform for applications (Windows, Linux,
macOS).
• Application software – designed to perform specific user tasks (Word, Excel, browsers).
• Utility software – performs system maintenance and security tasks (antivirus, backup tools).
• Open-source vs proprietary software.
4. Microsoft Word (Word Processing)
• Used for creating, editing, formatting, and printing text documents.
• Document components: Title bar, ribbon, tabs, rulers, status bar.
• Formatting features: Fonts, styles, alignment, spacing, bullets and numbering.
• Advanced features: Tables, images, headers and footers, page numbering, mail merge.
• Common uses: Letters, reports, CVs, minutes, academic assignments.
5. Microsoft Excel (Spreadsheets)
• Excel is used to organize, calculate, analyze, and visualize data.
• Workbook and worksheet structure.
• Cells and cell referencing: Relative, absolute, and mixed references.
• Common formulas and functions: SUM, AVERAGE, COUNT, IF.
• Charts and graphs: Column, bar, pie, line charts.
• Applications: Budgeting, payroll, inventory, results analysis.
6. Microsoft PowerPoint (Presentations)
• PowerPoint is used to create slide-based presentations.
• Components: Slides pane, slide area, notes section.
• Design elements: Themes, layouts, backgrounds.
• Animations and transitions enhance presentation delivery.
• Uses: Teaching, seminars, business pitches, project presentations.
7. Internet and Email
• The Internet is a worldwide network of interconnected computers.
• Common internet services: WWW, email, cloud computing, social media.
• Web browsers: Chrome, Firefox, Edge.
• Email structure: Email address, inbox, sent, attachments.
• Advantages and disadvantages of internet usage.
• Cyber threats: Phishing, malware, hacking.
8. Computer Security, Safety and Maintenance
• Computer security involves protecting systems from unauthorized access and damage.
• Use strong passwords and two-factor authentication.
• Install antivirus and keep software updated.
• Regular data backup and proper shutdown procedures.
• Physical safety: Proper handling, ventilation, and cleaning of hardware.