Friday 5 October 2012

ICT - Spreadsheets

Objective : To introduce the spreadsheet application Excel to pupils

Began with general discussion about types of applications which the pupils had experience
  • Word Processing (Word)
  • Presentation (PowerPoint)
  • Browser (IE, Firefox, Chrome, Safari)
  • Email (Outlook, Hotmail)
Looked at MS Office and identified an unknown application  -- Excel

Opened the application - introduced terminology
  • Spreadsheet
  • Row
  • Column
  • Cell - naming of cells
  • Block
  • Data types
    • text
    • numbers
    • formula
Created a 'calculator' using the software

Demonstrated use of formula to make spreadsheet add numbers- pupils then extrapolated the formulae for subtraction, multiplication and division

Introduced division sign as forward slash (/) and division sign as a star (*)

Demonstrated sum function to add all results together


No comments:

Post a Comment

Previous days