Experimental Syllabus of Advanced Computer Programming Technique

Company：School of Information Engineering, Chang’an University

Department: Electrical Engineering

Date: 2013.7

Experimental Syllabus of Advanced Computer Programming Technique

ICourse Name: Advanced Computer Programming Technique

IIProperty: Dependent

IIIDesigned for:Electrical Information Engineering, Communication Engineering

IVReference: Aqi Zheng, Practical Course of Delphi, Publishing House of Electronics Industry, 2003,6

VClass hours: 36h (28h for lecture on computer, 8h for experiments on computer)

VISubjects and time allocation

VIIObjects and requirements:

Experiments on computer are important section of learning Delphi advanced programming. The requirements of the experiments course are:

1 Understand methods and stages of Delphi development environment in Windows operation, improve the ability of computer application.

2 Be familiar with client interface and operation mode of Delphi; Master data types and data components like constant, variable, expression, function of Delphi; Understand basic knowledge of file types in Delphi.

3 Master basic knowledge, methods and technique of structured programming designing; Master basic flow control statements like order, braches and loops, as well as modular programming methods; be able to read, code and debug simple application program.

4 Understand basic conceptions of object oriented programming like object, class, property, method, event, etc; Master methods of object oriented programming and visualized programming.

5 Be able to realize applications with components provided by Delphi.

6 Be able to realize an application with Delphi based on knowledge learning from class and practical problem.

VIIIContent and requirements for each experiment:

1.Common used control structures programming

(1) Subject: comment used control structure programming

(2) Content:

1) Obtain values of piecewise function as following by programming

2) Obtain greatest common divisor and least common multiple of two input positive integers.

(3) Requirements:

1) Be familiar with definition of different types variables. Understand logic operation and expression; Masterifandcasestatements.

2) Master loop statements in programming like FOR…DO, WHILE…DO and REPEAT…UNTIL.

2．Usage of standard components and dialog components

(1) Subject: Usage of standard components and dialog components

(2) Content:

1) Design a program which could processing date input with year, month, date and day, show all of them in a Memo component. Add components gradually to realize the function and demonstrate usage of common used components.

2) Based on common used dialog, realize:

① Setting font of content in text component

② Save the content in text component.

③ Show the content of existing text in text component.

(3) Requirements:

1) Master property and usage of components like Label, Edit, Memo, Button, ListBox, ComboBox and RadioGroup.

2) Master usage of components OpenDialog, SaveDialog and FontDialog.

3．Design and usage of menu components

(1) Subject: Design and usage of menu components

(2) Content: Realize a text processing application with pull down menu, shortcut menu, toolbar and status bar.

(3) Requirements: Understand property and usage of components TmainMenu, shortcut menu, toolbar and status bar.

4. Design of multi-document editor

(1) Subject: Design of multi-document editor

(2) Content: Design a multi-document editor

(3) Requirements: Master methods and stages of Delphi MDI application design.

5. Usage of files

(1) Subject: Usage of files

(2) Content: Realize a system which could accept input data like students’ No., names, mathematics, English and computer, and save them in a text file. The system also has the ability of browsing and delete.

6. Basic operation of database

(1) Subject: Basic operation of database

(2) Content: this subject consists of content as following

1) Construct a client information data table Customer with Database Desktop. The files contained in the data table including clients’ No., name of corporation, province, city, zip code, telephone, address, fax No.

2) Create a database CUST and data table cu. which contains information in 1) with SQL Sever2000.

3) Configure table Customer aliases as customers with BDE in BDE Administrator.

4) Configure CUST aliases as CustSQL with ODBC in BDE Administrator.

(3) Requirements: Master creation and edition of data table in Database Desktop; Master creation of database and data table in SQL Sever2000; Master how to configure database aliases with BDE in BDE Administrator; Master how to configure database aliases with ODBC in BDE Administrator.

7. Database operation with BDE components

(1) Subject: Database operation with BDE components

(2) Content: this subject consists of content as following

1) Create a database application with Database Form Wizard. The database should be connected with data table Customer from subject 8, and could inquire and delete records in the data table.

2) Visit database CUST which was created in subject 6 with components Table and DataSource and BDE, show the table content of cu in it and its application.

3) Create data module. Design an application, which could connect with data table by data module and realize functions as 1).

4) Inquire clients information with province “Jiangsu” in table cu.

5) Create save procedure check-cust in database CUST. The function of this procedure is inquire special clients, if client’s No. is the same as the parameter, return the client’s corporation name.

6) Start check-cust with save procedure component StoreProc. Inquire client’s No. 000005, if there exist a client with this client’s No., input its corporation name.

7) Create an application which connect with table with the help of orders.db and items.db in Delphi7 DBDEMOS.

(3) Requirements: Master creation of database application with Database Form Wizard; Visit data table with components Table and DataSource; Master creation of data module and application citation to data module; Master SQL inquirement with Query component in BDE; Master the usage of StoredProc; Master how to create a master - slave Association table application with the help of component Table in BDE.

8．Client information management system (ADO)

(1) Subject: Client information management system (ADO)

(2) Content: this subject’s content is realization of a client information management system with functions as following:

1) Clients information maintenance ( input, update and delete)

2) Clients information browsing

3) Inquire information by clients No.

4) Inquire information by province or city

5) Inquire information by corporation name

(3) Requirement: Master visiting database with ADO. Master database application in Delphi.

IXAssessment

1 Report: the course is to train students’ practical operation ability. The report should be hand on by the way of assignment.

2 Assessments:

(1) Coding and programming with components, achievement of tasks.

(2) Achievement of reports.

(3) The percentage of experiments course score to the whole course score is 20%.