Uses of different kinds Of Spreadsheets
Central college uses
• Central College Nottingham is a further education college.
• The college was first formed from Castle College Nottingham and also South Nottingham College West Bridgford.
• South Nottingham College was founded in 1971, West Bridgford. Castle College, Nottingham, was formed on 1 June 2006 it was first created and founded in 1847.
• Both of the colleges merged on 1 July 2011The college was renamed Central College Nottingham in November 2012
Types of data used
Data used
• Data is only stored once
• No record changes needed
• Simple to delete or modify
• Complex queries can be carried out
• Easier to change data
Tools and techniques
In spreadsheets it is easy to compare and calculate using simple tools and techniques, such as:
•Percentages
•Averages
•Math calculation
•Money calculations
•Engineering data
Spreadsheets are used to
• Makes calculation easier
• Easy to input cross sheet data
• Easy to understand and make corrections to.
Disadvantages of spreadsheets
• Individual spreadsheets installed in an office also enable individuals to hoard mass data.
• Individuals can also create their own forecasts without the need of working with colleagues.
• This can then lead to mass duplication of data.
• Sometimes the structure of the spreadsheet can increase computer storage requirements.
Purpose spreadsheets
Central college uses
• Central College Nottingham is a further education college.
• The college was first formed from Castle College Nottingham and also South Nottingham College West Bridgford.
• South Nottingham College was founded in 1971, West Bridgford. Castle College, Nottingham, was formed on 1 June 2006 it was first created and founded in 1847.
• Both of the colleges merged on 1 July 2011The college was renamed Central College Nottingham in November 2012
Types of data used
- To manage and merge, data mining to store attendance records and finance’s.To cross reference data using different types of functions to assist with calculations such as percentages and ratio’s.
- Financial data, class attendance data, overdue book’s data and anything else related to specific individual can be cross referenced
Data used
• Data is only stored once
• No record changes needed
• Simple to delete or modify
• Complex queries can be carried out
• Easier to change data
Tools and techniques
In spreadsheets it is easy to compare and calculate using simple tools and techniques, such as:
•Percentages
•Averages
•Math calculation
•Money calculations
•Engineering data
Spreadsheets are used to
- Enable people to work fast
- Is more accurate
- More productivity
- Easier to locate associated files by using the filter.
• Makes calculation easier
• Easy to input cross sheet data
• Easy to understand and make corrections to.
Disadvantages of spreadsheets
• Individual spreadsheets installed in an office also enable individuals to hoard mass data.
• Individuals can also create their own forecasts without the need of working with colleagues.
• This can then lead to mass duplication of data.
• Sometimes the structure of the spreadsheet can increase computer storage requirements.
Purpose spreadsheets
- To enable the college to work fast and effectively to process mass data about students and individual data at a fast speed.
- Different departments can access the same spreadsheets to amend and update them such as: Teachers, student loans, library staff.
- To identify individual students with an ID number and be able to trace an individuals college history