当前位置 > 首页 > 教学管理 > 专科教育 > 正文
Stage 1 OSP125 Technology 2 Offshore Unit Outline
日期: 2013-08-19 15:49:14  点击:[]

Course Code: FNS40611

Course Name: Certificate IV in Accounting

Unit Name: OSP125B Technology 2

Faculty of Business and Finance, Off Shore Diploma Program

Updated July 2013

UNIT OUTLINE

Group:          Stage 1          Teacher:
Course Dates:      Semester 2, 2013  Duration: 50 hours of duration

Unit Objectives:

Produce Spreadsheets

This unit describes the performance outcomes, skills and knowledge required to develop spreadsheets through the use of spreadsheet software.

You will gain skills and knowledge in the following areas:

  1. Select and prepare resources

  1. Plan spreadsheet design

  1. Create spreadsheet

  1. Produce simple charts

  1. Finalise spreadsheets

Develop and Use Complex Spreadsheets

This unit describes the performance outcomes, skills and knowledge required to use spreadsheet software to complete business tasks and to produce complex documents. You will gain skills and knowledge in the following areas:

Prepare to develop spreadsheets

Develop a linked spreadsheet solution

Automate and standardise spreadsheet operation

Use spreadsheets

Represent numerical data in graphic form

Resources:      

  • Pazmandy, G. Develop and Use Complex Spreadsheets

Tekniks Publications Pty Ltd

  • USB with student’s name clearly written on it.


Table of Assessment

Lesson Number

Text Book Chapter Number

Exercise Number

Result

1

10

Question 9 (Page 349)

PX or N

2

11

Exercise 3a (Page 378)

PX or N

3

12

Exercise 1(Page 418)

PX or N

4

13

Exercises 1 and 5(Pages 472, 479, 480)

PX or N

5

14

Exercises 2 and 5(Page 511, 514)

PX or N

6

15

Exercise1(Pages 545, 546)

PX or N

7

16

Exercises 4 and 6(Pages 566, 568)

PX or N

8

17

Exercise 2(Page 614)

PX or N

9

18

Exercise 9(Page 667)

PX or N

10

19

Exercise 4(Page 697)

PX or N

11

20

Exercise 3(Page 726)

PX or N

12

21

Exercise 1(Page 754)

PX or N

13

22

Exercise 1(Page 778, 779)

PX or N

14

23

Exercises 2 and 6(Pages 803, 805, 806)

PX or N

Total Assessment  

PX or N

Assessment

You are required to maintain a portfolio of your completed work on your own USB. See

Assessment Portfolio Requirements and instructions below. Holmesglen Institute will not run a final examination in this subject however the Portfolio will be checked by Holmesglen throughout the semester.

Students will be will be graded PX (Pass) or N (Fail or not yet competent) for the subject.

Results:

PX= Pass (no higher grade available)

N = Fail (not yet competent)

Student responsibilities:

·  Use only English in classes as this course is delivered and assessed entirely in English.

·  Attend a minimum of 80% of classes.  Assessments may not be allowed if attendance is below 80%.

·  For successful completion of this unit, ALL portfolio requirements must be completed and saved on your USB.

·  You will be expected to study outside of class for this unit.

·  Participate in all class and homework activities.

·  Be on time for all classes.

Teacher responsibilities:

  • Only English should be used in teaching this subject, as this course is delivered and assessed entirely in English.

  • The content of the attached semester planner must be followed closely in the delivery of this subject as all assessment will be based on this content.

  • To sign off Assessment Portfolio Checklist for each student when he/she has successfully competed each portfolio requirement.


Semester Planner – semester beginning September 2013

LESSON

TOPIC

Comments

HOMEWORK

Lessons 1 – 6 Use Chapters 8 – 13 in Pazmandy, G. Produce Spreadsheets

       1.        

Chapter 10:
Introduction to Microsoft Excel

Work through Chapter and compete all exercises before you do portfolio exercises.

Complete the following portfolio questions:

Complete Chapter 10 - Question 9 (Page 349) – Save as Share Portfolio.xlsx to your USB

Complete exercises not finished in class

       2.        

Chapter 11:
Effective Spreadsheet Utilisation

Work through Chapter and compete all exercises before you do portfolio exercises.

