Teachers in Graveney School are required to write reports. It is reported that it takes around 10 to 15 minutes per
teacher, on a single student???s report. This means a teacher spends an average of 5 hours, to write reports on a
single class. Creating a system to write reports would reduce the time taken for a teacher to write reports. Having
this problem solved means a reduction in stress for teachers. It will also save a lot of time, where they can be
doing something else, such as creating test for students.

The system will take data of a student through generic multiple-choice questions, and automatically create reports
and generate teacher???s comments. Each multiple-choice question will have around four to five possible selections,
with each being a phrase (two to four words), to make it as effortless as possible for the user. There will be a
minimal amount of data needed to be input by the user to reduce time taken for a report. The aim is to create a
report of an individual, using the selected phrases, for example:

This would then be used to create the report

The features of a computer system that would be required for this solution would be a computer with hardware
being able to run a suitable operating System for the software to run on.

The problem is suitable for a computational approach as reports comments are needed to be automatically
generated through multiple choice questions. This can be done using an algorithm, which can me coded. Also the
reports are electronically sent to the student???s parents.

E.g. how is {student name} effort in class?
1) Excellent
2) Good
3) Unsatisfactory
4) Very Poor

I will be carrying out one to one interview, with my stakeholders, to see why my system is needed for teachers???
problems. I will be asking one of the problems of the existing system, and the other what is needed from my
system. Later on, I will be setting up a second interview with Mr Wino to analyse the current system in hand, and
conclude the major problems with it.

Finally, I will be collecting the problems of the current system my stakeholders, Mr Wino, uses.

Why do you want this system?
It???s hard to write reports. Sometimes I don???t know what to write. I???m not great with English either. On top of that
it???s really time consuming to write reports, takes up a lot of time at home in which I could be relaxing or could be
marking test on time for my students.

What is the main thing the system needs to be able to do?
Reduce the time for us to right reports which are actually good and aren???t tedious to read. It should be able to
process a well-written comment along with clearly stating the effort and behaviour in lessons for the student.

Is a questionnaire system good idea to write reports?
It is a good idea, however as I said before, it should be able to write student comments in detail. On top of that,
there should be a minimum number of questions and they should be short questions so that they could be
answered quickly by teachers.

Is the student???s reports comments and grades required to be saved on the database (This would allow users to
review the report of the student whenever they want.)
Without it being able to save data, it would be really hard to use the program, as it would require users to
manually save it, therefore the system has to be able to store data somehow. It will also give teachers access to
view the progress in a student???s grade over time.

How do you think student data should be stored?
Teachers don???t just use one classroom, therefore there has to be a database system that can save data so that it
could be accessed on any computer, as if it was to be saved locally, most of the time we wouldn???t be able to
access the data of students that we have put into the system, and then the system would be useless.

Do you think it is useful for the system being able to create a finalised student report as a pdf?
As much as it would be great to have a system that would allow users to export the reports, the school already
has a system which is able to create reports using comments and grades, and the same system is used for other
purposes, for example it is used to register for attendance. The system is called Sims. It already has all the
students and their parents??? details stored in it and has no issues.

A problem that may occur would be that a minority of teachers may not like the system. If the school relied on
the program to create the report that is sent straight to the parents, all teachers would be required to use the
system so that their evaluation of the students could be included in the reports.

However, an option which is able to export the student???s data, which has been inputted by teachers using the
system, into a pdf file, could be a good idea as it could save time by having all the students report data needed
to be put into sims in one single file. On top of that it could be safely stored elsewhere as a backup.

Should teachers be able to view students??? progress in other classes, written by other teachers?
Yes, it will show teachers what subjects the student is strong at and if there is a change in behaviour and effort
in other classes or not.

Summary: Program should be easy to use, should be able to generate report using questions and take grades.
Users should be able to save data and export reports. Graveney School uses a system called Sims where the report
comment will be copied from the system by the user.

Planning
I will create a small survey in google form, for 10 teachers to complete, to find out if the needed features stated
by Mr Patel, is also a solution for other teachers.

Survey Illustration

Summary
The results show that most teachers do switch rooms a lot during the day, meaning the feature of a database to
store data, so that it can be accessed on any computer, is going to be necessary. They also show that it takes
most people 15 ??? 20 min to write a teacher???s assessed comment for a student. Moreover, at least one teacher,
who already has a system, said that this system is still required, and overall, most people said it is required.

Summary
I and Mr Wino communicated via emails on how the system should look like. He requires that the system has a
light colour and easy to read font sizes. He also stated that the system should show that it???s made for Graveney
School.

Each student is put into a single form class throughout year 7 to year 11, and year 12 to year 13. The student
remains in the same form. Till year 11(if in secondary) or year 13(if in sixth-form). The form classes name???s is a/ are
alphabetical letter(s). Year 12 and 13???s consists of three letters, whereas year 7 to 11???s consists of only one letter.
Form classes pupils are mixed up for lessons.

These are some problems stated by Mr Wino about the current system. It shows some examples of what I should
prevent when creating the system. One problem that I noticed using the system was you have to restart the
system every time you save your data.

The data of Class Name format was collected so that the system can validate it.

Year 7 to 11 Class Name consists of only one character

Year 12 and 13 (6th Form) Class Name consists of three characters

Summary
Solution A is a system made in excel. It is a system that is currently used by Mr Wino. Mr Wino also stated the
problems with this system in the interview.

How the system works?
The system displays multiple sentences, for teachers to select and add to the student???s comment. It is made to
solve the same probem. Its purpose is to make it easier for teachers to write report comments and reduce time
taken.

Parts I can apply to my solution
One of the features is that it substitutes the name and pronoun in the sentences as shown in Figure A_1. This is
a feature that is required for my system, for the flow of the comment and to direct it to the student its written
for.

Another feature is that it allows users to edit the students report comment. This is a good feature that is
required for the solution, as there are some specif things that maybe needed to be added into the report
comment, by the teacher, which the program may not be able to generate.

Another feature is that it allows the user to save the students name and comment, allowing them to access and
alter it whenever they want to. This is required for the solution as the stakeholder, Mr Patel, stated the system
should be implemented in such way that data should be able to be accessed from anywhere.

Parts I cannot apply to my solution
One feature is that it sorts the comments using a scroll bar and through colour coordination. This is good
feature for this system, however my system will not give an option to choose. Instead, my system in going to
focus on generate the whole comment using the answers from each multiple choice question, since the issue is
the amount of time it takes teachers to create reports, and this feature opposes the solution.

Another feature is that it has instructions for the users on how to use the system. This is a good feature
however my system should be simple enough to understand how to use after one to two uses, since the main

