Back

school course

Grade 07: Computing

4 units across the school year. Each has a worked example, an activity and a standard to meet.

about this course

What you will be able to do

L3Secondary4 units36 teaching weeks36-week school yearBloom levels: Understand, Apply, Create
  • Create Build a simple web page with text, images and links.
  • Apply Solve problems with a short program.
  • Apply Enter, sort and filter data in a table.
  • Understand Describe a digital footprint and manage it.

Task, condition and standard

Task

Meet the outcome of every unit in Grade 07 Computing, and keep one piece of evidence for each.

Condition

A 36-week school year, 4 units, a teacher or guide, a learning book or device, and local examples in the local language first with English support.

Standard

Each unit: at least 8 of 10 marks on a short task, with one line of reasoning for each answer. Course pass: no unit at 'Not yet' after one retry, and a pass in SA1 and SA2.

Assessment plan

Formative checks FA1 to FA4 around weeks 6, 12, 24 and 30; summative checks SA1 in week 18 and SA2 in week 36.

unit by unit

4 units with worked examples

Unit 1 HTML basics Weeks 1 to 11Create

In this unit, 'HTML basics', you learn to build a simple web page with text, images and links. You work with notes, a worked line and a self-mark. You see it, say it, then do it alone.

  • See it: watch or try the skill in 'HTML basics' on a teacher screen or a safe device.
  • Name the parts: write the key words and what each part does.
  • Use it: build a simple web page with text, images and links. Save your work in a named file or folder.
  • Test and fix: run it, find one fault, correct it, and note what you changed.
Worked example. Solved: <h1>My page</h1><p>Hello</p><a href='about.html'>About</a>. CSS: p { color: blue; } makes paragraphs blue. Method: Model run for 'HTML basics'. Goal in one sentence. Plan: list the steps in order before touching the device. Do: follow the plan, saving after each step. Test: try normal input and one unusual input. Fix: change one thing and test again. Share: show a partner and explain it. What a good answer looks like: it works for normal input, steps match the plan, and the learner can explain each part. Online safety rules apply at all times.

Step by step.

  1. Step 1, Set up files: The learner creates a folder called camel-site and opens a plain text editor. She saves a new file as index.html inside it. The .html ending tells the browser that this file is a web page.
  2. Step 2, Basic skeleton: She types <!DOCTYPE html>, then <html>, <head><title>My Camel Page</title></head>, then <body> and </body></html>. The title shows on the browser tab, and everything visible goes between the body tags.
  3. Step 3, Heading and paragraph: Inside body she types <h1>Camels</h1> and <p>Camels live in the desert and can go days without water.</p>. In the browser she sees a large bold heading and one line of normal text below it.
  4. Step 4, Image: She copies camel.jpg into the folder and types <img src="camel.jpg" alt="A camel standing on sand">. The browser shows the picture, and the alt text is read by screen readers and appears if the image fails to load.
  5. Step 5, Link: She types <a href="facts.html">More camel facts</a>. Clicking the blue underlined words opens facts.html, which she creates with <h1>Facts</h1> and <p>Camels have two humps or one.</p>. A relative link works because both files are in one folder.
  6. Step 6, Test and fix: She saves and refreshes. The image is missing, so she checks the file name and finds she typed Camel.jpg with a capital C. She changes it to camel.jpg, saves, refreshes, and the picture appears.
  7. Your turn: Make a page with the title 'My Dates', a heading, a paragraph and a link to about.html. Model answer: <title>My Dates</title>, <h1>Dates</h1>, <p>Sweet fruit.</p>, <a href="about.html">About</a>, all inside the body, saved as index.html.

Activity. About 30 to 40 minutes of class work, then one short practice task for home. Keep evidence: a worked task and a corrected copy.

Standard to meet. Build a simple web page with text, images and links: at least 8 of 10 marks on a short task, with one line of reasoning for each answer.

Unit 2 Programming with variables, loops and decisions Weeks 12 to 22Apply

In this unit, 'Programming with variables, loops and decisions', you learn to solve problems with a short program. You work with notes, a worked line and a self-mark. You see it, say it, then do it alone.

  • See it: watch or try the skill in 'Programming with variables, loops and decisions' on a teacher screen or a safe device.
  • Name the parts: write the key words and what each part does.
  • Use it: solve problems with a short program. Save your work in a named file or folder.
  • Test and fix: run it, find one fault, correct it, and note what you changed.
