A blog about teaching and learning in a maths classroom.
Thursday, 24 January 2013 | 2 Comments
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.
The table below is an excerpt of my lesson plan spreadsheet.
|2||1||9_5.2_fractions_01_review-of-fractions||Y||9||Fractions||1||5.2||Review of fractions||Define. Identify parts of a fraction. Classify fractions. Fraction conversions.|
|3||2||9_5.2_fractions_02_fraction-conversions||Y||9||Fractions||2||5.2||Fraction conversions||Mixed numerals to improper fractions and vice versa. Simplifying. Determine reciprocals (extension of conversion).|
|4||3||9_5.2_fractions_03_equivalence-and-simplifying||Y||9||Fractions||3||5.2||Equivalence and simplifying||Equivalent fractions, simplifying fractions.|
Column B, the “Ref” column is generated automatically combining the year, stage, topic, topic no. and title of the lesson. Here is the Excel formula B2:
This creates a nice reference code (seen in B2 above) that can be used as a filename for a lesson plan and a folder name to store relevant resources.
(NB, after creating a lesson record, I could save the value of the generate code, rather than the formula.)
Here is an example file that will be easier than copying the formula.
Posted in • Admin • Software • Excel | Short URL: http://mths.co/2895
New Subscribe to the …MathsLinks
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→
updates via @mathslinks
The Salesman - by Greg Ashman - Filling The Pail
Peter Liljedahl wants to make kids think about mathematics
maths peterliljedahl gregashman
Mathcha - Online Math Editor
maths editor latex
Copy Paste MathJax
maths latex symbols
Crossover Workbooks | Sparx Maths
maths workbook practice exercise