Cert II Bus

 

main

back

Unit 8 BSBCMN214A Create and use simple spreadsheets 20 Hours

SECTION 8 CREATE & USE SIMPLE SPREADSHEETS

Your file needs to contain at least two pieces of evidence in each section to be deemed competent.

In these classes I use Worksheets and Web Quests as the main source, many worksheets can be used across several ICT lessons so in some instances the students may have already undertaken the work in Cert II IT or Cert II Bus or in ICT classes like AIT

Worksheets explain the elements of the topic with questions and test sections for students to answer

Web Quests cover topics where students must find information on the Internet or in Resource material and answer all questions.

 

Unit Descriptor This unit covers creating and using simple spreadsheets and charts through the use of spreadsheet software.

tasks

Lesson Worksheet Hours Tasks Hours Test or Solutions
WKS 100 Cover Page Set Up
1
     
MXL000 Excel Introduction
1
    MXL000 Excel Introduction
MXL100 Excel Intro
1
In Class Test   MXL100 Excel Exam S
MXL001 Excel Enter text Gnomes
1
    MXL001 Excel Enter text Gnomes S
MXL002 Excel Text & Merge Sports
1
    MXL003 Excel Exersize 03 surname
MXL005 Excel Absolute Cells
1
     
MXL016 Excel Test 1 Country Club
1
    MXL016 Excel Test 1 Country Club S
C2B803 Productivity Q
1
C2B803 Ans (Spreadsheet)
3
C2B803 Productivity S
MXL118 Excel Vlookup Silly Story
1
 
1
 
MXL013 Excel CountIf
1
 
MXL013 Excel CountIf S
MXL007 Excel Bikeshop IF Sales
1
 
MXL007 Excel Bikeshop IF Sales S
MXL008 Excel Payroll
1
 
MXL008 Excel Payroll S
MXL117 Budget Intro
1
In Class Tutorial
MXL117 Budget intro
MXL120 Excel Test Budget
1
 
MXL120 Excel Budget Test S
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Page under Construction
 
 
 
 
 
 
 
 
 
 
 
 
 
     
 

Note: Each class starts a new lesson each day, any unfinished work must be completed during recess, lunch-time or as homework. Time period for marking is two (2) weeks

 

units

Unit

Number

Certificate II in Business Title

Study Time

1

BSBCMN201A

Work effectively in a business environment

20

2

BSBCMN202A

Organize and complete daily work activities

15

3

BSBCMN203A

Communicate in the workplace

30

4

BSBCMN204A

Work effectively with others

20

5

BSBCMN205A

Use business technology

30

6

BSBCMN211A

Participate in workplace safety procedures

15

7

BSBCMN213A

Produce simple word processed documents

40

8

BSBCMN214A

Create and use simple spreadsheets

20

9

BSBCMN108A

Develop keyboard skills

40

10

BSBCMN107A

Operate a Personal Computer

20

11

ICAITU013C

Integrate Commercial computer packages

30

12

ICAITU012C

Design Organizational Documents using computer

50

 

Tutorials

 

Pens
access
audacity
Dreamweaver
Excel
Fireworks
Flash
Illustrator
InDesign
Inspiration
Pages
Paintshop
Photoshop
PowerPoint
Tech
Word

 

email

Email Peter Faulks

clown

Page updated 6th May 2014