Information Technology and Business Communication
Information Technology and Business Communication tests digital literacy and the ability to communicate professionally in written and oral formats. Expect items on hardware and software, networks, databases, spreadsheets, e-commerce, security, and the communication process.
Information systems
Hardware includes input, processing, storage, and output devices; software splits into operating systems and applications. Networks range from LANs to WANs and the internet; cloud computing delivers software, platforms, or infrastructure as a service. Relational databases store data in tables linked by keys, with a primary key uniquely identifying each record and a foreign key referencing another table. E-commerce models include B2B, B2C, C2C, and B2G.
Security and ethics
Threats include malware, phishing, ransomware, and social engineering. Controls include strong authentication, multi-factor authentication, encryption, firewalls, patching, and backups. Privacy obligations require collecting only necessary data and protecting it; acceptable-use policies define employee conduct.
Spreadsheets
Relative references (B5) shift when copied; absolute references ($B$5) stay fixed; mixed references lock one part (B$5 or $B5). Functions such as SUM, AVERAGE, IF, VLOOKUP, and COUNTIF automate analysis.
Communication
The process runs sender to encoding to channel to decoding to receiver, with feedback and noise affecting fidelity. Choose channels by richness: face-to-face for complex or sensitive messages, email for routine documentation. Choose a structure that makes the important information clear and timely. Bad news may need tact and context, but urgent facts, responsibilities and next steps should not be hidden. Business writing should be clear, concise, complete, and courteous.
Worked example
Cell D5 contains =B5*$B$1, where B1 holds a tax rate. Copied to D6, the formula becomes =B6*$B$1: the row-relative B5 updates to B6, while the absolute $B$1 stays fixed so every row multiplies by the same rate. Had the formula used B1, copying to D6 would produce B6*B2 and break the calculation.
Traps that cost marks
Do not treat a wiki or blog as a rich synchronous channel. Avoid assuming email is private or that deleting a file removes it from backups. On security items, phishing uses fraudulent messages to harvest credentials, while malware is malicious software - keep the categories distinct.