WELCOME TO THE COOL BEANS PROFILE

HI ITS AIDAN FROM GC AND IF U HATE GC GET OF MY BLOG U NOOB.

spreadsheets

Make a list of 10 different things that a spreadsheet like Microsoft excel could be used for
-bar graph
-roster
-line graph
-helps you with your must current bussiness information
-pie chart
-doughnut
-putting your information in
-radar
-column
-stock

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-graphs.
-science-when you are recording stuff down from like each day you can put like day one something something happened.
-social studies-population.

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
  • columns
  • 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 that is being used or moderfied in a spreadsheet
  • formula
  • what it = to
  • =
  • start with = then crate the formula
  • +
  • to add something, use
  • -
  • to subtract something, use
  • *
  • to mltiply something, use
  • /
  • to divide something, use

  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:
  5. Make sure you change the headings to bold / italics, put a border around your table, and change the backgof your survey. 
    1. Give it a title
    2. Label the round colour, just like the example picture. 
    3. Make a column graph axis
    4. Change the background to a different colour, or put a picture in
  6. See how many other graphs you can make of your survey data - make sure they all have titles, take away the legend if its not needed, and make them look good!