AIS205 - Computerised Accounting

SEMESTER OCT 2024 - FEB 2025

✅AC1103F ✔AC1103G
Covered in Class session 
  1. Welcoming messages ✅✔
  2. Expectations / Ground rules ✅✔
  3. Teaching materials ✅✔
  4. AI Introduction ✅✔
  5. Lesson Plan
  6. Carry Marks - 3F
  7. Carry Marks - 3G

Assessment
  1. Quiz 10%-W4-Dewan Merpati 2030-2130 (29/10/2024) ✅✔ Markah
  2. G Project 25% - W8 - 5/12/2024 BEFORE 5PM ✅✔ Question | Rubric
  3. Lab Test 15% - W14 - During Class ✅✔
  4. Final Assessment - 50% ✅✔
Main Workbook

  1. Nor Asiah ldris, Annuar Muhammad, Mohd Haron A.Alim and Samsuria Abdul Rahman. Microsoft Excel 2010 Application in Accounting with Supplementary Notes on Introduction to Accounting lnformation System. 2nd Edition, 2014, Pearson. ✅✔
  2. Sage UBS Accounting Self Study Guide 2011 Edition. ✅✔


FINAL ASSESSMENT
  1. 2024 July - Question 1,2, 3✅| Self Test MCQ | Self Test T/F | ✅✔
  2. 2024 July, Question 4 | 2024 January Question 4 - Kelas tambahan
  3. 2024 January - Question | Self Test MCQ | Self Test T/F | ✅
  4. 2023 July - Question | Self Test MCQ | Self Test T/F |
  5. 2023 February - Question | Self Test MCQ | Self Test T/F |✅✔
  6. 2022 July - Question | Self Test MCQ | Self Test T/F |
  7. 2022 February - Question | Self Test MCQ | Self Test T/F |
  8. 2019 Jun - Question | Self Test MCQ | Self Test T/F |✅✔
  9. 2018 Dec - Question | Self Test MCQ | Self Test T/F |✅✔
  10. 2018 Jan - Question | Self Test MCQ | Self Test T/F |✅✔

CLASS ACTIVITIES

Week 1
  1. W1 Topic 1 - Overview of AIS - Slides |ST 1| ST2|ST3| add video✅✔
  2. W1 Meet the inventor of the electronic spreadsheet✅✔
  3. W1 Introduction to Microsoft Excel 1992✅✔
  4. W1 The Beginner's Guide to Excel ✅✔
Week 2
  1. W2 MS Excel Lesson 1 Introduction |ST 1| ST2|ST3|✅✔
  2. W2 Microsoft Excel - Lesson 1✅✔
  3. W2 Microsoft Excel - Creating a chart - submission | 3F | 3G |✅✔
Week 3
  1. W3 Microsoft Excel - Relative Cell Referencing in a worksheet |ST 1| ST2|ST3|✅✔
  2. W3 Microsoft Excel - Absolute Cell Referencing in a worksheet |ST 1| ST2|ST3|✅✔
  3. W3 Relative vs Absolute |ST 1| ST2|ST3|✅✔
  4. W3 MS Excel Lesson 2 IF Function |ST 1| ST2|ST3|✅✔
  5. W3 MS Excel Lesson 3 AND Function |ST 1| ST2|ST3|✅✔
  6. W3 MS Excel Lesson 4 OR Function |ST 1| ST2|ST3|✅✔
  7. W3 MS Excel Lesson 5 NOT Function |ST 1| ST2|ST3|✅✔
  8. W3 Microsoft Excel - Data Management |ST 1| ST2|ST3|  - sub | 3F | 3G |✅✔
  9. Add The Michelangelo of Microsoft Excel✅✔
  10. Add Make Data Fun Again: Data Visualization using Excel✅✔
Week 4
  1. W4 Excel - Lecture ✅✔
Week 5 

Adjusted Trial Balance & Automated Financial Statement - Video✅✔
Ratio analysis - Video✅✔
  1. W5 Lesson 5 Adjusted Trial Balance - submission | 3F | 3G |✅✔
  2. W5 Lesson 6 Automated Financial Statement - submission | 3F | 3G |✅✔
Week 6
  1. W6 Lesson 7 Debtors Ageing Report - submission | 3F | 3G | video |✅✔
  2. W6 Lesson 8 Inventory Valuation - submission | 3F | 3G | video |✅✔
Week 7
  1. W7 Lesson 9 Depreciation on Fixed Assets - submission | 3F | 3G | video |✅✔
  2. W7 Lesson 10 Cost Volume Profit Relationship - submission | 3F | 3G | video |✅✔
Week 8
  1. Discussion✅
  2. Intro UBS Accounting✅
Week 9 & 10
  1. W10 Creating a New Company Data File (Lesson 1-4 UBS Self Study)
  2. W10 Creating Chart of Accounts
  3. W10 Debtors and Creditors Subsidiary
  4. W10 Organising Batches
  5. W10 Entering Opening Balances 
Week 11-13
  1. W11-13 Entering Transactions
  2. W11-13 Editing Transactions
Week 13
  1. W14 Maintaining Stock Values and Producing Report
  2. Submission Exercise 3F | 3G
Week 14
  1. Lab Test Submission 3F | 3G


Tiada ulasan:

Catat Ulasan

Langgan: Catatan (Atom)