INFO465 - Senior Projects in IS - Spring 2010

Current Stuff:

Topics & Dates:

(5/19) Intro to the course:Syllabus and A 'Design & Build' Experience. Please note the course objectives in the syllabus and plan to demonstrate that you've met them, repeatedly!

My objective as an instructor trying to maintain the value of our IS Degree is to _see_ that each student can listen, read, write, take direction, and demonstrate proficiency in concepts and tools for analysis & design, database, structured & OO programming, and project planning. Max points are posted for the best results.

The course is the capstone for our technical core of INFO350-Programming, INFO361-Analysis & Design, and INFO364-Database.  It revisits the topics and challenges skills developed in these courses, and requires that a student recognize and produce professional quality application objects, docs, and other artifacts of projects.

Get your development software if you don't already have it: PHPers please request a login account at INFO465.info; most Microsofters have VS.NET 2005 or 2008, but if you need to get it, MSDNAA will not be up until Thursday.

The Ledger Engine is in your future...

(5/21) Reviewed Pop Quiz #1, Pop Quiz #2 was to sketch UML Sequence Diagram of an order entry & fulfillment scenario demo'd with app and database info465.info/gschool/ involving customer, order picker, and ACH.

Project #1, Deliverable #1 Part #1 demo'd and assigned: Part 1, due June 2nd) Be able to authenticate two classes of Users, Landscaper & Helper, with reference to a table like the BE/BusinessEntity table used in class, and deliver an appropriate menu to them. Part 2, due June 11th) Have a suitable interface for CRUD on the BusinessEntity & GoodsAndServices table: able to create new records, lookup existing ones & update them. 3) Make sure to support CUA cursor movement and provide ComboBox or other 'lookup' so the user never has to guess about codes, ledger accounts, or foreign keys.

Review software architectures: Structure (sequence, alternative selection, loops, error-handling, subroutines/functions) & Object Orientation (properties, methods, events, inheritance, &c); Sketched these on the board, looked at scripts for authenticating a user..

(5/26) Authenticating a User w/ reference to a Database: Intro to VisualStudio.net, Visual Basic, Windoze Forms, Plain Classes, OLE, JET, & ACE options in Database Connection String, where to put an Access Database (in bin/debug/ ), &c, &c...

Some people are still using VS8-2005 and Access-2003 and the database connection should work as in the sample scripts. For those using VS9-2008 and Access-2007, use this instead:

Dim AuthCnxn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=YourDBName.accdb")

(5/28) Lab Time to connect apps to database, &c

(6/2) Sketches & start verbal specs for this semester's Project #1: Sketched on the board and discussed diagrams for Dlv #2: Use Case, Class Diagram, Database ERD. Also critiqued 1st of a few Dlv #2 submits from prior semesters of similar projects. Then, checked in Dlv #1a - Authenticate a User.

(6/4) Objects & Scripts for ' Table Maintenance'. Look at sample scripts for tricks common to database programming like escaping single-quotes, handling NULL data, matching up ComboBox index with data in the table, searching for records, syntax for insert/update, loading a listbox with the 'array list' scheme, &c...

(6/9) Business process modeling using the Sample Database Relationships among Entities, GoodsAndServices, Orders, Details, assigning ledger accounts to Details; Journalizing activity.

(6/11) Project Survival Guide A quick consideration of McConnel's view of what's important about software projects, Process of planning & documentation Maslow's hierarchy of needs applied to IS Projects, &c, &c...

(6/16) Look at Scripts for Order & Detail Entry; Checked Project #1 Dlv 1 - 'Table Maintenance' for BE & GS tables.

(6/18) Rubric for scoring Dlv #4, Dlv #2 assigned, Documentation package as critiqued in class: Overview; Use Case Diagram and Detailed Use Cases for each Actor; Class Diagram showing architecture of the applications components; A concise Data Dictionary; Tables populated with sample data showing a startup and a couple days' operations; & a Trial Balance prepared from the Details in the sample. Submit these as a printed copy in class, and as a single document, optionally zipped, and attached to VCU mail, on or before the deadline.

(more 6/18) Look at: XMIT a JV via email; 'Journalization' processes; SQL's format function applied to date/datetime columns; getting dates into a combo box for selection; Displaying a Journal; methods for getting the decimal point out of dollars and cents to conform to psX12's standards; 'hash totals' and counters for psX12 control values; emailing a psX12 JV (email a CAT). For those who would like to use a Web Service to xmit their JVs, sending a psX12 JV via web service is provided. Please note, there is nowhere posted an 'xmit a JV' script. 'email a CAT' is provided to show syntax and logic for using .NET's smtp client to launch email. 'display a JV' is provided to show how to make display 'human readable' Journal. You'll need to 'put them together' or design a fresh approach...

