A blog about teaching and learning in a maths classroom.

Archives → Excel

Term 3 2010 SDD

Monday, 19 July 2010 · (0) Comments

Each year for the Term 3 SDD (Staff Development Day), the four schools (three 7-10 and one 11-12) in the collegiate I work in get together for a combined program.

Time - Self-checking Excel Resource

Friday, 11 June 2010 ·

This is a resource for skills in working with time.

Teaching Year 10 with Laptops

Sunday, 07 February 2010 ·

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 ·

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 ·

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

Making a dice

Sunday, 27 September 2009 ·

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 ·

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 ·

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 ·

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 ·

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 ·

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. 

Social Media Icons from IconDock.

The posts and comments I make on this blog are made in a private capacity and do not represent the official view of my employer.