Assignment 1
KOS 1110 Computers in Science
Assignment 1 - Questions in Excel
Due on or before Wednesday, 2-8-2006, 10am
1.What is a spreadsheet program? How does it differ from a word processing program?
2.What is the difference between a worksheet and a workbook?
3.How do you copy and move cell contents?
4.How do you use the fill handle to copy contents of cells and to create a sequence? What type of sequences can be created using the fill handle?
5.How do you create custom headers and footers?
6.What is a relative cell address reference? How do you change a relative reference to an absolute reference? What is a mixed cell address reference?
7.What is the formula bar? What is the name box?
8.What is the difference between erasing the contents of a column and deleting the column?
9.How will you freeze a part of the worksheet?
10.What is the maximum number of significant digits possible in MS Excel?
11.What is the difference between a bar chart and a histogram?
12.How will you put the error bars in the x-y plot? Make a table with data points along with their error values, and draw a graph with errors bars shown. (hint: See Help facility in Excel)
13.How will you protect a workbook in MS Excel?
14.How to protect only selected cells in MS Excel?
15.Explain the different forms of log functions available in MS Excel.
16.In MS Excel, the argument of the sin functions should be in radians.
Assume that you are provided with a set of angles in degrees. Use radians function in MS Excel to express the angles in radians and then find out the sin of these functions.
17.Use of Help facilities in Excel: Go through the Help facilities in Excel and study several different types of functions. Explain the application of three different uncommon functions using your own examples.
18.Calculation using Formulas: Select any formula (as complicated as possible) from any one of your textbooks. Use Excel to calculate this formula, by entering the constants and the variables separately. (For example:
i. Gas constant = � units
ii. Temperature = �. units
iii. Pressure = .. units
iv. Voulme = formula)
19.Multiplot: Write down any one formula with two constants (a and b) and one variable (x). (eg. y=a sin(bx) or y=a x + b log (x) �etc). You can also make up your own formula. Use Excel to calculate your chosen formula for a range of x values at five different sets of constant values and tabulate them as x vs y with x in the first column and y in the next four columns as follows:
No. y values calculated using different set of constants
a= �. b=� a= �. b=� a= �. b=� a= �. b=�
Plot all the four curves in the same plot and label them differently. Comment on the effect of the constants on these plots.
20. Solving Simultaneous Equations: Write a set of five equations with five variables (eq. p, q, r, s, t and u) and solve them using Excel. Verify your answer by back substitution.
21. Solver exercise: The following data set is obtained in an experiment:
R V
0.5 127.0355
1.0 48.0715
1.5 12.1348
2.0 8.3139
2.1 5.3366
2.2 3.1064
2.3 1.5361
2.4 0.5472
2.5 0.0689
2.6 0.0374
2.7 0.3957
2.8 1.0921
2.9 2.0807
3.0 3.3199
3.1 4.7728
3.2 10.0998
3.5 20.7786
4.0 31.9924
4.5 42.6319
5.0 52.1824
5.5 60.4667
6.0 67.4911
Use the solver module in Excel to fit the data using the equation
V=a(1-exp(-b(R-c)))2,
where a, b and c are constants to be determined. Use solver to determine these constants. Calculate the V values using the values of a, b and c that you had found out by excel. Plot the experimental and the calculated data in the same plot and label them properly. What is the value of V at R=1.25 and R=c?
22. Solve Van der Waals's equation: (P + a/V2)(V - b)=RT, for the volume per mole (V) of an organic compound at 10 atm pressure and 400oK. The Van der Waals's constants for this particular compound are a = 40.0 liter2 atm/mole2 and b = 0.2 liter/mole. (Hint: use Goal Seek)
23. Select any equation such as given in the above question, from any of your text books and solve it using goal seek.
24. Grades distribution: Consider a class consisting of 12 to 20 students. Create their mark list in their final exam. The list should contain their names and their marks in two columns. Use the nested �if condition� to determine their grades (eg. A, B �.) and list them in the third column. Present their grade distribution as a histogram and as a pie chart.
25. Computerization of the laboratory report: Present any of your experimental laboratory report involving detailed calculations and graphs, as an Excel workbook. Your report should be self-contained and contain all the details to verify your graphs and results. In short it should look as lab report that you would submit after completing your experiment.
26. Exercises done in the computer lab: Present a complete report of all the excel exercises done during the lab hours.
General instructions for exercises in Excel (Read these instructions carefully)
For maximum credits, use as many Excel options as possible. Fit all the information within the screen size. If it is more than a screen size use the next worksheet and name them creatively. All the worksheets should be self explanatory with appropriate tiles and explanations. In all the MS Word documents use the view and header/footer option to automatically include the name, date and time of the file while printing the documents. In all the worksheets use the page setup and header/footer option to automatically include the name, date and time of the file while printing the excel worksheets. Protect your workbooks (refer the last slide of my Excel presentation or Help in Excel) using the name of the file as the password. All the information except the information to be input by the users should be locked.
After you have completed each assignment put all the files (virus free) in a single folder, compress them using winzip and email ([email protected]) the final zipped file to me. All of your assignments should carry Assignment no, due date of the assignment, your name, matric card no, section no., degree program name, email address and the web page address of the assignment. The name of the final zipped file should have the form 1mohd.zip, where 1 refers to assignment number and mohd refers to your name. Send both the printed and the electronic versions of your assignments before the due date. Once you have built your home page you should publish your assignments in your home pages. For evaluation purposes, the date of submission of the printed version would be taken as the correct submission date. All of your assignments should have complete particulars (inside the files) such as the course name, assignment number, due date, submission date, your name, your degree program, student ID number, section number, your email address, home page address, instructors name, questions and answers. Any form of copying is completely prohibited.
Each assignment will be graded using the following scheme:
Submission on or before the due date 2 marks (ZERO marks for late submission)
Follow the instructions as above 2 marks
Answer all the questions 2 marks
Originality, creativity and critical analysis 4 marks
Total 10 marks
