-maths equations
-to create clear and concise reports
-shopping list
-contact list
-Charts and graphs
-pricing
-budget planning
-surveys
-scientific applications
-record student marks
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- to do equatoins and graphs.
Itec-to do work.
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-text labels
- Numbers down the side-row numbers
- Cell reference-a unique letter and number
- Active cell-ready to be used
- formula
- = -before the formula
- + -to add something
- - -to subtract something
- * to multiply somethi
- /-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 in the Spreadsheets folder in your T-drive (Excel1)
- Make sure you change the headings to bold / italics, put a border around your table, and change the background colour, just like the example picture.
- Make a column graph of your survey.
- Give it a title
- Label the axis
- Change the background to a different colour, or put a picture in