Easier to read with cream paper, a tint, more contrast or larger text? Choose your colours and text, once, for every page.

Preview

Unit 6 B3: Testing a database with a test plan

This is the first page of the lesson. Read it and have a go at the activities. The rest is in the full lesson.

50 minutes

Ten is just too young

Oakfield Youth Club is made up. Its members must be 11 to 19. A volunteer tests the new form with an age of 14. It works, so she says it is finished.

Then a member of 10 is added by mistake. Nobody tested the edge. A test plan (a table of tests) makes sure the important cases are tried and written down.

By the end of this lesson

Note

I can write a test plan (a table of tests) with test data (the values you try) and use the results to improve my tables.

Key words

WordWhat it means
Test plana table of tests, with what should happen in each
Test datathe values you try in a test
Normal datatest data that should be accepted
Boundary datatest data right on the edge of a limit
Erroneous datatest data that is wrong and should be refused
Functionalitywhether each part does its job
Usabilityhow easy a system is to use

The cells students fill in are left blank in this preview.

Starter: what you already know

Have a go

Starter: what you already know

4 questions
Have a go: your answers are marked here and then forgotten. Sign in if you would like your score kept, and to pick up where you left off.Sign in to keep your score

Your answers are marked here and are not kept. A college account keeps every student’s marks.

Testing checks two things

Testing functionality asks: does each part do its job? Does the form save a record? Does the age limit refuse a wrong age?

Testing usability asks: is it easy to use? Ask other people to try it, and listen to their feedback. A person who did not build it sees problems you cannot.

Worked example: a test plan

NoTestTest dataExpectedActualPass or fail
1Add a memberAge 14AcceptedAcceptedPass
2Lowest ageAge 11AcceptedAcceptedPass
3Just too lowAge 10RefusedAcceptedFail
4Wrong ageAge 150RefusedRefusedPass

The cells students fill in are left blank in this preview.

Check

Have a go

Check

3 questions
Have a go: your answers are marked here and then forgotten. Sign in if you would like your score kept, and to pick up where you left off.Sign in to keep your score

Your answers are marked here and are not kept. A college account keeps every student’s marks.

The lesson goes on

8 more parts of this lesson are in the full lesson, which colleges teach from the Library. A college account gives your students all of it.