STEP Skills Development and Competitions CONTEST AREA:
CONTEST PACKAGE Bookkeeping Using MS-Excel Program TIME ALLOTMENT
Entrepreneurship and Information and YEAR LEVEL: Third Year/ Fourth Year Communications Technology Integration
ASSESSMENT CRITERIA
Accuracy
PROCEDURE/SPECIFIC INSTRUCTIONS
PERCENTAGE
40%
a.
Contest registration of trainers and contestants.
b.
Submission of required documents for the contest.
c.
Ocular inspection of the contest venue
Briefing g of trainers and contestants with the contest administrator before the competition. e. Inspection and distribution of contest materials.
d.
3 hours DESCRIPTION
PRELIMINARY ACTIVITIES
Completeness
25%
DURING a. b.
Skill in bookkeeping or in simple accounting is essential to the business undertaking to be able to know if the business is gaining or making profit. The application of electronic spreadsheet in recording can ease the job of a bookkeeper or an accountant.
Presentation
Lay-out/Format
15%
10%
RESOURCES T O
T O O L S
*Financial Statements - 10-column worksheet -Balance Sheet -Income Statement c. Final instruction of trainers with their contestants (5 minutes). d. Inspect the contest materials and equipment. e. Printing of output shall not be counted within time allotment. f. Problems for business transactions shall be prepared by the judges.
E Q U I P M E N T
prohibited.
AFTER ILLUSTRATION
10%
Sample Business Transactions EMPLOYABILITY OR BUSINESS OPPORTUNITY
Preparation of Financial Statements is typical to any types of business establishments.
Outputs shall be evaluated by special set of judges.
b b.
All outputs shall be endorsed to the Secretariat by the Contest Administrator.
All endorsed outputs shall be displayed until the duration of the skills competition. d. Presentation should not exceed 5 minutes. c.
Bookkeeper or Accountant USE
a.
TOTAL
100%
NOTES
ATTACHMENT(S)
a.
Analytic Scoring Rubrics/ Percentage Table
With regard to the provision of resources, the division and regional organizers may opt to deviate.
b.
Coaches are not allowed to stay in the contest area while the contest is in progress.
FORM OF JUDGING Special Judges
Organizer/s a. Processor: Pentium IV or equivalent b. Application Software: MS Excel XP c. PC Accessories
a. complete computer system b. LCD projector
a. bond paper b. score sheet c. USB
g. Other instructions from coaches and contest administrator are
Time Management
Contestant/s
T
Briefing of trainers and contestant with the contest administrator (10 minutes). The contestant will work on an electronic 10-column worksheet. Hyperlink shall be applied: *2-column journal for adjusting entries
Number of Participants: 1
M A T E R I A L S
ANALYTIC PERFORMANCE SCORING RUBRICS FOR ELECTRONIC SPREADSHEET CRITERIA A. ACCURACY
40%
B. COMPLETENESS 25%
C. PRESENTATION 15%
D. LAY-OUT/ FORMAT
E. TIME MANAGEMENT
10%
10%
95 • Entries were properly and accurately recorded.
•
• Entries were recorded completely in an appropriate column and manner.
•
• Exhibited good voice projection, appropriate body language, correct grammar and punctuation.
•
• All parts of the 10column worksheet were sequentially arranged and indention on other parts was observed.
•
• Finished the output 10 minutes before the allotted time.
•
PERFORMANCE INDICATOR 90 85 Entries were properly • Entries were properly recorded but with 1-3 recorded but with 4-7 inaccurate data. inaccurate data. Entries were recorded • Entries were recorded completely but 1-3 completely but 4-6 entries were recorded in entries were recorded in an inappropriate column an inappropriate column and manner. and manner. Exhibited good voice • Exhibited fair voice projection, appropriate projection, fair body body language with one language with 3-5 or two incorrect incorrect grammar and grammar and punctuation. punctuation. All parts of the 10• Some parts of the 10column worksheet were column worksheet were sequentially arranged sequentially arranged but 1-2 indentions on but 3-5 indentions on some parts were not some parts were not observed. observed. Finished the output 5 • Finished the output minutes before the within the given time. allotted time.
80 • Entries were properly recorded but with 8-10 inaccurate data. • Only few entries were recorded and in an inappropriate column and manner. • Exhibited fair body language with more than 5 incorrect grammar and punctuation. • Most parts of the 10column worksheet were not sequentially arranged and indention on some parts was not observed. • Was not able to finish the output within the given time.
Sample Problems on Business Transactions The following is the unadjusted trial balance of P.D. trading on December 31, 2007, the end of the accounting period.
Cash Accounts Receivable Allowance for Bad Debts Notes Receivable Inventory, January 1 Furniture and Equipment Accumulated Depreciation Land Accounts Payable Notes Payable-bank debt in 2 years Mortgage Payable-due in 5 years P.D., Capital Sales Sales Returns and Allowance Purchases Freight In Salaries Rent Expense Insurance Other Operating Expenses Interest Expense Interest Income Total
P
10,000.00 40,000.00 P
400.00
12,000.00 22,000.00 25,000.00 10,000.00 115,000.00 60,000.00 20,000.00 50,000.00 99,000.00 360,000.00 11,000.00 280,000.00 6,200.00 36,000.00 24,000.00 4,800.00 12,000.00 1,800.00 P
600,000.00 P
600.00 600,000.00
Additional information for adjustments:
a. Estimated bad debts are 2 ½% of accounts receivable. b. A note receivable P8,000.00, 60-day 6% is dated Nov. 16, 2007. c. The furniture and equipment were acquired on Jan. 1, 2005 and are estimated to last two years from December 31, 2007. d. The note payable to bank is 15% note dated Sept. 1, 2007. e. Accrued interest on mortgage is P1,500.00. f. Accrued salaries 1,200.00. g. Prepaid rent P8,000.00 h. Unexpired insurance P600.00. i. Prepaid interest expense P300.00. j. Prepaid interest income P100.00. k. Inventory, December 31, 2007, P62,440.00.