Information Systmes HW
Dre_fingerz
term.pdf
ITC 4230, Programming Concepts and Problem Solving II 1
Course Description Advanced study of programming-related problem solving using Visual Basic. Covers object-oriented concepts such as classes, reusability, and encapsulation. Requires Microsoft Visual Basic. See the course syllabus for specific details.
Course Textbook Zak, D. (2014). Clearly Visual Basic: Programming with Microsoft Visual Basic 2012 (3rd ed.). Boston, MA: Course
Technology. Course Software/Tools In order to complete the assignments in this course, you will need to have access to the following software and tools:
Microsoft Visual Basic 2012 (or newer) Express Edition Trial Download or Visual Studio; the Express version may be downloaded from www.microsoft.com/express/Windows;
access to the Internet; and
a computer with Windows XP (Home or Professional), Windows Vista (Basic or above), or Windows 7. Mac users can install a trial version of Parallels Desktop 10 for Mac. Doing so allows Mac users to install and use Microsoft Visual Basic. Use the following link to access and download a trial version of Parallels: http://trial.parallels.com/ Course Material and Textbook note: The material in this course expands upon more advanced approaches to concepts covered in ITC 4210, Programming Concepts and Problem Solving. Also, this course uses the same textbook as ITC 4210.
Course Learning Outcomes Upon completion of this course, students should be able to:
1. Write the syntax for a computer program to perform advanced loops. 2. Create a sub procedure and a function procedure. 3. Use a two-dimensional array to store, access, and search for elements within a computer program. 4. Utilize structures and sequential-access files as integrated components of a computer program. 5. Perform string-manipulation techniques within a computer program. 6. Connect an application to a Microsoft Access database. 7. Create a new class by using the syntax in Microsoft Visual Basic. 8. Create a Web application by using ASP.NET.
Credits Upon completion of this course, the students will earn three (3) hours of college credit.
Course Structure
1. Unit Learning Outcomes: Each unit contains Learning Outcomes that specify the measurable skills and knowledge students should gain upon completion of the unit.
2. Unit Lessons: Each unit contains a Unit Lesson, which discusses unit material.
ITC 4230, Programming Concepts and Problem Solving II Course Syllabus
ITC 4230, Programming Concepts and Problem Solving II 2
3. Reading Assignments: Each unit contains Reading Assignments from one or more chapters from the textbook. Chapter presentations are provided in each unit study guide as Required Reading to aid students in their course of study. Suggested Readings are listed in the Unit I-V, VII, and VIII study guides to aid students in their course of study. The readings themselves may or may not be provided in the course, but students are encouraged to read the resources listed if the opportunity arises as they have valuable information that expands upon the lesson material. Students will not be tested on their knowledge of the Suggested Readings.
4. Learning Activities (Non-Graded): These non-graded Learning Activities are provided in each unit to aid students in their course of study.
5. Discussion Boards: Discussion Boards are part of all CSU term courses. More information and specifications can be found in the Student Resources link listed in the Course Menu bar.
6. Unit Assignments: Students are required to submit for grading Unit Assignments in Units I-VIII. Unit VIII contains two assignments. Specific information and instructions regarding these assignments are provided below. Grading rubrics are included with the Unit I-VIII Assignments. Specific information about accessing these rubrics is provided below.
7. Ask the Professor: This communication forum provides you with an opportunity to ask your professor general or course content related questions.
8. Student Break Room: This communication forum allows for casual conversation with your classmates.
CSU Online Library The CSU Online Library is available to support your courses and programs. The online library includes databases, journals, e-books, and research guides. These resources are always accessible and can be reached through the library webpage. To access the library, log into the myCSU Student Portal, and click on “CSU Online Library.” You can also access the CSU Online Library from the “My Library” button on the course menu for each course in Blackboard. The CSU Online Library offers several reference services. E-mail ([email protected]) and telephone (1.877.268.8046) assistance is available Monday – Thursday from 8 am to 5 pm and Friday from 8 am to 3 pm. The library’s chat reference service, Ask a Librarian, is available 24/7; look for the chat box on the online library page. Librarians can help you develop your research plan or assist you in finding relevant, appropriate, and timely information. Reference requests can include customized keyword search strategies, links to articles, database help, and other services.
Unit Assignments Unit I Homework Part 1—Chapter 13: Complete Exercise 3 (Modify This) on page 302. Complete Exercise 5 (Introductory) on page 302. Part 2—Chapter 14: Complete Exercise 2 (Try This) on page 322. Complete Exercise 11 (Intermediate) on pages 325- 326. Check your answer for Exercise 2 by referring to Appendix B. Click here to access Appendix B. The answers for Exercises 3, 5, and 11 are not in Appendix B, so your grade will be heavily based on how you complete each of these exercises. Click here to access the exercise files for Chapters 13 & 14.
ITC 4230, Programming Concepts and Problem Solving II 3
(Zak, 2014, p. 266)
Part 3: In Part 3 of this assignment, you will create pseudocode and a flowchart that contains the pretest and posttest looping statements. In a Microsoft Word document, complete the following:
1. Jane is standing an unknown number of steps away from a door. First, write the pseudocode that contains pretest (i.e., Algorithm 1) and posttest (i.e., Algorithm 2) algorithms that instruct Jane to walk from her current position to the door. Be sure to include the selection structure to Algorithm 2 to determine if Jane is standing in front of the door. Review pages 294-296 for help with this.
2. Desk-check the algorithms (see page 295 for examples on how to conduct the desk-check). 3. Create a flowchart containing the diamond which represents the pretest loop’s condition in Algorithm 1 (use the
Insert -> Shape -> Flowchart tools in Microsoft Word to create the flowchart). 4. Create a flowchart containing the diamond which represents the posttest loop’s condition in Algorithm 2 (use the
Insert -> Shape -> Flowchart tools in Microsoft Word to create the flowchart). Part 4: In Part 4 of this assignment, you will create an application that plays a sound while the application is running. In Visual Basic, complete the following:
1. Complete the exercise on page 312 of your textbook (#1-4). You will need the Spaceship Solution (Spaceship Solution.sln) file and an audio (.wav) file.
Please be sure the audio file is professional and safe for work. Use any audio file you like—use your own or select one from http://freesound.org. Save each Visual Basic file and the Microsoft Word document before submitting them in Blackboard for grading. Click here for a brief tutorial on submitting more than one file for one assignment. Information about accessing the Blackboard Grading Rubric for this assignment is provided below. Unit II Homework Chapter 15: Complete the “What Time Is It?” exercise in the chapter on pages 331-333. Chapter 15: Complete the “What Do I Owe Each Month?” exercise in the chapter on pages 334-340. Chapter 15: Complete the short exercise “But I Want to Do It a Different Way” on pages 341-342. Chapter 16: Complete Exercise 3 (Modify This) on page 375. Chapter 16: Complete Exercise 8 (Intermediate) on page 376. Click here to access the exercise files for Chapters 15 & 16.
ITC 4230, Programming Concepts and Problem Solving II 4
Information about accessing the Blackboard Grading Rubric for this assignment is provided below. Unit III Homework Chapter 17: Complete the “Price Calculator Application” exercise in the chapter on pages 387-390. Chapter 17: Complete the “Revisiting the Concert Tickets Application” exercise in the chapter on pages 390-394. Chapter 17: Complete Exercise 3 (Modify This) on page 398. Chapter 18: Complete the “Airlines Application” on pages 407-413. Chapter 18: Complete the “Salary Application” on pages 414-417. Chapter 18: Complete Exercise 8 (Introductory) on page 426. Click here to access the exercise files for Chapters 17 & 18. Information about accessing the Blackboard Grading Rubric for this assignment is provided below. Unit IV Homework Chapter 19: Complete the “West Coast Emporium Application” exercise in the chapter on pages 432-436. Chapter 19: Complete the “Will You Share That with Me?” exercise in the chapter on pages 436-442. Chapter 19: Complete the “But I Don’t Know How Many There Are” exercise in the chapter on pages 443-447. Chapter 19: Complete Exercise 4 (Modify This) on page 450. Chapter 20: Complete the “Revisiting the West Coast Emporium Application” exercise on pages 458-464. Chapter 20: Complete the “Medical Bills Application” exercise on pages 467-468. Chapter 20: Complete Exercise 3 (Modify This) on page 472. Click here to access the exercise files for Chapters 19 & 20. Information about accessing the Blackboard Grading Rubric for this assignment is provided below. Unit V Homework Chapter 21: Complete the “Revisiting the West Coast Emporium Application…Again!” exercise in the chapter on pages 485-490. Chapter 21: Complete Exercise 4 (Modify This) on page 493. Chapter 21: Complete Exercise 5 (Introductory) on page 494. Chapter 22: Complete the “Game Show Contestants Application” exercise on pages 498-508. Chapter 22: Complete Exercise 4 (Introductory) on page 511. Click here to access the exercise files for Chapters 21 & 22. Information about accessing the Blackboard Grading Rubric for this assignment is provided below. Unit VI Homework Chapter 23: Complete the “Part Number Validator Application” exercise in the chapter on pages 516-520. Chapter 23: Complete the “Rearrange Name Application” exercise in the chapter on pages 522-525.
ITC 4230, Programming Concepts and Problem Solving II 5
Chapter 23: Complete Exercise 3 (Modify This) on page 534. Chapter 24: Complete the “Connecting…Connecting” exercise (Morgan Industries Application/Employees database) on pages 541-546. Chapter 24: Complete the “I’ll Use My Own Controls, Thank You” exercise on pages 559-561. Chapter 24: Complete the “Coding the Next Record and Previous Record Buttons” exercise on pages 561-562. Chapter 24: Complete Exercise 4 (Introductory) on page 566. Click here to access the exercise files for Chapters 23 & 24. Information about accessing the Blackboard Grading Rubric for this assignment is provided below. Unit VII Homework Chapter 25: Complete the “Red Dragon Games Application” in the chapter on pages 572-577. Chapter 25: Complete Exercise 8 (Intermediate) on page 584. Chapter 26: Complete the “The Bonnette Pool & Spa Depot Application” on pages 589-591. Chapter 26: Complete the “Pool Supplies Application” on pages 601-603 Chapter 26: Complete Exercise 8 (Intermediate) on pages 608-609. Click here to access the exercise files for Chapters 25 & 26. Information about accessing the Blackboard Grading Rubric for this assignment is provided below. Unit VIII Homework Chapter 27: Complete the “Creating a Web Application” exercise in the chapter on pages 614-623. Chapter 27: Complete the “Dynamic Web Pages” exercise in the chapter on pages 630-637. Click here to access the exercise files for Chapter 27. Save your work in separate Visual Basic files for each exercise and attach the files in Blackboard for grading. Information about accessing the Blackboard Grading Rubric for this assignment is provided below. Unit VIII Project For this assignment, you have an opportunity to create an application using Visual Basic or using ASP.NET to create a web application. Choose one of the options below by clicking on the link for the instructions. Option 1: Creating a Personal Web Application Using ASP.NET Click here for the instructions to this project. Option 2: Creating an Application Using Visual Basic Click here for the instructions to this project. Information about accessing the Blackboard Grading Rubric for this assignment is provided below.
ITC 4230, Programming Concepts and Problem Solving II 6
APA Guidelines The application of the APA writing style shall be practical, functional, and appropriate to each academic level, with the primary purpose being the documentation (citation) of sources. CSU requires that students use APA style for certain papers and projects. Students should always carefully read and follow assignment directions and review the associated grading rubric when available. Students can find CSU’s Citation Guide by clicking here. This document includes examples and sample papers and provides information on how to contact the CSU Success Center.
Grading Rubrics This course utilizes analytic grading rubrics as tools for your professor in assigning grades for all learning activities. Each rubric serves as a guide that communicates the expectations of the learning activity and describes the criteria for each level of achievement. In addition, a rubric is a reference tool that lists evaluation criteria and can help you organize your efforts to meet the requirements of that learning activity. It is imperative for you to familiarize yourself with these rubrics because these are the primary tools your professor uses for assessing learning activities. Rubric categories include: (1) Discussion Board, (2) Assessment (Written Response), and (3) Assignment. However, it is possible that not all of the listed rubric types will be used in a single course (e.g., some courses may not have Assessments). The Discussion Board rubric can be found within Unit I’s Discussion Board submission instructions. The Assessment (Written Response) rubric can be found embedded in a link within the directions for each Unit Assessment. However, these rubrics will only be used when written-response questions appear within the Assessment. Each Assignment type (e.g., article critique, case study, research paper) will have its own rubric. The Assignment rubrics are built into Blackboard, allowing students to review them prior to beginning the Assignment and again once the Assignment has been scored. This rubric can be accessed via the Assignment link located within the unit where it is to be submitted. Students may also access the rubric through the course menu by selecting “Tools” and then “My Grades.” Again, it is vitally important for you to become familiar with these rubrics because their application to your Discussion Boards, Assessments, and Assignments is the method by which your instructor assigns all grades.
Communication Forums These are non-graded discussion forums that allow you to communicate with your professor and other students. Participation in these discussion forums is encouraged, but not required. You can access these forums with the buttons in the Course Menu. Instructions for subscribing/unsubscribing to these forums are provided below. Click here for instructions on how to subscribe/unsubscribe and post to the Communication Forums. Ask the Professor This communication forum provides you with an opportunity to ask your professor general or course content questions. Questions may focus on Blackboard locations of online course components, textbook or course content elaboration, additional guidance on assessment requirements, or general advice from other students. Questions that are specific in nature, such as inquiries regarding assessment/assignment grades or personal accommodation requests, are NOT to be posted on this forum. If you have questions, comments, or concerns of a non- public nature, please feel free to email your professor. Responses to your post will be addressed or emailed by the professor within 48 hours. Before posting, please ensure that you have read all relevant course documentation, including the syllabus, assessment/assignment instructions, faculty feedback, and other important information.
ITC 4230, Programming Concepts and Problem Solving II 7
Student Break Room This communication forum allows for casual conversation with your classmates. Communication on this forum should always maintain a standard of appropriateness and respect for your fellow classmates. This forum should NOT be used to share assessment answers.
Grading
Discussion Boards (8 @ 2%) = 16% Homework (8 @ 8%) = 64% Unit VIII Project = 20% Total = 100%
Course Schedule/Checklist (PLEASE PRINT) The following pages contain a printable Course Schedule to assist you through this course. By following this schedule, you will be assured that you will complete the course within the time allotted.
ITC 4230, Programming Concepts and Problem Solving II 8
ITC 4230, Programming Concepts and Problem Solving II Course Schedule
By following this schedule, you will be assured that you will complete the course within the time allotted. Please keep this schedule for reference as you progress through your course.
Unit I Posttest Loops and Counter-Controlled Loops
Review: Unit Study Guide Learning Activities (Non-Graded): See Study Guide
Read:
Chapter 13: Do It, Then Ask Permission (Posttest Loops) Chapter 14: Let Me Count the Ways (Counter-Controlled Loops) Chapter 13 Presentation: See Study Guide Chapter 14 Presentation: See Study Guide Suggested Reading: See Study Guide
Discuss:
Discussion Board Response: Submit your response to the Discussion Board question by Saturday, 11:59 p.m. (Central Time)
Discussion Board Comment: Comment on another student’s Discussion Board response by Tuesday, 11:59 p.m. (Central Time)
Submit: Homework by Tuesday, 11:59 p.m. (Central Time)
Notes/Goals:
Unit II Nested Loops and Sub Procedures
Review: Unit Study Guide Learning Activities (Non-Graded): See Study Guide
Read:
Chapter 15: I’m on the Inside; You’re on the Outside (Nested Loops) Chapter 16: I Hear You Are Breaking Up (Sub Procedures) Chapter 15 Presentation: See Study Guide Chapter 16 Presentation: See Study Guide Suggested Reading: See Study Guide
Discuss:
Discussion Board Response: Submit your response to the Discussion Board question by Saturday, 11:59 p.m. (Central Time)
Discussion Board Comment: Comment on another student’s Discussion Board response by Tuesday, 11:59 p.m. (Central Time)
Submit: Homework by Tuesday, 11:59 p.m. (Central Time)
Notes/Goals:
ITC 4230, Programming Concepts and Problem Solving II 9
ITC 4230, Programming Concepts and Problem Solving II Course Schedule
Unit III Function Procedures and One-Dimensional Arrays
Review: Unit Study Guide Learning Activities (Non-Graded): See Study Guide
Read:
Chapter 17: Talk to Me (Function Procedures) Chapter 18: A Ray of Sunshine (One-Dimensional Arrays) Chapter 17 Presentation: See Study Guide Chapter 18 Presentation: See Study Guide Suggested Reading: See Study Guide
Discuss:
Discussion Board Response: Submit your response to the Discussion Board question by Saturday, 11:59 p.m. (Central Time)
Discussion Board Comment: Comment on another student’s Discussion Board response by Tuesday, 11:59 p.m. (Central Time)
Submit: Homework by Tuesday, 11:59 p.m. (Central Time)
Notes/Goals:
Unit IV One-Dimensional and Two-Dimensional Arrays
Review: Unit Study Guide Learning Activities (Non-Graded): See Study Guide
Read:
Chapter 19: Parallel and Dynamic Universes (More on One-Dimensional Arrays) Chapter 20: Table Tennis, Anyone? (Two-Dimensional Arrays) Chapter 19 Presentation: See Study Guide Chapter 20 Presentation: See Study Guide Suggested Reading: See Study Guide
Discuss:
Discussion Board Response: Submit your response to the Discussion Board question by Saturday, 11:59 p.m. (Central Time)
Discussion Board Comment: Comment on another student’s Discussion Board response by Tuesday, 11:59 p.m. (Central Time)
Submit: Homework by Tuesday, 11:59 p.m. (Central Time)
Notes/Goals:
ITC 4230, Programming Concepts and Problem Solving II 10
ITC 4230, Programming Concepts and Problem Solving II Course Schedule
Unit V Structures and Sequential Access Files
Review: Unit Study Guide Learning Activities (Non-Graded): See Study Guide
Read:
Chapter 21: Building Your Own Structure (Structures) Chapter 22: I’m Saving for the Future (Sequential Access Files) Chapter 21 Presentation: See Study Guide Chapter 22 Presentation: See Study Guide Suggested Reading: See Study Guide
Discuss:
Discussion Board Response: Submit your response to the Discussion Board question by Saturday, 11:59 p.m. (Central Time)
Discussion Board Comment: Comment on another student’s Discussion Board response by Tuesday, 11:59 p.m. (Central Time)
Submit: Homework by Tuesday, 11:59 p.m. (Central Time)
Notes/Goals:
Unit VI String Manipulation and Microsoft Access Databases
Review: Unit Study Guide Learning Activities (Non-Graded): See Study Guide
Read:
Chapter 23: The String Section (String Manipulation) Chapter 24: I’m Suffering from Information Overload (Access Databases) Chapter 23 Presentation: See Study Guide Chapter 24 Presentation: See Study Guide
Discuss:
Discussion Board Response: Submit your response to the Discussion Board question by Saturday, 11:59 p.m. (Central Time)
Discussion Board Comment: Comment on another student’s Discussion Board response by Tuesday, 11:59 p.m. (Central Time)
Submit: Homework by Tuesday, 11:59 p.m. (Central Time)
Notes/Goals:
ITC 4230, Programming Concepts and Problem Solving II 11
ITC 4230, Programming Concepts and Problem Solving II Course Schedule
Unit VII Using “LINQ” and Creating a Class
Review: Unit Study Guide Learning Activities (Non-Graded): See Study Guide
Read:
Chapter 25: The Missing “LINQ” (Querying a Database) Chapter 26: I Love this Class (Creating a Class) Chapter 26 Presentation: See Study Guide Suggested Reading: See Study Guide
Discuss:
Discussion Board Response: Submit your response to the Discussion Board question by Saturday, 11:59 p.m. (Central Time)
Discussion Board Comment: Comment on another student’s Discussion Board response by Tuesday, 11:59 p.m. (Central Time)
Submit: Homework by Tuesday, 11:59 p.m. (Central Time)
Notes/Goals:
Unit VIII Web Applications
Review: Unit Study Guide Learning Activities (Non-Graded): See Study Guide
Read: Chapter 27: Getting “Web-ified” (Web Applications) Chapter 27 Presentation: See Study Guide Suggested Reading: See Study Guide
Discuss:
Discussion Board Response: Submit your response to the Discussion Board question by Saturday, 11:59 p.m. (Central Time)
Discussion Board Comment: Comment on another student’s Discussion Board response by Tuesday, 11:59 p.m. (Central Time)
Submit: Homework by Tuesday, 11:59 p.m. (Central Time) Project by Tuesday, 11:59 p.m. (Central Time)
Notes/Goals:
