BIT502 Fundamentals of Programming Assessment 3 2026 | Open Polytechnic NZ

BIT502 Fundamentals of Programming Assignment 3

Weighting: 

This assignment is worth 40% of your total course mark.

Learning outcomes covered:

Learning outcome 1 Solve problems and make effective decisions utilising the principles of professional practice, independently and in a team.

Learning outcome 2 Create simple applications using fundamental programming constructs and principles.  

Learning outcome 3 Describe and apply the principles of interaction design and human computer interaction (HCI) employing current and emerging technologies.

Learning outcome 4 Identify a range of software tools, such as text editors and/or integrated development environments (IDEs).

Learning outcome 5 Describe and apply the principles of software implementation, including user testing, training and deployment across multiple platforms.

Learning outcome 6 Demonstrate an awareness of procedural and object-oriented programming methodologies.  

Learning outcome 7 Plan, design and develop a simple database application following application development life cycles.

Instructions

The work you submit should include your own code as a complete C# project that can be opened in MS Visual Studio 2017.

Your code should be written in simple and readable style, applying the concepts and principles of good programming practice that you learnt in the course material.

The interface and user interaction of your program should be convenient for a user.

Please refer to the marking schedule for detailed evaluation points.

Assignment guidelines

In this assignment you will create a C# project for grading students’ performance based on 10 marks from their course.

The project will require you to:

• design and create an appropriate database
• create multiple C# Windows  forms
• use the functions available in the Data Sources window to connect the necessary forms to your database  • implement all functions  specified.

Note:  Be sure to submit your full C# project including your database for marking.

Assignment 3 Tasks

Your task is to develop a C# application along with an accompanying database. The application will provide a search function that will read student information from the database and display the result to the user, along with some extra information that has been calculated from the data (such as the average of the student’s marks).

To complete this project, you will need to:

• design and create the  database
• populate the database with the data provided
• design and create the user interface for the three forms, based on the information provided
• follow good OOP  practices
• connect the database to your application and attach it to each form as necessary
• implement the search functionality and extra functionality as specified
• thoroughly test your application for errors and user convenience.   

Submission

You are required to produce the following deliverables:

1. a concept breakdown diagram/document of the application (follow the format in your course notes under the topic ‘Concept breakdown’)
2. a wireframe showing all three forms and the connectivity among them (a paper- based sketch is  sufficient)
3. the implementation of the assignment question in C# (include your full project and database)
4. a user guide for the  program.

Designing the database

For this assignment, you are expected to design and create your own database from the information provided. Although you can easily make your database in Visual Studio, you may use Microsoft Access as it is also compatible.

Your database only needs a single table for this program (do not separate the data into multiple tables). Normally, you would design the database following good practices that divide the data into multiple tables, however, in this assignment your design is to match the structure of their existing legacy system at the client’s request; changing the structure may cause conflicts.

This occurs often when working with existing systems and data.  Your table contains the student data and will need to store the following information:

• an ID
• the student’s first and last name
• marks from 10 courses.

The method you use to store the names and marks is up to you. Remember to follow good database practices.  

Populate your database with the data in Assignment 3 Appendix.