(6/23) Review for Deliverable #2, critiqued 3 similar packages on the board, broke for lab time in class about Dlv #2 &c.

(6/25) Review Structure, pop quiz about it, more to come.


Project #1 Resources:

  • Where to get MSDNAA software: I dredged up this link...
  • Demo in class, make new VS.NET Solution & Project, put an Access database in its bin/debug directory, started a 'user authentication form' similar to Authenticating a User
  • Business process modeling of The Accounting with the Sample Database, on the board & in a working prototype; Critique some past Deliverable #2 submits;
  • Authenticating a user, and Table Maintenance'; searching, loading list & combo boxes; Take on Customer Data from flat file to database.

    Connection String for VS & Access 2007 projects:

    Dim AuthCnxn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=InClassSpring09.accdb")

  • Debits & Credits; Chart of Accounts; More business process modeling using a sample application and database. Sample Database; A sample accounting (is _not_ 'the details')
  • Open Lab in class, following a quick look at SQL for making Trial Balance and Journal.
  • EDI Standards: ANSI X12 handout; discuss psX12 (pseudo X12) used in INFO465
  • Look at Scripts for Order & Detail Entry; Look at: 'Journalization' processes; SQL's format function applied to date/datetime columns; getting dates into a combo box for selection; Displaying a Journal; methods for getting the decimal point out of dollars and cents to conform to psX12's standards; 'hash totals' and counters for psX12 control values; emailing a psX12 JV (email a CAT); optionally, sending a psX12 JV via web service; rubric for scoring Dlv #4.
  • FAQ (First Asked Questions) for questions in email..

Project #1

Project #1's Deliverables 2, 3, & 4:
  • Dlv #2, Documentation package as critiqued in class: Overview; Use Case Diagram and Detailed Use Cases for each Actor; Class Diagram showing architecture of the applications components, either from an Application point of view (Solution Explorer explained), or from a Database point of view showing entities with their Methods; A concise Data Dictionary; Tables populated with sample data showing a startup and a couple days' operations; & a Trial Balance prepared from the Details in the sample. Submit these as a printed copy in class, and as a single document, optionally zipped, and attached to VCU mail, on or before the deadline.
  • Dlv #3, MSProject Plan for your Individual Project #1, Max points may be found in these guidelines. Make sure to mark all effort completed as of the 11th as completed, and that File -> Properties looks reasonable. Deliver a well-formatted, printed copy in class on the deadline. Submit another copy as an attachment to VCU mail, on or before midnite of the deadline.
  • (4/23) Dlv #4, Good Looking Trial Balance that equals the one displayed from the Landscaper's menu from the application's database, by midnite at the deadline. A point will be docked for each midnite that passes without the GLTB at the Ledger Engine, up to the max of five points. See this Rubric for scoring this deliverable. No other points will be deducted for late delivery of the completed application, the due date for which is the last day of class.

F I N A L Points posted. Check them over, please and let me know any problem you might see...

The Ledger Engine is eagerly awaiting _valid_ psX12 JVs to build Good-Looking Trial Balances. It's email address is ledgerengineATinfo465.info (Replace the AT with @, any address here will get spammed like crazy...) Streams of JVs originating by Midnite Thursday will get 5 Points Max, others will lose one per midnite passed without the GLTB.

Front Runners:Please use the 'Last 25 Emails' report to get an eye on what you're transmitting. Check out the psX12 standards, or use the Last 100 Emails, to get your eye on the format for a psX12 JV. Mr A, you're still putting the *!*! line on the first line of your body text & it doesn't belong there. And, the psX12 standard doesn't use () around credits, it uses a minus sign. Dollar amounts xmitted in a JV should be formatted without a decimal point the same way they are in a CAT. Ms M & Mr L, your pounding at the door with CAT transactions which I hope will soon be valid JVs.

Blank Use Case Form

A Yahoo Group , info465su09, has been set up for the class and invitatory emails have been sent to each student's VCU email. Please join up, or let me know if you need another invite. The Files section has a Database ERD and a zip containing a working, rough VB.NET prototype app. Any documents prepared for Project #2, please prepare for this set of tables.