WEEK 2: LAB OVERVIEW
Table of Contents
Lab Overview
Scenario/Summary
Click to download the Week 2 Lab Document (Links to an external
site.)Links to an external site. to complete the lab for this week. All of the
directions are included in the document.
For use with the lab and throughout the course, click to
download Excel: A How-To Handout (Links to an external site.)Links to an
external site..
After some introductory comments, the first question begins
under the title Creating Graphs and is a pie chart.
The data for this lab is located in the Files section of the
Course Menu. If you are not able to locate the data file, please contact your
professor.
On the last page is a section is titled Code Sheet. It is only
there to explain what the variables in the data set represent. In other words,
the code sheet just lists the variable name and the question used by the
researchers on the survey instrument that produced the data that are included
in the Excel data file. Those are not questions for you to answer, just
information.
The document includes places where you need to input the answers.
Any place where you see a gray box is where you need to put an answer.
Deliverables
Fill in the document, save it with your name in the title, and
submit the document.
Below is the grading rubric for this assignment.
|
Category |
Points |
% |
Description |
|
Questions |
15 |
30% |
Creating graphs and |
|
Question |
5 |
10% |
Calculating means and |
|
Questions |
30 |
60% |
Interpreting and using |
|
Total |
50 |
100% |
A quality lab will meet |
Required Software
Microsoft Office: Word and Excel
Use a
personal copy*, or access the software** at https://lab.devry.edu (Links to an
external site.)Links to an external site..
*From the Course Resources
page, students can obtain a personal copy of Microsoft Office through the
Student Software Store.
**To learn more about using the virtual
lab environment, click the Lab button on the Course Resources page and select
Citrix.
Lab Steps
Prepare and Submit Lab
1. Open
Excel.
2. Open
the lab Word document.
3. Follow
the steps in the lab Word document to do calculations in Excel.
4. Copy
and paste from Excel into the Word document, or retype the answer. Complete the
answers to the questions in complete sentences (fill in each gray box in the
Word document).
5. Save
the lab Word document, and submit it. No other files should be submitted.





