Wednesday, 25 July 2012

Excel skills - to be ticked off the Google Doc

Please make sure you can demonstrate how to do the following when you come to see me to show me your Excel documents...

  1. Locate and use Microsoft Excel
  2. I.D columns, cells, and rows
  3. Enter labels and numbers
  4. I.D cell locations
  5. Add and/or delete cells and rows
  6. Create different graphs
  7. Add title and label axes
  8. Modify data
  9. Use a simple formula (add up the spending data in your table/spreadsheet)
  10. Import data between a column
  11. Hide columns
  12. Display data labels
  13. Adjust colour and size of bars in a graph

Make sure that your Excel doc exhibits this or that you can show me the 13 things when you come to visit me at my desk - so I can tick these off on the Google Doc.

Cheers
    Ms Fridd :) 

Wednesday, 18 July 2012

Excel tasks! Year 9 ICT


The following link is to your task for Excel (the one I will be looking over to see if you are confident using Microsoft Excel). 

Follow here for the link to the Excel task 

You will need to change the currency format from British Pounds to Dollars $$$ If you are unsure how to do this - please ask! 

Remember - All tasks you complete with spreadsheets should be saved and put into your ICT folder.

Your final task is the extension activity - and the one I will be sighting to tick off that you have a basic functional knowledge of operating Excel. 


That is 1. Create a table with data
             2. Create a graph from that data