INFO465 - Senior Projects in IS - Spring 2010
Topics & Dates:
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 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...
(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:
Project #1Project #1's Deliverables 2, 3, & 4:
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.
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.