F i g u r e A _ 2

Order of Comment Selection
Opening, Behaviour, Progress, Strength, Weakness, Closing comment

F i g u r e A _ 1

goal is to allow users to create reports with ease and in time restrictions, therefore a help section will not be
implemented.

Another feature is that it allows users to change the listed comments permenantly, to make the system more
fitted for them. This is a good feature for this system, however as my system will be picking the comments for
the user, depending on how they answer, the user cannot modify the comments in the comment bank as it may
mean that the algorithm wont work. The user may answer something and the program may generate
something totally different due to the user altering the comment. This is not a feature needed as my program
will be speciallised for Graveney School, therefore will have all the comments needed for that school.

Summary
Solution B is a web application. It allows users to login/ create an account for free and write/ generate reports.
It shows a few sentences (less than solution A) to select, but has a lot of drop-down lists to modify the
comment. The web application offers you technical support in a variety of ways: video tutorials, written
instructions, and a feedback and support option. It doesn???t save any of your data.

Parts I can apply to my solution
One feature is that it allows users to replace the name for the pronoun, Vis versa. This is for the user to adjust
the flow of the comment, making it easier or nicer to read. My system will aim to try have the generated
comment not to have the name or pronoun repeated multiple times simultaneously. I will make use of the
pronoun choices given by this solution, in my system.

Another feature is that the user can create an account and login to use the system. This is for the user???s data for
any personal settings they have chosen to be saved on their account. In this solution, an example of data being
saved is personal comments written by the user. My solution will take a similar approach where it will allow
users to create accounts and signing to the system, to save the users data and protect it from others accessing
it.

Another feature is that the user???s login details can be saved. This is a great feature, which makes the system
much easier and user friendly, as well as reducing the time it will take a user to create a report, which is the
purpose of the solution. My solution will require this feature for this reason.

Another feature is that the user is required to write half of the comment. The system only gives the beginning
and the end of a sentence, and allows the user to write anything about the student in the middle. This does not
justify the solution as it then requires more time for the user to right the report. My system should auto
generate the whole comment, and give an option to edit the comment.

Number Feature Explanation and Justification
3 .1 The solution must
be able to run on
Windows OS

The schools??? computers run on windows operating system and all
teachers know how to use it.

Number Feature Explanation and Justification

Other details needed will be what class the student belongs to, and the
name of the student. Identifying a student to a class allows the user to
find the student in the system much faster when creating the students
report, by giving the user a filter option.

Number Criteria Justification
1 User is able to login with their email and password
to access their account

Shows a login form for user to enter their details
and open main menu. Requirements 4 and 8.1.
2 User must be able to create an account with
name, email and password

Shows a Signup form for the user to enter their
details for their account. Requirement 5.
3 User must be able to edit or delete their account
details

Shows an update account form for the user to edit/
delete their details. Requirement 9. User can open
form from main menu, requirement 8.3.
4 User must be able to create a school class with
form name and year

User opens create class form, from main menu,
where the user can create a class. Requirements 8.3
and 12.
5 User must be able to edit or delete any school
class

User opens select class form, from main menu,
where the user can edit/ delete a class???s detail.
Requirements 8.3, 13.1, 13.2.
6 User must be able to increment the year of all
school class by pressing a button

User opens select class form, from main menu,
where the user can increase all years by one,
deleting current year 13 and year 11 classes.
Requirement 13.3.
7 User must be able to create a student with
student name and class.

User opens create student form, from main menu,
where the user can create a student. Requirements
8.3 and 10.
8 User must be able to edit, share or delete any
student

User opens select student form, from main menu,
where the user can edit, share or delete a student.
Requirements 8.3, 16 and 1 1.
9 User must be able to create a report of a student
by completing a multiple choice quiz

User opens create report form from the main
menu. The user selects a student and answers the
multiple-choice questions. The user is able to create
a report. Requirement 14.
10 User must get an option to export the report as a
PDF or copy the comment

Users screen displays view report form. The user
can either read, copy or export report. Requirement
15.3
11 User must be able to view, edit and delete reports
after they have been created

User opens select student form and selects a
student. The user clicks on a report and the report
is displayed in view report form. The user can also
delete that report in select student form.
Requirement 15.1 and 15.2

Staff (StfID, FirstName, LastName, LgnID)

Login (LgnID, Email, Password)

Student (SdtID, FirstName, LastName, classID)

Report Info (RptInfoID, attendance, punctuality, grade, subject)

Class (ClassID, Name, year, StfID) //form class, a student only has one form class

Comment Bank (CmbID, type, comment, level)

Report Comments (RptID, CmbID) //stop other foreign keys from repeating over and over again

Report (RptID, attendance, punctuality, grade, subject,dateCreated, SdtID)

Here there is an illustration of the Relationship between each entity in the database. A user can only have one
account hence a one-to-one relationship between Login and Staff. A user can create multiple classes, hence a one-
to-many relationship between staff and class. A student can only be in one form class, and a class can have
multiple students, hence a one-to-many relationship between class and student. A report is created on a single
student, and a user will be able to create multiple reports on a student hence a one-to-many relationship between
student and report. A report will consist of a comment. That comment will be made up of parts from the comment
bank table. There is a many-to-many relationship between comment bank and report. Report comment table is a
linking table.

To conclude

This section sets the structure of the database. It shows the entities of the database and its attributes. It also
illustrates and explains the relationships between each entity in the database. This is an initial idea of the database
I will be using to solve the problem. Changes may occur later on in implementation, however this sets a main idea
of what my system should store and what it should do.

Report
Comment

The aesthetics of the Graphical Interface is important as it will be what the user will be interacting with to use the
system, therefore should be appealing.

Visualising the designs shows me how the application should look like, and give me a change to make any changes,
before the development stage.

Login Form

The login form is needed to complete requirement 4.1. All components are labelled correctly to its function in
the program, making it easier to use the system. It has a light colour and a big enough font to meet
requirement 6.

Error in here

The error will be displayed
here, e.g., incorrect
password. This is to
complete requirement 4.2.

The header color is #778f8f.
Font Lucida Console size 30.
System is used by one school.

Text boxes font Tahoma size 15.
Both indicate what to input in
each box.

The background color is
#bed3d3. It???s formal and
simple. Resolution is 400 by

Button to login. Font Tahoma
size 20.

Go to sign up page link. Font
Tahoma size 8.

Sign up

Signup Form

The header color is #778f8f.
Font Lucida Console size 30.
System is used by one school.

Text boxes font Tahoma size 15.
Both indicate what to input in
each box.

Button to Sign up. Font
Tahoma size 20.

