Software:
- Upgrade to Office XP and Windows XP, which has better features, and easier to do the project more quicker or more efficiently. Cost- £112
- Upgrade my drivers of all the necessary hardware. Download from the Internet. Cost – free.
- Voice Recognition programme- Cost- £49
Total upgrade cost: £460
Feasibility Report
I have the task of creating a computerised information storage system for a college form tutor, who requires improving his manual data storage system. She has to store information about the details of his form class students, and also the students in his subject. He gave me a limited budget of £300 and limited access to the college computers to create it. She also gave a limitation of time. I have to create the system by 01-04-2003. With all these limitations, is it going to be feasible to perform the task?
Technology- There is enough technology in the college to create a powerful but simple problem solving system for my end user. There are many computers, with powerful speed and lots of memory and good applications. I also have an access to a powerful computer at home. Both locations have computers with the necessary software, which are MS Excel, MS Word and MS Access.
Economic- There is enough finance available to cover the cost of creating the problem solving system, and also enough for necessary upgrades, which will amount to a maximum of £100.
Legal- The solution will not be breaking any legal rules, because the computer will be password protected, so if the students details are stored in it, it will not go to the wrong hands, therefore will not be breaking the data protection act. The information will be confidential and will not be revealed to anyone in the Internet or by any other methods.
Operational- The environment for the end user has the capability to support the solution that I am going to create in the system. My end user has the access to computers and is computer literate to understand and use the solution. The college has computer technicians who can fix his hardware and software for her if it gets damaged. The system I will be creating will be backed up, along with the information stored using it. This will ensure that in a case of data loss, all the information can be easily recovered. To prevent data loss or crashes, the computer has latest anti-virus software and firewalls.
Schedule- I have enough time to create a problem solving solution for the user. I have more than 1 year to complete the task. I will be working on it more than eight hours a week, both at college and home. I have broken my task into several parts to organise my time better.
Aims And Objectives
Aim:
To Create a Problem solving system for a computer user using problem solving applications.
Objectives:
To master computer applications, mainly MS Access, MS Word, MS Excel etc.
To create a computerised database system, for a user who wants to convert from a
Manual database system to an electronic one.
Add helpful objects like manual, backup and training.
Include helpful features like Queries, Reports and Forms.
Constraints and Limitations
System Limitations: The computer is Old; therefore it has a slow processor, and low RAM. Unless this is upgraded, it will be very difficult and slow to operate soft wares, which take up lot of space.
Software limitations: The soft wares are also not the latest versions, so they have limited features. They need to be upgraded as well, because a system with full capacity will be effective for a fast and efficient solution.
User limitations: The user does not have a high level of computer skills. It will be harder for him to operate a high level system. Therefore a system needs to be created to match his skills level.
Data Flow Diagrams
Level 0
Data Flow Diagrams
Level 01
Design
Consideration of possible solutions:
Simplified manual system – Although it will be easy for the user with his level of computer skills, it is not ideal because this will be very complicated to sort out, and also very time consuming.
Text document system – This way, it will be simple for Mr Altaf to store the information without any complications, but it cannot display any reports, queries etc.
Final Choice of solution:
For implementing the system a database package will be ideal for Asif Altaf. It will be done in Access XP, as it has the most features.
I already have some experience of using Microsoft access XP and it is possible for college and me to develop on my skills, as it is both at home.
By using this package it will be possible to:
Set up tables and relationships
Produce customised input screens.
Designing Reports
Implement a customised menu system
Link with MS word to perform mail merges to parents.
Make and save queries to selected certain customers for mail merge
Use visual basic to modules to enable fast searches for a particular customer.
Database Design
My database will contain the following entities and attributes:
Definition of data requirements
The tables will contain the following data:
Student Details
Attribute Type
Subject Details
Attribute Name Type
Report
Attribute Name Type
Systems Flowchart
Design of Input Forms
This input forms will be necessary, because it will help add new student information, and also add subjects for the student. It can be used to look through all the existing details of the students, and modify to upgrade it.
If a student is already in the database, mistakes while modifying the database will be noticed by the validation checks, and corrected. To make it easier for the user, the Student ID data type will be an auto number integer, so that there is continuity at work.
In the form, when the subject button is clicked, it will bring up a list of Subjects that the college provides, with relevant information linked to the subject, like teacher.
There are keys on the right side, which will take the user to lists of student, subject, open new form or go to main menu. Check box for some Attributes, to save the user time from typing it all up. There is a dropdown List for the user to find the student, and there is also a search student key, which will enable the user to find a student by using his/ her ID, Name etc. The sub form will be the added subject details, after the Add Subject Button is clicked.
Menu Design
My menu is going to be in the following format, to keep it simple and for the ease of the user:
Report Design
This is the format of the student report:
Queries
I will create, modify and save some queries for my user, so that she can access specific information about the students, subjects and reports by specifying an attribute.
Subject Query- This will enable my user to find out how many students in his tutor group have taken a particular subject.
Enhancement Query – Selects all the students who are attending Extra Curriculum enhancement programmes.
Course type Query – Selects all the students who are either part time, or full time students. It can also be modified to choose all the students who are first year students, or second year students.
Location Query – Selects all the students living in a particular area, for example East Ham.
Medical History Query – Selects all the students with medical problems.
Finance Query – Selects all the students who are eligible to receive a government grant.
Mail Merge
When the user selects the option of mail merge from the main menu, he will have the option to load word from access, and select the source of data to be use for the letters. There will be options available to send mails to either the students or the parents. Sent mails, addresses and date and time will be stored, for future reference or use. As the user increases his user level, or reads my user manual, he does not have to rely anymore on the automated mail merge system. He can use its flexibility to create and send mails on his own style.
Implementation
I have created a database solution for a college tutor, to help him sort out his student details and to create reports to be sent to parents. I have made tables, Queries, Forms and Reports. This is how I made it:
I have tested the whole database solution, and these are my results:
Testing the data entry in tables.
Result: Under the mobile No Field, the number does not allow entering of a full mobile No. I have corrected it, by expanding the field size for that in design view.
Expected result: Working.
Testing Queries.
Result: Queries work perfectly, No flaws.
Expected Result: Working.
Testing Reports.
Result: The reports, although showing the correct information, does not display it properly. The font is very complicated, and the background too, makes it hard to understand. I corrected this, by changing the look of the report in report design view.
Expected Result: Same.
Testing Forms.
Result: Forms work, although there are no keys that lets you select other objects from a list, like it was planned in design chapter.
Expected Result: Form with links and Relationships.
Testing Mail Merge: Works.
Expected Result: Works.
User Manual
- Open the database system, by clicking on the database icon on desktop.
- To enter data into a table, go to forms in a main menu, and either chose Students or Students and Classes Form.
- Enter the data in the spaces provided.
- Alternatively, you can enter the data directly into the table.
- To do this, go to main menu, click tables, and select either Students or Students and Classes.
- To view the table, just click on either tables [Main Menu > Tables > Tables]
- To find out specific information from the tables, go to [Main Menu > Queries]
- To find out if a particular subject is taken by any of your students, select Students query. Open in design view. Under criteria, under Subject No, enter the number of the subject you want. Save.
- To view the query, click on the query.
- To view which of your students are doing Enhancements, Open the Students Enhancement in design view. Under criteria under Enhancement type yes.
- Click on the query, to find out which of your students are doing enhancement.
- To find out which of your students are not doing enhancement, follow step 10, instead of yes on criteria, put No.
- To Merge the information from either the table or queries, click on the merge button on the main menu, and it will take all information to Ms Word.]
- To view reports, click reports in main menu, and you can view it. You can either print it out to post or to give to parents in parents evening, or you can mail merge it to the parents e-mail addresses.
Evaluation
I have created a database solution for a college tutor in my project, to sort out her student database, and also to create reports for parents. The system is quite an user –friendly solution, and since my user’s skill level is moderate, he will not have much trouble using it. With this project, I included Analysis, Design, Implementation and User Manual.
I am moderately satisfied with the work I produced. Out of the chapters, Analysis and Design were the two chapters, that I am fully satisfied with. I believe, that with more time, I could have put more information in the implementation and user manual. The last two chapters are proper and correct, but not as elaborate as I planned them to be.
My best part in the project is my analysis chapter, because I have done it with lots of time and care, and I am happy with the way it turned out. My worst part in the project is probably my user manual, because I did this at the end, when the time was running out.
There were a few things, that did not turn out as good as my expectations. I planned to add a few screenshots to my user manual. I wanted a dropdown list in my forms, but unfortunately, I did not know how to do it. I am also unhappy, that I could not turn in this project before the deadline, since I was struggling because of my lack of implementation knowledge. Still, I am proud of the work I produced under these circumstances. I am also quite proud, than I chose to do quite an original project of sorting information, while most of my fellow classmates are doing business solutions.
If I had to do the project again, I would change a few parts of it. I would plan the whole project more thoroughly, and I would put away more time for me to finish the project, so that I could turn it in the deadline. Overall, I am happy that I have produced this work.
[email protected]