Miss Tutor

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.