Here at Southampton Exam Factory we do AQA at GCSE. The style of questions is that the marks for a question are at the end of the question, not the student’s answer, and the students write on solid lines: We take questions from other exam boards and modify them to make them fit our syllabus.Continue reading “change the format of a question to AQA-style”
Tag Archives: Macro
add powers to a maths equation no.2
The macro below will produce the powers in a maths equation by making the powers size 8 and raising them by 2 points. To do this, put a ‘z’ in front of anything you want to be a power. For anything that you want to be a subscript put a ‘q’ in front of itContinue reading “add powers to a maths equation no.2”
the Arrhenius equation
In the Arrhenius equation the activation energy has a subscript but is itself a superscript: The best way to write it in Arial font size 11 is to have the exponential factor raised by 2 points but the small ‘a’ in size 8 and raised by only 1 point. The first code below will writeContinue reading “the Arrhenius equation”
delete all headers and footers
Here at Southampton Exam Factory we have a lot of resources from an exam board for a now-defunct specification. The resources all have several footers and headers in gaudy textboxes with logos. Nobody cares now which section of the defunct syllabus the resources were created for. The macro below will remove them all with oneContinue reading “delete all headers and footers”
write the standard electrode potential sign
The quickest way to get the sign below is to have it as a macro and get it in three clicks: The Greek capital letter theta is changed to font size 8, superscripted and raised by three points, all of which takes more than three clicks if you don’t use the macro.
write a standard enthalpy change sign
My wife, Lana Rude, used to spend ages calling up a delta sign then fiddling about getting a standard sign by superscripting a o and scoring a line through it. So I wrote a macro which adds the standard enthalpy sign below: The r is lowered by 1 point and the standard sign is theContinue reading “write a standard enthalpy change sign”
write a sulfate ion with 2- above the 4
Use the macro below to write a sulfate ion like this: The font is Arial size 11, unlike the font produced by Equations using the method here. Put the macro on the Quick Access Toolbar then type 21 for the sulfate ion, 22 for nitrate and 23 for carbonate.
write E cell with a standard sign
The macro below will generate the symbol above.
write the symbol with mass number and atomic number
This macro will generate the symbol above in Arial font 11 rather than the Cambria Math (sic) italics which Equations produces. There is a message box asking for the atomic number (only from 1 to 20) and typing in 12 will return the symbol above.
find the ASCII code of any symbol
Select any symbol and run the macro below over it. This will give a message box containing the ASCII code of the symbol.
Chemistry Word VBA macros 