STATE UNIVERSITY OF NEW YORK

COLLEGE AT OLD WESTBURY

 

BU 4230                                                                                              C. Schweikert

Information Systems for Managers                                                 e-mail: [email protected]
                                                                                                                        ([email protected])

                                                                                                            D321 M / T / W / Th 2:50pm - 3:50pm

Spring 2007 (M / W 4:40pm – 6:20pm)                                                      

Course Website: www.programmingeasyways.com/bu4230

References: Effy Oz, (2004) Management Information Systems, Fourth Edition
Course Technology, Thomson Learning.

Text Website: http://www.course.com/downloads/mis/oz/

Internet References:
CIO Magazine online: http://www.cio.com/

InformationWeek: http://www.informationweek.com/

A.1. Course Description:

Introduction to information systems as strategic assets of the enterprise utilized to achieve strategic advantage. Investigation is also made of the use of information systems at the tactical and support business levels. Management of information through database, spreadsheet, and software and web development tools.

A.2. Intended Audience:  MIS, Business, Management, majors

A.3. Course Objectives:

Students will learn to utilize data management software (Microsoft Access, Excel) and development tools such as Visual Basic .Net and FrontPage, gain an understanding of how companies and managers use information systems, and the importance of managers knowledge of technology.

B. Course Prerequisites:

C. Mode of Instruction:

The class consists of lecture and computer lab work where students will work with database, spreadsheet, and web software to design projects for each

D. Student Responsibilities:

1. Class work and projects.
2. Assignments and exams.

E. Grading:

 

Information Technology Presentation Choices (if you make more than two presentations, it will be extra credit):

1. Course project (ex. Access, Excel , VBA, VB .Net)
2. Managers and Information Technology

Choose a company (e.g. financial, drug company, retail, software), and investigate the role of the manager and how managers use information and information systems:

1.    What is the role and responsibilities of a manager?  (experience and s kills, job tasks of managers)

2.    How does information affect their decision-making?

3.    What should a manager know about technology and is their risk involved?

4.    How do managers use information systems (what kind of software/applications)?

5.    How does information affect business strategy?

3. Choose a topic that is crucial for IT professionals to be aware of and explain to the class (ex. E-Commerce, Business Continuity and Disaster Recovery Planning, Knowledge Management (KM), Mobile Security, Open Source, Outsourcing, Wireless WANs and LANs)  

 

Main Topics:

 

Date:	Topic:	Projects:
Wed Jan 24	Foundation and principles of information systems Reasons Managers need to be aware of IT/Programming Issues	IJAMT Article
Mon Jan 29, Wed Jan 31	Introduction to Database Tables, Records, Data Validation Create a webpage for your course projects (sample) Choose topic for an Access database and begin creating tables	Access Notes
Mon Feb 5, Wed Feb 7	Data Filters, Queries, Table Relationships   Access Project – Short Description of Database Tables -              Create Tables (3 to 4 Tables) - Define Fields and Primary Keys              Create any Relationships              Enter Records Queries Forms Reports Switchboard(s)	SQL
Mon Feb 12, Wed Feb 14	Managing and Updating Database using Forms (Feb 14 - No class due to snow)	Company Database
Mon Feb 19, (no class) Wed Feb 21	Generating Database Reports   Designing and Creating Access Database Projects Post Access project to website (example)
Mon Feb 26, Wed Feb 28	Access Project Presentations   Excel- Creating Spreadsheet, Formulas, Functions	Excel Intro   Excel Notes Web Query
Mon Mar 5, Wed Mar 7	Web Queries    Web Query Assignment: 1) Choose 7-8 stocks for your portfolio 2) Create a Web Query to get stock information 3) Design a portfolio sheet as shown in example 4) Create all necessary formulas and functions 5) Create 2 charts and/or graphs to visualize your portfolio	Stock Assignment
Mon Mar 12, Wed Mar 14	What-If Analysis, Charting Access and Excel Review   Midterm Topics: (Sample Midterm) Access: Tables: Fields, Records, Primary Key, Validation Rule, Validation Text Table Relationships (1-1, 1-M, M-M) Queries: Criteria, Calculations, Parameter Query SQL Forms Reports Pages Excel: Formulas Built-in Functions Charts Web Query Stock Portfolio Expense Report	Project and Review
Mon Mar 19, Wed Mar 21	Review and Midterm
Mon Mar 26, Wed Mar 28	VBA and Excel Presentations on VBA with Excel	VBA Example Search, Add
April 1 – 8 Spring Recess	Spring Recess
Mon Apr 9, Wed Apr 11	Intro to Visual Basic .Net   Visual Basic .Net Notes Inventory Program	Payroll Program Item Search Compute Pic Search
Mon Apr 16, Wed Apr 18	Visual Basic .Net Project (Inventory or Payroll) - Include Search and Computation Role and Experience of Managers and Technology (Web or Power Point)	VB tutor website
Mon Apr 23, Wed Apr 25	Internet and Network Security, Privacy, and Legal Issues Intro to Security	Sample Final
Mon Apr 30, Wed May 2	Project Presentations and Review
Mon May 7, Wed May 9	Final
May 10 – 16 Final Week	Finals  week

 

 

Course Websites:
Name                        Website

Arias, David L.	http://www.geocities.com/darias58
Castillo, Matthew R.	http://www.geocities.com/mtthw_castillo/
Castro, Cristian H.	http://www.geocities.com/platinesta
Chung-Lamey, Brenetha	http://www.geocities.com/brenannc/
Collins, Marvin P.	http://www.geocities.com/MarvinCollins219/
Cruz, Victor H.	http://www.geocities.com/niqqo1/
Gan, Norman E.	http://www.geocities.com/norman_gan/
Garcia, Frank V.	http://www.geocities.com/franco_franco1/
Jiang, Kaituo
Katehis, George
King Jr., Peter M.	http://www.geocities.com/pking09/
Megna, Charles R.	http://www.geocities.com/crmedu/
Motherway, Terrance J.	http://www.geocities.com/terrjm/
Parham, Sakinah A.	http://www.keenahsplace.com/
Parris, William	http://www.billparris.com/
Rentas, Nicholas T.
Riordan, Kathryn M.	http://www.geocities.com/k4te718/
Tavarez, Ironelys	http://www.geocities.com/tavarezironelys
Ruan, Jian Xun	http://www.geocities.com/jianxunruan
Veras, Sheyra	http://www.geocities.com/doministar24/
Yearby, Olga C.	http://www.geocities.com/o_yearby/