Spreadsheets - Countif
Suitable mainly for KS3 to teach how to use the COUNTIF function in Excel. Lesson contains a guidance sheet on how to perform COUNTIFs, Spreadsheet models to practice performing COUNTIFs (Dancefloor & Football stadium). Differentiated version which does not involve using COUNTIF - just requires basic formulas instead. Slides to demonstrate and guide students through tasks with Starter and Plenary etc. - Cells on football stadium model have 'A's and 'C's hidden in them to count up. Can be changed for any football team. Approx. 1 lesson's worth of work.
$3.86
Save for later
  • 1._Countif.doc
  • County-Ground.xls
  • County_Ground_(D).xls
  • Dance_Floor.xls
  • Extension.doc
  • Slides.ppt

About this resource

Info

Created: Dec 12, 2016

Updated: May 4, 2017

Worksheet

doc, 335 KB

1._Countif

Activity

xls, 75 KB

County-Ground

Activity

xls, 110 KB

County_Ground_(D)

Report a problem

Tes Paid Licence

How can I re-use this?