This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 1 EXCEL WORKSHOP (Review for 14CL) (A "Computer Lab" period for Chemistry 14BL & 20L) TO: Chemistry 14CL students: The following tutorial outlines the procedures for plotting titration data for monoprotic acetic acid so that an equivalence points can be precisely determined through both an expanded titration curve of the equivalence point region and the first derivative of this region. The final section describes how to put data from an acid titration and a base titration of a solution originating in a buffer region of the compound. Refer to the posted VOH guidelines for more information on how to do this for the diprotic acid you are using and what graphs need to be submitted with the group report. EXCEL is a very popular spreadsheet software program that allows the user to perform many kinds of statistical analyses of the data. It can also perform a variety of mathematical calculations. In addition, EXCEL can also plot data in a variety of formats. During the workshop, each of you will have a chance to practice preparing titration curve graphs from data. The goal of the workshop is to familiarize you with the EXCEL software so that you can use it to write your reports (not just in chemistry!) in the near future. If you have time to work on your own data, which you collected last week, be sure to save your work on a floppy disk so you can use it later. You will work in groups of TWO (THREE if needed ) in the computer lab. Before you can use the software, you need to open it. Go to “ START ” (located at the bottom left corner of the screen) and select “ PROGRAMS ”. Click on “ Microsoft EXCEL ”. NOTE: There is NO NEED to save any files based on the data in this handout that you will work on during the workshop period. If you do decide to save files, you will need to save them on a high-density 3.5” disk. There are, in general, three different steps when working with EXCEL . Data entry, data analysis, and graphing. Step (I) Data Entry – Enter the raw data ( found on page 5) for the titration of 1.0M acetic acid with 0.5M NaOH. Follow the instructions below to enter the data. On the spreadsheet, notice that the columns in EXCEL are labeled as A, B, C … etc. The rows of the spreadsheet are labeled as 1, 2,3 …etc. Each cell (i.e. a rectangular box) is defined by the location of the row and column in EXCEL . For example, the very first cell located on the upper left corner has an address of A1 in EXCEL . Before you start entering the data, you may want to increase the width of the columns. For example, if you want to increase the width of column A, point the cursor to the letter A and click on the left button of the mouse. The entire column A should now be highlighted. Go to the menu bar and click on “ FORMAT ”. Select “ COLUMN ” and then select “ WIDTH ”. A dialog box will appear. Type in a number that is greater than the original number shown to increase the width of the column. To decrease the width of the column, type in a smaller number. You can always go back and increase the column width anytime even after you enter the data. always go back and increase the column width anytime even after you enter the data....
View Full Document
- Fall '09
- Valence, data entry, Equivalence point