Complete the following portfolio questions:

Compete Chapter 11 - Exercise 3a (Page 378) – Save as McPappas.xlsx to your USB

Complete exercises not finished in class

       3.        

Chapter 12:
Spreadsheet Presentation

Work through Chapter and compete all exercises before you do portfolio exercises.

Complete the following portfolio questions:

Compete Chapter 12 - Exercise 1

(Page 418) – Save as Elwood.xlsx to your USB

Complete exercises not finished in class

       4.        

Chapter 13:
Spreadsheet Productivity Tools

Work through Chapter and compete all exercises before you do portfolio exercises.

Complete the following portfolio questions:

Compete Chapter 13 - Exercises 1, 5

(Pages 472, 479, 480)– Save as Emperor’s new clothes.xlsx and Rick’s Payroll.xlsx to your USB

Complete exercises not finished in class

       5.        

Chapter 14:
Analytical Charts and Graphics

Work through Chapter and compete all exercises before you do portfolio exercises.

Complete the following portfolio questions:

Compete Chapter 14 - Exercises 2, 5

(Page 511, 514) - Save as Costa.xlsx

Vatsala Deora.xlsx to your USB

Complete exercises not finished in class

       6.        

Chapter 15:
Incorporating Spreadsheet Data in a Word Document

Work through Chapter and compete all exercises before you do portfolio exercises.

Complete the following portfolio questions:

Compete Chapter 15 - Exercise1

(Pages 545, 546) - Save as Letter to Downs.docx

Downs share portfolio.xlsx to your USB

Complete exercises not finished in class


LESSON

TOPIC

Comments

HOMEWORK

Lessons 7 – 15 Use Text: Pazmandy G. Develop and Use Complex Spreadsheets.

       7.        

Chapter 16:
Date Functions

Work through Chapter and compete all exercises before you do portfolio exercises.

Complete the following portfolio questions:

Compete Chapter 16 Exercises 4 & 6

(Pages 566, 568) - Save as Duck and Banks.xlsx and

MKPG accounting.xlsx to your USB

Complete exercises not finished in class

       8.        

Chapter 17:  
Statistical Analysis and Forecasting

Work through Chapter and compete all exercises before you do portfolio exercises.

Complete the following portfolio questions:

Compete Chapter 17 Exercise 2

(Page 614)- Save asWentworth.xlsx to your USB

Complete exercises not finished in class

       9.        

Chapter 18:
Financial Functions
(Pages 622 to 667)

Work through Chapter and compete all exercises before you do portfolio exercises.

Complete the following portfolio questions:

Compete Chapter 18 Exercise 9

(Page 667)- Save asGrad.xlsx to your USB

Complete exercises not finished in class

     10.      

Chapter 19:
Logical Functions

Work through Chapter and compete all exercises before you do portfolio exercises.

Complete the following portfolio questions:

Compete Chapter 19 Exercise 9

(Page 697) - Save asAnxbank.xlsx to your USB

Complete exercises not finished in class

     11.      

Chapter 20:
Lookup Tables

Work through Chapter and compete all exercises before you do portfolio exercises.

Complete the following portfolio questions:

Compete Chapter 20 Exercise 3

(Page 726)- Save asTeacher.xlsx to your USB

Complete exercises not finished in class

     12.      

Chapter 21:
Goal Seeking and Solver Optimisation Modelling

Work through Chapter and compete all exercises before you do portfolio exercises.

Complete the following portfolio questions:

Compete Chapter 21 Exercise 1

(Page 754)- Save asAFL.xlsx to your USB

Complete exercises not finished in class


LESSON

TOPIC

Comments

HOMEWORK

     13.      

Chapter 22:
Database Operations and Pivot Tables

Work through Chapter and compete all exercises before you do portfolio exercises.

Complete the following portfolio questions:

Compete Chapter 22 Exercise 1

(Page 778, 779)- Save asBBB.xlsx to your USB

Complete exercises not finished in class

     14.      

Chapter 23:
Spreadsheet Macros

Work through Chapter and compete all exercises before you do portfolio exercises.

Complete the following portfolio questions:

Compete Chapter 23 Exercise 2, 6

(Page 803, 805, 806)- Save asYour name.xlsx and Product List.xlsx to your USB

