Spreadsheets

1. Make a list of 10 different things that a spreadsheet like Microsoft excel could be used for.

1. Maths calculations
2. graphs
3. collecting data
4. calculating data
5. shopping list
6. contact list
7. counting
8. charts
9. surveys
10. planning

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.

1. maths-mathematical calculations
2. science-listings
3. english-collecting data
4. technology-survey
5. social studies-graphs

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- used to indicate where you are up to  
• Numbers down the side- used to indicate where you are up to
• Cell reference- what the letter and the number equals e.g.G6  
• Active cell- blank cell
• formula- something used to calculate
• =  What a formula starts with
• +  This is used to add
• -   This is used to subtract
• *  This is used to multiply  
• /   This is used to dived  

4.

1. 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....
2. Survey the class, and write your results on a piece of paper
3. Open Microsoft Excel
4. Make a table of your results in a new excel e.g. see the example below: