Difference between revisions of "Microsoft Office Skill Builder"

From EG1004 Lab Manual
Jump to: navigation, search
Line 1: Line 1:
<h1 align=center>EG1004 Lab 1: Software for Engineers I</h1>
<h1 align=center>EG1004 Lab 1: Software for Engineers I (Office 2007 Version)</h1>
 
<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>


<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>
<ul>
<li>Click on the register button as shown on the following screen:</li>
<li>Click on the register button as shown on the following screen:</li>
<p align=center>[[Image:Lab_intro_27.png]]</p>
<p align=center>[[Image:Lab_intro_27.png]]</p>
<li>Fill in the appropriate information on the form that pops up and submit is, as shown on the following screen:</li>
 
<li>Fill in the appropriate information on the form that pops up and submit is,
as shown on the following screen:</li>
 
<p align=center>[[Image:Lab_intro_28.png]]</p>
<p align=center>[[Image:Lab_intro_28.png]]</p>
</ul>
</ul>


<h2>1 OBJECTIVES</h2>
<h2>1 OBJECTIVES</h2>
Line 20: Line 24:
<h2>2 OVERVIEW</h2>
<h2>2 OVERVIEW</h2>


<p>This lab is designed to introduce you to three Microsoft
<p>This lab is designed to introduce you to three Microsoft applications:
applications: Word, Excel, and PowerPoint.  
Word, Excel, and PowerPoint. Mastering these programs is essential for you to
Mastering these programs is essential for you to complete your
complete your assignments in EG1004. These software tools are widely used in
assignments in EG 1004. These software
academic settings as well as in business and industry.  Many of you may already
tools are widely used in academic settings as well as in business and
be familiar with some of the things they can do. The following exercises are
industry.  Many of you may already be
designed to ensure you have a well defined set of basic skills, so please
familiar with some of the things they can do.  
complete all the required tasks.</p>
The following exercises are designed to ensure you have a well defined
 
set of basic skills, so please complete all the required tasks.</p>
<p>Like many other installations, EG1004 has a huge amount of software written
to support products that are part of Office. All of this software is currently
written for Office 2003. Again, like many other installations, the EG1004 staff
is converting this software to operate with Office 2007. However, this is a
huge effort. Also, since many students take EG1004 from different class years,
some students may have Office 2003 and others Office 2007. Office 2007 can read
Office 2003 files, but the opposite conversion does not always work. Therefore,
for the foreseeable future, you will have to submit your work in Office 2003
format. Fortunately, this is easy to do; when you're preparing to submit something
to the EG1004 Web site or other destinations, instead of saving the document using
the "Save" menu item, you'll be using the "Save As" item instead, selecting the
Office 2003 version as the file type. Details on how to do this will be in the
appropriate places later in this lab.</p>
 


<h3>Microsoft Word</h3>
<h3>Microsoft Word</h3>


<p>Microsoft Word is a word processing program; its function is to
<p>Microsoft Word is a word processing program; its function is to help you
help you create and edit text. It has
create and edit text. It has features that make the mechanics of technical
features that make the mechanics of technical writing relatively easy, but it also
writing relatively easy, but it also has features that make academic dishonesty
has features that make academic dishonesty and plagiarism very easy, too. You are expected to do all the exercises and
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
assignments for this (and all other course assignments) yourself, unless you
specifically told otherwise, e.g., when you do a team report.</p>
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
<p>You can create tables and write equations in Word.  It also has spelling and
a thesaurus to help you eliminate mistakes in your writing. But beware: running spelling and grammar
grammar checkers and a thesaurus to help you eliminate mistakes in your writing.
checks does not eliminate the need for careful editing of all your
But beware: running spelling and grammar checks does not eliminate the need for
documents. As powerful as these tools are,
careful editing of all your documents. As powerful as these tools are, they are
they are not foolproof.</p>
not foolproof.</p>


<p>In this course, you will use Word to write lab reports and proposals. The
<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
thesaurus allows you to quickly find synonyms, so that you can avoid boring
repetition in your writing. To use the
repetition in your writing. To use the thesaurus, put the cursor anywhere
thesaurus, put the cursor anywhere within the word for which you would like to
within the word for which you would like to find a synonym. On the top menu,
find a synonym. Pull down the Tools menu and select Language, then Thesaurus. You can also right-click
select the <b><i>Review</i></b> tab. Then click on the <b><i>Thesaurus</i></b>
on the word and select Synonyms.</p>
icon, which looks like a book. The equivalent words (synonyms) will be shown on
the right side of the screen. Just double click on the one you want to
select.</p>


<h3>Microsoft Excel</h3>
<h3>Microsoft Excel</h3>


<p>Data collection, manipulation, and
<p>Data collection, manipulation, and analysis are critical steps in the
analysis are critical steps in the research and design phases of any
research and design phases of any project. Data can come from a variety of
project. Data can come from a variety of
sources including experiments and design calculations. Microsoft Excel, a
sources including experiments and design calculations. Microsoft Excel, a
spreadsheet program, allows you to compile and analyze your data in a
spreadsheet program, allows you to compile and analyze your data in a
systematic fashion.</p>
systematic fashion.</p>


<p>Excel has many features that streamline
<p>Excel has many features that streamline data analysis. You can use it to
data analysis. You can use it to
generate tables, charts, and graphs. Excel includes formatting tools, editing
generate tables, charts, and graphs.  
features, built-in functions, data manipulation capabilities, and graphing
Excel includes formatting tools, editing features, built-in functions,
features. It is especially useful for uncovering the relationships that exist
data manipulation capabilities, and graphing features. It is especially useful for uncovering the
between data and to identify trends. You will use it to create graphical
relationships that exist between data and to identify trends. You will use it to create graphical elements
elements that will be embedded in your reports, proposals, and
that will be embedded in your reports, proposals, and presentations.</p>
presentations.</p>


<h3>Microsoft PowerPoint</h3>
<h3>Microsoft PowerPoint</h3>


<p>Microsoft PowerPoint is a presentation
<p>Microsoft PowerPoint is a presentation program; its function is to create
program; its function is to create slides for presentations. Presenting information has always been
slides for presentations. Presenting information has always been intrinsic to
intrinsic to engineering projects. Product
engineering projects. Product introductions, requests for funding, progress
introductions, requests for funding, progress reports, and reports to
reports, and reports to management are just some examples of occasions where
management are just some examples of occasions where presentation skills are
presentation skills are required by technical professionals.</p>
required by technical professionals.</p>


<p>Remember, PowerPoint is a tool that will
<p>Remember, PowerPoint is a tool that will help you make better presentations.
help you make better presentations. It
It is not a substitute for the longstanding rules to which good public speakers
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
have always adhered. It is most
points you want your audience to understand. In EG1004, you will use PowerPoint
effective when you use it to illustrate the points you want your audience to
to report on your lab work and to present your progress on your Semester Long
understand. In EG, you will use
Design Project.</p>
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
<p>These software tools are essential to your success in EG1004 and beyond.
success in EG and beyond. This lab is
This lab is designed to help you master them by having you perform a specific
designed to help you master them by having you perform a specific set of tasks.</p>
set of tasks.</p>


<h2>3 YOUR ASSIGNMENT</h2>
<h2>3 YOUR ASSIGNMENT</h2>
Line 95: Line 110:
<h3>Individual Lab Report</h3>
<h3>Individual Lab Report</h3>


<p>There is no formal write-up for this lab report. Instead, you will submit:</p>
<p>There is no formal write-up for this lab report. Instead, you will
submit:</p>
 
<ul>
<ul>
<li>A title page</li>
<li>A title page</li>


