home

information

courses

notes

news

links

contact

Exercises Office: figures and charts
 
profits an introduction to using spreadsheets with simple calculations and the opportunity to do some graphs and charts
reviews an exercise which can be tried in both a table or a spreadsheet: useful as a comparison of the two perhaps. Useful opportunites to learn more about fonts and getting a display of data right
exams entering information on a sheet, calculations and amendments plus production of some graphs
staff list entering information on a sheet, calculations and amendments plus production of some graphs
cars performing several search and print tasks using a large Excel database. You will need the data too.
the tea club producing a simple income and expenditure sheet with calculations of monthly balances, some more difficult calculations and some charts too
Formation accounts a more advanced task involving the production of account statements for a number of customers. You will need the data for this one, and the notepaper.
course report This is a very simple introduction to transferring spreadsheet and database information to a text document and also to the production of straightforward charts.
Six months' gardening A miniature IBTII set of tasks. Rather than spending all your time entering text or data, this exercise gets you to do many of the types of job you will have to do in a real assignment in one session.
football league table Quite a challenging exercise which you can take as far as your skills allow. You may well return to it again at the Advanced level. There's a sample answer here to help.
   
   
page updated 18 February, 2007