BUSAD 200 Financial Accounting on Spreadsheet

BUSAD 200?Financial Accounting on Spreadsheet

Fall 2019

Section 7108: M 6-8:15 pm, FH 111

Plus 2 hours online

Required Texts and Software: The text and lab manual are both available in the Pirate's book store. The text is also available via the book website as noted below. The individual information is: How to Use Microsoft? Excel?: The Careers in Practice Series, (v. 1.1.2). Joseph Manzo. FlatWorld Knowledge Publishing Company. eISBN: 978-1-4533-8574-6. Financial Accounting on Spreadsheet, Edition 8.3. Linda Christensen Kropp. MJC Duplicating. Students will require access to Excel? 2016 software which is NOT included in the text book. Labs are available on campus

if you do not have access to a computer with Excel? elsewhere (Excel? 2013 or 2010 may be used but will not exactly match the text).

Course Description: Introduction to spreadsheet software. Spreadsheet analysis, design, testing, and documentation as they relate to the field of accounting will be covered; hands-on experience using Microsoft? Excel? as a tool for solving financial accounting problems. This course will follow the Financial Accounting course, using similar problems for Excel practice.

Prerequisites: Previous completion of BUSAD 310 (OR) previous or concurrent enrollment in BUSAD 201 or equivalent. If BUSAD 310 is used for prerequisite, BUSAD 320 is recommended for success.

Here is my plan for maintaining Regular Effective Contact with you throughout the course:

I will usually post at least one announcement per week with reminders and other notifications

about what is happening in the course and/or on campus.

I will provide you with feedback on your assignments. My goal is to do this within one week

but occasionally it may take a little longer. Be sure to check the gradebook for my feedback.

I may message you if I see you are falling behind or if you miss a major exam. Please let me

know if you run into difficulties that prevent your submitting your work in a timely fashion.

I may reach out to you in other ways as well including phone messages and/or email.

Here are the ways you can make contact with me outside of the Canvas learning environment:

Instructor Contact Information: Email: Communication through Canvas is preferred. If you choose to contact me through MJC email (kroppl@mjc.edu), please put "Busad 200" in the subject line to ensure your email does not get lost in the shuffle. Emails will be returned within 24-48 hours, Monday through Friday, 48 hours on the weekend. If you do not hear back in a timely fashion, please resend your message and/or leave a voicemail. When communicating via email please include the following information: Your CLASS and SECTION, Your NAME. It is difficult to answer your question if I don't have this information. Phone: (209) 575-6168 Office Hours: Founders Hall 120-D

Student Learning Objectives: Upon successful completion of the BUSAD 200 course:

1. Construct complex spreadsheet formulas and functions to build effective accounting spreadsheets from start to finish.

2. Format spreadsheets to enhance visualization, readability and presentation including charts and graphs.

3. Design user-friendly spreadsheet templates to collect and communicate accurate and useful accounting information.

Diversity and Disability: Disabled Students Services can be found on the web at . Call 209-575-6225, Fax 209-575-6852 or TTY 209575-6863. The office can also be reached by email at: mjcdsps@mjc.edu.

Policies and Procedures: On-campus Lab: All work can be completed at home and submitted for grading, however, the following lab is open for your use. Founders Hall 114: Monday-Thursday 9 am ? 6:45 pm

Coursework: Students are expected to turn in assignments on a regular schedule throughout the semester. All assignments are due at the beginning of class the week after they are assigned. This allows a week to complete the chapters and exercises.

Homework assignments for each chapter in the TEXT (by Manzo) will be submitted in Canvas. PROBLEMS (from the lab manual) will be printed and turned in at the beginning of the class period when they are due. Cases will be submitted both in print AND on Canvas. Homework scores will usually be available on-line within one week after receipt of assignments.

Quizzes will be available for the week that the TEXT chapter is assigned and is due when the chapter exercises are due and will usually be taken in class.

A cumulative hands-on final will be given at the end of the semester.

Grading Policy: Grades will be based upon completion, timeliness and quality of assignments. Late assignments will be accepted for two additional weeks after it is due but will automatically be 50% off. Grades will be based on the following scale:

Text Chapter Printouts Text Chapter Quizzes Problems Cases (3) Final Exam Total

(170 pts) (80 pts) (400 pts) (150 pts) (200 pts) 1000 pts

17% 8% 40% 15% 20% 100%

90 -100%

= A

80 - 89%

= B

70 - 79%

= C

60 - 69%

= D

0 - 59%

= F

Adding/Dropping:

Students may add with an add code during the first two weeks of class. It is the student's responsibility to drop the course if they do not intend to complete the course; however, a student may be dropped from the course for nonparticipation if they do not turn in any assignments for a two week period. Weekly assignments made on Mondays will be due on Monday of the following week at the end of class (unless otherwise noted for holidays). Manzo Text quizzes will be due on Monday at the end of lab.

Late Work: Due to the fact that "life happens" I DO accept late work. Problems, Manzo Chapters, Quizzes and Cases will be accepted two weeks after the due date with the following stipulation: if it is late, it is 30% off. My goal is for you to learn the material. If life gets in the way only a couple of times, you can still pass my class.

Fall Important Dates: September 2: Labor Day Holiday September 8: Last day to drop without a "W", Last day to add. September 24: Last day to file for Pass/No Pass November 11: Veteran's Day Holiday November 14: Last day to drop November 28-Dec 1: Thanksgiving Holiday December 9: Final Examination - 6-8:30 pm

Academic Honesty: Students caught copying, sharing work and/or plagiarizing will receive a failing grade on the assignment/test and in the course, as well as possible disciplinary action from the college.

Plagiarism Some students have trouble understanding what plagiarism is, so let's get that straight right away. Plagiarism includes copying writing or merely ideas from the published or unpublished work of another person without full, clear acknowledgment of the source. If you paraphrase or summarize what someone else has said, you must acknowledge that source even when you put those ideas into your own words. You are plagiarizing if you cut and paste bits and pieces of writing from the Internet or any other source and make it appear as if you wrote those words (i.e. if you don't use quotation marks and cite the source). Plagiarism also includes copying from yourself--that is, turning in material that you wrote for another class.

In this course, plagiarism detection software may be used on assignments you submit. If you're not sure what plagiarism is, check out the MJC Library "Avoid Plagiarism" page. It includes brief videos and tutorials.

Any assignment where academic dishonesty is involved will automatically receive an F (zero points), which may result in the student failing the course. A report may be filed. For additional information, see the MJC Standard of Student Conduct webpage.

Copyright Infringement: Students will need the use of Excel 2013 or later software to complete the assignments for the course. Student versions of the software are available for purchase at student pricing and labs are available on campus for student use. It is illegal to simply copy another student's software. Microsoft Office can be download from your student email account--instructions will be included in an announcement during the first week of class.

Trouble Accessing a Hybrid Class? If you should have trouble logging into Canvas once the semester has started, contact the Helpdesk by email: mailto:onlinehelpdesk@yosemite.edu or website: for assistance with your account. The Helpdesk hours are as follows:

Student Helpline during regular MJC business hours: 209-575-7900

Nights and Weekends Helpline for Students: 844-303-8280

Manzo Text Chapters Quizzes and M/C Exam

Lab Manual Problems Lab Manual Cases Hands-on Exam

Assignment Schedule: (all assignments are due the following week at the beginning of class)

Week

Assignment

Source

Turn in:

1 ( Aug 26)

Manzo Chapter 1 ? Intro to Microsoft Excel? (Due 9/10 ?end of lab)

Manzo Text Canvas

2 (Sep 2)

Martin Luther King Holiday ? No Class

3 (Sep 9)

Chapter 1 ? T Accounts

Lab Manual Print

4 (Sep 16)

Manzo Chapter 2 ? Using Formulas in Excel?

Manzo Text Canvas

5 (Sep 23)

Chapter 2 ? Adjusting Entries

Lab Manual Print

6 (Sep 30)

Manzo Chapter 3 ? Advanced Formulas

Manzo Text Canvas

7 (Oct 7)

Chapter 3 ? The Accountant's Worksheet

Lab Manual Print

8 (Oct 14)

Chapter 4 ? Case 1

Lab Manual Print/Canvas

9 (Oct 21)

Chapter 4 ? Case 2

Lab Manual Print/Canvas

10 (Oct 28)

Chapter 5 - Lower of Cost or Market

Manzo Text Print

11 (Nov 4)

Chapter 6 ? Bank Reconciliation

Lab Manual Print

12 (Nov 11)

Veteran's Day ? No Class Manzo Chapter 4 - Charting

Manzo Text Canvas

13 (Nov 18)

Chapter 7 - Depreciation

Lab Manual Print

14 (Nov 25)

Chapter 8 ? Payroll

Lab Manual Print

15 (Dec 2)

Chapter 9 ? Case 3

Lab Manual Print/Canvas

Scantron 883 portion of Final/Templates Due

16 (Dec 9)

Final Exam-- Monday, 6-9 pm (Hands-on Exam)

Lab Manual Class & Canvas

This syllabus is subject to change as needed throughout the semester.

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download