The background color is
#bed3d3. It???s formal and
simple. Resolution is 400 by

Main Menu

Create Class Form

Button to open different
forms. Each button is telling
what form it will open, and
the function of it. These
Forms are created to meet
requirements 10, 11 and 12.
Font Tahoma size 16

Opens User account settings,
where the user can update
or delete account, to
complete requirement 9.
This is where the users name
will go. Font Tahoma size 14.

Font Sans Serif with size 14.
Label indicates what needs to go
inside the textbox

Font Sans Serif with size 14. Label
indicates what the values of the
combo box are.

Font Sans Serif with size 12. Button
to create class.

Create Student Form

Select Class Form

Font Tahoma with size 12. Label
indicates what needs to go
inside the textbox

Font Tahoma with size 12. Label
indicates what the values of the
combo box are.

Font Tahoma with size 8. Button to
create student.

Displays
students inside
here, font 8

Combo box and text box, font
size 12

Button font size 12

The header colour is #778f8f.

Table font size
12

Select Student Form

Update Form

Buttons with font size 8

Text boxes along with
labels of font 12

Table with font size 12

Combo Boxes with font 12.

The header color is #778f8f.
Font Lucida Console size 30.
System is used by one school.

Text boxes font Tahoma size 15.
Both indicate what to input in
each box.

Button, Font Tahoma size 20.

The background color is
#bed3d3. It???s formal and
simple. Resolution is 400 by

Create Report Form

Report Comment Form

Displays report comment in
here in font 8

Text boxes with font 18

Button font 8

Label with font 8

Label to display question with
font size 14

Text boxes with font 12

Radio buttons to select answer
with font size 18

Combo Boxes with font 12

Buttons with font size 8, general
size is around 40 by 15

Resolution is 500 by 250, forms should at least fit a 720p monitor, hence meets requirement 2. The header colour is
#778f8f. All font styles are Tahoma. It has a light colour and a big enough font to meet requirement 6. The report
comment form is needed to meet requirements 15.1 and 15.3.

After creating my initial designs for the system, I showed it to my stakeholder, Mr Wino. He was pleased
with the design and thought it is suitable for the systems purpose. He did want the report comment
form to display the student???s name. Here is an updated version of the Report Comment form...

Student Name is put here. Font
size 14.

I am creating a data dictionary to outline the requirements of values in each of the fields, needed in the tables, in
the database. This and the entity relationship diagrams set out in 2.2 will make it much easier for me to create the
database.

Purpose: This will be used to store the user???s login details so they are able to access the program.

Field
Name

Required? Data Type Sample Data Validation
Rule

Validation
Type

Description and
key field
LgnID Yes AutoNumber ??? 1 ??? Must be
unique.
Must be an
integer.

Type
check.
Presence
check.

Primary key

Email Yes VarChar ???rayaanuddin@gmail.com??? Must be
unique.

Presence
check.

Password Yes VarChar ???Rayaan10??? Must be
less or
equal to 32
characters.

Length
check.
Presence
check.

Field
Name

Required? Data Type Sample
Data

Validation Rule Validation Type Description and
key field
StfID Yes AutoNumber ???12??? Must be unique.
Must be an integer.

Type check.
Presence check.

Primary key

FirstName Yes VarChar ???Rayaan??? Must be unique. Presence check.

LastName Yes VarChar ???Uddin??? Must be greater
than 8 characters

Length check.
Presence check.

LgnID Yes Integer ???1??? Must be unique.
Must be an integer.

Type check.
Presence check.

Foreign Key

Purpose: This will be used to store the classes created by the user.

Field
Name

Required? Data Type Sample
Data

Validation Rule Validation
Type

Description and
key field
classID Yes AutoNumber ??? 3 ??? Must be unique.
Must be an integer.

Type check.
Presence check.

Primary key

Name Yes VarChar ???B??? Length must be less
than or equal to 3
Must only be
alphabetical.

Presence check.
Length check.
Type check.

Year Yes Integer ??? 7 ??? Must be a single
integer.

Length check.
Presence check.
Type check.

StfID Yes Integer ???12??? Must be unique.
Must be an integer.

Type check.
Presence check.

Foreign Key

Field
Name

Required? Data Type Sample
Data

Validation Rule Validation
Type

Description and
key field
SdtID Yes AutoNumber ??? 6 ??? Must be unique.
Must be an integer.

Type check.
Presence check.

Primary key

FirstName Yes VarChar ???Elena??? Must only be
alphabetical.

Presence check.
Length check.
Type check.

LastName Yes VarChar ???Yale??? Must be a single
integer.

Length check.
Presence check.
Type check.

Gender Yes VarChar ???Female??? Must only be
alphabetical.

Type check.
Presence check.
classID Yes Integer ???3??? Must be unique.
Must be an integer.

Type check.
Presence check.

Foreign Key

Purpose: This will be used to store the details of a report once created by the user.

Field Name Required? Data Type Sample
Data

Validation Rule Validation
Type

Description and
key field
RptID Yes AutoNumber ??? 6 ??? Must be unique.
Must be an
integer.

Type check.
Presence
check.

Primary key

Attendance Yes Integer ??? 100 ??? Value must be
less than or equal
to 100.

Value check.
Presence
check.
Length check.
Type check.

Punctuality Yes Integer ??? 95 ??? Value must be
less than or equal
to 100.

Value check.
Presence
check.
Type check.

Grade Yes VarChar ??? 8 ??? Length must be
One.

Presence
check.
Length check.
Type check.
Gender Yes VarChar ???Female??? Must only be
alphabetical.

Type check.
Presence
check.
DateCreated Yes Date/Time ???08/06/2005??? Must be format
DD/MM/YYYY

Type check.
Presence
check.
Format Check
SdtID Yes Integer ???6??? Must be unique.
Must be an
integer.

Type check.
Presence
check.

Foreign Key

Purpose: This will be used to store the comments which the algorithm will select when generating the report.

Field
Name

Required? Data Type Sample Data Validation
Rule

Validation
Type

Description and
key field
cmbID Yes AutoNumber ??? 1 ??? Must be
unique.
Must be an
integer.

Type check.
Presence
check.

Primary key

type Yes VarChar ???Opening??? - Type check.
Presence
check.

level Yes VarChar ???Green??? - Presence
check.
Type check.

comment Yes VarChar ???{name} has made
very good progress
this year, consistently
producing work of a
high standard and
displaying a
conscientious attitude
throughout each
lesson.???

Field
Name

Required? Data Type Sample
Data

Validation Rule Validation
Type

Description and
key field
RptID Yes Integer ??? 6 ??? Must be unique.
Must be an integer.

Type check.
Presence check.

Composite key

CmbID Yes Integer ??? 1 ??? Must be unique.
Must be an integer.

Type check.
Presence check.

SQL Query Justification
SELECT StfID, Email, Password,
firstname, lastname FROM Login INNER
JOIN staff ON (login.LgnID =
staff.LgnID) WHERE email = :userEmail

This will be used by the system to validate a user.
When the user attempts to login, the email will be
used to find the corresponding account in the
database. This will allow users to login to their
accounts.
Requirements met: 4.1

SQL Query Justification
INSERT INTO Login(Email, Password)
VALUES (:userEmail,:userPassword)

This stores the users email and password to the table
login in the database. It is executed in the signup
phase.
INSERT INTO
staff(LgnID,Firstname,Lastname)
VALUES (:loginID,:fname,:lname)

This stores the users name into the staff table and
references the record of the users email and
password from table login. It is executed in the signup
phase.
This allows the user to create an account.
Requirements met: 5.1

SQL Query Justification
UPDATE Staff SET FirstName=:fName,
LastName=:lName WHERE StfID=:staffID

This updates the users first and last name in staff
table. It is executed in update user detail phase.

UPDATE Login SET Email= :userEmail,
password=:userPassword WHERE
LgnID=:loginID

This updates the users email and password in table
login. It is executed in update user detail phase.

This allows the user to update their account details.
Requirements met: 9.1

