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.

A | B | C | D | E | F | G | H | I | |
---|---|---|---|---|---|---|---|---|---|

1 | Record | Ref | Ready | Year | Topic | TopicNo | Stage | Title | Content |

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**:

=D2&IF(G2<>"","_"&G2,"")&"_"&LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(E2,"","-"),"'",""),",",""))&"_"&TEXT(F2,"00")&"_"&LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(H2,"'","")," ","-"),",",""),"/",""))

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.

Example for Organising Lessons
xls, 37 KB

This work is licensed under a Creative Commons License (?).

Posted in • Admin • Software • Excel | Short URL: http://mths.co/2895

New Subscribe to the …

MathsLinksemail newsletter

**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

updates via @mathslinks

Sydney University abandons HSC prerequisites in diversity push

mathsSeven ways to use diagnostic questions to check for understanding

maths bartonDeveloping a departmental approach to problem-solving

maths bartonDeveloping a departmental approach to reviewing answers

maths bartonDeveloping a departmental approach to worked examples

maths barton workedexamples examples

## Comments

author