Topic 6 (Administrative Software: Electronic Spreadsheets and Data Management.)

In my daily task as a lecturer, i used electronic spreadsheets to record manually the attendance and marks student. It is very useful and easy to used. With  electronic spreadsheets, we just need to enter table values manually. We can record data by identifying the row and column. 

Current versions of Excel and other spreadsheet programs can store multiple spreadsheet pages in a single computer file. 

The saved computer file is often referred to as a workbook and each page in the workbook is a separate worksheet.

According to Ben Joan, The main difference between electronic spreadsheets and database management systems is their complexity. The latter is way more complex than the former but adds features that are very useful, especially when you have a lot of data.

In database management systems, you need to create the individual databases and then establish the relationships of one to the other in order to maximize its features. You will also need to know a query language, a sort-of high level programming language that is used only with databases. But the complexity is only limited to setting it up. Once you, or someone capable of doing so, has set-up the database management system, just about anyone who knows how to use a computer can use it proficiently.

Summary:

• Database Management System is way more complex than an electronic spreadsheet
• Database Management Systems can create associations that cannot be made with electronic spreadsheets
• Database Management Systems can create custom views while electronics spreadsheets can’t
• Database Management Systems are more difficult to set-up than electronic spreadsheet

According to Kelly Anthony on January 29, 2014, The spreadsheet of the future:

• is intuitive and simple to use
• is powerful and flexible
• doesn’t require any training
• is online, so you can share and access it from anywhere
• helps you manage work more productively than ever before

Cite

by Ted French, https://www.thoughtco.com (Updated February 06, 2016)

Ben Joan. "Difference Between Electronic Spreadsheet and Database Management System." DifferenceBetween.net. April 21, 2012 < http://www.differencebetween.net/technology/software-technology/difference-between-electronic-spreadsheet-and-database-management-system/ >.

https://www.smartsheet.com/blog/best-online-spreadsheet