| Instructor: |
| Zulfiquar A. Dogar
Office: 2nd Floor, E. Albert Dumas Hall Telephone: 2349 E-mail: zdogar@lorman.alcorn.edu |
| Office Hours: | 09:00 a.m. – 02:00 p.m. Tuesday & Thursday | ||
| Other times by appointment | |||
| Time & Day of class: |
| 03:30 p.m. – 04:45 p.m. Tuesday & Thursday |
| Class-room: |
| Computer Lab 2, 2nd Floor, E. Albert Dumas Hall |
| Course website: |
| http://docushare.alcorn.edu/dscgi/ds.py/View/Collection-807 |
| Prerequisites: |
| BA-233 Business Computer Applications II or BA-226 Business Computer Applications and Senior standing | ||
| or | ||
| Consent of Instructor |
| Required Textbooks: |
1.
|
Fundamentals of Information Systems, 2nd Edition Authors: Ralph Stair, George Reynolds ISBN: 0-619-06491-9 |
|
2.
|
Microsoft Access 2000 Comprehensive Concepts and Techniques Authors: Gary B. Shelly, Thomas J. Cashman, Philip J. Pratt ISBN: 0-7895-5610-3 |
| Course Description: |
| A three (3) credit hour course, BA-433 is the 3rd course in a nine (9) credit hour sequence of information technology courses required of all Business Administration and Administrative Office Management majors. This course is described in the Alcorn State University 2002-04 catalog as follows: |
| ‘The purpose of this course is to provide the student with the appropriate level of knowledge, skills, and abilities required to effectively apply business computer information systems to the process of solving complex, multidimensional business management problems.’ |
|||
| Course Objectives: |
1.
|
Understand the role of Information Systems in organizations. | |
2.
|
Be able to participate as a user in analysis, design and development of a management information system. | |
3.
|
Plan, design, develop, and maintain simple database management systems. |
| Evaluation & Testing; |
POINTS
|
|||
| Nine (9) chapter exams & activities @ 40 points each | 360
|
||
| Nine (9) computer lab assignments @ 20 points each | 180
|
||
| Term project | 180
|
||
| TOTAL | 720
|
||
| Grading Scale: |
| TOTAL POINTS | GRADE
|
||
| 648 to 720 (90% & above) | A
|
||
| 576 to 647 (80% up to 90%) | B
|
||
| 504 to 575 (70% up to 80%) | C
|
||
| 432 to 503 (60% up to 70%) | D
|
||
| 431 and below (below 60%) | F
|
||
| Class Attendance: |
| Students must attend at least 75% of the class meetings of this course during the semester in order to qualify their course work for evaluation. |
| Learning Objectives & Related Activities: |
| DATE | LEARNING OBJECTIVES &/OR CLASS ACTIVITY | READING ASSIGNMENT | LAB/HOMEWORK ASSIGNMENT |
| 8/19 | · Welcome; Review of course syllabus & policies. | ||
| 8/21 | · Understand lab/network operating procedures, appropriate use policy. | Chapter 1 | Login to the network; setup printer; explore network drives; register for free email; familiarize with the BA-433 website. |
| 8/26 | ·
Distinguish data from information and describe the characteristics used to evaluate the value and quality of information.
· Define an information system and describe its four main elements. · Identify the basic types of business information systems and discuss who uses them, how they are used, and what kinds of benefits they deliver. · Identify the major steps of the systems development process and state the goal of each. · Describe three stages in the business use of information systems. · Define the types of roles, functions, and careers available in information systems. |
Chapter 1, 2 | Register in the online course discussion forum @http://bschool.alcorn.edu/forum/default.asp with a relevant user name and a valid email address that you check regularly. Post your response to the first topic/thread in the BA-433 online discussion forum. |
| 8/28 | · Chapter 1 exam (first 25 minutes of class). | ||
| ·
Identify and discuss the role of the essential hardware components of a computer system.
· List and describe popular classes of computer systems and discuss the role of each. · Outline the role of the operating system and discuss how operating systems have evolved over time. · Identify and describe the functions of the two basic kinds of software. · Discuss how application software supports personal, workgroup, and enterprise business objectives. · Outline the evolution of programming languages and highlight the differences between programming languages used by end users and IS professionals. |
Chapter 2 | Post your response to the second topic/thread in the BA-433 online discussion forum. | |
| 9/2 | · Review of coverage to-date. | Chapters 1, 2, 3 | Review/Catch-up. |
| 9/4 | · Chapter 2 exam (first 25 minutes of class). | ||
| 9/4 Cont. on next page… 9/4 Cont... |
·
Define basic data management concepts and terms, highlighting the advantages and disadvantages of the database approach to data management.
· Name three database models and outline their basic features, advantages, and disadvantages. · Identify the common functions performed by all database management systems and identify three popular end-user database management systems. · Identify and briefly discuss recent database developments. |
Chapter 3 | Post your response to the third topic/thread in the BA-433 online discussion forum. |
| 9/9 to | · Chapter 3 exam (first 25 minutes of class). | ||
| 9/16 | ·
Create a database using Microsoft Access.
· Learn to use Microsoft Access Help. · Design a database to eliminate redundancy. |
Project 1; Apply Your Knowledge: 1; In the Lab: 1, 2, 3; Cases & Places: 1, 2, 5 | |
| ·
Define telecommunications and describe the elements of a telecommunication system.
· Briefly describe how the internet works, alternatives for connecting to it, and the role of internet service providers. · Define the terms intranet and extranet and discuss how organizations use them. · Identify several new issues and challenges associated with the use of networks by organizations. |
Chapter 4 | ||
| 9/18 to | · Chapter 4 exam (first 25 minutes of class). | ||
| 9/23 | · Querying a database using the ‘Select’ query. | Project 2; | |
| ·
Use comparison operators and compound criteria involving AND & OR statements in queries.
· Join tables in a query. · Design and use calculated fields, statistics, & groups in a query. |
Apply Your Knowledge: 1; In the Lab: 1, 2, 3; Cases & Places: 1, 2 | ||
| ·
Understand the advantages of e-commerce systems and identify major types of e-commerce systems.
· Outline key hardware and software components of e-commerce. · Outline key components of an effective e-commerce strategy. · Understand the two types of transaction processing systems and activities associated with them. · Define the term Enterprise Resource Planning System (ERP), and discuss the advantages and disadvantages of ERP systems. |
Chapter 5 | ||
| 9/25 to | · Chapter 5 exam (first 25 minutes of class). | ||
| 9/30 | ·
Maintain a database using the design and update features of Access.
· Use data validation and formatting techniques. · Understand the concept of ‘referential integrity’. |
Project 3; Apply Your Knowledge: 1; In the Lab: 1, 2, 3; Cases & Places: 1, 2, 5 | |
| ·
Identify stages in decision making and problem-solving.
· Describe a Management Information System (MIS) and its key inputs & outputs. · Describe a Decision Support System (DSS) and Executive Information System (EIS) and their major objectives & components. · Relate various levels of management and the nature of information needs. |
Chapter 6 | ||
| 10/2 to | · Chapter 6 exam (first 25 minutes of class). | ||
| 10/7 | ·
Create a report using a wizard & modify it in the design view.
· Recognize the sections in a report & create groups & subtotals. · Create a form using a wizard & modify it in the design view. · Incorporate calculated fields and combo boxes in a form. · Format reports and forms. |
Project 4; Apply Your Knowledge: 1; In the Lab: 1, 2, 3; Cases & Places: 1, 2, 3, 4 | |
| ·
Define artificial intelligence (AI).
· Describe various categories of AI applications. · List characteristics of expert systems. · Define virtual reality and describe some of its applications. |
Chapter 7 | ||
| 10/9 to | · Chapter 7 exam (first 25 minutes of class). | ||
| 10/14 | ·
Create and use date, memo, OLE, & hyperlink fields in a table.
· Create and use a form with a sub-form. · Use date & memo fields in a query. · Compact a database. |
Project 5; Apply Your Knowledge: 1; In the Lab: 1, 2, 3; Cases & Places: 1, 2, 3, 4, 5 | |
| 10/16 | |||
| 10/21 | |||
| 10/23 | |||
| 10/28 | |||
| 10/30 | |||
| 11/4 | |||
| 11/6 | |||
| 11/11 | |||
| 11/13 | |||
| 11/18 | |||
| 11/20 | |||
| 11/25 | |||
| 11/27 | |||
| 12/2 | |||
| 12/4 | |||
| 12/9 | |||
| 12/11 | |||