Worked example. Solved: Algorithm to make toast: 1 take two slices, 2 put in toaster, 3 press down, 4 wait, 5 take out. Loop: repeat 4 times: step forward, turn right = draw a square. Method: Model run for 'Programming with variables, loops and decisions'. Goal in one sentence. Plan: list the steps in order before touching the device. Do: follow the plan, saving after each step. Test: try normal input and one unusual input. Fix: change one thing and test again. Share: show a partner and explain it. What a good answer looks like: it works for normal input, steps match the plan, and the learner can explain each part. Online safety rules apply at all times.

Step by step.

  1. Step 1, Break a problem into inputs, steps and output. Problem: you save 5 coins a week and want 60. How many weeks? Inputs are 5 and 60. Process is repeat adding 5 and count the weeks. Output is the number of weeks. Plan this before typing any code.
  2. Step 2, Write a while loop. savings = 0 and weeks = 0, then while savings < 60: savings += 5 and weeks += 1, then print(weeks, savings). It prints 12 60. The loop repeats while the test is true, and each pass changes a variable so the loop can end.
  3. Step 3, Use a for loop when the count is known. total = 0, then for n in range(1, 101): total += n. The range runs from 1 to 100 because the end value is left out. The program prints 5050, which matches adding 1 + 2 + 3 up to 100 by pairing.
  4. Step 4, Add a decision inside a loop. To count multiples of 7 below 100: count = 0, for n in range(1, 100): if n % 7 == 0: count += 1. The answer is 14, since 7 x 14 = 98 is the last multiple below 100. The % operator gives the remainder.
  5. Step 5, Test and debug. If a while loop never changes savings it runs forever; stop it with the stop button and add the missing line. Check one case by hand: the first 12 weeks give 12 x 5 = 60, so the program output is correct and an off-by-one slip is ruled out.
  6. Step 6, Your turn: change the program so you save 8 coins a week and want 100. How many weeks, and how much is saved? Answer: 13 weeks, because 12 weeks gives 96 which is below 100, and 13 weeks gives 104.

Activity. About 30 to 40 minutes of class work, then one short practice task for home. Keep evidence: a worked task and a corrected copy.

Standard to meet. Solve problems with a short program: at least 8 of 10 marks on a short task, with one line of reasoning for each answer.

Unit 3 Databases and tables Weeks 23 to 33Apply

In this unit, 'Databases and tables', you learn to enter, sort and filter data in a table. You work with notes, a worked line and a self-mark. You see it, say it, then do it alone.

  • See it: watch or try the skill in 'Databases and tables' on a teacher screen or a safe device.
  • Name the parts: write the key words and what each part does.
  • Use it: enter, sort and filter data in a table. Save your work in a named file or folder.
  • Test and fix: run it, find one fault, correct it, and note what you changed.
Worked example. Solved: Table Students: ID, Name, Class. Query: SELECT Name FROM Students WHERE Class = '7B'; lists the names in 7B. Method: Model run for 'Databases and tables'. Goal in one sentence. Plan: list the steps in order before touching the device. Do: follow the plan, saving after each step. Test: try normal input and one unusual input. Fix: change one thing and test again. Share: show a partner and explain it. What a good answer looks like: it works for normal input, steps match the plan, and the learner can explain each part. Online safety rules apply at all times.

Step by step.

  1. Step 1, Build the table: Faisal sets up a table with fields Name, Class and Score and five records: Ali 7A 82, Bana 7B 91, Cyrus 7A 76, Dina 7B 88, Eman 7A 91. Each row is one record and each column is one field.
  2. Step 2, Sort ascending: He sorts by Score from lowest to highest. The order becomes Cyrus 76, Ali 82, Dina 88, Bana 91, Eman 91. Bana and Eman tie at 91, so they may stay in their original order or swap, depending on the tool.
  3. Step 3, Sort descending: He changes the sort to highest first. Now Bana 91, Eman 91, Dina 88, Ali 82, Cyrus 76. The top of the table shows the best scores, which is useful for a quick ranking.
  4. Step 4, Filter by class: He filters Class equals 7A. Only 3 records show: Ali, Cyrus and Eman. The other 2 records, Bana and Dina, are hidden but not deleted. Clearing the filter shows all 5 again.
  5. Step 5, Filter by number: He filters Score greater than or equal to 85. This shows Bana 91, Dina 88 and Eman 91, which is 3 records. Ali at 82 and Cyrus at 76 do not meet the rule.
  6. Step 6, Combine filters: He applies Class equals 7A and Score at least 85 together. Only Eman remains, because Eman is the one record that passes both conditions. Two conditions together are stricter than either alone.
  7. Your turn: Table of books: Sand Tales Story 120, Stars Science 200, Boats Science 90, Moon Story 150 pages. Sort by pages up and filter Science. Model answer: Boats 90, Sand Tales 120, Moon 150, Stars 200; Science filter shows Stars and Boats, 2 records.

