FOR A-PLUS WRITER ONLY

SUPERIOR-PAPERS.COM essay writing company is the ideal place for homework help. If you are looking for affordable, custom-written, high-quality and non-plagiarized papers, your student life just became easier with us. Click the button below to place your order.


Order a Similar Paper Order a Different Paper

 

Phase 3

 

In this project, you will create and format charts that display your overall grade average for the courses that you are currently taking. You will create and format a 2-D column chart and a 3-D chart.

 

 

Perform the following tasks:

 

1.Open this Excel workbook  and save the worksheet as “FirstInital_LastName_ChartsIPA03_.xlsx.” 

 

2.Select cell range A5:A8 and G5:G8, using the control feature to select G5:G8, and then click the Insert tab select the Column tab, choose the cluster cylinder column.

 

3.Select a style from the Design tab and then format the all courses (on the chart) with the fill color of Olive Green, Accent 3.

 

4.Select the Cluster Cylinder Column chart, use the Cut command, and then paste a copy of the chart in cell A31.

 

5.Create a second chart from the Design tab. This time, select a Bar chart.

 

6.Add a chart title to both charts using the Layout Style 1. Label the Cluster Cylinder Column chart CTU Grade Average, and label the bar chart “Your Name” Grade Average.

 

7.You realize that a score is missing for your IP5 assignment in IT254. Modify cell F6, and add the value of 81. â—¦Note: Look at your charts. This action will change your averages.

 

8.Prepare the worksheet for printing by changing the orientation to Landscape. Go to File and Print preview and adjust the sheet to Fit All Columns on One Page.

 

9.Save the workbook. Close the workbook and then exit Excel. Submit the Excel spreadsheet.

 

 

 

Phase 4

 

 

 

Weekly tasks or assignments (Individual or Group Projects) will be due by Monday, and late submissions will be assigned a late penalty in accordance with the late penalty policy found in the syllabus. NOTE: All submission posting times are based on midnight Central Time.

 

 

 

Be sure to download the companion resources using the link provided in the reading assignments.

 

 

 

In this project, you will determine what core courses that are required to complete your degree in Information Systems Management. You are trying to determine which classes will be offered and how much longer it will take you to complete your degree. Once you complete your pivot table and chart, you will now be able to visually see what courses are available and which semester offers the most courses that you will need to successfully graduate.

 

 

 

To complete the assignment, perform the following tasks:

 

1.Open this Excel workbook and save the worksheet as “FirstInital_LastName_PivotIPA04_.xlsx.”

 

2.Highlight the entire data set, and insert a pivot table. â—¦For more information on how to create a pivot table, click here.

 

 

 

3.Create a new worksheet, and sort the pivot table as follows: â—¦Move Student level to the Column level.

 

â—¦Move the Year will move to Values, changing your values to count instead of sum.

 

â—¦Move the Course to Row Label.

 

 

 

4.Insert a Column chart and expand your chart. Select Chart Layout 3, and also change your chart design style 2.

 

5.Add a title “Course Availability” for your table.

 

6.Save the worksheet as “Course Availability,” and save your document as “FirstInitial_LastName_PivotIPA04_solution.”

 

7.Return to the Data sheet, highlight all the data, and click on Insert a pivot chart. â—¦For more information on how to create a pivot chart, click here.

 

 

 

8.Create a new worksheet, and sort the pivot chart as follows: â—¦Filter the Year.

 

â—¦Move Courses to Axis Fields.

 

â—¦Move the Count of Student to Value.

 

 

 

9.Change your chart type to columns and choose a style from the design tab. Insert the name “Course Overview” as your title.

 

10.Adjust your new chart by expanding it from cells A22 to G48.

 

11.Rename the worksheet to “Course Overview.” Submit your Excel spreadsheet.

 

 

 

Phase 5

 

 

 

Weekly tasks or assignments (Individual or Group Projects) will be due by Monday, and late submissions will be assigned a late penalty in accordance with the late penalty policy found in the syllabus. NOTE: All submission posting times are based on midnight Central Time.

 

 

 

Be sure to download the companion resources using the link provided in the reading assignments.

 

 

 

In this project, you will realize that you really need to invest in a new computer to complete course assignments for the school’s use. You will create a worksheet, use the PMT function, and format a worksheet to show a comparison of two electronic computers that you are interested in purchasing. You will make a comparison of the two items and determine which one is feasible to purchase.

 

•The Excel PMT function is used to calculate the payment for a loan based on constant payments and a constant interest rate.

 

•Click here for more information on how to use the PMT function.

 

 

 

To complete this assignment, perform the following tasks:

 

1.Data has been provided for you to generate a payment for each of the two products to help determine which product is feasible for you to purchase for school purposes. Click here to access the data.

 

2.The loan parameters have been entered into the worksheet. Click in cells B8 and E8 to calculate the amount to finance as Price – down payment – rebate.

 

3.Save the workbook as “FirstInitial_LastName_Purchase_solution.xlsx” â—¦Hint: Click Insert function and select PMT for payment.

 

 

 

4.Merge and center the titles in Cells A1:E1. Format your worksheet by including color as well as providing an appropriate clip art to accent the document.

 

5.Indent the content in cells A9:A14 and show the Payment amount in font size 14.

 

6.Indent the content in cells D9:D14 and show the Payment amount in font size 14.

 

7.Save the School Computer Purchase Analysis spreadsheet. Submit the School Computer Purchase Analysis spreadsheet.

 

Writerbay.net

Got stuck with a writing task? We can help! Use our paper writing service to score better grades and meet your deadlines.

Get 15% discount for your first order


Order a Similar Paper Order a Different Paper
Writerbay.net