*CIS 3145 Syllabus: Business Application Development with Visual Basic ( 3 credit hrs.)

Texts: Programming in Visual Basic.Net 2008. Bradley, J. and A. Millspaugh. McGraw-Hill 2008--ISBN 9780073517209. student CD with data files and student version of VB.Net included(do not install it.) Complete VB.NET Professional Edition 2008 software is on school network and is available for purchase from the ELMS Web Site. You also have a user account on the remote Citrix server that is available 24/7.

Materials: Secordary memory as needed; purchase of at least one memory stick (approx. $10).

Prerequisites: CMS 2010 and CMS 2110

Learning Objectives: This 3000 level class contains level 2 and 3 objectives (Bloom) beyond the recognition and recall level. Hence an understanding and ability to apply theory is required. The student will be evaluated on the degree to which concepts can be applied; items on exams will relate directly to these following objectives. Upon completion of this course, the student should be able to:

  1. Implement programming constructs using the Visual Basic language and Visual Studio environment (IDE).
  2. Author procedures and functions, call the procedures, passing parameters, and returning values.
  3. Develop VB programs—both Windows and Web applications that are validated and error-trapped.
  4. Understand the basic concepts of event-driven programming in the VB.net environment.
  5. Use  the Rapid Application Development (RAD) systems development method to develop a Visual Basic application.
  6. Apply principles of arrays and structures in coding assignments.
  7. Develop business applications that use databases and display and print reports.
  8. Author class definitions, use their objects in projects, and understand the basic concepts of object-oriented programming in the VB environment.

 Attendance, Testing, Grading: You are responsible for all information given in class labs and in assigned reading material. Class attendance is a course requirement. In order to complete the course requirements, you will need to spend considerable time outside of class time using VB.Net 2005 Professional Edition. There will be one handson lab test, three traditional tests ,Visual Basic tutorials and lab exercises that will account for 80% of your grade. Lab exercises are assigned in class and are due at the end of the class period in which they are assigned. The remainder of your grade (20%) will be based on 3 stages of a progressive case development; project homework is due weekly.

Exam 1

15%

week 6

 Visual Basic lab exercises

10%

Weeks 1-14

Exam 2

15%

week 11

Weekly Tutorials

10%

Weeks 2-14

Final Exam

15%

week 16

Case: Phase 1

5%

Weeks 1-5

HandsOn Test

10%

week 5

Case: Phase 2

5%

weeks 6-12

Instructor specific

5%

weekly

Case: Final OOPs Version of case

10%

week 15

Assignments are to be turned in on or before the date due (NO late assignments; partial credit is better than a 0 you receive for late assignments.) Completed plans for Case Study (50% of grade) must be submitted before final program is graded. Material to be turned in includes documentation as well as programs--including hardcopy printouts, as well as in electronic form on disk. Formal accompanying documentation required for Final Project.

Classroom Policy: I adhere to MSCD religious holiday policy, student disability policy, academic dishonesty, NC policy (NC date is 3/31.) The student has an obligation to advise instructors of any registered disability, and attempts to accommodate the student will be made. Attendance is required, without it being part of your grade. The student is responsible for any withdrawals. A standard grading system is used: => 90 is A; => 80 is B; => 70 is C; => 60 is D; below 60 is an F.


 

Classroom Topics

WEEK 1: Orientation.  VB Introduction: the .Net Framework and event-driven programming within an IDE. Review of programming logic. Programming constructs; course expectations and organization. 

WEEK 2: Review planning programs. Controls. User interface design. Ch 2 Program documentation. Modularity. RAD Rapid Application Development.

 WEEK 3: Ch 3 Containers and calculations. Parsing input and Formatting output. Counters, accumulators. Handling exceptions with Try...Catch.

 WEEK 4: Ch4. Validation. Coding conditions and calling procedures. Objects, properties, events and methods. 

WEEK 5: Handson Exam planning, writing, testing, debugging a VB application. Ch5. Common Windows controls. Writing Procedures and Functions.

