Difference between revisions of "Introduction to Engineering Computing Skills"

From EG1004 Lab Manual
Jump to: navigation, search
m (67 revisions)
m (9 revisions)
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<h1 align=center>EG1004 Lab 1: Software for Engineers I</h1>
#REDIRECT [[Software for Engineers]]
 
<p><b><font color=#ff0000>Important:</font> Please note before performing the lab you must register on
[http://eg.poly.edu the EG1004 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 1004.  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 1004
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 "EG1004" 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>(&#730;F)</i></b></li>
<li>In cell <b><i>B6</i></b>, enter <b><i>Temperature (&#730;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>&#730;</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 &#730;F into cells <b><i>A7</i></b> through <b><i>A16</i></b>,
increasing the temperature by 5 &#730;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]]

Latest revision as of 03:07, 11 July 2011