Phase 2
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 be assigned the task to record money received for a school fundraiser and create an Excel spreadsheet to record your receipts.
•You will determine the funds received and use the text to column feature (concatenate, apply conditional formatting, sort and filter data).
•You will determine your analysis and use sorting and filtering data, conditional formatting, as well as subtotals.
To complete the assignment, perform the following steps:
1.Open this Excel workbook titled "Fundraiser Receipt" and save the worksheet as "FirstInital_LastName_School expenses.xlsx."
2.Add a column to the right of the ”Last Name” column and name as “Full Name” Use the Concatenate function to join Last Name, First Name together. ◦Click here for more information on how to use the concatenate function.
3.Sort Columns C (C5:C25), using A–Z formatting.
4.Using the Conditional Formatting, determine which students have provided over $50 for the fundraiser in both Funds Received and Funds Pending Column. ◦The conditional formatting function allows you to apply different formatting options to data that meets certain conditions.
◦Click here for more information on how to use the conditional formatting function.
5.Highlight the entire data set (A1:E22), and apply a design to your data: In the Styles group, select Format as Table and use a dark formatting option.
6.Apply the Total row from the Design tab, providing a Sum for the Funds Raised and Funds Pending.
7.Add the Title “College Fundraiser Project” column by inserting blank lines. Change the font size of your spreadsheet data to 22, fill color with white background, darker 35%.
8.Change the orientation to landscape.
9.Name the worksheet "Fundraiser_Receipt_Solution."
10.Save the workbook. Close the workbook and then exit Excel. Submit your Excel spreadsheet.
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.
A-plus Writer
10 years ago
d_hooper_school_expenses.xlsx
