CIS112 Introduction to Computing
Excel #2 Assignment
Due: Sunday midnight of Unit 5
In this assignment, you will practice the skills of creating and formatting Excel charts using data you collect over the week.
From Monday through Friday, use a spreadsheet to track how many hours you spend using technology, categorizing them by Personal and Professional. Record the hours up to tenths of an hour (one decimal place). Create two charts: Pie chart and Line
Your work must meet the following requirements:
New workbook:
Open a new Excel workbook. Save it as Initials_TechnologyTime.xlsx where Initials are your initials.
By default, 3 worksheets are provided. Delete two of them and rename the remaining tab to “Time”.
Data
Title the columns with these headers: Day, Personal, Professional
In the day column, fill in the days of the week starting with Monday and ending with Friday
In the Personal and Professional columns, fill in the hours you spent using technology for either personal or professional purposes, to the nearest tenth (one decimal place).
Pie Chart:
Create a 2-D pie chart using the Personal data for the week.
Change the title to “Personal Technology Time”.
The legend should be on the right side and should display the days of the week.
Add data labels so they are easy to read.
Line Graph:
Create any type of line graph showing both the Personal and Professional data for the week.
Add a title to the top of “Technology Time”.
The legend should be on the right side and should display Personal and Professional as those are the two lines displayed.
Add a title to the Primary Vertical Axis of “Hours” with your choice of format.
The horizontal axis should display the days of the week.
Add data labels to the data points so they are easy to read.
Experiment with the other formatting features to make the table engaging and easy to interpret.
Refer to the grading rubric on the next page for grading criteria.
Grading Rubric
Criteria Deficient
0 points Proficient
5 points
Worksheet Title Extra worksheet or one worksheet with incorrect title. One worksheet title “Time”.
Table Content Some or all content missing or times not formatted to one decimal place. Monday through Friday days filled in and categorized correctly. Formatted to one decimal place.
Pie Chart 2-D chart not used or pie chart missing. 2-D Chart used.
Pie Chart – Title Incorrect or missing title. Titled correctly.
Pie Chart – Legend Legend missing or not on right side. Legend on right side.
Pie Chart – Data Labels Labels missing or difficult to read. Labels present and easy to read.
Line Graph Line graph missing. Line graph present.
Line Graph – Title Incorrect or missing title. Titled correctly.
Line Graph – Legend Legend missing or not on right side. Legend on right side.
Line Graph – Vertical Axis Vertical axis title missing or incorrectly labeled. Vertical axis title correctly formatted.
Line Graph – Data Labels Labels missing or difficult to read. Labels present and easy to read.
Line Graph – Additional Formatting No additional formatting or made it difficult to interpret the data. Additional formatting used to improve interpretation of the data.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]