# MathsClass

A blog about teaching and learning in a maths classroom.

## Archives → Excel

### Excel for Mathematics General

Saturday, 29 August 2015 ·

The Mathematics General (Stage 6, Years 11 and 12) syllabus in NSW includes numerous content points, considerations and suggest applications involving spreadsheets. But, I suspect, many teachers are not using spreadsheets in their lessons mainly because you get through the course without using them. Yet using a spreadsheet to complete some of the mathematical heavy lifting, can allow for the use of real-life data and the investigation of scenarios.

### Pythagorean Dates

Tuesday, 18 August 2015 ·

Monday (17/08/15) was a Pythagorean Day (172 = 82 + 152).

### Relative Frequency - Investigation

Thursday, 23 April 2015 ·

Probability is one of those topics where it's best to "see it".

### Rounding Using Significant Figures - MathsFaculty

Sunday, 22 February 2015 ·

A resource I put together for practising rounding using significant figures.

### Self-checking Christmas Worksheet

Thursday, 04 December 2014 ·

Here's a self-checking, simple questions, as you get the answers correct the tree lights up.

Nothing fancy. Just needed something for a computer lab tomorrow.

### MathsClass This Week 2 February 2013

Saturday, 02 February 2013 ·

### Organising Lessons

Thursday, 24 January 2013 ·

Back in 2011 I wrote:

Some things I do… Keep a list of my lessons in Excel. Each lesson has a Topic, Title and Description – and I get Excel to make a “code” to identify that lesson.
To a new teacher…

Here is how I get Excel to create a lesson code.

### Consumer Arithmetic - Spending - Electronic Worksheets

Monday, 17 December 2012 ·

This is part 2 of my electronic worksheets for Consumer Arithmetic. Part 2 focuses on Spending Money, in particular: profit and loss, discounts, purchasing, best buys and buying on terms (hire purchase). (Part 1 focused on earning money)

### Consumer Arithmetic - Electronic Worksheets

Saturday, 03 November 2012 ·

Through the start of this term, I’ve been creating a series of electronic worksheets (in Excel) to cover the ‘earning money’ part of a Consumer Arithmetic topic.

Saturday, 25 August 2012 ·

As I said in an earlier post...

2012 is looking like a year of quiet reflection (i.e. maybe not much on this blog), contemplation and trial and error.

Here is some recent thinking, please comment.

### Code Breaking

Saturday, 05 May 2012 ·

I recently received an email from the AAMT:

National Mathematics Day is Friday 18 May and looks at codes and code-breaking — to celebrate the centenary of the birth of Alan Turing.

### Smartie Statistics

Thursday, 08 September 2011 ·

Looking around, there are lots of activities for collecting and analysing data using small boxes of Smarties. Here is my version.

### Making a self-checking worksheet in Excel

Thursday, 14 July 2011 ·

I’ve had interest in how I make self-checking worksheets using Excel.

### Substitution Spider

Thursday, 21 April 2011 ·

Having made a Tables Spider this other day, I realised that I made myself a template for creating all sorts of “spiders”.

### Maths for SRN

Thursday, 21 April 2011 ·

With Stu Hasic’s Student Response Network (SRN) virtual clicker software installed on the 2011 DER laptops that NSW public school students in Year 9 receive this year, I wanted to try it out.

### Tables Spider

Monday, 18 April 2011 ·

In 2007, I wrote about a resource, a Number Spider, that I used as a lesson starter.

### Fun with Coordinate Geometry

Wednesday, 22 December 2010 ·

Tanya Duffy shared a great coordinate geometry activity on a private forum earlier in December.

### Term 3 2010 SDD

Monday, 19 July 2010 ·

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

Sunday, 29 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 ·

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.

New  Subscribe to the …

Simon Job — eleventh year of teaching maths in a public high school in Western Sydney, Australia.
MathsClass is about teaching and learning in a maths classroom. more→

@simonjob