<li>Your MS Word exercise (personalized schedule and non-personalized schedule)</li>
<li>Your Microsoft 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
<p><b>Note:</b> The title page and Microsoft Word exercise should be in a
the title page and exercise separated by page breaks. (To make a page break, put the cursor
single Word document, with the title page and exercise separated by page
where you want a page break, and select <i>Insert/Break</i>. On the popup menu, select
breaks. (To make a page break, put the cursor where you want a page break,
<i>Page Break</i> if it's not already selected, and click OK.</p>
select the <b><i>Insert</i></b> tab on the top menu, and then click on the
<b><i>Page Break</i></b> icon.</p>


<li>Your MS Excel exercise (table and graph). Submit the Excel file, which has an .xls
<li>Your Microsoft Excel exercise (table and graph). Submit the Excel file,
file extension, by itself, not as part of a Word document.</li>
which has an .xls file extension, by itself, not as part of a Word
document.</li>


<li>Your MS PowerPoint exercise. Submit the PowerPoint file, which has a .ppt
<li>Your Microsoft PowerPoint exercise. Submit the PowerPoint file, which has a
file extension, by itself, not as part of a Word document.</li>
.ppt file extension, by itself, not as part of a Word document.</li>
</ul>
</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
<p><b><font color=#ff0000>IMPORTANT</font></b> Submit your report
instructions, a sample coversheet, and a calendar showing the deadlines for your section are located
electronically using the EG1004 website: http://eg.poly.edu. You will need to
login and upload the lab report material. Submission instructions, a sample
coversheet, and a syllabus showing the deadlines for your section are located
on the website.</p>
on the website.</p>


<h3>Team PowerPoint Presentation</h3>
<h3>Team PowerPoint Presentation</h3>


<p>Refer to the pages in the "Introduction to Giving Technical Presentations" in this online manual.
<p>Refer to the pages in the "Introduction to Giving Technical Presentations"
In preparing your presentation, you may also need to use some of the material in the "Instructional
in this online manual. In preparing your presentation, you may also need to use
Web Pages".</p>
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
<p>You must hand in a hardcopy of the PowerPoint presentation (one copy per
have prepared at the beginning of each recitation period. You will deliver this presentation during
team) you have prepared at the beginning of each recitation period. You will
recitation with the team member(s) you worked with during lab. The hard copy will be used to help
deliver this presentation during recitation with the team members you worked
grade your oral presentation.</p>
with during lab. The hard copy will be used to help grade your oral
presentation.</p>


<h2>4 MATERIALS AND EQUIPMENT</h2>
<h2>4 MATERIALS AND EQUIPMENT</h2>
Line 135: Line 158:
</ul>
</ul>


<p><b>Remember:</b> You are required to take notes in lab. Experimental details are
<p><b>Remember:</b> You are required to take notes in lab. Experimental details
easily forgotten unless written down. You should keep a laboratory notebook for this purpose.  Each week, you
are easily forgotten unless written down. You should keep a laboratory notebook
<b>must</b> hand in a copy of your lab notes for the Writing Consultant (<b>WC)</b> to review. Keeping
for this purpose.  Each week, you <b>must</b> hand in a copy of your lab notes
careful notes is an essential component of all scientific practice.</p>
for the Writing Consultant (<b>WC)</b> to review. Keepingcareful notes is an
essential component of all engineering and 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>
<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>
<h2>5 PROCEDURE</h2>
Line 146: Line 171:
<h3>Microsoft Word</h3>
<h3>Microsoft Word</h3>


<p>Most software has a built-in reference manual to help you learn
<p>Most software has a built-in reference manual to help you learn the program.
the program. Always look for a Help menu on the toolbar, and use it
For all the Office 2007 products, the help icon is a white question mark in a
whenever you are in doubt about how to do something. This, and regularly saving your work, will save
blue button located at the top right corner of the screen. Use it whenever you
you many lost hours over your working lifetime.</p>
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>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 align=center>[[Image:lab_intro-1.JPG]]</p>
Line 164: Line 191:


<ol>
<ol>
<li>To open Microsoft Word, go to the Start menu, select Lab Menu then select Lab 1 and click on
<li>To open Microsoft Word, click on the Windows icon in the bottom left corner
Microsoft Word.</li>
of the screen, which is the <b><i>Start Menu</i></b>. On the list that appears,
click on the <b><i>Microsoft Office</i></b> menu item. This will expand to
the Office 2007 components. Click the <b><i>Microsoft Office Word 2007</i></b>
menu item.</li>
 
<p align=center>[[Image:lab_intro_2a.png]]</p>
 
<p class=caption>Figure 3: Beginning screen</p>


<p>It is a good idea to use the plain Times New Roman 12 pt font, with full justification as
<p>When Word starts, you'll see the the screen shown in Figure 3. The most
your default, i.e., your starting font and format. Font and paragraph adjustments are located in
important part is the "<b><i>ribbon</i></b>", which all Office
the Format menu on the main menu bar, as well as on the formatting toolbar. The paragraph
products now use. The ribbon has several features. In the extreme top left
alignment buttons looks like this:</p>
corner is the <b><i>Microsoft Office Button</i></b>, where functions that
manage the document are found. These include thinkgs like opening, saving, and
printing a document. Next to the Office button is the <b><i>Quick Access
Toolbar</i></b>, where frequently used functions can be found. Initially, there
are only three icons, corresponding to saving the document, an "undo" of what
you just did because you changed your mind, and an icon that will have Word
repeat what you just did. You can add more items to the Quick Access Toolbar if
you want, but we won't be doing this in this lab. Below the Quick Access
Toolbar is the "<b><i>ribbon</i></b>", where the tools you'll use for the
document are located. At the top of the ribbon are a set of tabs, which is the
high level menu. Each item in the menu is a <b><i>tab</i></b>, which operates
like the tab on a physical folder in a file cabinet. Looking at the tabs, you
can see the functions available. For example, right now you're on the
<b><i>Home</i></b> tab. The area below the tab has several <b><i>groups</i></b>
named at the bottom of the grouped functions. These groups are categories of
functions you can use. Most people will see <b><i>Clipboard, Font, Paragraph,
Styles</i></b>, and <b><i>Editing</i></b> groups.</p>
 
<p>So far all we see is a blank sheet of paper. Some of our work will require
that we know where things are located on this sheet. To help us, click on the
<b><i>View</i></b> tab. This will change the ribbon to what's shown in
Figure 4:</p>
 
<p align=center>[[Image:Lab_intro_2b.png]]</p>
 
<p class=caption>Figure 4: View ribbon</p>
 
<p>On the <b><i>Show/Hide</i></b> group, there's a box next to the word
<b><i>Ruler</i></b>. By clicking on this box, we'll display rulers on the top
and side of electronic paper, allowing us to align things. This will be very
helpful later. Now click on the <b><i>Home</i></b> tab to get back to the
main ribbon.</p>
 
<p>To understand the next part of the ribbon, we need to discuss typography.
A typed letter on a page or displayed on a screen has a number of attributes.
The first is its <b><i>font</i></b>, which is how the letter looks. Fonts come
in two different kinds. The first is a <b><i>serif</i></b> font, meaning that
its letters have small tails and curves that make it look good. However, these
letters tend to be thin to leave room for the extra frills. The alternative
kind is a <b><i>sans serif</i></b> font because the letters do not have this
level of detail. Word has many fonts of both kinds to choose from. The second
attribute a letter has is its size, specified in Word in <b><i>points</i></b>,
which is the height of the letter. A point is 1/48 of an inch, so a 12 point
letter will be 1/4 of an inch high.</p>
 
<p align=center>[[Image:Lab_intro_3_2007.png]]</p>
 
<p class=caption>Figure 5: Font Group</p>
 
<p>Figure 5 shows the <b><i>Font</i></b> group. Notice how all the terms
described in the preceding paragraph are shown, plus more. The default font is
Calibri 11 points, which is very readable, but not formal enough for a report,
and also a little on the small side. Therefore, we'll change it. On the top
left side, you'll see the font name of <b><i>Calibri (Body)</i></b> and next to
it the type size of 11 points. Next to the font name you'll see a small arrow
pointing downwards, indicating that there's a pulldown menu of fonts to choose
from. Click on the arrow, find the <b><i>Times New Roman</i></b> font, and
click on it. The fonts are in alphabetical order, and also show what they look
like. Notice that the font name is now changed. Next, click on the downward
facing arrow next to the size, showing a menu of type sizes. Choose
<b><i>12</i></b> for 12 point type. Times New Roman is the font many newspapers
use because it is very readable, and looks good as well.</p>
 
<p>Finally, we can change how the letters look to add emphasis. We can make
them italics, bold, or underlined. For example, the first time words are
defined in this lab, we make them bold and italics. You can give letters these
special attributes by clicking on the buttons in the Fonts group shown in
Figure 6:</p>
 
<p align=center>[[Image:Lab_intro_3a_2007.png]]</p>
 
<p class=caption>Figure 6: Letter highlighting buttons</p>
 
<p>Next, we can choose how we want paragraphs to look. The paragraph group
is shown in Figure 7:</p>
 
<p align=center>[[Image:Lab_intro_3b_2007.png]]</p>
 
<p class=caption>Figure 7: Paragraph Group</p>
 
<p>First, We can choose how the words fill out the line. The default is
<b><i>left justification</i></b> which means the words start on the left side
of the line and continue until we run out of room, and a new line is started.
This is the way we write. There are other choices. We also have <b><i>centered
justification</i></b>, where the text is centered on the line and if it's
smaller than the line there will be room on both the front and the back. There
is also <b><i>right justification</i></b>, where the line is up against the
right margin, and there is space on the left side. Finally, there is <b><i>full
justification</i></b> where the spacing between the words is increased so that
the words fill up the entire line from side to side. It is a good idea to use
the Times New Roman 12 point font, with full justification as your default,
i.e., your starting font and format. This will give your reports a professional
look. Paragraph adjustments are located in the <b><i>Paragraph</i></b> group.
In the bottom left corner of this group you'll see the justification choices.
The paragraph alignment buttons look like this:</p>


<p>[[Image:lab_intro_3.gif]]</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
<p>For this lab, we're not producing a formal report, so we'll use left
quotes or the italicized attributes:</li>
justfication instead. Click on the leftmost icon of the group (the one that
looks like text that's left justified) to do this. Also, note that if you hold
the cursor over any icon, a small message will pop up telling you what the
icon does. Microsoft calls this <b><i>hovering the cursor</i></b> and every
Microsoft product supports it.</p>


<p>“Section ??�? with the following attributes:<i> Courier New 48pt, aligned right</i></p>
<p>Sometimes we'd like to leave blank space and just move to a specific place
<p>“First TA�? <i>Times New Roman 12pt, aligned right</i></p>
on the line, filling in blank space as needed. In typography, this is called
<p>“Second TA�? <i>Times New Roman 12pt, aligned right</i></p>
a <b><i>tab</i></b>, and Word allows us to set tabs at specific places. This is
<p>“Name�? <i>Arial 24pt, underlined, centered</i></p>
why showing rulers helps. For example, if we right justify text using the
button just described, <b>all</b> the text will be right justified, which might
not be what we want. If we want text to be placed in a specific location, we
create a <b><i>tab stop</i></b>. In the <b><i>Paragraph</i></b> group, click on
the small arrow in the bottom right corner of the group. This brings up a
dialog box that gives us more control over the paragraph. This dialog box is
shown in Figure 8:</p>


<p>“email address�? <i>Courier New 16pt, bold, aligned left</i></p>
<p align=center>[[Image:Lab_intro_3c_2007.png]]</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
<p class=caption>Figure 8: Paragraph control window</p>
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
<p>Click on the <b><i>Tabs...</i></b> button in the bottom left corner of the
fonts (see Figure 3).</p>
window, and a new window shown in Figure 9 will appear:</p>


<p align=center>[[Image:lab_intro_4.gif]]</p>
<p align=center>[[Image:Lab_intro_3d_2007.png]]</p>


<p class=caption>Figure 3: Fonts dialog box</p>
<p class=caption>Figure 9: Tabs window</p>


<p>Use the Paragraph dialog box, found in the Format menu, to get the required alignment (see Figure 4).</p>
<p>You can set left tabs, where the text will start at the position you give,
center tabs, where the text will be centered on the position you give, and
right tabs, where the text will end at the position you give. The way you do
this is you give the place where you want the tab to be in inches, based on the
ruler at the top of the screen. Then you click on one of the <b><i>radio
buttons</i></b> to select the type of tab you want. Then click on the
<b><i>Set</i></b> button to create the tab. You can create more tabs if you
want. When you're done, click on the <b><i>OK</i></b> button.</p>


<p align=center>[[Image:lab_intro_5.gif]]</p>
<p>Next, we can decide how much blank space we want to follow a paragraph.
Once again, we'll open the paragraph control window by clicking on the small
arrow in the bottom right corner of the <b><i>Paragraph</i></b> group. This
opens a new window shown in Figure 10:</p>


<p class=caption>Figure 4: Paragraph dialog box</p>
<p align=center>[[Image:Lab_intro_3e_2007.png]]</p>


<p>Select the line spacing using the Line Spacing menu. Use the following line spacing instructions
<p class=caption>Figure 10: Paragraph spacing window</p>
for your Word document:</p>


<ol type="a">
<p>On the left side of the window, you'll see the <b><i>Spacing</i></b> area,
<li>for all text that is aligned right, use single spacing</li>
showing how much blank space is before and after the paragraph. The current
<li>for all text that is centered, use double spacing</li>
settings show zero points (nothing) before a paragraph and 10 points after it.
<li>for all text that is aligned left, use 1.5-line spacing.</li>
This is a good choice for most work, but we want to change it for this lab.
</ol>
Therefore,  double click on the "10" in the box for the <b><i>After</i></b>
specification, highlighting the number, and type a zero, indicating that no
blank space should follow the paragraph. Now click the <b><i>OK</i></b>
button.</p>
 
<p>We have to set a tab at the right margin. Use the method described
above to set a tab at 6.5 inches, right adjusted, and click the <b><i>OK</i></b>
button.</p>


<li>It is a good idea to periodically save your work. To do this, select Save from the File menu. Name
<p>Finally, check that the paragraphs we're going to create are initially set
the file “lab01generic.doc�? and save it in the “My Documents�? folder on the lab computer. Later, you must
for left justification. If the button that shows left alignment is not
<b>e-mail</b> all the files you create to your personal e-mail account so you can include them
highlighted, click on it to highlight it.</p>
in your lab report.</li>


<li>Now you will insert an equation into the Word document you have created.</li>
<li>Now we're ready to start creating the page. First we'll make an equation.</li>


<ol type="a">
<ol type="a">
<li>Position the cursor just in front of the word "Section" and left click the mouse. A vertical bar will
<li>The cursor should be blinking as a vertical line at the top left corner of
appear, meaning this is where the equation will be placed.</li>
your page. If it's not blinking, click anywhere on the page. The  vertical bar
shows where the equation will be placed.</li>


<li>From the Insert menu select Object. The box shown in Figure 5 will appear.</li>
<li>Click on the <b><i>Insert</i></b> tab. Figure 10 below shows what the
ribbon looks like now. Note that the ribbon changes to things that can be
inserted into the document. The groups are <b><i>Pages, Tables, Illustrations,
Links, Header & Footer, Text</i></b> and <b><i>Symbols</i></b>. In the
<b><i>Symbols</i></b> group you'll see the <b><i>Equation</i></b> icon. For
each of the symbols, there's the name of symbol and an arrow under it. The
arrows show the more common usages of the symbol. Unfortunately, it's rarely
what we will want, so be careful to click on the icon and not the arrow under
it. Click on the <b><i>Equation</i></b> icon and two things happen. The ribbon
changes to the <b><i>Design</i></b> tab on the menu to show things you can use
to make an equation, and on the document an area appears that says <b><i>Type
equation here</i></b>. Figure 11 shows what this looks like.</li>


<p align=center>[[Image:lab_intro_6.gif]]</p>
<p align=center>[[Image:Lab_intro_4_2007.jpg]]</p>


<p class=caption>Figure 5: Object dialog box</p>
<p class=caption>Figure 11: Insert ribbon</p>


<li>Select Microsoft Equation 3.0 from the list and click OK. The Equation
<p>Sometimes, when the <b><i>Design</i></b> tab opens, the equation area will
toolbar shown in Figure 6 will appear.</li>
be in the middle of the page. This means that Word has switched to full
justification to make the quation look pretty. This is not what we want, so
we'll click on the <b><i>Home</i></b> tab, put the paragraph back to left
justification, and return to the <b><i>Design</i></b> tab to continue
working.</p>


<p align=center>[[Image:lab_intro_7.gif]]</p>
<p align=center>[[Image:Lab_intro_5_2007.png]]</p>


<p class=caption>Figure 6: Equation toolbar</p>
<p class=caption>Figure 12: Design ribbon</p>


<li>To insert the desired quadratic equation in the upper left-hand corner of the page, proceed as follows:</li>
<li>To insert the desired quadratic equation in the upper left-hand corner of
the page, proceed as follows:</li>


<ul>
<ul>
<li>Select Text from the Style menu and then begin by typing “x=�? (as usual, without the quotes).</li>
<li>On the left side of the ribbon, you can select the kind of text you want.
Select <b><i>Normal Text</i></b> from the list.</li>
 
<li>Begin by typing “x=�? (as usual, without the quotes).</li>
 
<li>On the right side of the ribbon, you'll see the <b><i>Structures</i></b>
group. Click on the <b><i>Fraction</i></b> icon. This will bring up the
<b><i>Fraction</i></b> palette shown in Figure 13:</li>
 
<p align=center><b><i>[[Image:Lab_intro_6_2007.png]]</i></b></p>
 
<p class=caption>Figure 13: Fraction palette</p>


<li>Select the fraction item from the Equation palette (see Figure 7).</li>
<li>Select the style of fraction you want by clicking on it. In this case we
want the regular vertical fraction, which is the first one shown. Note that the
fraction now appears in your document, with two empty boxes. You click on each
box to fill in the top and bottom of the fraction. We'll start with the
numerator (the top box), so click on it.</li>


<p align=center><b><i>[[Image:lab_intro_8.gif]]</i></b></p>
<li>Type “-b�? and then select the plus-or-minus symbol from the Symbols
group (this is called a <b><i>gallery</i></b> by Microsoft) on the ribbon.
The symbol you want is the very first one shown.</li>


<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>
<li>Click on the <b><i>Radical</i></b> icon from the <b><i>Structures</i></b>
group. Select the square root item from the palette, and click the box
inside the radical on the document so we can fill it in.</li>


<p align=center>[[Image:lab_intro_9.gif]]</p>
<li>To superscript text (necessary for the “2�? in “b<sup>2</sup>�?), click on
the <b><i>Script</i></b> icon. We want the first selection, which is a simple
superscript. The item appears in the equation. Click on the the larger box
and put in the letter "b" term being squared. Next, click on the little box
for the power and put a "2" in it. Next, press the right arrow to move the
cursor right behind the b<sup>2</sup> term, and fill in the rest of the
numerator.</li>


<p class=caption>Figure 8: plus-or-minus symbol</p>
<li>Click on the bottom box to fill in the denominator, and type in the "2a"
term. When you are finished, click outside the equation box to return to the
ordinary word processing mode.</li>
</ul>


<li>Select the radical (square root) symbol from the Equation palette, which is found on the same menu as the fraction item.</li>
<li>Type the text in quotes below, without including the quotes or the
italicized attributes:</li>


<li>To superscript text (necessary for the “2�? in “b<sup>2</sup>�?), go to the super/sub script
<p>Press the tab key and the cursor will jump to the tab you created
menu on the Equation palette (see Figure 9).</li>
on the right margin. Type “Section ??�? and notice how it's filling
in from the right margin. Using the methods we covered earlier, change
this text to the following attributes:<i> Courier New 48 points</i></p>


<p align=center>[[Image:lab_intro_10.gif]]</p>
<p>For the rest of the text, we can align it using the paragraph
justification buttons described earlier.</p>


<p class=caption>Figure 9: super/subscript menu</p>
<li>Now, type more paragraphs and give them the following
attributes:</li>
<p>“First TA�? <i>Times New Roman 12 points, aligned right</i></p>
<p>“Second TA�? <i>Times New Roman 12 points, aligned right</i></p>
<p>“Name�? <i>Arial 24 points, underlined, centered</i></p>


<li>Complete the expression by typing the remaining characters in the appropriate places.  When you are finished, click outside the
<p>“email address�? <i>Courier New 16 points, bold, aligned left</i></p>
equation box to return to the ordinary word processing mode.</li>
<p>“Address�? <i>Times New Roman 12 pionts, aligned left</i></p>
<p>“Phone Number�? <i>Times New Roman 12 points, aligned left</i></p>


<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.
<p>The attributes should be applied to the typed text using the icons and menus
Select "Format Object".</li>
described earlier. 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>


<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>
<p>Select the line spacing using the Line Spacing icon in the
<b><i>Paragraph</i></b> group. This icon is in the middle of the bottom row
of this group, next to the justification icons. It looks like arrows next to
lines of text, a graphical way of indicating spacing. If you hover the cursor
over the icon, it will confirm this. Just select the text you want to control
line spacing for, and then click the icon. Use the following line spacing for
your Word document:</p>


<li> Click and hold down the mouse on the equation. As you move the mouse around, you'll be dragging the equation with you.
<ol type="a">
Drag the equation to the left side of the line and release the mouse. The equation is now where you want it.</li>
<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>


</ul>
<li>It is a good idea to periodically save your work. To do this, click on the
Office button. Click on the Microsoft Office Button, then click on the
<b><i>Save</i></b> menu item. Name the file  “lab01generic�? and save it in the
“My Documents�? folder on your computer. Later, you must convert the files to
Office 2003 format so you can submit them for grading.</li>


</ol>
</ol>
Line 280: Line 497:


<ol type="a">
<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>Position the cursor by putting your mouse directly below the "Phone Number"
<li>From the Table menu select Insert, then Table.The box shown in Figure 10 will appear.</li>
line and clicking it. A vertical bar (the cursor) will appear at the left end
of the line.</li>
 
<li>Click on the <b><i>Insert</i></b> tab to get back the ribbon shown in Figure
10. Click on the <b><i>Table</i></b> icon. The gallery shown in Figure 14 will
appear.</li>
 
<p align=center>[[Image:lab_intro_7a_2007.png]]</p>
 
<p class=caption>Figure 14: Insert Table Gallery</p>
 
<li>You can create small tables by using your mouse to select the desired
number of boxes off of the grid. However, our table will be bigger than the
grid provides. Therefore, click on the "Insert Table..." item at the bottom of
the gallery. This will bring up a window that allows us to build a custom
table. It's shown in Figure 15.</li>
 
<p align=center>[[Image:lab_intro_7b.png]]</p>
 
<p class=caption>Figure 15: Table dialog window</p>
 
<li>For your Word document, select 6 columns and 14 rows, and click OK. This
will create your table and move you to the design ribbon for the table, as
shown in Figure 16:</li>


<p align=center>[[Image:lab_intro_11.gif]]</p>
<p align=center>[[Image:lab_intro_7c.png]]</p>


<p class=caption>Figure 10: Insert Table dialog box</p>
<p class=caption>Figure 16: Table is created in the document</p>


<li>For your Word document, select 6 columns and 14 rows. Make all column and row headings bold and use
<li>Now we need to fill in the cells in the table. Click on the
Arial, 10pt for the text in the table. Center the table on the page.  Label the columns with the five days of the
<b><i>Home</i></b> tab so we can create and edit our text. You can give each
week. Label the rows from 8 AM to 9PM. Each row should contain one hour, e.g. 8:00 – 9:00. However, the row
cell font attributes or fill it in with text by clicking inside the cell with
should not contain the AM or PM identifiers since the context is obvious.</li>
the mouse. You can also give multiple cells the same attributes by dragging
the mouse over them. Make all the cells  Arial, 10 points, center justification
for the text in the table. For the First row and the first column, make these
cells bold text. If the cells have different attributes, Word will only show
you the attributes for the first cell, so it's a good idea to set the
attributes for the cells again even if they seem to be right. 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>
</ol>


<li>Now you will shade the cells and change the borders of your tables. The entire
<li>Now you will shade the cells and change the borders of your tables. The
perimeter of each table should have a double-lined border. The Club Hour cells should be shaded.</li>
entire perimeter of each table should have a double-lined border. The Club Hour
cells should be shaded.</li>


<ol type="a">
<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
<li>Highlight the Club Hour cells (Monday 1:00 pm to 2:00.pm and Wednesday
highlight an individual cell, place the cursor at the left end of the cell.  The cursor will become a black,
12:00 noon to 2:00 pm). To highlight an individual cell, place the cursor at
bolded, angled arrow. Once this arrow appears, click once to highlight the cell.</li>
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>In the <b><i>Paragraph</i></b> group, look for the icon that looks like a
paint can. This is how you "paint" the background of a cell. Click on the arrow
next to the paint can, and the following gallery show in Figure 17 appears:</li>
 
<p align=center>[[Image:lab_intro_7d.png]]</p>
 
<p class=caption>Figure 17: Background color gallery</p>


<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>In the gallery in the first column, hover the cursor to find the paint patch
that shows <i>White, Background 1, Darker 25%</i> and click on it. On the
Format menu, click Borders and Shading. Click the Shading tab and select 25%
gray from the color palette. Next, we'll change the text color. We do this by
clicking on the arrow next to the capital "A" in the bottom right corner of the
<b><i>Paragraph</i></b> group. This brings up the gallery shown in Figure 17
again, but this time the gallery is used to select the text color rather than
the background. Click on the white box in the top left corner. If you hover
your cursor over this box, it will say "White, Background 1". Now type "Club
Hour" in the cell. This will show white text on a gray background.</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>
<li>Now we'll make our table look professional by giving it a double border
around the outside. First, highlight all the cells in the table by dragging
the mouse over them. In the <b><i>Paragraph</i></b> group, look for the icon
in the bottom right corner that's next to the paint can. It looks like a
square. click on the arrow next to it. This brings up the window shown in
Figure 18:</li>
 
<p align=center>[[Image:lab_intro_7e.png]]</p>
 
<p class=caption>Figure 18: Cell formatting menu</p>
 
<li>Click on the last item in the menu: <i>Borders and shading</i>. This will
bring up the window shown in Figure 19:</li>
 
<p align=center>[[Image:lab_intro_7f.png]]</p>
 
<p class=caption>Figure 19: Borders and shading window</p>
 
<li>On the left side of the window are various built-in borders. Click on the
second item in the list: <i>Box</i>. Next, select the type of border we want by
scrolling down the <i>Styles:</i> list until we see the double lines. Click on
it to select it, and click on OK.</li>
 
<li>Now we'll repeat the process for the lines inside the table. Drag the mouse
over the table cells to highlight them if they're not highlighted already.
Click on the arrow next to the <i>Borders and Shading</i> icon you just
selected for the outside. Select the last menu item again, bringing up the
window in Figure 19. For the <i>Styles</i>, scroll up to the top of the lines
and select the single line. In the <b><i>Preview</i></b> pane on the right of
the window you see an abstract version of your table, showing the double line
on the outside and nothing on the inside. CLick in the middle of the table and
the solid lines will appear. Click OK and the table is complete.</li>
</ol>
</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>Save the changes that have been made by selecting <b><i>Save</i></b> from
inside the <b><i>Microsoft Office Button</i></b>.</li>


<li>Finally, you will learn to use Word Art.</li>
<li>Finally, you will learn to use WordArt.</li>


<ol type="a">
<ol type="a">
Line 314: Line 614:
<li>Place the cursor where you want your object to appear.</li>
<li>Place the cursor where you want your object to appear.</li>


<li>On the Insert menu, select Picture, then Word Art.</li>
<li>Click on the <b><i>Insert</i></b> to get the proper ribbon. On the right
side is the <b><i>WordArt</i></b> icon. 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>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>
<li>Type “EG1004�? in the box that appears. Click OK.</li>
 
<li>If the WordArt is left adjusted, you can put it in the center of the line
by clicking on the <b><i>Home</i></b> tab and selecting the centered
justification in the <b><i>Paragraph</i></b> group.</li>
</ol>
</ol>


<li>Save the document again.</li>
<li>Save the document again.</li>
<li>Since you have to submit this document, you need to save it again using the
Word 2003 format. To do this, click on the <b><i>Microsoft Office Button</i></b>
and select <i>Save As...</i> off the menu. On the window that comes up, use a
file name of “lab01generic�? like you did before, but this time, on the "Save as
type" menu below it click on the arrow on the right, and select "Word 97-2003".
Click OK and the document will be saved in Word 2003 format as well. Since Word
2007 has more functionality than Word 2003, especially with equations, you
might get a window warning you of compatibility issues. Since we're done with
this document, this is OK, so just click the OK button to continue.</li>


<li>Now it is time to personalize your document.</li>
<li>Now it is time to personalize your document.</li>


<ol type="a">
<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
<li>Select <b><i>Save As</i></b> from the <b><i>File</i></b> menu.  Name the
in the “My Documents�? folder on the lab computer.</li>
file “lab01personal.doc�? and save it in the “My Documents�? folder on the lab
computer. This will save the document in Word 2003 format as well, which is
what we want.</li>


<li>Personalize the generic document you just created, keeping the appropriate attributes.</li>
<li>Personalize the generic document you just created, keeping the appropriate
attributes.</li>


<li>Save this new file.</li>
<li>Save this new file.</li>
Line 340: Line 660:
<ol>
<ol>
<li>Put the cursor where you would like the comment inserted.</li>
<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>Click on the <b><i>Review</i></b> tab. The ribbon shown in Figure 20 will
<li>Type the text for the comment. You can see the text in the box at the bottom of the screen.</li>
appear:</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>.
<p align=center>[[Image:lab_intro_7g.png]]</p>
 
<p class=caption>Figure 20: Review ribbon</p>
 
<li>Click the <b><i>New Comment</i></b> icon in the <b><i>Comments</i></b>
group. The text under the cursor will be surrounded by a red box with a
connector to a box outside the document where you can type your comment. The
cursor is there, so you can type your comment. Type "Argh!" and you'll see it
in the comment box.</li>
 
<li>Click anywhere in the document outside the comment area to finish. Note
that in the <b><i>Tracking</i></b> group on the right side "Final Showing
Markup" is highlighted so you can see comments. If you don't want to see the
comments, click on the arrow to the right, and select the <b><i>Final</i></b>
menu item to show the document like it was.</li>
 
<li>We'll show the comment again by clicking on the arrow to the right of the
<b><i>Final</i></b> word and setting the view back to "Final Showing Markup"
by clicking on that menu item. The comment is now back. We can deleted the
comment by putting the mouse over the comment, right clicking the mouse, and
selecting <b><i>Delete Comment</i></b> on the menu that pops up.</li>


</ol>
</ol>


<p><b><i>Microsoft Excel</i></b></p>
<h3>Microsoft Excel</h3>
 
<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 21.</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 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 class=caption>Figure 21: Excel Document</p>
 
<p>To open Microsoft Excel, go to the Start menu, select <b><i>Microsoft
Office</i></b> and <b><i>Microsoft Office Excel 2007</i></b>. Excel will start,
and the home ribbon for Excel will appear, as shown in Figure 22:</p>
 
<p align=center>[[Image:lab_intro_12a.png]]</p>
 
<p class=caption>Figure 22: Excel home ribbon</p>


<p><b>Creating a Header</b></p>
<h4>Creating a Header</h4>


<ol>
<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>
<li>In the new, blank workbook that opens, select the <b><i>Page Layout</i></b>
menu and click on the Custom Header button (See Figure 12).</li>
tab. This will bring up the ribbon shown in Figure 23:</li>
 
<p align=center>[[Image:lab_intro_13_2007.png]]</p>


<p align=center>[[Image:lab_intro_13.jpg]]</p>
<p class=caption>Figure 23: Page Layout ribbon</p>


<p class=caption>Figure 12: Custom Header dialog box</p>
<li>In the <b><i>Sheet Options</i></b> group, click on the arrow in the bottom
right corner of the group. This will bring up the <b><i>Page Setup</i></b>
window. Click on the <b><i>Header/Footer</i></b> tab. Click on the button that
says <b><i>Custom Header</i></b>. Three windows will appear corresponding to
the left, center and right of the header you want at the top of your page. Fill
in the sections as follows:</li>
<ul>
<li>Left section: your name.</li>
<li>Center section: “Lab 1: Excel Exercise.�?</li>
<li>Right section: your section.</li>
</ul>


<li>In the Left section: box type your name.  In the Center section: box type “Lab 1: Excel Exercise.�?  In the Right section:
<li>Click "OK" to save this information. Click "OK" again to remove the "Page
box type your section. Click "OK" to save this information. Click "OK" again to remove the "Page Setup" window and return to
Setup" window and return to the spreadsheet.</li>
the spreadsheet.</li>
</ol>
</ol>


<p><b>Note</b>: <i>The Header is not visible on the Excel spreadsheet as you work; it is
<p><b>Note</b>: <i>The Header is not visible on the Excel spreadsheet as you
inserted when the sheet is printed. You
work; it is inserted when the sheet is printed. To preview the final document,
can use the </i>Print Preview<i> in the<b> </b></i>File menu<i> to preview the final
click on the <b>Microsoft Office Button</b>, then the <b>Print</b> icon, and
then the <b>Print Preview</b> icon on the popup menu. to preview the final
document.</i></p>
document.</i></p>


<p><b>Setting up Your Worksheet</b></p>
<h4>Setting up Your Worksheet</h4>


<p>To complete the exercise, you will create two tables. The first one is a table of constants. To create it, enter the
<p><b>Note:</b> When you enter data into Excel, it is not unusual for the data
following information into your Excel worksheet:</p>
to not fit into the cell initially, making it look like the data is overrunning
into the next cell. Don't worry about this - you can resize the cell later so
the data fill fit.</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>
<ol>
Line 395: Line 763:
<li>In cell <b><i>B3 </i></b>enter <b><i>0.082057</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>C3</i></b>, enter <b><i>L*atm*mol<sup>-1</sup>*K<sup>-1</sup></i></b></li>
<p><b>Note:</b> To make superscripts (powers), highlight what you want to
make a superscript with your mouse in the area just below the ribbon. Then
click on the <b><i>Home</i></b> tab and click on the arrow at the bottom right
of the <b><i>Fonts</i></b> group. The <b><i>Format Cells</i></b> popup window
will appear. Click on the <b><i>Superscript</i></b> box on the left side. Click
the OK button and you're done. You won't see the superscript in this area, but
you will see it if you look at the cell.</p>


<li>In cell <b><i>A4</i></b>, enter <b><i>P</i></b></li>
<li>In cell <b><i>A4</i></b>, enter <b><i>P</i></b></li>
Line 401: Line 777:
</ol>
</ol>


<p>To create the superscripted text necessary for cell <b><i>C3</i></b>, highlight the text you want
<p><b>Note:</b> In the next few cells, you'll be inserting the degree symbol.
superscripted and select Cells from the Format menu. Check the superscript box.</p>
When the time comes to do this, click on the <b><i>Insert</i></b> tab, and
click on the <b><i>Symbol</i></b> icon. This will bring up the Symbol pallette
shown in Figure 24:</p>
 
<p align=center>[[Image:lab_intro_13a_2007.png]]</p>
 
<p class=caption>Figure 24: Symbol pallette</p>
 


<p><b>Note:</b>In the next few cells, you'll be inserting the degree symbol. To do this, just type all
<p>Make sure the <b><i>Symbol</i></b> font is being shown. If it isn't, click
the text except the degree symbol, and then come back and insert the degree symbol using the instructions
on the arrow to the right to show all the fonts, and select Symbol. Next,
in the next note.</p>
scroll down the pallette until you see the degree symbol. You do this by
clicking on the scroll bar on the right side. The degree symbol is the first
symbol in the ninth row. The symbol pallette with this symbol selected is
shown in Figure 25:</p>


<p>Next, you will create a table of computed values.  To do this, type the following text into your
<p align=center>[[Image:lab_intro_13b_2007.png]]</p>
Excel worksheet:</p>
 
<p class=caption>Figure 25: Symbol pallette with degree symbol selected</p>
 
<p>Now, click on the <b><i>Insert</i></b> button and the symbol will be
inserted into the text. Finally, click on the <b><i>Close</i></b> button to
close the pallette.</p>
 
<p>Next, we'll create a table of computed values.  To do this, type the
following text into your Excel worksheet:</p>


<ol>
<ol>
Line 418: Line 812:
</ol>
</ol>


<p><b>Note:</b> To insert the <b>&#730;</b> symbol, pull down the Insert menu and choose the Symbol Palette.
<p>Enter Fahrenheit temperatures 0 – 45 &#730;F into cells <b><i>A7</i></b>
Choose the appropriate symbol and click Insert.</p>
through <b><i>A16</i></b>, increasing the temperature by 5 &#730;F in each
successive cell.</p>
 
<h4>Using Formulas</h4>
 
<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>Enter Fahrenheit temperatures 0 – 45 &#730;F into cells <b><i>A7</i></b> through <b><i>A16</i></b>,
<p>As an example of the syntax, the formula
increasing the temperature by 5 &#730;F in each successive cell.</p>
“= 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
parentheses to make sure the result is calculated correctly. The full range of
functions can be selected clicking on the <b><i>Formulas</i></b> tab. This
brings up the ribbon shown in Figure 26:</p>


<p><b>Using Formulas</b></p>
<p align=center>[[Image:lab_intro_13c_2007.png]]</p>


<p>Formulas perform calculations in your worksheet.  The calculations may use values in other cells, making
<p class=caption>Figure 26: Formulas ribbon</p>
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
<p>There are several ways to choose the formula you want and you don't know its
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
name. The first way is to click on the <b><i>Insert function</i></b> icon at
cell <b><i>X15</i></b> divided by 0.34. If you are in doubt about the order of the mathematical operations,
the left end of the ribbon. At the top of the dialog box that pops up, there's
use brackets to make sure the result is calculated correctly. The full range of functions can be selected from
a place where you can type the description of what you're looking for and Excel
the formula menu or by using the <b><i>fx </i></b>button on the toolbar<b><i>.</i></b></p>
will show matches. If you have a pretty good idea of what type of function you
want, you can use the colored book icons along the top of the ribbon. Just
click on the icon for the category you want and then choose the function from
the list.</p>


<p>You will use the following expression to convert your simulated data into degrees Celsius:</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>
<p align=center>[[Image:lab_intro_14.gif]]</p>
Line 444: Line 855:
<li>Enter “=5/9*(<b><i>A7</i></b>-32)�? into cell <b><i>B7</i></b>.</li>
<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)
<li>Now we'll copy the formula into other cells. To do this, click on the cell.
all the way down to cell <b><i>B16.</i></b></li>
Click on the <b><i>Home</i></b>tab on the ribbon. Click on the
<b><i>Copy</i></b> icon at the left end of the ribbon. highlight cells
<b><i>B8</i></b> through <b><i>B16</i></b> by dragging the mouse over them.
Click on the <b><i>Paste</i></b> icon that looks like a clipboard at the left
end of the ribbon.</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
<li>Click on the cells between <b><i>B7</i></b> and <b><i>B16</i></b> one at a
cell reference in the formula has automatically been adjusted in each destination cell.</li>
time and examine the contents. Notice that the cell reference in the formula
has automatically been adjusted in each destination cell.</li>
</ol>
</ol>


<p>You will then use the following expression to convert your data into Kelvin:</p>
<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>
<p align=center><sub>[[Image:lab_intro_15.gif]]</sub></p>
Line 458: Line 875:
<li>Enter “=<b><i>B7</i></b>+273.15�? into cell <b><i>C7</i></b>.</li>
<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>
<li>Copy this formula into the cells <b><i>C8</i></b> through <b><i>C16</i></b>
and then dragging the fill handle all the way to cell <b><i>C16</i></b>.<b><i></i></b></li>
using the same method we used earlier.</li>


<li>Click on the cell <b><i>C16 </i></b>and look at the contents.  Notice that the cell reference in the formula
<li>Click on the cell <b><i>C16 </i></b>and look at the contents.  Notice that
(<b><i>B7</i></b>) has automatically been adjusted to <b><i>B16</i></b>.</li>
the cell reference in the formula (<b><i>B7</i></b>) has automatically been
adjusted to <b><i>B16</i></b>.</li>


</ol>
</ol>


<p>You will use the ideal gas law expression to compute the volume for your exercise:</p>
<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>
<p align=center>[[Image:lab_intro_16.gif]]</p>


<ol>
<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>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
<li>Copy this formula into the cells <b><i>D8</i></b> through <b><i>D16</i></b>
then dragging the fill handle all the way to cell <b><i>D16</i></b>.<b><i></i></b></li>
using the same method we used earlier.</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
<li>Click on cell <b><i>D16 </i></b>and notice that all the cell references
kept constant.  Typing a <b><i>$</i></b> before a cell reference letter or number fixes the value, even if is
except <b><i>C7</i></b> have been kept constant.  Typing a <b><i>$</i></b>
it later copied. Two <b><i>$</i></b> keeps both the cell letter and the cell number constant.</li>
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>
</ol>


<p><b>Formatting Your Tables</b></p>
<h4>Formatting Your Tables</h4>


<p>First, you need to be able to see the entire contents of each column. By default, Excel sets all columns to
<p>First, you need to be able to see the entire contents of each column. By
the same width, and fields containing long strings of data can be obstructed by other columns.  However, Excel
default, Excel sets all columns to the same width, and fields containing long
can resize each column to make all the data it contains visible. Always review your data and decide if the number
strings of data can be obstructed by other columns.  However, Excel can resize
of digits displayed in the worksheet is appropriate.</p>
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.
Start by making sure no cells are highlighted. If there are, just click on
any cell so that just the usual outline box is present.</p>


<ol>
<ol>
<li>Double-click the right edge of the column (see Figure 13).</li>
<li>Move the cursor up to the top of the spreadsheet and hover the cursor
between the <b><i>A</i></b> and <b><i>B</i></b> column headers. Note that the
cursor changes to a vertical line with an arrow on each side, as shown in
Figure 27:</li>


<p align=center>[[Image:lab_intro_17.gif]]</p>
<p align=center>[[Image:lab_intro_17.gif]]</p>
<p class=caption>Figure 13: Column Edge</p>
<p class=caption>Figure 27: Column Edge</p>
 
</li>Double click on the boundary between the column headers and the width of
the column to the left will automatically resize. Do this for the other columns
as well</li>


<li>In our example two digits after the decimal point is appropriate. Adjust the display by highlighting the
<li>In our example two digits after the decimal point is appropriate. Adjust
data cells B7:D16 and selecting the tab under Cells in the Format menu.</li>
the display by highlighting the data cells B7:D16 (drag the mouse). Click on the
arrow in the bottom right corner of the <b><i>Font</i></b> group in the
<b><i>Home</i></b> tab to bring up the <b><i>Format Cells</i></b> dialog box
shown in Figure 28:</li>


<li>Select number and two decimal places from the menu. You may also do this by using the increase decimal
<p align=center>[[Image:Lab_intro_17a.png]]</p>
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
<p class=caption>Figure 28: Format Cells dialog box</p>
to hold so many places. Resize the column by double clicking the right edge of the column again.</li>
 
<li>Click on the <b><i>Number</i></b> tab in the dialog box. In the
<b><i>Category</i></b> list, click on the <b><i>Number</i></b> item and the
window will change to allow you to format numbers. Note that the number of
decimal places is 2, which is what you want. Click on the <b><i>OK</i></b>
button and you're done.</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. Make sure no cells
are highlighted and resize the column by double clicking the right edge of
the column again.</li>
</ol>
</ol>


<p><b>Creating Table Borders</b></p>
<h4>Creating Table Borders</h4>
 
<p>As part of this section, you'll see a different way to work with cells.</p>


<ol>
<ol>
<li>In your Excel worksheet, highlight the table of constants (cells A1-C4), and right-click within the
<li>In your Excel worksheet, highlight the table of constants (cells A1-C4),
highlighted area.</li>
and right click within the highlighted area.</li>
 
<li>From the dialog box that appears, select Format Cells. This will bring up
the same <b><i>Format Cells</i></b> dialog box that you saw before.</li>


<li>From the context menu that appears, select Format Cells.</li>
<li>In the Format Cells dialog box, go to the Border tab. This will change the
dialog box to what's shown in Figure 29:</li>


<li>In the Format Cells dialog box, go to the Border tab.</li>
<p align=center>[[Image:Lab_intro_17b.png]]</p>


<li>Make the constant table professional looking by selecting the double lines in the bottom right corner of
<p class=caption>Figure 29: Format Cells dialog box: border tab</p>
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
<li>Make the constant table professional looking by selecting the double lines
right click within the highligted area. Like before, select Format Cells from the context menu that appears and go
in the bottom right corner of the "Style", and the "Outline" preset. Now we'll
to the Border tab. Select the double lines in the bottom right corner of "Style" and the "Outline" present. Next, we'd
put grid lines inside by selecting the single line in the bottom left corner of
like to shade the column headers so they stand out more. Click on the "Pattern" tab and select the 25% gray box (next
"Style", and the "Inside" present. The preview picture will now show a grid
to last row on the extreme right side, just above the right box. Click "OK", and you'll see that the column headers
with a double line frame and single line inside lines. Click "OK", and you'll
now have their own frame and shading.</li>
now see the table of constants being nicely framed.</li>


<li>Repeat steps 1-5 for the table of computations.</li>
<li>Next, we'd like to separate the column headers from the numbers. Highlight
</ol>
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 "Fill" tab and the dialog box will change to
Figure 30:</li>


<p align=center>[[Image:lab_intro_18.gif]]</p>
<p align=center>[[Image:Lab_intro_17c.png]]</p>
<p class=caption>Figure 14: Format Cells dialog box</p>


<p><b>Creating a Chart</b></p>
<p class=caption>Figure 30: Format Cells dialog box: fill tab</p>


<p>As the final step in this exercise, you will be graphing the relationship between volume and temperature,
<li>Select the gray box in the middle row on the left side, which will be 25%
using the Chart feature in Excel. To create a chart:</p>
darker. Click "OK", and you'll see that the column headers now have their own
frame and shading.</li>


<ol>
<li>Repeat steps 1-5 for the table of computations.</li>
<li>Select the volume values in cells <b><i>D7–D16</i></b>.</li>
</ol>


<li>Click the Chart Wizard button.[[Image:lab_intro_19.gif]]</li>
<h4>Creating a Chart</h4>


<li>In the Chart Type dialog box, select XY (Scatter) chart type and leave the chart subtype
<p>As the final step in this exercise, you will be graphing the relationship
at the default setting (see Figure 15), then click Next.</li>
between volume and temperature, using the Chart feature in Excel. To create a
chart:</p>


<p align=center>[[Image:lab_intro_20.gif]]</p>
<ol>
<p class=caption>Figure 15: Chart Type dialog box</p>
<li>Select the temperature and volume values in cells <b><i>C7–D16</i></b>.</li>


<li>In the Chart Source dialog box, select the Series tab, as shown in Figure 16.</li>
<li>Click on the <b><i>Insert</i></b> tab on the ribbon. The ribbon will change
to what's shown in Figure 31:</li>


<p align=center>[[Image:lab_intro_21.gif]]</p>
<p align=center>[[Image:Lab_intro_17d.png]]</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>
<p class=caption>Figure 31: Insert ribbon</p>
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>
<li>The <b><i>Chart</i></b> group is in the middle of the ribbon. Click on the
<b><i>Scatter</i></b> icon. This will bring up the pallette shown in Figure 32:</li>


<p align=center>[[Image:lab_intro_22.gif]]</p>
<p align=center>[[Image:Lab_intro_17e.png]]</p>


<p class=caption>Figure 17: Chart Options dialog box</p>
<p class=caption>Figure 32:Scatter chart pallette</p>


<li>In the Chart Title: field, enter <b><i>Volume (L) vs. Temperature (K).</i></b></li>
<li>On the pallette, click on the first icon: Scatter with only markers.</li>


<li>In the Value(X) axis: field, enter <b><i>Temperature (K)</i></b>.</li>
<li>The chart appears on your spreadsheet, and the ribbon changes to the
<b><i>Design</i></b> tab so you can customize your chart, as shown in
Figure 33:</li>


<li>In the Value (Y) axis: field, enter <b><i>Volume (L)</i></b>.</li>
<p align=center>[[Image:Lab_intro_17f.png]]</p>


<li>Click Next and the Chart Location dialog box will appear (see Figure 18).</li>
<p class=caption>Figure 33:Design ribbon for chart</p>


<p align=center>[[Image:lab_intro_23.gif]]</p>
<li>The chart points are probably blue, which don't print well on a black and
white printer. If you look at the ribbon, the chart style is probably "Style
2". Click on "Style 1" and you'll get black points, which will print
better.</li>


<p class=caption>Figure 18: Chart Location dialog box</p>
<li>Now we'll customize the chart by adding the axis labels and title. In the
<b><i>Chart Layouts</i></b> group, hover the cursor over the first icon, and
the caption "Layout 1" will appear. This is the layout we want, so click on the
icon.</li>


<li>In the Chart Location dialog box, select As object in.</li>
<li>Click on the vertical axis title. Highlight the existing text that says
"Axis Title" and change it to "Volume (L)".</li>


<li>From the drop-down menu, select your current worksheet (see Figure 18).</li>
<li>Click on the horizontal axis title. Highlight the existing text that says
"Axis Title"and change it to "Temperature (K)".</li>


<li>Click Finish to create your chart.</li>
<li>Click on the title. Highlight the existing text that says "Chart Title" and
change it to "Volume (L) vs. Temperature (K)".</li>


<li>Delete the Series 1 Legend box from your chart. Click on the Legend box and it
<li>Click on the <b><i>Series 1</i></b> text on the right side, which is the
will be highlighted by having squares on it. Press the delete key to delete the box.</li>
chart legend. We don't need a legend for this chart. Put the cursor over the
</ol>
data point in front of the words and the cursor will change to a crosshair with
arrows. Press the <b><i>Delete</i></b> key and the legend will disappear. The
chart will also automatically resize to fill the space.</li>


<p><b>Adding a Trendline</b></p>
<h4>Adding a Trendline</h4>


<p>A trendline is a fit to data, indicating the general behavioral tendency or trend
<p>A trendline is a fit to data, indicating the general behavioral tendency or
of the data, if any. This allows you to more easily see the nature of any
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
relationship between the quantities in your graph. To add a trendline to your
chart:</p>
chart:</p>


<ol>
<ol>
<li>Select any data point on your chart. Excel will automatically select all remaining points for you.</li>
<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
<b><i>Add Trendline...</i></b>. This will bring up the dialog box shown in
Figure 34:</li>
 
<p align=center>[[Image:Lab_intro_17g.png]]</p>


<li>Right-click within the chart. From the context menu that appears, select Add Trendline.</li>
<p class=caption>Figure 34: Format Tendline dialog box</p>


<li>In the Type tab, select the Linear trend type.</li>
<li>As you can see, there are a lot of options. Fortunately, the defaults are
exactly what we want, so just click the <b><i>Close</i></b> button. The chart
now has the trendline we want.</li>
</ol>
</ol>


<p><b>Adding a Caption to Your Chart</b></p>
<h4>Adding a Caption to Your Chart</h4>


<ol>
<ol>
<li>Reposition the chart within your worksheet so that it does not obstruct your data tables. Do this
<li>Reposition the chart within your worksheet so that it does not obstruct
by clicking anywhere on the chart. Squares will appear around the border of the chart indicating that it
your data tables. Do this by clicking anywhere on the chart. Squares will
has been selected. Click the mouse, and "drag" the chart to where you want it, which is typically on the
appear around the border of the chart indicating that it has been selected.
left edge of the spreadsheet, with one row between the bottom of the data table and the top of the chart.</li>
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
<li>Select a set of cells beneath your graph roughly the same width as the
want the caption to begin, and right-click within the selected group of cells. From the context menu
graph, starting where you want the caption to begin, and right click within the
that appears, select Format Cells.</li>
selected group of cells. From the context menu that appears, select Format
Cells. The <b><i>Format Cells</i></b> dialog box that you saw earlier appears.
Click on the <b><i>Alignment</i></b> tab</li>, and the dialog box changes to
Figure 35:</li>


<li>In the Alignment tab, check the Wrap Text and Merge Cells checkboxes, and click OK.</li>
<p align=center>[[Image:Lab_intro_17h.png]]</p>


<li>Enter a suitable caption for your chart.</li>
<p class=caption>Figure 35: Alignment dialog box</p>


<li>Save your worksheet as “lab01excel.xls�? and print a copy on a single page.</li>
<li>In the <b><i>Text alignment</i></b> area, for <b><i>Horizontal</i></b>,
click on the arrow to the right of the word "Automatic" and a dropdown menu
appears. Click on <b><i>Center</i></b>.</li>
 
<li>In the <b><i>Text control</i></b> area, check the Wrap Text and Merge Cells
checkboxes, and click <b><i>OK</i></b>.</li>
 
<li>In the highlighted cells, enter a suitable caption for your chart.</li>
 
<li>Since we're done with the worksheet, we'll save it in Office 2003 format
for submission. Click on the <b><i>Microsoft Office</i></b> button. Click the
"Save As" icon. Change the "Save as Type" to "Excel 97-2003 Workbook", and use
a File Name of “lab01excel.xls�?. Print a copy of the sheet as well by clicking
again on the <b><i>Microsoft Office</i></b> button, clicking the
<b><i>Print</i></b> icon, and clicking the <b><i>OK</i></b> button on the
<b><i>Print</i></b> dialog box that comes up.</li>
</ol>
</ol>


<h3>Microsoft PowerPoint</h3>


<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
<p>Now you will create a PowerPoint presentation reporting on the work done in <b><i>Lab 1</i></b>.
one slide at a time, Outline View lists the text for each slide in your
PowerPoint has five viewing windows. Slide View displays one slide at a time, Outline View lists
presentation, Slide Shorter View displays thumbnails of all your slides
the text for each slide in your presentation, Slide Shorter View displays thumbnails of all your
allowing you to reorder them easily, and Notes Page View lets you attach text
slides allowing you to reorder them easily, and Notes Page View lets you attach text to each slide.
to each slide. Finally, you can view your slides in order in the Slide Show
Finally, you can view your slides in order in the Slide Show View.</p>
View.</p>


<p>For this lab, your presentation must include a title slide, a
<p>For this lab, your presentation must include a title slide, a
Line 635: Line 1,129:
and a conclusion slide. You may use any design template that you like. Use a
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
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
the information that follows. Figure 36 contains some examples of what your
slides might look like.</p>
slides might look like.</p>


<p align=center>[[Image:lab_intro_24.gif]]</p>
<p align=center>[[Image:lab_intro_24.gif]]</p>


<p class=caption>Figure 19: Typical PowerPoint slides</p>
<p class=caption>Figure 36: Typical PowerPoint slides</p>


<p>To open Microsoft PowerPoint, go to the Start menu, select Lab Menu then select Lab 1 and
<ol>
click on Microsoft PowerPoint.</p>
<li>To open Microsoft PowerPoint, go to the Start menu, select <b><i>Microsoft
Office</i></b> and <b><i>Microsoft Office PowerPoint 2007</i></b>. PowerPoint
will start. A new slide will appear with the default Title layout (see Figure
37). Click where it says, “Click to add title�? and enter the title of your
presentation.</li>


<ol>
<p align=center>[[Image:Lab_intro_25_2007.png]]</p>
<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 37: Microsoft PowerPoint, main window. Your screen will
look like this when you begin a new presentation.</p>


<p class=caption>Figure 20: Microsoft PowerPoint, main window. Your screen will look like
<li>From the <b><i>Slide</i></b> group, click on the <b><i>New Slide</i></b>
this when you begin a new presentation.</p>
icon. This will advance your presentation to the next slide, which will be
blank. When you select this, PowerPoint will display a number of atlernatives
for you to choose from on how to layout your next slide. Choose the one you
like best.</li>


<li>From the Insert menu, select New Slide (CTRL+M). Click on the new slide. Type the title of
<li>Click anywhere inside the box marked "Click to Add Text" and insert your
the next slide. Click anywhere inside the box marked Click to Add Text and insert your information.
information. Continue this process until you have outlined your entire
Continue this process until you have outlined your entire presentation.</li>
presentation.</li>


<li>To add an object from another software application, like Word or Excel, simply copy and paste
<li>To add an object from another software application, like Word or Excel,
your object onto the selected PowerPoint slide.</li>
simply copy and paste your object onto the selected PowerPoint slide.</li>
</ol>
</ol>


<p>Microsoft PowerPoint allows you to customize the design of your presentation. You can
<p>Microsoft PowerPoint allows you to customize the design of your
choose a design template in two ways depending on whether you are just starting your presentation
presentation.</p>
or have already created it.</p>


<p>To select a design template before you begin, select Design Template from the choices that appear
<p>To select a design template before you begin, click on the
when you create a new file. Select the particular design template you would like to use for
<b><i>Design</i></b> tab on the ribbon. The <b><i>Themes</i></b> group will
your presentation.</p>
show the slide themes you currently have available. Initially, it is a rather
limited selection. However, there are hundreds of themes available. Sample
slides of each therme are shown in teh group. To have a wider selection, click
on the downward facing arrow just to the right of the sample slides, to the
left of the icons for Colors, Fonts, and Effects. This will bring up the dialog
box shown in Figure 38:


<p>To select a design template after you start, open the presentation, pull down the Format
<p align=center>[[Image:lab_intro_25a_2007.png]]</p>
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
<p class=caption>Figure 38: Theme dialog box</p>
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>In addition to seeing the themes you already have, there is also a selection
<p>Make sure you run Spell Check when you have completed your presentation! To run it, hit F7. After making any
of how to acquire more. Click on the message "More Themes on Microsoft Office
corrections, save your presentation as “lab01PowerPoint.ppt.�?</p>
Online..." and you'll be directed to the Microsoft Web site that is an archive
of many templates for all the Office products. AIn the top left corner of the
Web page you'll see a group called <b><i>Search</i></b> Just below the word
"Templates" there's a line where you can enter text saying what you want to
search for. For example, if you want to use a theme with a space orientation,
type in "slides space" and click on the <b><i>Search</i></b> icon. This will
bring up the first 100 themes related to space, 14 at a time. You should be
able to find a theme you like on almost any subject.</p>


<p>To print a copy of your PowerPoint Presentation:</p>
<p><b>Note:</b> <i>The <b>Design</b> tab also allows you to adjust your color
schemes too. Click on the <b>Colors</b> icon on the right side of the
<b>Themes</b> group. From the dialog box that appears you can select a
predefined color scheme, or design one of your own. Remember to choose a scheme
that has a high contrast between the leteters on the slide and the background
so that your audience can read the slides easily. The built-in schemes are
designed to do this.</i></p>
 
<h4><font color=#ff0000>IMPORTANT</font></h4>
 
<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.�? Remember to save it as an Office 97-2003 presentation so
it can be submitted electronically.</p>
 
<p>You can print a copy of your presentation just like Word and Excel. To print
a copy of your PowerPoint Presentation:</p>


<ol>
<ol>
<li>Click on the Microsoft Office button. From the menu that appears, click on
the <b><i>Print</i></p> icon. The box in Figure 39 will appear.</li>


<li>From the File menu select Print. The box in Figure 21 will appear.</li>
<p align=center>[[Image:lab_intro_26_2007.png]]</p>
 
<p align=center>[[Image:lab_intro_26.gif]]</p>


<p class=caption>Figure 21: Microsoft PowerPoint Print dialog box.</p>
<p class=caption>Figure 39: 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 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 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>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>
<li>Click OK to print.</li>
</ol>
</ol>


<p>Your lab work is now complete. <b>e-mail</b> copies of all the files you created to your personal account.
<p>Your lab work is now complete. <b>e-mail</b> copies of all the files you
Review the files for errors before submitting your report.</p>
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
<p>Please clean up your workstation before you leave the lab. Refer to section
the list of the specific items you must submit for your report.</p>
<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]]
[[Main_Page | Return to Table of Contents]]

Revision as of 04:01, 20 May 2007

EG1004 Lab 1: Software for Engineers I (Office 2007 Version)

Important: Please note before performing the lab you must register on the EG1004 Web site.

  • Click on the register button as shown on the following screen:
  • Lab intro 27.png

  • Fill in the appropriate information on the form that pops up and submit is, as shown on the following screen:
  • Lab intro 28.png

1 OBJECTIVES

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.

2 OVERVIEW

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 EG1004. 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.

Like many other installations, EG1004 has a huge amount of software written to support products that are part of Office. All of this software is currently written for Office 2003. Again, like many other installations, the EG1004 staff is converting this software to operate with Office 2007. However, this is a huge effort. Also, since many students take EG1004 from different class years, some students may have Office 2003 and others Office 2007. Office 2007 can read Office 2003 files, but the opposite conversion does not always work. Therefore, for the foreseeable future, you will have to submit your work in Office 2003 format. Fortunately, this is easy to do; when you're preparing to submit something to the EG1004 Web site or other destinations, instead of saving the document using the "Save" menu item, you'll be using the "Save As" item instead, selecting the Office 2003 version as the file type. Details on how to do this will be in the appropriate places later in this lab.


Microsoft Word

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 course assignments) yourself, unless you are specifically told otherwise, e.g., when you do a team report.

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.

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. On the top menu, select the Review tab. Then click on the Thesaurus icon, which looks like a book. The equivalent words (synonyms) will be shown on the right side of the screen. Just double click on the one you want to select.

