Coursework Assignment Brief- Draft This is published as a draft and may be subject to change following external examiner feedback. Semester: E16 Module Code: PI307 Module Title: Visual Basic Net Programming Programme BSc. Business Management and Information Technology Level: Level 6 Awarding Body: Plymouth University Module Leader Asma Sabahat Aslam Format: Code & Report Special Requirements: All work should be submitted on the Student Portal along with a TurnItIn Report Word Limit: Task 1 - Program(word count not applicable) Task 2 - Reflection: 800 +-10% words Deadline date for submission: TBC Learning outcomes to be examined in this assessment • Design and develop programs including internet programs deploying visual basic Net applications. • Implement user interfaces with relation to object orientated programming techniques and use classes and assemblies to make code reusable and extendable. • Use visual tools ADO.NET objects and basic Structured Query language to access and manipulate data. Percentage of marks awarded for module: This assignment is worth 50% of the total marks for the module Marking Criteria Knowledge and understanding of the subject • Clearly understands the assignment deliverables and application to chosen case. • Knowledge and understanding of the steps required to design and implement the system. • Identified key theories and /or concepts (refer to weekly slides). Use of appropriate programming constructs. • Analysis and design (use of controls). 35% Cognitive and intellectual skills • Logic argument - e.g. with evidence articulate how a specific strategy has been reached. • Has a number of reliable sources (e.g. Organisation reports, academic journals, academic text). • Select relevant evidence to support recommendation and / or conclusion • Has researched beyond the key reading appropriate for the subject. • Academic honesty - Has avoided plagiarism • Has used Harvard referencing (in-text and reference list) • 40% Graduate Skills for life and Employment indicated by: • Uses appropriate academic conventions (e.g. summaries, paraphrasing etc.) • Research-related skills (evidenced by collection and interpretation of data to support findings) • Written and graphical skills • Problem-solving (is the strategy and recommendation based on the analysis) • Practical and professional skills (work has right level of detail/ complexity) • Use of Harvard referencing 25% Assignment Tasks: This Assignment is based on the following scenario. It is designed to go through the process of developing a VB.Net program (i.e. analysis, design, implementation, testing and documentation). The task also requires your reflection on the development process. Your assignment consists of two tasks: Task one is to develop an Information System for Brookside Group Practice. Task two is to analytically reflect on your experience in achieving task one above. Task 1 THE SCENARIO Brookside Group Practice is a busy surgery, managing patients' appointments, records, health history and referrals. You have been asked to design a sub system to manage patients at the surgery. The new sub system will be part of the central system that will manage the activities at the surgery. The sub system must run a database that contains all of the data relevant to the patients at the surgery. In addition, the system should provide functionalities to enrol new patients, delete patient record, update and save their details. Staff at the practice needs to be able to run a number of reports that detail summary information for the total number of patients registered with NHS and their health histories. They book and cancel routine patient appointments, view their medical records, deal with repeat prescriptions and provide printed reports to patients on request. You must develop the requirements below, which are essential to run basic operations. The system will be mainly used by administration staff. Administration Staff will have the capabilities to: 1. Store information related to patients in one table. 2. Enroll new patient. 3. Update patient information such as address or telephone number. 4. Delete patient details. 5. View patient records. 6. Scroll through records. For this assignment you are required to develop a fully working program in Visual Basic.Net providing visual front end and Database (MS Access\SQL) at the backend to store records. The Graphical User Interface should have an aesthetically pleasing design. Your design should reflect your knowledge of VB.Net language constructs. In addition, you must ensure that the program is errors free. Internal documentation is essential in real life assignment development to ease any future maintenance and additional requirements. Therefore, your code should take this in consideration for examples, using sensible names for variables and adding sufficient comments or remarks on program code. Task 2 Self-Reflective Commentary Your second task is to write a self-reflective commentary about the design and development experiences you had while undertaking the assignment, and what you learned about your own work practices as a result. Having created your program(s), you should write a self-reflective commentary (approx. 800 words +-10%) critically reflecting on your assignment. Your commentary should critically explore the work you have done to produce your assignment. You should reflect on: 1. Your research as you produced your assignment. 2. The decisions you made as you worked on your assignment. 3. Where you think you succeeded and where you think you could have room for improvement. 4. What you would do differently if you were to attempt to do your Assignment again and what you would do with your assignment if you could develop it further. Your commentary should show evidence of your reading and research and use Harvard referencing. Your commentary is a chance for you to critically analyse your own work, showing an awareness of strengths as well as identifying potential areas which could use improvement if they were to be done again. Deliverables You must present your work in a report format. The required structure is outlined below: Cover Page: Module Name and code, Title of Assignment, Student name and number, Submission date. Table of Contents: List the contents of the report in the order they appear. Number the section headings/sub headings, pages, appendices and list of figures. Introduction: This should summarise your response to the task and the strategy you are presenting. Software Development Process This is the core contents of your report. You should use the case study (in the question) to structure this section, clearly demonstrating how you addressed each of the requested tasks. You are required to include annotated screen shots, code snippet with commentary. You must show evidence of testing at every stage of the development cycle. Self-Reflection: A self-reflective commentary about the design and development experiences you had while undertaking the assignment, and what you learned about your own work practices as a result. Conclusions: These draw together your findings. Explain what you believe to be significant in your findings and tell the reader which findings you consider to be most important. References: All sources cited including Internet. References should be traceable – somebody reading your report may want to follow up one of your references; they must be able to find it from what you've written. Please use Harvard system for all references:- (AUTHOR LAST NAME, first name (DATE), Full Title, where published, name of publisher. Details for the Harvard Style can be found on the student portal. Appendices: An appendix contains supplementary information that you consider to be too long. You should add as appendix the FULL coding of the program. If you have more than one appendix, each appendix should be referred to in your text. You should not include something as an appendix if it is not discussed in the report. Total Marks: 100