Computer Essentials Notes

Based on the "Fundamental of Computer" syllabus, the key topics for Computer Essentials
include:

1. Fundamentals of Computer
1.1 Introduction
• Definition of Computer: An electronic device that processes data, performs calculations,
and executes instructions.
• Characteristics of Computers: Accuracy, Speed, Diligence, Versatility, Reliability,
Automation, and Memory.
• Basic Operations: Input, Process, Output, and Storage.
1.2 Type of Computer
• Based on Size and Capability: Supercomputers, Mainframe Computers, Minicomputers,
Workstations, Microcomputers (Personal Computers - Desktops, Laptops, Tablets,
Smartphones).
• Based on Data Handling: Analog, Digital, and Hybrid Computers.
1.3 Components of PC
• Hardware: Physical components of a computer system.
• Central Processing Unit (CPU): The
brain of the computer, responsible for executing instructions.
* Arithmetic Logic Unit (ALU): Performs arithmetic and logical operations.
* Control Unit (CU): Manages and coordinates the components of the computer system.
* Registers: Small, high-speed storage locations within the CPU.
* Memory: Stores data and instructions.
* Primary Memory (RAM & ROM):
* RAM (Random Access Memory): Volatile memory used for temporary storage of data and
programs currently in use. Faster than secondary memory.
* ROM (Read-Only Memory): Non-volatile memory that stores permanent instructions
(e.g., BIOS) needed to start the computer.
* Secondary Memory (Storage Devices): Non-volatile memory for long-term storage.
* Hard Disk Drive (HDD): Traditional storage with spinning platters.
* Solid State Drive (SSD): Faster, more durable storage using flash memory.
* Optical Discs (CD, DVD, Blu-ray): Data stored and read using lasers.
* USB Flash Drives: Portable storage devices.
* Motherboard: The main circuit board that connects all components of the computer.
* Power Supply Unit (PSU): Converts AC power to low-voltage DC power for internal
components.
* Expansion Cards: (e.g., Graphics Card, Sound Card, Network Card) Add functionality to
the computer.
• Software: Set of instructions that tells the hardware what to do.
• System Software: Manages computer hardware and software resources.
• Operating System (OS): (e.g., Windows, macOS, Linux) Manages hardware and
software resources, provides a user interface, and runs applications.
• Device Drivers: Enable communication between the OS and hardware devices.
• Utility Software: (e.g., antivirus, disk defragmenter) Helps maintain and optimize
computer performance.
• Application Software: Programs designed to perform specific tasks for users.
• Word Processors: (e.g., Microsoft Word, Google Docs) For creating and editing text
documents.
• Spreadsheet Software: (e.g., Microsoft Excel, Google Sheets) For organizing,
analyzing, and storing data in tabular form.
• Presentation Software: (e.g., Microsoft PowerPoint, Google Slides) For creating
and delivering presentations.
• Web Browsers: (e.g., Chrome, Firefox, Edge) For accessing and viewing websites.
 • Multimedia Software: (e.g., VLC Media Player, Adobe Photoshop) For creating or
playing audio, video, and images.
1.4 Inputs & Output Devices
• Input Devices: Used to enter data and instructions into a computer.
• Keyboard: For typing text and commands.
• Mouse: For controlling the cursor and interacting with graphical user interfaces.
• Scanner: Converts physical documents or images into digital format.
• Microphone: For inputting audio.
• Webcam: For capturing video and still images.
• Touchscreen: Allows direct interaction with the display.
• Joystick/Game Controller: For gaming.
• Output Devices: Used to display or present processed data from the computer.
• Monitor/Display: Visual output of text and graphics.
• Printer: Produces hard copies of documents or images.
• Speakers/Headphones: For audio output.
• Projector: Displays computer output onto a large screen.

1.5 Computer Languages

