Practical Project I – SS3 Digital Technologies Lesson Note (Third Term)
Lesson note at a glance
- Class
- SS3
- Subject
- Digital Technologies
- Term
- Third Term
- Reading time
- 5 min
A practical project in Digital Technologies is a working system, such as a library website or a database, that solves a real problem for real users.
Behavioural objectives
By the end of the lesson, students should be able to:
- State the problem their project solves and who will use it.
- Write a one-page project proposal with a title, objectives and tools.
- Draw a wireframe, a flowchart or an Entity-Relationship Diagram (ERD) for a project.
- Build a project in stages, starting with the small parts.
- Test a project and write a project report.
What are the stages of a practical project?
A practical project has five stages: plan, design, build, test and report.
- Plan: choose a real problem, name the users and write a proposal.
- Design: draw wireframes and a flowchart or ERD on paper.
- Build: make the small parts first, then join them.
- Test: try to break your own project and fix the bugs.
- Report: write the document you submit with the project.
How do you plan a project?
Planning means deciding what problem you will solve and who will use your system before you write any code or create any table.
Answer these two questions first:
- What problem am I solving? Example: “Students find it hard to check library book availability.”
- Who is going to use it? Example: “The Librarian and the Students.”
What is a project proposal?
A project proposal is a simple one-page plan that states what you will build and how.
- Title: the name of the project, for example Greenwood High Library Manager.
- Objectives: what the system should do, such as search for books, register new members and track borrowed books.
- Tools: what you will use, such as HTML/CSS for a website or MS Access for a database.
How do you design the interface?
Interface design means planning how each screen will look, and you do it on paper before you use the computer.
A wireframe is a simple sketch of a screen that shows where each item will go.
- For a website: decide where the logo goes and where the navigation buttons go.
- For a database: decide how the data entry form will look and whether it is easy to type into.
User Experience (UX) tip: keep it simple.
- If a user must click 10 times just to find a “Home” button, they will get frustrated.
- A frustrated user will stop using your app.
How do you design the logic?
Logic design means planning how information moves through your system, and the diagram you draw depends on the type of project.
What is a flowchart?
A flowchart is a diagram that uses shapes and arrows to show the steps and decisions in a process.
- Use: for a website or app.
- Question it answers: what happens when a user clicks “Submit”?
- Example: if the password is wrong, where does the app take the user?
What is an Entity-Relationship Diagram (ERD)?
An ERD is a diagram that shows the tables in a database and how they are linked.
- Use: for a database.
- Example: the Student table must be linked to the Books Borrowed table.
- Link: the tables share a field, such as Admission Number.
How do wireframes, flowcharts and ERDs differ?
| Diagram | What it shows | Used for |
|---|---|---|
| Wireframe | Layout of a screen | Websites, apps and database forms |
| Flowchart | Steps and decisions | Websites and apps |
| ERD | Tables and their links | Databases |
How do you build the project?
Building means turning your designs into a working system, and you do it by making the small parts first.
- The skeleton: create your basic folders and files, for example index.html and style.css.
- The data: for a database, create your tables first and set the primary key of each, such as Admission Number.
- The connection: use your code (JavaScript) or your database queries to make the parts work together.
Common mistake: making the project look “beautiful” before it works.
- Make it function first.
- Add the colours and fonts later.
A primary key is a field that identifies each record in a table in a unique way.
How do you test a project?
Testing means trying to “break” your own project so that you find and fix bugs before the user does.
- The stress test: enter wrong data, such as a name in a “Phone Number” box, and see whether the system gives an error or crashes.
- The user test: give the project to a classmate and explain nothing.
- User test result: if they cannot work out how to use it, the design needs work.
What is a project report?
A project report is a written document, submitted with the project, that explains the problem, the system and how to use it.
- Problem statement: the problem the project solves.
- System requirements: the kind of computer needed to run it.
- User manual: a “How-To” guide with screenshots.
- Conclusion: what you learned and what you would add if you had more time.
Project checklist
- Plan: solve a real problem.
- Design: draw it on paper first.
- Build: make it work before making it look good.
- Test: fix the bugs before the teacher sees them.
Evaluation
- What two questions must you answer before you start a project?
- List the three parts of a project proposal.
- What is a wireframe, and why should you draw it before using the computer?
- Which diagram would you draw for a database, and which for a website or app?
- Describe the stress test and the user test.
Assignment
Choose a real problem in your school or community. Write a one-page project proposal with a title, objectives and tools. Then draw a wireframe of your main screen and list the parts of the project report you will submit.
This term's Digital Technologies topics
SS3 Third Term · 4 topics

