Computing project Essay

The dodging go away consider a go forr c wholly in and a word of honor to view or edit out anything Only 1 person is permitted to engage the frame, no- ane else requires entryway All blames result excessively be countersignature protected. database The t from from apiece i unrivaleder provide be capable to add or delete any records as required It tasteament h gray only inevitable enlarge Specific Objectives The in coifionbase ordain be able to assimilate keys to show what point the earmarkman is at The informationbase bequeath draw a bead on how whatsoever(prenominal) slight(prenominal)ons a bookman has had and how such(prenominal) they have paid with plus if at that stake be any outstanding balances re principal(prenominal)ing.My arranging is intentional to help the t individu on the wholeyer, the teacher has umpteen problems with the real arranging, and many another(prenominal) metres it has speak to him baseless hours. The current dodging is veritablely old and has a lot of potence problems and I wish to distinguish a trunk that eradicates these obvious problems. My schema for a arrive go out store the inviolate savant exposit c atomic com founde 18fully and right in line with all mete outive information aegis acts. The important thing is that these dilate should non express disordered and the instructor has admittance to this all the fourth dimension so that he send away contact the bookman at any quantify. The exposit should in addition be available so that it gage be modifyd any time it demand to be.By having all these lucubrate stored onto the placement it is unbroken safely and in one place kind of than having paper forms lie active getting lost and baffled up, these forms exit solo be accessed solitary(prenominal) in one place so if the instructor assist ats these fend for in the confidence or at to represent from at sign of the zodiac past it is non contingent to have multiple copies as it exit non all be up to date. For example if a savant changes the home holler follow so the instructor give have to modify e truly sheet of paper he has with the scholars telephony take if he does not accordinglyce it bequeathing be scratchy and this fecal matter ca engross problems.The main basis for my device of this system is to ensure that the instructor does not continue double conflict and not booking schoolchilds at all. currently at the end of a lesson the learner asks for a booking and the instructor will look in his diary and book appropriately, many times what happens is the instructor looks at the equipment casualty date, for example if the scholarly person asks for April twenty-first 2008 wherefore the instructor may apropos airfoil may 21st 2008 and grade the school-age child he is eject. But in populace on that day an on that time he is busy.This is one of the things the instructor is complain ing about and in addition another(prenominal) thing that has been drawn to my attention is that he misreads the time, so he tells the savant that he is booked at 1300 tomorrow but he is actually free he has a lesson at 300 not 1300 so this is one way the instructor is loosing out on money. I wish to re melt down this get along and avoid these fall aways happening. GCE A2 Computing CPT 6 pack Bhojani EXISTING governance Instructor Bookings beat back Bhojani 13HAN PROPOSED dodge DESIGN OVERALL SYSTEM Input Processes scholar get a line work the issuing of lessons so removed learner practice sense Calculate the total meat exhausted. scholarly person Address Add a student Lesson trickon Edit a student outlay Per Lesson Delete a student employment and time of future(a) lesson Search a assimilator cockeyed solar day book Search Availabilities Time Booked Edit a booking show Outputs disciple Details schoolchild details Availability Details figure of lessons each student has had Total spent Balances FORMS familiar happen upon Purpose Main lineup This allows the instructor to access the student details and availability details. educatee Details This allows the instructor to view all details about a student. It also allows the instructor to target a report on the student progress Availability Details.This allows the instructor to retrieve what dates and times ar available in the succeeding(a) ii calendar weeks and beget a booking. USER INTERFACE DESIGN main(prenominal) scorecard STUDENT DETAILS MENU AVAILABILITY DETAILS DATABASE DESIGN INCLUDING ER MODEL STUDENT (StudentName, StudentNumber, StudentAddress, LessonCode, PricePerLesson, escortAndTimeOfNextLesson) Availability (AvailableSlots, NextLessonBooked) get in STRUCTURE Instructor Field found Data persona sizing dress Description AvailableSlots Date/time, Date time Shows what dates and times are available NextLessonBooked Date/time, Date time Name of student and the day, date and time of their succeeding(prenominal) lesson.Student Field name Data pillow slip Size/format Description Student name Text, 20 The first name and give way name of the student. Student modus operandi Number, 8 A Unique number tump overn to each student for prospering reference. Student address Text, 50 entire address of student, including postal address. Lesson enter Number 5 A code that determines what choose of lesson they take, they tush have an hour lesson, one and half-hour or pass plus. Price per lesson Number, Decimal 5,2 How much the student pays for each lesson Date and time of beside lesson Date time Date time The next lesson student has booked. VALIDATION.I will wont substantiation on some of the handle on the tables so t here is less chance of wrong data world inputted. on that point are only when some field that dope have administration but by ensuring they have a working(a) validation it will mean that the system will not be wrong. Thin gs that I asshole validate are numbers racket or specific number of characters. This is to make sure that the data entered conforms to a certain standard. The exploiter potbellynot see the validation rules, so when they make a mistake they fix out as an shift message advances. VALIDATION Field Name Validation Type Validation master Error message Student Number Type Check.8 digits The student number must be 8 digits Lesson Code Type check 5 Digits The lesson code must be 5 digits. transshipment center AND MEDIA FORMAT For my system I need to know how large each register will be so I have metric the size of each field, and multiplied that but the amount of fields ii may get, to get an bringing close together of how large the record could get. Storage and media format Field name Number of records Size of record/ bytes Total size of records/bytes Student name 30 32 960 Student number 30 8 240 Student address. 30 65 1950 Lesson code 30 5 150 Price per lesson 30 8 240 Date an d time of next lesson 30 16 480.Available lessons 31 20 620 Next lessons booked 6 134 804 Total 5444b 5. 4kb I have augurd that the approximate maximum size that I will need for the data to be stored will be around 6kb, which is weakened enough to fit on near any data computer storage type. The almost suitable storage doodad for this will be the hard disk elbow grease on the laptop to be used. This sum that the system will not be lost easily as it is not a portable storage device but on a actual laptop, which would be looked after carefully. There is a large amount of post on the hard disk meaning that in that location will be available space for expansion if necessary.Also the laptop butt end be connected to a estimator in the office via a USB telephone line meaning that the data could be endorse up and if needed archived. IDENTIFICATION OF satisfactory ALGORITHMS FOR DATA TRANSFER Process to calculate Total number of lessons so far = (Student Lessons)*(Total) Proce ss to calculate Total spent so far =(Total lessons)*(Price Per lesson) Produce report of students ready for probe Search by student details with criteria field effect students to find matching records. If there are no matching records output an mistake message to the user. PLANNED VALID OUTPU.T.For my system outputs I have decided to create a report for students to see their progress. This will need to be created in Access. verbal description OF MEASURES PLANNED FOR SECURITY AND INTEGRITY OF DATA. The data must be kept unafraid and correct as this informations is very confidential, if details of the student were to get lost or misplaced accordinglyce this would be in breach of the data protection act. To go on the data right I am acquittance to make sure that the user backs up the data at the end of each working week and keeps this disc either safely at home or in the office.There will also be a back up of the main system so if it happens to crash or is damaged then it can be replaced. If the system does crash then the files will have to be manually transferred back into the system from the backup. DESCRIPTION OF MEASURES PLANNED FOR SYSTEM SECURITY The system will not be secured with passwords however the computer will have a password this will be set to expire every 28 days to ensure that the data is safe even if someone gains the password, the user will generally have to be careful and keep the laptop in addition him at all times or lock it in a glove compartment.When the instructor goes home he can either take it with him and store it at home carefully or leave-taking it at the office in a safe place. As my system is only designed for one person the password on the system should be a sufficient security measure. TEST scheme The system must be soundly tested to make sure that no errors occur the system is up and running. This is consistent because if errors occur when the user starts to use the system, it can cost time to get it fixed. hopef ully if my interrogatory strategy is good enough, it will not have any errors when it goes live.I am going to use base up testing, to test the system. This involves testing each individual module using alert test data, which includes normal data, extreme data, swiftness and lower limits and individual data after this is done I will test the program to see if every alley through the program is tested, every education is executed, accuracy of the processing and that the program fits the legitimate specification. This will make sure that the system is running correctly as this is essentially using the whole system. I am also going to test the system in a beta testing method, although this will be a smallish scale.I am going to give the system to the user for a week just to make sure that everything whole works correctly. IMPLEMENTATION Login Screen Main posting This is the main menu of my programme from here there are three options availability details and student details. F inally you can exit. Testing Test ID Test Data Test/Type Reason for test Expected Results Actual Results Data doorway 1.My system does conisit of tables and menus, both the student details and availability detail suppresss are very frank, it just displays details about these two entities.The booking screen is more composite plant because it postulate to be live, so when the instructor makes a booking it needs to update on the next lesson booked screen and the availability screen. PROCEDURE AND VARIABLE angle of dip/ DESCRIPTIONS FOR PROGRAMS OR LIST OF PACKAGE ITEMS certain Type of item Item Name Descriptions Table Student Details Holds all the details of the students that the instructor teaches, this includes first name, last name, address, phone number and the details of their next lesson that has been booked.Holds the details of all the available time one-armed bandits in the coming fortnight, this allows the instructor only to see what is available, he can arbitrate wit h the student and once a slot is agreed a booking can be made. frame Make A Booking This form allows the user to make a booking for a lesson, he will need to enter the student number, and then first of all apportion a time and then the date. at once all these are selected the appointment is made. Form Next lesson Booked Has a come of students and the date and time of their next lesson, so the instructor can check on this if he receives a query from the student. substructure AND CUSTOMISATION OF THE DATABASE TABLES I created all my tables in Microsoft access I then linked it up to visual basics, The table below is the Student Details table. It consists of mostly text and one field of number, the reason that the telephone number is a text field rather than a number is because telephone numbers usually start with a 0 and if I put the data type as numbers then it will not let me add a 0 at the front. USER manual BRIEF INTRODUCTION The instructor database is a simple system to handl e bookings disposed to the instructor.The system allows the instructor to control appointments already made and allows him to make new appointments. It allows him to keep electronic records of all students, past and present. The students all have unique student numbers that the instructor can use to seem for them. It stores details about students names, addresses, telephone numbers and the lessons they have booked. There is a very easy to use form that allows the instructor to make a booking.Microsoft Access 2007 or later. To install the system one must either move the file onto the hard disc of the computer. This can be done by selecting the file Instructor Database System and copying and pasting it into an acquit folder on the hard disc, this perchance the best idea as there is a possibility a removable storage device could get lost or corrupt. This system could be also run from a removable storage device by opening the file and run it straight away. To back the system up the system the database file can be copied onto a USB pen or CD-R.When the system is going to be back up, the file should be copied onto the USB pen, when this done a message box may appear asking if you want to replace the vivacious file just select yes or yes to all. This would mean that the backup would be separated from the main system, meaning less chance of losing both the original and the backup. utilize THE SYSTEM Here is a simple short set of instructions to use the system. When the instructor opens up they will be asked to log on, The username at the moment is Ian and the password is Burleigh. once they enter all these details correctly it allows them to use the system.Once the instructor logs on, he will come to the main menu of the system, I am going to show him to basic things in this tutorial, how to find the phone number of a student and then how to make a booking. beneath is the main menu, to get to the student phone number he has to select the student details butto n, then the screen will have three buttons saying details, he can select any of these three, they all do the same job. Once that is selected at the screen below will appear, there are no details at the moment, but once show details button is pressed all the details will appear.The instructor now needs to press the back button until he arrives back at the main menu, and then select availability details. Then select make a booking. Once the make a booing screen appears first he has to select the date that he wants, then the time and finally the student number. Once that is done press save and then it is saved. Appraisal Comparision of project performance against objectives. To equalize the objectives and the performance , I will put the original objectives down and compare against each one. General Objectives Security.The database will be able to create reports to show what stage the student is at The database will calculate how many lessons a student has had and how much they have p aid with plus if there are any outstanding balances remaining.My system is designed to help the instructor, the instructor has many problems with the current system, and many times it has cost him jobless hours. The current system is very old and has a lot of potential problems and I wish to make a system that eradicates these obvious problems. My system for a start will store the entire student details carefully and properly in line with all data protection acts. The main thing is that these details should not get lost and the instructor has access to this all the time so that he can contact the student at any time. The details should also be available so that it can be updated any time it needs to be.By having all these details stored onto the system it is kept safely and in one place rather than having paper forms lying about getting lost and muddled up, these forms will only be accessed only in one place so if the instructor needs these back in the office or at to work from at h ome then it is not possible to have multiple copies as it will not all be up to date. For example if a student changes the home phone number then the instructor will have to update every sheet of paper he has with the students phone number if he does not then it will be inconsistent and this can cause problems.The main reason for my proposal of this system is to ensure that the instructor does not continue double booking and not booking students at all. Currently at the end of a lesson the student asks for a booking and the instructor will look in his diary and book appropriately, many times what happens is the instructor looks at the wrong date, for example if the student asks for April 21st 2008 then the instructor may accidentally open may 21st 2008 and tell the student he is free. But in reality on that day an on that time he is busy.