Sale!
Placeholder

French Verb Tester

10,000 3,000

Product Description

Summary
Project Objectives
The aim of this project is to produce an interactive website which will test a student’s ability to conjugate verbs in French, in order to aid them prepare and improve their French prior to sitting their GCSE French examination. In order to do this, the following objectives were set:
· Produce a website with an underlying database, with which the user can interact.
· For the website to select a pronoun, verb and tense for the student to conjugate, providing a response
as to whether or not they were correct.
· Perform an investigation into verb conjugation tools currently available on-line.
· Learn about computer-based learning and how it can be applied to French.
· Learn any new applications or languages required to complete the project
· Expand on my knowledge and skills concerning project management and development.
· Apply the knowledge I have gained during my years at University.
What the Project Achieved
The objectives mentioned above were met and exceeded. The functionality of the website was complete, and all
investigations were complete and aided in the completion of the project as a whole. Users are asked to
conjugate a pronoun and verb in a particular tense selected at random from the database using ASP, and once
they have submitted their answer, a response is returned to the user informing them if they were correct or not.
There are also help pages for which the users can use as a reference for the usage and conjugation of verbs for
the tenses studied at GCSE level (present, imperfect, perfect, conditional and future). It also allows the user to
request as many conjugation tests as they require. Furthermore, during the completion of the project, the
following were also achieved:
· An analysis of three conjugation tools currently available on-line.
· The acquisition of ASP and JavaScript of which I had no previous knowledge.
· Identifying requirements for good web development and HCI design.
· An investigation and comparison of scripting languages and database management systems.
· Testing and evaluation of the system suggesting possible future developments.
· The application of previous knowledge gained throughout University and the acquisition of new
knowledge.
Currently the prototype website is accessible via:
http://csiis.leeds.acuk/cbxsmw/db32/Project/French.asp

