MathsClass

A blog about teaching and learning in a maths classroom.

Archives → Excel

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.

Being too helpful?

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

Friday, 15 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

Monday, 30 November 2009 ·

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

Making a dice

Monday, 28 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.

Get updates

also via…

RSS Twitter Facebook

Google+ Feedly

About

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

Archive

by date

by category

Search

Elsewhere

@simonjob
updates via @mathslinks

maths bookmarks on Pinboard

My websites are hosted by DreamHost