Complete exercises not finished in class

     15.      

Complete all exercises for your Portfolio.

Make sure your teacher signs them all off on your sheet.

Public Holidays:

Labour Day                  9 March 2009

Good Friday                 10 April 2009

Easter Monay                13 April 2009

Queen’s Birthday             8 June 2009

Instructions for Completion of Assessment Portfolio Checklist

and USB

  1. The teacher will keep a copy of this checklist for each student in the class

  1. When each exercise is completed by a student the teacher will check that it is correct and sign and date the checklist. Exercised should be signed off throughout the semester, not on the last day of class.

  1. To pass the subject all exercises must be completed correctly by the student and signed off by the teacher. Teachers should see the student actually undertaking the exercise in class before signing off on it.

  1. Exercises that are to be completed for the student’s portfolio should not be set for homework. All other exercises in chapters may be completed for homework. This is to avoid students copying from each other out of class.

  1. All exercises are to be saved to the students’ USB. The teacher is to check this. If any exercise is missing from the USB the teacher cannot sign off on it.

  1. Each student must add his/her name to the spreadsheet exercise as shown in the instructions column of the checklist. If your name is missing or another student’s name is there, the teacher must not sign the exercise off as completed.

  1. Holmesglen teachers may check the student’s portfolio of work at any time during the semester by viewing the student’s USB.

  1. At the end of the semester all checklists and USBs must be provided to the Program Coordinator who will give them to Holmesglen Invigilators. USBs will be returned to the coordinator after being checked by Holmesglen invigilators.


OSP125B  Business Technology 2 - Assessment Portfolio Checklist

To pass this subject, all of the following exercises must be completed and saved onto your own USB. Your teacher and a Holmesglen Invigilator will view the exercises on your USB during the semester.

Name: ---------------------------------------------------        Pinyun------------------------------------        English--------------------

Lesson Number

Text Book Chapter Number

Exercise Number

Details/Instructions

Name of file to be saved on your USB as:

Date Question Completed

Teacher’s Signature to show that you have satisfactorily completed this exercise

Holmesglen Teacher’s Signature

For Lessons 1 – 6 Use Section 3 - Chapters 10 – 15 from the textbook ‘Business Computing’

1

10

Question 9

(Page 349)

Add your name in Cell C1

Share Portfolio.xlsx

2

11

Exercise 3a

(Page 378)

Add your name in Cell C1

Mcpappas.xlsx

3

12

Exercise 1

(Page 418)

Add your name in Cell C2

Elwood.xlsx

4

13

Exercises 1, 5

(Pages 472, 479, 480)

Add your name in Cell F2

Add your name in Cell A5

Emperor’s new clothes.xlsx

Rick’s Payroll.xlsx

5

14

Exercises 2, 5

(Page 511, 514)

Add your name in Cell A1 for each spreadsheet

Costa.xlsx

Vatsala Deora.xlsx

6

15

Exercise1

(Pages 545, 546)

Add your name in the footer

Add your name in Cell A1

Letter to Downs.docx

Downs share portfolio.xlsx


For Lessons 7 - 15 Use Section 3 - Chapters 16 - 23 from the textbook ‘Business Computing’

7

16

Exercises 4 & 6

(Pages 566, 568)

Add your name to cell A1 of each spreadsheet

Duck and Banks.xlsx

MKPG accounting.xlsx

8

17

Exercise 2

(Page 614)

Write the answer to each calculation on the spreadsheet. Add your name to cell A1

Wentworth.xlsx

9

18

Exercise 9

(Page 667)

Write the answer to each calculation on the spreadsheet. Add your name to cell A1

Grad.xlsx

10

19

Exercise 4

(Page 697)

Add your name to Cell A1

Anxbank.xlsx

11

20

Exercise 3

(Page 726)

Add your name to Cell A1

Teacher.xlsx

12

21

Exercise 1

(Page 754)

Add your name to Cell A1

AFL.xlsx

13

22

Exercise 1

(Page 778, 779)

Add your name to Cell A1

BBB.xlsx

14

23

Exercises 2, 6

(Pages 803, 805, 806)

Your name should be in cell A1

Yourname.xlsx

Product List.xlsx

15

Complete all the portfolio and keep it ready to be signed

Teacher Name: