Difference between revisions of "Microsoft Office Skill Builder"

From EG1004 Lab Manual
Jump to: navigation, search
(1003 --> 1004)
 
(101 intermediate revisions by the same user not shown)
Line 1: Line 1:
<h1 align=center>EG1004 Lab 1: Software for Engineers I</h1>
'''<span style="color: red;">Important:</span> Please note that you ''must'' register on the [http://eg.poly.edu EG Website] before performing the lab.'''


<h2>1 OBJECTIVES</h2>
# Click on the register link as shown in Figure 1.
#: [[Image:Lab_intro_27.png|thumb|500px|left|Figure 1. Registration Link Identification.]]<br style="clear: both;" />
# Fill in the appropriate information on the form shown in Figure 2 and submit it.
#: '''Note:''' Please make sure that you capitalize the first letter of your first and last name.
#: [[Image:Lab_intro_28.png|thumb|500px|left|Figure 2. Registration Form.]]<br style="clear: both;" />
# Select the type of ID card you possess. Based on the type of ID you have, you may be asked for different information. If a Unique ID is asked of you, it is the barcode on the back of your ID.
#: <div><div style="float: left; display: inline;">[[Image:Lab_intro_29.png|thumb|300px|Figure 3a. Registration Form Fields for Landscape IDs.]]</div><div style="float: left; display: inline;">[[Image:Lab_intro_30.png|thumb|300px|Figure 3b. Registration Form Fields for Portrait IDs.]]</div></div><br style="clear: both;" />
# Fill in the remaining information accordingly.
#: '''Note:''' If your email is '''flast99'''@students.poly.edu or '''fml999'''@nyu.edu, then '''flast99''' or '''fml999''', respectively, will be your username.
#: '''IMPORTANT!!:'''  After you are registered, a TA must approve your account before you can log in.


<p>The objective of this lab is to use Microsoft Word, Excel, and
= Objectives =
PowerPoint to perform specific exercises and learn which programs are best
The objective of this lab is to use Microsoft Word, Excel, and PowerPoint to perform specific exercises and become accustomed with the tasks that each application is best suited for. Your goal is to complete the assigned tasks and obtain a basic familiarity with these three applications.
suited to particular tasks. Your goal, after having completed the assigned
tasks, is to have a basic familiarity with these three software tools.</p>


<h2>2 OVERVIEW</h2>
= Overview =
This lab is designed to introduce you to three Microsoft (MS) applications: Word, Excel and PowerPoint. These programs are widely used throughout academia and business so many of you may already have some familiarity with them. Completing your assignments in EG1004 will require a basic competency in them; the following exercises are designed to ensure you have this competency so please complete them.


<p>This lab is designed to introduce you to three Microsoft
== Microsoft Office ==
applications: Word, Excel, and PowerPoint.
With the recent release of MS Office 2010, EG1004 is in a transition period between MS Office 2007 and MS Office 2010. Either version of MS Office may be used to complete this lab. At this time, it is believed that there are no differences, other than cosmetic ones, which will impact how this lab is performed.
Mastering these programs is essential for you to complete your
assignments in EG 1004.  These software
tools are widely used in academic settings as well as in business and
industry. Many of you may already be
familiar with some of the things they can do.  
The following exercises are designed to ensure you have a well defined
set of basic skills, so please complete all the required tasks.</p>


<h3>Microsoft Word</h3>
When Microsoft released MS Office 2007, they introduced a new user interface to the MS Office Suite. When a MS Office application is launched, you will see this new ''Ribbon'' interface at the top of the window. The ''Ribbon'' has several features. In the top-left corner of the windows is the ''Office Button'', where functions that manage the document are found. MS Office 2010 replaced the button with the ''File'' tab. These functions include actions like opening, saving, and printing a document. Next to the ''Office Button'', or above the ''Ribbon'' in MS Office 2010, 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 the MS Office application 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 file are located. At the top of the ribbon are a set of tabs, which operate like the tabs on physical folders in a file cabinet. Looking at the tabs, you can see the functions available. For example, upon launch you are on the ''Home'' tab. The area below the tab is organized into several ''collections'' which are named at the bottom of the ribbon. Collections are used to logically break down and group similar functions together. Figure 4 shows the initial ''Ribbon'' on the Home tab that you are presented with when MS Word is launched.
: [[Image:lab_intro_2a.png|thumb|650px|left|Figure 4. MS Word Ribbon: Home Tab.]]<br style="clear: both;" />


<p>Microsoft Word is a word processing program; its function is to
[[Image:Lab_intro_31.png|thumb|150px|right|Figure 5. Help Button]]Clicking the question mark at the top right of any MS Office application will open its help manual. Use it as a reference whenever you are unsure of how to do something. This, and saving your work regularly, will save you many hours over your working lifetime.<br style="clear: both;" />
help you create and edit text. It has
features that make the mechanics of technical writing relatively easy, but it also
has features that make academic dishonesty and plagiarism very easy, too.  You are expected to do all the exercises and
assignments for this (and all other courses) yourself, unless you are
specifically told otherwise, e.g., when you do a team report.</p>


<p>You can create tables and write equations in Word. It also has spelling and grammar checkers and
== Microsoft Word ==
a thesaurus to help you eliminate mistakes in your writing.  But beware: running spelling and grammar
MS Word is a word processing program. Its function is writing and editing text. It has features that make the mechanics of technical writing relatively easy, but it also has features that make academic dishonesty (e.g., plagiarism) easy as well. You are expected to do all exercises and assignments by yourself for all courses including this one, unless explicitly stated otherwise. Specifically for this course, the main exceptions to this rule are lab presentations (to be done with your lab partner(s) of the week), project presentations (to be done with your project partners) and team lab reports (to be done with your lab partner(s) of the week). You will be given adequate notice when a lab report is expected to be written as a team; otherwise, you are expected to write the lab report individually.
checks does not eliminate the need for careful editing of all your
documents. As powerful as these tools are,
they are not foolproof.</p>


<p>In this course, you will use Word to write lab reports, software
You can create tables and write equations in MS 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.
documentation, and proposals.  The
thesaurus allows you to quickly find synonyms, so that you can avoid boring
repetition in your writing. To use the
Thesaurus, put the cursor anywhere within the word for which you would like to
find a synonym. Pull down the Tools menu and select Language, then Thesaurus.  You can also right-click
on the word and select Synonyms.</p>


<h3>Microsoft Excel</h3>
In this course, you will use MS Word to write lab reports. 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 Ribbon, select the ''Review'' tab. Then, in the ''Proofing'' collection, click on the ''Thesaurus'' icon, which looks like an open book. The equivalent words (synonyms) will be shown on the right side of the screen. Just double-click on the one you want to use.


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


<p>Excel has many features that streamline
== Microsoft Excel ==
data analysis. You can use it to
MS Excel is a spreadsheet program. Its function is collecting, manipulating, and analyzing data. This data can come from a variety of sources, including experiments and design calculations.
generate tables, charts, and graphs.
Excel includes formatting tools, editing features, built-in functions,
data manipulation capabilities, and graphing features. It is especially useful for uncovering the
relationships that exist between data and to identify trends.  You will use it to create graphical elements
that will be embedded in your reports, proposals, and presentations.</p>


<h3>Microsoft PowerPoint</h3>
MS 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 and presentations.


<p>Microsoft PowerPoint is a presentation
Use in EG1004: general data manipulation and analysis. It is useful for uncovering the relationships between data sets and identifying trends. Graphs will be required for many lab reports and presentations.
program; its function is to create slides for presentations. Presenting information has always been
intrinsic to engineering projects.  Product
introductions, requests for funding, progress reports, and reports to
management are just some examples of occasions where presentation skills are
required by technical professionals.</p>


<p>Remember, PowerPoint is a tool that will
== Microsoft PowerPoint ==
help you make better presentations. It
MS 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 in which technical professionals need presentation skills.
is not a substitute for the longstanding rules to which good public speakers
have always adhered.  It is most
effective when you use it to illustrate the points you want your audience to
understand. In EG, you will use
PowerPoint to report on your lab work and to present your progress on your
Independent Project.</p>


<p>These software tools are essential to your
Remember, MS 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 MS PowerPoint to report on your lab work and to present your progress on your semester-long design project.
success in EG and beyond. This lab is
designed to help you master them by having you perform a specific set of tasks.</p>


<h2>3 YOUR ASSIGNMENT</h2>
MS PowerPoint is not a substitute for the longstanding rules that good public speakers adhere to. An effective presentation is one that illustrates the points that you want your audience to understand without taking the majority of their attention. Slides with excessive amounts of text do not illustrate anything and as such your presentation should not be written like a novel.


<h3>Team PowerPoint Presentation and Individual Lab Report</h3>
Use in EG1004: creating and giving presentations on your lab work and semester-long design project.


<p><b><i>(one presentation per team and one report per student)</i></b></p>
= Your Assignment =
== Individual Lab Report ==
You do not have to write a lab report for this lab. However, you do have to write one for [[Mousetrap Car Competition|Lab 1A: Mousetrap Car Competition]], which you will perform in the second half of the lab session.


