Accounting LESSONS: Unit 2
OERB Website: User Id: Durhamstudent password: oerbs
Search ELO: Resource ID : ELO1092430 (Unit 2: Balance Sheet and Transactions) OR Access through the money bag icon
Search ELO: Resource ID : ELO1092430 (Unit 2: Balance Sheet and Transactions) OR Access through the money bag icon
Fri. Feb. 10th Target: to learn how to create a balance sheet in proper accounting form.
1. Click on Activity One - The Balance Sheet and answer the following questions and activity
2. Activity One Balance Sheet Questions and Activity*
3. As a class, complete Bruce Wayne's Balance Sheet
4. Balance Sheet practice - The Art and Sculptures Store*
5. Balance Sheet practice - Mow-a-Lawn*
Mon. Feb. 13th
1. Start to watch the movie "Catch Me If You Can" (extension of the Ethics Mini-Unit)
2. Please answer the questions as you watch the movie (Question Sheet Handout provided by supply teacher)
Tues. Feb. 14th: Happy Valentine's Day
1. Continue/finish watching the movie "Catch Me If You Can"
2. Finish answering the questions and start the "two-page typed news article" - due tomorrow (Wed. Feb. 15th) at the beginning of class.
3. Please be reminded that your Accounting Designation ISU is also due tomorrow - both assignments due at the beginning of class.
Wed. Feb. 15th Target: to learn how to analyze business transactions.
1. Please hand in your Accounting Designations ISU and your Catch Me If You Can Questions and News Articles
2. Complete the Balance Sheet handout (practice examples 1&4). Take up.
3. Access OERB Unit 2 (through money bag icon)
4. Click on Activity 2 - Business Transactions
Activity Two Questions and Activity
5. Textbook Question #5a, #5b, #6 pg. 13
**There will be a mini-test tomorrow (Thursday) on the Balance Sheet**
Thurs. Feb. 16th Target: to demonstrate understanding of completing a Balance Sheet.
1. Take up Textbook Exercise #5b
2. Do Exercise #6 pg. 14 - take up
3. Balance Sheet Mini-test - you will have 20 minutes to complete the test
3. Take up Activity Two Questions and Activity from yesterday
4. Access OERB Unit 2 (through money bag icon)
5. Click on *Activity Three - The Use of Spreadsheets in Accounting* - make sure to click on "The Basics of.." and "How to use Microsoft Excel" video clips.
Activity Three Questions and Activity
Activity Three Excel Spreadsheet Template**
Tues. Feb. 21st
1. Hand back past assignments and test
2. Take up Activity 2 - Business Transactions
3. Continue with Activity 3 - The Use of Spreadsheets in Accounting - take up
4. Creating a Balance Sheet on Excel Practice Activity #2 Ontime Taxi** **Balance Sheet Template Excel*
5. Click on Activity Four - The Transaction Analysis Sheet and watch the presentation and answer the following Activity Four Questions* - take up
Wed. Feb. 22nd:
1. Take up Ontime Taxi Balance Sheet
2. Take up Activity 4 Questions
3. Do *Activity Four Saints Softball Activity* - take up
*Hint: zero proof formula for Transaction #1 (Cell L8) is: =SUM(B8:H8)-SUM(I8:K8)
4. Balance Sheet Guided Practice - Liverpool Cleaners*
*Balance Sheet Template*
4. More MS Excel Balance Sheet Practice - Acting 101 Balance Sheet - complete and submit online (in your hand in folder)
*Balance Sheet Template*
1. Click on Activity One - The Balance Sheet and answer the following questions and activity
2. Activity One Balance Sheet Questions and Activity*
3. As a class, complete Bruce Wayne's Balance Sheet
4. Balance Sheet practice - The Art and Sculptures Store*
5. Balance Sheet practice - Mow-a-Lawn*
Mon. Feb. 13th
1. Start to watch the movie "Catch Me If You Can" (extension of the Ethics Mini-Unit)
2. Please answer the questions as you watch the movie (Question Sheet Handout provided by supply teacher)
Tues. Feb. 14th: Happy Valentine's Day
1. Continue/finish watching the movie "Catch Me If You Can"
2. Finish answering the questions and start the "two-page typed news article" - due tomorrow (Wed. Feb. 15th) at the beginning of class.
3. Please be reminded that your Accounting Designation ISU is also due tomorrow - both assignments due at the beginning of class.
Wed. Feb. 15th Target: to learn how to analyze business transactions.
1. Please hand in your Accounting Designations ISU and your Catch Me If You Can Questions and News Articles
2. Complete the Balance Sheet handout (practice examples 1&4). Take up.
3. Access OERB Unit 2 (through money bag icon)
4. Click on Activity 2 - Business Transactions
Activity Two Questions and Activity
5. Textbook Question #5a, #5b, #6 pg. 13
**There will be a mini-test tomorrow (Thursday) on the Balance Sheet**
Thurs. Feb. 16th Target: to demonstrate understanding of completing a Balance Sheet.
1. Take up Textbook Exercise #5b
2. Do Exercise #6 pg. 14 - take up
3. Balance Sheet Mini-test - you will have 20 minutes to complete the test
3. Take up Activity Two Questions and Activity from yesterday
4. Access OERB Unit 2 (through money bag icon)
5. Click on *Activity Three - The Use of Spreadsheets in Accounting* - make sure to click on "The Basics of.." and "How to use Microsoft Excel" video clips.
Activity Three Questions and Activity
Activity Three Excel Spreadsheet Template**
Tues. Feb. 21st
1. Hand back past assignments and test
2. Take up Activity 2 - Business Transactions
3. Continue with Activity 3 - The Use of Spreadsheets in Accounting - take up
4. Creating a Balance Sheet on Excel Practice Activity #2 Ontime Taxi** **Balance Sheet Template Excel*
5. Click on Activity Four - The Transaction Analysis Sheet and watch the presentation and answer the following Activity Four Questions* - take up
Wed. Feb. 22nd:
1. Take up Ontime Taxi Balance Sheet
2. Take up Activity 4 Questions
3. Do *Activity Four Saints Softball Activity* - take up
*Hint: zero proof formula for Transaction #1 (Cell L8) is: =SUM(B8:H8)-SUM(I8:K8)
4. Balance Sheet Guided Practice - Liverpool Cleaners*
*Balance Sheet Template*
4. More MS Excel Balance Sheet Practice - Acting 101 Balance Sheet - complete and submit online (in your hand in folder)
*Balance Sheet Template*
Thurs. Feb. 23rd
1. Take up Saints Softball Balance Sheet
2. Do Balance Sheet Guided Practice - Liverpool Cleaners*
*Balance Sheet Template*
3. Do Balance Sheet Practice - Acting 101 Balance Sheet
*Balance Sheet Template* - complete and submit online (in your hand in folder)
4. Guided Practice - Transaction Analysis Sheet Practice - Doggy Dasz Spa Transactions* *Transaction Analysis Sheet Template*
5. Transaction Analysis Sheet Practice - Textbook Ex. #9 pg. 21 Template*
6. Transaction Analysis Sheet Practice - Textbook Ex. #10 pg. 22 Template*
Fri. Feb. 24th
1. Take up Ex. #9 pg. 21 Balance Sheet and Ex. #10
2. Do Transaction Analysis Sheet Practice - *Textbook Exercise #11 pg. 22-23 Template*
**you will need to log into OERB: login: durhamstudent password: oerbs
3. Debit/ Credit Lesson** (click on the link and Search: Resource ID : ELO1222770) *Debit/Credit Questions & Activity**
4. Double Entry Accounting Lesson** (Search OERB Resource ID : ELO1222780) **Double Entry Activity**
**Dragon's Den* - Liquid Hot Chocolate* *Dragon's Den Question Sheet*
Mon. Feb. 27th
1. Finish and take up Double Entry Accounting Lesson Activity - Chart only (no T-Accounts)
2. Access OERB - Unit 2 through money bag icon or from home/internet - Search: ELO1092430
3. Click on Activity Five - Ledger, Trial Balance and T-Accounts
**Activity Five Questions**
4. Finish Double Entry Activity from Friday (Rebecca's Pet Grooming T-Accounts)
5. Saints Softball - T-Accounts MS Excel Activity**
**Balance Sheet on Excel TEST tomorrow**
Tues. Feb. 28th
1. Balance Sheet Excel Mini-Test* *Balance Sheet Template*
2. REVIEW: Debit/Credit Theory Recap - click on Topic 1 - Intro.* - Debit/Credit Quiz tomorrow
3. Seatwork: T-Accounts and Trial Balance practice - Goldman's Gym - handout
4. Take up Monday's work - Saints Softball - T-Accounts MS Excel Activity**
Wed. Feb. 29th
1. Finish Saints Softball Activity - will take up tomorrow
2. Textbook work - Ex. #1a pg. 51 *Ex. #1a Template*
3. Textbook work - Ex. #2 pg. 52 **Ex. #2 Template*
4. Textbook work - Ex. #3 pg. 52 a) *Ex. #3 Template for anaylzing transactions*
b) then use T-accounts set up from Ex. #1a to transfer transactions to
c) Calculate t-account balances
d) Then create a Trial Balance Sheet*
5. Textbook work - Ex. #4 pg. 52 a) Open and complete t-accounts and then calculate t-account balances
b) Create a Trial Balance Sheet*
6. Debit/Credit Quiz tomorrow
Thurs. Mar. 1st
1. Take up Saints Softball Activity
2. Take up textbook Exercises #1-4 pg. 51-52
Fri. Mar. 2nd
1. Debit/Credit Quiz
2. Take up Ex. #4
3. Start textbook Exercises #5-9
*Ex. #5 Template* *Trial Balance Sheet*
*Ex. #6 Template*
*Ex. #7 Analyzing Transactions Template*
*Ex. #8 Analyzing Transactions Template*
*Ex. #9 T-Accounts and Trial Balance Template*
4. TEST on Wed. Mar. 7th
Mon. Mar. 5th
1. Please print off and submit Ex. #5 (t-accounts only) and the trial balance sheet of Ex. #9
2. Do Ex. #10 & 11
*Ex. #10 Analyzing Transactions Template*
*Ex. #11 T-Accounts and Trial Balance*
3. Will take up ALL exercises at the end of class
4. When you finish Ex. # 11 you may start on Cases #1-3 pg. 62-63
**Test on Wednesday
Tues. Mar. 6th
1. Take up Ex. #9-11
2. Trial Balance Out of Balance Lesson and Activities handout
3. Cases #1-5 pg. 62-63
4. Test tomorrow - please see me tomorrow morning or at lunch for extra help before test.
Wed. Mar. 7th
1. You have the entire period to write the test. *Unit 2 TEST Template*
With regards to the test, please do the following:
a) Answer Question #1 on the test booklet. Answers questions #2-5 in the MS Excel template
b) Save the test as Unit 2 Test_your name
c) Drop off the test to: BAF (Money Bag icon, Groupwork, Unit 2 TEST folder
d) Print a copy of all FOUR (4) Excel spreadsheet questions - please ensure your name is typed onto the spreadsheet BEFORE printing and please ensure each question fits on one page (you will have to do print preview). and staple it to your test booklet
*Failure to do any of the above will result in mark deduction.
2. When you are finished the test, you may work on completing the Cases from yesterday (Cases #1- 5 pgs. 62-63)
Thurs. Mar. 8th - Happy March Break
1. Finish and take up Cases #1-5 pg. 62.-63
2. GAAP Booklet
Mon. Mar. 19th
**Link to Unit 3**
1. Take up Saints Softball Balance Sheet
2. Do Balance Sheet Guided Practice - Liverpool Cleaners*
*Balance Sheet Template*
3. Do Balance Sheet Practice - Acting 101 Balance Sheet
*Balance Sheet Template* - complete and submit online (in your hand in folder)
4. Guided Practice - Transaction Analysis Sheet Practice - Doggy Dasz Spa Transactions* *Transaction Analysis Sheet Template*
5. Transaction Analysis Sheet Practice - Textbook Ex. #9 pg. 21 Template*
6. Transaction Analysis Sheet Practice - Textbook Ex. #10 pg. 22 Template*
Fri. Feb. 24th
1. Take up Ex. #9 pg. 21 Balance Sheet and Ex. #10
2. Do Transaction Analysis Sheet Practice - *Textbook Exercise #11 pg. 22-23 Template*
**you will need to log into OERB: login: durhamstudent password: oerbs
3. Debit/ Credit Lesson** (click on the link and Search: Resource ID : ELO1222770) *Debit/Credit Questions & Activity**
4. Double Entry Accounting Lesson** (Search OERB Resource ID : ELO1222780) **Double Entry Activity**
**Dragon's Den* - Liquid Hot Chocolate* *Dragon's Den Question Sheet*
Mon. Feb. 27th
1. Finish and take up Double Entry Accounting Lesson Activity - Chart only (no T-Accounts)
2. Access OERB - Unit 2 through money bag icon or from home/internet - Search: ELO1092430
3. Click on Activity Five - Ledger, Trial Balance and T-Accounts
**Activity Five Questions**
4. Finish Double Entry Activity from Friday (Rebecca's Pet Grooming T-Accounts)
5. Saints Softball - T-Accounts MS Excel Activity**
**Balance Sheet on Excel TEST tomorrow**
Tues. Feb. 28th
1. Balance Sheet Excel Mini-Test* *Balance Sheet Template*
2. REVIEW: Debit/Credit Theory Recap - click on Topic 1 - Intro.* - Debit/Credit Quiz tomorrow
3. Seatwork: T-Accounts and Trial Balance practice - Goldman's Gym - handout
4. Take up Monday's work - Saints Softball - T-Accounts MS Excel Activity**
Wed. Feb. 29th
1. Finish Saints Softball Activity - will take up tomorrow
2. Textbook work - Ex. #1a pg. 51 *Ex. #1a Template*
3. Textbook work - Ex. #2 pg. 52 **Ex. #2 Template*
4. Textbook work - Ex. #3 pg. 52 a) *Ex. #3 Template for anaylzing transactions*
b) then use T-accounts set up from Ex. #1a to transfer transactions to
c) Calculate t-account balances
d) Then create a Trial Balance Sheet*
5. Textbook work - Ex. #4 pg. 52 a) Open and complete t-accounts and then calculate t-account balances
b) Create a Trial Balance Sheet*
6. Debit/Credit Quiz tomorrow
Thurs. Mar. 1st
1. Take up Saints Softball Activity
2. Take up textbook Exercises #1-4 pg. 51-52
Fri. Mar. 2nd
1. Debit/Credit Quiz
2. Take up Ex. #4
3. Start textbook Exercises #5-9
*Ex. #5 Template* *Trial Balance Sheet*
*Ex. #6 Template*
*Ex. #7 Analyzing Transactions Template*
*Ex. #8 Analyzing Transactions Template*
*Ex. #9 T-Accounts and Trial Balance Template*
4. TEST on Wed. Mar. 7th
Mon. Mar. 5th
1. Please print off and submit Ex. #5 (t-accounts only) and the trial balance sheet of Ex. #9
2. Do Ex. #10 & 11
*Ex. #10 Analyzing Transactions Template*
*Ex. #11 T-Accounts and Trial Balance*
3. Will take up ALL exercises at the end of class
4. When you finish Ex. # 11 you may start on Cases #1-3 pg. 62-63
**Test on Wednesday
Tues. Mar. 6th
1. Take up Ex. #9-11
2. Trial Balance Out of Balance Lesson and Activities handout
3. Cases #1-5 pg. 62-63
4. Test tomorrow - please see me tomorrow morning or at lunch for extra help before test.
Wed. Mar. 7th
1. You have the entire period to write the test. *Unit 2 TEST Template*
With regards to the test, please do the following:
a) Answer Question #1 on the test booklet. Answers questions #2-5 in the MS Excel template
b) Save the test as Unit 2 Test_your name
c) Drop off the test to: BAF (Money Bag icon, Groupwork, Unit 2 TEST folder
d) Print a copy of all FOUR (4) Excel spreadsheet questions - please ensure your name is typed onto the spreadsheet BEFORE printing and please ensure each question fits on one page (you will have to do print preview). and staple it to your test booklet
*Failure to do any of the above will result in mark deduction.
2. When you are finished the test, you may work on completing the Cases from yesterday (Cases #1- 5 pgs. 62-63)
Thurs. Mar. 8th - Happy March Break
1. Finish and take up Cases #1-5 pg. 62.-63
2. GAAP Booklet
Mon. Mar. 19th
**Link to Unit 3**