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: VBA
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”
add batch AutoCorrect entries
As explained here, AutoCorrect can be used to type in unformatted chemical formulae which then automatically add the correct subscripts and superscripts, or to type in an abbreviation which automatically expands to the long word or phrase. But it takes a long time to add each entry individually. The link below is to a fileContinue reading “add batch AutoCorrect entries”
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.
copy selected pages to new document
If you have a long document and want to copy part of it this is a quick way. There is a message box at the start requiring the page range to copy. These pages are then copied to a new document.