Business Communication and Technology
What the domain tests
This domain covers the communication process, business writing, presentations, spreadsheets, databases, information systems, e-commerce, digital citizenship, and security. Questions ask you to choose an appropriate channel, formula, or security practice.
Core rules
- Communication includes sender, encoding, channel, receiver, decoding, feedback, and noise. Channel choice depends on richness, audience, urgency, and need for a record. Sensitive or complex messages usually call for richer, synchronous channels; routine confirmations can use lean channels.
- Business writing should be clear, concise, audience-centered, and organized. Use direct order for routine or good news and indirect order for bad news or persuasion.
- Spreadsheet formulas use relative references (A1) that change when copied and absolute references ($A$1) that do not. Functions include SUM, AVERAGE, IF, VLOOKUP, and COUNTIF. Charts should match the data relationship.
- Databases organize records and fields; a primary key uniquely identifies a record. Queries retrieve data; reports present it.
- E-commerce models include B2B, B2C, C2C, and B2G. Security controls include strong authentication, encryption, firewalls, updates, and backups. Phishing exploits human trust.
- Digital citizenship includes privacy, acceptable use, accessibility, and intellectual property.
Worked example
A student builds a price sheet in which column C holds a single tax rate. The formula in D2 is =B2*$C$1. When copied to D3, the relative B2 becomes B3, but $C$1 stays fixed, so every row multiplies by the same tax rate. If the formula used C1 without dollar signs, copying down would shift the tax reference to C2, C3, and so on, producing wrong results. The reasoning is that the dollar sign locks the row and column.
Traps
CC exposes recipients; BCC hides them. Absolute references are not always required-use them only for a fixed cell. A database is not a spreadsheet; primary keys prevent duplicate records. Encryption protects data in transit or at rest but does not stop phishing. A chart type should not be chosen for decoration.