INFO465 - Senior Projects in IS - Spring 2012

Current Stuff as at May 14th:

F I N A L Grades are posted.

Team Points for Project #2: Extra points were added to the Final Deliverable for Project #2 based on the quality of the artifacts the team delivered and demo'd. For the couple of teams who didn't turn in or demo a final product 10 points were assigned -- it appears they could do the work if pressed for it but didn't take initiative to get me good looking stuff.

Upload your Project #1 Dlv #4: Zip it up with Windows Zipper (not RAR please) and upload it via this Upload Link. Several are missing as at Saturday mid-day.

Exit Exam and Last Chance to Demo Projects: We're using the exam time for the class, 8:00am Thursday the 10th, for the 2nd part of the ISA exam and to demo Project #1 and #2 deliverables. At this time, it looks like we'll be using the regular classroom for the ISA exam with students bringing their own laptops -- plus I'll have 'the cart' with spares for those who don't have a functioning laptop. Watch this spot for the room assignment, may be updated next week.

JV Date

Some students pounding at the ledger engine today needed help getting the date for the JV in the proper format for the ledger engine...

The date on the JV* line in your JV transaction must be formed from the date used for the Journal. It should not be the date/time stamp that goes on the *!*! line!

Here is one scheme for setting it and getting it into your JV string. It takes the date from cbJVDate, which is formatted like 04/26/2012, splits the string using the slashes, then concatenates the numbers together the way they should be for the JV* line:

Dim JournalDate As String = cbJVDate.SelectedItem
Dim ParseDate As String() = Regex.Split(JournalDate, "/")
JVString += "JV*" + EnterpriseId + "*" + ParseDate(2) + ParseDate(0) + ParseDate(1) + vbCrLf

Enterprise Ids have been Assigned:

Go to and find your 4-digit Enterprise Id. The Ledger Engine is eagerly awaiting your good-looking JVs!

Due Dates have been Relaxed for Project #1, Dlv #4:

Good Looking Trial Balance at the Ledger Engine is now due by the last class, May 1st. Dlv #4, the complete app to be scored according to the rubric, needs to be demo'd by the end of The Exam Period, 8:00 - 11:00am Thursday May 10th. Extra office hours will be posted for Exam Week. Take the extra time to show me extra good stuff!

Other Current Stuff

Project #2: Some teams are derelict, haven't turned in the printed User Interface/Reports for their main Use Case, related to the class' database. The last deliverable, on or before the exam day, is a polished requirements package and application to support the main Use Case. The teams' BAs should be able to use and demo the app.

Points are posted for everything that's been turned in and several 'missing' items were found. If you're missing points please print out what's missing and turn it in asap.

Exit Exam: Class on the 17th and the Exam Time will be used for the 'Exit Exam'. The exam is standardized and administered by, Institute for Certification of Computing Professionals. A score of 50% or better + a couple hundred dollars gets you their ISA Certificate, Information Systems Analyst, without prior work experience. After a few years in the field you can go after their CCP, Certified Computing Professional, certification. The ISA doesn't substitute for other technical certifications like RedHat, Cisco, or Microsoft for a Network Management major. But, it is a respected certificate and a good place to start. A brief outline of the exam is available -- it draws from both the BFO and IS Core courses.

Project #2

Here is a Blank Use Case Form. Hand-drawn sketches and lists are entirely OK for feedback on March 6th, should be done with Rose or Visio and accompanied by good-looking Detailed Use Cases by the 8th.

By the 27th, have good-looking user interfaces and/or reports mocked up or ready for use -- make sure to identify the database entities referenced, or have the prototype hooked up to the database...

Here is a Database ERD for the database left behind by other INFO465 classes. Similar will be up soon for Developers to hit...

Project #1, Dlv #3 & #4 Due Dates:

Project #2 is Underway

Teams were assigned on Tuesday the 28th, each with a Developer and Business Analysts. The first deliverable, due March 8th, for each team is be 1) a good-looking Use Case Diagram showing the team's Actor and associated Actors, and 2) Detailed Use Cases. Use the class meetings on the 1st and 6th to interview The Customer (instructor) to develop the detailed use cases. Developers should be working to connect to the database, roughly prototyping, and getting ready to put the stuff of the Detailed Use Cases into application components.

Project #1 Leftovers

Project #1, Dlv #2 - Documentation package was due at the beginning of class Feb 23rd, extension until the 1st was granted, 5 point bonus for the several that were presented on-time.

Points are posted from last semester, this semester's will be assigned similarly.

Class Meetings & Topics:

(1/17) 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 delivering the best results on time.

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; most Microsofters have VS.NET 2008 or 2010, but if you need to get it, MSDNAA will not be up until after add/drop. Please note: This is a time of 'platform issues' where 64-bit vs. 32-bit is a big deal! Beware if you've got the machine you bought in your Freshman year.

No wandering in and out of lecture policy: Take care of any personal issues before class starts. Evening sections will take a ten minute break at about 8:00. If you must leave class before the break, please wait until the break to return to your seat.

Project #1, Deliverable #1 Part #1 demo'd and assigned

(1/24 & 26) Dlv #1 Part #1, due TBA: Be able to authenticate two classes of Users, Owner/Manager & Salesperson/Technicial with a table like the BE/BusinessEntity table used in class, and deliver an appropriate menu to them, at least displaying their authority in the system.

Dlv #1 Part 2, due a week after: Have a suitable interface for CRUD on the BusinessEntity & GoodsAndServices tables: able to create new records, lookup existing ones & update them.

Make sure your BE table maintenance app supports CUA cursor movement and provides ComboBox or other 'lookup' so the user never has to guess about codes, ledger accounts, or foreign keys. Provide all fields appropriate for polite correspondence via snail mail (Street Address, Extra Line, City, State, and Zip) and is can take-on customer data from this page: Customer Data.

Make your database and code comply with this Rubric For Scoring to get full points for Dlv #1, Part#2.

Dlv #1, Part #1: Authenticating a User w/ reference to a Database: Intro to, Visual Basic, Windoze Forms, SQLServerCE, Plain Classes, Database Connection String, &c, &c...

(1/26) Open lab in class, to work on database and app.

(1/31) Demo an ugly, web-based App doing startup and a couple days' operations, then hitting the Ledger Engine. Checked in Dlv #1, Part #1.

(2/2) Run thru the accounting for a startup and a couple days' ops slow-motion on the board, populating the five tables, made three Journals and a Trial Balance net zero.

Project #1, Deliverable #2 demo'd and assigned

(2/2 & 7) Preview Deliverable #2, critique a good-looking doc on the board.

Project #1, Dlv #1, Part #2: Objects and code for Table Maintenance, SQLServerCE, and Table Maintenance, Access Database. 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...

(1/31 & 2/2) Business process modeling using the Sample Database Relationships among Entities, GoodsAndServices, Orders, Details, assigning ledger accounts to Details; Journalizing activity. On the board and with a MySQL database.

Pop quiz, Demo'd 'fulfillment cycle' using, asked class to sketch UML Sequence or other diagram showing interfaces with customer, order picker, and the ACH.

Project #1 Resources:

Project Deliverables 2 thru 4:

Due dates for these will be posted at the top of the page.