# SS 2 Digital Technology - First Term Sparklabs Learning / Creative Brains Academy Academic session 2026 / 2027 Weeks: 12 --- ## Week 1: Review and Computer Architecture Date: Monday 7 September 2026 to Friday 11 September 2026 Subtopic: Review of Computer System and IPO Model; Computer Architecture and the CPU; The System Bus and the Fetch-Execute Cycle ### Lesson objectives By the end of the week, learners should be able to: 1. Recall the SS1 computer definitions without notes. 2. Classify computers by processor size, memory and storage using performance criteria. 3. Compare desktops, laptops, tablets and smartphones on stated criteria. 4. State why servers buy more expensive hardware than general-purpose computers. 5. Judge whether a given example belongs to workstation, server or mobile category. ### Key vocabulary - **Review**: bringing previously taught material back to active memory. - **Classification**: grouping devices by shared attributes. - **Performance criteria**: measurable attributes such as speed, memory and storage. - **Desktop**: a fixed-purpose computer housed in a case. - **Laptop**: a portable computer using a built-in display and battery. - **Tablet**: a touchscreen computing device aimed at light tasks. - **Smartphone**: a mobile phone with computing features. - **Server**: a computer that serves resources to other machines on a network. ### Common misconceptions - *"All computers are the same shape."* Shape matches purpose; desktop and laptop serve different environments. - *"Tablets and laptops are the same thing."* Tablets target lightweight use; laptops target heavier workloads. - *"Review means rereading."* Review means testing and reapplying, not passively reading notes. ### Teacher activities 1. Starter: show the twelve SS1 First-Term week titles and ask pairs to recall one definition each without notes. 2. Share the recalled definitions and check the ones missed for reteaching. 3. Introduce the performance criteria table and fill desktop, laptop and tablet rows collaboratively. 4. Compare smartphones and tablets on the same criteria with a Venn diagram. 5. Explain servers as resource providers and show one server form in a laboratory. 6. Close with the classification task and exit question about the server decision. ### Student activities 1. Recall one SS1 definition per week without notes and note any missed definitions. 2. Fill the performance criteria table for three device types. 3. Place smartphones and tablets in the Venn diagram using two criteria. 4. State two reasons businesses buy servers with brief explanations. 5. Decide whether a given example is a workstation, server or mobile device with a reason. 6. Answer the exit question in one sentence about the server purchase decision. ### Practical / learning evidence A completed performance criteria comparison table, a Venn diagram comparing smartphone and tablet, and a classification worksheet deciding workstation, server or mobile with reasons. Hand in all three. ### Resources and preparation Printed criteria table, blank Venn diagram and a server photograph. Offline route: paper table and diagram, no device needed. Display any photograph carefully and ensure it does not distract learners from the task. ### Assessment for learning Inspect the criteria table for at least four distinct criteria filled correctly. Check the Venn diagram placement matches the chosen criteria. Mark the classification worksheet for correct workstation, server or mobile choice with a defensible reason. ### Inclusion and homework Provide the criteria table prefilled in the first two rows for learners who need scaffolding and allow oral reasoning. Extend confident learners by adding a fourth device type and rating it on every criterion. Homework: name three devices at home and classify each as desktop, laptop, tablet, smartphone or server. --- ## Week 2: Main Memory Date: Monday 14 September 2026 to Friday 18 September 2026 Subtopic: RAM and ROM; Cache Memory and the Memory Hierarchy; How the CPU Uses Main Memory ### Lesson objectives By the end of the week, learners should be able to: 1. Define primary memory and secondary memory in their own words. 2. Name three types of RAM and state volatility for each. 3. Explain caching as temporary faster access to frequently used data. 4. Compare SRAM and DRAM on speed and cost. 5. Map a program execution path onto main memory stages. ### Key vocabulary - **Memory**: working space holding programs and data currently in use. - **Main memory**: memory inside the CPU accessible directly. - **Secondary memory**: storage kept off the CPU bus. - **Volatile**: loses contents when power is removed. - **SRAM**: static RAM holding data without refresh cycles. - **DRAM**: dynamic RAM requiring regular refreshes. - **Cache**: very fast temporary storage nearby the CPU. - **Refresh cycle**: repeated reads keeping DRAM data current. - **Execution path**: the sequence of memory locations accessed during a run. ### Common misconceptions - *"RAM holds my files permanently."* RAM holds work in progress and clears at shutdown. - *"Cache stores permanent data."* Cache is temporary and cleared once the data moves elsewhere. - *"SRAM and DRAM do the same things."* SRAM is faster but more expensive than DRAM. ### Teacher activities 1. Starter: ask where your running spreadsheet data sits temporarily while you use it. 2. Define main and secondary memory with one example each. 3. Name three types of RAM and note their volatility. 4. Explain caching as faster access for frequently used data. 5. Compare SRAM and DRAM on speed and cost with a simple analogy. 6. Map a simple program execution onto main memory stages. ### Student activities 1. Answer the starter and identify main versus secondary memory. 2. Define main and secondary memory in their own words. 3. Name three types of RAM and state volatility for each in one sentence. 4. Explain caching in one paragraph tied to frequent access. 5. Compare SRAM and DRAM on speed and cost with brief reasoning. 6. Map a program execution onto main memory stages showing data movement. ### Practical / learning evidence A three-RAM type chart with volatility and a SRAM versus DRAM comparison, plus a one-page caching explanation. Hand in both for marking. ### Resources and preparation Printed charts, blank diagrams and sample program execution traces. Offline route: paper versions, no device needed. Display any hardware carefully and keep tools out of reach. ### Assessment for learning Inspect the three-RAM chart for correct volatile states. Mark the SRAM versus DRAM comparison for correct tradeoffs. Check the caching explanation for a sensible analogy. Flag any learner who says cache stores files permanently. ### Inclusion and homework Provide the three-RAM chart prefilled for learners who need scaffolding and allow oral comparison. Extend confident learners with five RAM types and a four-stage execution map. Homework: name two places in your school lab that use cache and state why they need it. --- ## Week 3: Secondary Storage Date: Monday 21 September 2026 to Friday 25 September 2026 Subtopic: Magnetic and Optical Storage; Solid-State Storage and Device Comparison; Cloud Storage and Capacity or Performance; Secondary Storage Working Mechanisms; Storage Media Characteristics; File Organisation and Access Methods ### Lesson objectives By the end of the week, learners should be able to: 1. Define secondary storage and distinguish it from main memory. 2. Name four magnetic, optical and solid-state technologies. 3. Convert between bytes, kilobytes, megabytes, gigabytes and terabytes. 4. Compare storage technologies on capacity, speed, portability and cost. 5. Describe backup strategy using external drives and cloud copies. ### Key vocabulary - **Secondary storage**: long-term holding of files when the power is off. - **Capacity**: the amount of data a device holds. - **Speed**: how quickly data can be accessed. - **Portability**: how easily a device moves between locations. - **Cost**: the purchase and maintenance price. - **Magnetic storage**: stores data magnetically, such as a hard drive. - **Optical storage**: read by a laser, such as a CD or DVD. - **Solid-state storage**: flash memory with no moving parts. - **Backup**: a redundant copy stored separately. ### Common misconceptions - *"Secondary storage is always faster than RAM."* SSDs and HDDs sit outside the CPU bus. - *"More storage is always better."* Too much storage wastes money and management effort. - *"Cloud is a replacement for backups."* Cloud provides redundancy but still needs local copies too. ### Teacher activities 1. Starter: ask where a saved file sits when you turn off the lab computer. 2. Define secondary storage and contrast it with main memory. 3. Build the unit ladder bit byte KB MB GB TB and work two conversions. 4. Pass around an HDD, a CD, a flash drive and a memory card. 5. Compare capacities by converting and asking how many CDs equal one DVD. 6. Introduce backups as separate copies stored elsewhere. ### Student activities 1. Answer the starter and identify where saved files sit. 2. Define secondary storage in their own words and contrast with main memory. 3. Complete five unit conversions showing the working. 4. Identify each device passed round and write its storage technology. 5. Solve two capacity conversion problems with the method shown. 6. Describe a backup strategy using both external and cloud copies. ### Practical / learning evidence A conversion ladder worksheet with at least five worked conversions, a four-technology comparison chart and a backup strategy paragraph. Submit both for marking. ### Resources and preparation An HDD, a CD or DVD, a flash drive and a memory card. Calculators for conversion work. Printed conversion worksheets. Offline route: physical media and worksheets. Warn learners not to insert unknown flash drives into laboratory machines. ### Assessment for learning Mark the working, not just the final answer, since a wrong answer from wrong work fails later questions. Check the comparison chart for four distinct technologies compared across all four criteria. Ask two learners to explain their capacity method aloud before collection. ### Inclusion and homework Provide a printed conversion ladder as a reference and reduce the worksheet to three items where time is short. Extend confident learners with a comparison of SSD and HDD for speed. Homework: find the storage capacity of any phone, memory card or computer you can access in gigabytes. --- ## Week 4: Operating Systems, Licensing and Applications Date: Monday 28 September 2026 to Friday 2 October 2026 Topic: Operating Systems, Software Licensing and Applications Subtopic: Types of Operating Systems; Common Operating Systems; Functions of an Operating System; Advanced Operating System Engineering; Resource Allocation, CPU Scheduling and Interrupt Handling; Comparing Modern Operating Systems; Software Licensing; Software Categories; Practical Application Scenarios; Impact of Choosing the Wrong Licence; Productivity Suites; Word Processing Formatting; Desktop Publishing Software and Design Principles ### Lesson objectives By the end of the week, learners should be able to: 1. Restate the operating-system functions developed this term. 2. Explain software licensing types such as freeware, shareware and open source. 3. Name at least three licence types and give one example of each. 4. Compare freeware and paid software on cost, update and support. 5. Judge which licence type suits a school teaching environment. ### Key vocabulary - **Licence**: permission terms governing how software may be used. - **Freeware**: free to use with restricted commercial rights. - **Shareware**: trial software nagging users before payment. - **Open source**: source code visible and modifiable by users. - **Paid software**: commercial software requiring a licence fee. - **Update**: a newer release fixing bugs and adding features. - **Support**: help services provided by the publisher. - **Restricted commercial rights**: limitations on selling or reselling. - **Suit**: choosing a licence for a specific context. ### Common misconceptions - *"Freeware is always safer than commercial software."* Freeware often has weaker updates and support. - *"Open source costs nothing forever."* Open source still requires administration and patching effort. - *"Schools must always pay for licensed software."* Schools may use free alternatives to suit budgets. ### Teacher activities 1. Starter: hold up two licences, one freeware and one paid, and ask which your school prefers. 2. Restate the operating-system functions from prior terms. 3. Name at least three licence types and give one example each. 4. Compare freeware and paid software on cost, updates and support. 5. Explain why schools consider licence type alongside budget. 6. Close with the licence-choice task and exit question. ### Student activities 1. Pick the preferred licence from the starter and explain the reason. 2. Restate five operating-system functions in their own words. 3. Name at least three licence types and give one example each. 4. Compare freeware and paid software on three criteria. 5. Explain why licence type matters for school budgeting. 6. Choose which licence suits your school classroom and justify it. ### Practical / learning evidence A five-licence function sheet, a freeware versus paid comparison table and a school-choice justification paragraph. Submit all three for marking. ### Resources and preparation Printed licence cards and blank comparison tables. Offline route: paper cards and tables, no device needed. Provide accurate commercial licence terms and avoid recommending unsupported software packages. ### Assessment for learning Inspect the licence sheet for at least three distinct types with examples. Mark the freeware versus paid comparison for equal criteria. Check the school choice for a defensible budget rationale. Flag any learner who dismisses paid software advantages. ### Inclusion and homework Provide the licence cards prelabelled for learners who need scaffolding and allow oral comparison. Extend confident learners with five licence types and a sixth comparison. Homework: name one real school software that is open source and one that is commercial. --- ## Week 5: Number Systems and Data Representation Date: Monday 5 October 2026 to Friday 9 October 2026 Subtopic: Understanding Number Systems; Binary Number System; Converting Decimal to Binary; Octal Number System; Hexadecimal Number System; ASCII and Character Codes; Unicode; Representing Images; Representing Sound; Representing Video; Measuring File Sizes; Practical Exercises; How Computers Represent Data; Number Conversions with Worked Examples; Representing Characters, Images, Pixels and Colour Depth ### Lesson objectives By the end of the week, learners should be able to: 1. Convert decimal numbers to binary, octal and hexadecimal. 2. Convert binary back to decimal and vice versa. 3. Explain why binary is the natural language of digital electronics. 4. Represent characters, images and audio in binary forms. 5. Compute the bit pattern for a given letter, image pixel and audio sample. ### Key vocabulary - **Decimal**: base ten number system using digits 0 through 9. - **Binary**: base two using only digits 0 and 1. - **Octal**: base eight using digits 0 through 7. - **Hexadecimal**: base sixteen using digits 0 through 9 and letters A through F. - **Bit**: one binary digit, the smallest unit of data. - **Byte**: eight bits, the basic storage unit. - **Natural language**: the native form a system uses internally. - **Character encoding**: mapping letters to binary values. - **Pixel**: one tiny picture element in an image. - **Sample**: a discrete value taken from an audio stream. ### Common misconceptions - *"Binary is hard to read."* Binary is compact and fast once learned; humans add grouping aids. - *"Decimal converts directly to binary without grouping."* Decimal must be grouped by powers of two for conversion. - *"Hexadecimal adds new symbols randomly."* Hexadecimal maps cleanly onto four bits each. ### Teacher activities 1. Starter: ask which base suits electronic switches best and why. 2. Walk through converting decimal ten to binary step by step. 3. Show grouping decimal and binary with powers of two. 4. Demonstrate converting decimal fifteen to octal and hexadecimal. 5. Explain why binary is the natural language of electronics. 6. Close with the conversion task and exit question. ### Student activities 1. Answer the starter and explain why binary suits electronic switches. 2. Convert decimal ten to binary with the grouping method shown. 3. Convert binary back to decimal and group the result. 4. Convert decimal fifteen to octal and hexadecimal. 5. Explain why binary is the natural language of digital electronics in one paragraph. 6. Answer the exit question in one sentence about base choice. ### Practical / learning evidence At least five worked conversions covering decimal, binary, octal and hexadecimal, plus a bit-pattern worksheet for a letter, a pixel and an audio sample. Submit both for marking. ### Resources and preparation Printed conversion worksheets and bit-pattern templates. Offline route: paper worksheets, no device needed. Provide large printed templates for learners with low vision. Verify conversion accuracy against the official method before distributing. ### Assessment for learning Mark the working, not just the final answer. Check that each conversion shows grouping or division. Inspect the bit-pattern worksheet for a sensible mapping of each input to binary. Flag any learner who skips grouping and guesses results. ### Inclusion and homework Provide the conversion ladder prefilled for the first step and allow oral completion of the rest. Reduce the bit-pattern worksheet to two items. Extend confident learners with base conversions to base three and base five, and a seventh bit-pattern challenge. Homework: convert one decimal number to binary and verify your grouping answer by grouping. --- ## Week 6: Logic Gates and Digital Logic Date: Monday 12 October 2026 to Friday 16 October 2026 Subtopic: What is a Logic Gate?; The AND Gate; The OR Gate; The NOT Gate; The NAND and NOR Gates; The XOR and XNOR Gates; Boolean Algebra; De Morgan's Laws; The Half Adder; The Full Adder; Applications of Logic Gates; Practical Exercises; Digital Logic and Binary Signals; Gate Functions and Truth Tables at a Glance; Combining Gates to Build Simple Circuits; Real-World Applications of Logic Circuits ### Lesson objectives By the end of the week, learners should be able to: 1. Define AND, OR and NOT gates and state the operation of each. 2. Complete truth tables for each gate and each compound expression. 3. Simplify a Boolean expression using De Morgan's laws. 4. Draw simple gate circuits on paper. 5. State why combinational circuits produce predictable outputs. ### Key vocabulary - **Logic gate**: a circuit performing a fundamental boolean operation. - **AND gate**: produces one output only when all inputs are true. - **OR gate**: produces output when any input is true. - **NOT gate**: inverts its single input. - **Truth table**: a table listing outputs for every input combination. - **Boolean expression**: a formula using AND OR NOT operators. - **De Morgan's laws**: rules simplifying complex boolean expressions. - **Combinational circuit**: a circuit whose output depends only on current inputs. - **Predictable output**: a value determined purely by the inputs present. ### Common misconceptions - *"A truth table lists one column for inputs."* Truth tables list outputs as the final column. - *"De Morgan's laws apply to normal arithmetic."* They apply only to boolean logic. - *"Combinational circuits have memory."* Combinational circuits depend only on current inputs. ### Teacher activities 1. Starter: ask what happens to an AND gate when one input is false. 2. Define AND, OR and NOT one by one and build truth tables. 3. Demonstrate De Morgan's laws by simplifying a compound expression. 4. Draw a simple AND circuit showing two inputs meeting at an output. 5. Contrast combinational circuits with sequential circuits briefly. 6. Close with the truth-table task and exit question. ### Student activities 1. Answer the starter and explain why AND gives zero when any input is false. 2. Name the three basic gates and give the truth condition for each. 3. Complete truth tables for AND, OR and NOT. 4. Simplify a compound expression using De Morgan's laws step by step. 5. Draw a simple AND circuit and label the inputs and output. 6. Contrast combinational circuits with sequential circuits in one sentence. ### Practical / learning evidence Three complete truth tables, one De Morgan simplification with steps, one circuit drawing and a combinational versus sequential comparison. Submit all four for marking. ### Resources and preparation Printed truth tables, blank circuit templates and sample expressions. Offline route: paper versions, no device needed. Display any logic gates carefully and avoid touching circuit boards. ### Assessment for learning Inspect each truth table for every row filled correctly. Check the De Morgan simplification for valid steps. Mark the circuit for correct gates and connections. Flag any learner who claims a combinational circuit has memory. ### Inclusion and homework Provide the truth tables prefilled for the first row and allow oral completion of the rest. Reduce the circuit drawing to one simple gate. Extend confident learners with NAND and NOR combinations and a fourth truth-table exercise. Homework: simplify a second De Morgan expression and compare the two simplified results. --- ## Week 7: Computer Networks Date: Monday 19 October 2026 to Friday 23 October 2026 Subtopic: What is a Network Topology?; Bus Topology; Star Topology; Ring Topology; Mesh Topology; Tree (Hierarchical) Topology; Hybrid Topology; Why Network Models Exist; The OSI Reference Model; The Seven Layers of the OSI Model; The TCP/IP Model; Comparing OSI and TCP/IP; Client-Server and Peer-to-Peer Models; Corporate Networks; Network Protocols in Business; Network Security Measures and Threats; Meaning and Uses of Networks; Classes of Network; Network Devices; Topology; Wired and Wireless Connections ### Lesson objectives By the end of the week, learners should be able to: 1. Define a network as devices sharing resources through a medium. 2. Name the four basic network topologies and compare them on combined criteria. 3. Explain why star topologies dominate modern networks. 4. Describe collision domains and how switches reduce them. 5. Trace network traffic from a client to a server across topology layers. ### Key vocabulary - **Network**: two or more devices sharing resources. - **Topology**: the shape of the network connecting devices. - **Star topology**: one central device connected to all others. - **Bus topology**: one cable through which all devices attach. - **Ring topology**: devices chained in a closed loop. - **Mesh topology**: every device connected to every other device. - **Collision domain**: the set of devices sharing one cable segment. - **Switch**: a central device forwarding frames only to the destination port. - **Traffic trace**: the path of a packet through a network. ### Common misconceptions - *"Networks exist only in school labs."* Networks exist at home, bank, hospital and transport. - *"Topologies must stay exact shapes."* Real networks combine multiple topologies in practice. - *"A switch behaves like a hub."* A switch forwards selectively; a hub broadcasts everywhere. ### Teacher activities 1. Starter: ask where a packet leaves a desktop before reaching the internet. 2. Define a network and illustrate it as a shared-resource arrangement. 3. Name the four topologies and compare them on cost, reliability and scalability. 4. Explain collision domains and how switches reduce them. 5. Model tracing traffic from a client through the star topology to a server. 6. Close with the topology-choice task and exit question. ### Student activities 1. Answer the starter and describe the path from desktop to internet. 2. Name the four topologies and state the defining feature of each. 3. Compare the four topologies on three combined criteria. 4. Describe collision domains in one sentence tied to hubs. 5. Trace traffic through a star topology from client to server. 6. Choose the topology suited to a school laboratory and justify it. ### Practical / learning evidence A four-topology comparison chart, a collision-domain explanation and a star-traffic trace worksheet. Submit all three for marking. ### Resources and preparation Printed comparison chart, blank topology trace template and sample traffic diagrams. Offline route: paper versions, no device needed. Display any router or switch carefully and never dismantle them during demonstration. ### Assessment for learning Inspect the comparison chart for at least two criteria filled correctly per topology. Mark the collision-domain explanation for a sensible hub behaviour. Check the star-traffic trace for correct client-to-server path. Flag any learner who claims a switch behaves like a hub. ### Inclusion and homework Provide the comparison prefilled for learners who need scaffolding and allow oral traffic trace. Extend confident learners with five topologies and a five-criteria ranking. Homework: name two real networks outside school and state the topology each uses. --- ## Week 8: Internet and Online Safety Date: Monday 26 October 2026 to Friday 30 October 2026 Topic: The Internet and Online Safety Subtopic: What the Internet Is; How Data Travels; Services on the Internet; Access and the Local Situation; Web Technologies; Personal Safety Online; Security of the Computer; Cyber Crime and Cyber Ethics; Healthy and Responsible Use ### Lesson objectives By the end of the week, learners should be able to: 1. Define the internet and World Wide Web correctly. 2. Name the four requirements to get online and identify each role. 3. Apply four reliability checks to a web source result. 4. Name five common online safety threats and state protections. 5. State three rules for safe internet use in a school environment. ### Key vocabulary - **Internet**: a global network of interconnected computer networks. - **World Wide Web**: hyperlinked pages running on the internet. - **Requirement**: something necessary to connect, such as a browser. - **Browser**: software used to view web pages. - **ISP**: the company supplying network access. - **Reliability check**: judging whether a source is trustworthy. - **Threat**: anything that can harm a computer or user. - **Protection**: a safeguard against a threat. - **Safe rule**: a behaviour guideline for users. ### Common misconceptions - *"Google and YouTube are the same thing."* Google is a search engine; YouTube is a streaming video site. - *"Anything online is true."* Anyone can publish; check the author, date and evidence. - *"Strong passwords stop all threats."* Strong passwords help but phishing bypasses strength alone. ### Teacher activities 1. Starter: hold up a browser and an email inbox and ask which is an online service. 2. Recap internet versus web distinction and list six common online services. 3. Apply four reliability checks one by one to a source. 4. Name five common online safety threats and pair each with a protection. 5. State three safe internet rules for a school environment. 6. Close with the safety-check task and exit question. ### Student activities 1. Answer the starter and name the online service shown. 2. Define the internet and World Wide Web correctly and compare. 3. Name the four requirements to get online and identify each role. 4. Apply four reliability checks to three sources and record outcomes. 5. Name five online safety threats and state the protection for each. 6. State three safe internet rules for a school environment. 7. Answer the exit question in one sentence about checking sources. ### Practical / learning evidence A four-reliability-checks sheet with outcomes, a five-threat-with-protection chart and a three-rule school-safety checklist. Submit all three for marking. ### Resources and preparation Computers with a browser, printed source sheets and sample safety threats. Offline route: paper versions, no device needed. Keep screenshots on the projector only during demonstration. Disable Caps Lock before drills. ### Assessment for learning Inspect the reliability checks for correct author, date and evidence outcomes. Mark the threat chart for correct threat and protection pairs. Check the school safety rules for three enforceable behaviours. Flag any learner who accepts any source unchecked. ### Inclusion and homework Provide the source sheets prechecked for learners who need scaffolding and allow oral safety checks. Extend confident learners with five more threats and a second set of checks. Homework: enable two-factor authentication on one account you use regularly. --- ## Week 9: Introduction to Databases Date: Monday 2 November 2026 to Friday 6 November 2026 Subtopic: Meaning and Reason for Databases; Parts of a Database; Keys, Relationships and Design; Using a Database Program; Advantages and Precautions ### Lesson objectives By the end of the week, learners should be able to: 1. Define a database and describe its purpose in an organisation. 2. Name the main components of a database schema. 3. Distinguish relational and non-relational structures briefly. 4. Create a simple table schema with fields, types and constraints. 5. Explain why indexing speeds up queries. ### Key vocabulary - **Database**: a structured collection of related records. - **Schema**: the design defining tables, fields and relationships. - **Table**: a collection of related rows and fields. - **Field**: a column holding a characteristic of each record. - **Constraint**: a rule limiting what data may enter a field. - **Index**: a sorted lookup structure speeding query searches. - **Query**: a request returning records matching criteria. - **Relational**: a tabular structure holding tables linked by keys. - **Non-relational**: a document or graph structure storing loose data. - **Speeds up**: makes something faster through a structural aid. ### Common misconceptions - *"A database is just a big spreadsheet."* Databases enforce constraints and relationships that spreadsheets ignore. - *"Tables store unrelated rows."* Related rows belong together because of shared field types. - *"Indexing adds unrelated overhead."* Indexing speeds queries substantially without changing stored values. ### Teacher activities 1. Starter: ask where a school keeps student records if not on a teacher's desktop. 2. Define a database and describe its organisational purpose. 3. Name the main schema components one by one. 4. Briefly distinguish relational from non-relational structures. 5. Create a simple table schema on the board for a student records table. 6. Demonstrate how an index speeds a query lookup. ### Student activities 1. Answer the starter and identify the right storage location. 2. Define a database in their own words and state its purpose. 3. Name the main schema components in one sentence each. 4. Distinguish relational from non-relational structures briefly. 5. Create a simple table schema with fields, types and constraints. 6. Explain why an index speeds up queries in one paragraph. 7. Answer the exit question in one sentence about databases versus spreadsheets. ### Practical / learning evidence A one-table schema worksheet with fields, types and constraints, plus an index explanation paragraph. Submit both for marking. ### Resources and preparation Printed schema templates, sample student data and index example cards. Offline route: paper templates, no device needed. Provide an index example drawn simply on paper. ### Assessment for learning Inspect the schema for correct field names, types and at least one constraint. Mark the index explanation for a plausible lookup analogy. Flag any learner who calls the database a big spreadsheet. ### Inclusion and homework Provide the schema prefilled for the field names and allow oral constraint completion. Extend confident learners with two tables linked by a foreign key and a second index example. Homework: name one advantage and one disadvantage of a relational database over a spreadsheet. --- ## Week 10: Advanced Productivity Tools Date: Monday 9 November 2026 to Friday 13 November 2026 Subtopic: Mail Merge and Templates; Spreadsheet Formulas, Functions and Pivot Tables; Advanced Presentations and Productivity Suites; Advanced Spreadsheet Skills; Advanced Word Processing and Presentation Features; Integration and Collaboration Tools; Formulas and References; Statistical Functions; Logical, Text and Date Functions; Lookup Functions; Building a Summary Worksheet ### Lesson objectives By the end of the week, learners should be able to: 1. Name at least three advanced productivity tools such as LaTeX or Markdown. 2. Explain why Markdown is preferred for technical documentation. 3. Apply bold, italic, strikethrough and blockquote formatting. 4. Produce a formatted document with headings, lists and tables. 5. Export the document as PDF for distribution. ### Key vocabulary - **Productivity tool**: software helping users create professional documents. - **LaTeX**: a typesetting system for mathematical notation. - **Markdown**: a lightweight formatting syntax for plain text. - **Formatting**: changing how text looks such as size, colour and spacing. - **Strikethrough**: a line through selected text indicating deletion. - **Blockquote**: a quoted passage set apart from surrounding text. - **Heading**: a title used for sections and hierarchy. - **List**: a bulleted or numbered series of items. - **Table**: a grid aligning rows and columns of data. - **Export**: saving a copy in another format. ### Common misconceptions - *"Word processors are the only tools for documents."* Markdown and LaTeX suit different workflows than Word. - *"Markdown changes the document itself."* Markdown is plain text with formatting markers; no hidden style layers. - *"Bold and italic are the same."* Bold and italic change weight and slant respectively. ### Teacher activities 1. Starter: display plain text and formatted text and ask which a technical team prefers. 2. Name three advanced productivity tools and describe each workflow. 3. Demonstrate Markdown formatting: heading, bold, italic, strikethrough, blockquote. 4. Show producing a formatted document with headings, lists and a table. 5. Demonstrate exporting the Markdown to PDF via a converter. 6. Close with the formatting task and exit question. ### Student activities 1. Choose the starter item and explain the preference reason. 2. Name three advanced productivity tools and describe each workflow. 3. Apply Markdown formatting to the heading, bold, italic, strikethrough and blockquote. 4. Produce a formatted document with headings, lists and a table. 5. Export the Markdown to PDF and confirm the conversion worked. 6. Answer the exit question in one sentence about Markdown. ### Practical / learning evidence A formatted Markdown document containing heading, bold, italic, strikethrough, blockquote, a list and a table, plus a converted PDF. Inspect both for matching content. ### Resources and preparation Computers with a Markdown editor and PDF converter, blank templates and sample text. Offline route: paper Markdown preview, no device needed. Warn learners not to enter personal data visible in Markdown preview. ### Assessment for learning Inspect the Markdown for correct syntax on every element. Check the PDF for matching content. Ask a learner to describe the difference between bold and italic. Flag any learner who claims Markdown hides formatting layers. ### Inclusion and homework Provide the sample text already typed so learners focus on formatting syntax. Allow extra time for the PDF conversion. Extend confident learners with four more elements and a second conversion. Homework: convert one plain-text document to Markdown and back again. --- ## Week 11: Revision Date: Monday 16 November 2026 to Friday 20 November 2026 Subtopic: Review of Architecture, Memory and Storage; Review of Number Systems and Logic; Review of Networks and the Internet; Review of Productivity Tools ### Lesson objectives By the end of the week, learners should be able to: 1. Recall the full term's key terms without notes in ten minutes. 2. Test objective knowledge with a short recall quiz. 3. Practise spreadsheet, database, logic-gate and program skills under timed conditions. 4. Prepare three practical stations ready for the examination week. 5. Organise their materials for examinations. ### Key vocabulary - **Full summary**: a one-page recap of the entire term's vocabulary. - **Recall quiz**: a short test of definitions and concepts from memory. - **Timed conditions**: a restricted time allowance for practice. - **Practical station**: a setup point for examination practical tasks. - **Materials organisation**: keeping tools ready before an examination. ### Common misconceptions - *"Revision is just reading notes again."* Revision means testing and practising, not passive reading. - *"Tomorrow is the exam so today is fine."* A full day before leaves almost no preparation time. - *"Better to be relaxed than busy preparing."* Preparation reduces anxiety and improves performance. ### Teacher activities 1. Starter: ten rapid-fire recall questions from the full term, no notes allowed. 2. Run a timed objective quiz and mark it as a class, explaining distractors. 3. Demonstrate the three practical stations and remind learners of the materials checklist. 4. Walk through a morning materials organisation checklist. 5. Confirm that every learner can reach the exam room and has stationery. 6. Close with a brief announcement of the Second Term starting Monday. ### Student activities 1. Answer the ten recall questions and note any slips. 2. Mark their own quiz answers and record scores for review. 3. Prepare the three practical stations and run through the materials checklist. 4. Practise spreadsheet, database, logic-gate and program tasks for ten minutes each. 5. Pack stationery, identification and any permitted materials for examination day. 6. Write one sentence on what revision helped you feel ready for Monday. ### Practical / learning evidence A scored objective quiz, a completed revision grid covering all terms and an materials-organisation checklist signed by the learner. All three handed to the teacher for marking. ### Resources and preparation Quiz sheet, revision grid and materials checklist. Confirm the examination room, three machines and one invigilator per station are booked before the week. ### Assessment for learning Use the quiz scores to plan the Second-Term reteach if class averages are below target. Check the revision grid for completeness. Verify the materials checklist is signed and ready for examination day. ### Inclusion and access Provide the quiz in large print and allow extra time where approved. Pair learners for the practical rehearsal so a confident partner can model the steps. Homework: pack everything needed for the examination week and store it safely. --- ## Week 12: Examination Date: Monday 23 November 2026 to Friday 27 November 2026 Subtopic: Before the Examination; During the Written Paper; During the Practical Paper; After the Examination ### Lesson objectives By the end of the examination week, learners should be able to: 1. Demonstrate recall of the term's concepts under examination conditions. 2. Apply knowledge to unfamiliar examples in objective and short-answer questions. 3. Complete a practical task within the time allowance using correct procedure. 4. Name, save and submit files correctly. 5. Explain their practical output when questioned by the examiner. ### Examination design For Senior Secondary 2 the totals are: Section A objective 20 marks, Section B short answer 30 marks, Section C essay 10 marks, Section D practical 20 marks, total 80. Section A samples recall. Section B samples explanation, comparison and classification. Section D samples practical database, logic-gate and program skills. | Section | Format | Marks | |---|---:|---:| | A | Objective (20 four-option items) | 20 | | B | Short answer (definitions / diagrams / classification / conversions) | 30 | | C | Essay (definition / comparison / application) | 10 | | D | Practical (database schema / logic gate truth table / program) | 20 | | **Total** | **80** | ### Teacher activities 1. Confirm the approved timetable, venue, seating and invigilation before the week begins. 2. Brief learners on the paper structure, the time for each section and the materials allowed. 3. Set out three practical stations: database schema, logic-gate construction and program execution, with one invigilator per station where possible. 4. Prepare offline equivalents for learners without device access: printed sketchbook, paper truth-table template and paper program tracing task. 5. Mark using the agreed scheme, moderate a sample of scripts and record scores. 6. Return scripts with feedback and hand over to Third Term. ### Student activities 1. Attend the briefing and note the time allowed per section. 2. Complete Section A, then Section B, allocating time as instructed. 3. Move through the practical stations in the assigned order. 4. Save work with the correct filename and confirm it opens before leaving the station. 5. Answer the examiner's question on their practical output. 6. Collect marked scripts and record the topics to revise in Third Term. ### Practical / learning evidence The completed examination script, the saved practical file for each candidate and the practical rubric sheets. Retain scripts, marking guides and representative learner work for moderation as required by the assessment framework. ### Resources and preparation Printed question papers and answer sheets, a marking guide and rubric per station, working computers with a database tool or spreadsheet and a graphics package, a stopwatch and printed sketchbooks. Check every machine the day before, and prepare two spare machines where possible. Ensure power backup and an offline alternative for each station. ### Assessment for learning Mark Section D against the practical rubric: task interpretation, procedure, technical accuracy, schema correctness, truth table and program, file naming and saving, organisation and explanation. Moderate a sample of scripts across all sections, and flag any question where more than a third of learners scored zero for review of the teaching rather than the learners. ### Inclusion and access Provide extra time and large-print papers where approved, seat learners with visual or hearing needs appropriately, and allow the offline equivalent for any learner without device access so that no candidate loses practical marks because of equipment. Keep the practical criteria identical across the digital and paper routes. ### After the examination Record scores against the class list, return scripts with brief feedback, and hand over to Third Term: Python basics, e-commerce, project work and SSCE preparation. Note any topic where the class average fell below the school's threshold and schedule it as a Third-Term retrieval starter. --- Prepared from the SS 2 First Term curriculum. Adapt timings and tasks to the approved school calendar.