This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Chemistry Excel Microsoft 2007 This workshop is designed to show you several functionalities of Microsoft Excel 2007 and particularly how it applies to your chemistry course. In this workshop, you will be shown how to complete the following tasks: Formatting cells Creating and inserting functions Changing decimal places Creating a graph using non-contiguous columns Editing and manipulating a graph Changing data intervals Adding a trendline (line of best Ft) Analyzing a regression equation Changing the location of a graph ¡ormatting a lab report (adding textboxes) ConFguring Printing Options Experiment: The Half Life of S-35 We will go through an example exercise that is similar to the ‘Neutron Activation of Silver’ lab. For our example, Jack and Jill are performing an experiment with S-35, attempting to calculate its half life. Begin by navigating to the Scratch Drive, located on the desktop, and open the Excel fle entitled Chem Excel S35 . Copy the ‘Raw Activity’ from this document into a new Excel spreadsheet. Input the remainder of Jack and Jill’s data into your new spreadsheet, calculate the true activity and natural log of S-35, and determine what the half life should be. Brought to you by: In Association with: i Copying Columns: To copy information in a column, click and highlight all of the information you wish to copy. Once highlighted, right-click anywhere within that area and select Copy . Navigate to the document you want to paste this information to, right-click on the cell the frst piece oF data will start in, and select Paste . Alternatively, you can also use the shortcuts CTRL+C (copy) and CTRL+P (paste) in place of right-clicking. Formatting Cells: Manual Sizing: You can change the size of cells so that if you have data that is bigger than the cells, you can see all of the data. To do this, place your cursor between the blue column markers (labeled A, B, C, etc). When your cursor hovers between two columns, the default I-Beam will turn into a cross-like icon, with two arrows pointing in opposite directions. Click and hold; drag either way to increase or decrease the width. Automatic Sizing: If you have a lot of data that is wider than your cells, you can make all of the cells as big as the largest piece of data. You can do this by putting your cursor in between the column that you want to resize and the adjacent column, and double-click. This will automatically resize the column or row to ft the pieces oF data. Copy ‘Raw Activity’ data Name columns Expand columns to ft titles Task One: Insert functions Input remaining data Task Two: Creating Functions: Option One: In Excel, you can make your own functions based upon your data. For example, let’s say you want to create a function that lists days by twenties (0, 20, 40, etc.), denoting the 260 day period of Jack and Jill’s half life experiment: 1. Choose a column in which to store this function. In this example, we are going to do this in column A....
View Full Document