week 11: CLear

A database is a collection of data used by users to access information. There are many types of databases such as operational, analytical, and external each used by different users. Operational database is used in organizations to support operations and increase efficiency. The security of databases is critical due to the vast amount of valuable information. There is software that manages the storage of the data.

Databases are a crucial component to businesses success. Once a organization has large amounts of data they must begin storing them in databases. To not do this would be detrimental to the success of the organization. Not just a database is needed but an easy to use and navigate one. Here is a link to the world's most popular open source database.

Excel Project

Our excel project consisted of manipulating data in regards to heart rate during exercise. The fisrt thing we did was manipulate the raw data and get new figures. The second part consisted of data analysis and using pivot tables. The actions we did gave us more information and elaborated on the data.

The project let me use the skills I learned in excel doing our last project. This project was very easy due to that and made it more enjoyable. I feel that I am now pretty well versed in excel and have never been this confident using it. Excel is a very useful program and I'm happy to be better at it now.

Here is a screenshot of one of the pivot tables:

week 9: Clear

Excel which is apart of the the Microsoft Office applications allows users to create spreadsheets easily and quickly. It is offered for both Microsoft Windows and Mac OS X and has been in use since 1987. Once an individual learns the basics it allows them to create spreadsheets and charts for various uses. There have been over 10 versions but not till version 5 did the application begin to be used widely.

Excel is an invaluble tool for all involved in business. It is by far easier to use than paper speadsheets and has almost wiped them out in their use. When being interviewed a common question is how good are you at using excel and to say effiecient is an upperhand. The lack of knowledge of excel could easily cause one to lose a potential job. Knowing the ins and outs of excel wll only be beneficial. This website posts tips for use such as shortcuts and graphics.

Excel on Mac OS X