final project documentation Computer studies, High school final essays of Computer science

Download final project documentation Computer studies and more High school final essays Computer science in PDF only on Docsity! Bill Maker Page No. 1 PROBLEM /TASK IDENTIFICATION Brief Description of the Problems in terms of IPO Akram Traders & Super Store has been in the field for the last four years. Mr. Muhammad Akram successfully runs it. The store deals in every kind of product & accessories. Muhammad Akram is also helped by five of his workers. The store is run quite nicely but sometimes the problems of calculations occur as registers and hard calculations are maintained so sometimes when making large bills a lot of time may be consumed and as a result the customer may become irritated. Also due to negligence wrong prices may be used due to which miscalculation may occur. The processing would also take a lot of time as the customers would want a certain amount of discount on the product so a lot of time will be consumed. Also there would not be any record of transaction due to which the workers can alter the accounts. The output would be a piece of paper on which the bill details would be written manually in which errors can occur. Bill Maker Page No. 2 Form of Data INPUT The new system would be a lot more organized and user-friendly. It would also be less time consuming. The list of data input in the new system would be: 1. NAME 2. PRODUCT 3. QUANTITY 4. PRICE 5. DISCOUNTS  The PROCESSING The processing would take place automatically and only the prices and quantity would be input and the system would produce the results automatically.  OUTPUT Required The output would be in the form of a computerized printed receipt, which would be having every single detail of the transaction. Bill Maker Page No. 5 DATA Structure Field Type Size in characters Size in bytes Remarks Receipt no. Numeric 4 Primary key Date Date 8 Name Text 20 20 Product Text 15 15 Quantity Numeric 4 Price Numeric 4 Total Numeric 4 Discounts Numeric 4 Grand Total Numeric 4 Size of a single record 67 bytes For 1000 records 67 x 1000 = 67000 = 67 KB. Bill Maker Page No. 6 Processes Validation Field Name Validation Test Receipt no. Should be numeric, in sequence Date Valid and logical date Customer name Should be in text, also should be in length of 25 characters Product It should consist of text and having a length of up to 20 characters Quantity Should be numeric, and having a range of 3 characters Price Price should be numeric and should be within 4 characters Discounts Should be numeric data, also should be within 3 characters Calculations Total = Quantity * Price Grand Total = Total - Discounts Etc. Bill Maker Page No. 7 Flow Diagram YES NO Input of transaction & related items Validation ERRO R Passwor d EXIT BILL File Calculation of Bills Print OUTPUT Screen OUTPUT Corre ct Bill Maker Page No. 10  Proof of Files This is the picture of the text file where the record will be saved Viewing the records in the text file through notepad Bill Maker Page No. 11 Searching in the bill Form for the Customer Name All the output, or all the bill details of the desired person will be shown on original add member Form Inputting the data to search Press this button to open the search box Bill Maker Page No. 12 Program Code Refer to chapter 5. Note on the relationship of program with design Relation of Programme with design: As the annotated programme listing will show, the programme uses the design that was given in section 2: Description of how to solve The main menu is output on the screen and the input is taken as selection of user. Once an option is selected, it jumps to the corresponding module. All the working is based on the original ideas.  To calculate, the user of the program provides the information data and a calculated value is output.   To calculate, the the data is used in the formule given and after validation, they desired operation is carried out. The result is sent to the module which converts decimal numbers to binary, which is output as the final answer. Finally, as decided before, all the output is given as text. Bill Maker Page No. 15 Field Name Reason of Validation Normal, Abnormal, Extreme Proof/ coding Problems or Comments Expected Result Actual Result Quantity Character Check Normal 3 45 67 19/29 Placing a character check was quite a difficult task for me; I had made reference to books on Visual Basic to guide me. Message Box rejecting invalid data Message Box rejecting invalid data Abnormal fgdg Extreme 11111111111 99999999999 00000000000 Price Character Check Normal 59 577 1056 19/29 Message Box rejecting invalid data Message Box rejecting invalid data Abnormal d Placing a character check was quite a difficult task for me; I had made reference to books on Visual Basic to guide me. Message Box rejecting invalid data Message Box rejecting invalid data Extreme 11111111111 99999999999 00000000000 Bill Maker Page No. 16 Field Name Reason of Validation Normal, Abnormal, Extreme Proof/ coding Problems or Comments Expected Result Actual Result Discoun ts Character Check Normal 65 8 123 19/29 Placing a character check was quite a difficult task for me; I had made reference to books on Visual Basic to guide me. Message Box rejecting invalid data Message Box rejecting invalid data Abnormal dssaa Extreme 11111111111 99999999999 00000000000 Name Presence Check Normal Ahmed Omar John 20/27 The Presence check did not have much problem with at all since I’ve placed presence checks before, using Visual Basic. Message Box rejecting invalid data Message Box rejecting invalid data Abnormal (Blank) Extreme (Any word up to 20 characters long) Bill Maker Page No. 17 Field Name Reason of Validation Normal, Abnormal, Extreme Proof/ coding Problems or Comments Expected Result Actual Result Product Presence Check Normal Shampoo Surf Toffees 20/27 The Presence check did not have much problem with at all since I’ve placed presence checks before, using Visual Basic. Messagebox rejecting invalid data Messagebox rejecting invalid data Abnormal (Blank) Extreme (Any word of 15 characters) Price Presence Check Normal 22 954 4661 20/27 Message box rejecting invalid data Messagebox rejecting invalid data Abnormal (Blank) The presence check was rather simple to place. Extreme (Any 5 numbers) Quantity Presence Check Normal 5 283 4323 20/27 The Presence check did not have much problem with at all since I’ve placed presence checks before, using Visual Basic. Message Box rejecting invalid data Message Box rejecting invalid data Abnormal (Blank) Extreme (Any 4 numbers) Bill Maker Page No. 20 BILL FORM Character Check Name Bill Maker Page No. 21 Character Check on Product Character Check on Quantity Bill Maker Page No. 22 Character Check on Price Character check on Discounts Bill Maker Page No. 25 Length Check on Discounts Bill Maker Page No. 26 CHAPTER 5 TECHNICAL DOCUMENTATION  Description of Data and File Used Field Name Data Type Data Length Name String 20 Product String 15 Price Signed Integer 4 Quantity Signed Integer 4 Total Signed Integer 4 Discounts Signed Integer 4 Grand Total Signed Integer 4  How to Password Protect The password protecting system provided is not a very complex one. There is one password, which cannot be changed, and it is Project, including the capital P. If you would like to change the password, you must go into the coding of the Password form and edit it there. To do this double click on the enter button when the form is not loaded, then go to the part where it says “To Create a Password,” there where it says If Text1= “Project” Then, change the “Project” to the desired password, but please note, that the new password must be within the quotation marks just like the word Project is.  Security Measures A bill calculator contains many private details of several people, thus a certain amount of protection should be granted to prevent unauthorized users from viewing, or misusing these details. Therefore a password option has been provided. The password is: car. The password should be exactly that. This should guarantee safety to some extent. Another precaution that you the user can take is to make a back up of the text file where the contacts are saved. Bill Maker Page No. 27 Program Annotation ‘bill form coding done by me in compute lab of school ‘bill form calculates the bill of the item sold through the bill ‘information of the bill is saved in the file bill1.dat it is txt file containing data. ‘record set is created to save the data ‘an array is created to save the data in memory array. ‘Searching is provided Bill Calculator Form 'The billRecrmation for the Record set Private Type billRec RecieptNo As Integer crDate As String * 9 custName As String * 20 Product As String * 15 Quantity As Integer Price As Integer Total As Integer Discounts As Integer GrandTotal As Integer End Type 'creating Array of 1000 bills in memory Dim billFile(1 To 1000) As billRec '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 is to be used for the counter Dim count2 As Integer Dim recno As Integer SEARCH BUTTON Private Sub Command10_Click() 'Search First Name i = 1 count2 = 1 a = InputBox("Enter customer name", , "Ali") End Sub NEW BUTTON Private Sub Command2_Click() Text2 = Date recno = recno + 1 Bill Maker Page No. 30 disp (i) 'Call display function to show first record MsgBox NumberofRecord End Sub Private Function disp(i As Integer) Text1 = billFile(i).RecieptNo Text2 = billFile(i).crDate Text3 = billFile(i).custName Text4 = billFile(i).Product Text5 = billFile(i).Discounts Text6 = billFile(i).GrandTotal Text7 = billFile(i).Quantity Text8 = billFile(i).Price End Function VALIDATION CHECK ON NAME Private Sub Text3_LostFocus() If IsNumeric(Text3) Then MsgBox "please enter a valid name" Text3 = "" Text3.SetFocus End If 'Length Check If Len(Text3) > 19 Then MsgBox "Text is too long" Text3 = "" Text3.SetFocus End If End Sub VALIDATION CHECK ON PRODUCT Private Sub Text4_Change() If IsNumeric(Text4) Then MsgBox "please enter a valid product name" Text4 = "" Text4.SetFocus End If 'Length Check If Len(Text4) > 15 Then MsgBox "please enter the data within length" Text4 = "" Text4.SetFocus End If End Sub Bill Maker Page No. 31 VALIDATION CHECK ON DISCOUNTS Private Sub Text5_Change() Text6 = Val(Text9) - Val(Text5) 'Length Check If Len(Text5) > 4 Then MsgBox "please enter the data within length" Text5 = "" Text5.SetFocus End If End Sub Private Sub Text5_LostFocus() If Not IsNumeric(Text5) Then MsgBox "please enter discounts in numeric" Text5 = "" Text5.SetFocus End If End Sub VALIDATION CHECK ON QUANTITY Private Sub Text7_LostFocus() If Not IsNumeric(Text7) Then MsgBox "please enter quantity in numeric" Text7 = "" Text7.SetFocus End If 'Length Check If Len(Text7) > 4 Then MsgBox "please enter the data within length" Text7 = "" Text7.SetFocus End If End Sub Main Menu Form Private Sub Command1_Click() 'To open the password form Me.Hide Form1.Show End Sub Private Sub Command2_Click() 'Exiting the program End End Sub Bill Maker Page No. 32 VALIDATION CHECK ON PRICE Private Sub Text8_Change() If Not IsNumeric(Text8) Then MsgBox "please enter price in numeric" Text8 = "" Text8.SetFocus End If 'Length Check If Len(Text8) > 4 Then MsgBox "please enter the data within length" Text8 = "" Text8.SetFocus End If End Sub TOTAL Private Sub Text9_Click() Text9 = Val(Text7) * Val(Text8) End Sub PASSWORD FORM Private Sub OK_Click() 'to create a password Dim res As Integer res = pass(Passwordtxt) If res = 1 Then Me.Hide billcalc.Show Else MsgBox "you are not authorised" End End If End Sub Private Function pass(password As String) As Integer If password = "car" Then pass = 1 Else pass = 0 End If End Function Bill Maker Page No. 35 Running the Program To run the program, just double click on the following icon. This will start the program and then you may do what you wish with the program. The first form will look like this: The second form will look like this: After pressing the OK button the bill calculator form will show up: Click here to enter the project Click here to exit the project Insert Password After putting in password click OK to move to next form Click here to move back to previous form Bill Maker Page No. 36 Type in the name of the customer The name of the product required The quantity in which product is needed The price of the required product The total, which automatically comes when we click on total column when quantity and price is put in Discounts are put in here The final grand total box Provides with a new bill record Takes us to the first, next, previous, and last records of the file Allow you to open a place in the file for you to type in the details of the contact. Provides us with the facility to search Saves the record in the text file Prints out the receipt to customer Takes us back Bill Maker Page No. 37 Search Customer Form Screenshot Problems that Occurred I had encountered several problems in the creating this software. Firstly, I had problem with my new button, as it didn’t showed a new record. After that, when I saved the records in the ‘DAT’ file they didn’t occurred there but the problem was solved afterwards. A problem with the password option occurred, I was unable to program it to be the password of the users liking, and thus it has a fixed password, which is car. Another problem that occurred, was that I had tried to make my next and previous buttons give error messages when they reached the End Of File, which worked only on the previous button, and to disable the Previous button once the end of file was reached. It did disable, the problem was that it did not enable itself after that. Inputting the data for search All the desired results or output will be shown in the original form The Search button