---

Excel Microsoft Excel is a spreadsheet program which allows users to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis.

 

---

This 15 page document will introduce you to the basics in Excel to assist you in the teaching of Strand 1 - Statistics and Probability, namely in the Statistics Section. Some of the topics include: An Introduction to Excel, Drawing a Chart, Correlations, Scatter Plots, Sorting, filtering & freezing data, Random Number Generator, Pivot Tables, Drawing the Normal Curve, Drawing Tree Diagrams (Probability).

 

This 15 page document will introduce you to the basics in Excel to assist you in the teaching of Strand 1 - Statistics and Probability, namely in the Statistics Section. Some of the topics include: An Introduction to Excel, Drawing a Chart, Correlations, Scatter Plots, Sorting, filtering & freezing data, Random Number Generator, Pivot Tables, Drawing the Normal Curve, Drawing Tree Diagrams (Probability).

 

---

This Excel spreadsheet is to accompany, Teaching and Learning Plan 2 - Probability and Relative Frequency. There are two sheets in the workbook, an Instruction Sheet and the actual table sheet. (This spreadsheet was used in workshop 1)

master_table_9.xlsm
This Excel spreadsheet is to accompany, Teaching and Learning Plan 8 - An Introduction to Trigonometry. There are two sheets in the workbook, an Instruction Sheet and the actual table sheet. (This spreadsheet was used in workshop 2)

This spreadsheet was used in workshop 2 to demonstrate theorem 8.

 

---

This site is dedicated to teaching ICT at all levels. It contains excellent video tutorials on many ICT packages including Excel. Teachers will find lesson ideas and tons of free material.

 

Mircosofts's own site, offering help and support. It also contains many templates available for download. 

 

List of shortcut keys available in Excel.

 

By installing this Compatibility Pack if you already have Microsoft Office 2000, Office XP, or Office 2003, you will be able to open, edit, and save files using the file formats in newer versions of Word, Excel, and PowerPoint . The Compatibility Pack can also be used in conjunction with the Microsoft Office Word Viewer 2003, Excel Viewer 2003, and PowerPoint Viewer 2003 to view files saved in these new formats.

 

The resources on this Website fall into two categories. The first section is the ready made resources for use in the classroom. The second section is a tutorial to guide the user through the process of creating similar workbooks, and a set of tools to use in these workbooks.