NEB 12 Computer Science study plan

Define and classify the core building blocks of a computer system (CPU, memory, storage, I/O) and explain how each contributes to program execution

Convert between binary, decimal, octal, and hexadecimal by hand and verify each conversion with a second method

Perform binary addition and subtraction, including two's complement representation of negative integers

Explain how characters, integers, and floating-point values are represented and stored in memory

Trace the fetch-decode-execute cycle for a short instruction sequence and identify the role of the program counter, instruction register, and accumulator

Differentiate primary and secondary memory and justify a storage choice for a stated scenario

Describe the purpose of an operating system and distinguish multitasking, multiprocessing, and time-sharing

Identify common input, output, and storage devices and state one trade-off for each

Write, compile mentally, and trace short programs that use variables, arithmetic operators, and type casting

Construct and evaluate Boolean expressions using AND, OR, and NOT, including truth tables

Trace nested selection structures and predict output for given inputs

Identify and correct common syntax and logic errors in short code fragments

Trace definite and indefinite loops and compute iteration counts and final variable values

Convert a loop-based solution between for, while, and do-while forms

Decompose a problem into functions with parameters and return values, and trace parameter passing

Explain the difference between local and global scope with a concrete example

Declare and traverse one-dimensional and two-dimensional arrays and compute sums, maxima, and searches by hand

Perform linear and binary search on sample data and count comparisons for each

Trace a simple sorting algorithm step by step and state its effect on the data after each pass

Match a problem statement to an appropriate data structure and justify the choice

Explain the relational model and identify primary keys, foreign keys, and candidate keys in given schemas

Write SQL statements for selection, projection, filtering, and simple joins

Normalize a small unnormalized table to third normal form and justify each step

Distinguish DBMS, RDBMS, and file-based storage with one advantage of each

Describe the layers of a network and the function of common protocols (HTTP, TCP/IP, DNS, SMTP)

Distinguish LAN, WAN, and the client-server versus peer-to-peer models with examples

Explain the difference between the internet and the World Wide Web and outline how a URL resolves to a page

Identify common security threats and at least three countermeasures, including encryption and authentication

Assemble a consolidated formula and definition sheet spanning all eight weeks

Complete a full-length timed mock exam under exam conditions and self-mark it

Categorize every missed question by topic and re-solve each one without notes

State your three weakest subtopics and the specific corrective action for each