<p>There is no formal write-up for this lab report.  Instead, you will submit:</p>
You must submit two files to the [http://eg.poly.edu/ EG website]:
<ul>
# MS Word file (.docx)
<li>A title page</li>
#* Title page
#* Generic document
#* Personalized document
#*: '''Note:''' The title page and Microsoft Word exercises should be in a single MS Word document, with the title page and each 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 Ribbon, and then click on the ''Page Break'' icon in the ''Pages'' collection.
#* Lab report (Mousetrap Car only)
# Excel file (.xlsx)
#* Tables and graph


<li>Your MS Word exercise (personalized schedule and non-personalized schedule)</li>
'''<span style="color: red;">IMPORTANT!</span>''' Submit your report electronically using the [http://eg.poly.edu EG website]. You will need to login and upload the lab report material. [[How to Submit Work to the EG1004 Website|Submission instructions]] are available. A syllabus showing the deadlines for your section are located on the [http://eg.poly.edu/ EG website].
<li>Your Software Documentation exercise</li>
<li>Your MS Excel exercise (table and graph)</li>
<li>Your MS PowerPoint exercise</li>
</ul>
<p><b><font color=#ff0000>IMPORTANT</font></b> Submit your report electronically through the EG 1004
website: http://eg.poly.edu. You will need to login and upload the lab
report material. Please copy all of the Microsoft Word exercises into ONE Microsoft Word file.  Submission instructions, a sample coversheet, and a calendar showing the deadlines for your section are listed on the website. 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 present this during recitation with the team member(s) you worked with during lab. It will be used to help in grading your oral presentation.</p>


<h2>4 MATERIALS AND EQUIPMENT</h2>
<!--
== 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".


<ul>
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.
<li>Lab PC</li>
-->
<li>Microsoft Office Suite</li>
</ul>


<p><b>Remember:</b> You are required to take notes in lab.  Experimental details are
= Materials and Equipment =
easily forgotten unless written down. You should keep a laboratory notebook for this purpose.  Each week, you
* Lab PC
<b>must</b> hand in a copy of your lab notes for the Writing Consultant (<b>WC)</b> to review.  Keeping
* Microsoft Office suite
careful notes is an essential component of all scientific practice.</p>


<h2>5 PROCEDURE</h2>
= Procedure =
== Microsoft Word ==
You will be creating the following two documents:
: [[Image:Lab_intro_32.png|thumb|700px|left|Figure 6. Generic Document (left) and Personalized Document (right).]]
<br style="clear: both;" />
Refer to this figure above as you follow the instructions below to spot any mistakes you may make.


<h3>Microsoft Word</h3>
# Launch ''Microsoft Word''. To do this, click on the Windows icon in the bottom-left corner of the screen, which opens the ''Start Menu''. Click on the ''All Programs'' item that appears just above the button. This will show you all the software on your computer. On the list that appears, click on the ''Microsoft Office'' menu item. This will expand to show the MS Office components. Click the ''Microsoft Word 2007'' or ''Microsoft Word 2010'' menu item.
#: ''Alternatively, you can type "word" into the search field of the Start Menu and click on '''Microsoft Word 2010'''''.
# Familiarize yourself with and set up your MS Word workspace.
## [[Image:Lab_intro_33.png|thumb|350px|right|Figure 7. Enable the ruler.]]Enable the ruler. 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 7. In the ''Show'' collection, there's a box next to the word ''Ruler''. By clicking on this box, we'll display rulers on the top and side of the electronic sheet of paper, allowing us to align text and objects. This will be very helpful later.<br style="clear: both;" />
## [[Image:Lab_intro_34.png|thumb|450px|right|Figure 8. Set font properties.]]Change the font face and size. Click on the ''Home'' tab and locate the ''Font'' collection. To understand this section of the ribbon, we need to discuss typography. A typed letter printed on a page or displayed on a screen has a number of attributes. The first is its ''font face'', or ''font'' for short, which is how the letter looks. Fonts come in two different types. 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. MS Word has many fonts of both types to choose from. The second attribute a letter has is its size, specified in ''points'', corresponding to the height of the letter. A point is 1/72 of an inch, so a 12 point letter will be 1/6 of an inch high. Figure 8 shows the ''Font'' collection. Notice how all the terms described 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 of ''Font'' collection, you'll see the font name of ''Calibri (Body)'' and next to it the font size of 11 points. Next to the font name you'll see a small arrow pointing downwards, indicating that there's a pull-down 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 font. ''Times New Roman'' is the font many newspapers use because it is very readable, and looks good as well.<br style="clear: both;" />
## Add style to what you type. Finally, we can change how the letters look to add emphasis. We can make them bolded, italicized, 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 ''Font'' collection shown in Figure 8.
## [[Image:Lab_intro_35.png|thumb|450px|right|Figure 9. Setting tab stops.]]Space out your paragraphs. We can decide how much blank space we want to follow a paragraph. In the ''Paragraph'' collection, click on the small arrow in the bottom-right corner of the collection, next to the collection name. This opens the dialog box also shown at the center of Figure 9. Under the ''Indents and Spacing'' tab, locate the ''Spacing'' options, where you can set 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 ''After'' box, highlighting the number, and type ''0'' (zero), indicating that no blank space should follow the paragraph. Now click the ''OK'' button.
## Align your text. We can choose how words fill the line on paper. The default is ''Left'' alignment which means the words start on the left side of the line and continue right until there is no more room and any text that follows is pushed to the left side of the next line. This is the way we write, where all the text is lined up on the left side of the page. There are other choices. We also have ''Centered'' alignment, where the text is centered on the line and if new text is smaller than the line what the line can hold, the existing text will shift left and right to accommodate the new text. There is also ''Right'' alignment, where the text is lined up against the right margin, and there is space on the left side. Finally, there is ''Justified'' and ''Distributed'' alignment. These two types of alignment make text appear as if text were both lined up on the left and right sides. With ''Justified'' alignment, space is added between words to make this possible. With ''Distributed'' alignment, space is added between characters. It is a good idea to use the ''Times New Roman'' 12-point font, with ''Justified'' alignment 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'' collection shown in Figure 9. In the bottom-left corner of this collection you'll see the alignment choices. For this lab, we're not producing a formal report, so we'll use left alignment instead. Select the leftmost icon among the alignment buttons (shown as depressed in Figure 9) to do this. Also, note that if you hold the cursor over any icon, a small message, called a tool tip, will pop up telling you what the icon does.
## Set a right-aligned tab at the right margin (6.5 inches). 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 MS Word allows us to set ''tab stops'' at specific places. This is why showing rulers helps. For example, if we right align text, '''all''' the text will be right aligned, which might not be what we want. If we want text to be placed in a specific location, we create a ''tab stop''. Once again, open the paragraph control window by clicking on the small arrow in the bottom right corner of the ''Paragraph'' collection shown in Figure 9. This brings up the ''Paragraph'' dialog box from before. Click on the ''Tabs...'' button in the bottom-left corner of the window, and a new window also shown in Figure 9 will appear.<br />You can set the alignment of tab stops, just as you can align text with the margins of the page. With tab stops, you can align text five ways. You can align tab stops to the left, center, and right just as with the margins of the page. There are two additional alignments you can choose from. One is the ''Decimal'' alignment, where text at that tab stop position is aligned to a decimal point in a number. This is especially helpful when displaying data with decimal points without the use of a table. The last alignment doesn't actually align text: the ''Bar'' alignment inserts a vertical bar at the tab stop position. Again, this alignment may be useful to separate data without the use of a table.<br />''Leaders'' can also be set. Leaders are punctuation marks (none, decimals, dashes, underscores, or dots) that fill in the space between where the tab is started to the tab stop position.<br />Where tab stops are placed is determined using the ''Ruler'' we previously activated. Tab stop positions are measured from the left margin of the paper. By default, the unit of measure is inches. To set a tab stop using the ''Tabs'' dialog box, select the type of alignment and type of leader you wish for the ''tab stop''. Next, enter the position you wish to place your tab stop, measured in inches (by default) from the left margin of the paper, in the ''Tab stop position'' text box. When you are satisfied, click the ''Set'' button to create the tab stop. You can create as many tab stops as you wish. After all tab stops have been set, select ''OK'' to confirm all your selections.<br style="clear: both;" />
# Create the generic document. This document will be used as a template and should look exactly like the one pictured
## Write the equation. Before we begin, check that the paragraphs we're going to create are initially set for left alignment. If the button that shows left alignment is not highlighted, click on it to select it. Now we're ready to start creating the page. First we'll make an equation.
## Focus on the workspace. 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 to bring it into ''focus''. The vertical bar shows where the equation will be placed.
## [[Image:Lab_intro_4.png|thumb|450px|right|Figure 10: Insert ribbon]]Click on the ''Insert'' tab. Figure 10 shows what the ribbon looks like now. Note that the ribbon changes to things that can be inserted into the document. The collections are ''Pages, Tables, Illustrations, Links, Header & Footer, Text,'' and ''Symbols''. In the ''Symbols'' collection you'll see the ''Equation'' icon. Click on the Equation icon. The arrow under the icon will show you the more common equations that Word already has stored. Unfortunately, they are rarely what we will want, so be careful to click on the icon and not the arrow under it. Two things happen. The ribbon changes to the ''Design'' tab to show things you can use to make an equation, and on the document an area appears that says ''Type equation here''.<br style="clear: both;" />Sometimes when an equation is inserted into a document, the equation area will be in the middle of the page. This means that Word has switched to full justification to make the equation look pretty. This is not what we want, so we'll click on the ''Home'' tab, put the paragraph back to left alignment, and return to the ''Design'' tab to continue working.
## [[Image:Lab_intro_5.png|thumb|500px|right|Figure 11: Insert ribbon]]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'' collection. Click on the ''Fraction'' icon. 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 collection (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'' collection. 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 "b<sup>2</sup>"), 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 b<sup>2</sup> term, and fill in the rest of the numerator, i.e., "-4ac".
### 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.<br style="clear: both;" />
## Press the tab key and the cursor will jump to the tab stop 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''
## Now, type the text paragraphs and give them the following attributes:
##: "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 points, aligned left''
##: ''Leave an empty line since most addresses take up two lines. Times New Roman 12 points, 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.
## [[Image:Lab_intro_36.png|thumb|350px|right|Figure 12: Line spacing.]]Select the line spacing using the Line Spacing icon in the ''Paragraph'' collection. This icon is in the middle of the bottom row of this collection, next to the alignment 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:
### for all text that is aligned right, use single spacing
### for all text that is centered, use double spacing
### for all text that is aligned left, use 1.5-line spacing
### for all text that is inside the table, use single spacing<br style="clear: both;" />
## [[Image:Lab_intro_37.png|thumb|250px|right|Figure 13: Saving work.]]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 your account's Documents folder.<br style="clear: both;" />
## [[Image:Lab_intro_7.png|thumb|350px|right|Figure 14: Insert table.]]Insert a table.
### 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.
### 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.
### 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 dialog box that allows us to build a custom table.
### For your Word document, select 6 columns and 25 rows, and click OK. This will create your table and move you to the Design ribbon for the table.
### 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 to highlight. Make all the cells  Arial, 10 points, center alignment 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 8AM to 8PM. Each row should contain one half-hour interval, e.g. 8:00 &ndash; 8:30. However, the row should not contain the AM or PM identifiers since the context is obvious.
## 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.<!--
### Highlight the Club Hour cells (Monday and Wednesday 12:00 noon to 1:30 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.
### [[Image:lab_intro_8.png|thumb|350px|right|Figure 15: Background color gallery]]In the ''Paragraph'' collection, 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 gallery shown in Figure 15 appears. 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.<br style="clear: both;" />
### [[Image:lab_intro_9.png|thumb|350px|right|Figure 16: Font color change]]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 ''Font'' collection. This brings up the gallery shown in Figure 20 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.<br style="clear: both;" />-->
### [[Image:lab_intro_10.png|thumb|350px|right|Figure 15: Table border.]]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 to highlight. In the ''Paragraph'' collection, 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 drop down menu shown on the left side of Figure 15.
### Click on the last item in the menu: ''Borders and shading''. This will bring up the dialog box shown on the right side of Figure 15.
### On the left side of the dialog box 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 ''Style'': list until we see the double lines. Click on it to select it, and click on OK.
### 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 15. For the ''Style'', 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. As an alternative, you can click on the buttons surrounding the preview. Just click on the button in the middle of the left side and the button in the middle on the bottom of the preview to achieve the same effect. Click OK and the table is complete.<br style="clear: both;" />
## Save the changes that have been made by selecting ''Save'' from inside the ''Microsoft Office Button'' or ''File'' tab.
## [[Image:lab_intro_11.png|thumb|350px|right|Figure 16: WordArt.]]Finally, you will learn to use WordArt.
### Place the cursor where you want your object to appear.
### Click on the ''Insert'' tab to get the proper ribbon. On the right side is the ''WordArt'' icon. Click on it.
### A gallery of choices will appear. Select one that's shown in Figure 16. Click OK.
### Type "EG1004" in the box that appears. Click OK.
### WordArt's default wrap text setting is ''In Front of Text'', which means it "floats above" text.  On the ''Format'' tab, choose ''In Line with Text'' to make it exist on the line, so you can align it. Make sure your generic document looks like the one in Figure 16.<br style="clear: both;" />
## Save the document again.
## Now it is time to personalize your document.
### [[Image:Lab_intro_38.png|thumb|250px|right|Figure 17: Save As.]]Select ''Save As'' from the ''File'' menu.  Name the file "lab01personal.docx" and save it in the "My Documents" folder on the lab computer.<br style="clear: both;" />
### Personalize the generic document you just created, keeping the appropriate attributes.
### Save this new file.


<p>Most software has a built-in reference manual to help you learn
== Microsoft Excel ==
the program.  Always look for a Help menu on the toolbar, and use it
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 18.
whenever you are in doubt about how to do somethingThis, and regularly saving your work, will save
: [[Image:lab_intro_12.png|thumb|650px|left|Figure 18: Excel Document]]<br style="clear: both;" />
you many lost hours over your working lifetime.</p>
# Launch Microsoft Excel. To do this, open the Start Menu, navigate to the ''Microsoft Office'' menu item and expand it. Click the ''Microsoft Excel 2007'' or ''Microsoft Excel 2010'' menu item.
#: ''Alternatively, you can type "excel" into the search field of the Start Menu and click on '''Microsoft Excel 2010'''''.
# [[Image:lab_intro_13.png|thumb|450px|right|Figure 19: Create header.]]Creating a Header
## In the new, blank workbook that opens, select the <b><i>Page Layout</i></b> tab. This will bring up the ribbon shown at the top of Figure 19.
## In the <b><i>Sheet Options</i></b> collection, click on the arrow in the bottom right corner. This will bring up the <b><i>Page Setup</i></b> dialog box. Click on the <b><i>Header/Footer</i></b> tab. Click on the button that says <b><i>Custom Header</i></b>. A new dialog box with three text areas 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.
## Click "OK" to save this information. Click "OK" again to remove the "Page Setup" window and return to the spreadsheet.
#: <b>Note</b>: <i>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 <b>Microsoft Office Button</b>, then the <b>Print</b> icon, and then the <b>Print Preview</b> icon on the popup menu in MS Excel 2007. In MS Excel 2010, click on the '''File''' tab and then the '''Print''' item on the left.</i><br style="clear: both;" />
# Setting up Your Worksheet
#: <b>Note:</b> 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:
## In cell <b><i>A1</i></b>, enter <b><i>Term</i></b>
## In cell <b><i>B1 </i></b>enter <b><i>Number</i></b>
## In cell <b><i>C1 </i></b>enter <b><i>Unit(s)</i></b>
## In cell <b><i>A2</i></b>, enter <b><i>n</i></b>
## In cell <b><i>B2</i></b>, enter the value provided by your TA
## In cell <b><i>C2</i></b>, enter <b><i>mol</i></b>
## in cell <b><i>A3</i></b>, enter <b><i>R</i></b>
## In cell <b><i>B3 </i></b>enter <b><i>0.082057</i></b>
## [[Image:Lab_intro_39.png|thumb|450px|right|Figure 20: Superscripts.]]In cell <b><i>C3</i></b>, enter <b><i>L*atm*mol<sup>-1</sup>*K<sup>-1</sup></i></b>
##: <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> collection. 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.<br style="clear: both;" />
## In cell <b><i>A4</i></b>, enter <b><i>P</i></b>
## In cell <b><i>B4</i></b>, enter <b><i>1</i></b>
## In cell <b><i>C4</i></b>, enter <b><i>atm</i></b>
#: [[Image:lab_intro_13a.png|thumb|450px|right|Figure 21: Symbol pallette]]<b>Note:</b> In the next few cells, you'll be inserting the degree symbol. 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 palette shown in Figure 21.
#: Make sure the <b><i>Symbol</i></b> 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. Select it.
#: 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 palette.<br style="clear: both;" />
#: Next, we'll create a table of computed values.  To do this, type the following text into your Excel worksheet:
## In cell <b><i>A6</i></b>, enter <b><i>Temperature</i></b> <b><i>(&deg;F)</i></b>
## In cell <b><i>B6</i></b>, enter <b><i>Temperature (&deg;C)</i></b>
## In cell <b><i>C6</i></b>, enter <b><i>Temperature (K)</i></b>
## In cell <b><i>D6</i></b>, enter <b><i>Volume (L)</i></b>
#: Enter Fahrenheit temperatures 0 – 45 &deg;F into cells <b><i>A7</i></b> through <b><i>A16</i></b>, increasing the temperature by 5 &deg;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 (=).
#: [[Image:lab_intro_13c.png|thumb|450px|right|Figure 22: Formulas ribbon]]As an example of the syntax, the formula "= 5*(<b><i>P98</i></b>)+ABS(<b><i>X15</i></b>)/0.34" would take the value in cell <b><i>P98</i></b> and multiply it by five, and then add the result to the absolute value of the contents of cell <b><i>X15</i></b> divided by 0.34. If you are in doubt about the order of the mathematical operations, use 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 22.<br style="clear: both;" />
#: 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 <b><i>Insert function</i></b> 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:
#: <math>^\circ C = \frac{5}{9} \left( ^\circ F - 32 \right)\,</math>
## Enter "=5/9*(<b><i>A7</i></b>-32)" into cell <b><i>B7</i></b>.
## Now we'll copy the formula into other cells. To do this, click on the cell. 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.
## Click on the cells between <b><i>B7</i></b> and <b><i>B16</i></b> 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:
#: <math>K = ^\circ C + 273.15\,</math>
## Enter "=<b><i>B7</i></b>+273.15" into cell <b><i>C7</i></b>.
## Copy this formula into the cells <b><i>C8</i></b> through <b><i>C16</i></b> using the same method we used earlier.
## Click on the cell <b><i>C16 </i></b>and look at the contentsNotice that the cell reference in the formula (<b><i>B7</i></b>) has automatically been adjusted to <b><i>B16</i></b>.
#: You will use the ideal gas law expression to compute the volume for your exercise:
#: <math>V = \frac{nRT}{P}\,</math>
## 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>.
## Copy this formula into the cells <b><i>D8</i></b> through <b><i>D16</i></b> using the same method we used earlier.
## Click on cell <b><i>D16 </i></b>and notice that all the cell references except <b><i>C7</i></b> have been kept constant.  Typing a <b><i>$</i></b> before a cell reference letter or number fixes the value, even if is it later copied. Two <b><i>$</i></b> keeps both the cell letter and the cell number constant.
# 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.
## [[Image:Lab_intro_17.png|thumb|250px|right|Figure 23: Column Edge]]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 23.<br style="clear: both;" />
## 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.
## [[Image:Lab_intro_17a.png|thumb|450px|right|Figure 24: Format Cells dialog box]]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 <b><i>Font</i></b> collection in the <b><i>Home</i></b> tab to bring up the <b><i>Format Cells</i></b> dialog box shown in Figure 24.<br />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.<br />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.<br style="clear: both;" />
# [[Image:Lab_intro_17b.png|thumb|350px|right|Figure 25: Format Cells dialog box: border tab]]Creating Table Borders
#: As part of this section, you'll see a different way to work with cells.
## In your Excel worksheet, highlight the table of constants (cells A1-C4), and right click within the highlighted area.
## 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.
## In the Format Cells dialog box, go to the Border tab. This will change the dialog box to what's shown in Figure 25:
## 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" preset. 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.
## 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.<br style="clear: both;" />
## [[Image:Lab_intro_17c.png|thumb|350px|right|Figure 26: Format Cells dialog box: fill tab]]Next, we'd like to shade the column headers so they stand out more. Click on the "Home" tab on the ribbon. In the ''Font'' collection, click on the arrow next to the paint can to see the gallery shown in Figure 26.
## 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.<br style="clear: both;" />
## Repeat steps 1-6 for the table of computations.
# [[Image:Lab_intro_17e.png|thumb|450px|right|Figure 27:Scatter chart pallette]]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:
## Select the temperature and volume values in cells <b><i>C7–D16</i></b>.
## Click on the <b><i>Insert</i></b> tab on the ribbon. The ribbon will change to what's shown in Figure 27.
## The <b><i>Chart</i></b> collection 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 27.
## On the pallette, click on the first icon: Scatter with only markers.<br style="clear: both;" />
## [[Image:Lab_intro_17f.png|thumb|450px|right|Figure 28: Design ribbon for chart]]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 28.
## 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.<br style="clear: both;" />
## Now we'll customize the chart by adding the axis labels and title. In the <b><i>Chart Layouts</i></b> collection, 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.
## Click on the vertical axis title. Highlight the existing text that says "Axis Title" and change it to "Volume (L)".
## Click on the horizontal axis title. Highlight the existing text that says "Axis Title"and change it to "Temperature (K)".
## Click on the title. Highlight the existing text that says "Chart Title" and change it to "Volume (L) vs. Temperature (K)".
## Click on the <b><i>Series 1</i></b> 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 <b><i>Delete</i></b> key and the legend will disappear. The chart will also automatically resize to fill the space.
# [[Image:Lab_intro_17g.png|thumb|450px|right|Figure 29: Format Tendline dialog box]]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:
## Select any data point on your chart. Excel will automatically select all remaining points for you.
## 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 29.
## 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.<br style="clear: both;" />
# Adding a Caption to Your Chart
## 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.
## [[Image:Lab_intro_17h.png|thumb|450px|right|Figure 30: Alignment dialog box]]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 <b><i>Format Cells</i></b> dialog box that you saw earlier appears. Click on the <b><i>Alignment</i></b> tab, and the dialog box changes to Figure 30.
## 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 "General" and a dropdown menu appears. Click on <b><i>Center</i></b>.
## In the <b><i>Text control</i></b> area, check the Wrap Text and Merge Cells checkboxes, and click <b><i>OK</i></b>.<br style="clear: both;" />
## In the highlighted cells, enter a suitable caption for your chart.
# Since we're done with the worksheet, we'll save it for submission.


<p>You are going to create two Microsoft Word documents.  One will look like Figure 1 below.</p>
== Microsoft PowerPoint (Optional Exercise) ==
Now you will create a PowerPoint presentation reporting on the work done in <b><i>Lab 1</i></b>. PowerPoint has five viewing windows. Slide View displays one slide at a time, Outline View lists the text for each slide in your presentation, Slide Sorter View displays thumbnails of all your slides allowing you to reorder them easily, and Notes Page View lets you attach text to each slide. Finally, you can view your slides in order in the Slide Show View.


<p align=center>[[Image:lab_intro-1.JPG]]</p>
For your labs, 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 31 contains some examples of what your slides might look like.


<p class=caption>Figure 1: Generic Word document</p>
:[[Image:lab_intro_24.png|thumb|650px|left|Figure 31: Typical PowerPoint slides]]<br style="clear: both;" />


<p>The other will be personalized, and will look like Figure 2.</p>
# 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 32). Click where it says, "Click to add title" and enter the title of your presentation.
#: [[Image:Lab_intro_25.png|thumb|650px|center|Figure 32: Microsoft PowerPoint, main window. Your screen will look like this when you begin a new presentation.]]<br style="clear: both;" />
# From the <b><i>Slide</i></b> group, click on the <b><i>New Slide</i></b> icon. This will advance your presentation to the next slide, which will be blank. When you select this, PowerPoint will display a number of alternatives for you to choose from on how to layout your next slide. Choose the one you like best.
# Click anywhere inside the box marked "Click to Add Text" and insert your information. Continue this process until you have outlined your entire presentation.
# 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 <b><i>Design</i></b> tab on the ribbon. The <b><i>Themes</i></b> 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 theme are shown in the 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.
#: [[Image:lab_intro_25a.png|thumb|650px|left|Figure 33: Theme dialog box]]<br style="clear: both;" />
#: 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. In 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.
#: <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 letters 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>
#: '''<span style="color: red;">IMPORTANT: </span>'''Make sure you run Spell Check when you have completed your presentation! To run it, hit F5. After making any corrections, save your presentation.


<p align=center>[[Image:lab_intro_2.jpg]]</p>
=== Printing Instructions for Recitation ===
You can print a copy of your presentation just like Word and Excel. To print a copy of your PowerPoint Presentation:
# Click on the ''Microsoft Office'' button or ''File'' tab. From the menu that appears, click on the <b><i>Print</i></b> icon. In MS Office 2007, a dialog box with the following options will appear. In MS Office 2010, the Backstage View will appear with the following options.
#: [[Image:lab_intro_26.png|thumb|650px|left|Figure 34: Microsoft PowerPoint Print dialog box.]]<br style="clear: both;" />
# In the box marked Print what: select <b><i>Handouts</i></b>.
# In the box marked Color/grayscale select <b><i>Pure Black and White</i></b>.
# In the box marked Slides per page choose <b><i>six</i></b>, using <b><i>Horizontal</i></b> border.
# Click OK to print.
Your lab work is now complete. <b>Email</b> copies of all the files you created to your personal account. Review the files for errors before submitting your report.


<p class=caption>Figure 2: Personalized Word document</p>
Please clean up your workstation before you leave the lab. Refer to section <b><i>3 Your Assignment </i></b>for the list of the specific items you must submit for your report.


<ol>
{{Laboratory Experiments}}
<li>To open Microsoft Word, go to the Start menu, select Lab Menu then select Lab 1 and click on
Microsoft  Word.</li>
 
<p>It is a good idea to use the plain Times New Roman 12 pt font, with full justification as
your default, i.e., your starting font and format.  Font and paragraph adjustments are located in
the Format menu on the main menu bar, as well as on the formatting toolbar.  The paragraph
alignment buttons looks like this:</p>
 
<p>[[Image:lab_intro_3.gif]]</p>
 
<li>On the blank MS Word document page that opens, type the text in quotes below, without including the
quotes or the italicized attributes:</li>
 
<p>“Section ??�? with the following attributes:<i> Courier New 48pt, aligned right</i></p>
<p>“First TA�? <i>Times New Roman 12pt, aligned right</i></p>
<p>“Second TA�? <i>Times New Roman 12pt, aligned right</i></p>
<p>“Name�? <i>Arial 24pt, underlined, centered</i></p>
 
<p>“email address�? <i>Courier New 16pt, bold, aligned left</i></p>
<p>“Address�? <i>Times New Roman 12pt, aligned left</i></p>
<p>“Phone Number�? <i>Times New Roman 12pt, aligned left</i></p>
 
<p>The attributes should be applied to the typed text using the program menus.  The attributes can be
selected before you type the appropriate text, or applied afterward by selecting (highlighting) the
text and then applying the attributes.</p>
 
<p>Use the <b><i>Fonts</i></b> dialog box, found in the <b><i>Format</i></b> menu, to apply the required
fonts (see Figure 3).</p>
 
<p align=center>[[Image:lab_intro_4.gif]]</p>
 
<p class=caption>Figure 3: Fonts dialog box</p>
 
<p>Use the Paragraph dialog box, found in the Format menu, to get the required alignment (see Figure 4).</p>
 
<p align=center>[[Image:lab_intro_5.gif]]</p>
 
<p class=caption>Figure 4: Paragraph dialog box</p>
 
<p>Select the line spacing using the Line Spacing menu. Use the following line spacing instructions
for your Word document:</p>
 
<ol type="a">
<li>for all text that is aligned right, use single spacing</li>
<li>for all text that is centred, use double spacing</li>
<li>for all text that is aligned left, use 1.5-line spacing.</li>
</ol>
 
<li>It is a good idea to periodically save your work. To do this, select Save from the File menu. Name
the file “lab01generic.doc�? and save it in the “My Documents�? folder on the lab computer. Later, you must
<b>e-mail</b> all the files you create to your personal e-mail account so you can include them
in your lab report.</li>
 
<li>Now you will insert an equation into the Word document you have created.</li>
 
<ol type="a">
<li>Position the cursor just in front of the word "Section" and left click the mouse. A vertical bar will
appear, meaning this is where the equation will be placed.</li>
 
<li>From the Insert menu select Object. The box shown in Figure 5 will appear.</li>
 
<p align=center>[[Image:lab_intro_6.gif]]</p>
 
<p class=caption>Figure 5: Object dialog box</p>
 
<li>Select Microsoft Equation 3.0 from the list and click OK. The Equation
toolbar shown in Figure 6 will appear.</li>
 
<p align=center>[[Image:lab_intro_7.gif]]</p>
 
<p class=caption>Figure 6: Equation toolbar</p>
 
<li>To insert the desired quadratic equation in the upper left-hand corner of the page, proceed as follows:</li>
 
<ul>
<li>Select Text from the Style menu and then begin by typing “x=�? (as usual, without the quotes).</li>
 
<li>Select the ratio option from the Equation palette (see Figure 7).</li>
 
<p align=center><b><i>[[Image:lab_intro_8.gif]]</i></b></p>
 
<p class=caption>Figure 7: Ratio menu</p>
 
<li>Type “-b�? and then select the plus-or-minus symbol from the Equation palette (see Figure 8).</li>
 
<p align=center>[[Image:lab_intro_9.gif]]</p>
 
<p class=caption>Figure 8: plus-or-minus symbol</p>
 
<li>Select the radical (square root) symbol from the Equation palette, which is found on the same menu as the ratio option.</li>
 
<li>To superscript text (necessary for the “2�? in “b<sup>2</sup>�?), go to the super/sub script
menu on the Equation palette (see Figure 9).</li>
 
<p align=center>[[Image:lab_intro_10.gif]]</p>
 
<p class=caption>Figure 9: super/subscript menu</p>
 
<li>Complete the expression by typing the remaining characters in the appropriate places.  When you are finished, click outside the
equation box to return to the ordinary word processing mode.</li>
 
<li>Click on the equation and a black frame will appear around it. Right click on the equation, and a drop down menu will appear.
Select "Format Object".</li>
 
<li>Click on the "Layout" tab, and the picture above "In Front of Text". This will allow you to move the equation around. Click "OK".</li>
 
<li> Click and hold down the mouse on the equation. As you move the mouse around, you'll be dragging the equation with you.
Drag the equation to the left side of the line and release the mouse. The equation is now where you want it.</li>
 
</ul>
 
</ol>
 
<li>Next, you will insert a table.</li>
 
<ol type="a">
<li>From the Table menu select Insert, then Table.The box shown in Figure 10 will appear.</li>
 
<p align=center>[[Image:lab_intro_11.gif]]</p>
 
<p class=caption>Figure 10: Insert Table dialog box</p>
 
<li>For your Word document, select 6 columns and 14 rows.  Make all column and row headings bold and use
Arial, 10pt for the text in the table. Center the table on the page.  Label the columns with the five days of the
week.  Label the rows from 8 AM to 9PM. Each row should contain one hour, e.g. 8:00 AM – 9:00 AM.</li>
</ol>
 
<li>Now you will shade the cells and change the borders of your tables.  The entire
perimeter of each table should have a double-lined border. The Club Hour cells should be shaded.</li>
 
<ol type="a">
<li>Highlight the Club Hour cells (Monday 1:00 pm to 2:00.pm and Wednesday 12:00 noon to 2:00 pm). To
highlight an individual cell, place the cursor at the left end of the cell.  The cursor will become a black,
bolded, angled arrow.  Once this arrow appears, click once to highlight the cell.</li>
 
<li>On the Format menu, click Borders and Shading. Click the Shading tab and select 25% gray from the color palette. Highlight 'Club Hours' and change text color to white.</li>
 
<li>Now click on the Borders tab.  Select the double line from the Style list and then select Table from the Apply to drop-down menu.</li>
</ol>
 
<li>Save the changes that have been made by selecting <b><i>Save</i></b> from the <b><i>File</i></b> menu.</li>
 
<li>Finally, you will learn to use Word Art.</li>
 
<ol type="a">
 
<li>Place the cursor where you want your object to appear.</li>
 
<li>On the Insert menu, select Picture, then Word Art.</li>
 
<li>A gallery of choices will appear. Select one that resembles our example. Click OK.</li>
 
<li>Type “EG1004�? in the box that appears.  Click OK.</li>
</ol>
 
<li>Save the document again.</li>
 
<li>Now it is time to personalize your document.</li>
 
<ol type="a">
<li>Select <b><i>Save As</i></b> from the <b><i>File</i></b> menu.  Name the file “lab01personal.doc�? and save it
in the “My Documents�? folder on the lab computer.</li>
 
<li>Personalize the generic document you just created, keeping the appropriate attributes.</li>
 
<li>Save this new file and proceed to the technical writing exercise on software documentation.</li>
</ol>
 
</ol>
 
<h3>Software Documentation:</h3>
 
<p>As an example of the use of Word, prepare a short piece of software documentation.  When preparing
to write documentation to support the efficient and effective use of software like Word, Excel and PowerPoint,
the first step is always to assess the likely user. There are many ways to do this. One of the best is to
interview them. For this exercise, your lab partner will be your user.  Assume you have graduated if you are
not now working. Ask your partner the following four questions and note the answers. You will find prepared
sheets for your lab notes on the EG website.  There are three types: graphed, lined, and unlined. For this
assignment use the lined paper.  Your lab notes will be reviewed weekly by the <b>WC</b> throughout the semester.</p>
 
<ul>
<li>What is your job?</li>
<li>Tell me one way you use computers in your job.</li>
 
<li>Are you a novice, experienced or expert computer user?</li>
<li>When you load a new software package, how do you learn to use it?</li>
</ul>
 
<p>Then, using Word, write a one-paragraph user profile. For example:</p>
 
<p><i>Dave Stewart is an Electrical Engineer. He
uses his computer to prepare schematics of the designs he creates. He is an
experienced computer user who learns about new software by first talking to
colleagues.</i></p>
 
<p>Save this profile as a Word file “lab01SoftwareDocument.doc�? and
use it to help prepare a set of software instructions for your user. After the
lab session, choose a simple function from one of the programs you used in this
Lab and write a list of three to five steps to accomplish a specific task. Make
sure you clearly specify the function chosen and that you write in complete
sentences. For example:</p>
 
<p><b><i>To insert a comment (Microsoft Word):</i></b></p>
 
<ol>
<li>Put the cursor where you would like the comment inserted.</li>
<li>Pull down the <b><i>Insert</i></b> menu and select <b><i>Comment</i></b>.</li>
<li>Type the text for the comment.  You can see the text in the box at the bottom of the screen.</li>
<li>Click anywhere in the document outside the comment area to finish.</li>
<li>To delete a comment, right-click on the comment and select <b><i>Delete Comment</i></b>.
 
</ol>
 
<p><b><i>Microsoft Excel</i></b></p>
 
<p>Now you will create a Microsoft Excel document.  Your Excel document will include two tables and a graph showing
how the volume of a gas changes when its temperature changes.  Your Lab TAs will supply each student with a
different value for the number of moles, n.  The relationship you will graph is known as Charles’ Law. When
you are finished, your document will look like Figure 11.</p>
<p align=center>[[Image:lab_intro_12.jpg]]</p>
<p class=caption>Figure 11: Excel Document</p>
 
<p>To open Microsoft Excel, go to the Start menu, select Lab Menu then select Lab 1 and click on Microsoft Excel.</p>
 
<p><b>Creating a Header</b></p>
 
<ol>
<li>In the new, blank workbook that opens, select <b><i>Header</i></b> and <b><i>Footer</i></b> from the <b><i>View</i></b>
menu and click on the Custom Header button (See Figure 12).</li>
 
<p align=center>[[Image:lab_intro_13.jpg]]</p>
 
<p class=caption>Figure 12: Custom Header dialog box</p>
 
<li>In the Left section: box type your name.  In the Center section: box type “Lab 1: Excel Exercise.�?  In the Right section:
box type your section. Click "OK" to save this information. Click "OK" again to remove the "Page Setup" window and return to
the spreadsheet.</li>
</ol>
 
<p><b>Note</b>: <i>The Header is not visible on the Excel spreadsheet as you work; it is
inserted when the sheet is printed.  You
can use the </i>Print Preview<i> in the<b> </b></i>File menu<i> to preview the final
document.</i></p>
 
<p><b>Setting up Your Worksheet</b></p>
 
<p>To complete the exercise, you will create two tables. The first one is a table of constants. To create it, enter the
following information into your Excel worksheet:</p>
 
<ol>
<li>In cell <b><i>A1</i></b>, enter <b><i>Term</i></b></li>
<li>In cell <b><i>B1 </i></b>enter <b><i>Number</i></b></li>
 
<li>In cell <b><i>C1 </i></b>enter <b><i>Unit(s)</i></b></li>
<li>In cell <b><i>A2</i></b>, enter <b><i>n</i></b></li>
<li>In cell <b><i>B2</i></b>, enter the value provided by your TA</li>
<li>In cell <b><i>C2</i></b>, enter <b><i>mol</i></b></li>
 
<li>in cell <b><i>A3</i></b>, enter <b><i>R</i></b></li>
<li>In cell <b><i>B3 </i></b>enter <b><i>0.082057</i></b></li>
<li>In cell <b><i>C3</i></b>, enter <b><i>L*atm*mol<sup>-1</sup>*K<sup>-1</sup></i></b></li>
 
<li>In cell <b><i>A4</i></b>, enter <b><i>P</i></b></li>
<li>In cell <b><i>B4</i></b>, enter <b><i>1</i></b></li>
<li>In cell <b><i>C4</i></b>, enter <b><i>atm</i></b></li>
</ol>
 
<p>To create the superscripted text necessary for cell <b><i>B2</i></b>, highlight the text you want
superscripted and select Cells from the Format menu.  Check the superscript box.</p>
 
<p><b>Note:</b>In the next few cells, you'll be inserting the degree symbol. To do this, just type all
the text except the degree symbol, and then come back and insert the degree symbol using the instructions
in the next note.</p>
 
<p>Next, you will create a table of computed values.  To do this, type the following text into your
Excel worksheet:</p>
 
<ol>
<li>In cell <b><i>A6</i></b>, enter <b><i>Temperature</i></b> <b><i>(&#730;F)</i></b></li>
<li>In cell <b><i>B6</i></b>, enter <b><i>Temperature (&#730;C)</i></b></li>
<li>In cell <b><i>C6</i></b>, enter <b><i>Temperature (K)</i></b></li>
<li>In cell <b><i>D6</i></b>, enter <b><i>Volume (L)</i></b></li>
</ol>
 
<p><b>Note:</b> To insert the <b>&#730;</b> symbol, pull down the Insert menu and choose the Symbol Palette.
Choose the appropriate symbol and click Insert.</p>
 
<p>Enter Fahrenheit temperatures 0 – 45 &#730;F into cells <b><i>A7</i></b> through <b><i>A16</i></b>,
increasing the temperature by 5 &#730;F in each successive cell.</p>
 
<p><b>Using Formulas</b></p>
 
<p>Formulas perform calculations in your worksheet.  The calculations may use values in other cells, making
Excel a very powerful calculator program.  A formula is entered in the destination cell where you want the
answer to appear. Excel has many built in functions that you can use.  The destination cell value is the implied
result and so a formula always starts with an equal sign (=).</p>
 
<p>As an example of the syntax, the formula “= 5*(<b><i>P98</i></b>) +ABS(<b><i>X15</i></b>)/0.34�? would take the
value in cell <b><i>P98</i></b> and multiply it by five, and then add the result to the absolute value of the contents of
cell <b><i>X15</i></b> divided by 0.34.  If you are in doubt about the order of the mathematical operations,
use brackets to make sure the result is calculated correctly.  The full range of functions can be selected from
the formula menu or by using the <b><i>fx </i></b>button on the toolbar<b><i>.</i></b></p>
 
<p>You will use the following expression to convert your simulated data into degrees Celsius:</p>
 
<p align=center>[[Image:lab_intro_14.gif]]</p>
 
<ol>
<li>Enter “=5/9*(<b><i>A7</i></b>-32)�? into cell <b><i>B7</i></b>.</li>
 
<li>Copy the formula by dragging the fill handle (solid square on the bottom right of the <b><i>B7</i></b> cell)
all the way down to cell <b><i>B16.</i></b></li>
 
<li>Click on the cells between <b><i>B7</i></b> and <b><i>B16 </i></b>and examine the contents. Notice that the
cell reference in the formula has automatically been adjusted in each destination cell.</li>
</ol>
 
<p>You will then use the following expression to convert your data into Kelvin:</p>
 
<p align=center><sub>[[Image:lab_intro_15.gif]]</sub></p>
 
<ol>
<li>Enter “=<b><i>B7</i></b>+273.15�? into cell <b><i>C7</i></b>.</li>
 
<li>Copy the formula into the remaining cells in column <b><i>C</i></b> by selecting cell <b><i>C7</i></b>
and then dragging the fill handle all the way to cell <b><i>C16</i></b>.<b><i></i></b></li>
 
<li>Click on the cell <b><i>C16 </i></b>and look at the contents.  Notice that the cell reference in the formula
(<b><i>B7</i></b>) has automatically been adjusted to <b><i>B16</i></b>.</li>
 
</ol>
 
<p>You will use the ideal gas law expression to compute the volume for your exercise:</p>
 
<p align=center>[[Image:lab_intro_16.gif]]</p>
 
<ol>
<li>Enter “=(<b><i>$B$2</i></b> *<b><i>$B$3</i></b>*<b><i>C7)/$B$4</i></b>�? into cell <b><i>D7</i></b>.</li>
 
<li>Copy the formula into the remaining cells in column <b><i>D</i></b> by selecting cell <b><i>D7 </i></b>and
then dragging the fill handle all the way to cell <b><i>D16</i></b>.<b><i></i></b></li>
 
<li>Click on cell <b><i>D16 </i></b>and notice that all the cell references except <b><i>C7</i></b> have been
kept constant.  Typing a <b><i>$</i></b> before a cell reference letter or number fixes the value, even if is
it later copied. Two <b><i>$</i></b> keeps both the cell letter and the cell number constant.</li>
 
</ol>
 
<p><b>Formatting Your Tables</b></p>
 
<p>First, you need to be able to see the entire contents of each column. By default, Excel sets all columns to
the same width, and fields containing long strings of data can be obstructed by other columns.  However, Excel
can resize each column to make all the data it contains visible. Always review your data and decide if the number
of digits displayed in the worksheet is appropriate.</p>
 
<ol>
<li>Double-click the right edge of the column (see Figure 13).</li>
 
<p align=center>[[Image:lab_intro_17.gif]]</p>
<p class=caption>Figure 13: Column Edge</p>
 
<li>In our example two digits after the decimal point is appropriate. Adjust the display by highlighting the
data cells B7:D16 and selecting the tab under Cells in the Format menu.</li>
 
<li>Select number and two decimal places from the menu. You may also do this by using the increase decimal
or decrease decimal buttons on the formatting toolbar.</li>
 
<li>Changing the number of places in the "Volume" column now made the column too wide, since it no longer has
to hold so many places. Resize the column by double clicking the right edge of the column again.</li>
</ol>
 
<p><b>Creating Table Borders</b></p>
 
<ol>
<li>In your Excel worksheet, highlight the table of constants (cells A1-C4), and right-click within the
highlighted area.</li>
 
<li>From the context menu that appears, select Format Cells.</li>
 
<li>In the Format Cells dialog box, go to the Border tab.</li>
 
<li>Make the constant table professional looking by selecting the double lines in the bottom right corner of
the "Style", and the "Outline" preset. Now we'll put grid lines inside by selecting the single line in the
bottom left corner of "Style", and the "Inside" present. The preview picture will now show a grid with a double
line frame and single line inside lines. Click "OK", and you'll now see the table of constants being nicely framed.
</li>
 
<li>Next, we'd like to separate the column headers from the numbers. Highlight the column header cells (A1-C1), and
right click within the highligted area. Like before, select Format Cells from the context menu that appears and go
to the Border tab. Select the double lines in the bottom right corner of "Style" and the "Outline" present. Next, we'd
like to shade the column headers so they stand out more. Click on the "Pattern" tab and select the 25% gray box (next
to last row on the extreme right side, just above the right box. Click "OK", and you'll see that the column headers
now have their own frame and shading.</li>
 
<li>Repeat steps 1-5 for the table of computations.</li>
</ol>
 
<p align=center>[[Image:lab_intro_18.gif]]</p>
<p class=caption>Figure 14: Format Cells dialog box</p>
 
<p><b>Creating a Chart</b></p>
 
<p>As the final step in this exercise, you will be graphing the relationship between volume and temperature,
using the Chart feature in Excel. To create a chart:</p>
 
<ol>
<li>Select the volume values in cells <b><i>D7–D16</i></b>.</li>
 
<li>Click the Chart Wizard button.[[Image:lab_intro_19.gif]]</li>
 
<li>In the Chart Type dialog box, select XY (Scatter) chart type and leave the chart subtype
at the default setting (see Figure 15), then click Next.</li>
 
<p align=center>[[Image:lab_intro_20.gif]]</p>
<p class=caption>Figure 15: Chart Type dialog box</p>
 
<li>In the Chart Source dialog box, select the Series tab, as shown in Figure 16.</li>
 
<p align=center>[[Image:lab_intro_21.gif]]</p>
<p class=caption>Figure 16: Chart Source dialog box</p>
 
<li>Click on the Select From Worksheet button (the icon at the right end of the <u>X</u>
Values box). Excel will  allow you to select cells directly from your worksheet. Select cells
<b><i>C7–C16 </i></b>and press Enter.</li>
 
<li>Click Next and the Chart Options dialog box will appear (see Figure 17</li>
 
<p align=center>[[Image:lab_intro_22.gif]]</p>
 
<p class=caption>Figure 17: Chart Options dialog box</p>
 
<li>In the Chart Title: field, enter <b><i>Volume (L) vs. Temperature (K).</i></b></li>
 
<li>In the Value(X) axis: field, enter <b><i>Temperature (K)</i></b>.</li>
 
<li>In the Value (Y) axis: field, enter <b><i>Volume (L)</i></b>.</li>
 
<li>Click Next and the Chart Location dialog box will appear (see Figure 18).</li>
 
<p align=center>[[Image:lab_intro_23.gif]]</p>
 
<p class=caption>Figure 18: Chart Location dialog box</p>
 
<li>In the Chart Location dialog box, select As object in.</li>
 
<li>From the drop-down menu, select your current worksheet (see Figure 18).</li>
 
<li>Click Finish to create your chart.</li>
 
<li>Delete the Series 1 Legend box from your chart. Click on the Legend box and it
will be highlighted by having squares on it. Press the delete key to delete the box.</li>
</ol>
 
<p><b>Adding a Trendline</b></p>
 
<p>A trendline is a fit to data, indicating the general behavioral tendency or trend
of the data, if any. This allows you to more easily see the nature of any
relationship between the quantities in your graph. To add a trendline to your
chart:</p>
 
<ol>
<li>Select any data point on your chart. Excel will automatically select all remaining points for you.</li>
 
<li>Right-click within the chart. From the context menu that appears, select Add Trendline.</li>
 
<li>In the Type tab, select the Linear trend type.</li>
</ol>
 
<p><b>Adding a Caption to Your Chart</b></p>
 
<ol>
<li>Reposition the chart within your worksheet so that it does not obstruct your data tables. Do this
by clicking anywhere on the chart. Squares will appear around the border of the chart indicating that it
has been selected. Click the mouse, and "drag" the chart to where you want it, which is typically on the
left edge of the spreadsheet, with one row between the bottom of the data table and the top of the chart.</li>
 
<li>Select a set of cells beneath your graph roughly the same width as the graph, starting where you
want the caption to begin, and right-click within the selected group of cells. From the context menu
that appears, select Format Cells.</li>
 
<li>In the Alignment tab, check the Wrap Text and Merge Cells checkboxes, and click OK.</li>
 
<li>Enter a suitable caption for your chart.</li>
 
<li>Save your worksheet as “lab01excel.xls�? and print a copy on a single page.</li>
</ol>
 
 
<p><b><i>Microsoft PowerPoint</i></b></p>
 
<p>Now you will create a PowerPoint presentation reporting on the work done in <b><i>Lab 1</i></b>.
PowerPoint has five viewing windows. Slide View displays one slide at a time, Outline View lists
the text for each slide in your presentation, Slide Shorter View displays thumbnails of all your
slides allowing you to reorder them easily, and Notes Page View lets you attach text to each slide.
Finally, you can view your slides in order in the Slide Show View.</p>
 
<p>For this lab, your presentation must include a title slide, a
brief overview of the presentation, examples of the work done in this lab
(either screenshots, or material copied and pasted from the original documents)
and a conclusion slide. You may use any design template that you like. Use a
title slide at the beginning of your presentation and the bulleted slides for
the information that follows. Figure 19 contains some examples of what your
slides might look like.</p>
 
<p align=center>[[Image:lab_intro_24.gif]]</p>
 
<p class=caption>Figure 19: Typical PowerPoint slides</p>
 
<p>To open Microsoft PowerPoint, go to the Start menu, select Lab Menu then select Lab 1 and
click on Microsoft PowerPoint.</p>
 
<ol>
<li>From the dialog box displayed, select Blank Presentation, or select Blank Presentation from
the New Presentation toolbar on the right of the screen. A new slide will appear with the
default Title layout (see Figure 20). Click where it says, “Click to add title�? and enter
the title of your presentation. </li>
 
<p align=center>[[Image:lab_intro_25.jpg]]</p>
 
<p class=caption>Figure 20: Microsoft PowerPoint, main window. Your screen will look like
this when you begin a new presentation.</p>
 
<li>From the Insert menu, select New Slide (CTRL+M). Click on the new slide. Type the title of
the next slide. Click anywhere inside the box marked Click to Add Text and insert your information.
Continue this process until you have outlined your entire presentation.</li>
 
<li>To add an object from another software application, like Word or Excel, simply copy and paste
your object onto the selected PowerPoint slide.</li>
</ol>
 
<p>Microsoft PowerPoint allows you to customize the design of your presentation. You can
choose a design template in two ways depending on whether you are just starting your presentation
or have already created it.</p>
 
<p>To select a design template before you begin, select Design Template from the choices that appear
when you create a new file. Select the particular design template you would like to use for
your presentation.</p>
 
<p>To select a design template after you start, open the presentation, pull down the Format
menu, select Slide Design and apply the design template you like.</p>
 
<p><b>Note:</b><i> With this window open, you can adjust your color schemes, too. After selecting the
design template, click on </i>Color Schemes <i>and select the color you like. PowerPoint will apply this
color to your template. Remember, a light background with the letters in strong contrast is best.</i></p>
 
<h3><font color=#ff0000>IMPORTANT</font></h3>
<p>Make sure you run Spell Check when you have completed your presentation! To run it, hit F7.  After making any
corrections, save your presentation as “lab01PowerPoint.ppt.�?</p>
 
<p>To print a copy of your PowerPoint Presentation:</p>
 
<ol>
 
<li>From the File menu select Print. The box in Figure 21 will appear.</li>
 
<p align=center>[[Image:lab_intro_26.gif]]</p>
 
<p class=caption>Figure 21: Microsoft PowerPoint Print dialog box.</p>
 
<li>In the box marked Print what: select <b><i>Handouts</i></b>.</li>
 
<li>In the box marked Color/grayscale select <b><i>Pure Black and White</i></b>.</li>
 
<li>In the box marked Slides per page choose <b><i>six</i></b>, using <b><i>Horizontal </i></b>order.</li>
 
<li>Click OK to print.</li>
</ol>
 
<p>Your lab work is now complete. <b>e-mail</b> copies of all the files you created to your personal account.
Review the files for errors and complete the software documentation assignment before submitting your report.</p>
 
<p>Please clean up your workstation before you leave the lab. Refer to section <b><i>3 Your Assignment </i></b>for
the list of the specific items you must submit for your report.</p>
 
 
[[Main_Page | Return to Table of Contents]]

Latest revision as of 03:38, 18 August 2022

Important: Please note that you must register on the EG Website before performing the lab.

  1. Click on the register link as shown in Figure 1.
    Figure 1. Registration Link Identification.

  2. Fill in the appropriate information on the form shown in Figure 2 and submit it.
    Note: Please make sure that you capitalize the first letter of your first and last name.
    Figure 2. Registration Form.

  3. Select the type of ID card you possess. Based on the type of ID you have, you may be asked for different information. If a Unique ID is asked of you, it is the barcode on the back of your ID.
    Figure 3a. Registration Form Fields for Landscape IDs.
    Figure 3b. Registration Form Fields for Portrait IDs.

  4. Fill in the remaining information accordingly.
    Note: If your email is flast99@students.poly.edu or fml999@nyu.edu, then flast99 or fml999, respectively, will be your username.
    IMPORTANT!!: After you are registered, a TA must approve your account before you can log in.

Objectives

The objective of this lab is to use Microsoft Word, Excel, and PowerPoint to perform specific exercises and become accustomed with the tasks that each application is best suited for. Your goal is to complete the assigned tasks and obtain a basic familiarity with these three applications.

Overview

This lab is designed to introduce you to three Microsoft (MS) applications: Word, Excel and PowerPoint. These programs are widely used throughout academia and business so many of you may already have some familiarity with them. Completing your assignments in EG1004 will require a basic competency in them; the following exercises are designed to ensure you have this competency so please complete them.

Microsoft Office

With the recent release of MS Office 2010, EG1004 is in a transition period between MS Office 2007 and MS Office 2010. Either version of MS Office may be used to complete this lab. At this time, it is believed that there are no differences, other than cosmetic ones, which will impact how this lab is performed.

When Microsoft released MS Office 2007, they introduced a new user interface to the MS Office Suite. When a MS Office application is launched, you will see this new Ribbon interface at the top of the window. The Ribbon has several features. In the top-left corner of the windows is the Office Button, where functions that manage the document are found. MS Office 2010 replaced the button with the File tab. These functions include actions like opening, saving, and printing a document. Next to the Office Button, or above the Ribbon in MS Office 2010, 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 the MS Office application 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 file are located. At the top of the ribbon are a set of tabs, which operate like the tabs on physical folders in a file cabinet. Looking at the tabs, you can see the functions available. For example, upon launch you are on the Home tab. The area below the tab is organized into several collections which are named at the bottom of the ribbon. Collections are used to logically break down and group similar functions together. Figure 4 shows the initial Ribbon on the Home tab that you are presented with when MS Word is launched.

Figure 4. MS Word Ribbon: Home Tab.

Figure 5. Help Button

Clicking the question mark at the top right of any MS Office application will open its help manual. Use it as a reference whenever you are unsure of how to do something. This, and saving your work regularly, will save you many hours over your working lifetime.

Microsoft Word

MS Word is a word processing program. Its function is writing and editing text. It has features that make the mechanics of technical writing relatively easy, but it also has features that make academic dishonesty (e.g., plagiarism) easy as well. You are expected to do all exercises and assignments by yourself for all courses including this one, unless explicitly stated otherwise. Specifically for this course, the main exceptions to this rule are lab presentations (to be done with your lab partner(s) of the week), project presentations (to be done with your project partners) and team lab reports (to be done with your lab partner(s) of the week). You will be given adequate notice when a lab report is expected to be written as a team; otherwise, you are expected to write the lab report individually.

You can create tables and write equations in MS 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 MS Word to write lab reports. 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 Ribbon, select the Review tab. Then, in the Proofing collection, click on the Thesaurus icon, which looks like an open book. The equivalent words (synonyms) will be shown on the right side of the screen. Just double-click on the one you want to use.

Use in EG1004: writing lab reports.

Microsoft Excel

MS Excel is a spreadsheet program. Its function is collecting, manipulating, and analyzing data. This data can come from a variety of sources, including experiments and design calculations.

MS 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 and presentations.

Use in EG1004: general data manipulation and analysis. It is useful for uncovering the relationships between data sets and identifying trends. Graphs will be required for many lab reports and presentations.

Microsoft PowerPoint

MS 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 in which technical professionals need presentation skills.

Remember, MS 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 MS PowerPoint to report on your lab work and to present your progress on your semester-long design project.

MS PowerPoint is not a substitute for the longstanding rules that good public speakers adhere to. An effective presentation is one that illustrates the points that you want your audience to understand without taking the majority of their attention. Slides with excessive amounts of text do not illustrate anything and as such your presentation should not be written like a novel.

Use in EG1004: creating and giving presentations on your lab work and semester-long design project.

Your Assignment

Individual Lab Report

You do not have to write a lab report for this lab. However, you do have to write one for Lab 1A: Mousetrap Car Competition, which you will perform in the second half of the lab session.

You must submit two files to the EG website:

  1. MS Word file (.docx)
    • Title page
    • Generic document
    • Personalized document
      Note: The title page and Microsoft Word exercises should be in a single MS Word document, with the title page and each 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 Ribbon, and then click on the Page Break icon in the Pages collection.
    • Lab report (Mousetrap Car only)
  2. Excel file (.xlsx)
    • Tables and graph

IMPORTANT! Submit your report electronically using the EG website. You will need to login and upload the lab report material. Submission instructions are available. A syllabus showing the deadlines for your section are located on the EG website.


Materials and Equipment

  • Lab PC
  • Microsoft Office suite

Procedure

Microsoft Word

You will be creating the following two documents:

Figure 6. Generic Document (left) and Personalized Document (right).


Refer to this figure above as you follow the instructions below to spot any mistakes you may make.

  1. Launch Microsoft Word. To do this, click on the Windows icon in the bottom-left corner of the screen, which opens the Start Menu. Click on the All Programs item that appears just above the button. This will show you all the software on your computer. On the list that appears, click on the Microsoft Office menu item. This will expand to show the MS Office components. Click the Microsoft Word 2007 or Microsoft Word 2010 menu item.
    Alternatively, you can type "word" into the search field of the Start Menu and click on Microsoft Word 2010.
  2. Familiarize yourself with and set up your MS Word workspace.
    1. Figure 7. Enable the ruler.
      Enable the ruler. 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 7. In the Show collection, there's a box next to the word Ruler. By clicking on this box, we'll display rulers on the top and side of the electronic sheet of paper, allowing us to align text and objects. This will be very helpful later.
    2. Figure 8. Set font properties.
      Change the font face and size. Click on the Home tab and locate the Font collection. To understand this section of the ribbon, we need to discuss typography. A typed letter printed on a page or displayed on a screen has a number of attributes. The first is its font face, or font for short, which is how the letter looks. Fonts come in two different types. 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. MS Word has many fonts of both types to choose from. The second attribute a letter has is its size, specified in points, corresponding to the height of the letter. A point is 1/72 of an inch, so a 12 point letter will be 1/6 of an inch high. Figure 8 shows the Font collection. Notice how all the terms described 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 of Font collection, you'll see the font name of Calibri (Body) and next to it the font size of 11 points. Next to the font name you'll see a small arrow pointing downwards, indicating that there's a pull-down 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 font. Times New Roman is the font many newspapers use because it is very readable, and looks good as well.
    3. Add style to what you type. Finally, we can change how the letters look to add emphasis. We can make them bolded, italicized, 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 Font collection shown in Figure 8.
    4. Figure 9. Setting tab stops.
      Space out your paragraphs. We can decide how much blank space we want to follow a paragraph. In the Paragraph collection, click on the small arrow in the bottom-right corner of the collection, next to the collection name. This opens the dialog box also shown at the center of Figure 9. Under the Indents and Spacing tab, locate the Spacing options, where you can set 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 After box, highlighting the number, and type 0 (zero), indicating that no blank space should follow the paragraph. Now click the OK button.
    5. Align your text. We can choose how words fill the line on paper. The default is Left alignment which means the words start on the left side of the line and continue right until there is no more room and any text that follows is pushed to the left side of the next line. This is the way we write, where all the text is lined up on the left side of the page. There are other choices. We also have Centered alignment, where the text is centered on the line and if new text is smaller than the line what the line can hold, the existing text will shift left and right to accommodate the new text. There is also Right alignment, where the text is lined up against the right margin, and there is space on the left side. Finally, there is Justified and Distributed alignment. These two types of alignment make text appear as if text were both lined up on the left and right sides. With Justified alignment, space is added between words to make this possible. With Distributed alignment, space is added between characters. It is a good idea to use the Times New Roman 12-point font, with Justified alignment 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 collection shown in Figure 9. In the bottom-left corner of this collection you'll see the alignment choices. For this lab, we're not producing a formal report, so we'll use left alignment instead. Select the leftmost icon among the alignment buttons (shown as depressed in Figure 9) to do this. Also, note that if you hold the cursor over any icon, a small message, called a tool tip, will pop up telling you what the icon does.
    6. Set a right-aligned tab at the right margin (6.5 inches). 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 MS Word allows us to set tab stops at specific places. This is why showing rulers helps. For example, if we right align text, all the text will be right aligned, which might not be what we want. If we want text to be placed in a specific location, we create a tab stop. Once again, open the paragraph control window by clicking on the small arrow in the bottom right corner of the Paragraph collection shown in Figure 9. This brings up the Paragraph dialog box from before. Click on the Tabs... button in the bottom-left corner of the window, and a new window also shown in Figure 9 will appear.
      You can set the alignment of tab stops, just as you can align text with the margins of the page. With tab stops, you can align text five ways. You can align tab stops to the left, center, and right just as with the margins of the page. There are two additional alignments you can choose from. One is the Decimal alignment, where text at that tab stop position is aligned to a decimal point in a number. This is especially helpful when displaying data with decimal points without the use of a table. The last alignment doesn't actually align text: the Bar alignment inserts a vertical bar at the tab stop position. Again, this alignment may be useful to separate data without the use of a table.
      Leaders can also be set. Leaders are punctuation marks (none, decimals, dashes, underscores, or dots) that fill in the space between where the tab is started to the tab stop position.
      Where tab stops are placed is determined using the Ruler we previously activated. Tab stop positions are measured from the left margin of the paper. By default, the unit of measure is inches. To set a tab stop using the Tabs dialog box, select the type of alignment and type of leader you wish for the tab stop. Next, enter the position you wish to place your tab stop, measured in inches (by default) from the left margin of the paper, in the Tab stop position text box. When you are satisfied, click the Set button to create the tab stop. You can create as many tab stops as you wish. After all tab stops have been set, select OK to confirm all your selections.
  3. Create the generic document. This document will be used as a template and should look exactly like the one pictured
    1. Write the equation. Before we begin, check that the paragraphs we're going to create are initially set for left alignment. If the button that shows left alignment is not highlighted, click on it to select it. Now we're ready to start creating the page. First we'll make an equation.
    2. Focus on the workspace. 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 to bring it into focus. The vertical bar shows where the equation will be placed.
    3. Figure 10: Insert ribbon
      Click on the Insert tab. Figure 10 shows what the ribbon looks like now. Note that the ribbon changes to things that can be inserted into the document. The collections are Pages, Tables, Illustrations, Links, Header & Footer, Text, and Symbols. In the Symbols collection you'll see the Equation icon. Click on the Equation icon. The arrow under the icon will show you the more common equations that Word already has stored. Unfortunately, they are rarely what we will want, so be careful to click on the icon and not the arrow under it. Two things happen. The ribbon changes to the Design tab to show things you can use to make an equation, and on the document an area appears that says Type equation here.
      Sometimes when an equation is inserted into a document, the equation area will be in the middle of the page. This means that Word has switched to full justification to make the equation look pretty. This is not what we want, so we'll click on the Home tab, put the paragraph back to left alignment, and return to the Design tab to continue working.
    4. Figure 11: Insert ribbon
      To insert the desired quadratic equation in the upper left-hand corner of the page, proceed as follows:
      1. On the left side of the ribbon, you can select the kind of text you want. Select Normal Text from the list.
      2. Begin by typing "x=" (as usual, without the quotes).
      3. On the right side of the ribbon, you'll see the Structures collection. Click on the Fraction icon. 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.
      4. Type "-b" and then select the plus-or-minus symbol from the Symbols collection (this is called a gallery by Microsoft) on the ribbon. The symbol you want is the very first one shown.
      5. Click on the Radical icon from the Structures collection. Select the square root item from the palette, and click the box inside the radical on the document so we can fill it in.
      6. 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, i.e., "-4ac".
      7. 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. Press the tab key and the cursor will jump to the tab stop 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
    6. Now, type the text paragraphs and give them the following attributes:
      "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 points, aligned left
      Leave an empty line since most addresses take up two lines. Times New Roman 12 points, 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.
    7. Figure 12: Line spacing.
      Select the line spacing using the Line Spacing icon in the Paragraph collection. This icon is in the middle of the bottom row of this collection, next to the alignment 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
      4. for all text that is inside the table, use single spacing
    8. Figure 13: Saving work.
      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 your account's Documents folder.
    9. Figure 14: Insert table.
      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. 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 dialog box that allows us to build a custom table.
      4. For your Word document, select 6 columns and 25 rows, and click OK. This will create your table and move you to the Design ribbon for the table.
      5. 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 to highlight. Make all the cells Arial, 10 points, center alignment 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 8AM to 8PM. Each row should contain one half-hour interval, e.g. 8:00 – 8:30. However, the row should not contain the AM or PM identifiers since the context is obvious.
    10. Now you will change the borders of your tables. The entire perimeter of each table should have a double-lined border.
      1. Figure 15: Table border.
        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 to highlight. In the Paragraph collection, 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 drop down menu shown on the left side of Figure 15.
      2. Click on the last item in the menu: Borders and shading. This will bring up the dialog box shown on the right side of Figure 15.
      3. On the left side of the dialog box 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 Style: list until we see the double lines. Click on it to select it, and click on OK.
      4. 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 15. For the Style, 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. As an alternative, you can click on the buttons surrounding the preview. Just click on the button in the middle of the left side and the button in the middle on the bottom of the preview to achieve the same effect. Click OK and the table is complete.
    11. Save the changes that have been made by selecting Save from inside the Microsoft Office Button or File tab.
    12. Figure 16: WordArt.
      Finally, you will learn to use WordArt.
      1. Place the cursor where you want your object to appear.
      2. Click on the Insert tab to get the proper ribbon. On the right side is the WordArt icon. Click on it.
      3. A gallery of choices will appear. Select one that's shown in Figure 16. Click OK.
      4. Type "EG1004" in the box that appears. Click OK.
      5. WordArt's default wrap text setting is In Front of Text, which means it "floats above" text. On the Format tab, choose In Line with Text to make it exist on the line, so you can align it. Make sure your generic document looks like the one in Figure 16.
    13. Save the document again.
    14. Now it is time to personalize your document.
      1. Figure 17: Save As.
        Select Save As from the File menu. Name the file "lab01personal.docx" and save it in the "My Documents" folder on the lab computer.
      2. Personalize the generic document you just created, keeping the appropriate attributes.
      3. Save this new file.

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

Figure 18: Excel Document

  1. Launch Microsoft Excel. To do this, open the Start Menu, navigate to the Microsoft Office menu item and expand it. Click the Microsoft Excel 2007 or Microsoft Excel 2010 menu item.
    Alternatively, you can type "excel" into the search field of the Start Menu and click on Microsoft Excel 2010.
  2. Figure 19: Create header.
    Creating a Header
    1. In the new, blank workbook that opens, select the Page Layout tab. This will bring up the ribbon shown at the top of Figure 19.
    2. In the Sheet Options collection, click on the arrow in the bottom right corner. This will bring up the Page Setup dialog box. Click on the Header/Footer tab. Click on the button that says Custom Header. A new dialog box with three text areas 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.
    3. 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 in MS Excel 2007. In MS Excel 2010, click on the File tab and then the Print item on the left.
  3. 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. Figure 20: Superscripts.
      In cell C3, enter L*atm*mol-1*K-1
      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 collection. 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.
    10. In cell A4, enter P
    11. In cell B4, enter 1
    12. In cell C4, enter atm
    Figure 21: Symbol pallette
    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 palette shown in Figure 21.
    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. Select it.
    Now, click on the Insert button and the symbol will be inserted into the text. Finally, click on the Close button to close the palette.
    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.
  4. 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 (=).
    Figure 22: Formulas ribbon
    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 22.
    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:
    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 Home tab 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:
    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:
    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.
  5. 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. Figure 23: Column Edge
      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 23.
    2. 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. Figure 24: Format Cells dialog box
      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 collection in the Home tab to bring up the Format Cells dialog box shown in Figure 24.
      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.
      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.
  6. Figure 25: Format Cells dialog box: border tab
    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 25:
    4. 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" preset. 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.
    5. 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.
    6. Figure 26: Format Cells dialog box: fill tab
      Next, we'd like to shade the column headers so they stand out more. Click on the "Home" tab on the ribbon. In the Font collection, click on the arrow next to the paint can to see the gallery shown in Figure 26.
    7. 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.
    8. Repeat steps 1-6 for the table of computations.
  7. Figure 27:Scatter chart pallette
    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 27.
    3. The Chart collection is in the middle of the ribbon. Click on the Scatter icon. This will bring up the pallette shown in Figure 27.
    4. On the pallette, click on the first icon: Scatter with only markers.
    5. Figure 28: Design ribbon for chart
      The chart appears on your spreadsheet, and the ribbon changes to the Design tab so you can customize your chart, as shown in Figure 28.
    6. 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.
    7. Now we'll customize the chart by adding the axis labels and title. In the Chart Layouts collection, 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.
    8. Click on the vertical axis title. Highlight the existing text that says "Axis Title" and change it to "Volume (L)".
    9. Click on the horizontal axis title. Highlight the existing text that says "Axis Title"and change it to "Temperature (K)".
    10. Click on the title. Highlight the existing text that says "Chart Title" and change it to "Volume (L) vs. Temperature (K)".
    11. 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.
  8. Figure 29: Format Tendline dialog box
    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 29.
    3. 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.
  9. 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. Figure 30: Alignment dialog box
      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, and the dialog box changes to Figure 30.
    3. In the Text alignment area, for Horizontal, click on the arrow to the right of the word "General" and a dropdown menu appears. Click on Center.
    4. In the Text control area, check the Wrap Text and Merge Cells checkboxes, and click OK.
    5. In the highlighted cells, enter a suitable caption for your chart.
  10. Since we're done with the worksheet, we'll save it for submission.

Microsoft PowerPoint (Optional Exercise)

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 Sorter 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 your labs, 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 31 contains some examples of what your slides might look like.

Figure 31: 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 32). Click where it says, "Click to add title" and enter the title of your presentation.
    Figure 32: Microsoft PowerPoint, main window. Your screen will look like this when you begin a new presentation.

  2. 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 alternatives for you to choose from on how to layout your next slide. Choose the one you like best.
  3. Click anywhere inside the box marked "Click to Add Text" and insert your information. Continue this process until you have outlined your entire presentation.
  4. 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 theme are shown in the 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.
    Figure 33: 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. In 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 letters 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 F5. After making any corrections, save your presentation.

Printing Instructions for Recitation

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 or File tab. From the menu that appears, click on the Print icon. In MS Office 2007, a dialog box with the following options will appear. In MS Office 2010, the Backstage View will appear with the following options.
    Figure 34: Microsoft PowerPoint Print dialog box.

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

Your lab work is now complete. Email 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.