Computer Science — 3rd Year (Mathematics-Physics-Technology track)

The complete Computer Science — 3rd Year (MPT) curriculum, on Akaguriro Academy: the official Burundian syllabus, covered in full, term by term, like a real school year.

Computer Science A3 MPT — from your first line of C to a working school network

This course follows the exact structure of the Burundian curriculum for the Mathematics-Physics-Technology track. It builds up step by step across three terms: first the C programming language from scratch, then relational databases and Microsoft Access, and finally computer networks — all illustrated with real, complete case studies (a bar-restaurant's ordering system, a media library's database, a school's network setup) and graded assignments with detailed rubrics.

🎯 Course goals

• Master the entire Computer Science A3 MPT syllabus as taught in Burundi.
• Write, compile and debug real C programs: variables, operators, conditions, loops, functions.
• Design a relational database from an entity-relationship model through to real SQL queries and a working Microsoft Access database.
• Understand how computer networks actually work: hardware, topologies, the OSI and TCP/IP models, email protocols, and IP/MAC addressing.
• Practice with corrected exercises and random-question quizzes on every chapter, plus 5 full real-world integration cases as graded assignments with detailed rubrics.

📘 Detailed syllabus — 31 sections, exercises and quizzes, over 3 terms

Term 1 — The C programming language (12 sections)

1. The basics: compiling and running your first C program
2. Types and variables in C
3. Operators in C
4. Conditions: if, if...else
5. Conditions (continued): switch, booleans
6. Loops: while, do...while, for
7. Unconditional branching: break, continue, goto
8. Creating a function
9. Calling a function and building a personal project
10. Integration — synthesis of the term
11. Integration case: computerizing a bar-restaurant's ordering system (graded assignment)
12. Integration case: calculating a total price including tax (graded assignment)

Term 2 — Databases and Microsoft Access (10 sections)

1. Introduction to databases: DBMS and data models
2. The entity-relationship model
3. Graphical modeling of the entity-relationship model
4. Relational algebra: selection, projection, union, intersection
5. The SQL language: real practical queries
6. Introduction to Microsoft Access: creating a table
7. Creating a database with Access: queries
8. Integration — synthesis of the term
9. Integration case: managing a media library, an 8-table real schema (graded assignment)
10. Integration case: building an invoicing system, a 4-table real schema (graded assignment)

Term 3 — Computer networks (9 sections)

1. Introduction to computer networks
2. Building a network: the hardware (cables, wireless, network card, hub, switch, router)
3. Network architecture and topologies (PAN/LAN/MAN/WAN, bus/ring/star)
4. Communication protocols and the OSI model
5. The TCP/IP model
6. Email protocols: SMTP, POP3, IMAP4
7. IP and MAC addresses, address classes and subnet masks
8. Integration — synthesis of the term
9. Integration case: networking a school's computers, real IP address classes and subnet masks (graded assignment)

Every chapter includes its lesson and a random-question practice quiz; the 5 integration cases are graded assignments (mod_assign) with a detailed marking guide, reflecting the exact official grading rubric.

🎓 Learning format

• 📖 Lessons, organized exactly like the real school year, with real code, database schemas and network case studies throughout.
• ✅ Corrected exercises for every chapter, and random-question practice quizzes.
• 💻 Real worked examples — actual C programs, real database schemas, real network addressing plans — not abstract theory alone.
• 📝 Graded assignments for the 5 integration cases, with a detailed grading rubric visible to the teacher.
• 💬 Forum, chat and private messaging to ask a question anytime, without waiting for the next class.
• ♾️ Unlimited access over time after purchase — review one specific chapter the night before a test, or go through the whole year again from the start.