ST. GREGORY’S UNIVERSITY
ACE Business Module 1
COURSE
SYLLABUS for August-October 2001
|
COURSE(S) |
ACE Business Module
1 | |
|
TIME/LOCATION |
Monday, 1730-2130 (5:30-9:30
pm), Room 318 | |
|
PREREQUISITE
|
Sophomore
standing | |
|
INSTRUCTORS |
Mayda Shorney, Ph.D.,
CPA |
Melinda
Yarbrough |
|
E-MAIL |
||
|
PHONE
(Home) |
405-214-6449
|
405-275-3314 |
|
OFFICE |
Room 442a, Ext. 5159
|
Room 442c, Ext.
5158 |
|
OFFICE
HOURS |
M 1630-1730, or by
appointment |
By
appointment |
COURSE DESCRIPTIONS FROM OFFICIAL
BULLETIN
BU 2113
Financial Accounting
An
introductory course covering the historical development of business and
accounting. The preparation of
financial statements is demonstrated as well as their use in cash management and
performance evaluation. Additional
concepts such as the time value of money, long-term debt, and equity financing
are studied. The course concludes
with a comprehensive evaluation of a firm’s profitability, financial position,
and cash flows. Prerequisite:
Sophomore standing and CS 1823.
BU 2123
Managerial Accounting
An
introductory course that emphasizes the use of accounting data within an
organization. It demonstrates how
managers use accounting information in planning operations, controlling
activities, and making decisions.
Problems and cases cover such current topics as activity-based costing
and quality costs and management in service, not-for-profit, and retail
organizations, as well as manufacturing firms. Prerequisite: BU 2113
This advanced course is designed to
extend the student’s computer skills to a level necessary for survival in the
business world. Competencies will
include creating and maintaining active links, posting Web applications,
developing spreadsheet and database templates, and designing and documenting
macros. Students are to create
professional quality reports and forms including charts, graphs, tables, input
forms, and query scenarios.
OBJECTIVES
·
Learn
who the users of accounting information are and why they find accounting
information useful.
·
Understand the data reported on each
financial statement and the way statements relate to each
other.
·
Define
the broad, generally accepted concepts and principles that apply to the
accounting process.
·
Demonstrate why financial ratios are
important and how trend analysis can be used most
effectively.
·
Describe what is included in the
cash, receivable, and inventory amounts reported on the balance
sheet.
·
Explain the affect of property,
plant, and equipment transactions on the financial
statements
·
Understand the effects of revenues,
expenses and cash flows on the financial statements.
·
Discuss
the major distinctions between managerial and financial
accounting.
·
Define
and use cost, cost objectives, and cost behaviors in case
situations.
·
Understand
C-V-P data and use in making decisions on limits or
output.
·
Define
budgeting, its uses, and supporting schedules for the master
budget.
·
Distinguish
between static and flexible budgets and use each in the discussion of variances
to each.
·
Use
current word processing and spreadsheet software to develop accounting reports
and analyses.
·
Use
current spreadsheet software to develop a simple decision support system
employing "what-if" analysis to analyze data with a graphical presentation of
the results.
These objectives can only be
achieved through joint effort. We will work to stimulate your interest and
learning in these areas, but you will be expected to display initiative and a
program of self-study as well. In
that sense, a complementary objective of the course is to provide you with an
environment that will encourage and reward your own intellectual effort, while
simultaneously maintaining rigorous standards that identify those who are
motivated to pursue excellence in their own educational preparation for a
business career.
ACADEMIC
HONESTY
Students
are advised that cheating and plagiarism are not tolerated at St. Gregory’s
University. Students are expected
to abide by the University's academic regulations and policy and are responsible
for awareness of the University's definition of these activities. The
consequences of violating the academic honesty standard may include a grade of
"0" on the assignment/exam, a grade of "F" in the course, and, possibly,
expulsion from the University.
REQUIRED TEXT AND SUPPLEMENTAL
MATERIALS TO BE PURCHASED BY STUDENT
Dixon,
Robert L. and Harold E. Arnett, The McGraw-Hill 36-Hour Accounting
Course, Third Edition, McGraw-Hill, 1993. ISBN
0-07-014094-0.
Willet, Edward, David Crowder, and
Rhonda Crowder, Microsoft Office 2000 Bible, IDG Books Worldwide,
1999. ISBN
0-7645-3261-8.
INTERNET
RESOURCES
ATTENDANCE POLICY
Attendance is recorded and reported.
However, attendance does not add points to the grade. Students should be aware
that research shows a strong correlation between attendance and course grade.
Absence will not be considered an excuse for submitting assignments
late.
METHODS OF ASSESSMENT AND STUDENT
EVALUATION
|
Report covering Financial
Accounting, Microsoft Excel and Microsoft Word |
45% |
|
Report covering Managerial
Accounting, Microsoft Excel and Microsoft Word |
45 |
|
Homework/Participation |
10 |
|
Total
points |
100% |
EXAMINATIONS AND
PRESENTATIONS
·
If any
exam question is left unattempted, the value of that question will be subtracted
from the exam score. If supporting computations and documentation are missing,
50 percent will be deducted.
·
Being
prepared and present for the exams and presentations is your
responsibility. The exam and presentation will be given on schedule. Mark
your calendars now.
·
A
make-up exam will not be given. If the exam is missed, your total points
possible will be adjusted accordingly.
COURSE OUTLINE
The schedule is
flexible. Much
material is required. It is not possible for an instructor to cover all the
course material without student independent study. As students are interested in
a particular topic or as test scores warrant review, more time will be spent on
a chapter, or as may be required.
|
Week |
Topic |
Homework |
|
08/13 |
Introduction and syllabus For next week (1) Choose Fortune 500 company to study.
(2) Read Ch 11 and 13 (MSO2000), and Accounting
Handout |
|
|
08/20 |
Excel: Formatting, Formulas,
Functions Internet: Search and
Downloads |
|
|
|
Annual Reports |
|
|
|
Income Statement |
|
|
|
Read Ch 12 (MSO2000), and Accounting
Handout |
|
|
08/27 |
Excel: Charts and graphs, If-Then Statements,
Embedding functions, Sorting, Relative versus absolute references,
|
|
|
|
Cost Behavior |
|
|
|
Cost-Volume-Profit
Analysis |
|
|
|
Read Ch 17 (MSO2000), and Accounting
Handout |
|
|
09/03 |
Excel: Goal seek, What if scenarios, Time of
value of money functions |
|
|
|
Budgeting |
|
|
|
Manufacturing Costs |
|
|
|
Variance Analysis |
|
|
|
Read Accounting
Handout |
|
|
09/10 |
Excel: Depreciation
functions |
|
|
|
Balance Sheet,
Assets |
|
|
|
Excel Ch 18 (MSO2000), Read
Accounting Handout |
|
|
09/17 |
Excel: Stock quote
retrievals |
|
|
|
Balance Sheet, Liabilities
& Stockholders' Equity |
|
|
|
Read Ch 35 - 41 (MSO2000), and
Accounting Handout |
|
|
09/24 |
Access: Linking to Excel, Creating
reports, Calculated fields |
|
|
|
Statement of Cash
Flows |
|
|
|
Read Ch 28 - 34 (MSO2000), and
Accounting Handout |
|
|
10/01 |
Outlook: Schedules, Calendar,
Contacts |
|
|
|
Financial Statement
Analysis |
|
|
10/07 |
Presentations |
|
This schedule will change as new
information becomes available.
Check the Web site often.