Computer Awareness and Accounting Software
Computer Awareness and Accounting Software tests everyday digital competence: basic hardware and memory terms, spreadsheet formulas, and the voucher discipline required by Tally-type accounting packages.
Concepts
- RAM is volatile working memory; ROM is permanent. 1 KB = 1024 bytes.
- The operating system manages hardware and files (Windows, Linux); application software performs the accounting.
- Spreadsheet references: relative A1 shifts when copied; absolute $A$1 does not.
- Common functions: =SUM(B2:B10), =IF(B2>=500,"Pass","Fail"), =VLOOKUP(A2,$F$2:$G$10,2,FALSE) - lookup value in the first column, return column 2, exact match.
- Accounting software sequence: create the company, then ledgers, then vouchers. A voucher cannot use a ledger that does not exist, and a ledger with transactions cannot simply be deleted.
- Security basics: daily backups, unique user IDs, passwords never shared, and suspicion of phishing mails that imitate genuine senders.
Worked example
Cell A2 holds basic pay ₹18,000 and B2 holds =IF(A2>=15000,A2*0.1,0), which returns ₹1,800. Copy the formula to row 3 and A2 becomes A3, because the reference is relative. To make every row read a rate stored in E1, write $E$1 so the reference is locked.
Traps that cost marks
- Numbers stored as text, which SUM silently ignores.
- Altering or deleting a ledger after vouchers are posted, instead of passing a rectification voucher.
- Confusing RAM with storage, and never testing whether a backup can actually be restored.