Design Recommendations

The course to be tailored for the elearning design will be (BSBITU304A – Produce Spreadsheets) NTIS number.

This course is primarily concerned with covering the basics for creating and using spreadsheets using the Microsoft Excel program.  The course can run on a minimal budget allowing for use by TAFE and other institutions with limited funding.

The course will cover five units of competency:

  • Select and prepare resources
  • Plan spreadsheet design
  • Create spreadsheet
  • Produce simple charts
  • Finalise spreadsheets

This course was design to run with either an online delivery or in a classroom setting.  It is especially suited to the Flexible Learning Centres around the state that allow for self paced learning with the backup of a teacher if problems arise.  It is recommended that the course run online but a CDROM could be prepared with all the necessary data if desired.

Most students completing this topic will be in the process of gaining a Certificate II or Certificate III in Business Administration.  Most of the students completing the subject will have had some exposure to Excel spreadsheets already (workplace or during high school). It is not a prerequisite that students have experience with spreadsheets.

There are a number of learning theories applied in the design of this course.  Saying that, the primary learning theory utilised is “constructivist”.  From the storyboard you can see that each competency will build the users confidence and also give them “experience” to be confident to meet the challenge of preparing professional spreadsheets by competency number 5.  Constructivism can also be seen in the building of meaning from each competency.  Learners would need to ensure they complete the previous competency to “build” on their understanding.

A constructivist method was chosen as “focus on activities and environments rather than on learning objects. Knowledge is constructed by learners and not transmitted by an instructor.”  Wangpipatwong, T. University of Thailand

As well as constructivist ideals, the storyboard has also been influenced by the behaviourist learning theory.  This is the reason that most sections of the course include some sort of video or “howto” instructions.  Ultimately, the behavior to be duplicated is the creation of a professional spreadsheet. 

The objective of this course is to allow students to effectively learn by creating an environment that is self paced and structured without having to depend on a teacher for instruction.

It is recommended that this course use a mix of web based and possibly CD ROM based technologies.  The course uses videos, audio and electronic documents to deliver a self paced learning experience.  The technologies chosen allow the user to repeat and reuse any resources needed to allow for complete understanding before moving to the next competency of the course.

Students will deliver their final spreadsheets to a digital drop box for marking by a particular date.

The actual training package guide can be viewed here.

The storyboard for the course can be seen on its own page here.


Leave a Reply

Your email address will not be published. Required fields are marked *