CSS Prepare

optional · CSS study notes

🗄️ OLD — Office & Productivity Tools, Internet (consolidated)

⚠️ SUPERSEDED: This page's content has been split into individual topic pages matching the exact textbook outline. See the main P-I.I. Introduction to Computing index for the current granular pages. Keeping this only for reference.

CSS Computer Science (Optional) — Paper-I, Section-A, Topic I (Introduction to Computing). Covers: Working With Computer Documents, Usage of Word Processors, Spread Sheets, Power Point, Electronic Mail, Search Engines, Web Browsers, Messengers, Internet.

Working With Computer Documents

A computer document is any file created and saved by an application (a text document, spreadsheet, presentation, image, etc.). Key concepts:

  • File formats: determine how data is structured and which applications can open it (e.g., .docx for Word, .xlsx for Excel, .pdf for portable documents)
  • Creating, saving, and versioning: documents are created in an application, saved to storage (local or cloud) under a filename/extension, and can have multiple saved versions
  • File management: organizing documents into folders/directories, naming conventions, and backup practices are part of good digital document hygiene

Usage of Word Processors

A word processor is application software used to create, edit, format, and print text-based documents (e.g., Microsoft Word, Google Docs).

Key features:

  • Text formatting: font, size, bold/italic/underline, alignment, paragraph spacing
  • Page layout: margins, headers/footers, page numbering, columns
  • Templates: pre-designed document layouts (resumes, letters) to speed up creation
  • Spell check & grammar check: automated proofreading tools
  • Mail merge: combines a template document with a data source (e.g., a spreadsheet of names/addresses) to generate personalized copies — commonly used for bulk letters/invitations
  • Tables and images: insertion of tabular data and graphics within text documents
  • Track changes / comments: collaborative editing features that record edits and allow reviewer feedback

Spread Sheets

A spreadsheet is application software organized into a grid of rows and columns (cells), used for numerical data, calculations, and analysis (e.g., Microsoft Excel, Google Sheets).

Key concepts:

  • Cell: the intersection of a row and column, referenced like A1, B2 — holds a value, text, or formula
  • Formulas: user-written expressions that calculate values from other cells (e.g., =A1+B1)
  • Functions: built-in predefined formulas for common operations (SUM(), AVERAGE(), IF(), VLOOKUP())
  • Charts/Graphs: visual representation of spreadsheet data (bar, line, pie charts)
  • Sorting & Filtering: reorganizing or narrowing displayed data based on criteria
  • Absolute vs Relative referencing: a relative reference (A1) shifts when copied to another cell; an absolute reference ($A$1) stays fixed — a common practical exam distinction

Power Point

Presentation software (e.g., Microsoft PowerPoint, Google Slides) is used to create a sequence of visual "slides" to support an oral presentation.

Key features:

  • Slides: individual pages of a presentation, each holding text, images, charts, etc.
  • Slide Master: a template layout that controls the consistent design (fonts, colors, logo placement) applied across all slides
  • Transitions: visual effects when moving from one slide to the next
  • Animations: visual effects applied to elements within a single slide (e.g., text appearing on click)
  • Speaker notes: private notes visible only to the presenter, not the audience
  • Slide Sorter view: an overview mode showing thumbnails of all slides for easy reordering

Electronic Mail (E-Mail)

Email is a method of exchanging digital messages over a network.

Key concepts:

  • Email address structure: username@domain (e.g., name@example.com)
  • Core protocols:
    • SMTP (Simple Mail Transfer Protocol): used to send email from client to server, and between mail servers
    • POP3 (Post Office Protocol v3): downloads email from the server to a single device, typically removing it from the server
    • IMAP (Internet Message Access Protocol): synchronizes email across multiple devices by keeping messages on the server
  • Message structure: To, CC (Carbon Copy — visible to all recipients), BCC (Blind Carbon Copy — hidden from other recipients), Subject, Body, Attachments
  • Spam/Phishing: unsolicited or fraudulent email, a major security concern covered further under Computer Crimes

Search Engines

A search engine is a software system designed to search the World Wide Web and return relevant results (e.g., Google, Bing).

How they work (three-stage process):

  1. Crawling: automated bots ("crawlers"/"spiders") systematically browse the web, following links to discover pages
  2. Indexing: the content of discovered pages is analyzed and stored in a massive searchable index/database
  3. Ranking: when a user submits a query, the search engine retrieves matching pages from its index and orders ("ranks") them by relevance, using algorithms that weigh factors like keyword match, page authority, and freshness

Web Browsers

A web browser is application software used to access, retrieve, and display content on the World Wide Web (e.g., Google Chrome, Mozilla Firefox, Safari).

Key concepts:

  • Browsers communicate with web servers using HTTP/HTTPS (HyperText Transfer Protocol / Secure)
  • They render HTML, CSS, and JavaScript into the visual page a user sees
  • HTTPS adds encryption (via TLS/SSL) to protect data exchanged between browser and server — an important distinction from plain HTTP for security-related exam questions

Messengers

Instant messaging (IM) applications allow real-time text, voice, or video communication over the Internet (e.g., WhatsApp, Skype, Microsoft Teams). Distinguished from email by their real-time, conversational nature rather than asynchronous message delivery.

Internet

The Internet is a global system of interconnected computer networks that communicate using a standardized set of protocols, primarily TCP/IP (Transmission Control Protocol/Internet Protocol).

Key concepts:

  • Internet vs World Wide Web: the Internet is the underlying global network infrastructure; the World Wide Web (WWW) is one service that runs on the Internet — a system of interlinked hypertext documents accessed via browsers. Email, file transfer (FTP), and other services also run on the Internet but are not the Web itself — a frequently tested distinction.
  • ISP (Internet Service Provider): a company that provides individuals/organizations access to the Internet
  • IP Address: a unique numerical identifier assigned to each device on a network (IPv4: e.g., 192.168.1.1; IPv6: a longer format designed to solve IPv4 address exhaustion)
  • Domain Name System (DNS): translates human-readable domain names (e.g., google.com) into numerical IP addresses that computers use to locate each other

MCQ Traps

  • The Internet and the World Wide Web are not the same thing — the Internet is the network; the Web is a service that runs on it. This is one of the most commonly tested distinctions in this topic.
  • POP3 downloads and typically removes mail from the server; IMAP keeps mail synced across devices — a frequently reversed-answer trap.
  • An absolute cell reference ($A$1) does not change when copied to another cell; a relative reference (A1) does.
  • Transitions apply between slides; animations apply to elements within a slide — don't swap these terms.
  • HTTPS, not HTTP, provides encryption via TLS/SSL for secure data transfer.

Self-Test Questions

  1. Differentiate the Internet from the World Wide Web.
  2. Name the three core email protocols and briefly state what each does.
  3. What is the difference between a relative and an absolute cell reference in a spreadsheet?
  4. Describe the three-stage process by which a search engine returns results.
  5. What is the role of DNS in accessing a website by name?
  6. Differentiate a slide transition from a slide animation.