PlS021 Study Guide Midterm 2 Flashcards

Computer Networking

• Definition of a Computer Network

  • A group of two or more electronic devices connected to exchange information.

• Purpose of a Network

  • To allow the exchange of information and resource sharing.

• Types of Networks

  • PAN (Personal Area Network)

  • LAN (Local Area Network)

  • WAN (Wide Area Network)

  • Internet

• Function of a Router

  • An intelligent device that connects two or more networks and directs network traffic.

• IP Address

  • A unique identifier for a device on a network, used to access a router and transmit data.

• TCP and IP

  • Transmission Control Protocol (TCP) ensures reliable data transfer.

  • Internet Protocol (IP) provides logical addressing for devices.

Word Processing & Web Design

• Examples of Word Processing Software

  • Microsoft Word

  • Google Docs

  • LibreOffice Writer

  • Apple Pages

• HTML

  • Hypertext Markup Language; used to structure web pages.

• Main Parts of a URL

  • Protocol

  • Domain Name

  • File/Resource Path

• CMS (Content Management System)

  • A platform for creating and managing web content without coding.

Spreadsheets

• Common Spreadsheet Functions

  • SUM, AVERAGE, IF, VLOOKUP, HLOOKUP, and PERCENT.

• Pivot Table

  • A tool used to summarize and analyze large datasets in spreadsheets.

• Absolute vs Relative Cell References

  • Absolute References ($A$1) do not change when copied.

  • Relative References (A1) change when copied.

Photo and Video Editing

• Raster Graphics

  • Images made up of pixels, such as JPEG and PNG.

• Vector Graphics

  • Graphics based on mathematical formulas, such as SVG and AI files.

• Main Video Editing Software

  • Adobe Premiere Pro

  • Apple Final Cut Pro

  • iMovie

  • Camtasia

  • Shotcut

Software and Operating Systems

• Definition of Software

  • A set of instructions that tells a computer how to perform a task.

• Types of Software Licenses

  • Proprietary

  • Open Source

  • Freeware

  • Shareware

• Main Types of User Interfaces

  • Command Line Interface (CLI)

  • Graphical User Interface (GUI)

  • Natural Language Interface (NLI)

Computer Security

• Common Types of Cyberattacks

  • Phishing

  • Malware

  • Denial of Service (DoS)

  • SQL Injection

  • Ransomware.

• Social Engineering

  • Manipulating people to divulge confidential information.

• Firewall

  • A security system that monitors and controls incoming and outgoing network traffic.

Presentation Software

• The Six S's of Effective Slides

  • Story

  • Scope

  • Simplicity

  • Structure

  • Sequence

  • Speed.

• Common Presentation Software Solutions

  • Microsoft PowerPoint

  • Google Slides

  • Prezi

  • Canva

  • Keynote.

• Linear vs Non-linear Presentations

  • Linear presentations follow a fixed sequence.

  • Non-linear presentations allow flexible navigation.

Saving Instructions

1. Copy all the content above.

2. Open Microsoft Word or Google Docs.

3. Paste the content into a new document.

4. Save the file as PLS021_Flashcards.docx to have a fully formatted document.