SQL Query Justification
INSERT INTO class(name, year, StfID
VALUES (:cName, :cYear, :staffID)

This will be used by the system to store the class
details into the table class and reference the StfID of
the user who created the class. This will allow users to
create a class in the system
Requirements met: 12.1

SQL Query Justification

SELECT name FROM class WHERE
year=:cYear and stfID=:staffID

This will be used by the system to display users
existing classes. This will be used in many forms in the
system such as, select class, create report, create
student form. It is shown in Interface Design most
forms have a section where the user selects the class
and student on the top. This will allow the system to
assign data stored by the user to the correct student.

SQL Query Justification
UPDATE Class SET name = :cName, year
= :cYear WHERE classID = :classID

This will be used by the system to update the selected
class???s record in the table class. This will allow users to
update a class???s details in the system
Requirements met: 13.1

SQL Query Justification
INSERT INTO student(FirstName,
LastName,Gender, ClassID) VALUES
(:fName,:lName,:gender,:classID)

This will be used by the system to add a student to
the table student in the database. The class is
referenced. This will allow users to create students on
their accounts.
Requirements met: 10.1

SQL Query Justification
UPDATE Student SET FirstName =
:FirstName, LastName = :LastName
, Gender = :Gender, classID =
:classID WHERE SdtID = :studentID

This will be used by the system to update the selected
student record in student table. This will allow users
to update their student???s details.
Requirements met: 11.1

SQL Query Justification
INSERT INTO Report(SdtID, Attendance,
Grade, Punctuality, Subject,
dateCreated) VALUES (:StudentID,
:Attendance, :Grade, :Punctuality,
:Subject, :dateCreated)

This will be used by the system to store the report???s
details in the table report in the database.

INSERT INTO [Report Comments](RptID,
CmbID) values (:reportID,
:reportNumber)

This will be used by the system to assign the report
comments to the report. This is done in the Report
Comments table in the database.

This allows the user to create and save a report in the system
Requirements met: 14.1

SQL Query Justification

SELECT FirstName, LastName, Gender,
Attendance, Grade, Punctuality,
Subject, DateCreated, Name, Year FROM
Class INNER JOIN (Student INNER JOIN
Report ON Student.SdtID =
Report.SdtID) ON Class.classID =
Student.classID WHERE report.RptID =
:reportID

This will be used by the system to get the report
details by having the report id.

SELECT comment FROM [Comment Bank]
INNER JOIN [Report Comments] ON
[Comment Bank].cmbID = [Report
Comments].CmbID WHERE rptID =
:reportID ORDER BY [Report
Comments].CmbID

This will be used by the system to get the report
comments.

This will be needed in the report comment form, when displaying the report. This will allow users to view the
student???s reports; needed for the solution.
Requirements met: 15.1

PROCEDURE DatabaseLogin

IF FormEmpty THEN
ADD SQL SELECT StfID, Email, Password, firstname, lastname FROM Login INNER
JOIN staff ON (login.LgnID = staff.LgnID) WHERE email = :userEmail

IF No Records Found THEN
PRINT(???EMAIL NOT FOUND???)
ELSEIF Password_entered == Password THEN
Open MainMenuForm
ELSE
PRINT(???INCORRECT PASSWORD!???)
ENDIF
ELSE
PRINT(???COMPLETE THE FORM...???)
ENDIF

ENDPROCEDURE

This procedure will be used to validate the user, when logging in on login form. This will contribute to the overall
solution since system uses accounts as a way to assign and store data individually to each user. Having this procedure
allows the user to use the system and have its data secured.
Requirement met: 4

PROCEDURE WriteAccount

IF isValidEmail AND isValidName AND isValidPassword THEN

ADD SQL SELECT LgnID from login where email = :userEmail

IF No Records Found THEN
ADD SQL INSERT INTO Login(Email, Password) VALUES (:userEmail,
:userPassword)
SQL EXECUTE

ADD SQL INSERT INTO staff(LgnID,Firstname,Lastname) VALUES
(:loginID,:fname,:lname)
SQL EXECUTE

PRINT(???ACCOUNT CREATED!???)

CLOSE frmSignup
OPEN frmLogin
ELSE
PRINT(???ACCOUNT ALREADY EXISTS!???)
ENDIF

ENDPROCEDURE

This procedure will be used to store a user when account is created in signup form. This will contribute to the overall
solution since to use the system the user has to have an account to login and store data on.
Requirement met: 5

FUNTION isValidEmail(email)

charslist = ['_', '-', '.', '0'..'9', 'a'..'z'];
emailLen = email.LENGTH
FoundAt = FALSE
LastPoint = FALSE
Valid = TRUE

FOR i=1 TO emailLen
c=email[i]
IF c = ???@??? THEN
IF FoundAt THEN
Valid = FALSE
ELSE
FoundAt = TRUE
ENDIF
ELSEIF c = ???.??? AND FoundAt THEN
LastPoint = TRUE
ELSEIF NOT(c in charslist) THEN
Valid = FALSE
ENDIF
NEXT i

RETURN Valid

ENDFUNCTION

This procedure will be used to validate the users email when creating account in signup form. This contributes to the
overall solution since one of the requirement was data stored must be accurate.
Requirements met: 7 (updated)

PROCEDURE CreateClass

IF FormEmpty THEN
PRINT(???FILL IN THE VALUES TO CREATE CLASS???)
ELSEIF isValidClassName THEN
ADD SQL SELECT classID FROM class WHERE name = :Name AND stfID = :StaffID
AND year = :Year
IF No Records Found THEN
ADD SQL INSERT INTO class(name, year, StfID VALUES (:cName, :cYear,
:staffID)
SQL EXECUTE
PRINT(???STUDENT CREATED???)
ELSE
PRINT(???CLASS EXISTS...???)
ENDIF
ELSE
PRINT(???INVALID NAME...???)
ENDIF

ENDPROCEDURE

This procedure will be used by the system to create a class. The solution requires classes to store students in. It???s a
computational feature for the system, which organises students, making it easier for the user to search a student when
needed to.
Requirement met: 12

PROCEDURE DeleteClass(ClassID)

ADD SQL SELECT SdtID FROM student WHERE classID = :ClassID

for i= 1 to RecordCount
DeleteStudentReports(SdtID)
NEXT SQL
NEXT i

ADD SQL DELETE * FROM student WHERE classID = :ClassID
SQL EXECUTE

ADD SQL DELETE * FROM Class WHERE classID = :ClassID
SQL EXECUTE
ENDPROCEDURE

This procedure will be used by the system to delete a class. The user must be able to delete its data.
Requirement met: 13.2

PROCEDURE CreateStudent

IF FormEmpty THEN
PRINT(???FILL IN THE VALUES TO CREATE STUDENT???)
ELSEIF isValidName THEN

ADD SQL SELECT FirstName, LastName FROM student WHERE classID = :ClassID AND
FirstName = :FName AND LastName = :LName AND Gender = :Gender
IF No Records Found THEN
ADD SQL INSERT INTO student(FirstName, LastName,Gender, ClassID) VALUES
(:fName,:lName,:gender,:classID)
SQL EXECUTE
PRINT(???STUDENT CREATED???)
ELSE
PRINT(???STUDENT EXISTS...???)
ENDIF
ELSE
PRINT(???INVALID NAME...???)
ENDIF

ENDPROCEDURE

This procedure will be used by the system to create a student. This contributes to the overall solution of the problem,
since it then allows the user to create a report and on a student which is the purpose of the program.
Requirement met: 10

PROCEDURE DeleteStudent(StudentID)

DeleteStudentReports(SdtID)

ADD SQL DELETE * FROM Student WHERE sdtid = :StudentID
SQL EXECUTE

ENDPROCEDURE

This procedure will be used by the system to delete a student. The user must be able to delete its data.
Requirement met: 11.2

PROCEDURE GenerateReport

IF isReportFormValid THEN
GenerateReportComment

ADD SQL INSERT INTO Report(SdtID, Attendance, Grade, Punctuality, Subject,
dateCreated) VALUES (:StudentID, :Attendance, :Grade, :Punctuality, :Subject,
:dateCreated)
SQL EXECUTE

ADD SQL SELECT RptID FROM Report WHERE sdtID = :StudentID ORDER BY RptID
DESC

FOR i=1 TO 6
ADD SQL INSERT INTO [Report Comments](RptID, CmbID) values (:reportID,
:reportNumber)
SQL EXECUTE
NEXT i

PRINT(???REPORT CREATED???)
ENDIF

This procedure will be used by the system to create a report. This contributes to the overall solution as it allows users to
successfully create valid reports and have them saved in the database, so they can access it whenever they want.
Requirement met: 14

FUNCTION isReportFormValid

IF isFormEmpty THEN
isInvalid = TRUE
PRINT(???COMPLETE THE FORM...???)
ELSE
IF Grade.LENGTH = 1 THEN
IF NOT(isAlpha(Grade)) THEN
IF NOT(isInteger(Grade)) THEN
PRINT(???GRADE MUST BE ALPHABETICAL OR NUMERICAL???)
IsInvalid = TRUE
ENDIF
ENDIF
ELSE
PRINT(???GRADE IS A SINGLE CHARACTER???)
IsInvalid = TRUE
ENDIF

IF NOT(isAlpha(Subject)) THEN
PRINT(???SUBJECT NAME MUST BE ALPHABETICAL WITH NO SPACES???)
IsInvalid = TRUE
ELSE
IF isInteger(Attendance) AND isInteger(Punctuality) THEN
IF Attendance > 100 OR Attendance < 0 OR Punctuality > 100 OR
Punctuality < 0 THEN
PRINT(???PUNTUALITY OR ATTENDANCE IS INVALID???)
IsInvalid = TRUE
ENDIF
ELSE
PRINT(???PUNTUALITY OR ATTENDANCE IS INVALID???)
IsInvalid = TRUE
ENDIF
ENDIF
ENDIF

IsReportFormValid = NOT(IsInvalid)

ENDFUNCTION

This procedure will be used by the system to verify the report being created is valid. This is required for the overall
solution of the system, making sure data stored is accurate.
Requirement met: 14.4

PROCEDURE displayReport(reportID)

ADD SQL SELECT FirstName, LastName, Gender, Attendance, Grade, Punctuality,
Subject, DateCreated, Name, Year FROM Class INNER JOIN (Student INNER JOIN

Outlining the key variables needed for the program will make it much easier in development stage to know what
each variable is used for and what it holds. It will also let me know what data structures need to be implemented
into the coded solution.

Having variables and data structures written beforehand will also avoid any repeated code of creation of any
classes, etc.

This selection will highlight all the key variables and data structures used by the system and its data types. It will
also state if it???s a local or global variable.

Name Data Structure/
properties

Global/
Local

Description & Justification

TUserData Record Global This record is assigned to hold the users data.
This is required as the system will need to
consistently use the user???s details in different
forms.
TUserData.FirstName String Global This will hold the users first name.

TUserData.LastName String Global This will hold the users last name.

TUserData.Email String Global This will hold the users email.

TUserData.Password String Global This will hold the users password.

TUserData.StaffID Integer Global This will hold the users staff ID, which is used
to assign data to a specific user.

Name Data Type Global/ Local Description & Justification
info TUserData Global This object will hold the users details needed
thought the program, once the user logs in. It
is a global variable since it will be needed to
be used by other units.

Name Data Type Global/ Local Description & Justification
Charslist Char Array Local This array will hold all the characters a valid
email can contain. This is required to check if
email entered by user on signup phase is
valid, to meet requirement 7.
FoundAt, LastPoint,
Valid

Boolean Local These will be used to check for each
requirement of an email when validating it.
Required to meet requirement 7.

Name Data Type Global/ Local Description & Justification
Tquestion Record Global This record holds a question. This is required
to be used to efficiently store the question
and its number separately as different
attributes in an object.
Tquestion.number Integer Global This will hold the question number

Tquestion.text String Global This will hold the question itself

Name Data Structure Global/
Local

Description & Justification

Tquestion Record Global This record holds a question. This is required
to be used to efficiently store the question
and its number separately as different
attributes in an object.

Name Data
Structure/
properties

Global/ Local Description & Justification

Tquiz Class Global This class will store the questions data. This is
required as it will be the main data structure
of a single question in the questionnaire.
Tquiz.question Tquestion Global This will hold the question number and the
actual question. The constructor will add it to
the object. The constructor will set its default
value to...
Number is 0,
Text is ??????.
Tquiz.answerNumber Integer Global This will hold the number of the selected
answer i.e. number between 1 and 4. The
constructor will add it to the object. The
constructor will set its default value to 0.

Name Data
structure/
properties

Global/ Local Description & Justification

TStudentInfo Class Global This class will store the details of a selected
student by the user. This will be when the
user selects a student to edit, delete, view or
create reports on.
TStudentInfo.fName String Global This will hold the first name of the student
selected. Will be needed when editing
student or when outputting report.

TStudentInfo.lName String Global This will hold the last name of the student
selected. Saves time rather than reading it
from database multiple time. Will be needed
when editing student or when outputting
report.
TStudentInfo.year String Global
This will hold the year of the student selected.
Saves time rather than reading it from
database multiple time. Will be needed when
editing student.
TStudentInfo.gender
String Global This will hold the gender of the student
selected. Will be needed when the system
displays a report, need to be outputted in the
right pronouns.
TStudentInfo.cName
String Global This will hold the class name of which the
student is in. Saves time rather than reading it
from database multiple time. Will be needed
when editing student or when outputting
report.
TStudentInfo.id String Global This will hold the stdID from the table student
in the database which matches to the student
selected. This is required for the system to
know which student to allocate/ read data to/
from.

Name Data Type Global/ Local Description & Justification
punctuality,
attendance, grade,
subject, studentName,
dateCreated,
classNameYr

string Global These variables will be set to hold the reports
data which will be fetched in the report
comment form. The reason these are global
variables are since if the user decides to
export the report as a PDF, these variables
will be needed in the export report unit.

Name Data
Structure

Global/ Local Description & Justification

pronoun Array
string

Local This array will hold the pronouns for the
student that the comment will be displayed
for. The pronouns replace the place holders of
the comments in the database, hence it is
required for the solution.
If gender is male then [he, his, him]
If gender is female then [she, her, her]

Test
Num
ber

Test Purpose Test Data Expected Result Test
Type

Justification

1.1.1 Checking if
database can store
account details.

Login Table
LgnID: 1
Email: adam@gmail.com
Password: Adam10

Staff Table
StfID: 1
FirstName: Adam
LastName: Sandler
LgnID: 1

It accepts the
values and stores it
within the database

Valid This test is to make
sure data can be add
to the Table, and Staff
Table can reference
the Login table.

1.1.2 Checking if
referential integrity
is enforced
between Login and
Staff

Changing LgnID from 1 to 2
within staff table where StfID is
1.
Note: Record with LgnID 2
doesn???t exist

It displays error and
doesn???t change

Invalid This test is to make
sure referential
integrity is enforced.

1.2.1 Checking if
database can store
class details

Class Table
ClassID: 1
Name: F
Year: 7
StfID: 1

It accepts the
values and stores it
within the database

Valid This test is to make
sure data can be add
to the Table, and Class
Table can reference
the Staff table.
1.2.2 Checking if
referential integrity
is enforced
between Staff and
Class

Changing StfID from 1 to 2
within staff table where ClassID
is 1.
Note: Record with StfID 2
doesn???t exist

It displays error and
doesn???t change

Invalid This test is to make
sure referential
integrity is enforced.

1.3.1 Checking if
database can store
student details

Student Table
SdtID: 1
FirstName: Josh
LastName: Drake
Gender: Male
ClassID: 1

It accepts the
values and stores it
within the database

Valid This test is to make
sure data can be add
to the Table, and
Student Table can
reference the Class
table.
1.3.2 Checking if
referential integrity
is enforced
between Student
and Class

Changing ClassID from 1 to 2
within student table where
StfID is 1.
Note: Record with StfID 2
doesn???t exist

It displays error and
doesn???t change

Invalid This test is to make
sure referential
integrity is enforced.

1.4.1 Checking if
database can store
a report

Report Table
RptID: 1
SdtID: 1
Attendance: 98
Grade: A
Punctuality: 100
Subject: English
DateCreated: 26/10/2022

Report Comments
Store comments 1, 10, 15, 22,
and 26 with RptID 1.

It accepts the
values and stores it
within the database

Valid This test is to make
sure data can be add
to the Tables, and
report comments is
able to reference both
report and comment
bank.

2 .1.1 Checking if system
allows users to
login

{click login button}
Email: adam@gmail.com
Password: Adam10

The program will
display the ???main

Valid This test to make sure
that the login form
works by reading the

menu??? and ???Login
form??? will hide.

{click login button}
Email: adam123@gm
Password: Adam10

The ???Login Form???
will output ???email
not found???.

{click login button}
Email: adam@gmail.com
Password: Adam10123

The ???Login Form???
will output
???incorrect
password???.

{click login button}
Email:
Password:

The ???Login Form???
will output
???complete the
form???.

Invalid

This test is to make
sure the system
informs client why they
cannot login to the
system, when they
haven???t filled in the
form.

{click login button}
Email:
Password: Adam10

The ???Login Form???
will output
???complete the
form???.

Invalid

{click login button}
Email: adam@gmail.com
Password:

The ???Login Form???
will output
???complete the
form???.

Invalid

2. 3 Testing button is
interactive when
mouse on top

Hover mouse on top of login
button

When mouse is on
top, colour is
changed to RGB
(119,143,143).
When mouse is not
on top, colour
should be white.

Valid This test is to make
sure the button
changes colour to
indicate to the user
that it???s a button and
can be clicked. This is a
GUI test.
2 .4 Checking if login
form can open sign
up form

Click ???don???t have and account,
sign up???.

Sign up form should
appear and login
form should close.

Click on email edit box

Click on Password edit box

Click on email edit box

When user clicks on
email edit box,
???email??? should
disappear.

When user clicks on
password edit box,
???password??? should
disappear and
???email??? should

Valid This test is to make
sure the system always
gives a hint to users of
what should be
entered in the
password and email
edit boxes, when the
value is null, and
deletes the hint for the
user, instead of having

appear within email
edit box.

When user clicks on
email edit box,
???email??? should
disappear, and
???password??? should
appear within
password edit box.

the user deleting it
manually.

Type ???adam@gmail.com??? in
Email Edit box.

Click on Password Edit box.

Click on email edit box.

The value of the
email edit box will
not change when
the user clicks on
password edit box
or email edit box

Valid
This test is to make
sure the system does
not change the values
of the edit box when
the user has entered
the value in.
If it does change the
value, it will not allow
the user to login to the
system (requirement
4.1 will not be met).

Type ???Adam10??? in Password
Edit box.

Click on email edit box.

Click on Password Edit box.

The value of the
password edit box
will not change
when the user clicks
on email edit box or
password edit box.

Valid

First Name: Ryan
Last Name: Reynold
Email:
RyanReynold@gmail.com
Password: Reynold10

Click on signup button

The signup form
should create the
account and should
display message of
account created.

First Name: Ryan1
Last Name: Reynold
Email: RyanRenold@gmail.com
Password: Reynold10

Click on signup button

The signup form
should not create
the account and
should display
message invalid
name.

Invalid

This test is to make
sure the program
doesn???t create an
account, when the
values the user enters
for name is invalid, and
user is informed why
the account is not
created. This test is to
make sure
requirements 5.6 and
5.4 are met.

First Name: Ryan
Last Name: Reynold##]
Email: RyanRenold@gmail.com
Password: Reynold10

First Name: Ryan
Last Name: Reynold
Email: RyanRenold@gmail.com
Password: ReynoldsTheBest

Click on signup button

The signup form
should not create
the account and
should display
message invalid
password.

Invalid

This test is to make
sure the program
doesn???t create an
account when the
value the user enters
for password is invalid,
and user is informed
why the account is not
created. This test is to
make sure

First Name: Ryan
Last Name: Reynold

password, where
password length is
less than 8

Email: RyanRenold@gmail.com
Password: Reyno1

Click on signup button

requirements 5.5 and
5.4 are met.

First Name: Ryan
Last Name: Reynold
Email: RyanRenold@gmail.com
Password: Reynold1

Click on signup button

The signup form
should create the
account and should
display message of
account created.

Bounda
ry

This is a boundary test
to make sure password
is valid when the
length is on boundary

First Name: Ryan
Last Name: Reynold
Email: RyanReynoldgmail.com
Password: Reynold10

Click on signup button

The signup form
should not create
the account and
should display
message invalid
email.

Invalid

This is a test making
sure an invalid email
address is not
accepted by the
system.
This test is to make
sure the user is
informed when the
account is not created
and told why.
Requirement 7 met.

First Name: Ryan
Last Name: Reynold
Email:
Ryan@Reynold@gmail.com
Password: Reynold10

First Name: Ryan
Last Name: Reynold
Email: RyanReynold@gmailcom
Password: Reynold10

First Name: Ryan
Last Name: Reynold
Email: Ryan.Reynold@gmail
Password: Reynold10

First Name: Ryan
Last Name: Reynold
Email:
RyanReynold#@gmail.com
Password: Reynold10

Click on signup button

Errone
ous

First Name: Thomas
Last Name: Shelby
Email:
RyanReynold@gmail.com
Password: Thomas10

Click on signup button

The signup form
should not create
the account and
should display
message informing
user that the
account already
exists

Errone
ous

This is a test to make
sure the system does
not create accounts of
users who already
exist.
The test is also to make
sure the user is
informed that they

Email:
RyanReynold@gmail.com
Password: Reynold10

Click on Login button

The login form will
successfully login
with the valid
account. It will hide
itself and show
main menu. The
main menu will
display ???ryan
reynold??? on the top
of the menu.

Valid This test is to make
sure the system is able
to display the users
name on main menu.

Hover mouse on top of buttons
on main menu

When mouse is on
top, colour is
changed to RGB
(119,143,143).
When mouse is not
on top, colour
should be white.

Clicks on button Create Class in
Main menu

Opens Create Class
form

Class Name: B
Select Year 7

Click on Create Button
Create Class form
should create the
class and display a
message informing
the user that the
class has been
created

Valid

This test is to make
sure the user is able to
create a class using the
system.
This test is also to
make sure that the
class is stored properly
in the database by the
system.
This test is also to
make sure that classes
can be created with
the valid name length.
This test is to check if
requirement 12.1 is
met.

Class Name: BJH
Select Year 13

Click on Create Button

Checking if system
can inform user
when from is not
completed, and
does not create
account

Class Name: NULL
Does not select a year

Click on Create Button Create Class form
should not create
the class and
display message, fill
in the values to
create class

Invalid

This test is to make
sure that a class is not
created with empty
values. This is to make
sure the system
functions properly and
classes can be used to
sort students. This test
is to check if
requirement 12.4 is
met.

Class Name: NULL
Select year 7

Click on Create Button

Class Name: BL
Select Year 7

Click on Create Button

Create Class form
should not create
the class and inform
user class name is
invalid.

Bounda
ry

This test is to make
sure the system does
not create a class with
an invalid name. The
system is created for
Graveney school and
must follow the
Graveney school
procedure.
The test is to check if
requirement 12.3 is
met.

Class Name: BL
Select Year 11

Click on Create Button

Checking if system
can inform user
class name is
invalid, where year
12 class name
length is not three

Class Name: B
Select Year 12

Checking if system
can inform user
class name is
invalid, where year
13 class name
length is not three

Class Name: B
Select Year 13

Class Name: BL1
Select Year 13

Click on Create Button

Errone
ous

Class Name: B
Select Year 7

Click on Create Button

Create Class form
should not create
the class and inform
user that the class
already exists

1) Select Year 7, View Classes
2) Select Year 13, View Classes
3) Select Year 8, View Classes

