COURSE SYLLABUS- ONLINE SECTION #23844-201521
INSTRUCTOR: PROFESSOR DENISE F. MC HUGH F E-Mail: Use Blackboard Learn E-mail feature.. If having a
Blackboard Learn E-mail problem… use>
COURSE DATES:START - 8/23/15 END - 12/9/15
Check the Blackboard Learn Calendar Weekly!
MEETING: YOU ARE ADVISED TO ATTEND THE ONLINE ORIENTATION MEETING ON FRIDAY, AUGUST 28, 2015 AT 7 PM – Important information about course requirements and software questions will be addressed. You do NOT have to be on campus to attend. Just find a computer that will permit login to the OCC Online courses.
TEXTBOOKS: Computerized Accounting With QuickBooks 2014
** BE SURE by Villani And Rosa; Published by Paradigm Publishing,
YOU HAVE ISBN #978-0-76386-025-7 (Text And CDs) IF YOU RENT A
QUICKBOOKS 2014 Microsoft Excel 2013, Introductory (Illustrated Series) TEXT OR BUY A
INCLUDING THE by Reding And Wermers; Published by Cengage Learning, USED TEXT, BE
SOFTWARE CD ISBN #13: 978-1-285-09320-8 SURE IT HAS CDs!
GRADING: 90% = A; 80% = B; 70% = C; 60% = D; less than 60% = F
CREDIT = 70%... LESS THAN 70% = NO CREDIT
A LETTER GRADE MAY BE REQUIRED FOR TRANSFER CREDIT
TOTAL COURSE POINTS POSSIBLE = 150 Quizzes are Online.
QUIZZES: 2 Accounting Quizzes and 1 Excel Quiz worth 50 course points each.
NO MAKEUPS. They must be taken during the week they are assigned. There is no extra credit. You are expected to complete the work in a timely fashion which will enable you to earn good Quiz grades as you go along.
CLASS ACTIVITIES: You will LOSE POINTS if you do not engage in Group Discussions on a regular basis. These discussions must be substantial with meaningful content that is well thought out! Language must be professional and business-like. SPELLING MATTERS! You also will LOSE POINTS if you miss an announced activity because you did not check the Blackboard Learn Announcements. It is a good idea to check Announcements DAILY.
ASSIGNMENTS: Homework assignments are provided to help you practice concepts presented in course material and, to identify areas where further study and practice are needed. It is up to you to do homework assignments. All homework should be prepared the same week you study the course material. Answer files for both written questions and computer homework exercises will be made available for your review. Homework is not collected unless students are not keeping up with weekly studies. Complete all assignments before reviewing answer files. Expect to spend a minimum of 5 hours weekly on studies and homework for this course. If you are not current on your accounting knowledge or computer skills, additional time will be required. You will need to spend at least as much time for an Online course as you would for an “on campus” course.
NOTE: It is expected that you have studied and understand Accounting 100 /Accounting 101 (Financial Accounting) concepts prior to taking this class. Have reference texts available. Online classes are based upon off-campus self-guided study. Each week has progress goals to meet.
PLEASE BE AWARE…
You are expected to purchase both the QuickBooks 2014 and the Excel 2013 textbooks. BOTH TEXTS ARE REQUIRED FOR THIS COURSE.
This semester, Fall 2015, we will be using QuickBooks 2014 for the accounting portion of this course. The textbook will have the CDs containing access to the QuickBooks 2014 software, on a limited license. It is essential that you purchase this textbook. Purchase it through the OCC Bookstore. If you purchase a used textbook or you rent a textbook, make sure you have the textbook CDs that contain the software and the student files. If you purchase or lease a book that is missing the CD, the Bookstore will not take it back. Check for the QuickBooks CDs before you leave the bookstore! The Excel textbook used is Microsoft Excel 2013. Those textbook files can be downloaded from the Publisher’s web site.
Please refer to page 1 of the course Syllabus for Textbook information.
COURSE OBJECTIVES
1. Describe the functions of a pre-programmed general ledger accounting package.
2. Save, retrieve, adjust, correct and modify data files.
3. Demonstrate the Program’s operation and application.
4. Produce critical accounting reports.
5. Apply special functions of the Program… payroll, inventory.
6. Read selected reports to determine net income, balances, and variances.
7. Produce functional spreadsheets.
8. Write practical mathematical formulas to maximize spreadsheet effectiveness.
9. Display proper spreadsheet report format.
10. Interpret special applications and capabilities of Excel spreadsheets.
STUDENT OUTCOMES
Your studies and participation in this course should lead you to achieve the following outcomes.
1. Complete an Accounting Cycle for a merchandising business operation using General Ledger software.
2. Complete an Accounting Cycle for a service business operation using General Ledger software.
3. Analyze and Interpret Accounting data through use of reports provided by Accounting software.
4. Demonstrate spreadsheet program operations and applications by designing and creating Accounting spreadsheets and charts, using a variety of formulas and formatting options.
5. Develop sufficient familiarity with Excel functions and tools to optimize presentation of business information for management decision-making.
~ ~ ~ ~ ~
WEEKWEEK 1
ONLINE
MEETING
AUG. 28
AT 7 PM
WEEK 1:
Blackboard
Learn Calendar
Semester
Starts
8/23 / TOPICS
ATTEND ORIENTATION MEETING HELD ONLINE 8/28 FROM 7 PM – 9 PM OR UNTIL ALL QUESTIONS HAVE BEEN ANSWERED.
LOG IN AND GO TO THE GROUP FORUM DISCUSSION AREA FROM ANY COMPATIBLE COMPUTER.
CLASS PROCEDURES; COURSE OUTLINE;
SOFTWARE ORIENTATION
Accessing Orange Coast College Online System; Logging On to the Acct 110 Course; Familiarization with Guidelines and System Checks; Working in Blackboard Learn for
Acct 110 course.
QUICKBOOKS 2014…
OVERVIEW AND FILE MANAGEMENT
Differences and Similarities Between
Manual and Computerized Accounting
Four Levels of Operation Within QuickBooks
Open QuickBooks and a Company File
Using Drop-Down Menus and Dialog Boxes
File Naming and File Extensions
Make a Backup Copy of a Company File
Restore a Backup Copy of a Company File
Change the Company Name in a Company File
ACCOUNTING REVIEW NOTES
Accounting Cycle Overview
Recording Supplies Purchases
Recording Prepaid Insurance Transactions
Recording Adjusting Journal Entries
Recording Closing Journal Entries
Recording Salary Accruals
GENERAL LEDGER REPORTS
* Chart of Accounts
* General Journal
* General Ledger
* Trial Balance
FINANCIAL STATEMENTS
* Income Statement
* Balance Sheet
* Statement of Owner's Equity / ASSIGNMENTS
Purchase Textbooks and Set up your Browser to Begin Working in the BlackBoard Learn Environment.
Load the QuickBooks 2014 Software
Make A Backup of Your QuickBooks Exercise Files CD On Your PC’s Hard Drive
Register Your QuickBooks Software
Review the Course Syllabus and the Online Calendar
Villani & Rosa:
Read Chapter 1- QuickBooks 2014
Read Appendix A- Open or Restore a Company File
Read Appendix B- Manual Accounting Versus QuickBooks
Instructor-Provided
Accounting Notes:
Read As Needed
Read Procedure Review-
Chapter 1*
Prepare Key Concepts- Chapter 1*
Prepare Procedure Check- Chapter 1*
Prepare Case Problems-
Chapter 1: #1 and #2*
Check Blackboard Learn
Announcements
* Answer Files Will Be Made Available Online For You To Check Your Work
WEEK
WEEK 2
Blackboard
Learn Calendar
Week of
8/30 / TOPICS
VENDORS:
ENTER BILLS, PAY BILLS,
ACCOUNTING FOR CASH PAYMENTS
Identify System Default Accounts For Vendors
Update Vendor Center: Adding, Deleting
and Editing Vendors
Record Purchases “On Account” in Enter Bills
Process Debit/Credit Memos in Enter Bills
Record Accounts Payable Payments in Pay Bills
Record Cash Purchases in Write Checks
Display and Print Vendor Reports
ACCOUNTING REVIEW NOTES
Specialized Journals
Returns And Allowances
Discounts
Purchasing System
VENDOR REPORTS:
* Unpaid Bills Detail Report
* Vendor Balance Detail Report
* Vendor Contact List Report
* Vendor Journal Report / ASSIGNMENTS
Villani & Rosa:
Read Chapter 2- Vendors
Read Appendix D-
Purchase Orders
Instructor-Provided
Accounting Notes:
Read As Needed
Read Procedure Review-
Chapter 2*
Prepare Key Concepts- Chapter 2*
Prepare Procedure Check- Chapter 2*
Prepare Case Problems-
Chapter 2: #1 and #2*
Check Blackboard Learn
Announcements
* Answer Files Will Be Made Available Online For You To Check Your Work
WEEK
WEEK 3
Blackboard Learn Calendar
Week of
9/6 / TOPICS
CUSTOMERS:
CREATE INVOICES, RECEIVE PAYMENTS, ENTER SALES RECEIPTS, MAKE DEPOSITS
Identify System Default Accounts For Customers
Update Customer Center: Adding, Deleting
and Editing Customers
Record Sales “On Account” in Create Invoices
Process Debit/Credit Memos in Create Invoices
Record Collections of Accounts Receivable
in Receivable Payments
Record Cash Sales in Enter Sales Receipts
Record deposits in Make Deposits
Display and Print Customer Reports
ACCOUNTING REVIEW NOTES
Specialized Journals
Returns And Allowances
Discounts
CUSTOMER REPORTS:
* Open Invoices Report
* Customer Balance Report
* Customer Contact List Report
* Customer Journal Report / ASSIGNMENTS
Villani & Rosa:
Read Chapter 3- Customers
Instructor-Provided
Accounting Notes:
Read As Needed
Read Procedure Review-
Chapter 3*
Prepare Key Concepts- Chapter 3*
Prepare Procedure Check- Chapter 3*
Prepare Case Problems-
Chapter 3: #1 and #2*
Check Blackboard Learn
Announcements
* Answer Files Will Be Made Available Online For You To Check Your Work
WEEK
WEEK 4
Blackboard Learn
Calendar
Week of
9/13 / TOPICS
PERIOD-END PROCEDURES:
MAKE GENERAL JOURNAL ENTRIES
Update Chart of Accounts List: Adding, Deleting
and Editing General Ledger Accounts
Record Adjustments in
Make General Journal Entries
View the Effect of “Period-End Adjustments”
on the Trial Balance
Display and Print Period-End
Accounting Reports
Display and Print Financial Statements
Change the Reports Display the Using
Customize Report Feature
ACCOUNTING REVIEW NOTES
Review Week 1 Accounting Notes…
Recording Supplies Purchases
Recording Prepaid Insurance Transactions
Recording Adjusting Journal Entries
Recording Closing Journal Entries
Recording Salary Accruals
GENERAL LEDGER REPORTS:
* Chart of Accounts List
* Trial Balance
* General Journal Report
* General Ledger Report
* Adjusted Trial Balance Report
* Register Reports
FINANCIAL STATEMENTS
* Profit & Loss Standard Report
(Income Statement)
* Balance Sheet Standard Report / ASSIGNMENTS
Villani & Rosa:
Read Chapter 4-
Period-End Procedures
Read Appendix C-
Journal Report Types
Instructor-Provided
Accounting Notes:
Read As Needed
Read Procedure Review-
Chapter 4*
Prepare Key Concepts- Chapter 4*
Prepare Procedure Check- Chapter 4*
Prepare Case Problems-
Chapter 4: #1 and #2*
Check Blackboard Learn
Announcements
* Answer Files Will Be Made Available Online For You To Check Your Work
WEEK
WEEK 5
Blackboard Learn Calendar
Week of
9/20 / TOPICS
INVENTORY: RECEIVE ITEMS, SELL ITEMS, PROCESS SALES DISCOUNTS, ADJUST QUANTITY / VALUE ON HAND, PAY SALES TAX
Identify Two Inventory Systems:
Periodic and Perpetual
FIFO / LIFO
Update the Inventory Item List: Adding, Deleting
and Editing Inventory Items
Record Purchases of “Inventory Items”
in Enter Bills and Write Checks
Identify Transactions Requiring Sales Tax
Process Sales Discounts Transactions
Record Adjustments to Inventory Items in
Adjust Quantity/Value On Hand
Record Sales Tax Payments in
Pay Sales Tax
Display and Print Inventory Reports
Display and Print Accounting Reports
and Financial Statements
ACCOUNTING REVIEW NOTES
Perpetual Inventory
Periodic Inventory
FIFO / LIFO Inventory Valuation Methods
Sales Tax Accounting
INVENTORY REPORTS:
* Inventory Valuation Detail Report
* Purchases By Item Detail Report
* Sales By Item Detail Report
* Inventory Journal Report
FINANCIAL STATEMENTS:
* Profit & Loss (Includes COGS Detail)
* Balance Sheet (Includes Inventory Detail) / ASSIGNMENTS
Villani & Rosa:
Read Chapter 5- Inventory
Read Appendix E- Customer
Credits and Bad Debt Write-Offs
Instructor-Provided
Accounting Notes:
Read As Needed
Read Procedure Review-
Chapter 5*
Prepare Key Concepts- Chapter 5*
Prepare Procedure Check- Chapter 5*
Prepare Case Problems-
Chapter 5: #1 and #2*
Check Blackboard Learn
Announcements
* Answer Files Will Be Made
Available Online For You To
Check Your Work
PREPARE FOR
ACCOUNTING QUIZ 1
Includes CHAPTERS 1 - 5
and APPENDICES A - E
WEEK
WEEK 6:
Blackboard Learn Calendar
Week of
9/27 / TOPICS
TAKE ACCOUNTING QUIZ 1
Includes CHAPTERS 1 – 5
and APPENDICES A - E / ASSIGNMENTS
REVIEW QUIZ CONCEPTS YOU WERE UNSURE ABOUT
Check Blackboard Learn
Announcements
WEEK 7
Blackboard Learn Calendar
Week of
10/4 / NEW COMPANY SETUP: ADVANCED SETUP AND EXPRESS START
Create A New Company File and Establish
Preferences Using QuickBooks Advanced
And Express Start Setup Method
and Easy Step Interview
Set Up Customer Center, Vendor Center
and Item List using QuickBooks Setup
Review Information Recorded in
Easy Step Interview and QuickBooks Setup
Establish Preferences
Customize the Chart of Accounts List,
System Default Accounts and Terms List
Update the Chart of Accounts and Item Lists:
Account Numbers, Names, System Defaults
Update the Customer Center and Vendor Center
Adjust the new company file to follow
the Accrual Basis of Accounting
Display and Print Accounting Reports
and Financial Statements
ACCOUNTING REVIEW NOTES
* Review of Default Settings
* Chart of Accounts List
* Trial Balance
* General Journal Report
* General Ledger Report
* Adjusted Trial Balance Report
FINANCIAL STATEMENTS
* Profit & Loss
* Balance Sheet / Villani & Rosa:
Read Chapter 6- New Company
Setup- Advanced Setup
Read Chapter 7- New Company Setup- Express Start
Read Appendix F- New Company
Setup Methods
Instructor-Provided
Accounting Notes:
Read As Needed
Read Procedure Review-
Chapters 6 and 7*
Prepare Key Concepts-
Chapters 6 and 7*
Prepare Procedure Check-
Chapters 6 and 7*
Prepare Case Problems-
Chapters 6 and 7: #1 and #2*
Check Blackboard Learn
Announcements
* Answer Files Will Be Made Available Online For You To Check Your Work
WEEK
WEEK 8
Blackboard Learn Calendar
Week of
10/11 / TOPICS
PAYROLL SETUP AND PROCESSING:
CUSTOM SETUP, PAY EMPLOYEES, PAY LIABILITIES, PROCESS PAYROLL FORMS
Payroll Terminology
Establish Payroll Preferences
Set Up Payroll System Default Accounts
Customize and Update Chart of Accounts
for Payroll Processing and Reporting
Set Up Payroll to Accept Manual Entries
Customize Payroll Item List for Payroll Items
Created by QuickBooks
Update the Payroll Item List
Update the Employee Center
Record Payroll in Pay Employees
Record Payroll Tax Payments in Pay Liabilities
Review Payroll Transaction Accounting
Display and Print Payroll Reports, Accounting