• Machine Language (First Generation): Binary code (0s and 1s) directly understood by
the CPU. Machine-dependent and difficult to program.
• Assembly Language (Second Generation): Uses mnemonics (short codes) for
instructions, translated into machine code by an assembler. Still machine-dependent
but easier than machine language.
• High-Level Languages (Third Generation): (e.g., C, C++, Java, Python) Use English-like
statements, translated into machine code by compilers or interpreters. Machine-
independent and easier to read, write, and debug.
• Fourth-Generation Languages (4GLs): (e.g., SQL, MATLAB) Designed to be closer to
human language, often used for specific applications like database management or
statistical analysis.
• Fifth-Generation Languages (5GLs): (e.g., Prolog, OPS5) Used in artificial intelligence
and expert systems, focusing on solving problems using constraints rather than
algorithms.
1.6 Memory of Computer
• Primary Memory:
• RAM (Random Access Memory): Volatile, read/write, temporary storage for active
programs and data. Faster access.
• ROM (Read-Only Memory): Non-volatile, read-only, stores firmware and boot-up
instructions.
• Secondary Memory: Non-volatile, permanent storage for large amounts of data.
• Hard Disk Drives (HDDs): Magnetic storage, high capacity, slower access.
• Solid State Drives (SSDs): Flash-based storage, faster, more durable, lower power
consumption.
• Optical Discs (CD/DVD/Blu-ray): Laser-based storage.
• Flash Memory (USB drives, SD cards): Portable, non-volatile storage.
• Cache Memory: Small, very fast memory located between the CPU and main memory.
Stores frequently accessed data to speed up processing.
• Registers: Smallest and fastest memory in the CPU, used to hold data and instructions
during processing.
2. Introduction to MS Office
2.1 MS-Word: Introduction, Starting MS-Word Screen and its
Components, Elementary Working with MS-Word
• Introduction: A word processing software used to create, edit, format, and print text
documents.
• Starting MS-Word: Typically from the Start Menu or a desktop shortcut.
• Screen Components:
• Ribbon: Contains tabs (File, Home, Insert, Design, Layout, References, Mailings,
Review, View) with groups of related commands.
• Quick Access Toolbar: Customizable toolbar for frequently used commands.
• Title Bar: Displays the document name and application name.
• Rulers: Horizontal and vertical rulers for precise alignment and measurement.
• Scroll Bars: For navigating through the document.
• Status Bar: Displays information about the document (page number, word count,
zoom).
• Document Area: The main area where text is entered and edited.
• Elementary Working: Typing, selecting text, copying, cutting, pasting, saving, opening
documents.
2.2 MS-Excel: Introduction, Starting MS-Excel, Basics of Spreadsheet,
MS-Excel Screen and its Components, Elementary Working with MS-
Excel.
• Introduction: A spreadsheet software used for organizing, analyzing, and storing data
in tabular form, performing calculations, and creating charts.
• Starting MS-Excel: From the Start Menu or a desktop shortcut.
• Basics of Spreadsheet:
• Workbook: An Excel file containing one or more worksheets.
• Worksheet: A single sheet within a workbook, composed of rows and columns.
• Cell: The intersection of a row and a column, where data is entered.
• Cell Address: Unique identifier for a cell (e.g., A1, B5).
• Range: A group of selected cells (e.g., A1:B5).
• Screen Components: Similar to MS-Word (Ribbon, Quick Access Toolbar, Title Bar,
Scroll Bars, Status Bar), plus:
• Formula Bar: Displays the content of the active cell and allows editing.
• Name Box: Displays the address of the active cell.
• Column Headers (A, B, C...): Identify columns.
• Row Headers (1, 2, 3...): Identify rows.
• Elementary Working: Entering data, basic formulas (SUM, AVERAGE), formatting cells,
creating simple charts.
2.3 MS –Power Point: Introduction, Starting MS-PowerPoint, Basics of
PowerPoint, MS-PowerPoint Screen and Its Components, Elementary
Working with MS-PowerPoint.
• Introduction: A presentation software used to create and deliver slideshows.
• Starting MS-PowerPoint: From the Start Menu or a desktop shortcut.
• Basics of PowerPoint:
• Presentation: A collection of slides.
• Slide: A single page in a presentation.
• Layouts: Predefined arrangements of placeholders on a slide.
 • Themes: Predefined sets of colors, fonts, and effects.
• Screen Components: Similar to MS-Word and Excel (Ribbon, Quick Access Toolbar, Title
Bar, Status Bar), plus:
• Slide Pane: Displays the current slide.
• Outline/Slides Pane: Displays a text outline of the presentation or thumbnails of
slides.
• Notes Pane: For adding speaker notes.
• Elementary Working: Adding new slides, choosing layouts, entering text, inserting
images, applying basic animations and transitions.

