AMIS 532 - Fundamentals of Business Information Systems
Fall 2004
MW 3:30 - 5:18 pm Schoenbaum 205

1. INSTRUCTOR:
            Dr. John Butler
        OFFICE:
            448 Fisher Hall, Fisher College of Business, The Ohio State University,
            Columbus, Ohio 43210
        OFFICE HOURS:
            Wednesday 2:30 - 3:30 and by appointment.
        OFFICE PHONE:
            (614) 688-8679
        E-MAIL:
      butlerj@cob.ohio-state.edu
         the subject of all messages must be AMIS 532

2. COURSE TEXTS:

  1. Programming in Visual Basic.NET: Update Edition for VB.NET 2003 by Julia Case Bradley and Anita C. Millspaugh, 5th edition, McGraw Hill, ISBN 0072256710
  2. A book on using Microsoft Access of your choice
  3. This syllabus serves as an interactive entry point into all materials covered in this class. It WILL be updated frequently during the quarter, so check often for new links, notes, messages, and other related material.
3. COURSE DESCRIPTION & OBJECTIVES:
 
 
bb
The course introduces the concepts and programming techniques for building successful interactive business systems.  Graphical user interfaces (GUI) and event-driven programming, which provide the basis for the ease-of-use feature of successful business systems, are studied using friendly, powerful, and popular systems development tools.

4. STUDENT RESPONSIBILITIES:
 
bb
You are expected to have read carefully the assigned portion of the book prior to coming to class (and I encourage you to discuss it with friends); most of the class time will be devoted to the discussion of applications and extensions of the material in the book. 
bb
You may work on assignments together (for example, discuss how to work a problem or rough out a solution), but every group must turn in work that is written up individually. Solutions to these problems may not be “copied” and “pasted” by multiple groups.  The purpose of the assignments is not to find a solution on the Internet or from students who took this class previously.  If you do find some useful information on the web or from another source it should be referenced!  Evidence of cheating in any form will be met with serious punishment including formal channels at the University level.

5. GRADING POLICY:
 
bb The class consists of a total of 100 points:
  • Exams 40 points
  • Exercises 40 points
  • Group Project 20 points
bb
Exercises
Exercises are individual assignments.  As such, they should be done individually.  It is important to note that plagiarism is an academic misconduct subject to severe penalty.  Those who commit plagiarism including accomplice will risk receiving a failure grade for the course and also sanction from the university. Click here for how to hand in an exercise.
bb
Group Project
The project is an important part of the course and will constitute 20% of your grade.  It will be done in groups of 3 or 4. The objective is to develop a business application using Visual Basic .Net.  You will have considerable flexibility in selecting an application.  You will present your work to the class at the end of the course.  More detailed description about the project will be given as the end of the quarter approaches.
bb No makeup exams will be given.   No late assignments will be accepted. 
bb
If an assignment is added or deleted, those points will simply be added or subtracted from the total.

6. COMPUTER USUAGE:

This class requires the Microsoft .NET Framework and Visual Basic.NET.  Note, .NET is a true object oriented language and is very different than previous versions of Visual Basic.  The lab in Mason Hall will be equipped with the appropriate software.

The .Net framework  is a set of software technologies for connecting information, people, systems, and devices, independent of location and computing platform.  The goal is to access information anywhere and anytime using the common infrastructure of the Internet.  An important element of the .Net framework is software components (objects) that run on diverse computing platforms.  The .Net Framework supersedes  the ActiveX technology.  The following site contains detailed information about the .Net framework: http://www.microsoft.com/net/

7. TENTATIVE SCHEDULE:
 
 
Week
Date
Topic Readings Class Notes Assignment (points)
1
Sept 22
Course overview
2
Sept 27
VB Programming Environment Chapter 1 chap1.ppt
Sept 29
More Controls Chapter 2 chap2.ppt
3
Oct 4
Programming with VB.Net Chapter 3 chap3.ppt
Oct 6
More Programming with VB.Net Chapter 4 & 5 chap4-5.ppt Exercise 1 (2)
4
Oct 11
Object Oriented Concepts Chapter 6 chap6.ppt Exercise 2 (4)
Oct 13
Multiple forms, static variables, timers and menus Chapter 7 chap7.ppt
5
Oct 18
Message boxes, exception handing Chapter 7 Exercise 3 (5)
Oct 20
Lists, combo boxes, arrays and protection Chapter 8 chap8.ppt
6
Oct 25
Exam 1 Exercise 4 (5)
Oct 27
Rich text boxes, common dialog controls, data files and databases Chapter 11 chap11.ppt
7
Nov 1
SQL and Microsoft Access Nov1.ppt Exercise 5 (5)
Nov 3
Access print this file
bring chap11.ppt
bring textbook
8
Nov 8
Accessing Database Files Chapter 10 chap10.ppt Exercise 6 (6)
Nov 10
Accessing Database Files Chapter 10 chap10-2.ppt
9
Nov 15
Input validation, strings week9-1.ppt
Nov 17
Active X, user controls week9-2.ppt Exercise 7 (6)
10
Nov 22
Exam 2 Exercise 8 (7)
see 11/17 message 
Nov 24
Project Work Day
11
Nov 29
Project Presentations
Dec 1
Project Presentations

8. MESSAGES:

www.niehs.nih.gov/kids/mindread/psychicSparkle.swf

11/22 Exercise #8 is now due by 3:00 pm on 11/24.  Start immediately.

11/17 1) Here's an Excel sheet with all of the car brands and models that are in the Ex#8 database.  2) We're doing SEIs today for the start of class.

11/14 Since you cannot experiment wtih web forms in the lab, the second midterm will not cover chapter 9.

11/2 Bring the Chap11.ppt slides on Monday (11/3) as well so we can discuss database "theory".

10/14 Some of you are paying attention.  To be honest, I posted the example solution for Exercise 3 from last year and didn't think much about it.  Techically it is wrong.  The lights were staying around too long.  I've reposted a new example, NEWtrafficlight.exe here and on the assignment page.  Let me be clear: if you don't fix this it would be a minor (10%) deduction.  I'll explain the issue in a follow up e-mail.  Sorry for the mixup.

10/13 I changed the due dates of the assignments as we discussed in class today.  Think of the links as a "heads-up" that your assignment is about to be due.  Imporant: I will be attending a conference from Oct 23 - Oct 26th.   I will have someone else give your midterm on the 25th but it is important to realize that I will have limited access to e-mail.  You would be well served to start ASAP so that you can ask questions when I am in town.

10/04 Hotmail will block .exe files whether your e-mail client will send them or not.  Note that I have changed the procedure for handing in files.  I am going to delete all of the assignments that have been sent so far.  If you already sent your file, please re-send as it has been deleted.  See how to hand in an exercise for the changes (again).

10/01 Just to be clear the only use of the butler532@hotmail.com address is for handing in the executable file (and other files that may be part of an assignment).  All other correspondance should be sent to me directly.

9/29 In class today I told you that I would send you a "secret code" to use in naming your files.  I thought about it and decided that it wasn't neccessary to do that if I changed the naming convention for the files you submit.  See how to hand in an exercise for the changes.

9. CONTACT INFO:
 
e-mail entire class, including Butler e-mail entire class, excluding Butler