Classroom Management

IT01 Introduction to Spreadsheeting

This course is aimed at the teacher who needs to be able to use a spreadsheet but who lacks the confidence to press that first button on their keyboard.

This is an interactive day: following the introduction to each section, delegates will be given activities to work on to ensure they have grasped the materials.

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
  • Find their way around a spreadsheet: finding and naming the elements of the screen
  • Work confidently with cells and ranges
  • Format cells: numbers, text, alphanumeric
  • Program basic formula to help them to carry out a wide variety of calculations
  • Identify and use a spreadsheet's basic in built functions
  • Prepare graphs from various data sets
  • Make links between a spreadsheet and word processing and presentation software
  • Appreciate the basic 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 needs an updating or refresher course on the modern spreadsheet: teachers who recognise the need to use spreadsheets but who don't have the knowledge and confidence to do so.

Agenda

09.00 - 09.30 Arrival and registration
    09.30 - 11.30 - Session 1:
    • Find their way around a spreadsheet: finding and naming the elements of the screen
    • Work confidently with cells and ranges
    • Format cells: numbers, text, alphanumeric
    • Program basic formula to help them to carry out a wide variety of calculations
    11.30 - 11.45 Coffee
      11.45 - 12.30 - Session 2:
      • Identify and use a spreadsheet's basic in built functions
      12.30 - 13.15 Lunch
        13.15 - 15.00 - Session 3:
        • Prepare graphs from various data sets
        • Make links between a spreadsheet and word processing and presentation software
        15.00 - 15.15 Any questions?
          Throughout:
          • Appreciate the basic rules of spreadsheet layout
          • Appreciate the need to document all spreadsheets
          • Use many keyboard short cuts