Objective: This is an individual assignment aimed to give students the experience to use visual programming language, create simple graphical user interfaces with event-driven programs, develop data connectivity and design reports within an applications environment.

Learning Outcomes covered:

1. Understand visual programming environment and controls

2. Apply visual programming concepts to write event-driven programs

3. Write programs with the support of an integrated development environment

4. Build database applications using ADO.Net

5. Design reports using Crystal Report

Instruction to the students:

 Perform all tasks

 Individual case study having a weightage of 60 will be set out of 100 marks and the corresponding answers will be evaluated out of 100 marks.

Task 1:

Choose one from the given list below and create your own VB.Net Application. Gather information from any company based on your chosen application. When you create your application, make sure to change the company name into your own company name as well as the logo. You have to design your forms appropriately and use different controls (like textbox, listbox, combo box, radio buttons, data grid, date format, etc) in your application. Your application should include the ALL requirements stated below.

Visual Programming (COMP 1007)

Case Study with Presentation

Spring 2018

VISUAL PROGRAMMING-COMP 1007– SPRING – 18–CW2 (Case Study)-All-QP

COMP 1007 Page 2 of 9

Choose any one from the following list of system:

 Human Resource Management system

 Sales/Order System

 Library Management System

 Car Rental System

 Hotel Management System

 Students Information/Admission System

 Hospital Management System

 Railway Reservation System

Requirements:

A. Submit a work proposal for this case study by the end of week 9, which must include:

1. Table columns of the chosen system with at least 2 sample data/records.

2. Understanding on the deliverables – which may include the form designs along with codes (whatever have been completed)

3. Time line for completion of each deliverables and references.

B. You have to prepare a report/documentation that will include the following:

1. A brief introduction of what your application/system is all about and the scope of your application/system.

2. The screen design with their proper source codes.

C. Create and Design a database in MS Access that will include the following:

1. At least one (1) table with minimum six (6) columns

2. Insert at least 15 appropriate records

D. Create and Design a VB application that will include the following:

1. Connect the created database to your VB application. Database connectivity of transaction form should be through codes.

2. Log in form – create at least 2 different users with different level of access/privileges. The login form should validate the given username and password and will display appropriate messages if invalid data is entered. If valid username and password are entered, a splash screen will be displayed and then the main form/menu will be displayed with all the functionalities/operations that can be performed by the user. A user can have only at most three (3) attempts to login. After three invalid attempts, the application/program should be closed automatically. Password should not be readable.

VISUAL PROGRAMMING-COMP 1007– SPRING – 18–CW2 (Case Study)-All-QP

COMP 1007 Page 3 of 9

3. Splash screen – will show the name of your system as well as the logo. Create and design your own company name and logo. This will be displayed only if the entered username and password are valid.

4. Main Menu – a form that will contain all the functionalities/operations a valid user can perform based on his/her level of access/privileges. (e.g. maintenance, transaction or report)

5. Maintenance form – a form where user can add, delete and update records stored in the database. Upon opening the form, all fields should not be enabled to do any changes. When updating a record, a form or an input box can be used to make the changes. There should be a function/procedure to be called in this form while updating records are being done.

6. Transaction form – a form where users can use the records in the database to do some transactions. A transaction activity needs to be implemented in this form such as calculations, error messages, etc. Make use of message boxes for displaying error messages with regard to your chosen application. Ensure to connect and access your database in doing the transaction.

7. Crystal Report – at least 2 different kinds of report that can be generated from your database through your application. One of the reports should be a parameter report.

8. Export any of the reports to MS Word/MS Excel/Text format.

Task 1 Marking Scheme:

A. Work Proposal – 10 Marks

B. Report/Documentation – 5 Marks

C. Database (table with records) – 10 Marks

D. VB application – 75 Marks

1. Connectivity – 15 marks

2. Splash screen – 5 marks

3. Login form – 10 marks

4. Main Menu – 5 marks

5. Maintenance form – 12 marks

6. Transaction form – 12 marks

7. Crystal report

a. Simple report – 5 marks

b. Parameter report – 6 marks

8. Export – 5 marks

VISUAL PROGRAMMING-COMP 1007– SPRING – 18–CW2 (Case Study)-All-QP

COMP 1007 Page 4 of 9

Total marks – 100 Marks

Task 2:

You have to present and demonstrate your work to your teacher on a specified date given by your teacher (14th or 15th week). During presentation, you may be asked to debug code, add and delete records, do transaction, etc.

Note: Task 2 is compulsory. Marks for task 1 will depend on the presentation. No marks will be awarded for Task 1 without presentation.

Guidelines

Follow the guidelines mentioned below for your assignment.

 Assignment documentation/report should be typed.

 Assignment documentation/report should be uploaded in Moodle and will undergo plagiarism detection test through Turnitin (a plagiarism detection tool)

 A softcopy of the Application along with all the images used need to be stored in a CD and to be submitted during the mentioned submission date. Please note that you have to check that all the files are completely saved in the CD before submission.

 Handwritten assignments will not be accepted

 Assignment should have a Title Page. Title Page should contain the following information.

 Assignment Name

 Session

 Student name

 Student ID

 It should have Table of Contents

 Use page numbers

 Assignment should be typed in your own words using Times New Roman font size 12.

 Heading should be with Font Size 14, Bold, Underline

 Use Diagrams and Examples to explain your topic.

 Copy paste from the Internet is strictly not acceptable.

 Reference should be included in the last page as follows

 Author name, Book Title, Publisher, Year in case of books

 In case of web site references type the full path of the web page with referenced date

VISUAL PROGRAMMING-COMP 1007– SPRING – 18–CW2 (Case Study)-All-QP

COMP 1007 Page 5 of 9

 In case of magazines/ periodicals type article name, magazine name, Issue Number and date

Rules & Regulations

ï‚· If any topic or diagram of an assignment is found copied from the other then marks will be deducted from both assignments.

ï‚· The purpose of assignment is to do some research work so you can consult books in Library or use internet or computer magazines or any other source.

Plagiarism Policy

As per MEC policy, any form of violation of academic integrity will invite severe penalty. Plagiarized documents, in part or in whole, submitted by the students will be subject to this policy.

A. First offence of plagiarism

a. A student will be allowed to re-submit the assignment once, within a maximum period of one week. However, a penalty of deduction of 25% of the marks obtained for the resubmitted work will be imposed.

b. Mark deduction: When the work is resubmitted, the marking will be undertaken according to the marking criteria. In compliance with this policy, the 25% deduction is then made on the marks obtained. For example, in an assessment that carries a maximum of 50 marks, suppose a student were to obtain 30 marks for the resubmitted work, the final marks for that assessment will be 22.5 (after deducting 25% of the marks actually obtained for the resubmitted work).

c. Period of resubmission: The student will have to resubmit the work one week from the date he or she is advised to resubmit. For example, if the formal advice to resubmit was communicated to the student on a Sunday (latest by 5 pm), the student will have to resubmit the work latest by next Sunday 5 pm.

d. If the re-submitted work is also detected to be plagiarized, then the work will be awarded a zero.

e. Resubmission of the work beyond the maximum period of one week will not be accepted and the work will be awarded a zero.

B. Any further offence of plagiarism

a. If any student is again caught in an act of plagiarism during his/her course of study (either in the same module, same semester or in any other semester), the student will directly be awarded zero for the work in which plagiarism is detected. In such cases, the student will not be allowed to re-submit the work.

C. Guidelines

VISUAL PROGRAMMING-COMP 1007– SPRING – 18–CW2 (Case Study)-All-QP

COMP 1007 Page 6 of 9

b. Type 1: In case plagiarism is detected in any component or part submission (submitted at different times) of one assessment (assignment), the deduction in marks will be applicable for the whole assessment (assignment), even if only the component or part submission alone needs to be resubmitted.

c. Type 2: In case plagiarism is detected in a group assessment, all students of the group will be considered as having committed an act of plagiarism irrespective of whether plagiarism is on account of the act of all or a few or only one member. The policy will then be applied to all students.

d. Type 3: Combination of Type 1 and Type 2: In case plagiarism is detected in any component or part submission (submitted at different times) of a group assessment (assignment), the deduction in marks will be applicable for the whole assessment (assignment), even if only the component or part submission alone needs to be resubmitted. All students of the group would be considered as having committed an act of plagiarism irrespective of whether plagiarism is on account of the act of all or a few or only one member. The policy will then be applied to all the students of the group.

e. Type 4: Variation of Type 1 and Type 2: In cases where the assessment consists of components or part submissions that could be a group assessment component (e.g. group assignment) and an individual assessment component (e.g. individual reflection), the following will be applicable:

1. If plagiarism is detected in the group assessment component, all students of the group will be considered as having committed an act of plagiarism, irrespective of whether plagiarism is on account of the act of all or a few or only one member. The policy will then be applied to all students of the group. In such cases the group assessment component will be resubmitted as per the policy.

2. If plagiarism is detected in the individual assessment component, the individual assessment component will be resubmitted as per the policy. The policy will then be applied to that student alone.

3. In both cases (a) and/or (b), the deduction in marks will be applicable for the whole assessment (assignment).

3 D. Amount of similar material

a. The total amount of similar material in any form of student work from all sources put together should not exceed 30% (including direct quotations).

b. The total amount of quoted material (direct quotations) in any form of student work from all sources put together should not exceed 10%.

c. The total amount of similar material in any form of student work from a single source should not exceed 7 percent. However, cases having a similarity of less than 7 percent in such cases may still be investigated by the faculty depending on the seriousness of the case.

VISUAL PROGRAMMING-COMP 1007– SPRING – 18–CW2 (Case Study)-All-QP

COMP 1007 Page 7 of 9

d. If faculty member find enough merit in the case of a student work with a similarity (with a single source) of more than 7 percent as not a case of plagiarism, the faculty member should provide detailed comments/remarks to justify the case.

Late Submission

Students must contact their teachers for specific details of the submission time. Late submissions, will receive a penalty of 5 per cent of the maximum mark for that assessment will be deducted for each working day. Assessment documents submitted beyond a period of one week after the last date of submission will not be accepted and will be marked as zero for that assessment.

VISUAL PROGRAMMING-COMP 1007– SPRING – 18–CW2 (Case Study)-All-QP

COMP 1007 Page 8 of 9

Visual Programming (COMP 1007)

Spring 2018

Student ID: ________________ Student Name: _____________________________________________

Case Study with Presentation Evaluation Grid

Task 1

Deliverables

0

1-5

6-10

Mark

Work Proposal

No submission

Partial completion

Completed work proposal

Deliverables

0

1-4

5

Mark

Report/Documentation

No documentation

Only screen design and source code

Complete screen design, source code references, and introduction

Deliverables

0

1-5

6-9

10

Mark

Database (table with records)

No/Inaccurate database design

Satisfactory database design and records

Good database design and records

Complete and accurate in all aspects

Deliverables

0

1-7

8-14

15

Mark

Connectivity (ADO)

No connectivity

Able to connect database to the application but not through codes

Able to connect database to the application and connected transaction form as well as maintenance form through codes but some errors

Able to connect database to the application properly and through codes for transaction form and maintenance form

Deliverables

0

1-4

5

Mark

Splash screen

No splash screen

Satisfactory design of splash screen

Complete and accurate in all aspects

Deliverables

0-2

3-5

6-9

10

Mark

Login Form

Form design only and no codes

Good design with partially incomplete/incorrect codes as per the requirement

Good design with correct codes but a few requirements are missing

Complete and accurate in all aspects

VISUAL PROGRAMMING-COMP 1007– SPRING – 18–CW2 (Case Study)-All-QP

COMP 1007 Page 9 of 9

Deliverables

0-4

5

Mark

Main Menu

Form design only and no codes

Complete and accurate in all aspects

Deliverables

0-2

3-8

9-11

12

Mark

Maintenance Form

Form design only and no codes

Good form design with partially correct functionality of maintenance form

Good form design with satisfactory correct functionality of maintenance form

Complete and accurate in all aspects

Deliverables

0-2

3-8

9-11

12

Mark

Transaction Form

Form design only and no codes

Good form design with partially correct functionality of transaction form and no error messages

Good for design with satisfactory correct functionality of transaction form with error messages

Complete and accurate in all aspects

Deliverables

0

1-4

5-10

11

Mark

Crystal Report

No Crystal Report

Only 1 simple Crystal Report

2 Crystal reports (1 simple & 1 parameter report) but satisfactory design

Complete and accurate in all aspects

Deliverables

0-1

2-5

Mark

Export Report

Unable to export any report

Able to export reports.

* i will send the file for the steps and also i will send the sample.

* when you finish from my assignment i have to submit in turnitin and that website its looking or searching in my assignment words if i taken from any resource of ( internet, students , books, newspaper …) so you have be careful in that to not become higher then 5%

* please go though the question and follow the steps please. If there is any thing inform me.

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.