WEEK 6:  Exam I on Ch 1-5: Ch 6,14 (pp. 544-50 only) Multiform projects and class definition by visual inheritance. MDI and SDI. Toolbars/statusbars. Scope and lifetime in VB.

WEEK 7: Ch7. Loops, lists, collections. Counting. Printing basics with e.graphics.drawstring(). PrintDocument controls, callbacks, and modularity.

WEEK 8: Using arrays in VB programs. Chapter 8. Control arrays, structures, table lookups. Concepts of arrays  .

WEEK 9: Ch 9. Programming Web forms. File system Web sites. Managing state. Web server use of asp.Net Framework library; managing delivery of  Web applications. Static vs. dynamic Web applications. ASP and server side applications.

SPRING BREAK--ENJOY!

 WEEK 10: ADO.NET. Accessing databases with VB programs. SQLDB Connection strings and the DataSource Wizard Commands, datasets, role of SQL. ADO.net. Report Designer and Crystal Report Wizard.

WEEK 11: Exam II. Update on course objectives. Ch  11. StreamReader and StreamWriter methods for traditional file processing. List boxes and text files.

WEEK 12. Chapter 12. OOPs principles. Creating classes of objects Writing and using class definitions. Encapsulation, polymorphism, Inheritance. Regions in class definitions.  Multitier applications. Constructors and destructors

WEEK 13 OOPs continued. Shared variables. Derived classes and object instantiation.

WEEK 14: Chapter 13 sampler.  Putting it all together. GDI.  D ‘n D. Multimedia elements. Reviewing final project requirements.

WEEK 15 . Usability testing and RAD delivery. Final Project troubleshooting. Formal submission includes system flow and program, description.

WEEK 16: FINAL EXAM: MSCD schedule.

Reading & Lab Activities

Review of MSCD network, location of programs needed. ELMS site and other tools for program planning, documentation. Chap. 1 Hello World tutorial. Prepare Very Very Boards Case project.

Components of a project. Compiling to MSIL. Ch2 class exercise. Basic I/O and user choices : Ch 2 HandsOn tutorial. Complete VV Boards case.

Chapter 3. Submit class exercise and HandsOn tutorial. Complete Very Very Boards Case Study.

Learn to use VB Debugger. Submit class exercise and HandsOn tutorial. Complete VV Boards Case Study. Prepare for in-class HandsOn lab test on Exercises 4.1-4.9.

Submit HandsOn tutorial. Complete VV Boards Case Study. Feedback on HandsOn solutions.  Layout, graphical user interface (GUI) design Review for Exam I.

 Chapter 6 Submit class exercise and HandsOn tutorial. “Recycling” VB projects. Complete VV Boards Case Study, adding MDI or toolbar/statusbar.

Chapter 7. Exam feedback. Submit class exercise and HandsOn tutorial. Lists as items collections. Complete VV Boards Case Study.

Chapter 8. Submit class exercise and HandsOn tutorial. Complete VV Boards Case Study

 

Ch 9. Running Web forms .Differences in Web and Windows applications.  IIS servers. Submit class exercise and HandsOn tutorial. Complete VV Boards Case Study.

 

SPRING BREAK

Chapter 10: Using a Provider and SQLDB connections. Submit class exercise and HandsOn tutorial. Complete VV Boards case study with Crystal Report. Review for Exam II.

Take  Exam II. Covers related Web pages and Chapters 6-10, part of 14. Complete VV Boards case study.


Ch 12. HandsOn tutorial and class variables and methods exercise. Intro to Class Designer and Test Bench for class definition. Release requirements for Phase III Final Project—. Prepare VV Boards case study.

Ch 12 continued. Visual inheritance, multi-class projects. Object Browser. Review case study.

Do 2 tutorials of choice in Chapter 13, 14 to use in final project. MDI, Web browser controls, hyperlinks.

Ch 14. Validating events.Security issues for .NET Web and Windows applications. Handson practice with ClickOnce deployment.  All Final Projects due.

Final covers chapters 11-14 and general programming theory. 

*Syllabus is subject to change.