Interactive Computer Quiz: vb.net 2013, computer science homework help

Front End Technologies COMP 0385.1 – Spring – 16 – CW2 (Case Study) – All – QP COMP 0385.1 Page 1 of 11 Instructions to students:  Perform all tasks Objective: This is an individual or a group (only two student) assignment aimed to give students the experience to use visual programming language, create simple grap hical user interfaces and reports. Learning Outcomes: 1. Write event -driven programs with the support of an integrated development environment 2. Build simple database applications using ADO.Net 3. Design reports using Crystal Report Task 1: Sub mit a work proposal for this assig nment by the end of week 8th, which must include: Un derstanding of delive rables – a detail descri ption of delive rables Ge neral overview of task 2 - initial understand ing of solution to task2 (7 marks) The work proposal must be s ubmitted in a word file throu gh th e link avai lable in M oodle. assignment Spring 201 6 Module: Front End Technologies COMP 0385.1 ID NUMBER Level: 1 Max. Marks: 70 Duration:6 Weeks Submission Date: : MAY 28th, 2016 Handout Date: 7 th week Front End Technologies COMP 0385.1 – Spring – 16 – CW2 (Case Study) – All – QP COMP 0385.1 Page 2 of 11 Task 2: Interactive Computer Quiz is a tool which involves the use of computer programs to present educational materials through question and answers to students. It can be applied to range of ages from primary, high school and college students . This program is developed to offer a kind of student interaction with the computer screen and is custom -made for a specific domain, topic and group of students. This also includes learning assessments conducting a test based on the topics covered. Your ta sk is to develop a QUIZ application of any topic of your choice/interest (e.g. learning basics , learning to count, learning simple programming, learning advanced subjects of engineering, science etc.). The application should include at least 10 forms for learning materials presentation (lessons) and at least three forms for conducting test based on the presented materials. The application should have a proper flow that a user cannot take the test unless he/she has gone through the lessons. But the user h as the privilege either to take the test directly after the lesson or not . The test should give proper message (s) on the performance of the user based on the score garnered on the test. The application should be creatively design ed , with accurate concepts and contents and is functioning accordingly. (23 marks ) Task 3: 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 cre ate 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. 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 use r to evaluate more than one employee at a time and will Front End Technologies COMP 0385.1 – Spring – 16 – CW2 (Case Study) – All – QP COMP 0385.1 Page 3 of 11 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 s ingle 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 borr owing/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 si ngle 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 Re ntal 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 cal culate the amount to be paid for the rented car 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 s hould automatically calculate the amount to be paid for the Front End Technologies COMP 0385.1 – Spring – 16 – CW2 (Case Study) – All – QP COMP 0385.1 Page 4 of 11 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 allo w 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 s hould not be processed/displayed. Requirements: A. 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. B. 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 1 5 appropriate records C. Create and Design a VB application that will include the foll owing: 1. Connect the created database to your VB application. 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/men u will be displayed with all 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. 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 . Upon opening the form, all fields should not be enabled to do any changes. Front End Technologies COMP 0385.1 – Spring – 16 – CW2 (Case Study) – All – QP COMP 0385.1 Page 5 of 11 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 . In transaction, every time an item/product/service is being rendered to a customer, the database n eeds to be updated for that specific item/product/service. (Example: In a bookstore, if a customer buy 2 copies of VB book, the number of books on hand of the said book in the database should be deducted by 2) Make use of message boxes by displaying error messages with regard to your chosen application. (Example: If the quantity bought is higher than stock on hand or if the payment is less than the amount to be paid, an error message should be displayed by your application/program) Make sure to 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 . 8. Export any of the reports to MS Word/MS Excel/Text format . Task 3 Marking Scheme: A. Report/Documenta tion - 4 marks B. Database (table with records) - 4 marks C. VB application - 32 marks 1. Connectivity - 2 mark 2. Splash screen - 2 marks 3. Login form - 4 marks 4. Main Menu - 2 marks 5. Maintenance form - 9 marks 6. Transaction form - 9 marks 7. Crystal report - 3 marks 8. Export - 1 marks Total marks - 40 marks Task 4: Front End Technologies COMP 0385.1 – Spring – 16 – CW2 (Case Study) – All – QP COMP 0385.1 Page 6 of 11 You have to present and demonstrate your work to your teacher on a specified date given by your teacher (14 th week). During presentation, you may be asked to d ebug code, add and delete records, do transaction, etc. Note: Task 4 is compulsory. Marks for tasks 1, 2 and 3 will depend on the presentation and viva voce. No marks will be awarded for all the tasks without presentation and viva voce. Guidelines Follow the guidelines mentioned below for your assignment.  Form a group of two (2) students.  Assignment documentation/report should be typed.  Both assignment documentation/report and Softcopy of the Applications (task 1 and task 2) should be uploaded in Moodle and will undergo plagiarism detection test through Turnitin (a plagiarism detection tool)  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 topi c.  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 reference d date Front End Technologies COMP 0385.1 – Spring – 16 – CW2 (Case Study) – All – QP COMP 0385.1 Page 7 of 11  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.  Assignment s with 3 or more identical topics will be awarded 0 Marks.  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. MEC Plagiarism Policy As per MEC policy, any form of violation of academic integrity will invite severe penalty. Plagiarised 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 assignme nt 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 cr iteria. 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 ass essment 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 ad vice to resubmit was Front End Technologies COMP 0385.1 – Spring – 16 – CW2 (Case Study) – All – QP COMP 0385.1 Page 8 of 11 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. R esubmission 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. 2 C. Guidelines a. Type 1: In case plag iarism 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. b. 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 o ne member. The policy will then be applied to all students. c. 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 plag iarism 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. d. Type 4: Variation of Type 1 and Type 2: In cases where the assessment consists of components or part submissions that c ould be a group assessment component (e.g. group assignment) and an individual assessment component (e.g. individual reflection), the following will be applicable: Front End Technologies COMP 0385.1 – Spring – 16 – CW2 (Case Study) – All – QP COMP 0385.1 Page 9 of 11 1. If plagiarism is detected in the group assessment component, all students of the group wi ll 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 comp onent 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 c ases (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% (i ncluding 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 sourc e 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 w ith 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 Penalty for late submission - 5% of the maximum mark specified for the 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. Note : Must follow assignments instructi ons. Front End Technologies COMP 0385.1 – Spring – 16 – CW2 (Case Study) – All – QP COMP 0385.1 Page 10 of 11 Front End Application Development (COMP 20006) Fall 2015 Case Study Evaluation Grid Tasks #1 0 4 7 Mark No Submission or student has failed to understand the require ments of the case study Little understanding of deliverables – a detail description of deliverables General overview of task 2 Understanding of deliverables – a detail description of deliverables General overview of task 2 Task 2 Deliverables 0-2 3-4 5 Mark Form Design Satisfactory form design Good form design Creatively done Deliverables 0-3 4-6 7-8 Mark Contents and concepts of the lesson and test Satisfactory concepts and contents Good concepts and contents Excellent concepts and proper/goo d range of contents Deliverables 0 1-4 5-8 9-10 Mark Functionality No functionality Partially functioning according to the chosen topic but test performance is not evaluated Good functionality but test performance is partially evaluated Fully functioni ng according to the chosen topic and test performance is properly evaluated Task 3 Deliverables 0 1-2 3-4 Mark Report/Docu mentation No documentation Only screen design and source code Complete screen desig n, source code and introduction Deliverabl es 0 1-2 3-4 Mark Database (table with records) No/Inaccurate database design Satisfactory database design and records Complete and accurate in all aspects Deliverables 0 1-2 Mark Connectivity (ADO) No connectivity Able to connect database to the application Front End Technologies COMP 0385.1 – Spring – 16 – CW2 (Case Study) – All – QP COMP 0385.1 Page 11 of 11 Deliverables 0 1 2 Mark Splash screen No splash screen Satisfactory design of splash screen Complete and accurate in all aspects Deliverables 0-1 2 3 4 Mark Login Form Form design only and no codes Good design but partially incorre ct code Good design and correct code but only for 1 type of user Complete and accurate in all aspects Deliverables 0-1 2 Mark Main Menu Form design only and no codes Complete and accurate in all aspects Deliverables 0-1 2-3 5-7 8-9 Mark Maintenan ce Form Form design only and no codes Good form design with partially correct functionality of maintenance form Good for design with satisfactory correct functionality of maintenance form Complete and accurate in all aspects Deliverables 0-2 3-5 5-7 8-9 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 an d accurate in all aspects Deliverables 0 1 2 3 Mark Crystal Report No Crystal Report Only 1 Crystal Report 2 Crystal reports but satisfactory report design and content Complete and accurate in all aspects Deliverables 0 1 Mark Export Report Unable to export any report Able to export reports Subtotal Signature of Teacher Sl No Student Id Student Name Total out of 70 Penalty Final Mark 1 2