Classroom Management

IT04 Applied Spreadsheeting

This intensive and hands on course is aimed at the teacher whose spreadsheeting skills are at least at the intermediate level and who is seeking to use a spreadsheet to develop high quality and varied teaching/learning materials.

In addition to the functions and techniques mentioned in the course objectives and agenda, below, delegates should appreciate that activities and demonstrations will use a wide variety of other spreadsheet functionality. Hence potential delegates should note that this course is NOT suitable for the basic spreadsheet user.

Delegates will take away with them fully worked solutions to all exercises in fully formatted and documented spreadsheet files.

The 2008 dates and venues have yet to be finalised for this course. Please return to our Course Subjects page.

Objectives

By the end of this course, delegates will be able to
  • Appreciate the role that random numbers can play in the development of teaching/learning materials
  • Develop random number based and therefore unique teaching/learning materials: for example, unique numerical questions, flash card type exercises
  • Use such functions as SUMIF and COUNTIF to generate schedules and tables from lists and otherwise unformatted data sets
  • Apply PIVOT TABLE functionality to the solution of such problems as preparing a Trial Balance from a list of transactions
  • Develop templates for use in lessons: for example, forms and tables to be completed, financial accounting statements, tables of constants such as sine, cosine and tangent, compound interest factors, discount factors
  • Apply the spreadsheet to the solution of examination type questions and the generation of clones from them
  • Appreciate the rules of spreadsheet layout
  • Appreciate the need to document all spreadsheets
  • Use many keyboard short cuts

Who should attend

This course is aimed at the teacher who appreciates the role that spreadsheets can play in the development of teaching/learning materials and who will appreciate the opportunity of attending an intensive and interactive course to help them to achieve such an ambition.

Agenda

09.00 - 09.30
  • Arrival and registration
09.30 - 10.30 - Session 1:
  • Appreciate the role that random numbers can play in the development of teaching/learning materials
  • Develop random number based and therefore unique teaching/learning materials: for example, unique numerical questions, flash card type exercises
10.35 - 11.35 - Session 2:
  • Use such functions as SUMIF and COUNTIF to generate schedules and tables from lists and otherwise unformatted data sets
11.35 - 11.45
  • Coffee
11.45 - 12.15 - Session 3:
  • Apply PIVOT TABLE functionality to the solution of such problems as preparing a Trial Balance from a list of transactions
12.15 - 13.00
  • Lunch
13.00 - 13.45 - Session 4:
  • Develop templates for use in lessons: for example, forms and tables to be completed, financial accounting statements, tables of constants such as sine, cosine and tangent, compound interest factors, discount factors
13.45 - 15.00 - Session 5:
  • Apply the spreadsheet to the solution of examination type questions and the generation of clones from them
15.00 - 15.15
  • Any questions?
Throughout:
  • Appreciate the rules of spreadsheet layout
  • Appreciate the need to document all spreadsheets
  • Use many keyboard short cuts