QSO 320 Module One Assignment Guidelines and Rubric
Overview
For this assignment, you’ll set up a spreadsheet to track labor costs for the given scenario below. This assignment will give you practice in setting up a basic spreadsheet with calculations. You’ll also practice linking that data to another tab (worksheet). You’ll build on this assignment in future modules as you learn more about spreadsheet functionality.
Directions
First, create an Excel spreadsheet and name the document Labor Hours. Label the first tab of the document Data. Then complete the following steps:
1 In the Data tab, create a table with the following information:
A Employees’ names
B Each employee’s hourly rate
C The number of hours per day for five days for each employee
2 Use basic formulas to calculate the following:
A The total number of hours each employee worked for five days
B The labor cost for each employee
C The total labor cost for the project
3 In that same document (workbook), set up a separate tab labeled Data Link. In this tab, set up a blank table and fill the table by linking the cells to the data from the table you created in the Data tab.
Note: You might be tempted to copy and paste the table and formulas from the Data tab for this part of the assignment. However, it’s important that you learn to link data from one tab to another. In the real world, you could have a spreadsheet with multiple tables on multiple tabs all pulling from the same data set. If you copy data instead of linking it, you’ll have to update every table. However, if you link the data, all the tables will automatically update if any of the data changes.
Hint: On your separate worksheet, click on any cell that is importing data. You’ll see the name of the original worksheet (the name on the tab) followed by an exclamation point, before the cells are listed. For example: sheet1!A2.
Scenario
You are looking at labor costs for a construction project using eight employees:
• The employees’ names are Smith, Rodriquez, Daniel, Eli, Lee, Kim, Buster, and Green.
• Each employee worked eight hours a day for five days.
• The employees’ wages per hour are as follows:
◦ Smith: $8.95
◦ Rodriguez: $11
◦ Daniel: $14
◦ Eli: $16
◦ Lee: $19
◦ Kim: $20
◦ Buster: $25
◦ Green: $40
Specifically, you must address the following rubric criteria:
1 Set up the spreadsheet with all the needed data from the scenario given.
2 Use formulas to perform correct calculations.
3 Link all the data correctly from one spreadsheet to another.
What to Submit
Your assignment must be submitted as a Microsoft Excel document. Use 11-point Calibri font.
