CIS112 Unit 5 Assignment and Rubric

ORDER NOW FOR AN ORIGINAL PAPER!!! CIS112 Unit 5 Assignment and Rubric .

In this assignment, you will begin to enter and manipulate data using Excel spreadsheets. You will insert a simple SUM function and format numbers.

In order to complete this assignment, first you must download and save the document “Unit 5 Excel,” attached above. This will give you the basic spreadsheets.

Once you have done that, open the file titled “CIS112 Unit 5 Assignment and Rubric” and complete all of the tasks listed there.
Save your work, and submit the updated file you created to Blackboard by Sunday at Midnight.
ASSIGNMENT 6:

This assignment will take you further into Excel and covers the material in this unit.

In order to complete this assignment, first you must download and save the document “Unit 6 Charting,” attached above.

Once you have done that, open the file titled “CIS112 Unit 6 Assignment and Rubric” and complete all of the tasks listed there.
Save your work, and submit the updated file you created to Blackboard by Sunday at Midnight.

CIS 112 – Intro to Computing MS Excel Assignment 1 Due: Midnight Sunday. In this assignment, you will format a worksheet on the number of pens purchased by students. You will also format the worksheet and insert appropriate formulas. Please remember to save your work as you go through the steps. The requirements for your assignment are: 1. Open the Unit 5_Excel1.xlsx document; 2. Save the document as Your First Initial LastName_Pen_Sales.xlsx (For example: SBrown_Pen_Sales.xlsx); 3. The “Students” worksheet will contain the following data: 4. On the “Students” worksheet, do the following: a b c d e f 5. Insert your first and last name in cell A1. Italicize your name in cell A1 Select all the values in Column B.

Using the Increase Decimal option, format the purchased pens in Column B to have 2 decimal places. In cell B15, use the AutoSum function to get the Total of all pens purchased; Using the Increase Decimal option, format the sum in cell B15 to have two decimal places; Change the cell Background Color in cell B15 to Yellow Save your work and submit the completed worksheet in Blackboard. Refer to the grading rubric below for the grading criteria. Students: Be sure to read the criteria, by which your paper/project will be evaluated, before you write, and again after you write. Evaluation Rubric for Unit 5 Assignment Criteria Name SUM of Pens Formatting Excel document name Below Expectations Needs Improvement Meets Expectations 0-18 points 19-26 points 27-30 points Name has not been entered in correct cell.

Name has been Name is entered in entered, but text is not correct cell, and text is Italicized. Italicized. 0-18 points 19-26 points 27-30 points Function not entered to SUM pens purchased, and background color of the cell has not been changed. Autosum used to sum pens purchased. Value does not have two decimal places. Background color of the cell has been changed. Autosum used to determine sum of pens purchased, and value has two decimal places using increase decimal option. Background color of cell has been change 0-18 points 19-26 points 27-30 points All pens purchased values have not been formatted to contain two decimal places. Some pens purchased values have been formatted with two decimal places. All pens purchased values have been formatted to contain two decimal places. 0-5 points 6-8 points 9-10 points File name has not been changed. File name has been changed, but is not correct. CIS112 Unit 5 Assignment and Rubric

File name has been changed to correct name. Student Name Page, Lisa Martinez, Mary Dawson, Jonathan Chan, Eric Pratt, Erik Garcia, Joe Wiggins, Frank Tanner, Timothy Chase, Troy Perez, Maria White, Daniel Holland, Donald SUM of Pens Purchased Pens Purchased 55 87 82 93 61 67 75 81 79 95 75 99 CIS 112 – Intro to Computing MS Excel Assignment 2 Due: Midnight Sunday In this assignment, you will format a worksheet and insert appropriate formulas, and formatting. Please remember to save your work as you go through the steps. The requirements for your assignment are: 1. Open the Unit 6 Charting.xlsx document; 2. Save the document as Your Initials_Unit 6_Charting.xlsx (i.e. SB_Unit6_Charting.xlsx); 3. Select Column Q on the worksheet and hide the entire column Q; 4. Format the values in cells B3:M6 as a Number format with 2 decimal points;

5. Select cell A7 and enter the text “Total”; 6. Using the SUM function, calculate the Totals for each month. Your worksheet should look like the following: 7. Select cells A2:M6 and create a Line chart for the data; Your Line chart should look like the following: Note: If your chart does NOT look like the chart above, but looks like the chart below, you should choose the Switch Row/Column Option, which is located under the Chart Tools Menu. 8. Adjust the size of your line chart and move it so that the chart fits in cells A12:H20. 9. Add a legend to the bottom of your line chart; 10. Add the following title to the chart: “Sales by Month by Region”. Your chart with the legend and title should like the following: 11. Below is how your completed worksheet should look: 12. Save your document and upload into Blackboard.

Students: Be sure to read the criteria, by which your paper/project will be evaluated, before you write, and again after you write. Evaluation Rubric for Unit 6 Assignment Criteria Below Expectations 0-18 points Hidden Column Sales Worksheet Line Chart Worksheet 19-26 points Column Q has not been A column has been hidden hidden on the worksheet. on the worksheet, but it is not the correct column. Meets Expectations 27-30 points Column Q has been hidden correctly on the worksheet. 0-18 points 19-26 points 27-30 points No Total calculations and no formatting has been completed. Total calculations using the SUM function completed correctly, but number formatting has not been completed. Total calculations using the SUM function completed correctly and the number formatting has also been completed correctly. 0-18 points 19-26 points 27-30 points Line Chart has not been created. 0-5 points Excel document name Needs Improvement File is named incorrectly. Line Chart has been created. Line chart has been created Problem with legend and/or correctly. Legend and chart title of the chart. have both been added correctly. 6-8 points File name is correct. File saved in improper format. 9-10 points File is named correctly, and saved in proper format CIS112 Unit 5 Assignment and Rubric