Visual Programming

Anonymous
timer Asked: Jan 3rd, 2018
account_balance_wallet $90

Question description

Choose any one from the list of system and ensure to employ the given requirements. 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.

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.
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. Transaction activities mentioned earlier in each system requirements 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.

VP-COMP 1007– Fall – 17–CW2 (Case Study)-All-QP Visual Programming (COMP 1007) Case Study with Presentation Fall 2017 Level: 5 Hand out week: Week 7 Duration: 6 weeks Assignment Submission: Week 13 (6/01/2018, 23:59 Hours) Work Proposal Submission: Week 9 (9/12/2017, 23:59 Hours Total Marks: 100 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 COMP 1007 Page 1 of 10 VP-COMP 1007– Fall – 17–CW2 (Case Study)-All-QP application. Your application should include the ALL requirements stated below. Any additional features of the application will be awarded with marks appropriately. Choose any one from the following list of system and ensure to employ the given requirements:  HR Employee’s Salary Calculation: The application should maintain employee details. The application should allow the user to enter increment (for example: 10% of Basic Pay) for a specific employee then it should automatically calculate the total salary of that particular employee based on employee’s salary and some criteria, which you have to prepare. The current/calculated salary should be stored/updated in the database table. The application should provide an interface that will allow user to evaluate more than one employee at a time and will automatically calculate the total salary of all the employees evaluated. Error message should be displayed if the entered increment is more than 100 and the evaluation process should not be processed/displayed.  Sales/Order System: The application should maintain details of products/items available. The application should allow user to choose any products/items the customer purchases and should request the user to enter the quantity bought for each product/item being purchased. Upon this process, the stock on hand and total of all purchases should be automatically calculated by the application. The application should provide an interface that will allow user to do multiple product purchases for a single customer and should automatically calculate the overall total to be paid based on the purchased products/items. Error message should be displayed if the quantity bought is greater than the stock and the transaction should not be processed/displayed.  Library management System: The application should maintain details about the different books in the library. The application should allow user to lend books to students. A student can take only 5 books for a period of 1 month. Upon this process of borrowing/returning books, the available number of books that can be borrowed should be updated and amount to be paid as fine should be automatically calculated. The application should provide an interface that will allow user to borrow multiple books for a single student and should automatically calculate the overall fine to be paid on late submission. Error message should be displayed if the number of books that can be lent is greater than the limit and transaction should not be processed/displayed.  Car Rental System: The application should maintain details about the cars for rent. The application should allow user to choose from the list of cars for rent and should accept number of days to be rented from the user. The application should automatically calculate the amount to be paid for the rented car COMP 1007 Page 2 of 10 VP-COMP 1007– Fall – 17–CW2 (Case Study)-All-QP based on the entered number of days to be rented and should update the status of that specific/chosen car to “rented”. The application should provide an interface that will allow user to process multiple car rentals on a single transaction/customer and should automatically calculate the overall total to be paid on the rented cars. Error message should be displayed if the chosen car to rent is already rented and transaction should not be processed/displayed.  Hotel Room Reservation: The application should maintain details about the different rooms in the hotel. The application should allow the user to choose from the list of rooms and should accept number of days the room will be reserved. The application should automatically calculate the amount to be paid for the reserved room on the entered number of days to be reserved and should update the availability of the specific/chosen room to “reserved”. The application should provide an interface that will allow user to process multiple room reservations on a single transaction/customer and should automatically calculate the overall total to be paid on the reserved rooms. Error message should be displayed if the chosen room is already reserved and transaction should not be processed/displayed. 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. COMP 1007 Page 3 of 10 VP-COMP 1007– Fall – 17–CW2 (Case Study)-All-QP 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. 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. Transaction activities mentioned earlier in each system requirements 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 COMP 1007 1. Connectivity - 10 marks 2. Splash screen - 5 marks Page 4 of 10 VP-COMP 1007– Fall – 17–CW2 (Case Study)-All-QP 3. Login form - 10 marks 4. Main Menu - 5 marks 5. Maintenance form - 15 marks 6. Transaction form - 15 marks 7. Crystal report a. Simple report - 5 marks b. Parameter report - 5 marks 8. Export - 5 marks 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 COMP 1007 Page 5 of 10 VP-COMP 1007– Fall – 17–CW2 (Case Study)-All-QP  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  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. COMP 1007 Page 6 of 10 VP-COMP 1007– Fall – 17–CW2 (Case Study)-All-QP 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 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). COMP 1007 Page 7 of 10 VP-COMP 1007– Fall – 17–CW2 (Case Study)-All-QP 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. 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. COMP 1007 Page 8 of 10 VP-COMP 1007– Fall – 17–CW2 (Case Study)-All-QP Visual Programming (COMP 1007) Fall 2017 Student ID: ________________ Student Name: _____________________________________________ Case Study with Presentation Evaluation Grid Task 1 Deliverables Work Proposal 0-10    Mark Provided table columns of the chosen system with at least 2 sample data/records. Understanding on the deliverables – which may include the form designs along with codes (whatever have been completed) Time line for completion of each deliverables. Deliverables Report/Docu mentation 0 No documentation 1-4 5 Only screen Complete screen design and source design, source code code and introduction Mark Deliverables Database (table with records) 0 No/Inaccurate database design 1-5 6-9 Satisfactory Good database design database design and records and records 10 Mark Complete and accurate in all aspects Deliverables Connectivity (ADO) 0 No connectivity 1-4 Able to connect database to the application but not through codes 5-9 Able to connect database to the application and connected transaction form through codes but some errors Deliverables 0 1-4 5 10 Mark Able to connect database to the application properly and through codes for transaction form Mark Splash screen No screen Deliverables COMP 1007 0-2 splash Satisfactory Complete and design of splash accurate in all aspects screen 3-5 6-9 10 Mark Page 9 of 10 VP-COMP 1007– Fall – 17–CW2 (Case Study)-All-QP Login Form Form design Good design with only and no partially codes incomplete/incorr ect codes as per the requirement Deliverables 0-4 Main Menu Form design Complete and only and no accurate in all codes aspects Deliverables 0-2 Maintenance Form Form design Good form design only and no with partially codes correct functionality of maintenance form 0-2 3-8 Good form design Complete and with satisfactory accurate in all correct functionality aspects of maintenance form Good for design with Complete and satisfactory correct accurate in all functionality of aspects transaction form with error messages Deliverables Crystal Report Form design Good form design only and no with partially codes correct functionality of transaction form and no error messages 0 1-4 No Crystal Only 1 simple Report Crystal Report Deliverables 0-1 Export Report Unable export report Deliverables Transaction Form Good design with Complete and correct codes but a accurate in all few requirements are aspects missing 5 Mark 3-8 9-14 9-14 5-9 2 Crystal reports (1 simple & 1 parameter report) but satisfactory design 15 Mark 15 Mark 10 Mark Complete and accurate in all aspects 2-5 to Able to any reports Mark export Total Marks Penalty Final marks Signature of Teacher COMP 1007 Page 10 of 10

Tutor Answer

sethamimo
School: Cornell University

Here you go! Let me know if you need any...

flag Report DMCA
Review

Anonymous
Wow this is really good.... didn't expect it. Sweet!!!!

Similar Questions
Hot Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors