graphs
pie charts
lists
formulas
calculation
pivot tables
software design
database communication and control
data sorting
number simulation
2. Describe which different subjects in school you might need to use a spreadsheet for, and what you would use it for in that subject.
Maths- graphs for data analysis
Science-pie chart and dot plot for amount of H2O or Oxygen in the air
English-for tally charts on who likes what.
social studies-pie chart for the population or race in our class or year level
Itech- learning how to use microsoft excel
3. Open the powerpoint file called 'SS_Features'
You will find it: T-Drive - Technology - 9iTEc - Spreadsheets
Watch the powerpoint, and explain what each of the following things are on the spreadsheet:
- Letters at the top:columns (letters)
- Numbers down the side: rows (numbers)
- Cell reference: all cells have a cell reference that consits of the row number and column e.g e12
- Active cell: an empty cell that has no formula or graph in it
- formula:a formula is what is used to calculate or add some thing to a empty graph when you enter it in a active cell
- = : this is where a formulas start
- + : to add something in to the formula
- - :to subtract somthing
- * : to multiply somthing
- / : to divid somthing
