Difference between revisions of "Introduction to Microsoft Office"

From EG1004 Lab Manual
Jump to: navigation, search
(Fall 2015 Update)
m
(22 intermediate revisions by 4 users not shown)
Line 1: Line 1:
[[Software for Engineers]]
<span style="color: red;">Important: Please note that you must register on the [http://eg.poly.edu EG1003 website] before performing the lab.</span>
 
'''<span style="color: red;">Important:</span> Please note that you ''must'' register on the [http://eg.poly.edu EG Website] before performing the lab.'''
 
# 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.


= Objectives =
= 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.
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 =
= 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.
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 ==
MS Office is a software suite that bundles MS Word, Excel, PowerPoint, and Outlook.
Microsoft Office is a software suite that bundles Microsoft Excel, PowerPoint, Word, and more.
 
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.
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.


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


MS Outlook is an email client that will not be covered by this course.
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 =
= Materials and Equipment =
* Lab PC
* A lab PC
* Microsoft Office suite
* Microsoft Office suite


= Procedure =
= Procedure =
== Microsoft Word ==
For an in-depth look at Microsoft Office, see the [[Microsoft Office Skill Builder]]. Complete the following exercises.
Create a template for lab reports to be written throughout the semester based on the given template.


== Microsoft Excel ==
* Change all generic (highlighted in yellow) text to the information created in the lab
Create a spreadsheet of values to illustrate Charles' Law based on the given template.
* Copy and paste Excel tables and figures as pictures. Right-click and click the Paste as Picture icon [[Image:Lab 1A1.png|176px|thumb|center||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 <b>do not</b> need to be submitted on the [https://eg.poly.edu/submit.php EG1003 website].
 
== 1. Microsoft Excel ==
Fill in the empty highlighted cells in the [[Media: Excel Template.xlsx|Microsoft Excel Template]] to illustrate Charles' Law. Use the following formulas to fill the spreadsheet.


<math>{^\circ C} = \frac{5}{9} \left( {^\circ F} - 32 \right)\,</math>
<math>{^\circ C} = \frac{5}{9} \left( {^\circ F} - 32 \right)\,</math>
Line 46: Line 40:
<math>K = {^\circ C} + 273.15\,</math>
<math>K = {^\circ C} + 273.15\,</math>


<math>V = \frac{nRT}{P}\,</math>
<math>PV = nRT\,</math>


== Microsoft PowerPoint ==
== 2. Microsoft PowerPoint ==
Create a template for lab presentations to given throughout the semester based on the given template.
Recreate the [[Media:Presentation Template.pdf|Lab Presentation Template]] from scratch for lab presentations to be given during the semester.


=== Printing Instructions for Recitation ===
=== Printing Instructions for Recitation ===
When printing handouts for recitation, select the following options in the print dialog:
When printing handouts for Recitation, select the following options in the print dialog.
* Handouts, 6 Slides Horizontal
* Handouts, six slides horizontal
* Portrait Orientation
* Portrait orientation
* Pure Black and White or Grayscale
* 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.
== 3. Microsoft Word ==
Recreate the [[Media: Report Template.pdf|Lab Report Template]] from scratch for lab reports to be written during the semester.


= Assignment =
= 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.
You must submit two files to the [http://eg.poly.edu/ EG website]:
# 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)
# Excel file (.xlsx)
#* Tables and graph


'''<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 EG1003 Website|Submission instructions]] are available. A syllabus showing the deadlines for your section are located on the [http://eg.poly.edu/ EG website].
There is <b>no</b> individual lab report or team presentation for this part of Lab 1.


{{Laboratory Experiments}}
{{Laboratory Experiments}}

Revision as of 02:53, 22 January 2020

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

Objectives

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

For an in-depth look at Microsoft Office, see the Microsoft Office Skill Builder. 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 Charles' Law. Use the following formulas to fill the spreadsheet.

2. Microsoft PowerPoint

Recreate the Lab Presentation Template from scratch for lab presentations to be given during the semester.

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.

Assignment

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