Archives → Excel

Teaching Year 10 with Laptops

Sunday, 07 February 2010
(2) Comments | Posted in • Lesson IdeaConsumer ArithmeticCongruenceRatesTrigonometrySoftwareExcelGeoGebraTechnologyDigital Education RevolutionLaptops 4 Learning

In 2009, Year 9 got their DER netbooks and now they are in Year 10. This year’s Year 9 does not have their netbooks yet, and so this gives teachers a little time to get their heads around the inclusion of netbooks into the classroom. This year, I’m teaching a 5.2 pathway Year 10 class (and a Year 9 5.2 class).

Make a roll book

Thursday, 07 January 2010
| Posted in • AdminHow toSoftwareExcel

Teacher’s all have their own way of keeping track of student attendance, and other aspects that are recorded in class. Here’s mine, it might give you some ideas.

Drawing in Excel

Monday, 30 November 2009
| Posted in • Lesson IdeaNumber PlaneSoftwareExcelTechnologyDigital Education RevolutionLaptops 4 LearningWebsite

A lesson for Year 9 students with DER laptops, or anyone really.

Making a dice

Sunday, 27 September 2009
| Posted in • How toSoftwareExcel

In my IST class, we’re studying Modeling and Simulation, and started to make a model of a dice using Excel.

Thinking about it, the technique involved in making this would also be of interest to Maths teachers.

Curriculum Support for DER

Monday, 20 July 2009
| Posted in • ResourceSoftwareExcelGeoGebraGoogle EarthGoogle SketchupTechnologyDigital Education RevolutionLaptops 4 LearningWebsite

Screenshot of Curriculum Support website

For NSW DET teachers, the Curriculum Support web-site has been updated with resources for the DER, i.e. the laptops being rolled out to Year 9 students.

Dice

Friday, 05 June 2009
| Posted in • GameLesson IdeaProbabilitySoftwareExcelTechnologyIWBProjector Resource

I wanted to play a multiplication bingo type game with a class the other day, so I grabbed two 10 sided dice (apparently you don’t need to call a single dice a “die” anymore) out of the cupboard. Then I thought… hey I have a projector and a laptop.

Temperature Conversion Graph

Saturday, 10 January 2009
| Posted in • Lesson IdeaGraphsPrintableSoftwareExcel

As I was putting together a lesson on using conversion graphs, I couldn’t find a nice temperature conversion graph - so I created one.

Generating random questions in Excel - Basic operations

Sunday, 11 March 2007
| Posted in • How toSoftwareExcel

In this second post about using Excel to generate random questions, the first showed how to make a question about money, I show the simple formulae used to generate questions using the 4 basic operations.

Generating random questions in Excel - Money

Saturday, 10 February 2007
| Posted in • How toSoftwareExcel

Excel, part of Microsoft Office, is great for working with numbers.  For a maths class, Excel can be used for standard applications like working with tables of data and creating graphs.  Other teaching and learning applications that I’ve seen include creating self-marking computer based worksheets, interactive worksheets using sliders and even randomly generating questions for paper worksheets.