Texas A&M University – San AntonioCISAFinal Exam Name: Create a folder and name it Your Last Name_Final. Save your Final Exam, the PowerBI, Visio and Project files. At the end of the exam when you...

Texas A&M University – San AntonioCISAFinal Exam
Name:
Create a folder and name it Your Last Name_Final. Save your Final Exam, the PowerBI, Visio and Project files.
At the end of the exam when you have saved all your files in the folder, Right-click on the folder and select “Sent to..,” then select “Compressed (zipped) folder.” Upload the zipped file Your Last Name_Final.zip
***
PowerBI
Import the file PowerBI Final OCT_Payments for PowerBI, which is located in the folder you downloaded from Blackboard. Use a separate tab for each task. Label each tab by exam question number (i.e. Task 1, Task 2, etc…) Save the file as [yourlastname] Payment Analysis.pbix in Your Last Name_Final folder.
Total of 34 points.
1.Using a Pie Chart Visualization, identify the third (3rd) highest entity the City of San Antonio paid the most to in the month of October.Answer:
What is the total amount?Answer:
2.Using a Stacked Column Visualization, on what date did the City of San Antonio pay the most?Answer:
What is the total amount?Answer:
3.Under the Fields column, select the “Amount” and “Date,” fields. Expand Date and select Day. Under the Visualizations column, select the Matrix Visualization option. Under the Filters column, select the “Pay_To” filter enter the search term “Alamo.” Select all the businesses with the word Alamo in it.
Which organization was paid the most?Answer:
Using the drill down feature, how many times was the organization paid and on what dates?Answer:4.Pick a visualization of your choice to best answer the following question: For the month of October, what is the dollar amount the City paid
By ACH?Answer:
By check?Answer:
By Wire?Answer:


VisioYou are going to create a PERT chart with the information below. Save your file as Last Name PERT.vsdx.
Total of 34 points.
Consider the following project
ActivityImmediate PredecessorExpected daysA--6B--4CA3DA5EA1FB,C4GB,C2HE,F6IE,F5JD,H3KG,I5 L J,K 1
1.Use Microsoft Visio to construct a PERT network.
2.Identify the Critical Path and the estimated days it will take to complete the project.
3.Solve for the expected earliest and latest start and finish time for Activity J.
4.What is the total amount of slack afforded?
5.“What-if” scenario: Would the project be delayed, advanced, or unchanged if Activity B’s immediate predecessor was Activity A?



ProjectYou are going to create a GANTT chart with the information below. Save your file as Last Name GANTT.mpp.
Total of 34 points.
Consider the following project. Being on 6 January 2021.
Task NameDurationPredecessorTask 1Construction--Task 2Mobilization2 daysTask 3Demo3 days2Task 4Rough Framing6 days3Task 5Wiring4 days3Task 6Plumbing8 days4,5Task 7Framing Inspection1 day6Task 8Drywall10 days7Task 9Painting12 days8Task 10Trim, Finish, and Fixture11 days8,9Task 11Final Walkthrough3 days10
1.Use Microsoft Project to create a Gantt chart.
2.Make all the Tasks below Task 1 be subtasks of Task 1.
3.How many days will this phase the construction project take to be complete?
4.Without changing the duration days for any of the tasks, reduce the number of days to complete the construction phase by AT LEAST 10 days. You might be able to reduce the project scope by more days and that’s fine if you are able to. (Hint. Consider having to work on weekends, or Focus your attention on the Gantt chart. Break links and re-link activities. Click the link and change the Lag number in the Dependencies Window…)
5.What is the slack time? (Hint. On your Quick Table, change the next free column by clicking on the drop-down arrow and search for “Start Slack.”)
May 07, 2021

Submit New Assignment

Copy and Paste Your Assignment Here