3. Introduction to Internet
3.1 What is Internet?
• A global system of interconnected computer networks that uses the Internet protocol
suite (TCP/IP) to communicate between networks and devices.
• A vast network of networks that consists of private, public, academic, business, and
government networks of local to global scope, linked by a broad array of electronic,
wireless, and optical networking technologies.
3.2 Computer Communication and Internet.
• Data Communication: The exchange of data between two devices via some form of
transmission medium.
• Protocols: Rules that govern data communication (e.g., TCP/IP, HTTP, FTP).
• TCP/IP (Transmission Control Protocol/Internet Protocol): The fundamental protocol
suite for the Internet.
• TCP: Ensures reliable delivery of data packets.
• IP: Handles addressing and routing of data packets.
• Client-Server Model: Most common model for Internet services, where clients request
resources from servers.
3.3 WWW and Web Browsers.
• World Wide Web (WWW): An information system on the Internet that allows documents
and other web resources to be accessed via hyperlinks and URLs.
• Web Browser: Software application for retrieving, presenting, and traversing
information resources on the World Wide Web (e.g., Chrome, Firefox, Edge, Safari).
• URL (Uniform Resource Locator): The address of a web page or other resource on the
Internet.
• HTTP (Hypertext Transfer Protocol): The protocol used for transmitting web pages
over the Internet.
• HTML (Hypertext Markup Language): The standard markup language for creating web
pages.
3.4 Creating own Email Account.
• Email (Electronic Mail): A method of exchanging digital messages from an author to
one or more recipients.
• Email Service Providers: (e.g., Gmail, Outlook, Yahoo Mail) Offer free or paid email
accounts.
• Steps to Create an Email Account: Choose a provider, sign up, fill in personal details,
choose a username and password.
3.5 Networking and types.
• Networking: Connecting two or more computing devices together to share resources
and exchange data.
• Types of Networks:
 • LAN (Local Area Network): Connects devices in a limited geographical area (e.g.,
home, office).
• WAN (Wide Area Network): Connects devices over a large geographical area (e.g.,
cities, countries), often using public telecommunication lines.
• MAN (Metropolitan Area Network): Covers a larger area than LAN but smaller than
WAN (e.g., a city).
• PAN (Personal Area Network): Connects devices within a short range (e.g.,
Bluetooth devices).
• WLAN (Wireless Local Area Network): A LAN that uses wireless communication.
• Network Devices: Routers, Switches, Hubs, Modems, and Network Interface Cards
(NICs).

4. Introduction to HTML and Software

4.1 Introduction to HTML. Working of HTML
• HTML (Hypertext Markup Language): The standard markup language for creating web
pages and web applications.
• Markup Language: Uses tags to define elements within a document.
• Working of HTML: Web browsers read HTML documents and render them into visible or
audible web pages.
4.2 Creating and loading HTML pages, tags.
• Creating HTML Pages: Written in a text editor and saved with a .html or .htm
extension.
• Loading HTML Pages: Opened directly in a web browser or served by a web server.
• HTML Tags: Keywords enclosed in angle brackets ( <tag> ), used to structure content.
• Opening Tag: <p>
 • Closing Tag: </p>