Activity. About 30 to 40 minutes of class work, then one short practice task for home. Keep evidence: a worked task and a corrected copy.

Standard to meet. Enter, sort and filter data in a table: at least 8 of 10 marks on a short task, with one line of reasoning for each answer.

Unit 4 Digital footprint Weeks 34 to 36Understand

In this unit, 'Digital footprint', you learn to describe a digital footprint and manage it. You work with notes, a worked line and a self-mark. You see it, say it, then do it alone.

  • See it: watch or try the skill in 'Digital footprint' on a teacher screen or a safe device.
  • Name the parts: write the key words and what each part does.
  • Use it: describe a digital footprint and manage it. Save your work in a named file or folder.
  • Test and fix: run it, find one fault, correct it, and note what you changed.
Worked example. Solved: Before posting ask: would I say this face to face, and would I be happy if a teacher saw it? Everything you post can be copied. Method: Model run for 'Digital footprint'. Goal in one sentence. Plan: list the steps in order before touching the device. Do: follow the plan, saving after each step. Test: try normal input and one unusual input. Fix: change one thing and test again. Share: show a partner and explain it. What a good answer looks like: it works for normal input, steps match the plan, and the learner can explain each part. Online safety rules apply at all times.

Step by step.

  1. Step 1, Define: The learner's digital footprint is every trace she leaves online: posts, photos she shared, comments, accounts, and also what others post about her. Some traces she chose on purpose, like a profile picture, and some are collected from her activity.
  2. Step 2, Audit: She searches for her own name and lists what she finds: 4 public photos, 1 school quiz result, 2 comments on a game forum, and 1 old account she forgot. That is 8 items in total.
  3. Step 3, Sort the items: She marks each item as keep, change or remove. Quiz result keep; 2 comments change, because one uses her full name; 4 photos, 1 shows her school uniform with the school name, so that goes to remove; the old account is removed.
  4. Step 4, Manage: She sets the photo album to friends only, deletes the uniform photo, deletes the old account and its posts, and edits the forum name from her real name to a nickname. Items visible to the public drop from 8 to 3, the quiz result and the 2 comments.
  5. Step 5, Think before posting: Before posting a holiday picture she asks, 'Would I be fine if my teacher, grandmother and a stranger saw this in five years?' She also leaves out the location. Posts can be copied and stay long after deletion.
  6. Step 6, Review: Her new footprint shows safe, positive items such as her art competition result. She sets a reminder to check privacy settings every term. Managing a footprint is ongoing, not a one-time job.
  7. Your turn: Audit shows 6 public items, 2 reveal your address. What do you do? Model answer: remove or hide the 2 address items first, set the rest to friends only, and check again; public items drop from 6 to 4 or fewer.

Activity. About 30 to 40 minutes of class work, then one short practice task for home. Keep evidence: a worked task and a corrected copy.

Standard to meet. Describe a digital footprint and manage it: at least 8 of 10 marks on a short task, with one line of reasoning for each answer.

assessment

How you are checked

Evidence for each unit is marked with this rubric by a teacher, and by a peer where the unit allows. Pass: no criterion at 'Not yet' after one retry.

Marking rubric (Not yet, Meets, Exceeds)
CriterionNot yetMeetsExceeds
It worksDoes not runRuns with helpRuns and handles odd input
Understanding of the partsCannot nameNames mostNames and explains
PlanningNoneA listA clear ordered plan
Safety and careNeeds remindingFollows rulesFollows rules and helps others
Practice habitRarelyWeeklyMost days

Ten-question check, with model answers

Q1. Unit 1 (HTML basics): Make a page with the title 'My Dates', a heading, a paragraph and a link to about.html.

Model answer: <title>My Dates</title>, <h1>Dates</h1>, <p>Sweet fruit.</p>, <a href="about.html">About</a>, all inside the body, saved as index.html. (Covered in unit 1: HTML basics.)