1) Shows Class B
2) Shows Classes
LMN and BJH
3) Shows No Classes

Valid This test is to make
sure the form correctly
shows classes
corresponding to the
year selected by the
user, using the
database. The class is

needed to be stored to
meet requirement
10.3. The test is to
check if requirements
10.6 and 10.7 are met.

First Name: Ben
Last Name: Yale
Select Year 7 Class B
Select Gender Male

Click on Create Student Button

Create Student
form should create
the student and
inform user that the
student has been
created

First Name: Ben
Last Name: Yale
Select Year 7 Class B
Select Gender Male

Click on Create Student Button

2)TYPE
First Name: ben
Last Name: yale
Select Year 7 Class B
Select Gender Male

Click on Create Student Button

Create Student
form should not
create the student
and inform user
that the student
already exists

Click on Create Student Button

Create Student
Form should not
create the student
and should inform
user the form is not
filled out.

Invalid

This test is to make
sure the system
collects all values it
needs before creating
the class, so the
system can function
properly.
The test is to make
sure the user is
informed if the form is
not fully filled out.
This test is to ensure
requirement 10.3 is
met.

First Name:
Last Name: Yale
Select Year 7 Class B
Select Gender Male

First Name: Ben
Last Name:
Select Year 7 Class B
Select Gender Male

