Wednesday, March 20, 2013

Office for Administration - EXCEL

MS EXCEL

Excel is a spreadsheet programme which allows CALCULATIONS to be made. It is hugely useful for a variety of different applications in teaching, including the dreaded Mark Sheets which most teachers need to do at some stage or another.

However, that is not all Excel can be used for - here are a few other ideas for using them in the classroom:
Use the cells to design a SEATING PLAN of the kids in your class - and you can even use the REVIEW menu to add comments about what to look out for - "He talks too much" "She will burst into tears if you raise your Voice" etc.





Create a CLASS LIST. You can sort Alphabetically using the SORT tool - but don't forget to EXPAND THE SELECTION if you select only one column at the beginning






Draw Graphs or Charts to show data graphically. The Chart Icon allows you to turn your data into a chart. You can choose a variety of different types of graphs. You can even make PICTOGRAPHS

Make a MARK BOOK

You have detailed instructions on how to create a Mark Book. Some of the skills you will need to master are:

  • Renaming the Spreadsheet
  • Sorting class lists alphabetically
  • Orientating Headings
  • Calculating the SUM of a range of numbers
  • Calculating the AVERAGE of a range of numbers
  • Changing data
  • Saving and retrieving the markbook

Remember when you perform a calculation that there are some rules that you need to follow

eg

No comments:

Post a Comment