Computer Studies 7010 in the Senior Secondary ECZ curriculum covers algorithm design, pseudocode, flowcharting symbols, database architecture, and software development methodologies. Master these core theoretical and practical skills for Paper 1 and Paper 2 exams.
Pseudocode Exam Rule:
In ECZ Computer Studies, pseudocode algorithms must use uppercase keywords (e.g., INPUT, OUTPUT, IF...THEN...ELSE, WHILE...DO) and proper indentation!
1. Flowcharts & Pseudocode Algorithm Design
Candidates must trace and write algorithms for common mathematical procedures (e.g., finding the average of numbers, calculating tax, or identifying maximum values).
Standard Flowchart Symbols:
- Oval (Terminator): Indicates Start or Stop.
- Parallelogram (Input/Output):
INPUT scoreorPRINT "Passed". - Rectangle (Process): Arithmetic operations or variable assignment (e.g.,
total = sum + 5). - Diamond (Decision): Conditional checks (e.g.,
mark >= 50?) with YES/NO branches.
| Pseudocode Construct | Standard ECZ Syntax Example | Execution Logic |
|---|---|---|
| Selection (IF) | IF mark >= 50 THEN |
Executes the THEN branch if true; otherwise executes ELSE branch. |
| Count Loop (FOR) | FOR i = 1 TO 10 DO |
Repeats loop body exactly 10 times with counter variable i. |
| Condition Loop (WHILE) | WHILE count < 5 DO |
Evaluates condition before each iteration. Loop stops when condition becomes FALSE. |
2. Relational Database Concepts & SQL Queries
ECZ Paper 2 practical and Paper 1 theory examine relational database design:
- Fields & Records: Fields are vertical table columns (data attributes); Records are horizontal rows (single entity data).
- Primary Key vs Foreign Key: Primary key uniquely identifies a record (e.g.,
Student_ID). Foreign key links to a primary key in another table to establish 1-to-many relationships. - Basic SQL Query Syntax:
SELECT Student_Name, Exam_Mark FROM Students_Table WHERE Exam_Mark >= 50 ORDER BY Exam_Mark DESC;
Teacher Lab Strategy:
Have candidates build relational database tables in Microsoft Access during lab sessions, defining data types (Text, Number, Date/Time, Currency) and running criteria queries.
Parent Support:
Encourage your child's interest in ICT. Digital literacy and database management are high-demand career skills across banking, healthcare, and software development in Zambia.
Offline Pseudocode Practice:
Practice hand-writing 5 pseudocode algorithms on paper weekly. Check your logic by dry-running trace tables with sample numerical inputs.