First Name: Ben
Last Name: Yale
Select Year 7
Select Gender Male

First Name: Ben
Last Name: Yale
Select Gender Male

First Name: Ben
Last Name: Yale
Select Year 7 Class B

First Name: Ben1
Last Name: Yale
Select Year 7 Class B

Click on Create Student Button

The Create Student
form should not
create the student
and should display
message invalid
name.

Invalid

This test is to make
sure the program
doesn???t create a
student, when the
values of the student???s
name is invalid, and
user is informed why
the account is not
created. This test is to
make sure
requirement 10.5 is
met.

First Name: Ben
Last Name: Yale##]
Select Year 7 Class B

Click on Create Student Button

Enter Letter ???A??? in
cboselectyear

The Create Student
form should just
display select year

Click on setting button on main
menu

Main menu should
display the form
with the users
values displayed
within the edit
boxes, apart from
password

Valid This test is to make
sure the main menu
can open the update
setting form.

Not changing any details
Typing the original password:
Adam1010

Click Update Button

The Update Student
Form should update
the email and
change it within the
database. It should

Valid This test is to make
sure the user is able to
update their accounts
when they are only

then display a
message to user
regarding the
changes taken
place.

Change Email value to
Adam1@gmail.com

Other values keep same...
Name: Adam Sandler
Type Password: Adam1010

