L36 — Final Test: Informatics
The final comprehensive test covering all informatics topics from L01 to L34: hardware, databases, web, algorithms, mobile, networks, and security.
Assignment Reference
The final test covers the entire Informatics course — all material from L01 to L34. Students are evaluated on both theoretical understanding and practical skills.
| Block | Lessons | Topics |
|---|---|---|
| Block 1 — Foundations | L01–L05 | Safety, hardware, software, number systems, logic |
| Block 2 — Databases | L06–L11 | Relational databases, SQL, structured queries |
| Block 3 — Web | L12–L23 | Modern IT, 3D, AR/VR, HTML/CSS, multimedia |
| Block 4 — Algorithms & Mobile | L24–L28 | Algorithms, App Inventor, Figma, UI design |
| Block 5 — Networks & Security | L29–L34 | Smart home, marketing, networks, IP/DNS, security |
Format: written theory (40 min) + practical task at the computer (35 min) + oral defence (5 min). Total: 100 points.
Grading Rubric
Part A — Theory (40 points, written)
Students answer 10 questions, 4 points each.
| # | Question | Points |
|---|---|---|
| 1 | Name the main components of a computer (at least 5). Classify each as input, output, or processing/storage. | 4 |
| 2 | What is the difference between an operating system and an application program? Give 2 examples of each. | 4 |
| 3 | Convert the binary number 11011010 to decimal. Show your working. | 4 |
| 4 | What is a relational database? What is a primary key and why is it needed? | 4 |
| 5 | Write an SQL query that selects all students from a students table where the age is greater than 16, sorted by last name. | 4 |
| 6 | Explain what an algorithm is. Give one everyday example. What are 3 of its 5 properties? | 4 |
| 7 | What is the difference between HTTP and HTTPS? What does the 🔒 lock in the browser guarantee — and what does it NOT guarantee? | 4 |
| 8 | What is DNS? Trace what happens step by step when you type google.com into a browser. | 4 |
| 9 | List 3 types of cyber threats. For each: name it, describe how it works, and give one way to protect against it. | 4 |
| 10 | What is IoT? Give 3 examples of smart home devices. Name one benefit and one risk of a smart home. | 4 |
Part B — Practical Task (50 points)
Students complete one large task at the computer. Teacher assigns based on classroom capabilities.
Option 1 — Complete App + Mockup
Build an App Inventor app AND a Figma design for the same idea:
| Criterion | Max points |
|---|---|
| App Inventor: app opens and runs without errors | 5 |
| App Inventor: at least 2 screens, navigation between them | 8 |
| App Inventor: uses 1+ variable and 1+ if/else block | 7 |
| Figma: Home screen with top bar, cards, FAB, bottom nav | 8 |
| Figma: Detail screen with back arrow, title, description, action | 7 |
| Figma: prototype link connecting both screens | 5 |
| Consistency between app logic and design (same features in both) | 5 |
| Quality: clean layout, readable text, no obvious UI rule violations | 5 |
Option 2 — Comprehensive HTML + CSS page
Build a 2-page website from scratch in a text editor (VS Code, Notepad++, or Notepad):
| Criterion | Max points |
|---|---|
Valid HTML structure (<!DOCTYPE>, <head>, <body>) | 5 |
| Navigation bar linking to both pages | 7 |
| At least one table with 3+ rows | 7 |
| At least one image with alt text | 5 |
| External CSS file with: custom fonts, colours, and layout | 8 |
| Responsive design: content readable on both wide and narrow windows | 5 |
An embedded YouTube video (using <iframe>) | 4 |
| A working HTML form with name, email, and a submit button | 4 |
| No broken links, no missing images | 5 |
Part C — Oral Verification (10 points)
Teacher asks 2 questions, 5 points each. Student answers without looking at notes.
| Score | Criteria |
|---|---|
| 5/5 | Answer is correct, complete, and explained in student's own words |
| 3–4/5 | Answer is mostly correct, minor gaps |
| 1–2/5 | Partial answer, significant gaps |
| 0/5 | Incorrect or "I don't know" |
Grade bands:
| Score | Grade |
|---|---|
| 90–100 | A (Excellent) |
| 75–89 | B (Good) |
| 60–74 | C (Satisfactory) |
| < 60 | Retake required |
Verification Questions
Teacher selects 2 questions based on the student's practical work:
Foundations:
- I have the binary number
10110011. Convert it to decimal step by step. - What is the difference between RAM and a hard drive? What happens to each when you turn off the computer?
- Give an example of an AND, OR, and NOT logic gate in everyday life (not computers).
Databases:
4. What is SQL? Write a query that adds a new student (name: "Ali", age: 17) to the students table.
5. What is the difference between WHERE and HAVING in SQL?
6. What is a JOIN in SQL? Give an example of when you'd need one.
Web:
7. What's the difference between HTML and CSS? Can a page exist without CSS?
8. Point to your page. Explain what <head> contains and why it's not visible.
9. What is the alt attribute on an image and why does it matter?
Algorithms & Mobile:
10. Draw a flowchart for a cyclic algorithm of your choice. Identify the loop condition.
11. Open your App Inventor project. Explain what the if / else block in your app does.
12. Point to your Figma design. Why did you choose this layout? What UI rules did you follow?
Networks & Security: 13. What is the difference between a router and a switch? 14. What is the difference between your private IP and your public IP? Why can't two devices in the world have the same private IP? 15. What is 2FA? Give a realistic scenario where a password alone would fail but 2FA would protect you.
Submission Checklist
Before the test, have ready:
- Notebook/pen for written answers
- Computer logged into your accounts: App Inventor, Figma, email
- For HTML option: VS Code or Notepad++ open with a blank folder
- For App Inventor option: a blank project ready to name
- Browser open at: ai2.appinventor.mit.edu and/or figma.com
On test day:
- Part A written — teacher distributes question sheet. Work quietly. 40 minutes.
- Part B practical — move to computers. 35 minutes. Save work frequently.
- Part C oral — teacher calls students one by one. Show your practical work and answer 2 questions. ~5 minutes each.
Submit:
- Written answers (paper or photographed and sent)
- Screenshot of the running App Inventor app / Figma prototype link
- For HTML option: zip the folder and send via email or USB
Good luck! If you've been to the lessons, you know this material. Trust your memory and your practice.