Table of Contents
Analysis
Background to/Identification of the Problem 1
Identification of the prospective user 2
Justification of the chosen Solution 2
Questionnaire 2
Identification of the user needs and Acceptable Limitations 3
Realistic Appraisal of the feasibility if potential solutions 3
Entity Relationship Diagram 3
Data Sources and destinations 4/5
Summary of existing system 6
Problems with existing system 6
Objectives of the project 6 General Objectives 6
Specific objectives 6
Data Flow Diagram of current system 7
Data Flow diagram of proposed system 8
Design
Overall System 9
User Interface Design 10
Database Design Including ER Model 11
Record Structure 11/12
Validation 13
Storage Media and Format 13/14
Identification of suitable algorithms for data transformation 14
Planned Valid Output 15
Description of Measures Planned for security and integrity of Data 15
Description of Measures Planned for System Security 15
Test Strategy 16
Implementation
Main Menu Screen Prints 17
Availability Details Main Menu 18
Make A Booking Screen Print 19
Next Lesson Booked Screen print 20
Availabilities Screen Print 21
Student details Screen Print 22
Testing
Design of test plan 23
Annotated hard copy of test plan 25
Minimal set of test data 32
System Maintenance
System Overview 33 Procedure and variable developed 33
Creations and customisation of the database 34
Tables 34
Relationships 37
User Manual 38
Appraisals 47
User Feedback 49
BACKGROUND TO/ IDENTIFICATION OF PROBLEM
The present system is very inefficient, when a student wishes to book a lesson the instructor has to get out his diary check the dates that are available and book in the student. After the lesson the instructor has to update his student book, he has to write in what the student did in the lesson, how they found it, whether they paid or not. Occasionally the instructor will add up how many lessons that the student has had and jot this down. This is a waste of time, as the instructor cannot book a student until he has finished all the paper work, this usually takes about 15 minutes after each lesson.
In a day the instructor ends up wasting around 2 hours after the lesson updating his books. I wish to change the way this works and I want to make the whole system work around the computer to decrease the time wasted, I want to programme the computer to do half the jobs that the instructor currently has to do, I wish to change the 15 minutes to 5 minutes and also provide the instructor with useful information such as pass rates, average lessons needs, average cost for student and how many lesson each student has had. This will help the instructor a lot by saving him time and also providing this information that he can use to improve some things.
JUSTIFIACTION OF THE CHOSEN SYSTEM.
There are many ways in which I can get information from my user, some common ones being, taking an interview, performing a questionnaire or observing my user. If I were to take an interview of the prospective user then it would be difficult for me, I would have to write down what he tells me very quickly and carefully. This can be time consuming and there are possibilities that I could miss some vital information that the user tells me. Also when taking an interview the user may not tell everything that he wants and in some cases the interviewee are not honest. This would mean that the system I make would not be as useful as it could be. So I have decided that taking an interview of the user will not be effective and I need to consider other methods to get the information.
Can also observe my user
I however this also has it's limitations as I will only be getting the information on how he runs and operates with the old system and I will not know if he wants anything in the new system to make his job easier. It would be difficult to observe the instructor as it will distract both him and his student, therefore the only other method would be a questionnaire. So for this identification I will pass a questionnaire to the user and I will look at other methods in other areas of my project. I have asked my user a few questions that will aid me in the production of his system below are the results.
QUESTIONNAIRE RESULTS
How many lessons do you have a day?
This depends on demand; usually I do about 7 lessons however on Saturday s and busy periods I squeeze in 9lessons.
Ideally how much time would you like to spend after every lesson to update books?
I do waste a lot of time updating my records, after a lesson I allow half an hour to update books and time to reach my next student. I spend about 15 minutes of that time updating records; it would be brilliant if this were to come down to 10 minutes.
Do you think providing each student with a card that you can scan to book and start lessons would be a good idea?
No I don't think this would be a practical, students will lose these cards costing me money to replace them, another option would be for me to keep the cards and scan them when I need to. However I think we are short for space in the car to have a barcode scanner.
Are you able to use programmes such as access to record all data?
Yes I have had training on this, this is what they use in the office to book in us instructors, so yes it would be ideal if I were able to use access to store and interpret all the data.
Would you like a printer in your car to print out reports for students?
Again I think that the space is an issue we could set up all this in the boot of my car but I believe that it would be more practical if I had these facilities at home or in the office so the students can enjoy the facilities of a report without the inconvenience.
Will you be the only user?
Yes I will be the only user to access the details and your software, it would be necessary to have it password protected for data protection purposes.
Can you use software such as access to input and view data?
Yes I have had training on this, this is what they use in the office to book in us instructors, so yes it would be ideal if I were able to use access to store and interpret all the data
How often would you be looking at updating your system?
Really I don't mind the longer it lasts the better, however it would be nice to update to the new versions of access every time they are released, usually the new versions become more and more user friendly so this should save me time.
IDENTIFICATION OF THE USERS NEEDS AND ACCEPTABLE LIMITATIONS
After considering the answers I have received I have found out that the user wants a system that will save his time, it must be easy to use and it needs to be user friendly. The instructor wants to have all data of his students stored; this needs to be made considering data protection violations. The instructor want something that he can have transaction done on, ideally a database that will do transactions, that include calculate a cost, update availability for next lesson and update the file with student lesson.
The instructor would be very grateful if we were to include something that will show him statistics easily, draw reports and he is able to see progress easily. I will be producing a prototype that will have limited data but the instructor can try it out and see if this is what he wants.
REALISTIC APPRAISAL OF THE FEASIBILITY OF POTENTIAL SOLUTIONS
There are many ways I can solve the problems of the current system, I think upgrading it so that every thing is based around a computer to save time. I think I will be ...
This is a preview of the whole essay
The instructor would be very grateful if we were to include something that will show him statistics easily, draw reports and he is able to see progress easily. I will be producing a prototype that will have limited data but the instructor can try it out and see if this is what he wants.
REALISTIC APPRAISAL OF THE FEASIBILITY OF POTENTIAL SOLUTIONS
There are many ways I can solve the problems of the current system, I think upgrading it so that every thing is based around a computer to save time. I think I will be using Visual Basic express to do this, as this is the program that will allow me to do more things. This will also meet the criteria of the prospective user, and I will be able to include things like adding and editing student details. Viewing making appointments, this will mean that it will fulfil all the criteria for the user and my system will aid the instructor in doing day-to-day jobs more effectively. The system can be used on a laptop that the instructor carries with him in the car so that he can access all the details and do everything he could possibly need to do from the car itself. This will mean there are fewer chances of making mistakes and it will all be based around a real time situation. This can also be accessed in the office pc.
ENTITY RELATIONSHIP
DATA SOURCE AND DESTINATION
Student
Field name
Type, Max range
Example
Description
Student name
Text, Char (20)
John Smith
The first name and last name of the student.
Student number
Number, Char (8)
22147859
A Unique number given to each student for easy reference.
Student address
Text, Char (50)
Hay Close, Bath, B12 5DS
Full address of student, including postal address.
Lesson code
Number (5)
22567
A code that determines what sort of lesson they take, they can have an hour lesson, one and half-hour or pass plus.
Price per lesson
Number, Decimal (5,2)
£19.00
How much the student pays for each lesson
Date and time of next lesson
Text/ Number
1/11/07.13.00
The next lesson student has booked.
AVAILABILITY DETAILS
Instructor
Field name
Type, Max range
Example
Description
AvailableSlots
Date/time, Variable
Friday 01/02/08 13:00
A day, date and time of an availability
NextLessonBooked
Char, Date/time, Variable
D.S Stewart
Tuesday 29/01/08 09:00
Name of student and the day, date and time of their next lesson
SUMMARY OF EXISTING SYSTEM
Currently the instructor receives booking either by telephone or at the end of the lesson. Once a booking is received he puts this in his diary and writes on the student's appointment card the date, time and day of the next lesson. At the end of the lesson the instructor brings out the students folder which he carries with him for the day, at the start of the day he checks his diary to see what students he has and gets all their folders. He updates the student folder by adding 1 to the total lessons and writes what he has taught today, what the student did well and what they were weak at. The instructor allows 15 minutes after each lesson to do this. Once he has done this he updates his account book by writing down how much the student paid, and what method of payment was used. Once all this is done he heads for the next student, at the end of the day he has to go back to the office and pass on all the details about how many lessons, how much money was paid and what the student was taught. He is required to type all this up and save it on the system for reference.
PROBLEMS WITH EXISTING SYSTEM
The problem with this system is that it is time consuming and is tedious. The instructor has too much paper work to do which compromises on the time they can give to students, if the 15 minutes per lesson is calculated this soon adds up to hours and days of wastage. By computerising the system half the time will be wasted in collecting and passing on the data. The diary is not a very reliable way of writing appointments and if the instructor were to forget the diary or loose it then it would be impossible to continue with the day. The student folders are not very secure and loosing them would be breach of the data protection act and this could be a costly mistake so clearly it needs to be upgraded to save time and for security.
OBJECTIVES OF THE PROJECT
General Objectives
Security
* The system will require a user name and a password to view or edit anything!
* Only one person is permitted to use the system, no-one else requires access
* All files will also be password protected.
Database
* The instructor will be able to add or delete any records as needed
* It will hold all necessary details
Specific Objectives
* 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 paid 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 home 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. This is one of the things the instructor is complaining about and also another thing that has been drawn to my attention is that he misreads the time, so he tells the student that he is booked at 13:00 tomorrow but he is actually free he has a lesson at 3:00 not 13:00 so this is one way the instructor is loosing out on money. I wish to remove this issue and avoid these mistakes happening.
GCE A2 Computing
CPT 6
Ram Bhojani
EXISTING SYSTEM
Instructor Bookings | Ram Bhojani 13HAN
PROPOSED SYSTEM
DESIGN
OVERALL SYSTEM
Input
Processes
Student Name
Calculate the number of lessons so far
Student Number
Calculate the total amount spent
Student Address
Add a student
Lesson Code
Edit a student
Price Per Lesson
Delete a student
Date and time of next lesson
Search a Student
Day Booked
Search Availabilities
Time Booked
Edit a booking
File
Outputs
Student Details
Student details
Availability Details
Number of lessons each student has had
Total spent
Balances
FORMS
General Name
Purpose
Main Menu
This allows the instructor to access the student details and availability details.
Student Details
This allows the instructor to view all details about a student. It also allows the instructor to print a report on the student progress
Availability Details
This allows the instructor to see what dates and times are available in the next two weeks and make a booking.
USER INTERFACE DESIGN
MAIN MENU
STUDENT DETAILS MENU
AVAILABILITY DETAILS
DATABASE DESIGN INCLUDING ER MODEL
STUDENT (StudentName, StudentNumber, StudentAddress, LessonCode, PricePerLesson, DateAndTimeOfNextLesson)
Availability (AvailableSlots, NextLessonBooked)
RECORD STRUCTURE
Instructor
Field name
Data type
Size format
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 next lesson
Student
Field name
Data type
Size/format
Description
Student name
Text,
20
The first name and last name of the student.
Student number
Number,
8
A Unique number given to each student for easy reference.
Student address
Text,
50
Full address of student, including postal address.
Lesson code
Number
5
A code that determines what sort of lesson they take, they can 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 next lesson
Date time
Date time
The next lesson student has booked.
VALIDATION
I will use validation on some of the fields on the tables so there is less chance of wrong data being inputted. There are only some fields that can have validation but by ensuring they have a working validation it will mean that the system will not be wrong. Things that I can validate are numbers or specific number of characters. This is to make sure that the data entered conforms to a certain standard. The user cannot see the validation rules, so when they make a mistake they find out as an error message appears.
VALIDATION
Field Name
Validation Type
Validation Rule
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.
STORAGE AND MEDIA FORMAT
For my system I need to know how large each file will be so I have calculated the size of each field, and multiplied that but the amount of fields ii may get, to get an estimate of how large the file 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
950
Lesson code
30
5
50
Price per lesson
30
8
240
Date and time of next lesson
30
6
480
Available lessons
31
20
620
Next lessons booked
6
34
804
Total
5444b
5.4kb
I have calculated that the approximate maximum size that I will need for the data to be stored will be around 6kb, which is small enough to fit on almost any data storage type.
The most suitable storage device for this will be the hard disk drive on the laptop to be used. This means 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 space on the hard disk meaning that there will be available space for expansion if necessary. Also the laptop can be connected to a computer in the office via a USB cable meaning that the data could be backed up and if needed archived.
IDENTIFICATION OF SUITABLE ALGORITHMS FOR DATA TRANSFER
Process to calculate Total number of lessons so far
= ([Student Lessons])*([Total])
Process to calculate Total spent so far
=([Total lessons])*([Price Per lesson])
Produce report of students ready for test
Search through student details with criteria field Ready students to find matching records. If there are no matching records output an error message to the user.
PLANNED VALID OUTPUT
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.
DESCRIPTION OF MEASURES PLANNED FOR SECURITY AND INTEGRITY OF DATA.
The data must be kept secure and correct as this information's is very confidential, if details of the student were to get lost or misplaced then this would be in breach of the data protection act. To keep the data secure I am going to make sure that the user backs up the data at the end of every 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 besides 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 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 STRATEGY
The system must be thoroughly tested to make sure that no errors occur the system is up and running. This is logical because if errors occur when the user starts to use the system, it can cost time to get it fixed. Hopefully if my testing strategy is good enough, it will not have any errors when it goes live. I am going to use bottom up testing, to test the system. This involves testing each individual module using prepared test data, which includes normal data, extreme data, upper and lower limits and individual data after this is done I will test the program to see if every route through the program is tested, every statement is executed, accuracy of the processing and that the program fits the original specification. This will make sure that the system is running correctly as this is basically using the whole system. I am also going to test the system in a beta testing method, although this will be a small scale. I am going to give the system to the user for a week just to make sure that everything works correctly.
IMPLEMENTATION
Login Screen
Main Menu
This is the main menu of my programme from here there are three options availability details and student details. Finally you can exit.
Testing
Test ID
Test Data
Test/Type Reason for test
Expected Results
Actual Results
Data Entry
.
[StudentID] 11457848
Ensure data entry of 8 numbers is possible
'11457848' stored
AS EXPECTED
2.
[StudentID] 114578484584
No more than 8 numbers allowed
Error message too many digits
AS EXPECTED (See Screen Dump 1)
3.
[StudentID] Null
Erroneous Data
Error Message, please enter number
AS EXPECTED
4.
[Name] Sean
Ensure data entry possible
'Sean' Stored
AS EXPECTED
5.
[Name] 'aaaaaaaaaaa'
Extreme Data
Data Stored
AS EXPECTED
6.
[Address] 125 Buckingham Avenue.
Ensure I can add address
Data Stored
AS EXPECTED
7.
[Address] 'aaaaaaaaa'
Extreme Data
Data Stored
AS EXPECTED (See screen dump 2)
8.
[Town] Manchester
Ensure data entry possible
Data Stored
DATA REJECTED, VALIDATION INCORRECT NEEDS CHANGING (See Screen Dump 3)
9.
[PostCode] MA32 6TR
Ensure data entry possible
Data Stored
AS EXPECTED
0.
[PostCode] 'aaaaaaaaaa'
Extreme Data entry possible
Data Stored
AS EXPECTED
1.
[PostCode] MA326594D
Ensure that it rejects this too many characters
Data Rejected
AS EXPECTED
2.
[Telephone] 0113 2669079
Ensure data entry is possible
Data Stored
AS EXPECTED
3.
[Telephone] 'aaaaaaaaaa'
Extreme Data
Data Stored
AS EXPECTED
4.
[Telephone] 00154 8794649
Ensure it rejects too many numbers
Data Rejected
AS EXPECTED (See Screen Print4)
5.
[Date] '21/03/2008'
Ensure data is stored
Data Stored
AS EXPECTED
6.
[Date] '20/14/2008'
Ensure it rejects this incorrect date
Data Rejected
AS EXPECTED (See screen Print 5)
7.
[Time] '12:00'
Ensure data is stored correctly
Data Stored
AS EXPECTED
8.
[Time] '26:00'
Ensure it rejects this incorrect data
Data Rejected
AS EXPECTED (See screen print 6)
Screen Dump 1
Minimal Set of Test Data
Student Details
Student Details
Student Number
Student Name
Student Address
Student Telephone Number
1457848
Sean Higgins
25 Buckingham Avenue, Bath, BA15SS
0015 8794649
2147894
Harry Atkinson
32A Church Street, Manchester, MA326TR
0248 6497466
21347418
Katy Buckland
36 Burleigh Road, Loughborough, LE115DS
0150 9296797
21547854
Lyne Payne
32 Oxford Road, Cambridge, CM115KP
0117 3526594
22174895
Richard Talver
6 Stewart Drive, Manchester, MN148SK
0178 2649849
22531484
Anne Smith
78 Kerrysdale avenue, Rushden, NN83LB
0193 3225464
23597854
John Smith
21 Albert road, Leeds, LD128FF
0518 5151916
31321694
Stephanie Jacob
89 Alwark way, Nottingham, NT895TT
0115 6597641
32668736
Alex Wright
3A Leicester road, Nottingham,NT65JS
0115 3264976
35694784
Neil Lawrence
78 Ratcliffe Road, Newcastle, NW156AS
0185 7896497
52854725
Khris Johnson
25 Ashby Square,Dundee, DN124AA
0326 4548946
54587952
Robert Taylor
22 Aspire Street, Newcastle, NW1236GH
0254 4548284
Next lesson Booked
Next Lesson Booked
Student Number
Student Address
Student Name
Date
Time
1457848
25 Buckingham Avenue, Bath, BA15SS
Sean Higgins
21/03/2008
1:45:00
2147894
32A Church Street, Manchester, MA326TR
Harry Atkinson
5/03/2008
8:00:00
21347418
36 Burleigh Road, Loughborough, LE115DS
Katy Buckland
5/03/2008
5:30:00
21547854
32 Oxford Road, Cambridge, CM115KP
Lyne Payne
4/03/2008
4:15:00
22174895
6 Stewart Drive, Manchester, MN148SK
Richard Talver
4/03/2008
08:00:00
22531484
78 Kerrysdale avenue, Rushden, NN83LB
Anne Smith
4/03/2008
6:45:00
23597854
21 Albert road, Leeds, LD128FF
John Smith
4/03/2008
3:00:00
31321694
89 Alwark way, Nottingham, NT895TT
Stephanie Jacob
20/03/2008
4:15:00
32668736
3A Leicester road, Nottingham,NT65JS
Alex Wright
20/03/2008
6:45:00
35694784
78 Ratcliffe Road, Newcastle, NW156AS
Neil Lawrence
21/03/2008
0:30:00
52854725
25 Ashby Square,Dundee, DN124AA
Khris Johnson
20/03/2008
0:30:00
54587952
22 Aspire Street, Newcastle, NW1236GH
Robert Taylor
4/03/2008
08:00:00
Availabilities
Availabilities
Date
Time
4/03/2008
1:45
7/03/2008
5:30
7/03/2008
8:00
5/03/2008
9:15
8/03/2008
3:00
7/03/2008
0:30
4/03/2008
9:15
5/03/2008
8:00
22/03/2008
1:00
6/03/2008
8:00
MAINTENANCE
SYSTEM OVERVIEW
I have created a system for my instructor, to allow him to input data through Visual basic, such as student details, availabilities and next lesson booked. My system does conisit of tables and menus, both the student details and availability detail screens are very simple, it just displays details about these two entities. The booking screen is more complex because it needs 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 LIST/ DESCRIPTIONS FOR PROGRAMS OR LIST OF PACKAGE ITEMS DEVELOPED
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.
Table
Availability Details
Holds the details of all the available time slots in the coming fortnight, this allows the instructor only to see what is available, he can liaise with the student and once a slot is agreed a booking can be made.
Form
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 select a time and then the date. Once all these are selected the appointment is made.
Form
Next lesson Booked
Has a list 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.
CREATION 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 handle bookings given 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 search for them.
It stores details about student's 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.
INSTALLATION GUIDE
Hardware/Software requirements
* Laptop
* Mouse
* Keyboard
* Printer
* USB 2.0 port
* Windows Vista
* Visual Basic 2008 Or later
* 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 empty folder on the hard disc, this maybe 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 backed 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 existing 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.
USING 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. Below is the main menu, to get to the student phone number he has to select the student details button, 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 compare the objectives and the performance , I will put the original objectives down and compare against each one.
General Objectives
Security
* The system will require a user name and a password to view or edit anything!
* Only one person is permitted to use the system, no-one else requires access
* All files will also be password protected.
Database
* The instructor will be able to add or delete any records as needed
* It will hold all necessary details
Specific Objectives
* 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 paid 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 home 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. This is one of the things the instructor is complaining about and also another thing that has been drawn to my attention is that he misreads the time, so he tells the student that he is booked at 13:00 tomorrow but he is actually free he has a lesson at 3:00 not 13:00 so this is one way the instructor is losing out on money. I wish to remove this issue and avoid these mistakes happening.
Security, the system now has some good security, it only allows the instructor to long in and once the password is entered then the instructor can access the system. This is in line will all data protection acts and just general security.
User feedback
I asked Ian, the future user of this system, to navigate his way through the system and in turn add, edit, search output data using user manual as a guide. Here is what he found
DID YOU FIND IT EASY TO FIND THE STUDENT TELEPHONE NUMBER?
HOW DIFICULT WAS IT TO MAKE A BOOKING?
WHAT DID YOU FIND DIFFICULT?
WHAT WAS THE BEST THING ON THE SYSTEM?
WHAT WOULD YOU CHANGE WITH THE SYSTEM?
IS THIS AN IMPROVEMENT FROM THE EXISTING SYSTEM
SIGNATURE:
<GCE A2 Computing
<CPT 6
<Ram Bhojani
<Instructor Booking> |<Ram Bhojani 13HAN>
GCE A2 Computing
CPT 6
Ram Bhojani
Instructor Bookings | Ram Bhojani 13HAN
