Difference between revisions of "Introduction to Microsoft Office"
(→Saving Work: Admin Meeting 2016-09-14) |
|||
| Line 2: | Line 2: | ||
= Objectives = | = Objectives = | ||
The objective of this lab is to master the basics of Microsoft Excel, PowerPoint, and Word and | 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 EG 1003 lab reports and PowerPoint presentations. | ||
= Overview = | = 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 | 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 == | ||
Microsoft Office is a software suite that bundles Microsoft Excel, PowerPoint, Word, and more. | Microsoft Office is a software suite that bundles Microsoft Excel, PowerPoint, Word, and more. | ||
Microsoft Excel is a spreadsheet program. Its function is collecting, | 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 | Microsoft PowerPoint is a presentation application. Its function is to create slides for presentations. In this course, eight lab presentations, three milestones 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 | 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 = | ||
* | * A lab PC | ||
* Microsoft Office suite | * Microsoft Office suite | ||
| Line 24: | Line 24: | ||
In each of the following exercises: | In each of the following exercises: | ||
* Change all generic (highlighted in yellow) text to | * Change all generic (highlighted in yellow) text to the information created in the lab | ||
* Copy and paste Excel tables and figures as a picture; screenshots are not acceptable in this class | * Copy and paste Excel tables and figures as a picture; screenshots are not acceptable in this class | ||
* Label tables and figures. | * Label tables and figures. | ||
* Use Insert Equation in Word and PowerPoint. | * Use Insert Equation in Word and PowerPoint. | ||
| Line 45: | Line 45: | ||
=== 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, | * Handouts, six slides horizontal | ||
* Portrait | * Portrait orientation | ||
* | * Black and white or grayscale | ||
== Microsoft Word == | == Microsoft Word == | ||
Recreate the [[Media:Report Template.pdf|Lab Report Template]] for lab reports to be written | Recreate the [[Media:Report Template.pdf|Lab Report Template]] for lab reports to be written during the semester. | ||
== Saving Work == | == Saving Work == | ||
The information on the Lab PCs cannot be accessed outside of the lab rooms. '''Email''' copies of all the files | The information on the Lab PCs cannot be accessed outside of the lab rooms. '''Email''' copies of all the files created to your personal account. | ||
The templates created in this exercise for Microsoft Word, Excel, and PowerPoint do not need to be [https://eg.poly.edu/submit.php submitted on eg.poly.edu]. | The templates created in this exercise for Microsoft Word, Excel, and PowerPoint do not need to be [https://eg.poly.edu/submit.php submitted on eg.poly.edu]. | ||
{{Laboratory Experiments}} | {{Laboratory Experiments}} | ||
Revision as of 21:33, 12 September 2017
Important: Please note that you must register on the EG 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 EG 1003 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 milestones 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 students who need an in-depth look at Microsoft Office, see the Microsoft Office Skill Builder.
In each of 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 a picture; screenshots are not acceptable in this class
- Label tables and figures.
- Use Insert Equation in Word and PowerPoint.
Microsoft Excel
Edit the Microsoft Excel Template to illustrate Charles' Law.
Use the following formulas to fill the spreadsheet:
Microsoft PowerPoint
Recreate the Lab Presentation Template for lab presentations to be given throughout 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
Microsoft Word
Recreate the Lab Report Template for lab reports to be written during the semester.
Saving Work
The information on the Lab PCs cannot be accessed outside of the lab rooms. Email copies of all the files created to your personal account.
The templates created in this exercise for Microsoft Word, Excel, and PowerPoint do not need to be submitted on eg.poly.edu.
| ||||||||