Calculating Multiplication Tables!

Open: Programs / OpenOfficeOrg / Select the “Calc” program

Save as: MyCalculations.ods in your personal folder located in the LAB drive!!

Lesson: Understanding spreadsheets and simple calculating formulas.

Who uses Spreadsheets?

Accountants need to keep track of all of the money coming into the business and all of the payments going out. They also need to calculate the wages of all the staff each month.

Teachers can use spreadsheets to keep track of marks given for homework and recording exam results and also for registers.

Engineers need to perform thousands of calculations when designing bridges, buildings, aeroplanes, cars etc.

Sales people use spreadsheets to keep track of the items they sell, the value of the items, the profit made on each item and more importantly, the commission they have earned!

Scientists need to be able to keep track of their results from experiments.They use spreadsheets to help them to analyse what happened with the experiment and also to predict what might happen if they were to change one variable.

Supermarkets keep track of finances i.e. sales, losses and money spent.

Market researchers collect data from shoppers about their spending habits and their awareness of different brands.

Understanding the Spreadsheet and Formulas:

Spreadsheets: A tool used to assist in dta entry, recording, and manipulating data/calculations.

• A spreadsheet is like a huge table filled with data cells. It uses a series of vertical Columns and horizontal Rows.
• Each empty box is called a 'cell'.
• Each 'cell' is labeled using the Letter at the top of the table (the columns) and the number on the left side of the table (the rows).
• In the table below, the cell 'A6' has the number 5 in it.
• Cell labels ALWAYS use the Column Letter first, then the Row Number
  (F3, J8, etc.).

Formula: A series of characters that perform mathematical functions.

• In a spreadsheet calculation formula, * means to multiply, / means to divide
• Don't use any spaces in your formulas.
• Formulas always start with the symbol: =
• The box at the top left of your Menu Bar, directly above 'Column A' will also show the name of the cell, when you click inside of a cell.

 

You can continue creating your Multiplication Table, adding more
numbers in the top row, and filling in new formulas as needed to
complete a full Multiplication Table.

Want to do more?
You can do the same to creat a Division Table,
using / instead of * to divide the different cells.

Next week . . .

When done, resave your work
to your personal folder located in the LAB drive!!