|
|
| (2 intermediate revisions by 2 users not shown) |
| Line 1: |
Line 1: |
| <p><b><font color=#ff0000>Important:</font> Please note before performing the lab you must register on
| | #REDIRECT [[Software for Engineers]] |
| [http://eg.poly.edu the EG1003 Web site].</b></p> | |
| <ul>
| |
| <li>Click on the register button as shown on the following screen:</li>
| |
| <p align=center>[[Image:Lab_intro_27.png]]</p>
| |
| <li>Fill in the appropriate information on the form that pops up and submit it, as shown on the following screen:</li>
| |
| <p align=center>[[Image:Lab_intro_28.png]]</p>
| |
| </ul>
| |
| | |
| | |
| <h2>1 OBJECTIVES</h2>
| |
| | |
| <p>The objective of this lab is to use Microsoft Word, Excel, and
| |
| PowerPoint to perform specific exercises and learn which programs are best
| |
| suited to particular tasks. Your goal, after having completed the assigned
| |
| tasks, is to have a basic familiarity with these three software tools.</p>
| |
| | |
| <h2>2 OVERVIEW</h2>
| |
| | |
| <p>This lab is designed to introduce you to three Microsoft
| |
| applications: Word, Excel, and PowerPoint.
| |
| Mastering these programs is essential for you to complete your
| |
| assignments in EG 1003. These software
| |
| tools are widely used in academic settings as well as in business and
| |
| industry. Many of you may already be
| |
| familiar with some of the things they can do.
| |
| The following exercises are designed to ensure you have a well defined
| |
| set of basic skills, so please complete all the required tasks.</p>
| |
| | |
| <h3>Microsoft Word</h3>
| |
| | |
| <p>Microsoft Word is a word processing program; its function is to
| |
| help you create and edit text. It has
| |
| features that make the mechanics of technical writing relatively easy, but it also
| |
| has features that make academic dishonesty and plagiarism very easy, too. You are expected to do all the exercises and
| |
| assignments for this (and all other courses) yourself, unless you are
| |
| specifically told otherwise, e.g., when you do a team report.</p>
| |
| | |
| <p>You can create tables and write equations in Word. It also has spelling and grammar checkers and
| |
| a thesaurus to help you eliminate mistakes in your writing. But beware: running spelling and grammar
| |
| checks does not eliminate the need for careful editing of all your
| |
| documents. As powerful as these tools are,
| |
| they are not foolproof.</p>
| |
| | |
| <p>In this course, you will use Word to write lab reports and proposals. The
| |
| thesaurus allows you to quickly find synonyms, so that you can avoid boring
| |
| repetition in your writing. To use the
| |
| thesaurus, put the cursor anywhere within the word for which you would like to
| |
| find a synonym. Pull down the Tools menu and select Language, then Thesaurus. You can also right-click
| |
| on the word and select Synonyms.</p>
| |
| | |
| <h3>Microsoft Excel</h3>
| |
| | |
| <p>Data collection, manipulation, and
| |
| analysis are critical steps in the research and design phases of any
| |
| project. Data can come from a variety of
| |
| sources including experiments and design calculations. Microsoft Excel, a
| |
| spreadsheet program, allows you to compile and analyze your data in a
| |
| systematic fashion.</p>
| |
| | |
| <p>Excel has many features that streamline
| |
| data analysis. You can use it to
| |
| generate tables, charts, and graphs.
| |
| Excel includes formatting tools, editing features, built-in functions,
| |
| data manipulation capabilities, and graphing features. It is especially useful for uncovering the
| |
| relationships that exist between data and to identify trends. You will use it to create graphical elements
| |
| that will be embedded in your reports, proposals, and presentations.</p>
| |
| | |
| <h3>Microsoft PowerPoint</h3>
| |
| | |
| <p>Microsoft PowerPoint is a presentation
| |
| program; its function is to create slides for presentations. Presenting information has always been
| |
| intrinsic to engineering projects. Product
| |
| introductions, requests for funding, progress reports, and reports to
| |
| management are just some examples of occasions where presentation skills are
| |
| required by technical professionals.</p>
| |
| | |
| <p>Remember, PowerPoint is a tool that will
| |
| help you make better presentations. It
| |
| is not a substitute for the longstanding rules to which good public speakers
| |
| have always adhered. It is most
| |
| effective when you use it to illustrate the points you want your audience to
| |
| understand. In EG, you will use
| |
| PowerPoint to report on your lab work and to present your progress on your
| |
| Independent Project.</p>
| |
| | |
| <p>These software tools are essential to your
| |
| success in EG and beyond. This lab is
| |
| designed to help you master them by having you perform a specific set of tasks.</p>
| |
| | |
| <h2>3 YOUR ASSIGNMENT</h2>
| |
| | |
| <h3>Individual Lab Report</h3>
| |
| | |
| <p>There is no formal write-up for this lab report. Instead, you will submit:</p>
| |
| <ul>
| |
| <li>A title page</li>
| |
| | |
| <li>Your MS Word exercise (personalized schedule and non-personalized schedule)</li>
| |
| | |
| <p><b>Note:</b> The title page and MS Word exercise should be in a single Word document, with
| |
| the title page and exercise separated by page breaks. (To make a page break, put the cursor
| |
| where you want a page break, and select <i>Insert/Break</i>. On the popup menu, select
| |
| <i>Page Break</i> if it's not already selected, and click OK.</p>
| |
| | |
| <li>Your MS Excel exercise (table and graph). Submit the Excel file, which has an .xls
| |
| file extension, by itself, not as part of a Word document.</li>
| |
| | |
| </ul>
| |
| <p><b><font color=#ff0000>IMPORTANT</font></b> Submit your report electronically using the EG 1003
| |
| website: http://eg.poly.edu. You will need to login and upload the lab report material. Submission
| |
| instructions, a sample coversheet, and a calendar showing the deadlines for your section are located
| |
| on the website.</p>
| |
| | |
| <!--><h3>Team PowerPoint Presentation</h3>
| |
| | |
| <p>Refer to the pages in the "Introduction to Giving Technical Presentations" in this online manual.
| |
| In preparing your presentation, you may also need to use some of the material in the "Instructional
| |
| Web Pages".</p>
| |
| | |
| <p>You must hand in a hardcopy of the PowerPoint presentation (one copy per team) you
| |
| have prepared at the beginning of each recitation period. You will deliver this presentation during
| |
| recitation with the team member(s) you worked with during lab. The hard copy will be used to help
| |
| grade your oral presentation.</p></!-->
| |
| | |
| <h2>4 MATERIALS AND EQUIPMENT</h2>
| |
| | |
| <ul>
| |
| <li>Lab PC</li>
| |
| <li>Microsoft Office Suite</li>
| |
| </ul>
| |
| | |
| <p><b>Remember:</b> You are required to take notes in lab. Experimental details are
| |
| easily forgotten unless written down. You should keep a laboratory notebook for this purpose. Each week, you
| |
| <b>must</b> hand in a copy of your lab notes for the Writing Consultant (<b>WC)</b> to review. Keeping
| |
| careful notes is an essential component of all scientific practice.</p>
| |
| | |
| <p>However, <b>for this lab only</b>, you are not required to take lab notes, or submit them for review by the Writing Consultant.</p>
| |
| | |
| <h2>5 PROCEDURE</h2>
| |
| | |
| <h3>Microsoft Word</h3>
| |
| | |
| <p>Most software has a built-in reference manual to help you learn
| |
| the program. Always look for a Help menu on the toolbar, and use it
| |
| whenever you are in doubt about how to do something. This, and regularly saving your work, will save
| |
| you many lost hours over your working lifetime.</p>
| |
| | |
| <p>You are going to create two Microsoft Word documents. One will look like Figure 1 below.</p>
| |
| | |
| <p align=center>[[Image:lab_intro-1.JPG]]</p>
| |
| | |
| <p class=caption>Figure 1: Generic Word document</p>
| |
| | |
| <p>The other will be personalized, and will look like Figure 2.</p>
| |
| | |
| <p align=center>[[Image:lab_intro_2.jpg]]</p>
| |
| | |
| <p class=caption>Figure 2: Personalized Word document</p>
| |
| | |
| <ol>
| |
| <li>To open Microsoft Word, go to the Start menu, select Lab Menu then select Lab 1 and click on
| |
| Microsoft Word.</li>
| |
| | |
| <p>It is a good idea to use the plain Times New Roman 12 pt font, with full justification as
| |
| your default, i.e., your starting font and format. Font and paragraph adjustments are located in
| |
| the Format menu on the main menu bar, as well as on the formatting toolbar. The paragraph
| |
| alignment buttons looks like this:</p>
| |
| | |
| <p>[[Image:lab_intro_3.gif]]</p>
| |
| | |
| <li>On the blank MS Word document page that opens, type the text in quotes below, without including the
| |
| quotes or the italicized attributes:</li>
| |
| | |
| <p>"Section ??" with the following attributes:<i> Courier New 48pt, aligned right</i></p>
| |
| <p>"First TA" <i>Times New Roman 12pt, aligned right</i></p>
| |
| <p>"Second TA" <i>Times New Roman 12pt, aligned right</i></p>
| |
| <p>"Name" <i>Arial 24pt, underlined, centered</i></p>
| |
| | |
| <p>"email address" <i>Courier New 16pt, bold, aligned left</i></p>
| |
| <p>"Address" <i>Times New Roman 12pt, aligned left</i></p>
| |
| <p>"Phone Number" <i>Times New Roman 12pt, aligned left</i></p>
| |
| | |
| <p>The attributes should be applied to the typed text using the program menus. The attributes can be
| |
| selected before you type the appropriate text, or applied afterward by selecting (highlighting) the
| |
| text and then applying the attributes.</p>
| |
| | |
| <p>Use the <b><i>Fonts</i></b> dialog box, found in the <b><i>Format</i></b> menu, to apply the required
| |
| fonts (see Figure 3).</p>
| |
| | |
| <p align=center>[[Image:lab_intro_4.gif]]</p>
| |
| | |
| <p class=caption>Figure 3: Fonts dialog box</p>
| |
| | |
| <p>Use the Paragraph dialog box, found in the Format menu, to get the required alignment (see Figure 4).</p>
| |
| | |
| <p align=center>[[Image:lab_intro_5.gif]]</p>
| |
| | |
| <p class=caption>Figure 4: Paragraph dialog box</p>
| |
| | |
| <p>Select the line spacing using the Line Spacing menu. Use the following line spacing instructions
| |
| for your Word document:</p>
| |
| | |
| <ol type="a">
| |
| <li>for all text that is aligned right, use single spacing</li>
| |
| <li>for all text that is centered, use double spacing</li>
| |
| <li>for all text that is aligned left, use 1.5-line spacing.</li>
| |
| </ol>
| |
| | |
| <li>It is a good idea to periodically save your work. To do this, select Save from the File menu. Name
| |
| the file "lab01generic.doc" and save it in the "My Documents" folder on the lab computer. Later, you must
| |
| <b>e-mail</b> all the files you create to your personal e-mail account so you can include them
| |
| in your lab report.</li>
| |
| | |
| <li>Now you will insert an equation into the Word document you have created.</li>
| |
| | |
| <ol type="a">
| |
| <li>Position the cursor just in front of the word "Section" and left click the mouse. A vertical bar will
| |
| appear, meaning this is where the equation will be placed.</li>
| |
| | |
| <li>From the Insert menu select Object. The box shown in Figure 5 will appear.</li>
| |
| | |
| <p align=center>[[Image:lab_intro_6.gif]]</p>
| |
| | |
| <p class=caption>Figure 5: Object dialog box</p>
| |
| | |
| <li>Select Microsoft Equation 3.0 from the list and click OK. The Equation
| |
| toolbar shown in Figure 6 will appear.</li>
| |
| | |
| <p align=center>[[Image:lab_intro_7.gif]]</p>
| |
| | |
| <p class=caption>Figure 6: Equation toolbar</p>
| |
| | |
| <li>To insert the desired quadratic equation in the upper left-hand corner of the page, proceed as follows:</li>
| |
| | |
| <ul>
| |
| <li>Select Text from the Style menu and then begin by typing "x=" (as usual, without the quotes).</li>
| |
| | |
| <li>Select the fraction item from the Equation palette (see Figure 7).</li>
| |
| | |
| <p align=center><b><i>[[Image:lab_intro_8.gif]]</i></b></p>
| |
| | |
| <p class=caption>Figure 7: Fraction menu</p>
| |
| | |
| <li>Type "-b" and then select the plus-or-minus symbol from the Equation palette (see Figure 8).</li>
| |
| | |
| <p align=center>[[Image:lab_intro_9.gif]]</p>
| |
| | |
| <p class=caption>Figure 8: plus-or-minus symbol</p>
| |
| | |
| <li>Select the radical (square root) symbol from the Equation palette, which is found on the same menu as the fraction item.</li>
| |
| | |
| <li>To superscript text (necessary for the "2" in "b<sup>2</sup>"), go to the super/sub script
| |
| menu on the Equation palette (see Figure 9).</li>
| |
| | |
| <p align=center>[[Image:lab_intro_10.gif]]</p>
| |
| | |
| <p class=caption>Figure 9: super/subscript menu</p>
| |
| | |
| <li>Complete the expression by typing the remaining characters in the appropriate places. When you are finished, click outside the
| |
| equation box to return to the ordinary word processing mode.</li>
| |
| | |
| <li>Click on the equation and a black frame will appear around it. Right click on the equation, and a drop down menu will appear.
| |
| Select "Format Object".</li>
| |
| | |
| <li>Click on the "Layout" tab, and the picture above "In Front of Text". This will allow you to move the equation around. Click "OK".</li>
| |
| | |
| <li> Click and hold down the mouse on the equation. As you move the mouse around, you'll be dragging the equation with you.
| |
| Drag the equation to the left side of the line and release the mouse. The equation is now where you want it.</li>
| |
| | |
| </ul>
| |
| | |
| </ol>
| |
| | |
| <li>Next, you will insert a table.</li>
| |
| | |
| <ol type="a">
| |
| <li>Position the cursor by putting your mouse directly below the "Phone Number" line and clicking it. A vertical bar (the cursor) will appear at the left end of the line.</li>
| |
| <li>From the Table menu select Insert, then Table.The box shown in Figure 10 will appear.</li>
| |
| | |
| <p align=center>[[Image:lab_intro_11.gif]]</p>
| |
| | |
| <p class=caption>Figure 10: Insert Table dialog box</p>
| |
| | |
| <li>For your Word document, select 6 columns and 14 rows. Make all column and row headings bold and use
| |
| Arial, 10pt for the text in the table. Center the table on the page. Label the columns with the five days of the
| |
| week. Label the rows from 8 AM to 9PM. Each row should contain one hour, e.g. 8:00 – 9:00. However, the row
| |
| should not contain the AM or PM identifiers since the context is obvious.</li>
| |
| </ol>
| |
| | |
| <li>Now you will shade the cells and change the borders of your tables. The entire
| |
| perimeter of each table should have a double-lined border. The Club Hour cells should be shaded.</li>
| |
| | |
| <ol type="a">
| |
| <li>Highlight the Club Hour cells (Monday 1:00 pm to 2:00.pm and Wednesday 12:00 noon to 2:00 pm). To
| |
| highlight an individual cell, place the cursor at the left end of the cell. The cursor will become a black,
| |
| bolded, angled arrow. Once this arrow appears, click once to highlight the cell.</li>
| |
| | |
| <li>On the Format menu, click Borders and Shading. Click the Shading tab and select 25% gray from the color palette. Highlight 'Club Hours' and change text color to white.</li>
| |
| | |
| <li>Now click on the Borders tab. Select the double line from the Style list and then select Table from the Apply to drop-down menu.</li>
| |
| </ol>
| |
| | |
| <li>Save the changes that have been made by selecting <b><i>Save</i></b> from the <b><i>File</i></b> menu.</li>
| |
| | |
| <li>Finally, you will learn to use Word Art.</li>
| |
| | |
| <ol type="a">
| |
| | |
| <li>Place the cursor where you want your object to appear.</li>
| |
| | |
| <li>On the Insert menu, select Picture, then Word Art.</li>
| |
| | |
| <li>A gallery of choices will appear. Select one that resembles our example. Click OK.</li>
| |
| | |
| <li>Type "EG1003" in the box that appears. Click OK.</li>
| |
| </ol>
| |
| | |
| <li>Save the document again.</li>
| |
| | |
| <li>Now it is time to personalize your document.</li>
| |
| | |
| <ol type="a">
| |
| <li>Select <b><i>Save As</i></b> from the <b><i>File</i></b> menu. Name the file "lab01personal.doc" and save it
| |
| in the "My Documents" folder on the lab computer.</li>
| |
| | |
| <li>Personalize the generic document you just created, keeping the appropriate attributes.</li>
| |
| | |
| <li>Save this new file.</li>
| |
| </ol>
| |
| | |
| </ol>
| |
| | |
| <p><b><i>To insert a comment (Microsoft Word):</i></b></p>
| |
| | |
| <ol>
| |
| <li>Put the cursor where you would like the comment inserted.</li>
| |
| <li>Pull down the <b><i>Insert</i></b> menu and select <b><i>Comment</i></b>.</li>
| |
| <li>Type the text for the comment. You can see the text in the box at the bottom of the screen.</li>
| |
| <li>Click anywhere in the document outside the comment area to finish.</li>
| |
| <li>To delete a comment, right-click on the comment and select <b><i>Delete Comment</i></b>.
| |
| | |
| </ol>
| |
| | |
| <p><b><i>Microsoft Excel</i></b></p>
| |
| | |
| <p>Now you will create a Microsoft Excel document. Your Excel document will include two tables and a graph showing
| |
| how the volume of a gas changes when its temperature changes. Your Lab TAs will supply each student with a
| |
| different value for the number of moles, n. The relationship you will graph is known as Charles' Law. When
| |
| you are finished, your document will look like Figure 11.</p>
| |
| <p align=center>[[Image:lab_intro_12.jpg]]</p>
| |
| <p class=caption>Figure 11: Excel Document</p>
| |
| | |
| <p>To open Microsoft Excel, go to the Start menu, select Lab Menu then select Lab 1 and click on Microsoft Excel.</p>
| |
| | |
| <p><b>Creating a Header</b></p>
| |
| | |
| <ol>
| |
| <li>In the new, blank workbook that opens, select <b><i>Header</i></b> and <b><i>Footer</i></b> from the <b><i>View</i></b>
| |
| menu and click on the Custom Header button (See Figure 12).</li>
| |
| | |
| <p align=center>[[Image:lab_intro_13.jpg]]</p>
| |
| | |
| <p class=caption>Figure 12: Custom Header dialog box</p>
| |
| | |
| <li>In the Left section: box type your name. In the Center section: box type "Lab 1: Excel Exercise." In the Right section:
| |
| box type your section. Click "OK" to save this information. Click "OK" again to remove the "Page Setup" window and return to
| |
| the spreadsheet.</li>
| |
| </ol>
| |
| | |
| <p><b>Note</b>: <i>The Header is not visible on the Excel spreadsheet as you work; it is
| |
| inserted when the sheet is printed. You
| |
| can use the </i>Print Preview<i> in the<b> </b></i>File menu<i> to preview the final
| |
| document.</i></p>
| |
| | |
| <p><b>Setting up Your Worksheet</b></p>
| |
| | |
| <p>To complete the exercise, you will create two tables. The first one is a table of constants. To create it, enter the
| |
| following information into your Excel worksheet:</p>
| |
| | |
| <ol>
| |
| <li>In cell <b><i>A1</i></b>, enter <b><i>Term</i></b></li>
| |
| <li>In cell <b><i>B1 </i></b>enter <b><i>Number</i></b></li>
| |
| | |
| <li>In cell <b><i>C1 </i></b>enter <b><i>Unit(s)</i></b></li>
| |
| <li>In cell <b><i>A2</i></b>, enter <b><i>n</i></b></li>
| |
| <li>In cell <b><i>B2</i></b>, enter the value provided by your TA</li>
| |
| <li>In cell <b><i>C2</i></b>, enter <b><i>mol</i></b></li>
| |
| | |
| <li>in cell <b><i>A3</i></b>, enter <b><i>R</i></b></li>
| |
| <li>In cell <b><i>B3 </i></b>enter <b><i>0.082057</i></b></li>
| |
| <li>In cell <b><i>C3</i></b>, enter <b><i>L*atm*mol<sup>-1</sup>*K<sup>-1</sup></i></b></li>
| |
| | |
| <li>In cell <b><i>A4</i></b>, enter <b><i>P</i></b></li>
| |
| <li>In cell <b><i>B4</i></b>, enter <b><i>1</i></b></li>
| |
| <li>In cell <b><i>C4</i></b>, enter <b><i>atm</i></b></li>
| |
| </ol>
| |
| | |
| <p>To create the superscripted text necessary for cell <b><i>C3</i></b>, highlight the text you want
| |
| superscripted and select Cells from the Format menu. Check the superscript box.</p>
| |
| | |
| <p><b>Note:</b>In the next few cells, you'll be inserting the degree symbol. To do this, just type all
| |
| the text except the degree symbol, and then come back and insert the degree symbol using the instructions
| |
| in the next note.</p>
| |
| | |
| <p>Next, you will create a table of computed values. To do this, type the following text into your
| |
| Excel worksheet:</p>
| |
| | |
| <ol>
| |
| <li>In cell <b><i>A6</i></b>, enter <b><i>Temperature</i></b> <b><i>(˚F)</i></b></li>
| |
| <li>In cell <b><i>B6</i></b>, enter <b><i>Temperature (˚C)</i></b></li>
| |
| <li>In cell <b><i>C6</i></b>, enter <b><i>Temperature (K)</i></b></li>
| |
| <li>In cell <b><i>D6</i></b>, enter <b><i>Volume (L)</i></b></li>
| |
| </ol>
| |
| | |
| <p><b>Note:</b> To insert the <b>˚</b> symbol, pull down the Insert menu and choose the Symbol Palette.
| |
| Choose the appropriate symbol and click Insert.</p>
| |
| | |
| <p>Enter Fahrenheit temperatures 0 – 45 ˚F into cells <b><i>A7</i></b> through <b><i>A16</i></b>,
| |
| increasing the temperature by 5 ˚F in each successive cell.</p>
| |
| | |
| <p><b>Using Formulas</b></p>
| |
| | |
| <p>Formulas perform calculations in your worksheet. The calculations may use values in other cells, making
| |
| Excel a very powerful calculator program. A formula is entered in the destination cell where you want the
| |
| answer to appear. Excel has many built in functions that you can use. The destination cell value is the implied
| |
| result and so a formula always starts with an equal sign (=).</p>
| |
| | |
| <p>As an example of the syntax, the formula "= 5*(<b><i>P98</i></b>) +ABS(<b><i>X15</i></b>)/0.34" would take the
| |
| value in cell <b><i>P98</i></b> and multiply it by five, and then add the result to the absolute value of the contents of
| |
| cell <b><i>X15</i></b> divided by 0.34. If you are in doubt about the order of the mathematical operations,
| |
| use brackets to make sure the result is calculated correctly. The full range of functions can be selected from
| |
| the formula menu or by using the <b><i>fx </i></b>button on the toolbar<b><i>.</i></b></p>
| |
| | |
| <p>You will use the following expression to convert your simulated data into degrees Celsius:</p>
| |
| | |
| <p align=center>[[Image:lab_intro_14.gif]]</p>
| |
| | |
| <ol>
| |
| <li>Enter "=5/9*(<b><i>A7</i></b>-32)" into cell <b><i>B7</i></b>.</li>
| |
| | |
| <li>Copy the formula by dragging the fill handle (solid square on the bottom right of the <b><i>B7</i></b> cell)
| |
| all the way down to cell <b><i>B16.</i></b></li>
| |
| | |
| <li>Click on the cells between <b><i>B7</i></b> and <b><i>B16 </i></b>and examine the contents. Notice that the
| |
| cell reference in the formula has automatically been adjusted in each destination cell.</li>
| |
| </ol>
| |
| | |
| <p>You will then use the following expression to convert your data into Kelvin:</p>
| |
| | |
| <p align=center><sub>[[Image:lab_intro_15.gif]]</sub></p>
| |
| | |
| <ol>
| |
| <li>Enter "=<b><i>B7</i></b>+273.15" into cell <b><i>C7</i></b>.</li>
| |
| | |
| <li>Copy the formula into the remaining cells in column <b><i>C</i></b> by selecting cell <b><i>C7</i></b>
| |
| and then dragging the fill handle all the way to cell <b><i>C16</i></b>.<b><i></i></b></li>
| |
| | |
| <li>Click on the cell <b><i>C16 </i></b>and look at the contents. Notice that the cell reference in the formula
| |
| (<b><i>B7</i></b>) has automatically been adjusted to <b><i>B16</i></b>.</li>
| |
| | |
| </ol>
| |
| | |
| <p>You will use the ideal gas law expression to compute the volume for your exercise:</p>
| |
| | |
| <p align=center>[[Image:lab_intro_16.gif]]</p>
| |
| | |
| <ol>
| |
| <li>Enter "=(<b><i>$B$2</i></b> *<b><i>$B$3</i></b>*<b><i>C7)/$B$4</i></b>" into cell <b><i>D7</i></b>.</li>
| |
| | |
| <li>Copy the formula into the remaining cells in column <b><i>D</i></b> by selecting cell <b><i>D7 </i></b>and
| |
| then dragging the fill handle all the way to cell <b><i>D16</i></b>.<b><i></i></b></li>
| |
| | |
| <li>Click on cell <b><i>D16 </i></b>and notice that all the cell references except <b><i>C7</i></b> have been
| |
| kept constant. Typing a <b><i>$</i></b> before a cell reference letter or number fixes the value, even if is
| |
| it later copied. Two <b><i>$</i></b> keeps both the cell letter and the cell number constant.</li>
| |
| | |
| </ol>
| |
| | |
| <p><b>Formatting Your Tables</b></p>
| |
| | |
| <p>First, you need to be able to see the entire contents of each column. By default, Excel sets all columns to
| |
| the same width, and fields containing long strings of data can be obstructed by other columns. However, Excel
| |
| can resize each column to make all the data it contains visible. Always review your data and decide if the number
| |
| of digits displayed in the worksheet is appropriate.</p>
| |
| | |
| <ol>
| |
| <li>Double-click the right edge of the column (see Figure 13).</li>
| |
| | |
| <p align=center>[[Image:lab_intro_17.gif]]</p>
| |
| <p class=caption>Figure 13: Column Edge</p>
| |
| | |
| <li>In our example two digits after the decimal point is appropriate. Adjust the display by highlighting the
| |
| data cells B7:D16 and selecting the tab under Cells in the Format menu.</li>
| |
| | |
| <li>Select number and two decimal places from the menu. You may also do this by using the increase decimal
| |
| or decrease decimal buttons on the formatting toolbar.</li>
| |
| | |
| <li>Changing the number of places in the "Volume" column now made the column too wide, since it no longer has
| |
| to hold so many places. Resize the column by double clicking the right edge of the column again.</li>
| |
| </ol>
| |
| | |
| <p><b>Creating Table Borders</b></p>
| |
| | |
| <ol>
| |
| <li>In your Excel worksheet, highlight the table of constants (cells A1-C4), and right-click within the
| |
| highlighted area.</li>
| |
| | |
| <li>From the context menu that appears, select Format Cells.</li>
| |
| | |
| <li>In the Format Cells dialog box, go to the Border tab.</li>
| |
| | |
| <li>Make the constant table professional looking by selecting the double lines in the bottom right corner of
| |
| the "Style", and the "Outline" preset. Now we'll put grid lines inside by selecting the single line in the
| |
| bottom left corner of "Style", and the "Inside" present. The preview picture will now show a grid with a double
| |
| line frame and single line inside lines. Click "OK", and you'll now see the table of constants being nicely framed.
| |
| </li>
| |
| | |
| <li>Next, we'd like to separate the column headers from the numbers. Highlight the column header cells (A1-C1), and
| |
| right click within the highligted area. Like before, select Format Cells from the context menu that appears and go
| |
| to the Border tab. Select the double lines in the bottom right corner of "Style" and the "Outline" present. Next, we'd
| |
| like to shade the column headers so they stand out more. Click on the "Pattern" tab and select the 25% gray box (next
| |
| to last row on the extreme right side, just above the right box. Click "OK", and you'll see that the column headers
| |
| now have their own frame and shading.</li>
| |
| | |
| <li>Repeat steps 1-5 for the table of computations.</li>
| |
| </ol>
| |
| | |
| <p align=center>[[Image:lab_intro_18.gif]]</p>
| |
| <p class=caption>Figure 14: Format Cells dialog box</p>
| |
| | |
| <p><b>Creating a Chart</b></p>
| |
| | |
| <p>As the final step in this exercise, you will be graphing the relationship between volume and temperature,
| |
| using the Chart feature in Excel. To create a chart:</p>
| |
| | |
| <ol>
| |
| <li>Select the volume values in cells <b><i>D7–D16</i></b>.</li>
| |
| | |
| <li>Click the Chart Wizard button.[[Image:lab_intro_19.gif]]</li>
| |
| | |
| <li>In the Chart Type dialog box, select XY (Scatter) chart type and leave the chart subtype
| |
| at the default setting (see Figure 15), then click Next.</li>
| |
| | |
| <p align=center>[[Image:lab_intro_20.gif]]</p>
| |
| <p class=caption>Figure 15: Chart Type dialog box</p>
| |
| | |
| <li>In the Chart Source dialog box, select the Series tab, as shown in Figure 16.</li>
| |
| | |
| <p align=center>[[Image:lab_intro_21.gif]]</p>
| |
| <p class=caption>Figure 16: Chart Source dialog box</p>
| |
| | |
| <li>Click on the Select From Worksheet button (the icon at the right end of the <u>X</u>
| |
| Values box). Excel will allow you to select cells directly from your worksheet. Select cells
| |
| <b><i>C7–C16 </i></b>and press Enter.</li>
| |
| | |
| <li>Click Next and the Chart Options dialog box will appear (see Figure 17</li>
| |
| | |
| <p align=center>[[Image:lab_intro_22.gif]]</p>
| |
| | |
| <p class=caption>Figure 17: Chart Options dialog box</p>
| |
| | |
| <li>In the Chart Title: field, enter <b><i>Volume (L) vs. Temperature (K).</i></b></li>
| |
| | |
| <li>In the Value(X) axis: field, enter <b><i>Temperature (K)</i></b>.</li>
| |
| | |
| <li>In the Value (Y) axis: field, enter <b><i>Volume (L)</i></b>.</li>
| |
| | |
| <li>Click Next and the Chart Location dialog box will appear (see Figure 18).</li>
| |
| | |
| <p align=center>[[Image:lab_intro_23.gif]]</p>
| |
| | |
| <p class=caption>Figure 18: Chart Location dialog box</p>
| |
| | |
| <li>In the Chart Location dialog box, select As object in.</li>
| |
| | |
| <li>From the drop-down menu, select your current worksheet (see Figure 18).</li>
| |
| | |
| <li>Click Finish to create your chart.</li>
| |
| | |
| <li>Delete the Series 1 Legend box from your chart. Click on the Legend box and it
| |
| will be highlighted by having squares on it. Press the delete key to delete the box.</li>
| |
| </ol>
| |
| | |
| <p><b>Adding a Trendline</b></p>
| |
| | |
| <p>A trendline is a fit to data, indicating the general behavioral tendency or trend
| |
| of the data, if any. This allows you to more easily see the nature of any
| |
| relationship between the quantities in your graph. To add a trendline to your
| |
| chart:</p>
| |
| | |
| <ol>
| |
| <li>Select any data point on your chart. Excel will automatically select all remaining points for you.</li>
| |
| | |
| <li>Right-click within the chart. From the context menu that appears, select Add Trendline.</li>
| |
| | |
| <li>In the Type tab, select the Linear trend type.</li>
| |
| </ol>
| |
| | |
| <p><b>Adding a Caption to Your Chart</b></p>
| |
| | |
| <ol>
| |
| <li>Reposition the chart within your worksheet so that it does not obstruct your data tables. Do this
| |
| by clicking anywhere on the chart. Squares will appear around the border of the chart indicating that it
| |
| has been selected. Click the mouse, and "drag" the chart to where you want it, which is typically on the
| |
| left edge of the spreadsheet, with one row between the bottom of the data table and the top of the chart.</li>
| |
| | |
| <li>Select a set of cells beneath your graph roughly the same width as the graph, starting where you
| |
| want the caption to begin, and right-click within the selected group of cells. From the context menu
| |
| that appears, select Format Cells.</li>
| |
| | |
| <li>In the Alignment tab, check the Wrap Text and Merge Cells checkboxes, and click OK.</li>
| |
| | |
| <li>Enter a suitable caption for your chart.</li>
| |
| | |
| <li>Save your worksheet as "lab01excel.xls" and print a copy on a single page.</li>
| |
| </ol>
| |
| | |
| | |
| <p><b><i>Microsoft PowerPoint</i></b></p>
| |
| | |
| <p>Now you will create a PowerPoint presentation reporting on the work done in <b><i>Lab 1</i></b>.
| |
| PowerPoint has five viewing windows. Slide View displays one slide at a time, Outline View lists
| |
| the text for each slide in your presentation, Slide Shorter View displays thumbnails of all your
| |
| slides allowing you to reorder them easily, and Notes Page View lets you attach text to each slide.
| |
| Finally, you can view your slides in order in the Slide Show View.</p>
| |
| | |
| <p>For this lab, your presentation must include a title slide, a
| |
| brief overview of the presentation, examples of the work done in this lab
| |
| (either screenshots, or material copied and pasted from the original documents)
| |
| and a conclusion slide. You may use any design template that you like. Use a
| |
| title slide at the beginning of your presentation and the bulleted slides for
| |
| the information that follows. Figure 19 contains some examples of what your
| |
| slides might look like.</p>
| |
| | |
| <p align=center>[[Image:lab_intro_24.gif]]</p>
| |
| | |
| <p class=caption>Figure 19: Typical PowerPoint slides</p>
| |
| | |
| <p>To open Microsoft PowerPoint, go to the Start menu, select Lab Menu then select Lab 1 and
| |
| click on Microsoft PowerPoint.</p>
| |
| | |
| <ol>
| |
| <li>From the dialog box displayed, select Blank Presentation, or select Blank Presentation from
| |
| the New Presentation toolbar on the right of the screen. A new slide will appear with the
| |
| default Title layout (see Figure 20). Click where it says, "Click to add title" and enter
| |
| the title of your presentation. </li>
| |
| | |
| <p align=center>[[Image:lab_intro_25.jpg]]</p>
| |
| | |
| <p class=caption>Figure 20: Microsoft PowerPoint, main window. Your screen will look like
| |
| this when you begin a new presentation.</p>
| |
| | |
| <li>From the Insert menu, select New Slide (CTRL+M). Click on the new slide. Type the title of
| |
| the next slide. Click anywhere inside the box marked Click to Add Text and insert your information.
| |
| Continue this process until you have outlined your entire presentation.</li>
| |
| | |
| <li>To add an object from another software application, like Word or Excel, simply copy and paste
| |
| your object onto the selected PowerPoint slide.</li>
| |
| </ol>
| |
| | |
| <p>Microsoft PowerPoint allows you to customize the design of your presentation. You can
| |
| choose a design template in two ways depending on whether you are just starting your presentation
| |
| or have already created it.</p>
| |
| | |
| <p>To select a design template before you begin, select Design Template from the choices that appear
| |
| when you create a new file. Select the particular design template you would like to use for
| |
| your presentation.</p>
| |
| | |
| <p>To select a design template after you start, open the presentation, pull down the Format
| |
| menu, select Slide Design and apply the design template you like.</p>
| |
| | |
| <p><b>Note:</b><i> With this window open, you can adjust your color schemes, too. After selecting the
| |
| design template, click on </i>Color Schemes <i>and select the color you like. PowerPoint will apply this
| |
| color to your template. Remember, a light background with the letters in strong contrast is best.</i></p>
| |
| | |
| <h3><font color=#ff0000>IMPORTANT</font></h3>
| |
| <p>Make sure you run Spell Check when you have completed your presentation! To run it, hit F7. After making any
| |
| corrections, save your presentation as "lab01PowerPoint.ppt."</p>
| |
| | |
| <p>To print a copy of your PowerPoint Presentation:</p>
| |
| | |
| <ol>
| |
| | |
| <li>From the File menu select Print. The box in Figure 21 will appear.</li>
| |
| | |
| <p align=center>[[Image:lab_intro_26.gif]]</p>
| |
| | |
| <p class=caption>Figure 21: Microsoft PowerPoint Print dialog box.</p>
| |
| | |
| <li>In the box marked Print what: select <b><i>Handouts</i></b>.</li>
| |
| | |
| <li>In the box marked Color/grayscale select <b><i>Pure Black and White</i></b>.</li>
| |
| | |
| <li>In the box marked Slides per page choose <b><i>six</i></b>, using <b><i>Horizontal </i></b>order.</li>
| |
| | |
| <li>Click OK to print.</li>
| |
| </ol>
| |
| | |
| <p>Your lab work is now complete. <b>e-mail</b> copies of all the files you created to your personal account.
| |
| Review the files for errors before submitting your report.</p>
| |
| | |
| <p>Please clean up your workstation before you leave the lab. Refer to section <b><i>3 Your Assignment </i></b>for
| |
| the list of the specific items you must submit for your report.</p>
| |
| | |
| | |
| [[Main_Page | Return to Table of Contents]]
| |