| 1. |
Introduction to Computers |
| |
| (a) |
Computer hardware |
| |
Classification of computers – personal computer, workstation, servers and super computers
Computer components – CPU, input output devices, storage devices |
| (b) |
BUS, I/O CO processors, ports (serial, parallel, USB ports), expansion slots, add on cards, on board chips, LAN cards, multi media cards, cache memory, buffers, controllers and drivers |
| (c) |
Computer software |
| |
Systems software – operating system, translators (compilers, interpreters and assemblers), system utilities |
| |
General purpose software/ utilities - word processor, spread sheet, DBMS, scheduler / planner, internet browser and e-mail clients |
| |
Application software – financial accounting, payroll, inventory |
| |
Specialised systems – Enterprise Resource Planning (ERP), artificial intelligence, expert systems, decision support systems – an overview |
|
| 2. |
Data Storage, Retrievals and Data Base Management Systems |
| |
| (a) |
Data and information concepts: bits, bytes, KB, MB, GB, TB |
| (b) |
Data organization and access |
| |
Storage concepts : records, fields, grouped fields, special fields like date, integers, real, floating, fixed, double precision, logical, characters, strings, variable character fields (Memo); key, primary key, foreign key, secondary key, referential integrity, index fields. |
| |
Storage techniques: sequential, block sequential, random, indexed, sequential access, direct access, random access including randomizing |
| |
Logical structure and physical structure of files |
| (c) |
DBMS models and classification: |
| |
Need for database, administration, models, DML and DDL (query and reporting); data dictionaries, distributed data bases, object oriented databases, client server databases, knowledge databases |
| (d) |
Backup and recovery – backup policy, backup schedules, offsite backups, recycling of backups, frequent checking of recovery of backup |
| (e) |
Usage of system software like program library management systems and tape and disk management systems – features, functionalities, advantages |
| (f) |
Data mining and data warehousing - an overview |
|
| 3. |
Computer Networks & Network Security |
| |
| (a) |
Networking concepts – need and scope, benefits |
| |
Classification: LAN, MAN, WAN, VPN; peer-to-peer, client server |
| |
Components - NIC, router, switch, hub, repeater, bridge, gateway, modem |
| |
Network topologies – bus, star, ring, mesh, hybrid, architecture : token ring, ethernet |
| |
transmission technologies and protocols – OSI, TCP/IP, ISDN etc. |
| |
Network operating system |
| (b) |
Local Area Networks – components of a LAN, advantages of LAN |
| (c) |
Client server technology |
| |
Limitation of single user systems and need for client server technology |
| |
Servers – database, application, print servers, transaction servers, internet servers, mail servers, chat servers, IDS |
| |
Introduction to 3-tier and “n” tier architecture (COM, COM+) |
| (d) |
Data centres: features and functions, primary delivery centre and disaster recovery site |
| (e) |
Network security need; threats and vulnerabilities; security levels; techniques |
|
| 4. |
Internet and other technologies |
| |
| (a) |
Internet and world-wide web, intranets, extranets, applications of internet, internet protocols |
| (b) |
E-commerce - nature, types (B2B, B2C, C2C), supply chain management, CRM, Electronic Data Interchange (EDI), Electronic Fund Transfers (EFT), payment portal, e-commerce security; |
| (c) |
Mobile commerce, bluetooth and Wi-Fi |
|
| 5. |
Flowcharts, Decision Tables. |