CLEP Information Systems study plan

Map every objective in Domain 1 (word processing, spreadsheets, presentation graphics, database vs. spreadsheet use, collaboration tools) into a one-page checklist you can tick off

Demonstrate relative vs. absolute cell references by building a 12-row budget sheet with one copied formula column and one locked-reference column, then explain in writing why each behaves differently

Identify the five most common spreadsheet functions tested (SUM, AVERAGE, IF, COUNT, and lookup-style retrieval) and write a one-line plain-English definition plus a worked example for each

Compare word processing features (styles, mail merge, headers/footers, track changes) against presentation features (slide masters, transitions, speaker notes) in a two-column table

Classify input, output, processing, and storage devices into a four-quadrant chart with at least four examples per quadrant and one sentence on when each is preferred

Distinguish primary storage from secondary storage and volatile from non-volatile memory by writing a 10-item sorting exercise and answering it correctly

Explain the fetch-decode-execute cycle in your own words in under 120 words without looking at notes, then check against a reference and correct errors

Describe what an operating system does (process management, memory management, file systems, device drivers, user interface) with one concrete example per function

Convert between binary, decimal, and hexadecimal for at least 10 values by hand and verify each with a calculator

Label the parts of a URL (scheme, host, path, query string) and explain the roles of DNS, HTTP/HTTPS, and a web server in loading one page

Differentiate the major internet access and connection concepts (ISP, bandwidth, IP address, router vs. modem) in a glossary of at least 12 terms written in your own words

Compare the main web content models (static pages, dynamic server-rendered pages, client-side scripting) and state one trade-off for each

Demonstrate effective search technique by writing five queries that use operators or filters and recording what each returns

Identify common browser and web-application features (cookies, cache, bookmarks, plug-ins, forms) and state the purpose of each in a single sentence

Define confidentiality, integrity, and availability and give one realistic threat to each in a small-business context

Distinguish viruses, worms, Trojan horses, ransomware, spyware, and phishing by writing a one-line signature for each and matching 10 scenarios to the correct category

Explain authentication factors (something you know, have, are) and evaluate why multi-factor authentication reduces risk

Describe encryption at rest vs. in transit and identify where each applies in everyday tools such as banking sites and full-disk encryption

Outline an incident response sequence (detect, contain, eradicate, recover, review) and list one action per stage for a compromised laptop

Model a small business scenario as entities, attributes, and relationships, then draw the resulting entity-relationship diagram with cardinalities marked

Apply normalization up to third normal form to one badly designed table, showing the intermediate steps and stating what anomaly each step removes

Write and execute at least eight SQL statements covering SELECT with WHERE, ORDER BY, aggregate functions with GROUP BY, and a two-table join

Distinguish primary keys, foreign keys, and candidate keys using your own schema as the example for each

Compare flat files, relational databases, and a NoSQL-style document store on structure, query flexibility, and typical use case

Explain the difference between data and information and between a database management system and a database, with one workplace example each

Trace a simple algorithm (such as finding the largest value in a list) step by step and express it as pseudocode and as a flowchart

Identify the constructs of sequence, selection, and iteration in a short program and rewrite one loop as an equivalent conditional structure

Distinguish compiled from interpreted languages and describe what source code, an assembler/compiler, and an interpreter each do

Describe the stages of the software development life cycle and place one concrete activity and one deliverable in each stage

Analyze three ethical dilemmas (software piracy, workplace monitoring, and data reuse) using a stated decision framework rather than opinion alone

Explain the legal and ethical obligations around personal data privacy, including consent, purpose limitation, and the right to access or correct records

Evaluate the social effects of automation on employment and accessibility, giving both a benefit and a harm with supporting reasoning

Distinguish types of software licensing (proprietary, open source, freeware, site license) and state one permitted and one prohibited use for each

Describe professional codes of conduct in computing and apply one clause to a realistic workplace scenario

Diagnose weak areas by scoring at least 60 practice questions across all seven domains and recording accuracy per domain

Re-study only the two lowest-scoring domains, producing a corrected note for every missed question

Rehearse timed conditions by completing a 45-minute mixed-domain set without notes and logging pacing problems

Memorize the highest-yield distinctions (RAM vs. ROM, compiler vs. interpreter, primary vs. foreign key, virus vs. worm, HTTP vs. HTTPS) by writing them from memory and checking

Build a final one-page formula-and-terms sheet you can review in the 24 hours before the exam