N/A
Computer Programming Final Assessment: Outline and Rubric Final Assessment: Outline and Rubric 1 Purpose of this Assessment The final assessment for this competency is to create a computer program that includes debugging, Boolean logic, selecting mechanisms, and arrays. You will use Microsoft Visual Studio to create a Visual Basic application that will help a hypothetical friend with tracking his inventory. Items Required for Submission 1. The item required for submission is a Microsoft Visual Studio project containing the program you created for this assignment, which you will submit as a single compressed file (.zip). Step ONE: Preparation Review the material in this competency to ensure that you have an accurate understanding of what your computer program should accomplish. Read and think about the following scenario: Bob, a close friend, owns a bookstore. For years he has kept track of all his inventory manually, using index cards and paper filing systems. Bob has asked you to develop a simple program that he can use to track his book inventory. You will need a PC and the Microsoft Visual Studio software to complete this assignment. If you have not done so already, visit Microsoft Azure and follow the steps to download the latest version of Visual Studio, which is available at no cost for students and your account will be valid for 12 months. Competency Name: Computer Programming Competency Statement: Demonstrate an understanding of computer programming and its applications. Final Assessment Title: Computer Programming Final Assessment Competency Objectives: 1. Demonstrate understanding of computer programming including using object-based language (e.g., Visual Basic). 2. Create computer programs and learn how to debug programs, apply Boolean logic, use selection mechanisms, and create arrays. 3. Demonstrate understanding of other programming languages (e.g., mobile, web). Program Learning Outcome(s): N/A Institutional Learning Outcome(s): N/A https://azure.microsoft.com/en-us/free/students/ Computer Programming Final Assessment: Outline and Rubric Final Assessment: Outline and Rubric 2 Step TWO: Build the Program Build the program and make sure to address all of the following requirements: Search Tab First, create a search tab that includes the ability to search by: Author Title Genre (drop-down) ISBN The search tab may include additional features; for example, a user message indicating if the item was found. Data-Entry Screen Create a second tab for a data entry screen that contains text fields to browse, edit, and add new books by: Author(s) Title Genre ISBN Quantity Price Buttons The data entry screen should include functional buttons that include the ability to: • Add : Allows you to add a new record • Delete: Allows you to delete a record. A confirmation message should prompt after hitting the delete button which allows you to cancel or continue with the deletion • Modify: Allows you to modify any existing record being displayed • First: Move to the first record • Last: Move to the last record • Next: Move to the next record. The next button should continuously loop through the recordset in the forward direction. If the end of the recordset is reached, the next button should restart at the beginning. • Previous: Move back to the previous record. Similar to the next button, the previous button should continuously loop through the recordset in the backwards direction. If the beginning of the recordset is reached, the previous button should return to the end of the recordset. Additional Requirements: • The application should use arrays, loops and conditional statements. • When entering a “new” record, all fields should be required. If any fields have been left blank, an error message should notify the user which field(s) should be completed. Computer Programming Final Assessment: Outline and Rubric Final Assessment: Outline and Rubric 3 • The program should be free of grammatical and/or spelling errors. Step THREE: Document the Program • The program should be thoroughly documented with comments to indicate functionality. See this example for reference: MSDN: Comments in Code (Visual Basic) Step FOUR: Test the Program Functionality • Thoroughly test the program for bugs and functionality. Test the function of your code by feeding it inputs (button presses, data entry, search input) and examining the output. Document any issues you encounter and the solution you use to correct the problem. Step FIVE: Complete Checklist for Submission Before you submit your work, check to see if you have met the criteria noted below. Did you: Create an operable computer program with all of the required components that will help someone keep track of their book inventory? Include a functional search tab that allows users to search by Author, Title, Genre (should be drop- down), and ISBN? Consider and include additional features that add to the functionality of your computer program? Include a data-entry tab which includes the required fields and buttons (Author(s), Title, Genre, ISBN, Quantity, and Price) to browse, edit and add new books? Include all required buttons (Add, Delete, Modify, First, Last, Next, Previous) in the data-entry tab and ensure all buttons function properly? Correctly use arrays, loops, and conditional statements? Create an error message so that blank fields result correctly in an error message? Thoroughly document the program with comments to indicate functionality and are helpful for describing the program flow and functionality? Ensure that your computer program uses accurate spelling, grammar, and punctuation? Step SIX: Submit Your Work ● Your completed files should be submitted through the Final Assessment page of your competency. ● Please note, for files smaller than 10MB (e.g., most Word documents), use the corresponding “+UPLOAD STUDENT FILE” button to upload your Final Assessment documents. For larger files of any type (e.g., voice over PowerPoint files, video presentations), please use the optional TEXT EDITOR to provide a URL where your tutorial faculty can download your file. ● How you create a download URL is up to you, but various free online providers, including Google Drive and Dropbox, offer this service. Please make sure that the URL you provide can be accessed by anyone with the link. For further instructions on how to create public links for uploaded files, consult the support pages for your chosen provider. https://docs.microsoft.com/en-us/dotnet/visual-basic/programming-guide/program-structure/comments-in-code Computer Programming Final Assessment: Outline and Rubric Final Assessment: Outline and Rubric 4 Scoring Rubric for Final Assessment Criterion EMERGING DEVELOPING PROFICIENT EXEMPLARY Search Tab The application does not contain a search tab or does contain a search tab but features are missing and do not function properly. The application contains a search tab but not all the required features are included and/or do not function properly. The application contains a search tab that functions properly and allows the user to search by: Author Title Genre (should be drop-down) ISBN The application contains a search tab that functions properly and allows the user to search by: Author Title Genre (should be drop-down) ISBN The search tab includes additional features such as a user message indicating if the item was found. Data---entry Tab The application is missing a data- entry tab OR contains a data- entry tab but is missing more than two of the required fields and/or more than two of the required fields do not function properly. The application contains a data- entry tab but is missing two of the required fields and/or two of the required fields do not function properly. The application contains a data- entry tab but is missing one of the required fields and/or one of the required fields does not function properly. The application contains a data- entry tab, which includes text fields to browse, edit and add new books. The required fields are: Author(s) Title Genre ISBN Quantity Price Buttons The data-entry tab is missing more than two buttons (Add, Delete, Modify, First, Last, Next, Previous) and/or more than two buttons do not function properly. The data-entry tab is missing two of the required buttons (Add, Delete, Modify, First, Last, Next, Previous) and/or two of the required buttons do not function properly. The data-entry tab is missing one of the required buttons (Add, Delete, Modify, First, Last, Next, Previous) and/or one of the required buttons does not function properly. The data-entry tab includes all required buttons (Add, Delete, Modify, First, Last, Next, Previous) and all buttons function properly. Additional Requirements The application does not use arrays, loops and conditional The application uses arrays, loops and conditional statements. The application uses arrays, loops and conditional statements. Two or more blank fields The application uses arrays, loops and conditional statements. Computer Programming Final Assessment: Outline and Rubric Final Assessment: Outline and Rubric 5 statements properly. Blank fields do not result in an error message. result correctly in an error message. Blank fields result correctly in an error message. Documentation The program is not documented with comments to indicate functionality. The program is minimally documented with comments to indicate functionality. Some comments are not helpful in describing flow and/or functionality. The program is documented with comments to indicate functionality. Some comments are not helpful in describing flow and/or functionality. The program is thoroughly documented with comments to indicate functionality. Comments are helpful in describing program flow and functionality. Writing Mechanics The