Q2. Unit 2 (Programming with variables, loops and decisions): Change the program so you save 8 coins a week and want 100. How many weeks, and how much is saved?

Model answer: 13 weeks, because 12 weeks gives 96 which is below 100, and 13 weeks gives 104. (Covered in unit 2: Programming with variables, loops and decisions.)

Q3. Unit 3 (Databases and tables): Table of books: Sand Tales Story 120, Stars Science 200, Boats Science 90, Moon Story 150 pages. Sort by pages up and filter Science.

Model answer: Boats 90, Sand Tales 120, Moon 150, Stars 200; Science filter shows Stars and Boats, 2 records. (Covered in unit 3: Databases and tables.)

Q4. Unit 4 (Digital footprint): Audit shows 6 public items, 2 reveal your address. What do you do?

Model answer: remove or hide the 2 address items first, set the rest to friends only, and check again; public items drop from 6 to 4 or fewer. (Covered in unit 4: Digital footprint.)

Q5. Unit 1 (HTML basics): Basic skeleton. Show how you do it and say what the result is.

Model answer: She types <!DOCTYPE html>, then <html>, <head><title>My Camel Page</title></head>, then <body> and </body></html>. The title shows on the browser tab, and everything visible goes between the body tags. (Covered in unit 1: HTML basics.)

Q6. Unit 2 (Programming with variables, loops and decisions): Write a while loop. Show how you do it and say what the result is.

Model answer: savings = 0 and weeks = 0, then while savings < 60: savings += 5 and weeks += 1, then print(weeks, savings). It prints 12 60. The loop repeats while the test is true, and each pass changes a variable so the loop can end. (Covered in unit 2: Programming with variables, loops and decisions.)

Q7. Unit 3 (Databases and tables): Sort ascending. Show how you do it and say what the result is.

Model answer: He sorts by Score from lowest to highest. The order becomes Cyrus 76, Ali 82, Dina 88, Bana 91, Eman 91. Bana and Eman tie at 91, so they may stay in their original order or swap, depending on the tool. (Covered in unit 3: Databases and tables.)

Q8. Unit 4 (Digital footprint): Audit: She searches for her own name and lists what she finds. Show how you do it and say what the result is.

Model answer: 4 public photos, 1 school quiz result, 2 comments on a game forum, and 1 old account she forgot. That is 8 items in total. (Covered in unit 4: Digital footprint.)

Q9. Unit 1 (HTML basics): Heading and paragraph. Show how you do it and say what the result is.

Model answer: Inside body she types <h1>Camels</h1> and <p>Camels live in the desert and can go days without water.</p>. In the browser she sees a large bold heading and one line of normal text below it. (Covered in unit 1: HTML basics.)

Q10. Unit 2 (Programming with variables, loops and decisions): Use a for loop when the count is known. Show how you do it and say what the result is.

Model answer: total = 0, then for n in range(1, 101): total += n. The range runs from 1 to 100 because the end value is left out. The program prints 5050, which matches adding 1 + 2 + 3 up to 100 by pairing. (Covered in unit 2: Programming with variables, loops and decisions.)

levels L1 to L7

Where this course sits on the ladder

Seven slides, one for each level. Step in at your level and move up; credits stack. A level is reached when you can meet its standard, not by age.

Slide 1. L1 Basic: What a computer does

On the slide: L1 Basic · What a computer does

Notes: Name the four jobs of a computer: input, process, output and storage. Notes: use a washing machine or a phone and label each job with a sticky note; no screens are needed. Learners say which part is the input and which is the output.

Slide 2. L2 Awareness: Steps and algorithms

On the slide: L2 Awareness · Steps and algorithms

Notes: Describe an algorithm as ordered steps and put a set of steps in the right order. Notes: cut up the steps for making a sandwich and mix them; learners order them and find what breaks if two swap. Work unplugged. Safe knife use is for an adult only.

Slide 3. L3 Foundation: Code loops and variables (this course)

On the slide: L3 Foundation · Code loops and variables

Notes: Write a short program that uses a variable and a loop to give a predicted output. Notes: for i in range(1,6), print the square of i. The output is 1, 4, 9, 16, 25 and their total is 55. Learners predict the output first, then run and compare. Take breaks to rest eyes.

This course: Grade 07 Computing is at this level. Its units include HTML basics; Programming with variables, loops and decisions; Databases and tables; Digital footprint.

Slide 4. L4 Practitioner: Binary and image size

On the slide: L4 Practitioner · Binary and image size

Notes: Apply binary and storage sums to convert numbers and estimate file size. Notes: 45 in binary is 101101, since 32 plus 8 plus 4 plus 1 is 45. A raw picture of 800 by 600 pixels at 24 bits needs 1,440,000 bytes. Learners check by working back from binary to decimal.

Slide 5. L5 Specialist: Network transfer and security

On the slide: L5 Specialist · Network transfer and security

Notes: Analyse how data moves over a network and compare protections against common threats. Notes: a 50 MB file is 400 megabits; at 20 megabits per second the transfer takes 20 s. Learners work out the time on a slower link and list two safe habits for passwords and updates.

Slide 6. L6 Advanced (degree level): Complexity and search

On the slide: L6 Advanced · Complexity and search

Notes: Apply Big O reasoning to compare linear and binary search. Notes: a sorted list of 1,000,000 items needs at most 20 comparisons by binary search, since 2 to the 20 is 1,048,576, instead of up to a million for linear search. Learners trace a search on 16 numbers by hand.

Slide 7. L7 Super expert (postgraduate/expert): Secure system design

On the slide: L7 Super expert · Secure system design

Notes: Evaluate a small system for security risk and design controls. Notes: a 12-character password from 62 symbols holds about 71.5 bits of entropy, since 12 times log2 of 62 is 71.45. Learners rank threats, choose controls, and test only on systems they own or have written permission to test.

Notes: a level is reached when you can meet its standard, not by age. Learners may move up or down a level by subject.

ten locations and global

Localised for your place

Teach in the local language first, with English support. Use local currency, units and examples in every worksheet. Local curriculum and ministry rules are checked before use in a school; Arabic, Islamic, Social and Moral content needs licensed educators and ministry review. Child-safety rules apply for every learner under 18.

India (Bengaluru)

Use INR in money problems; deliver in English, Hindi, Kannada; personal data rule: Digital Personal Data Protection Act 2023; guardian contact for every learner under 18.

Netherlands (Eindhoven area)

Use EUR in money problems; deliver in Dutch, English; personal data rule: EU GDPR (Dutch: AVG), supervised by the Autoriteit Persoonsgegevens; guardian contact for every learner under 18.

UAE (Dubai and Abu Dhabi)

Use AED in money problems; deliver in Arabic, English; personal data rule: Federal Decree-Law No. 45 of 2021 (personal data protection); guardian contact for every learner under 18.

Brazil (Sao Paulo)

Use BRL in money problems; deliver in Portuguese (Spanish and English support); personal data rule: LGPD (Lei Geral de Protecao de Dados); guardian contact for every learner under 18.

Canada (Toronto)

Use CAD in money problems; deliver in English, French; personal data rule: PIPEDA, with provincial rules where they apply; guardian contact for every learner under 18.

United States

Use USD in money problems; deliver in English, Spanish; personal data rule: state privacy laws (for example California), and COPPA for children under 13; guardian contact for every learner under 18.

Singapore

Use SGD in money problems; deliver in English, Mandarin, Malay, Tamil; personal data rule: Personal Data Protection Act (PDPA); guardian contact for every learner under 18.

Australia

Use AUD in money problems; deliver in English; personal data rule: the Privacy Act 1988 and the Australian Privacy Principles; guardian contact for every learner under 18.

Hong Kong (Eastern Asia)

Use HKD in money problems; deliver in Chinese (Cantonese, Mandarin), English; personal data rule: the Personal Data (Privacy) Ordinance; guardian contact for every learner under 18.

Georgia and Israel (Western Asia)

Use GEL or ILS in money problems; deliver in Georgian, Hebrew, Arabic, English; personal data rule: the personal data law of the country where the learner lives; guardian contact for every learner under 18.

Cayman Islands (Caribbean)

Use KYD in money problems; deliver in English; personal data rule: the Data Protection Act; guardian contact for every learner under 18.

Mexico

Use MXN in money problems; deliver in Spanish, English; personal data rule: the federal law on personal data held by private parties; guardian contact for every learner under 18.

where this leads

Next steps, study and work

next

Draft

Draft course in our own words. Needs review by a qualified teacher before classroom use. Not live.

More Secondary courses Join