• Content: The text or other elements between the tags.
• Empty Tags: (e.g., <br> , <img> ) Do not have closing tags.
4.3 Structure of an HTML Document, Stand Alone Tags.
• Basic HTML Structure:
• <!DOCTYPE html> : Declaration defines this document to be an HTML5 document.
• <html> : The root element of an HTML page.
• <head> : Contains meta-information about the HTML page (e.g., title, character set,
links to stylesheets).
• <title> : Specifies the title for the HTML page (shown in the browser's title bar or tab).
• <body> : Contains the visible page content.
• Stand Alone Tags (Self-closing tags): Tags that do not require a closing tag because
they don't enclose content.
• <br> : Line break.
• <img> : Image.
• <hr> : Horizontal rule.
• <input> : Input field.

4.4 Formatting text, Adding Images, Creating hyper Links, Tables.

• Formatting Text:
• Headings: <h1> to <h6> for different levels of headings.
• Paragraphs: <p> for blocks of text.
• Bold: <b> or <strong> .
 • Italic: <i> or <em> .
• Underline: <u> .
• Line Break: <br> .
• Adding Images: <img> tag with src (source) and alt (alternative text) attributes.
• Example: <img src="[Link]" alt="Description of image">
• Creating Hyperlinks: <a> (anchor) tag with href (hypertext reference) attribute.
• Example: <a href="[Link] Example</a>
• Tables: Used to display data in rows and columns.
• <table> : Defines a table.
• <tr> : Defines a table row.
• <th> : Defines a table header cell.
• <td> : Defines a table data cell.

4.5 Cyber security.

• Cybersecurity: The practice of protecting systems, networks, and programs from digital
attacks.
• Threats: Malware (viruses, worms, ransomware), phishing, denial-of-service (DoS)
attacks, data breaches.
• Basic Security Measures: Strong passwords, antivirus software, firewalls, regular
software updates, being cautious of suspicious emails/links.
4.6 Computer virus.
• Computer Virus: A type of malicious software program that, when executed, replicates
itself by modifying other computer programs and inserting its own code.
• How they spread: Through infected files, email attachments, malicious websites, or
removable media.
• Impact: Data corruption, system crashes, unauthorized access, identity theft.
• Prevention: Antivirus software, avoiding suspicious downloads, regular system scans.

5. Information Technology
5.1 Current IT Tools.
• Cloud Computing Platforms: (e.g., AWS, Azure, Google Cloud) For scalable computing
resources and services.
• Version Control Systems: (e.g., Git, GitHub, GitLab) For managing changes to source
code and collaborative development.
• Containerization: (e.g., Docker, Kubernetes) For packaging applications and their
dependencies into isolated environments.
• DevOps Tools: (e.g., Jenkins, Ansible) For automating software development and
deployment processes.
• Data Analytics Tools: (e.g., Python with Pandas/NumPy, R, Tableau) For processing,
analyzing, and visualizing large datasets.
5.2 Social networking, mobile computing, cloud computing.
• Social Networking: Online platforms that allow users to build social networks or social
relations with other users (e.g., Facebook, Twitter, LinkedIn).
• Mobile Computing: Human-computer interaction in which a computer is expected to
be transported during normal usage, which allows for transmission of data, voice, and
video (e.g., smartphones, tablets).
• Cloud Computing: Delivery of on-demand computing services—from applications to
storage and processing power—typically over the Internet with a pay-as-you-go pricing
model.
 • Types of Cloud Services: IaaS (Infrastructure as a Service), PaaS (Platform as a
Service), SaaS (Software as a Service).
• Deployment Models: Public cloud, Private cloud, Hybrid cloud.
5.3 Introduction of IOT and IOE
• IoT (Internet of Things): A network of physical objects—
things—embedded with sensors, software, and other technologies for the purpose of
connecting and exchanging data with other devices and systems over the Internet.
• IoE (Internet of Everything): A broader concept than IoT, encompassing people,
processes, data, and things. It aims to bring together all these elements to make
networked connections more relevant and valuable.
5.4 Computer Application in various fields like Data analysis, database
management, artificial intelligence.
• Data Analysis: Using computers to inspect, cleanse, transform, and model data with the
goal of discovering useful information, informing conclusions, and supporting decision-
making.
• Tools: Spreadsheets (Excel), statistical software (R, SPSS), programming languages
(Python with Pandas, NumPy).
• Database Management: The use of computer systems to store, organize, and retrieve
large amounts of data efficiently.
• Database Management Systems (DBMS): (e.g., MySQL, PostgreSQL, Oracle, SQL
Server) Software that allows users to define, create, maintain, and control access to
the database.
• Artificial Intelligence (AI): The simulation of human intelligence processes by
machines, especially computer systems. These processes include learning, reasoning,
and self-correction.
• Subfields: Machine Learning, Deep Learning, Natural Language Processing (NLP),
Computer Vision, Robotics.
6. List of Practical (Overview)
This section outlines practical exercises that reinforce the theoretical concepts, including:
• Operations on Operating System: Creating/managing folders, files, using basic
Windows features (Notepad, WordPad, Calculator), setting display properties, managing
taskbar, wallpaper, date/time.
• Basic and Advanced Operations on MS Word: Text formatting, bullets/numbering,
alignments, hyperlinks, inserting pictures/ClipArt, Word Art, borders/shading,
find/replace, headers/footers, mail merge, macros, importing/merging documents,
creating tables, resume creation.
• Basic and Advanced Operations on Electronic Spreadsheet/Excel: Calculating
divisions, generating bills (electricity, telephone), salary statements, mark sheets,
computing mean/median/mode, generating graphs/charts, creating charts from data,
auto sum/calculate, average, conditional formatting (pass/fail), headers/footers,
importing/exporting data, simple program development.
• PowerPoint Presentation Preparation: Creating presentations using blank
presentations, design templates, and Auto Content Wizard. Applying animations,
various effects, audio/video, color schemes, and slide shows.
• Simple Program in HTML: Creating webpages using basic HTML tags (background
color, font, bold/italic/underline, headings, marquee, lists), creating employee tables,
internal/external hyperlinks, frames, inserting images, designing homepages, web
pages for tourism, CVs, image animation, table handling.
• Basics of Internet, Surfing, Email Account Opening and Transactions: Connecting to
the Internet, saving webpages, searching for topics, downloading material, creating
email IDs, logging in, reading/composing/sending/forwarding/deleting emails, sending
attachments, surfing for information about colleges and tourism.
This comprehensive overview covers the essential topics typically found in a
diploma-level "Computer Essentials" or "Computer Fundamentals" curriculum, aligning
with the topics found in the provided syllabus.