Download computer studies Final project documentation for O level standard. and more Essays (high school) Computer science in PDF only on Docsity!
______________________________________________________________________
Problem/Task Identification
Brief Description of the Problem to be solved
The company sells footballs of different sizes. Presently, the records of sales are stored
in a Register. At times, the salesman does not even remember to enter the sales records.
The bill is produced by a write up. Each sale transaction is written down on a bill and it is
given to the customer. A carbon copy is also produced simultaneously.
A great confusion is created at the end of the day when the owner, Jack Wolfskin, reviews
the sale transactions. This is so due to carelessness of the salesman by not entering all
sale transactions and by not storing the ones, which are produced.
While producing the bill, a calculator is needed to workout the total amount to be paid and
the total amount of footballs being sold. This present way is irritating for the customers, as
it is time consuming and very vulnerable total calculation mistakes.
Thus resulting a long que at the sales point and very angry customers.
Data Input
At the moment, all the bills are produced by writing them down on a paper. And
then storing that data in a register.
The records to be input are: Date, Customer Name, Customer Number, Football
Type, and Quantity.
Required Output
The total list of all transactions carried out for the specific sales days is needed to be
appropriately laid out.
The records to be output are: Total Quantity, Total amount.
______________________________________________________________________
Program Design
Description of How to solve the problem
In order to solve the problem, the whole present system needs to be computerised. A
program will be created to replace the present system.
To create such a program, a software Ms Visual Basic will be used. This is a user-friendly
program and it will have the potential to create an appropriate program.
All valid details about each sale will be filled on the form, which will act as an electronic
bill. The salesman just needs to fill in the required details.
All the calculations will be done by the new system. Thus the salesman would need to
consult a calculator, and inevitably making mistakes and time wasting.
A save option will be given so that the salesman can save the valid data and use it for
further consulting with the owner. All the sales transactions will be saved on a disk for safe
storage and the disk will be kept in a secure compartment.
Initially, the salesman would forget to fill in the all the required details on the bill, leaving
out relevant information.
So this system would have a validation, “Empty Check”. This informs the salesman to fill
in all details. Therefore all relevant information will be saved and no further confusions
would occur.
______________________________________________________________________
Input Design
Great Balls of Fire Incorporated TM
Receipt No.
Customer Name
Contact Number
Date
Time
Type
A
Size 3 Size 4 Size 5
Size 6
Type
B
Size 3 Size 4 Size 5 Size 6
Type
C
Size 3 Size 4 Size 5 Size 6
Quantity
Quantity
Quantity
Total Quantity Total Amount ($)
______________________________________________________________________
Output Design
Processes
Validation
Customer Name Presence check: to ensure that the Customer
Name is entered.
Type check: to make sure that the correct type of
data is entered.
Contact Number Presence check: to ensure that the Contact
Number is entered.
Type check: to make sure that the correct type of
data is entered.
Quantity A Length check: makes sure that the quantity does
exceed the required limit.
Quantity B Length check: makes sure that the quantity does
exceed the required limit.
Quantity C Length check: makes sure that the quantity does
exceed the required limit.
Calculation
Total($) A/B/C = Price of Football($) * Quantity A/B/C
Total Quantity = Quantity A + Quantity B + Quantity C
Total Amount = Total($) A + B + C
Great Balls of Fire Incorporated TM
Receipt No. X
Customer Name XXXXXXXXX
Contact Number XXXXX
Date XX/XX/XX
Time XX:XX
Type
A/B/
C
Size 3 Size 4 Size 5 Size 6 Quantity X
Total Quantity
X Total Amount($) X
______________________________________________________________________
Flow Chart
Exit
Input of Football
type, size and
quantity
Validation
Calculation of
Total quantity
and Cost
Screen
Output
Error
Print output
(Bill/Receipt)
Yes
No
Password
______________________________________________________________________
Program Development
Features of Visual Basic
I used VB professional edition version 6.00 because file handling in Visual Basic
is easier for not only programming, but for users. This is because it is the object
orientated programming, and since it is in the GUI (Graphical User Interface)
format, it is much easier for the users.
Method of Creating the Solution
Objectives Procedure
Search
System
Using an “If” condition and “Do While”, I created a counter
through which if the text in the text field is the same as a
record in the text file, then it will display the data in the text
fields, else it shall add 1 to the counter and search again, and
display a message stating that no such record exists.
Next/Previous
Buttons
The next and previous buttons work through a simple “If”
statement to ensure that it does not reach the end of file, and
a simple counter that will decrease or increase depending on
whether it is going to the next or previous record.
Create Button In the “Form_Load”, a file is created and opened, the create
button simply, makes a space in the text file using a counter,
while when the button is pressed clicked upon, the counter
adds 1 to itself giving new space for the entry of data.
Save Button This button simply takes the data in the text fields and inserts
them in the text file where all the other records are.
Password
Verification
The verification simply takes place through an “If” statement, if
the text in the text field is equal to “Project”, it will allow the
user to pass to the next form, else it will present an error
message.
Character
Check
This was done by using an “If” statement checking the keys
pressed by the user, the program will only allow certain keys
to be pressed, otherwise it will present an error message.
Presence
Check
Here, “If” statements were used to check if any data was
entered in the fields, otherwise it would pop an error message
telling the user that the text fields are empty.
Length Check This was accomplished by using an “If” statement, that would
check the number of characters present and see if they are
under the conditions given, otherwise it will give an error
message stating that the text is too long.
______________________________________________________________________
How to search for a record
When a record is located this is the output
______________________________________________________________________
Test Strategy
Test Plan
Field Name Type of
Validation
Test Data:
Normal,
Abnormal,
Extreme.
Expected Result Remark
Receipt No. - - Automatic -
Date - - Automatic -
Time - - Automatic -
Customer
Name
Type Check Ammar
*&^%
Should be Accepted
Should NOT be Accepted
Should NOT be Accepted
Wrong type of Data
Wrong type of Data
Contact
Number
Type Check 12345
a
Should be Accepted
Should NOT be Accepted
Should NOT be Accepted
Wrong type of Data
Wrong type of Data
Quantity A Length
Check
Should be Accepted
Should NOT be Accepted
Should NOT be Accepted
Wrong type of Data
Wrong type of Data
Quantity B Length
Check
Should be Accepted
Should NOT be Accepted
Should NOT be Accepted
Wrong type of Data
Wrong type of Data
Quantity C Length
Check
Should be Accepted
Should NOT be Accepted
Should NOT be Accepted
Wrong type of Data
Wrong type of Data
Price of
Football($) A
Price of
Football($) B
Price of
Football($) C
Total($) A - - Automatic -
Total($) B - - Automatic -
Total($) C - - Automatic -
Total Quantity - - Automatic -
Total
Amount($)
______________________________________________________________________
Length Check on Quantity A/B/C
______________________________________________________________________
Test Results
Field
Name
Test Data:
Normal,
Abnormal,
Extreme.
Expected Result Actual
Results
Remark
Receipt No. - Automatic -
Date - Automatic -
Time - Automatic -
Customer
Name
Ammar
*&^%
Should be Accepted
Should NOT be Accepted
Should NOT be Accepted
Accepted
Rejected
Rejected
Wrong type of Data
Wrong type of Data
Contact
Number
a
Should be Accepted
Should NOT be Accepted
Should NOT be Accepted
Accepted
Rejected
Rejected
Wrong type of Data
Wrong type of Data
Quantity A 50
Should be Accepted
Should NOT be Accepted
Should NOT be Accepted
Accepted
Rejected
Rejected
Wrong type of Data
Wrong type of Data
Quantity B 50
Should be Accepted
Should NOT be Accepted
Should NOT be Accepted
Accepted
Rejected
Rejected
Wrong type of Data
Wrong type of Data
Quantity C 50
Should be Accepted
Should NOT be Accepted
Should NOT be Accepted
Accepted
Rejected
Rejected
Wrong type of Data
Wrong type of Data
Price of
Football($) A
Price of
Football($) B
Price of
Football($)
C
Total($) A - Automatic -
Total($) B - Automatic -
Total($) C - Automatic -
Total
Quantity
Total
Amount($)
______________________________________________________________________
Bill Form
Date is displayed. It is
automatically generated
when the New button is
selected.
Displays the time at
the Point of sale. It
is automatically
generated when the
New button is
selected.
Displays receipt
number, which identifies
each bill. It is
automatically generated
when the New button is
selected.
Customer Name
is entered here.
Customer’s
contact
number is
entered here.
Calculates the
total by multiplying
the quantity with
the price.
Calculates the
sum of all
Amounts and the
quantities.
Closes the Form
and opens the
MainPage form. Allows salesman
to enter a
Customer name
and search for
his/her record.
Displays
the First
record,
which was
entered.
Displays
the Last
record,
which
was
entered.
Allows the
salesman to
enter a New
record.
Quantity is
entered
here.
A size is selected
from each type of
Football: A/B/C.
Saves the record,
as a Dat file. The
saved record is
displayed in a
Notebook file.
______________________________________________________________________
Security Measures
When the program is being used. Only authorized people are given a user name
and password. And they can access the records using that.
Data is definitely important and thus a password system is used to protect it.
When the incorrect username/password is entered
The
username is
entered here
The salesman’s
assigned password
is entered here
This button checks
whether the
username/password is
correct. And if it is,
then the program
starts running.
______________________________________________________________________
Program Annotation
Coding for Bill Form
This form is based on a Bill system. It enables the user to enter relevant data and all the
calculations are done by the system to produce the required outcome. The user is given
options to Save, Open, Select Previous and Following records and to Search for a
record.
'The ballsRecrmtion for the Record Set
Private Type ballsRec
receipt As Integer
Date As String * 15
Time As String * 15
Name As String * 30
Number As Long
quantity As Integer
total As Integer
qtya As Integer
qtyb As Integer
qtyc As Integer
pricea As Integer
priceb As Integer
pricec As Integer
totala As Integer
totalb As Integer
totalc As Integer
End Type
'Creating Array of 150 balls in memory
Dim ballsFile(1 To 150) As ballsRec 'The array in which the data is saved
Dim NumberofRecord As Integer 'integer variable to hold total no of records
Dim i As Integer 'integer i to be used for the counter
Dim count2 As Integer
Private Sub Command10_Click()
'To view the Previous Customer
i = i - 1
If i >= 1 Then
disp (i) 'Call display function to show previous record
Else
i = 1
MsgBox "Beginning Of File"
End If
End Sub
Private Sub Command11_Click()
'To view Last Record
i = 1
disp (i) 'Call display function to show last record
End Sub
______________________________________________________________________
