BA104: Computer Applications in Accounting

 

COURSE DESCRIPTION:

Students will learn the basic elements of spreadsheet software (MS Office Excel 2007) and apply them to accounting principles.  Emphasis will be on creating formulas for problem solving and on building spreadsheet models.  This course uses a combination of discussions and hands-on exercises.

 

Course Objectives:

At the completion of this course, you will be able to:

1. Demonstrate proficiency in using spreadsheet software to develop formulas and graphs that manipulate data and provide desired results.

2. Demonstrate the ability to use spreadsheet software for a variety of common accounting applications by completing previously developed templates

3. Demonstrate the ability to create usable spreadsheet templates for a variety of accounting applications

 

PREREQUISITES OR COREQUISITES:

 Prerequisite:  BA 101A or BA 106

 

COURSE REQUIREMENTS:

1.     Perform assigned tasks and readings from the textbook.

2.     Complete all class assignments.

3.     Participate in class discussions.

4.     Access documents and submit assignments via WebCT

5.    MS Office Excel 2007

This class uses the online course management system WebCT to access lessons and other documents; students submit questions/comments as well as assignments via WebCT.

 

ONLINE HELP DESK

If you experience technical difficulties with WebCT please do not contact the instructor; instead, please contact

http://www2.ohlone.edu/instr/onlineeducation/aboutus/index.htm

 

HOW TO LOG IN TO WEBCT

Enter your user name The first two letters of your first name; the first two letters of your last name; followed by the last four digits of your Student ID

Enter your password (default is student in lower case)

(You will be required to change your password on your first login)

 

For more info please navigate to

http://www2.ohlone.edu/instr/onlineeducation/students/login_info.htm

 

HOW TO LOG IN TO WEBCT-VIDEO CLIP

http://www2.ohlone.edu/instr/onlineeducation/students/How%20To%20Log%20Into%20WebCT1/How%20To%20Log%20Into%20WebCT.html

 

MINIMUM HARDWARE/SOFTWARE REQUIREMENTS

http://www2.ohlone.edu/instr/onlineeducation/faculty/software_hardware_req.htm

 

BROWSER CHECK

The browser tune-up will ensure that you are using a supported browser. It includes step-by-step instructions to make sure your browser settings are optimized for the best possible WebCT experience

http://www.webct.com/tuneup

 

 

 

DOWNLOADS

You will need to ensure you have installed the following software plug-ins into your system:

WebCT maintains a site with links to all the plug-ins you will need. Visit http://www.webct.com/tuneup/viewpage?name=tuneup_browser_tuneup_information#plugins 

ONLINE STUDENT RESOURCES

http://www2.ohlone.edu/instr/onlineeducation/students/index.htm

 

TEXT/MATERIALS:

Excel Applications for Accounting Principles. Smith, Gaylord N.  3rd edition Thomson-SouthWestern ISBN 9780324379150

 

To view the textbook used in BA 104, navigate to http://www.thomsonedu.com

type 9780324379150   in the search textbox labeled “Enter ISBN”

 

The data files can be downloaded from the link below (copy the link below and paste it in your browser address)

http://websites.swlearning.com/cgi-wadsworth/course_products_wp.pl?fid=M20b&product_isbn_issn=9780324379150&discipline_number=400

 

RESOURCES:

This is a partial list of sites where you may purchase the textbook:

http://www.ohlonebookstore.com                                   http://gettextbooks.com

http://www.bigword.com                                                   http://www.half.com

 

Discounted software for students and instructors:

http://www.collegesoftware.org                                        http://www.creationengine.com/

 

GRADING

In this class there are no make-up assignments or assignments for extra/bonus points.

Your final grade is based on completion of the following activities:

 

 

Percentage

GRADING

SCALE:

Participation

10%

90-100%

A

Project assignments

70%

80-89%

B

Final

20%

70-79%

C

TOTAL

100%

60-69%

D

 

 

<59%

F

 

Discussion READINGS and PARTICIPATION Assignments

Discussion readings and participation are a very important component of online learning. The purpose of these discussions is to encourage cooperative learning; your classmates may have the answer you are looking for. To make this class more useful, it is important to make use of your classmates. Or if you're ahead, help out a fellow student with your hard earned knowledge.

 

Logging into the course and visiting the Course content area, Calendar, Announcements, Assignments, Discussion area and your WebCT email will be the equivalent of attending class.

 

You are required to check in the Discussion Forum at least once a day (Monday through Friday) to read the postings and/or help out your classmates and post questions if you have any.

You are required to follow the weekly schedule of activities as stated in the schedule below; it is recommended that you plan accordingly and give plenty of time for the instructor and students to answer any questions that you may have.

 

A student will be dropped from class if s/he has not checked in the Discussion Forum at least three days during a week (M-F) or has not submitted assignments during a two weeks period

 

 

Instructor Participation/Responses Discussion:

The instructor will check in the Forum twice a day (Monday through Friday). The instructor will read all discussion postings. The instructor will respond with helpful comments and advice at appropriate times; the instructor, however, will not respond to every post in the discussion board.

 

EMAIL

If you need to communicate with the instructor about an issue that is not suitable for posting on the Discussion Forum please use the WebCT email tool.

The instructor does not check his other emails as often as he checks the WebCT email. The instructor responds ONLY to questions/issues/comments posted in the WebCT email.

The instructor will respond to email requests within 24 hours during the work week (Monday through Friday)

Assignments submitted via email will receive no credit.

 

NETTIQUETTE

Although the tone of your discussion board postings can be informal, your instructor will expect them to be on a professional level. Please use online etiquette and professionalism when placing comments.

Any comments unrelated to the discussion forums and/or that do not meet online etiquette and professionalism will be deleted. For more info please visit

http://www.learnthenet.com/english/html/09netiqt.htm

 

PROJECT ASSIGNMENTS

All assignments are due on the due date specified in the Schedule. No work will be accepted after the due date. There will be no make-up assignments or assignments for extra credit. Assignments submitted via email will receive no credit. Keep a record of your scores and maintain all returned assignments until final grades are calculated.

The assignments will be corrected and returned no later than seven days after the assignment due date; for example, if the assignment was due on September 14, the corrected assignment will be returned on or before September 21. The schedule below shows the dates when corrected assignments are returned.

 

FINAL

The final is given online and lasts at the most two hours. The online test will be given on the day/time as specified in the schedule. Make the appropriate arrangements to be available to take the online test on the day/time specified since the test will not be given on any other day/time.

 

LATENESS POLICY:

All assignments, projects and final are due on the due dates as stated. No credit will be given for assignments projects and final submitted after the due dates. All assignments are to be submitted via the Assignment tool; assignments submitted via email will not be accepted.

The WebCT Server may occasionally experience technical difficulties; so please plan accordingly and submit your assignments promptly.

 

ACADEMIC HONESTY POLICY:

Please read the following document regarding academic honesty policies: http://www.ohlone.edu/org/board/policy/chapter7reg.htm#r7.8.4

 

WITHDRAWALS/DROPS:

A student will be dropped from class if s/he has not checked in the Discussion Forum at least three days during a week (M-F) or has not submitted assignments during a two weeks period.

Students are responsible for the proper revision of their class schedules. Students who stop attending this class are responsible to verify the drop through WebAdvisor. If this is not done, the student may be carried in the class to the end of the semester and receive an "F" grade

Last day to drop this class and be eligible for a refund: Tuesday, September 8

Last day to drop this class without a W grade: Monday, Sunday, September 13

Last day to drop this class with a W grade: Thursday, November 19

Grades available via WebAdvisor: Monday, January 4

For more information visit

http://www.ohlone.edu/org/admissions/academiccalendar.html

 FINAL GRADE POSTING:

The final grades will be available via WebAdvisor on Monday, January 5, 2009. The instructor will not issue final grades to individual students.

SCHEDULE:

Scroll down to view the weekly schedule of topics and assignments due dates. The last table displays dates when corrected assignments are returned.

 

Week

Date

Topics/Assignments

Tasks/Readings

1

8/31 -9/6

Introduction. Creating a Worksheet

Assignment: XL01

 

Kona’s Expresso Coffee , due  on or before 9/14

 

WebCt tools

Introductions

 

Online document

2

9/7-9/13

Formulas, Functions and Formatting

Assignment:  Read tutorial XL02

 

 

Online document

3

9/14-9/20

Practice problem : ESTIMATOR

Due: on or before 9/21

Text: pp. 2-11

 

 

4

9/21- 9/27

Assignment P1

Business Transactions (PTRANS)

Due: on or before 9/28

 

 

Text: pp. 26-29

5

9/28-10/4

Assignment P2

P2: Service Company Worksheet (F1WORK)

Due: on or before 10/5

 

 

Text: pp. 30-34

6

10/5-10/11

Assignment P3

P3: Merchandising Co. worksheet (P2WORK)

Due: on or before 10/12

 

 

Text: pp. 35-39

7

10/12-10/18

Assignments P4 and P5

P4: Merchandising Company Financial Statements

(FMERCH)

P5: Bank Reconciliation (BANKREC)

P4 and P5: due on or before 10/19

 

 

Text: pp. 40-44

 

 

 

Text: pp. 45-49

8

10/19-10/25

Assignments P6 and P8

 

P6: Aging Account Receivables (AGING)

P8: Gross Profit Method (GP)

P6 & P8 due on or before 10/26

 

 

Text: pp. 50-53

Text: pp. 59-61

 

9

10/26-11/1

Assignment P9

P9: Depreciation (DEPREC)

Due: on or before 11/2

 

 

Text: pp. 62-65

 

10

11/2-11/8

Assignment P10

P10: Payroll Register (PR)

Due: on or before 11/9

 

 

Text: pp. 66-70

 

11

11/9-11/15

Assignment P14:

P14: Statement of Cash Flows (CASHFLOW)

Due: on or before 11/16

 

 

 

Text: pp. 83-89

 

12

11/16-11/22

Assignments P17, M1 and M2

P17: Job Order Costing  (JOB)

M1: Trial Balance  (FTB)

M2: Financial Statements (PFS)

P17, M1 and M2 due on or before 11/30

 

 

Text: pp. 100-104

Text: p. 155

Text: p. 156

 

13

11/23-11/29

Thanksgiving holiday

 

 

14

11/30-12/6

Assignments M3, M4 and M5

M3: Cash Receipts Journal

M4: Short-Term Investments

M5: Perpetual-Inventory Record

M3, M4 and M5 due: on or before 12/7

 

 

Text: p. 157

Text: p. 158

Text: p. 159

 

15

12/7-12/11

Assignments M6, M7 and M8

M6: Inventory Valuation

M7: Lump Sum Purchase

M8: Bonds vs. Stock Financing

M6, M7 and M8 due: on or before 12/14

 

 

Text: p. 160

Text: p. 161

Text: p. 162

 

16

12/14

7:00 - 9:00 pm

Final