Introduction to Microsoft Office

Important: Please note that you must register on the EG1003 website before performing the lab.

Objective

The objective of this lab is to master the basics of Microsoft Excel, PowerPoint, and Word and to learn how to employ these applications. This exercise will produce templates for EG1003 lab reports and PowerPoint presentations.

Overview

This lab is designed to teach the skills needed to become proficient with the three primary Microsoft applications: Excel, PowerPoint, and Word. These programs are widely used in academia and the public and private sectors so proficiency in these applications is a requirement. Completing assignments in EG1003 requires a basic competency in them and the following exercises are designed to create that competency.

Microsoft Office

Microsoft Office is a software suite that bundles Microsoft Excel, PowerPoint, Word, and more.

Microsoft Excel is a spreadsheet program. Its function is collecting, processing, and analyzing data. Microsoft Excel has many features that streamline data analysis. It can be used to generate tables and graphs. It is useful for showing the relationships between data sets and identifying trends. Graphs will be required for many lab reports and presentations.

Microsoft PowerPoint is a presentation application. Its function is to create slides for presentations. In this course, eight lab presentations, three Milestone presentations for the semester long design project, and a final sales presentation for the semester long design project will be created and presented using PowerPoint.

Microsoft Word is a word processing application. Its function is writing and editing text. In this course, Microsoft Word will be used to write nine lab reports.

Materials and Equipment

• A lab PC
• Microsoft Office suite

Procedure

Complete the following exercises.

• Change all generic (highlighted in yellow) text to the information created in the lab
• Copy and paste Excel tables and figures as pictures. Right-click and click the Paste as Picture icon
  

  Figure 1: Paste as Picture
• Label tables and figures
• Use the Equation function in Word and PowerPoint

Saving Work

The information on the Lab PCs cannot be accessed outside of the lab rooms. Email copies of all the files created to a personal account.

The templates created in this exercise for Microsoft Word, Excel, and PowerPoint do not need to be submitted on the EG1003 website.

1. Microsoft Excel

Fill in the empty highlighted cells in the Microsoft Excel Template to illustrate the Ideal Gas Law. Use the following formulas to fill the spreadsheet.

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

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

$PV=nRT\,$

2. Microsoft PowerPoint

Recreate the Lab Presentation Template from scratch for lab presentations to be given during the semester. Use the results from completing the Excel worksheet to fill out the Data/Observation slides

Printing Instructions for Recitation

When printing handouts for Recitation, select the following options in the print dialog.

• Handouts, six slides horizontal
• Portrait orientation
• Black and white or grayscale

3. Microsoft Word

Recreate the Lab Report Template from scratch for lab reports to be written during the semester. Use the results from completing the Excel worksheet to fill out the Data/Observation section.

Assignment

There is no individual lab report or team presentation for this part of Lab 1.