Microsoft Excel

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.

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.

Microsoft PowerPoint

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.

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 EG1004, you will use PowerPoint to report on your lab work and to present your progress on your Semester Long Design Project.

These software tools are essential to your success in EG1004 and beyond. This lab is designed to help you master them by having you perform a specific set of tasks.

3 YOUR ASSIGNMENT

Individual Lab Report

There is no formal write-up for this lab report. Instead, you will submit:

  • A title page
  • Your Microsoft Word exercise (personalized schedule and non-personalized schedule)
  • Note: The title page and Microsoft 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, select the Insert tab on the top menu, and then click on the Page Break icon.

  • Your Microsoft Excel exercise (table and graph). Submit the Excel file, which has an .xls file extension, by itself, not as part of a Word document.
  • Your Microsoft PowerPoint exercise. Submit the PowerPoint file, which has a .ppt file extension, by itself, not as part of a Word document.

IMPORTANT Submit your report electronically using the EG1004 website: http://eg.poly.edu. You will need to login and upload the lab report material. Submission instructions, a sample coversheet, and a syllabus showing the deadlines for your section are located on the website.

Team PowerPoint Presentation

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".

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 members you worked with during lab. The hard copy will be used to help grade your oral presentation.

4 MATERIALS AND EQUIPMENT

  • Lab PC
  • Microsoft Office Suite

