CCAS Final Exam Review Guide - UIT & Microsoft Applications

Comprehensive vocabulary flashcards covering basic networking, cyber security, digital technology, data hierarchy, and Microsoft Office applications (Word, Excel, Access) as compiled for the CCAS Final Exam.

Strong Password Length

Requires a standard minimum length of $12$ to $16$ characters.

Password Complexity

Including a mixed combination of uppercase letters, lowercase letters, numbers, and symbols.

Logic Bomb

Malicious code intentionally hidden inside a software system that remains dormant until a specific condition or date triggers it.

Ransomware

Financial extraction malware that encrypts or steals files and demands a ransom payment in exchange for access.

Denial of Service (DoS)

A cyberattack aimed at shutting down or flooding a machine, network, or website to make it completely unavailable to its users.

Virus Vectors

Human-assisted methods through which a virus replicates and spreads, primarily opening phishing emails/attachments, downloading from untrusted sites, and inserting infected USB flash drives.

Biometrics

An advanced security authentication method using unique biological characteristics (fingerprints, facial geometry, iris scans) to verify identity.

Encryption

The computational safety process of scrambling readable plaintext data into an unreadable format called ciphertext.

Benevolent Hackers

Also known as white hat hackers; ethical security experts who use hacking skills for defensive good to patch bugs before malicious actors find them.

Network Benefits

Core organizational advantages consisting of hardware/resource sharing, simplified data collaboration, and centralized administrative management.

Bluetooth

A low-power, short-range wireless communication connection standard used to bridge consumer devices over short distances.

Digital vs. Analog

Analog translates information as continuous physical wave measurements, whereas digital converts data into highly precise, non-continuous binary code ($1$s and $0$s).

Hacktivists

Hackers driven by ideological, political, or social activist motives rather than pure financial profit.

Smartphone

A portable cellular device packed with integrated software applications and native internet connectivity.

Text Messaging (SMS)

Short message protocol limited to a maximum threshold of $160$ characters per transmission (including spaces).

Megapixels

A measurement equal to $1,000,000$ pixels, tracking the resolution capacity of a digital image sensor.

Video on Demand (VoD)

Technologies enabling viewers to instantly stream video or television programming directly from an enterprise server at their own convenience.

Podcasting

The syndicated recording, distribution, and downloading of episodic internet radio or digital audio files.

Aspect Ratio

The numeric, proportional relationship established between the layout width and the layout height of an image or monitor screen.

Mashup

A creative digital combination of elements pulled from alternative, unrelated web platforms to generate an entirely new interactive tool.

E-reader

A specialized, low-power handheld device designed explicitly to download, store, and display digital e-books.

Convergence

The historical technical blending of independent sectors—computing, telecoms, consumer electronics, and entertainment—into streamlined data devices.

Portability

The physical attribute or quality designating an electronic component as lightweight and easy to transport.

Tablet

A flat, mobile personal computer utilizing an interactive touchscreen interface.

Societal Effect of Digital TV

A shift in consumer behavior allowing viewers to watch programming entirely on-demand at their own convenience rather than relying on network scheduling.

Database

A deeply structured, systematically arranged digital safehouse of relevant, interconnected information tables.

Data vs. Information

Data encompasses raw, unorganized facts and figures, whereas information represents data that has been structured, sorted, and parsed into a meaningful, context-driven deliverable.

Good Information Traits

Core metrics indicating operational value: accuracy, timeliness, completeness, relevance, and cost-effectiveness.

Bit

The absolute smallest element in a database hierarchy, registering as a binary value of either $0$ or $1$.

Byte

A logical grouping of bits (usually $8$) assembled to represent a distinct character, alphanumeric letter, or numerical digit.

Field

A structural column within a data table cataloging a singular specialized attribute (e.g., Student Last Name).

Record

A full data row within a table grouping interconnected fields focused on a unique individual entity.

Table / File

A comprehensive administrative block containing a matrix layout of rows and columns detailing related data rows.

Data Storage Hierarchy Order

The correct progression sequence: Bit $\rightarrow$ Byte $\rightarrow$ Field $\rightarrow$ Record $\rightarrow$ Table $\rightarrow$ Database.

Turing Test

A milestone test engineered to assess whether a machine's output successfully mirrors indistinguishable, human-like intelligence.

CAPTCHA

An automated public security challenge to screen out automated network scraping bots from actual human end-users.

Horizontal Information Flow

The immediate, collaborative exchange of data passing between peer departments sitting on the identical layer of corporate authority.

Vertical Information Flow

The upward and downward routing of business tracking metrics across three structured corporate administrative management levels.

Strategic Management Level

The topmost executive layer of vertical data flow, analyzing long-range projection goals and strategic vision.

Tactical Management Level

The middle managerial layer of vertical data flow, handling short-term operational execution and procedural compliance control.

Operational Management Level

The baseline supervisor tier of vertical data flow, tracking daily work operations, hourly output, and routine tasks.

Data Mining

Sifting systematically through mass warehouse datasets to reveal hidden relational rules, trends, and market patterns.

DBMS Benefits

Software suites offering lowered structural duplicate storage, absolute integrity, advanced data security, and parallel cross-user data access.

Data Cleansing

The backend optimization process of scanning database tables to wipe out duplicate inputs, broken values, or corrupt information rows.

Primary Key

A field designated to uniquely and fully identify a specific row in a table (e.g., Student ID Number).

