Hong Kong Examinations and Assessment Authority Hong Kong

  • Slides: 12
Download presentation
Hong Kong Examinations and Assessment Authority Hong Kong Certificate of Education Examination 2006 Computer

Hong Kong Examinations and Assessment Authority Hong Kong Certificate of Education Examination 2006 Computer and Information Technology Paper 3 (Coursework) Module A (Algorithm and Programming): Seating Plan By Cheng Kai Lok

Hong Kong Examinations and Assessment Authority Hong Kong Certificate of Education Examination 2006 Computer

Hong Kong Examinations and Assessment Authority Hong Kong Certificate of Education Examination 2006 Computer and Information Technology Paper 3 (Coursework) Module A (Algorithm and Programming): Seating Plan Candidates are required to write a computer program for the school annual dinner registration. During the data collection stage, personal information of the participants is required to be input into the program, i. e. name of participant, year of graduation, sex, age, employment, number of seats required, etc. The program should validate all input data and also have functions to amend the input data. At the end of the registration period, the program should generate a seating plan of the anniversary dinner for the organizing committee in a text file. Candidates should clearly define the seat allocation rules and any other system parameters such as table size. Some possible seat allocation rules are as follows: • Grouping family members together • Balancing male and female participants • Grouping similar age participants • Grouping similar employment participants The program should consider at least TWO seat allocation rules at the same time to generate a seating plan. Candidates should note that there may not exist a perfect seating plan that satisfies all the stated rules. An approximate arrangement is acceptable. In the coursework report, candidates should justify the use of any data structures and algorithms in the implementation.

Objective and specification The personal information of the participants can be inputted into my

Objective and specification The personal information of the participants can be inputted into my computer program for the school annual dinner registration and stored in the database. And the program can validate all input data and also have functions to amend the input data. At the end of the registration period, the program can generate a seating plan of the anniversary dinner for the organizing committee in a text file. The program define the seat allocation rules and any other system parameters such as table size clearly. The allocation rule are Grouping family members together, Balancing male and female participants, Grouping similar age participants, Grouping similar employment participants. The program can TWO seat allocation rules at the same time to generate a seating plan. And the program can choose the table size.

Investigation I have gone to the library and the internet search different programming languages

Investigation I have gone to the library and the internet search different programming languages information, know the types of programming languages: C, C++, Cobol, HTML, Java. Script, Pascal, Visual Basic, Visual C++, XML, PHP. . And I know their weakness and strength. Book I have read: • PROFRDDIONAL PHP PROGRAMMING (WROX) • PROGRAMMING PHP (O’REILLY) • MICROSOFT C++ LANGUAGE SPCIFICATIONS (MICROSOFT) • PROGRAMMING FOR EVERYONE IN JAVA (SPRINGER) • PHP ESSENTIALS (MELONI) • OBJECT-ORIENTED PROGRAMMING USING C++ (COURSE TECHNOLOGY) • PROGRAMMING IN VISUAL BASIC 6. 0 (MCGRAW HILL) • GAME PROGRAMMING GEMS (DHARLES RIVER MEDIA) Web I have read: • http: //www. engin. umd. umich. edu/CIS/course. des/cis 400/

Decision Making Programming Weakness Language Strength Pascal Poor performance in GUI It is not

Decision Making Programming Weakness Language Strength Pascal Poor performance in GUI It is not easy for linking with database It is a strongly-typed language Easy to use C Poor performance in GUI Powerful, flexible language Visual Basic The cost of the software maybe too high The size of file is not small comparing with other language Not only a programming language A complete graphical development environment This environment allows users with little programming experience to quickly develop Java Too difficult to learn Platform Independence Object Orientation Rich Standard Library Applet Interface PHP The server of PHP maybe difficult to install Can be embedded into HTML Extremely simple for a newcomer PHP can be used on all major operating systems

I will choose the Microsoft Visual Basic. NET, it is because Visual Basic allows

I will choose the Microsoft Visual Basic. NET, it is because Visual Basic allows the user to create nice looking, graphical programs with little coding by the programmer, unlike many other languages that may take hundreds of lines of programmer keyed code. And I will choose the Microsoft Access, which is a powerful database software. Easy to use and deployment, reliability and performance.

System flow Main Start Add Record Input data Edit Record Generate table Search data

System flow Main Start Add Record Input data Edit Record Generate table Search data Edit data Delete data Quit

Data structure Name Type Lengths Student code Character 6 Student name Character 50 Year

Data structure Name Type Lengths Student code Character 6 Student name Character 50 Year of graduation Integer 4 sex Character 1 Year of birth Date/time / employment Character 50

Schedule September Program Coding October Program Coding November Debugging December Writing report and finishing

Schedule September Program Coding October Program Coding November Debugging December Writing report and finishing the project

End

End