Remember: 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 must hand in a copy of your lab notes for the Writing Consultant (WC) to review. Keepingcareful notes is an essential component of all engineering and scientific practice.

However, for this lab only, you are not required to take lab notes, or submit them for review by the Writing Consultant.

5 PROCEDURE

Microsoft Word

Most software has a built-in reference manual to help you learn the program. For all the Office 2007 products, the help icon is a white question mark in a blue button located at the top right corner of the screen. 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.

You are going to create two Microsoft Word documents. One will look like Figure 1 below.

Lab intro-1.JPG

Figure 1: Generic Word document

The other will be personalized, and will look like Figure 2.

Lab intro 2.jpg

Figure 2: Personalized Word document

  1. To open Microsoft Word, click on the Windows icon in the bottom left corner of the screen, which is the Start Menu. On the list that appears, click on the Microsoft Office menu item. This will expand to the Office 2007 components. Click the Microsoft Office Word 2007 menu item.
  2. Lab intro 2a.png

    Figure 3: Beginning screen

    When Word starts, you'll see the the screen shown in Figure 3. The most important part is the "ribbon", which all Office products now use. The ribbon has several features. In the extreme top left corner is the Microsoft Office Button, where functions that manage the document are found. These include thinkgs like opening, saving, and printing a document. Next to the Office button is the Quick Access Toolbar, where frequently used functions can be found. Initially, there are only three icons, corresponding to saving the document, an "undo" of what you just did because you changed your mind, and an icon that will have Word repeat what you just did. You can add more items to the Quick Access Toolbar if you want, but we won't be doing this in this lab. Below the Quick Access Toolbar is the "ribbon", where the tools you'll use for the document are located. At the top of the ribbon are a set of tabs, which is the high level menu. Each item in the menu is a tab, which operates like the tab on a physical folder in a file cabinet. Looking at the tabs, you can see the functions available. For example, right now you're on the Home tab. The area below the tab has several groups named at the bottom of the grouped functions. These groups are categories of functions you can use. Most people will see Clipboard, Font, Paragraph, Styles, and Editing groups.

    So far all we see is a blank sheet of paper. Some of our work will require that we know where things are located on this sheet. To help us, click on the View tab. This will change the ribbon to what's shown in Figure 4:

    Lab intro 2b.png

    Figure 4: View ribbon

    On the Show/Hide group, there's a box next to the word Ruler. By clicking on this box, we'll display rulers on the top and side of electronic paper, allowing us to align things. This will be very helpful later. Now click on the Home tab to get back to the main ribbon.

    To understand the next part of the ribbon, we need to discuss typography. A typed letter on a page or displayed on a screen has a number of attributes. The first is its font, which is how the letter looks. Fonts come in two different kinds. The first is a serif font, meaning that its letters have small tails and curves that make it look good. However, these letters tend to be thin to leave room for the extra frills. The alternative kind is a sans serif font because the letters do not have this level of detail. Word has many fonts of both kinds to choose from. The second attribute a letter has is its size, specified in Word in points, which is the height of the letter. A point is 1/48 of an inch, so a 12 point letter will be 1/4 of an inch high.

    Lab intro 3 2007.png

    Figure 5: Font Group

    Figure 5 shows the Font group. Notice how all the terms described in the preceding paragraph are shown, plus more. The default font is Calibri 11 points, which is very readable, but not formal enough for a report, and also a little on the small side. Therefore, we'll change it. On the top left side, you'll see the font name of Calibri (Body) and next to it the type size of 11 points. Next to the font name you'll see a small arrow pointing downwards, indicating that there's a pulldown menu of fonts to choose from. Click on the arrow, find the Times New Roman font, and click on it. The fonts are in alphabetical order, and also show what they look like. Notice that the font name is now changed. Next, click on the downward facing arrow next to the size, showing a menu of type sizes. Choose 12 for 12 point type. Times New Roman is the font many newspapers use because it is very readable, and looks good as well.

    Finally, we can change how the letters look to add emphasis. We can make them italics, bold, or underlined. For example, the first time words are defined in this lab, we make them bold and italics. You can give letters these special attributes by clicking on the buttons in the Fonts group shown in Figure 6:

    Lab intro 3a 2007.png

    Figure 6: Letter highlighting buttons

    Next, we can choose how we want paragraphs to look. The paragraph group is shown in Figure 7:

    Lab intro 3b 2007.png

    Figure 7: Paragraph Group

    First, We can choose how the words fill out the line. The default is left justification which means the words start on the left side of the line and continue until we run out of room, and a new line is started. This is the way we write. There are other choices. We also have centered justification, where the text is centered on the line and if it's smaller than the line there will be room on both the front and the back. There is also right justification, where the line is up against the right margin, and there is space on the left side. Finally, there is full justification where the spacing between the words is increased so that the words fill up the entire line from side to side. It is a good idea to use the Times New Roman 12 point font, with full justification as your default, i.e., your starting font and format. This will give your reports a professional look. Paragraph adjustments are located in the Paragraph group. In the bottom left corner of this group you'll see the justification choices. The paragraph alignment buttons look like this:

    Lab intro 3.gif

    For this lab, we're not producing a formal report, so we'll use left justfication instead. Click on the leftmost icon of the group (the one that looks like text that's left justified) to do this. Also, note that if you hold the cursor over any icon, a small message will pop up telling you what the icon does. Microsoft calls this hovering the cursor and every Microsoft product supports it.

    Sometimes we'd like to leave blank space and just move to a specific place on the line, filling in blank space as needed. In typography, this is called a tab, and Word allows us to set tabs at specific places. This is why showing rulers helps. For example, if we right justify text using the button just described, all the text will be right justified, which might not be what we want. If we want text to be placed in a specific location, we create a tab stop. In the Paragraph group, click on the small arrow in the bottom right corner of the group. This brings up a dialog box that gives us more control over the paragraph. This dialog box is shown in Figure 8:

    Lab intro 3c 2007.png

    Figure 8: Paragraph control window

    Click on the Tabs... button in the bottom left corner of the window, and a new window shown in Figure 9 will appear:

    Lab intro 3d 2007.png

    Figure 9: Tabs window

    You can set left tabs, where the text will start at the position you give, center tabs, where the text will be centered on the position you give, and right tabs, where the text will end at the position you give. The way you do this is you give the place where you want the tab to be in inches, based on the ruler at the top of the screen. Then you click on one of the radio buttons to select the type of tab you want. Then click on the Set button to create the tab. You can create more tabs if you want. When you're done, click on the OK button.

    Next, we can decide how much blank space we want to follow a paragraph. Once again, we'll open the paragraph control window by clicking on the small arrow in the bottom right corner of the Paragraph group. This opens a new window shown in Figure 10:

    Lab intro 3e 2007.png

    Figure 10: Paragraph spacing window

    On the left side of the window, you'll see the Spacing area, showing how much blank space is before and after the paragraph. The current settings show zero points (nothing) before a paragraph and 10 points after it. This is a good choice for most work, but we want to change it for this lab. Therefore, double click on the "10" in the box for the After specification, highlighting the number, and type a zero, indicating that no blank space should follow the paragraph. Now click the OK button.

    We have to set a tab at the right margin. Use the method described above to set a tab at 6.5 inches, right adjusted, and click the OK button.

    Finally, check that the paragraphs we're going to create are initially set for left justification. If the button that shows left alignment is not highlighted, click on it to highlight it.

  3. Now we're ready to start creating the page. First we'll make an equation.
    1. The cursor should be blinking as a vertical line at the top left corner of your page. If it's not blinking, click anywhere on the page. The vertical bar shows where the equation will be placed.
    2. Click on the Insert tab. Figure 10 below shows what the ribbon looks like now. Note that the ribbon changes to things that can be inserted into the document. The groups are Pages, Tables, Illustrations, Links, Header & Footer, Text and Symbols. In the Symbols group you'll see the Equation icon. For each of the symbols, there's the name of symbol and an arrow under it. The arrows show the more common usages of the symbol. Unfortunately, it's rarely what we will want, so be careful to click on the icon and not the arrow under it. Click on the Equation icon and two things happen. The ribbon changes to the Design tab on the menu to show things you can use to make an equation, and on the document an area appears that says Type equation here. Figure 11 shows what this looks like.
    3. Lab intro 4 2007.jpg

      Figure 11: Insert ribbon

      Sometimes, when the Design tab opens, the equation area will be in the middle of the page. This means that Word has switched to full justification to make the quation look pretty. This is not what we want, so we'll click on the Home tab, put the paragraph back to left justification, and return to the Design tab to continue working.

      Lab intro 5 2007.png

      Figure 12: Design ribbon

    4. To insert the desired quadratic equation in the upper left-hand corner of the page, proceed as follows:
      • On the left side of the ribbon, you can select the kind of text you want. Select Normal Text from the list.
      • Begin by typing “x=�? (as usual, without the quotes).
      • On the right side of the ribbon, you'll see the Structures group. Click on the Fraction icon. This will bring up the Fraction palette shown in Figure 13:
      • Lab intro 6 2007.png

        Figure 13: Fraction palette

      • Select the style of fraction you want by clicking on it. In this case we want the regular vertical fraction, which is the first one shown. Note that the fraction now appears in your document, with two empty boxes. You click on each box to fill in the top and bottom of the fraction. We'll start with the numerator (the top box), so click on it.
      • Type “-b�? and then select the plus-or-minus symbol from the Symbols group (this is called a gallery by Microsoft) on the ribbon. The symbol you want is the very first one shown.
      • Click on the Radical icon from the Structures group. Select the square root item from the palette, and click the box inside the radical on the document so we can fill it in.
      • To superscript text (necessary for the “2�? in “b2�?), click on the Script icon. We want the first selection, which is a simple superscript. The item appears in the equation. Click on the the larger box and put in the letter "b" term being squared. Next, click on the little box for the power and put a "2" in it. Next, press the right arrow to move the cursor right behind the b2 term, and fill in the rest of the numerator.
      • Click on the bottom box to fill in the denominator, and type in the "2a" term. When you are finished, click outside the equation box to return to the ordinary word processing mode.
    5. Type the text in quotes below, without including the quotes or the italicized attributes:
    6. Press the tab key and the cursor will jump to the tab you created on the right margin. Type “Section ??�? and notice how it's filling in from the right margin. Using the methods we covered earlier, change this text to the following attributes: Courier New 48 points

      For the rest of the text, we can align it using the paragraph justification buttons described earlier.

    7. Now, type more paragraphs and give them the following attributes:
    8. “First TA�? Times New Roman 12 points, aligned right

      “Second TA�? Times New Roman 12 points, aligned right

      “Name�? Arial 24 points, underlined, centered

      “email address�? Courier New 16 points, bold, aligned left

      “Address�? Times New Roman 12 pionts, aligned left

      “Phone Number�? Times New Roman 12 points, aligned left

      The attributes should be applied to the typed text using the icons and menus described earlier. The attributes can be selected before you type the appropriate text, or applied afterward by selecting (highlighting) the text and then applying the attributes.

      Select the line spacing using the Line Spacing icon in the Paragraph group. This icon is in the middle of the bottom row of this group, next to the justification icons. It looks like arrows next to lines of text, a graphical way of indicating spacing. If you hover the cursor over the icon, it will confirm this. Just select the text you want to control line spacing for, and then click the icon. Use the following line spacing for your Word document:

      1. for all text that is aligned right, use single spacing
      2. for all text that is centered, use double spacing
      3. for all text that is aligned left, use 1.5-line spacing.
    9. It is a good idea to periodically save your work. To do this, click on the Office button. Click on the Microsoft Office Button, then click on the Save menu item. Name the file “lab01generic�? and save it in the “My Documents�? folder on your computer. Later, you must convert the files to Office 2003 format so you can submit them for grading.
  4. Next, you will insert a table.
    1. 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.
    2. Click on the Insert tab to get back the ribbon shown in Figure 10. Click on the Table icon. The gallery shown in Figure 14 will appear.
    3. Lab intro 7a 2007.png

      Figure 14: Insert Table Gallery

    4. You can create small tables by using your mouse to select the desired number of boxes off of the grid. However, our table will be bigger than the grid provides. Therefore, click on the "Insert Table..." item at the bottom of the gallery. This will bring up a window that allows us to build a custom table. It's shown in Figure 15.
    5. Lab intro 7b.png

      Figure 15: Table dialog window

    6. For your Word document, select 6 columns and 14 rows, and click OK. This will create your table and move you to the design ribbon for the table, as shown in Figure 16:
    7. Lab intro 7c.png

      Figure 16: Table is created in the document

    8. Now we need to fill in the cells in the table. Click on the Home tab so we can create and edit our text. You can give each cell font attributes or fill it in with text by clicking inside the cell with the mouse. You can also give multiple cells the same attributes by dragging the mouse over them. Make all the cells Arial, 10 points, center justification for the text in the table. For the First row and the first column, make these cells bold text. If the cells have different attributes, Word will only show you the attributes for the first cell, so it's a good idea to set the attributes for the cells again even if they seem to be right. 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.
  5. 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.
    1. 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.
    2. In the Paragraph group, look for the icon that looks like a paint can. This is how you "paint" the background of a cell. Click on the arrow next to the paint can, and the following gallery show in Figure 17 appears:
    3. Lab intro 7d.png

      Figure 17: Background color gallery

    4. In the gallery in the first column, hover the cursor to find the paint patch that shows White, Background 1, Darker 25% and click on it. On the Format menu, click Borders and Shading. Click the Shading tab and select 25% gray from the color palette. Next, we'll change the text color. We do this by clicking on the arrow next to the capital "A" in the bottom right corner of the Paragraph group. This brings up the gallery shown in Figure 17 again, but this time the gallery is used to select the text color rather than the background. Click on the white box in the top left corner. If you hover your cursor over this box, it will say "White, Background 1". Now type "Club Hour" in the cell. This will show white text on a gray background.
    5. Now we'll make our table look professional by giving it a double border around the outside. First, highlight all the cells in the table by dragging the mouse over them. In the Paragraph group, look for the icon in the bottom right corner that's next to the paint can. It looks like a square. click on the arrow next to it. This brings up the window shown in Figure 18:
    6. Lab intro 7e.png

      Figure 18: Cell formatting menu

    7. Click on the last item in the menu: Borders and shading. This will bring up the window shown in Figure 19:
    8. Lab intro 7f.png

      Figure 19: Borders and shading window

    9. On the left side of the window are various built-in borders. Click on the second item in the list: Box. Next, select the type of border we want by scrolling down the Styles: list until we see the double lines. Click on it to select it, and click on OK.
    10. Now we'll repeat the process for the lines inside the table. Drag the mouse over the table cells to highlight them if they're not highlighted already. Click on the arrow next to the Borders and Shading icon you just selected for the outside. Select the last menu item again, bringing up the window in Figure 19. For the Styles, scroll up to the top of the lines and select the single line. In the Preview pane on the right of the window you see an abstract version of your table, showing the double line on the outside and nothing on the inside. CLick in the middle of the table and the solid lines will appear. Click OK and the table is complete.
  6. Save the changes that have been made by selecting Save from inside the Microsoft Office Button.
  7. Finally, you will learn to use WordArt.
    1. Place the cursor where you want your object to appear.
    2. Click on the Insert to get the proper ribbon. On the right side is the WordArt icon. On the Insert menu, select Picture, then Word Art.
    3. A gallery of choices will appear. Select one that resembles our example. Click OK.
    4. Type “EG1004�? in the box that appears. Click OK.
    5. If the WordArt is left adjusted, you can put it in the center of the line by clicking on the Home tab and selecting the centered justification in the Paragraph group.
  8. Save the document again.
  9. Since you have to submit this document, you need to save it again using the Word 2003 format. To do this, click on the Microsoft Office Button and select Save As... off the menu. On the window that comes up, use a file name of “lab01generic�? like you did before, but this time, on the "Save as type" menu below it click on the arrow on the right, and select "Word 97-2003". Click OK and the document will be saved in Word 2003 format as well. Since Word 2007 has more functionality than Word 2003, especially with equations, you might get a window warning you of compatibility issues. Since we're done with this document, this is OK, so just click the OK button to continue.
  10. Now it is time to personalize your document.
    1. Select Save As from the File menu. Name the file “lab01personal.doc�? and save it in the “My Documents�? folder on the lab computer. This will save the document in Word 2003 format as well, which is what we want.
    2. Personalize the generic document you just created, keeping the appropriate attributes.
    3. Save this new file.

To insert a comment (Microsoft Word):

  1. Put the cursor where you would like the comment inserted.
  2. Click on the Review tab. The ribbon shown in Figure 20 will appear:
  3. Lab intro 7g.png

    Figure 20: Review ribbon

  4. Click the New Comment icon in the Comments group. The text under the cursor will be surrounded by a red box with a connector to a box outside the document where you can type your comment. The cursor is there, so you can type your comment. Type "Argh!" and you'll see it in the comment box.
  5. Click anywhere in the document outside the comment area to finish. Note that in the Tracking group on the right side "Final Showing Markup" is highlighted so you can see comments. If you don't want to see the comments, click on the arrow to the right, and select the Final menu item to show the document like it was.
  6. We'll show the comment again by clicking on the arrow to the right of the Final word and setting the view back to "Final Showing Markup" by clicking on that menu item. The comment is now back. We can deleted the comment by putting the mouse over the comment, right clicking the mouse, and selecting Delete Comment on the menu that pops up.

Microsoft Excel

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 21.

Lab intro 12.jpg

Figure 21: Excel Document

To open Microsoft Excel, go to the Start menu, select Microsoft Office and Microsoft Office Excel 2007. Excel will start, and the home ribbon for Excel will appear, as shown in Figure 22:

Lab intro 12a.png

Figure 22: Excel home ribbon

Creating a Header

  1. In the new, blank workbook that opens, select the Page Layout tab. This will bring up the ribbon shown in Figure 23:
  2. Lab intro 13 2007.png

    Figure 23: Page Layout ribbon

  3. In the Sheet Options group, click on the arrow in the bottom right corner of the group. This will bring up the Page Setup window. Click on the Header/Footer tab. Click on the button that says Custom Header. Three windows will appear corresponding to the left, center and right of the header you want at the top of your page. Fill in the sections as follows:
    • Left section: your name.
    • Center section: “Lab 1: Excel Exercise.�?
    • Right section: your section.
  4. Click "OK" to save this information. Click "OK" again to remove the "Page Setup" window and return to the spreadsheet.

Note: The Header is not visible on the Excel spreadsheet as you work; it is inserted when the sheet is printed. To preview the final document, click on the Microsoft Office Button, then the Print icon, and then the Print Preview icon on the popup menu. to preview the final document.

Setting up Your Worksheet

Note: When you enter data into Excel, it is not unusual for the data to not fit into the cell initially, making it look like the data is overrunning into the next cell. Don't worry about this - you can resize the cell later so the data fill fit.

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:

  1. In cell A1, enter Term
  2. In cell B1 enter Number
  3. In cell C1 enter Unit(s)
  4. In cell A2, enter n
  5. In cell B2, enter the value provided by your TA
  6. In cell C2, enter mol
  7. in cell A3, enter R
  8. In cell B3 enter 0.082057
  9. In cell C3, enter L*atm*mol-1*K-1
  10. Note: To make superscripts (powers), highlight what you want to make a superscript with your mouse in the area just below the ribbon. Then click on the Home tab and click on the arrow at the bottom right of the Fonts group. The Format Cells popup window will appear. Click on the Superscript box on the left side. Click the OK button and you're done. You won't see the superscript in this area, but you will see it if you look at the cell.

  11. In cell A4, enter P
  12. In cell B4, enter 1
  13. In cell C4, enter atm

Note: In the next few cells, you'll be inserting the degree symbol. When the time comes to do this, click on the Insert tab, and click on the Symbol icon. This will bring up the Symbol pallette shown in Figure 24:

Lab intro 13a 2007.png

Figure 24: Symbol pallette


Make sure the Symbol font is being shown. If it isn't, click on the arrow to the right to show all the fonts, and select Symbol. Next, scroll down the pallette until you see the degree symbol. You do this by clicking on the scroll bar on the right side. The degree symbol is the first symbol in the ninth row. The symbol pallette with this symbol selected is shown in Figure 25:

Lab intro 13b 2007.png

Figure 25: Symbol pallette with degree symbol selected

Now, click on the Insert button and the symbol will be inserted into the text. Finally, click on the Close button to close the pallette.

Next, we'll create a table of computed values. To do this, type the following text into your Excel worksheet:

  1. In cell A6, enter Temperature (˚F)
  2. In cell B6, enter Temperature (˚C)
  3. In cell C6, enter Temperature (K)
  4. In cell D6, enter Volume (L)

Enter Fahrenheit temperatures 0 – 45 ˚F into cells A7 through A16, increasing the temperature by 5 ˚F in each successive cell.

Using Formulas

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 (=).

As an example of the syntax, the formula “= 5*(P98) +ABS(X15)/0.34�? would take the value in cell P98 and multiply it by five, and then add the result to the absolute value of the contents of cell X15 divided by 0.34. If you are in doubt about the order of the mathematical operations, use parentheses to make sure the result is calculated correctly. The full range of functions can be selected clicking on the Formulas tab. This brings up the ribbon shown in Figure 26:

Lab intro 13c 2007.png

Figure 26: Formulas ribbon

There are several ways to choose the formula you want and you don't know its name. The first way is to click on the Insert function icon at the left end of the ribbon. At the top of the dialog box that pops up, there's a place where you can type the description of what you're looking for and Excel will show matches. If you have a pretty good idea of what type of function you want, you can use the colored book icons along the top of the ribbon. Just click on the icon for the category you want and then choose the function from the list.

You will use the following expression to convert your simulated data into degrees Celsius:

Lab intro 14.gif

  1. Enter “=5/9*(A7-32)�? into cell B7.
  2. Now we'll copy the formula into other cells. To do this, click on the cell. Click on the Hometab on the ribbon. Click on the Copy icon at the left end of the ribbon. highlight cells B8 through B16 by dragging the mouse over them. Click on the Paste icon that looks like a clipboard at the left end of the ribbon.
  3. Click on the cells between B7 and B16 one at a time and examine the contents. Notice that the cell reference in the formula has automatically been adjusted in each destination cell.

You will then use the following expression to convert your data into Kelvin:

Lab intro 15.gif

  1. Enter “=B7+273.15�? into cell C7.
  2. Copy this formula into the cells C8 through C16 using the same method we used earlier.
  3. Click on the cell C16 and look at the contents. Notice that the cell reference in the formula (B7) has automatically been adjusted to B16.

You will use the ideal gas law expression to compute the volume for your exercise:

Lab intro 16.gif

  1. Enter “=($B$2*$B$3*C7)/$B$4�? into cell D7.
  2. Copy this formula into the cells D8 through D16 using the same method we used earlier.
  3. Click on cell D16 and notice that all the cell references except C7 have been kept constant. Typing a $ before a cell reference letter or number fixes the value, even if is it later copied. Two $ keeps both the cell letter and the cell number constant.

Formatting Your Tables

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. Start by making sure no cells are highlighted. If there are, just click on any cell so that just the usual outline box is present.

  1. Move the cursor up to the top of the spreadsheet and hover the cursor between the A and B column headers. Note that the cursor changes to a vertical line with an arrow on each side, as shown in Figure 27:
  2. Lab intro 17.gif

    Figure 27: Column Edge

    Double click on the boundary between the column headers and the width of the column to the left will automatically resize. Do this for the other columns as well
  3. In our example two digits after the decimal point is appropriate. Adjust the display by highlighting the data cells B7:D16 (drag the mouse). Click on the arrow in the bottom right corner of the Font group in the Home tab to bring up the Format Cells dialog box shown in Figure 28:
  4. Lab intro 17a.png

    Figure 28: Format Cells dialog box

  5. Click on the Number tab in the dialog box. In the Category list, click on the Number item and the window will change to allow you to format numbers. Note that the number of decimal places is 2, which is what you want. Click on the OK button and you're done.
  6. 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. Make sure no cells are highlighted and resize the column by double clicking the right edge of the column again.

Creating Table Borders

As part of this section, you'll see a different way to work with cells.

  1. In your Excel worksheet, highlight the table of constants (cells A1-C4), and right click within the highlighted area.
  2. From the dialog box that appears, select Format Cells. This will bring up the same Format Cells dialog box that you saw before.
  3. In the Format Cells dialog box, go to the Border tab. This will change the dialog box to what's shown in Figure 29:
  4. Lab intro 17b.png

    Figure 29: Format Cells dialog box: border tab

  5. 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.
  6. 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 "Fill" tab and the dialog box will change to Figure 30:
  7. Lab intro 17c.png

    Figure 30: Format Cells dialog box: fill tab

  8. Select the gray box in the middle row on the left side, which will be 25% darker. Click "OK", and you'll see that the column headers now have their own frame and shading.
  9. Repeat steps 1-5 for the table of computations.

Creating a Chart

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:

  1. Select the temperature and volume values in cells C7–D16.
  2. Click on the Insert tab on the ribbon. The ribbon will change to what's shown in Figure 31:
  3. Lab intro 17d.png

    Figure 31: Insert ribbon

  4. The Chart group is in the middle of the ribbon. Click on the Scatter icon. This will bring up the pallette shown in Figure 32:
  5. Lab intro 17e.png

    Figure 32:Scatter chart pallette

  6. On the pallette, click on the first icon: Scatter with only markers.
  7. The chart appears on your spreadsheet, and the ribbon changes to the Design tab so you can customize your chart, as shown in Figure 33:
  8. Lab intro 17f.png

    Figure 33:Design ribbon for chart

  9. The chart points are probably blue, which don't print well on a black and white printer. If you look at the ribbon, the chart style is probably "Style 2". Click on "Style 1" and you'll get black points, which will print better.
  10. Now we'll customize the chart by adding the axis labels and title. In the Chart Layouts group, hover the cursor over the first icon, and the caption "Layout 1" will appear. This is the layout we want, so click on the icon.
  11. Click on the vertical axis title. Highlight the existing text that says "Axis Title" and change it to "Volume (L)".
  12. Click on the horizontal axis title. Highlight the existing text that says "Axis Title"and change it to "Temperature (K)".
  13. Click on the title. Highlight the existing text that says "Chart Title" and change it to "Volume (L) vs. Temperature (K)".
  14. Click on the Series 1 text on the right side, which is the chart legend. We don't need a legend for this chart. Put the cursor over the data point in front of the words and the cursor will change to a crosshair with arrows. Press the Delete key and the legend will disappear. The chart will also automatically resize to fill the space.
  15. Adding a Trendline

    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:

    1. Select any data point on your chart. Excel will automatically select all remaining points for you.
    2. Right-click within the chart. From the context menu that appears, select Add Trendline.... This will bring up the dialog box shown in Figure 34:
    3. Lab intro 17g.png

      Figure 34: Format Tendline dialog box

    4. As you can see, there are a lot of options. Fortunately, the defaults are exactly what we want, so just click the Close button. The chart now has the trendline we want.

    Adding a Caption to Your Chart

    1. 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.
    2. 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. The Format Cells dialog box that you saw earlier appears. Click on the Alignment tab
    3. , and the dialog box changes to Figure 35:

      Lab intro 17h.png

      Figure 35: Alignment dialog box

    4. In the Text alignment area, for Horizontal, click on the arrow to the right of the word "Automatic" and a dropdown menu appears. Click on Center.
    5. In the Text control area, check the Wrap Text and Merge Cells checkboxes, and click OK.
    6. In the highlighted cells, enter a suitable caption for your chart.
    7. Since we're done with the worksheet, we'll save it in Office 2003 format for submission. Click on the Microsoft Office button. Click the "Save As" icon. Change the "Save as Type" to "Excel 97-2003 Workbook", and use a File Name of “lab01excel.xls�?. Print a copy of the sheet as well by clicking again on the Microsoft Office button, clicking the Print icon, and clicking the OK button on the Print dialog box that comes up.

    Microsoft PowerPoint

    Now you will create a PowerPoint presentation reporting on the work done in Lab 1. 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.

    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 36 contains some examples of what your slides might look like.

    Lab intro 24.gif

    Figure 36: Typical PowerPoint slides

    1. To open Microsoft PowerPoint, go to the Start menu, select Microsoft Office and Microsoft Office PowerPoint 2007. PowerPoint will start. A new slide will appear with the default Title layout (see Figure 37). Click where it says, “Click to add title�? and enter the title of your presentation.
    2. Lab intro 25 2007.png

      Figure 37: Microsoft PowerPoint, main window. Your screen will look like this when you begin a new presentation.

    3. From the Slide group, click on the New Slide icon. This will advance your presentation to the next slide, which will be blank. When you select this, PowerPoint will display a number of atlernatives for you to choose from on how to layout your next slide. Choose the one you like best.
    4. Click anywhere inside the box marked "Click to Add Text" and insert your information. Continue this process until you have outlined your entire presentation.
    5. To add an object from another software application, like Word or Excel, simply copy and paste your object onto the selected PowerPoint slide.

    Microsoft PowerPoint allows you to customize the design of your presentation.

    To select a design template before you begin, click on the Design tab on the ribbon. The Themes group will show the slide themes you currently have available. Initially, it is a rather limited selection. However, there are hundreds of themes available. Sample slides of each therme are shown in teh group. To have a wider selection, click on the downward facing arrow just to the right of the sample slides, to the left of the icons for Colors, Fonts, and Effects. This will bring up the dialog box shown in Figure 38:

    Lab intro 25a 2007.png

    Figure 38: Theme dialog box

    In addition to seeing the themes you already have, there is also a selection of how to acquire more. Click on the message "More Themes on Microsoft Office Online..." and you'll be directed to the Microsoft Web site that is an archive of many templates for all the Office products. AIn the top left corner of the Web page you'll see a group called Search Just below the word "Templates" there's a line where you can enter text saying what you want to search for. For example, if you want to use a theme with a space orientation, type in "slides space" and click on the Search icon. This will bring up the first 100 themes related to space, 14 at a time. You should be able to find a theme you like on almost any subject.

    Note: The Design tab also allows you to adjust your color schemes too. Click on the Colors icon on the right side of the Themes group. From the dialog box that appears you can select a predefined color scheme, or design one of your own. Remember to choose a scheme that has a high contrast between the leteters on the slide and the background so that your audience can read the slides easily. The built-in schemes are designed to do this.

    IMPORTANT

    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.�? Remember to save it as an Office 97-2003 presentation so it can be submitted electronically.

    You can print a copy of your presentation just like Word and Excel. To print a copy of your PowerPoint Presentation:

    1. Click on the Microsoft Office button. From the menu that appears, click on the Print

      icon. The box in Figure 39 will appear.
    2. Lab intro 26 2007.png

      Figure 39: Microsoft PowerPoint Print dialog box.

    3. In the box marked Print what: select Handouts.
    4. In the box marked Color/grayscale select Pure Black and White.
    5. In the box marked Slides per page choose six, using Horizontal order.
    6. Click OK to print.

    Your lab work is now complete. e-mail copies of all the files you created to your personal account. Review the files for errors before submitting your report.

    Please clean up your workstation before you leave the lab. Refer to section 3 Your Assignment for the list of the specific items you must submit for your report.


    Return to Table of Contents