KASNEB DICT study plan

Diagram the components of an ICT system (hardware, software, data, people, procedures, networks) and explain how each supports a named business process

Perform advanced word-processing operations - mail merge, styles, table of contents, section breaks - in a document of at least four pages

Build a spreadsheet using at least three lookup, three logical and three statistical functions, add a chart and a summary table

Create a 10-slide presentation with a master slide, speaker notes and transitions for a short business case

Classify 20 given software titles as system or application software and state the purpose of each

Draw and label the internal components of a desktop computer from memory and state the function and a typical specification for each

Compare magnetic, optical and solid-state storage and recommend one for three given scenarios with written justification

Sequence the steps for installing an operating system, partitioning a disk, and creating user accounts with permissions

Describe the preventive maintenance routine for a PC, printer and scanner, including cleaning and consumable checks

Diagnose five common hardware and operating-system faults by writing symptom, likely cause, diagnostic step and remedy

Map at least three protocols to each layer of the OSI and TCP/IP models and state one function per layer

Calculate network address, broadcast address, usable host range and host count for three given CIDR blocks

Design a 25-user office LAN specifying topology, cabling, switch, router and IP addressing plan

Explain with a diagram the request flow for DNS resolution, DHCP lease and an SMTP message delivery

Compare bus, star and mesh topologies and guided versus unguided media for cost, speed and reliability in three scenarios

Write flowcharts and pseudocode for five problems, at least two involving nested selection and iteration

Code five working programs that demonstrate variables, selection, iteration, arrays and user-defined functions

Trace the output of six given code segments and correct five deliberately seeded bugs

Compare waterfall, iterative and agile lifecycles and select one for a stated project with reasons

Explain compilation versus interpretation and describe unit, integration, system and acceptance testing

Derive a third-normal-form relational schema from a written business narrative and draw the resulting ER diagram

Write SQL data definition statements creating four tables with primary key, foreign key, NOT NULL and CHECK constraints

Write 12 SELECT statements using joins, GROUP BY with aggregates, and at least two subqueries

Explain ACID properties, transaction rollback and the purpose of backup and recovery procedures

Distinguish centralised, client-server and distributed database architectures with one advantage and drawback each

Plan a fact-finding exercise using interviews, questionnaires, observation and record review, and state when each technique is preferred

Draw a context diagram, level-0 and level-1 data flow diagrams, an entity relationship diagram and a use case diagram for one case study

Produce a feasibility study covering technical, economic, legal, operational and schedule feasibility with a recommendation

Compare parallel, direct, phased and pilot changeover strategies and select one for a stated risk profile

Describe the contents of a requirements specification and the purpose of a post-implementation review

Classify 15 given exposures as threats, vulnerabilities or controls and sort controls into physical, logical and administrative categories

Explain symmetric and asymmetric encryption, hashing, digital signatures, firewalls, intrusion detection and access control models with one use case each

Describe audit trails, segregation of duties, disaster recovery planning and computer-assisted audit techniques

Hand-code a responsive three-page website in valid HTML5 and CSS containing a table, an image, a form and an external stylesheet

Compare image, audio and video file formats and explain lossy versus lossless compression and the roles of domain name and web host

Explain professional codes of conduct and resolve five given ethical dilemmas in ICT with reasoned responses

Prepare an ICT project plan containing a work breakdown structure, schedule, budget and risk register

Compare waterfall, agile and PRINCE2-style project management approaches for an ICT project and justify a choice

Re-attempt every previously missed question across all nine domains and close each gap with a written note

Sit two full-length timed papers under exam conditions and analyse the score profile by domain