On 1/21/2011 12:45 PM, Michael Adams wrote:
There are actually two programs built in. Some of these questions seem to
relate to one (Calc) and other questions seem to relate to the other program
(Math).
On Friday 21 January 2011 01:11, FRANCES& MICHAEL wrote:
Hi there forum members!
I am a mathematics teacher. I am trying to construct a mathematics website
and I am trying to produce my own worksheets.
Worksheets are the domain of "Calc" which is the OpenOffice.org equivalent of
Microsoft Office Excel. There are differences.
I would like to use the Open Office Mathematics program for these tasks but,
unfortunately, I do not understand how to use it at all well. There are 3
initial questions that I would like to ask for someone's help with because I
cannot work the answers out for myself:
What does, for example, A9 mean?
A9 in a sheet is a refence to a cell. To explain it simply start
OpenOffice.org Calc:
1. Type "6" into cell B2 then tap the [Enter] key.
2. Type "3" into cell D4, [Enter].
3. In cell E2 type the formula "=B2+D4", [Enter].
4. In cell F2 type the legend "Cell B2 + Cell D4"
5. In cell E3 type the formula "=sum(b2,d4,e2)"
6. In cell E4 type the formula "=B2*D4"
7. In cell E5 type the formula "=B2/D4"
8. In cell E6 type the formula "=B2-D4"
9. In cell g2 type the formula "=e4*b2/7"
How do I create a power of a number?
"=B2^D4"
Math is a bit different. It is designed to show your formulas in standard
mathematical notation for printing. It does not do any calculations. So to
answer this question in the formula editor of Math "a sup b" would be written
in the bottom "Commands" window. After a second the layout would appear in
the top formula window. The example a and b i gave can be replaced with any
letter/s or number/s.
How do I create a fraction?
In Calc, format the cells as fractions. From the menu "Format - Cells...",
Numbers tab, Category, scroll down and select Fractions.
In math, in the Commands window type "a/b"
If anyone can help me, I would be most grateful. Michael Neillis
HTH
Addressing the format issue for Math not Calc, when
you enter "1/4" you get "1/4" in the output above.
When you input "1 over 4" you get and actual 1 above
a line above a 4.
A space can be input using `, while a larger space
is represented by ~
Both use the same key, next to 1 on the top of the
keyboard.
Hope this helps a little bit.
Tom
--
Quis custodiet ipsos custodes? -- Decimus Iunius Iuvenalis (Juvenal), Roman
Poet, late 1st, early 2nd century AD
("Who will protect us from the protectors?")
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
