Generating graphs in XHTML5 + SVG from spreadsheets
I have a regular need to quickly draft up quizzes which include xy scatter graphs. Due to bandwidth issues, I prefer to use XHTML5 + SVG to create a single file that includes the charts. An upside to this approach is that I can easily edit old code to create new quiz questions for future use. To facilitate this process I use an OpenOffice.org Calc spreadsheet to generate the initial code. Then I copy and paste the generated code to NotePad++ to remove the tabs and perform final tweaking of the SVG. This approach works well for statistics quizzes, and for physical science quizzes which often also include MathML. Note that the physical science quizzes use a variant of the spreadsheet which includes a wider variety of data point symbols.