Archives → Excel
Teaching Year 10 with Laptops
(2) Comments | Posted in • Lesson Idea • Consumer Arithmetic • Congruence • Rates • Trigonometry • Software • Excel • GeoGebra • Technology • Digital Education Revolution • Laptops 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
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
| Posted in • Lesson Idea • Number Plane • Software • Excel • Technology • Digital Education Revolution • Laptops 4 Learning • Website
A lesson for Year 9 students with DER laptops, or anyone really.
Making a dice
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
| Posted in • Resource • Software • Excel • GeoGebra • Google Earth • Google Sketchup • Technology • Digital Education Revolution • Laptops 4 Learning • 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
| Posted in • Game • Lesson Idea • Probability • Software • Excel • Technology • IWB • Projector 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
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
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
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.