Contents
1. Introduction ……………………………………………………………………………………………………………………………………… 1
1.1 Problem Definition……………………………………………………………………………………………………………………….. 6
1.1.1 Why make it Computer-Based? ………………………………………………………………………………………………. 7
1.1.2 Why make it Web-based?………………………………………………………………………………………………………. 8
1.1.3 The Intended Usage of the Website…………………………………………………………………………………………. 9
1.2 Objective……………………………………………………………………………………………………………………………………. 9
1.2.1 Minimum Requirements …………………………………………………………………………………………………………. 9
1.3 Possible Enhancements……………………………………………………………………………………………………………… 10
1.4 French Tenses to be Included……………………………………………………………………………………………………… 10
1.5 Relevance to my Degree Programme…………………………………………………………………………………………… 10
2. Methodology ………………………………………………………………………………………………………………………………….. 11
2.1 Life Cycle Model………………………………………………………………………………………………………………………… 11
2.2 Spiral Model and RAD Methodology …………………………………………………………………………………………….. 11
2.3 Waterfall Model …………………………………………………………………………………………………………………………. 11
2.4 Project Plan………………………………………………………………………………………………………………………………. 12
2.4.1 Analysis……………………………………………………………………………………………………………………………… 12
2.4.2 Design……………………………………………………………………………………………………………………………….. 12
2.4.3 Implementation……………………………………………………………………………………………………………………. 12
2.4.4 Integration and Testing ………………………………………………………………………………………………………… 12
2.4.5 Operation and Maintenance………………………………………………………………………………………………….. 12
2.5 Changes made to the Schedule…………………………………………………………………………………………………… 12
3. Background……………………………………………………………………………………………………………………………………. 13
3.1 Human Computer Interaction (HCI) and Web Development …………………………………………………………….. 13
3.1.1 Navigation ………………………………………………………………………………………………………………………….. 13
3.1.2 Content ……………………………………………………………………………………………………………………………… 14
3.1.3 Colour ……………………………………………………………………………………………………………………………….. 15
3.1.4 Response Times …………………………………………………………………………………………………………………. 15
3.1.5 Visual Design ……………………………………………………………………………………………………………………… 15
3.2 Computer-based Learning ………………………………………………………………………………………………………….. 16
3.2.1 How is French Taught in Schools? ………………………………………………………………………………………… 17
3.2.2 Advantages of Computer over Traditional Teaching Methods ……………………………………………………. 18
3.2.3 Requirements and Principles of Computer-Based Learning Systems………………………………………….. 19
3.2.4 Evaluating Computer-Based Learning Packages……………………………………………………………………… 19
4. Analysis…………………………………………………………………………………………………………………………………………. 20
4.1 Verb Conjugation Practice Tools Currently On-line…………………………………………………………………………. 20
4.1.1 The Verb Tutor……………………………………………………………………………………………………………………. 20
4.1.2 Le Devoir Conjugal………………………………………………………………………………………………………………. 23
4.1.3 The Conjuagation Trainer …………………………………………………………………………………………………….. 26
4.2 Development Tools ……………………………………………………………………………………………………………………. 29
4.2.1 Which Database Management System (DBMS) to Use?…………………………………………………………… 29
4.2.2 Microsoft Access or SQL Server? ………………………………………………………………………………………….. 29
4.2.3 Which Scripting Language to Use?………………………………………………………………………………………… 30
4.2.4 Client-side Scripting Vs Server-side Scripting………………………………………………………………………….. 30
4.2.5 Active Server Pages (ASP) …………………………………………………………………………………………………… 30
4.2.6 Common Gateway Interface (CGI)…………………………………………………………………………………………. 31
4.2.7 Personal Home Pages (PHP) ……………………………………………………………………………………………….. 31
4.2.8 ColdFushion……………………………………………………………………………………………………………………….. 31
4.2.9 Java Server Pages (JSP)……………………………………………………………………………………………………… 32
4.2.10 Which Method is Most Suitable and Why?…………………………………………………………………………….. 32
Sue-May Wong French Verb Tester
– 4 –
5. Design…………………………………………………………………………………………………………………………………………… 28
5.1 Database Design ………………………………………………………………………………………………………………………….. 28
5.1.2 Entity-schemes……………………………………………………………………………………………………………………. 34
5.1.3 Normalisation ……………………………………………………………………………………………………………………… 35
5.1.4 Normal Forms …………………………………………………………………………………………………………………….. 36
5.1.5 Boyce-Codd Normal Form (BCNF) ………………………………………………………………………………………… 37
5.2 Interface Design………………………………………………………………………………………………………………………… 37
5.2.1 Navigation ………………………………………………………………………………………………………………………….. 37
5.2.2 Content ……………………………………………………………………………………………………………………………… 38
5.2.3 Colour ……………………………………………………………………………………………………………………………….. 39
5.2.4 Visual Design ……………………………………………………………………………………………………………………… 39
6. Implementation ………………………………………………………………………………………………………………………………. 41
6.1 Implementation of the Database ………………………………………………………………………………………………….. 41
6.1.1 Conjugations ………………………………………………………………………………………………………………………. 41
6.1.2 Pronouns……………………………………………………………………………………………………………………………. 41
6.1.3 Tenses ………………………………………………………………………………………………………………………………. 41
6.1.4 Verbs…………………………………………………………………………………………………………………………………. 41
6.2 Implementation of the Website…………………………………………………………………………………………………….. 42
6.3 Implementation of ASP to Connect the Website to the Database……………………………………………………… 42
6.4 Implementation of JavaScript………………………………………………………………………………………………………. 43
6.5 Hardware and Software Requirements …………………………………………………………………………………………. 44
6.5.1 Hardware Requirements ………………………………………………………………………………………………………. 44
6.5.2 Software Requirements………………………………………………………………………………………………………… 44
6.6 Testing whilst Implementing………………………………………………………………………………………………………… 44
7. Testing ………………………………………………………………………………………………………………………………………….. 45
7.1 Functionality Issues……………………………………………………………………………………………………………………. 46
7.1.1 Verb, Pronoun and Tense Selection ………………………………………………………………………………………. 46
7.1.2 Returning the Correct Response……………………………………………………………………………………………. 46
7.1.3 Buttons and Links………………………………………………………………………………………………………………… 47
7.1.4 Functionality from the Students Point of View………………………………………………………………………….. 47
7.2 Usability …………………………………………………………………………………………………………………………………… 47
8. Evaluation ……………………………………………………………………………………………………………………………………… 49
8.1 Usability …………………………………………………………………………………………………………………………………… 49
8.1.1 Visual Clarity ………………………………………………………………………………………………………………………….. 49
8.1.2 Consistency ……………………………………………………………………………………………………………………….. 49
8.1.3 User Guidance and Support………………………………………………………………………………………………….. 49
8.1.4 Informative Feedback…………………………………………………………………………………………………………… 50
8.1.5 Explicitness ………………………………………………………………………………………………………………………… 50
8.1.6 Appropriate Functionality ……………………………………………………………………………………………………… 50
8.1.7 Flexibility and Control…………………………………………………………………………………………………………… 51
8.1.8 Error Prevention and Correction ……………………………………………………………………………………………. 51
8.1.9 System Usability Problems …………………………………………………………………………………………………… 52
8.1.10 General Usability……………………………………………………………………………………………………………….. 52
8.2 Minimum Requirements ……………………………………………………………………………………………………………… 54
8.3 Comparison with other Conjugation Tools …………………………………………………………………………………….. 54
8.4 Conclusion ……………………………………………………………………………………………………………………………….. 55
8.5 Future Developments…………………………………………………………………………………………………………………. 55
Bibliography ………………………………………………………………………………………………………………………………………. 56
Appendix A – Personal Reflection…………………………………………………………………………………………………………. 58
Appendix B – Project Schedule…..

GET THE COMPLETE MATERIAL

INQUIRES:

OUR SERVICES: