KOS 1110..(Computer in Science)

This course focuses on the uses of symbolic computation language to calculate,visualize,analyse, and simulate scientific information.
The students will also be introduced to the uses of web pages to present and communicate scientific data,building and visualizing bio-molecules
proper tags,molecular structure storage formats,database and retrieving structures from internet..

Today i learn about spreadsheets..
Before spreadsheets emerged,solving equations in science applications/problems involved learning complicated mathematical procedures.
So,it spend a lot of time trying to understand the procedure but not solving the problem.it waste of our time.Spreadsheets helps to spend up solving the problem.
Example of spreadsheets are MS Excel,LOtus 1-2-3,SPSS Quattro Pro,etc..

Our lecturer give us tutorial about Microsoft Excel..At the beginning,it was very diificult to do the tutorial because we do not understand aboaut the question.
So,we ask our beloved lecturer..she explain step by step how to do it..It make us easy to understand what to do during the claas..thanks madam..
Example of the question:

Beer's Law states that there is a linear relationship between concentration of a colored compound in solution and the light absorption of the solution.
This fact can be used to calculate the concentration of unknown solutions, given their absorption readings. First, a series of solutions of known concentration are tested for their absorption level.
Next, a scatter plot is made of this empirical data and a linear regression line is fitted to the data. This regression line can be expressed as a formula and used to calculate the concentration of unknown solutions.

Part 1 - Beer's Law Scatter Plot and Linear Regression
Entering and Formatting the Data in Excel
Open Excel. On Unity/Eos computers, the program will be located on the Application Launcher. On other computers, it will probably be located under the Start Menu.
Your data will go in the first two columns in the spreadsheet.
• Title the spreadsheet page in cell A1
• Label Column A as the concentration of the known solutions in cell A3.
• Label Column B as the absorption readings for each of the solutions in cell B3.
Begin by formatting the spreadsheet cells so the appropriate number of decimal :
• Click and drag over the range of cells that will hold the concentration data (A5 through A10 for the sample data)
• Choose Format > Cells... (this is shorthand for choosing Cells... from the Format menu at the top of the Excel window)
• Click on the Number tab
• Under Category choose Number and set Decimal places to 5
• Click OK
• Repeat for the absorbance data column (B5 through B10 for the sample data), setting the decimal places to 4
• Enter your data below the column titles
• You can also place the absorption readings for the unknown solutions below the other data.

We do step by step follow the questions until get the best answer..

Stdying Excel help us carry out lengthy calculations easily with its built-in features:
1-Display data graphically
2-Analyze data statistically
3-Fits algebraic equations through data sets
4-Solve single and simultaneous algebraic equations
5-Import,export,store,process,and sort data.

Very interesting study MS Excel..Enjoy it..