Database Administrator (DBA)

The IT technical professional in charge of configuring, updating, securing, and organizing company database ecosystems.

Metadata

Operational data properties commonly described as 'data about data,' explaining file sizing, type bounds, and structural data sources.

Quick Access Toolbar

A floating, customizable row of shortcut commands positioned away from the active ribbon tabs (e.g., Quick Save, Undo).

Ribbon Interface

The command panel extending across the application roof, structuring functional tool features into named tabs and groupings.

Default Word File Format

The default system file compression suffix used since 2010 versions, saving files as .docx.

Format Painter

An administrative button that allows a user to instantly replicate font styles, sizes, and layout configurations from a source text string to a target.

Clipboard Group Location

The specific group containing standard editing actions (Cut, Copy, Paste), located under the Home Tab.

Default Margins

The native page boundary perimeter, measuring a continuous $1.0$ inch across top, bottom, left, and right document borders.

Default Page Layout

Word's factory physical printing standard settings, configured for Letter size ($8.5 \times 11 \text{ inches}$) oriented in Portrait format.

Page Break

A structural formatting code forcing all trailing content down onto the start of the next blank page layout sheet.

Bullets Layout Location

The alignment list styling tool located within the Paragraph Group under the Home Tab, defaulting to a solid round black point.

Leaders

Rows of dotted, dashed, or solid linear symbols bridging left-justified header labels directly across to right-justified page references.

Document Theme

A unified group styling palette setting specific font pairing matches, accent colors, and geometric document accents.

Watermark

A faint, semi-transparent backdrop text string or image logo overlaid directly underneath the main body text layer (e.g., 'CONFIDENTIAL').

Proportional vs. Monospaced Fonts

Proportional fonts dynamically compress or expand character widths horizontally, whereas monospaced fonts assign the exact same horizontal block measurement to every character.

Serif vs. Sans Serif

Serif typefaces finish character strokes with tiny decorative feet (e.g., Times New Roman), whereas Sans Serif variations display clean, modern structural layouts (e.g., Arial).

Workbook vs. Worksheet

A workbook represents the entire saved application file, whereas a worksheet constitutes an individual workspace grid page layout accessed via bottom navigation.

Default Excel File Format

The native extension formatting used to record Excel file data, saving files as .xlsx.

Cell Address Name

The explicit geometric location code identifier matching an active cell, created by stacking its column letter onto its row number (e.g., $C4$).

Formula Bar

The interactive input strip tracking data directly above the grid sheets, showing hidden calculation steps or allowing live data alterations.

Range Block Selection

A specific geometric block clustering a group of two or more adjacent cells (e.g., $A1:B5$).

Formulas vs. Functions

Formulas are custom equations drafted manually starting with an equals prefix (e.g., $=A1+B1$), whereas functions are pre-compiled math calculations built into the engine (e.g., $=SUM(A1:B1)$).

Relative Reference

Cell identification values that adjust their position references dynamically when a calculation row is copied to alternative cell zones.

Absolute Reference

Locked cell identifiers that fix a reference row or column location in place using dollar sign notation (e.g., $\$A\$1$).

IF Function Architecture

A logical conditional processing tool analyzing exactly three distinct functional arguments: $=IF(logical\_test, value\_if\_true, value\_if\_false)$.

Show Formulas Command

An administrative auditing command toggled via $Ctrl + `$ that replaces cell calculation solutions with their raw mathematical formulas.

Financial PMT Function

A predefined macro evaluating periodic amortization payment criteria required to clear a constant-interest loan over regular terms.

Financial FV Function

A pre-programmed macro checking the compounded future valuation yield generated by regular investments over a fixed interest schedule.

Financial PV Function

A macro evaluating the current total net present value of incoming payment allocations due from an investment setup.

PEMDAS Order

The strict mathematical operational order: Parentheses, Exponents, Multiplication/Division, Addition/Subtraction.

Error Flag

A prompt alerting the user that the target column structure is currently too narrow to properly display a long number.

DIV/0! Error Flag

An algorithmic calculation error indicating that a cell equation is trying to divide a value by zero.

REF! Error Flag

A broken link error indicating that an equation points to a cell address that has been deleted or overwritten.

N/A Error Flag

An active data error indicating that critical reference information is entirely missing or unavailable to a calculation.

Default Access File Format

The native file extension used to save relational database files, designated as .accdb.

Four Core Access Objects

Layout structures required to control relational data: Tables (store data), Queries (extract data), Forms (entry interfaces), and Reports (summarize data).

Max Field Name Limit

The absolute database architectural constraint capping maximum column label designations at $64$ characters.

Design View Pane

The system configuration view interface used to map structural rules, properties, and data types—never used for manual data row entry.

Validation Rule vs. Validation Text

A validation rule sets a technical data bound (e.g., $<=100$), while validation text holds the custom error message that pops up if an entry breaks that rule.

Input Mask

An entry template setting formatting layouts to force precise data structuring during active user entry (e.g., automated brackets for phone records).

One-to-Many Relationship

A structure where a singular isolated data row inside Table A connects down to multiple corresponding child records in Table B.

Referential Integrity

System validation rules ensuring linked database data connections remain perfectly accurate, preventing orphaned rows or accidental erasure of parent records.

Update vs. Append Queries

Update queries alter cell entries inside existing rows, whereas append queries function to selectively migrate rows over to the bottom of another table.