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.
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)
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.
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.
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.
Looking around, there are lots of activities for collecting and analysing data using small boxes of Smarties. Here is my version.
I’ve had interest in how I make self-checking worksheets using Excel.
Having made a Tables Spider this other day, I realised that I made myself a template for creating all sorts of “spiders”.
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.
In 2007, I wrote about a resource, a Number Spider, that I used as a lesson starter.
Tanya Duffy shared a great coordinate geometry activity on a private forum earlier in December.
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.
This is a resource for skills in working with time.
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).
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.
A lesson for Year 9 students with DER laptops, or anyone really.
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.
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.
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.
As I was putting together a lesson on using conversion graphs, I couldn’t find a nice temperature conversion graph – so I created one.
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.
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.
Simon Job — eighth year of teaching maths in a public high school in Western Sydney, Australia.
MathsClass is about teaching and learning in a maths classroom. more→
maths bookmarks on Pinboard