a)Graphing
b)forms
c)data bases
d)spread sheets
e)pie charts
f)bar graphs
g)lists
h)pivot table
i)data sorting
j)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.
english-for tally charts about the classes likes and dislikes
maths-mathematical equations
social studies-pie charts on religions
science-listing combined chemicals and writing the new ones created
itec-learning how to use it
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 : colums
- Numbers down the side : rows
- Cell reference : each cell ahs a unique row and colum number eg: D11
- Active cell : a empty cell that is currently free and able to use
- formula : is what is used when a picture of file is added to an active cell
- = : the formula is started here
- + : you use this to add something to the formula using this
- - : use this to take somthing off the formula
- * : use this to multiply something
- / : use this to divide something
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:
