لو سمحتوا اريد مساعدة في حل لمشروع الفيجول بيسك
•
COMP 2105 Visual Basic Programming
Fall 2007
Mini-Project
Due date: Wednesday December 12, 2007 @ 4:00 PM
Grade Book
A teacher maintains an Access database named GRADES.MDB containing two tables
Students and Grades as described below. Write a Visual Basic program that allows
the instructor to record and process students and grades information as described in
the system requirements section below.
Students table:
The students table has the following fields:
Field Name Description
studentNumber Unique number given for each student
lastName Student’s last name
firstName Student’s first name
POBox Student address
postalCode 3 digits number
Grades Table:
The grades table has the following fields:
Field Name Description
studentNumber Student number
firstExam First exam score
secondExam Second exam score
finalExam Final exam score
System Requirements:
The program should allow the instructor to do the following:
a. Add students to the Students table. When a new student is added to the
students table a new record with the same studentNumber must be created in
the Grades table.
b. Enter student grades using a data grid view.
c. Display student’s grades list. The list should contain studentNumber,
firstName, lastName, firstExam, secondExam, and finalExam.
d. Display a data grid view showing the name of each student and his or her
semester average. The semester average should be calculated as (firstExam +
secondExam + 2 * finalExam)/4.
e. Display final grades list. The list should contain studentNumber and the
student's semester grade (letter grade). The semester grade should be
determined by the semester average with an A for 90-100, a B for 80-89, a C
for 70-79, a D for 60-69, and F for < 60. The list should be ordered by the
semester grade.
Graphical User Interface:
1. Menus should be used.
2. More than one form should be used
3. Appropriate controls should be used as needed
NOTE:
Fall 2007
Mini-Project
Due date: Wednesday December 12, 2007 @ 4:00 PM
Grade Book
A teacher maintains an Access database named GRADES.MDB containing two tables
Students and Grades as described below. Write a Visual Basic program that allows
the instructor to record and process students and grades information as described in
the system requirements section below.
Students table:
The students table has the following fields:
Field Name Description
studentNumber Unique number given for each student
lastName Student’s last name
firstName Student’s first name
POBox Student address
postalCode 3 digits number
Grades Table:
The grades table has the following fields:
Field Name Description
studentNumber Student number
firstExam First exam score
secondExam Second exam score
finalExam Final exam score
System Requirements:
The program should allow the instructor to do the following:
a. Add students to the Students table. When a new student is added to the
students table a new record with the same studentNumber must be created in
the Grades table.
b. Enter student grades using a data grid view.
c. Display student’s grades list. The list should contain studentNumber,
firstName, lastName, firstExam, secondExam, and finalExam.
d. Display a data grid view showing the name of each student and his or her
semester average. The semester average should be calculated as (firstExam +
secondExam + 2 * finalExam)/4.
e. Display final grades list. The list should contain studentNumber and the
student's semester grade (letter grade). The semester grade should be
determined by the semester average with an A for 90-100, a B for 80-89, a C
for 70-79, a D for 60-69, and F for < 60. The list should be ordered by the
semester grade.
Graphical User Interface:
1. Menus should be used.
2. More than one form should be used
3. Appropriate controls should be used as needed
NOTE:
•
Functions/Procedures should be used when/where appropriate.
•
•
Comments should be used to document and describe the various parts of the
program
أو بامكان اللي يريد يساعدني فهنالك ملف مرفق بالموضوع.
الرجاء ارسال الحل على الأيميل التالي murshid3@hotmail.com
program
أو بامكان اللي يريد يساعدني فهنالك ملف مرفق بالموضوع.
الرجاء ارسال الحل على الأيميل التالي murshid3@hotmail.com