Click Update Button

The Update Student
Form should update
the email and
change it within the
database. It should
then display a
message to user
regarding the
changes taken
place.

Valid This test is to make
sure the system allows
users to update their
details. This test is to
check if requirement
9.1 is met.

Change Email value to
ryanrynold@gmail.com

Other values keep same...
Name: Adam Sandler
Type Password: Adam1010

Click Update Button

The Update Student
Form should not
update the account.
It should inform the
user that the
account already
exists.

Change Email value to
Adamgmail.com

Other values keep same...
Name: Adam Sandler
Type Password: Adam1010

Click Update Button

The Update Student
Form should not
update the account.
It should inform the
user that the email
entered is invalid.

Keep Values the same
Name: Adam1 Sandler
Type Password: Adam1010

The Update Student
Form should not
update the account.
It should inform the

Invalid This test is to check the
validation of name
from signup is working
with update setting

Click Update Button user that the name
entered is invalid.

form. If the test is a
success, it means the
name validation is
working, since the
algorithm has already
been tested in Stage 3.
This test is to check if
requirement 9.2 is
met.

Keep Values the same
Name: Adam Sandler###
Type Password: Adam1010

Click Update Button

Invalid

Keep Values the same
Type Password: Adam

Click Update Button

The Update Student
Form should not
update the account.
It should inform the
user that the
password entered is
invalid.

The Update Setting
form should delete
all data of the user.
It should delete all
reports, students,
classes, and the
users??? staff record
and login.

Click on delete button
Then No

The Update Setting
form should not
delete the account
and shall just return
back to the form.

Valid This test is to make
sure the system is able
to prevent accidental
deletion of an account.
The purpose of the test
is to confirm the No
button does not delete
the account.

In signup form...
First Name: jEfE
Last Name: willIAMS
Email: Jeff@gmail.com
Password: Jeff1000
Press signup

The System should
make sure the
name in database is
stored as Jefe
Williams

In Select Class form...
Select class Name L Year 8

The Select Class
form should display
the 2 students,
Holly and Andy

Valid This test is to make
sure the system is able
to show the user which
students are in the
class. This feature is

which are in the
class.

In Select Class Form...
Select filter by year
1) Select year 7
2) Select year 9

1) The Select Class
form???s table should
display Class A
2) The Select Class
form???s table should
display no classes

In Select Class Form...
Select Class A Year 7
Press Delete
Press yes

The Select Class
form should delete
the class along with
all the students and
their reports.

In Select Class Form...
Select Class L Year 8
Class name K
Class year 11
Update The Select Class
form should update
the class and notify
the user. It should
then also refresh
the table.

Valid

This test is to make
sure the user is able to
update the classes???
values. This test is to
make sure
requirement 13.1 is
met.

In Select Class Form...
Select Class L Year 8
Class name K1
Class year 13
update
The select class
form should not
update the class,
and inform the
user.

Invalid

This test is to make
sure the system does
not allow any invalid
data within the
database. If the form is
able to verify this
correctly, then it will
verify and find all
invalid possible values,
since the form uses the
same procedure used
by Create Class Form,
which was already
been tested.

In Select Class Form...
Select Class L Year 8
Class name
Class year Any Year
update

In Select Class Form...
Select Class L Year 8
Class name: A
Class year 8
update

The select class
form should not
update the class,
and inform the user
the class already
exists

Invalid

This test is to make
sure the system can
prevent data
redundancy. This is not
only for the efficiency
of the system, but also
to make sure the

In Select Class Form...
Select Class L Year 8
Class name: R
Class year 11
update

The Select Class
form should update
the class and notify
the user. It should
then also refresh
the table.

Valid

Pressing the button named
btnIncrementClasses
The Update Setting
form should delete
all year 11s and 13
classes and
increment the class
year by 1.

valid

Year 12|LAL|Mellad Bagbhan

Grade B| Attendance 97|
Punctuality 92|Computing

1a|2b|3b|4a|5a|6b

The create report
form should be able
to create a report
by following the
algorithm, and save
it in the database.

Valid

Year 9|A|[unselected]

Other values selected randomly
The form should be
able to inform the
user that the form
is not complete, by
displaying a user-
friendly error
message. The form
should not create a
report.

Invalid

These tests are to
make sure the form is
complete and all
values entered by the
user are valid before
creating the report.
This test is to make
sure a suitable error
message is displayed to
user if there is an issue
with the data they
have inputted. This
test is to check if
requirement 14.4 has
been met.

Keep only attendance empty

Keep only punctuality empty

Keep only subject empty

1) Having punctuality as 123
2) Having attendance as - 12
3) Having attendance as A12

The form should
display message to
user, informing the
value is invalid and
not create the
report

Invalid

1) Inputting value 10
2) Inputting value AC
3) Inputting value #
Invalid