|
|
|
|
|
|
|
|
|
|
ACTG 378: ACCOUNTING INFORMATION MANAGEMENT -- Fall 2008
Monday/Wednesday 4-5:50pm,
Bexell Hall Room 323
CONTENTS
|
INSTRUCTOR
Byron Marshall, Ph.D. |
OFFICE HOURS
I
would enjoy talking to you! |
COURSE
DESCRIPTION -- ACTG378 is a four unit course.
This course is both a required accounting course and the first course in the MIS junior sequence.
The Catalog Description: Introduce students to the field of information management. Topics include information systems technology, the strategic role of IT, the business applications of networks, databases and Internet technologies, the system life cycle model, systems analysis and design methodologies, and the development and implementation of information systems. PREREQ: BA 213 and (BA 271 or BA 302) and (BA 275 or BA 276) and Junior standing.
Informally: The rapid evolution and diffusion of information
technology (IT) is transforming businesses and managed organizations. In most
organizations today, IT systems are crucial for daily operations. These systems
are facing new threats and new regulations. To be successful in the
"information age," organizations need people who are knowledgeable
about the operation and implementation of IT-based business applications. The
ACTG378 course has been designed to introduce students to the information
systems field. The lectures, readings, and assignments will introduce a number
of key concepts and timely issues related to the use of Information Systems in
organizations. Specific topics to be addressed include (among other topics):
information systems technology, the business applications of networks and
databases, the development of information systems, the implementation of
systems, IT Governance, and appropriate internal control environments for
IT-based business applications. In addition to the lecture and reading
material, students will apply the techniques we cover in an integrated group
project.
COURSE
MATERIALS
Accounting 378 - Accounting Infomation Systems Custom ISBN#:
0-558-03910-3 Some course material will be available in Blackboard. Activity Diagram examples were done in MS Vision 2007. This program is installed on the COB lab computers and is also available to COB students for free through MSDNAA. Links: MSDNAA instructions Burning an ISO image |
|
Tentative Course Schedule -- Fall 2008
|
Please
read Reading assignments in preparation for class. |
|||
|
Week |
Monday |
Wednesday |
Due Thursday Night |
|
1 |
Welcome
- Introduction, Assignments (Slides) |
Read: Text Chapter - "MIS
and You" -
From Kroenke , Using MIS 1st Ed. |
Due: List Group Members |
|
2 |
Transaction
Cycles, Organization-Specific Process Narratives, and Activity Diagrams |
Modeling
Systems (Slides) |
|
|
3 |
Read:
VII
Pillars of Productivity (Slides) |
Read: Text Chapter: "Control
and Accounting Information Systems" - From Romney & Steinbart, AIS
11th Ed (Slides) |
|
|
4 |
COBIT:
Controlling and Auditing IS (Slides) |
Review
& Project Work (Slides) |
|
|
5 |
Read: Text Chapter - Relational Databases (Slides) |
||
|
6 |
Read: Text Chapter - Relational
Databases |
More
hands-on Database Activities |
|
|
7 |
Key
Issues and features in today’s large-scale database-driven systems |
SQL
walkthrough – reconciling an AP system Meet
in computerized classroom 324 |
Due: PRJ5: Design Reports |
|
8 |
Computer
Hardware and Software: Text Chapter
"Hardware and Software" –
From Kroenke , Using MIS 1st Ed. |
Due:
Individual Database Assignment |
|
|
9 |
How
Does the Internet Work? |
Due: Complete Group Project |
|
|
10 |
XML,
XBRL, Web Services, and XBRL |
||
|
Dec 8-12, Finals Week |
Friday, December 12th,
7:30am |
||
STUDENT
EVALUATION
Student evaluation will consist of two related areas--the understanding of
basic concepts and the ability to apply tools and techniques. Students will
demonstrate their understanding of concepts by participating in classroom
discussions and completing written assignments, quizzes, and examinations.
Students will demonstrate their ability to apply tools through completing
assignments and projects.
|
Grade
Component |
Weighting |
|
30 % |
|
|
10 % |
|
|
30 % |
|
|
30 % |
|
Final grade percentages |
||||||||||||||||||||||||||||||||||||||
|
|
|
|
|||||||||||||||||||||||||||||||||||
Individual Assignments, and Quizzes:
· Assignments: Two assignments are
planned
- Individual UML Activity Diagram: See Group Project Description
- SQL exercises. These exercises will be made available
in Blackboard.
· Quizzes may be given during the
term. Quizzes will be given during class and are usually discussed immediately
after completion. Individuals not in class will not be allowed to make up the
quiz once it is discussed in class. Quizzes will be based upon the assigned
readings or material previously presented in class.
COURSE
POLICIES
College of
Business Code of Conduct
University wide Student Conduct Polices
Academic Honesty Policy:
Individuals
are encouraged to discuss the projects and assignments outside of class and
share ideas. However, unless specified as a team assignment, each person
must individually complete and submit his/her own work. Students are
expected to uphold the OSU standard of conduct for students relating to
academic dishonesty. Academic dishonesty is defined as an intentional act of
deception in which a student seeks to claim credit for the work or effort of
another person or uses unauthorized materials or fabricated information in any
academic work Students assume full responsibility for the content and integrity
of the academic work they submit. The guiding principle of academic integrity
is that a student's submitted work, examinations, reports, and projects must be
that student's own work for individual assignments, and the group's own work
for group assignments/projects. Students are guilty of academic dishonesty if
they:
- Use or obtain unauthorized materials or assistance in
any academic work; i.e., cheating. </li
- Falsify or invent any information regarded as cheating
by the instructor; i.e., fabrication. </li
- Give unauthorized assistance to other students; i.e.,
assisting in dishonesty. </li
- Represent the work of others as their own; i.e.,
plagiarism. </li
- Modify, without instructor approval, an examination,
paper, record or report for the purpose of obtaining additional credit; i.e.,
tampering.
The
penalty for academic dishonesty is severe. Any student guilty of academic
dishonesty may be subject to receive a failing grade for the exam, assignment,
quiz, or class participation exercise as deemed appropriate by the instructor.
In addition, the penalty could also imply that the student receive a failing
grade for the course and be reported to the University officials at the College
of Business, and the officials at the Office of Student Affairs.
Behavior in Class:
- Behavior in class should be professional at all times.
The atmosphere within the classroom should be the same as you might expect
in a casual business meeting. People must treat each other with
dignity and respect in order for scholarship to thrive. Behaviors
that are disruptive to learning will not be tolerated and may be referred
to the Office of the Dean of Students for disciplinary action.
Accommodations:
- Students who have any emergency medical information the
instructor should know of, who need special arrangements in the event of
evacuation, or students with documented disabilities who may need
accommodations should make an appointment with the instructor as early as
possible, no later than the first week of the term. If additional
assistance is required the student should contact the Office of Disability
Services.
This statement is gladly included in cooperation with University policy: "Accommodations are collaborative efforts between students, faculty and Services for Students with Disabilities (SSD). Students with accommodations approved through SSD are responsible for contacting the faculty member in charge of the course prior to or during the first week of the term to discuss accommodations. Students who believe they are eligible for accommodations but who have not yet obtained approval through SSD should contact SSD immediately at 737-4098."
Discrimination or Harassment:
- Discrimination or harassment will not be tolerated in
the classroom. Most cases of discrimination or harassment violate Federal
and State laws and University Policies and Regulations. Intentional
discrimination or harassment will be referred to the Affirmative Action
Office and dealt with in accordance with the appropriate rules and
regulations.
- Unintentional discrimination or harassment is just as
damaging to the offended party, but it usually results from people not
understanding the impact of their remarks or actions on others, or an
insensitivity to the feelings of others. We must all strive to work
together to create a positive learning environment. This means that each
individual should be sensitive to the feelings of others and tolerant of
the remarks and actions of others. If you find the remarks and actions of
another individual offensive, please bring it to their attention. If you
believe those remarks and actions constitute intentional discrimination or
harassment, please bring it to your instructor's attention.
Arbitration:
- There will be a one-week arbitration period after
graded items (projects, assignments, etc.) are returned.
Within that one-week period, you are encouraged to discuss any assumptions
and/or misinterpretations that you made about the activity that may have
influenced your grade.
LEARNING
OUTCOMES
My
goal for each of you this term is that you will explore a large number of
important topics. It is a long list but I plan to expose you to all of this in
10 short weeks.
A
successful student will be able to:
- Explain how business processes, transaction cycles, and
IT systems (both AIS and MIS) relate to and each other explain various
roles IS and non-IS users play in IS acquisition, development, management,
and use.
- Document individual business processes from an
information system perspective.
- Explain how internal controls are implemented in an
information system.
- Work productively in a group environment.
- Recognize limiting and enabling factors of technology,
and describe the forces and processes governing modern day business
computing.
- Understand the
relationships, both historical and current, between the use of
information system technology and business productivity.
- Provide an overview of
information successes and failures and some of their causes.
- Match standard business
data processing needs with standard technologies.
- Demonstrate a fundamental understanding of how the
Internet works. Note: this is not the same as knowing how to navigate the
Internet.
- Recognize the various
Internet and WWW standard setting organizations, their responsibilities
and their governance.
- Describe the function
of basic HTTP commands (GET, HEAD, and POST) and generally describe how
requests and responses move around the internet.
- Explain what a protocol
does and how protocols are a key element in the growth of the Internet.
- Explain the role of the
W3C in guiding the development of the Internet.
- Contrast the basic
purpose and syntax of XML vs. HTML.
- Recognize the operational and strategic business
opportunities of XML-based data communications such as web services.
- Formulate a simple XML
model of a standard set of business information; e.g., a simple earnings
statement, a sales order, or a customer complaint.
- Explain the role of
XBRL in financial business reporting.
- Conceptually formulate
an XML-based web service for sharing information between a B2B supplier
and consumer.
- List and explain the general function of the key
components of an XBRL document. Generally identify the function of
standard XBRL elements in an example document. Explain the value of using
XBRL.
- Explain general IT Governance principles, including
some key details.
- Design and read the relational structure of
prototypical complexes of business data and information and distinguish
good from bad data models.
- Classify an arbitrary
selection of business processing data into entities, attributes and
relationships.
- Specify primary and
foreign key structures.
- Differentiate master,
transaction, and junction tables, explaining their characteristics and
role in a relational database system.
- Translate back and
forth between standard business information and its relational
representation.
- Name the major
characteristics of industry-strength database systems.
- Describe
the basics of several system modeling techniques.
- List several ways
process modeling can be useful in business.
- List the basic diagrams
of and concepts behind the UML (Unified Modeling Language).
- Create a UML activity
diagram or flow chart for a business process depicting events, actors,
forms, decision points, and data stores.
- Draw simple data models
such as Entity Relationship Diagrams (ERD) or data-oriented UML Class
Diagrams.
- Recognize and describe
the advantages and limitations of psuedo code or structured English.
- List the basic
components of Data Flow Diagrams (DFD) and describe basic DFD balancing
rules.
- Recognize and describe
the advantages and limitations of decision tables.
- Describe the components
of Use-case diagrams and explain their role in the system development
process.
- Demonstrate a basic understanding of relational
database access concepts:
- Explain what makes a
password relatively strong or relatively weak.
- Discuss how an RDBMS
(Relational Database Management System) can support business processes
and controls based on Referential Integrity (foreign keys) and
Transaction Integrity (Roll Back).
- Describe how an RDBMS
supports data documentation. (Diagrams and a database about the
database.)
- Generally interpret an
SQL query. What are the basic key words? What do those key words do?
(SELECT, FROM, WHERE)
- Create simple SQL
statements which create lists of items from the database.
- Adapt more complex
statements to add columns or join to additional tables.
- Understand how SQL
supports list filtering and joining (WHERE), subtotals (GROUP BY),
sorting (ORDER BY), Uniqueness (DISTINCT) and a few other functions (MIN,
MAX, AVG, COUNT, SUM).
- Describe how different
queries can be used to support realistic business tasks.
- Recognize key computer hardware and software
terminology:
- Identify CPU, primary
storage, secondary storage, and IO device descriptors in a PC purchase
specification.
- List several factors
affecting computer performance.
- Contrast compiled and
scripted languages, listing examples and comparing functionality.
- List and briefly
explain several measures of software performance.
- Relate binary numbers
to data encoding, counting forward and backwrads in binary as it to
identify ascii characters.
- Explain key system characteristics:
- List and explain the
components of the DIKW framework.
- Demonstrate how the terms
modularity and coupling can be used in evaluating business processes.
- Contrast black/white
box and open/closed as they apply to systems.
- Explain how the terms
extensibility, entropy, and scope apply to the evaluation of systems and
system risks.
- Understand internal control as it relates to IT in
organizations:
- List and describe the
components of COSO.
- List and describe
internal control objectives and components within a coherent framework
using examples from the COBIT framework.
- Differentiate between
execution, information systems, asset protection, and performance
objectives.
- Identify and describe
execution and information systems risks associated with processes in the
acquisition and revenue cycles.
- Explain how various
kinds of internal controls can be used to reduce risk.
- Contrast various types
of controls: application controls, general IT controls, and internal
controls implemented in IT.
- List, define, contrast, and give examples of preventive, detective, corrective and compensating controls.
- Do a few rudimentary tasks in a personal database application (MS Access) and create flow charts using a drawing application (MS Visio).
These
objectives were selected after reviewing existing courses in our program,
talking to industry practitioners, and reviewing the model curriculum proposed
by ISACA (Information Systems Audit and Control Association). The text,
examinations, assignments, and project formulation have all been chosen to
support these objectives.
This
course will address the following College of Business
Learning Outcomes
- College of Business Specific Learning Outcomes
- Each student must
understand and be able to use team building, collaborative behaviors and
project management in the accomplishment of group tasks.
- Each student shall
demonstrate information technology skills as they apply to today’s
business environment.
- Each student shall be
able to converse and to write at an acceptable level for business
communications in English.
- Accounting Option Specific Learning Outcomes
- Each student shall be
able to apply accounting concepts, principles, standards, and processes.
- Each student shall
demonstrate information technology skills as they apply to today’s
business environment to solve business problems and to communicate those
solutions.
- Each student must
demonstrate analytical skills through finding, organizing, assessing, and
analyzing data appropriate to a given situation.
- Each student shall be able
to impart the knowledge and skills listed above to provide insightful
advisory judgments and recommendations regarding the accounting for and
the business implications of events, conditions, circumstances, and
transactions that give rise to business opportunities or problems.
- Each student must
demonstrate strong organizational skills and a capacity for responsive
and timely work.
This page is maintained by Byron Marshall Send
E-mail to byron.marshall@bus.oregonstate.edu.