Template · Template · Template
Advanced VB.NET Programming
- Section Template
- 4 Credits
- 06/03/2022 to 01/01/2075
- Modified 06/30/2022
This course is a second course in the VB.NET programming sequence and leads to the creation of functional Windows and Web based application programs. Topics include writing user requirements, creating test scenarios and test plans, advanced form design, error handlers, data validation, object oriented programming concepts, database access and programming, use of collections and developing help systems. (Sp)
Prerequisite: Minimum 2.0 in CITP 150 and Reading Level 5 and Math Level 4
Student Learning Outcomes
Upon successful completion of this course, students should be able to:
- Evaluate the needs of end users and their business in order record accurate requirements.
- Write a user requirements document.
- Choose and implement an appropriate deployment based on a user's requirements.
- Create test scenarios and test plans based on user requirements.
- Execute an approved test plan, including recording results and any required software.
- Develop classes and create solutions that use classes, their objects, methods and events.
- Select and apply appropriate data validation techniques, given a problem description.
- Develop Visual Basic Windows Applications and Web Applications that use Common Language Specification (CLS) compliant code.
- Develop a business application that utilizes direct manipulation of ADO.NET objects.
- Develop Structured Query Language (SQL) Select statements to retrieve data from multiple tables of a relational database.
- Develop and use arrays and collections.
- Use and understand Language Integrated Queries (LINQ).
- Use and understand Entity Data Models (EDM) or DataSets to develop Windows and Web Applications that use databases.
- Utilize the Visual Basic (VB) tools to build a database connection to facilitate database access with a given database description.
- Create and produce business reports based on a database.
- Use and understand Structures, Enumeration, Plymorphism and Inheritance.
- Demonstrate the use of ADO.NET database controls.
- Develop a business application that utilizes a Multiple Document Interface (MDI).
- Access system services through Base Class Libraries.
- Evaluate the program requirements to select and apply appropriate exception handling techniques.
- Design and create class modules that define objects and collections, and develop a business application that implements those classes for a given business problem.
- Define and give examples of commonly used Microsoft Windows and VB.NET programming terminology.
- Create multi-page web applications.
- Create web sites using multiple web pages or using Master Pages upon which all other web pages are based.
- Utilize Style Manager to create and maintain Cascading Style Sheets (CSS) in a web application or directly update the HTML source code to create and maintain styles.
- Develop applications that utilize existing Windows Communication Foundation (WCF) services.
- Add security features to web applications using login controls and the ASP.NET Web Site Administration Tool.
- Utilize XML data in VB.NET applications.
- Describe Windows Presentation Foundation (WPF) and know how to build WPF applications.
Tools, Equipment or Apparel (required of the student)
Hardware: USB storage device (1 gigabyte or more) recommended for storing and transporting homework. As an alternative you may use CD, DVD, sufficient free local hard disk space, or cloud-based storage solution.
Software: Internet Access, Web browser (current version Internet Explorer preferred), word-processing software, Adobe Reader, up-to-date virus protection, MS-Visual Studio (available for download at no charge through Microsoft’s Academic Alliance Program after the start of classes)
All required software can be downloaded for free and is also installed in the West Campus and Main Campus computer labs. Lab hours are posted at each lab and are subject to change.
Technical skills: Basic computer skills, including the ability to:
- Use email
- Add and open attachments in email
- Create new files
- Modify existing files
- Save files in commonly used word processing program formats
- Copy and paste text
- Download and install software
- Create Windows compressed folders for submitting assignments
Student Electronic Access to Grades
D2L is the College’s Course Management System which includes a gradebook function allowing students access to their grades in order to receive timely and meaningful feedback on their progress in the course at any time. These grades will align with the Evaluation Criteria listed in this syllabus. D2L is accessed through the MyLCC page.
Whenever practicable, results for graded items should be posted electronically within 48 hours after the instructor has completed the grading process for the items, and final grades for the course should be entered no later than the specified grading day.
All assignments include information about how, what, and where to submit your files. Typically, you will use the D2L Drop Box feature. Feedback for each assignment can be viewed by logging back into the D2L Drop Box. Typically, you will receive your score and feedback within 2-3 business days after submission. Missing or incorrect work may be resubmitted although a late penalty will likely be assessed. All points earned during the semester are totaled at the end of the semester and applied to the grading scale (see below).
Assignments will be graded on design, structure, code quality, adherence to class standards, documentation and output. Assignments can only receive full points if error free with all test data and include all required documentation. Partial credit for incomplete assignments will be given only for the final program of the semester. The criterion for evaluating the work is:
- Documentation = 15%
- Design, Style, Standards = 35%
- Correct Output = 50%
As a general rule, make-up tests will not be provided. Dropping the lowest Test score will cover one missed test.
Unless otherwise noted, all assignments are to be the work of an individual student, not a group. However, you may assist classmates as long as each maintains their own electronic version of the solution.
120 points (drop the lowest)
College Grading Standards
Recommended Guidelines for Student Grades
4.0 --- Excellent
4.0 --- 91 – 100%
364 – 400 points
3.5 --- ---------
3.5 --- 86 – 90%
344 – 363 points
3.0 --- Good
3.0 --- 81 – 85%
324 – 343 points
2.5 --- ---------
2.5 --- 76 – 80%
304 – 323 points
2.0 --- Satisfactory
2.0 --- 71 – 75%
284 – 303 points
1.5 --- ---------
1.5 --- 66 – 70%
264 – 283 points
1.0 --- Poor
1.0 --- 60 – 65%
240 – 263 points
0.0 --- --------
0.0 --- 0 – 59%
0 – 239 points
CITP 250 Course Policies
Plan to spend 2 to 3 hours per course credit each week on the weekly lessons (approximately 8 to 12 hours total). Each week you will do some reading and work on assignments related to the content, viewing the tutorials created for the assignments and studying the demo projects. Online students must take the final exam at a testing center. It will be VERY IMPORTANT to stay on schedule.
Tutoring Services provides walk-in CIT tutoring, also referred to as Supplemental Instruction (SI) for several courses, sometimes including CITP 250, based on scheduled availability of tutors or can arrange tutoring by appointment. If you are interested in or feel you need tutoring for this class, contact:
- Tutoring Services, A&S 103
- Phone: (517) 483-1206
- E-mail: [email protected]
The help you get is intended to assist you in your learning rather than complete your assignment. It is important to learn how to more efficiently troubleshoot your programs to identify what changes need to be made. Learn how to prevent problems rather than identifying and correcting them.
All tests and the final exam are completed in D2L and are open book, notes, and assignments. There is a 1 point per day late penalty after the due date for all parts of each assignment excluding weekends and holidays. All assignments must be correct and complete before they are accepted (except for the last assignment, if necessary).
Late Tests and Assignments
To receive full credit, all assignments must be submitted on or before the due dates listed in the class schedule. Work submitted after the due date is subject to a late penalty. Typically taking tests late is not available as a missed test will serve as the dropped score at the end of the semester.
CIT Program Policies
Class Participation Expectations
Participation is determined when the student logs into D2L on a regular basis (3 times a week minimum), submits assignments on time, and takes exams at the approved time and place. Students in face-to-face sections are expected to attend each class session. It is the student's responsibility to contact the instructor if the student must miss a due date. Missing a scheduled activity, for any reason, including illness or late registration, in no way relieves the student of the responsibility for completing all work in the course to the satisfaction of the instructor according to the class schedule.
Netiquette (or network etiquette) is defined as a set of principles developed to express courtesy and to help people act appropriately while sending e-mail and using the Internet. All of us (instructor and students) will demonstrate netiquette and civility whenever interacting with each other. Please use standard “Business English” (complete sentences) and not jargon or slang for all communications.
Consider anything said in the public forums to be public information. Don’t post comments that may be controversial, abrasive, or in poor taste or information that may reveal too much personal information - protect your privacy!
Each student is expected to be honest in his or her work. Cheating and plagiarism are dishonest. The purpose of this policy is to establish College definitions of cheating and plagiarism and to describe potential consequences of academic dishonesty. This policy applies to all students.
The term "cheating" includes but is not limited to:
- Use of any unauthorized assistance, including electronic devices/media or on-line resources, in taking quizzes, tests, or examinations;
- Dependence upon the aid of sources beyond those authorized by the instructor in writing papers, in preparing reports, in solving problems, or in carrying out other assignments such as those involving sounds as well as moving or still images;
- The acquisition of tests or other academic materials without permission of the faculty or staff to whom the material belongs. Any interaction with any person other than the instructor or proctor in a testing situation may be interpreted as cheating;
- Academic honesty is twofold on the part of the student; first, not to cheat, and second, not to enable others to cheat.
The term "Plagiarism" includes but is not limited to the use, by paraphrase or direct quotation or the inclusion of electronic sources, of the published or unpublished work of another person without full and clear acknowledgment. When producing work for a course, students are expected to present their own ideas and to appropriately acknowledge the incorporation of another person's work. Not doing so is dishonest.
For any of these violations, the student is subject to academic penalty and other disciplinary action. Academic penalty may consist of a "0.0" grade for the offending work or (with departmental approval) a "0.0" grade for the course.
Computer Resources – Acceptable Use
Use of College-owned computer resources is a privilege extended by the College to students, employees, and other authorized users as a tool to promote the mission of the College. All users agree to be bound by the terms and conditions of the LCC Acceptable Use Policy at the time they complete an account application form. Copies of the LCC Acceptable Use Policy are available at the Library Circulation Desk and may also be accessed on the World Wide Web. The URL is http://www.lcc.edu/policy/policies_1.aspx#ACCEPTABLE_USE_POLICY
Theft or Other Abuse of Computer Facilities and Resources, including but not limited to:
- Unauthorized entry into a file, to use, read, or change the contents, or for any other purpose.
- Unauthorized transfer of a file.
- Use of another individual's identification and/or password.
- Use of computing facilities and resources to interfere with the work of another student, faculty member or college official.
- Use of computing facilities and resources to send obscene or abusive messages.
- Use of computing facilities and resources to interfere with normal operation of the college computing system.
- Use of computing facilities and resources in violation of copyright laws.
- Any violation of the college's Acceptable Use Policy at http://www.lcc.edu/policy/policies_1.aspx#ACCEPTABLE_USE_POLICY
CIT INTERNET USE POLICY
Most Computer Information Technologies classrooms are set up with Internet access for course work and research.
Class-Related Use of Internet Resources
Student access to classroom Internet resources will be determined by the course faculty as part of their classroom management function, i.e., faculty will determine appropriate in-class use based on course outcomes and class objectives and will determine those times when it is appropriate to access these resources and which times access to these resources will be restricted in order to better focus on course outcomes and class objectives which don’t require access. If students are found using the Web inappropriately or at those times that the instructor has restricted access, the same penalties listed below under “Personal Use of Internet Resources” will apply.
Personal Use of Internet Resources
Web access is for course work only. At the beginning of a class session, Facebook and other social media, instant messaging, and/or any other personal use of the Web is prohibited. If you are found using the Web for personal use during class time you will be issued a warning, and if found repeating personal usage, you will be dismissed from the class for a day. A third offense will result in dismissal from the course.
Classroom faculty may choose to include specific language in a Course Syllabus or Outline which further defines the acceptable use within their classroom. These statements will be considered sanctioned by the CIT Program and will fall within the guidelines of this policy.
Up to a maximum of 10 extra credit points may be earned by online students by posting relevant questions or responses on the class discussion boards and by face-to-face students by class attendance.
For transfer information, please consult the LCC Transfer webpage. In addition, the Michigan Transfer Network website allows students to search how courses transfer to colleges and universities statewide.
The Michigan Transfer Agreement (MTA) simplifies the transfer of students from one Michigan institution to another. For the most current information, see the LCC General Education webpage.
Students interested in transfer should contact the Academic Advising Center in the Gannon Building - Star Zone, (517) 483-1904.
Students with disabilities who may need accommodations in this class should contact the Center for Student Access (CSA). They are located in the Gannon Building, Star Zone - Center for Student Support. You can also access the Center for Student Access website, or call (517) 483-5323. Contacting the Center early helps ensure that accommodations are put in place as soon as possible.
Student Code of Conduct and General Rules and Guidelines
The College recognizes the value and importance of a safe and orderly learning environment that supports honesty, integrity, and ethical conduct. The Student Code of Conduct and General Rules and Guidelines ensure the protection of student rights and the health and safety of the College community. The College has established procedures for reporting and addressing alleged violations.
Students must follow the Student Code of Conduct and the General Rules and Guidelines. Also, the instructor may establish reasonable guidelines within the classroom. Violations of the Student Code of Conduct and General Rules and Guidelines may be reported to the Office of Student Compliance.
Instructors will verify participation in a course by the 8th day after the start date of sections less than 8 weeks long, and by the 15th day after the start date of sections 8 weeks or longer. Students who have not participated will be dropped from the course and may be responsible for any non-refundable fees.
Academic Success Coaches (ASC)
Student success is our first goal. Our Academic Success Coaches mentor students to help them meet their educational, personal and career goals. Faculty or staff may refer you to an ASC for help if you are not doing well in a class. Please watch your LCC email for a referral.
We also suggest you contact an ASC on your own if you need help or advice to reach your goals.
LCC provides equal opportunity for all persons and prohibits discriminatory practices based on race, color, sex, age, religion, national origin, creed, ancestry, height, weight, sexual orientation, gender identity, gender expression, disability, familial status, marital status, military status, veteran’s status, or other status as protected by law, or genetic information that is unrelated to the person’s ability to perform the duties of a particular job or position or participate in educational programs, courses, services or activities offered by the College.
The following individuals have been designated to handle inquiries regarding the nondiscrimination policies: Equal Opportunity Officer, Washington Court Place, 309 N. Washington Square Lansing, MI 48933, 517-483-1730; Employee Coordinator 504/ADA, Administration Building, 610 N. Capitol Ave. Lansing, MI 48933, 517-483-1875; Student Coordinator 504/ADA, Gannon Building, 411 N. Grand Ave. Lansing, MI 48933, 517-483-1885; Human Resource Manager/Employee Title IX Coordinator, Administration Building, 610 N. Capitol Ave. Lansing, MI 48933, 517-483-1879; Student Title IX Coordinator, Gannon Building, 411 N. Grand Ave. Lansing, MI 48933, 517-483-9632.
COVID-19 Safety Precautions
All students, employees and visitors have a part to play in keeping LCC safe. Anyone who enters campus must follow the safety measures outlined on the Keeping LCC Safe webpage. Reports of noncompliance with current work safety rules and public health orders will be sent to the Student Compliance Office for action. Students with questions or concerns should email [email protected].
Media Release Statement
Photographs, pictures, slides, movies, video, or other media coverage of students may be taken for College-related business, in connection with their enrollment or participation in LCC activities without compensation from LCC, its Trustees, officers, directors, employees, students and agents of each of them. Photographs, pictures, slides, movies, video, or other media coverage of students may be used for any legal purposes.
For rules and procedures on matters such as Academic Calendar, Withdrawals, Incompletes, Appeals, etc., please review the College Catalog, and contact your Academic Advisor or Academic Success Coach.
Student Initiated Withdrawal
You may withdraw from this course before the second week of class without notation on your record. If you drop the third week through the sixth a "W" grade will be issued. If you decide to drop after this date, a passing grade-to-date is required for a "W". A "W" grade will be issued only if the student is passing at the time the withdrawal is requested. Check the semester schedule book for the exact dates for drops and/or refunds.
Incomplete ("I") is only given for the most extenuating circumstances if 80% of the coursework has been completed. All "I" grades should be completed by the end of the following semester in which the course was taken. Any "I" grade that is not completed within that period will automatically turn to "0.0".
A student who wishes to sit in on a class without taking exams or turning in assignments may register as an Audit student. An auditing student receives a grade of "X" at the end of the term, regardless of work completed during the term. Audited courses do not count toward degree requirements. If you wish to audit this course you must go to Registrar's office to have your enrollment status changed to audit.
Students are expected to submit all assignments and take all quizzes according to the class schedule (or make other arrangements well in advance of the scheduled due date. Failure to do so may result in academic penalty. The student is responsible for taking tests at the approved time and place, and for submitting assignments on time. If a student misses any due dates for activities, it is the student's responsibility to contact the instructor.