Introduction to Microsoft Office

Software for Engineers

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 EG1003 will require a basic competency in them; the following exercises are designed to ensure you have this competency so please complete them.

Microsoft Office

MS Office is a software suite that bundles MS Word, Excel, PowerPoint, and Outlook.

MS Word is a word processing program. Its function is writing and editing text. In this course, you will use MS Word to write lab reports.

MS Excel is a spreadsheet program. Its function is collecting, manipulating, and analyzing data. MS Excel has many features that streamline data analysis. You can use it to generate tables, charts, and graphs. Excel is used for 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.

MS PowerPoint is a presentation program; its function is to create slides for presentations. In this course, you will be creating and giving presentations on your lab work and semester-long design project.

MS Outlook is an email client that will not be covered by this course.

Materials and Equipment

• Lab PC
• Microsoft Office suite

Procedure

Microsoft Word

Create a template for lab reports to be written throughout the semester based on the given template.

Microsoft Excel

Create a spreadsheet of values to illustrate Charles' Law based on the given template.

${^{\circ }C}={\frac {5}{9}}\left({^{\circ }F}-32\right)\,$

$K={^{\circ }C}+273.15\,$

$V={\frac {nRT}{P}}\,$

Microsoft PowerPoint

Create a template for lab presentations to given throughout the semester based on the given template.

Printing Instructions for Recitation

When printing handouts for recitation, select the following options in the print dialog:

• Handouts, 6 Slides Horizontal
• Portrait Orientation
• Pure Black and White or Grayscale

Email copies of all the files you created to your personal account. Review the files for errors before submitting your report.

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.