- bar graph
- a roster
- line graph
- helps you with your busness infomation
- pie chart
- doughnut
- rader
-stock
- colume
- bubble
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- preasontations
-science- recording infomation
- socual studies- population
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 -
- collums
- Numbers down the side -
- rows
- Cell reference -
- each cell has a unique cell reference e.g d11
- Active cell -
- the cell that continues the value being used or moderfied in a spreadsheet program.
- formula -
- what it costs
- = -
- start with = then create the formula
- + -
- to add something ,use
- - -
- to subtract something, use
- * -
- to multiply something ,use
- / -
- to divide something,use.
4.
- Pick a topic to survey the class on e.g. favourite takeway, favourite tryp of animal, pets, tutor class, house, favourite TV program, sports played....
- Survey the class, and write your results on a piece of paper
- Open Microsoft Excel
- Make a table of your results in a new excel e.g. see the example below:
