Popular Posts

spreadsheets

1. Make a list of 10 different things that a spreadsheet like Microsoft excel could be used for.
-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. 
  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 in the Spreadsheets folder in your T-drive (Excel1)
  5. 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. 
  6. Make a column graph of your survey. 
    1. Give it a title
    2. Label the axis
    3. Change the background to a different colour, or put a picture in