Term Project

·       There are 2 sets of Metadata – either with a group or individually pick one of the sets.

·       These files are called Crimes 2001-Present and Traffic Violations.

·       Compile your analysis and hypothesis using analytical data.

·       Create 8 sets of Pivot Table and Pivot Charts to build and support your data

·       Anticipate any trends using linier or other methods of forecasting.

·       Build a supporting relevant pivot chart for each data

·       Ensure the formatting of the cell in the pivot is correct and the way the information is being calculated is relevant

o   Eg – if you want to show the total number of violations in a given year – Sum of count vs sum of total

·       One final worksheet compile the data and have them linked to a Main Table

·       Back up your hypothesis.

·       Create a 800~ to support your analysis and train of though

Eg – growth rate of a specific type of conviction in a region – how is it trending and is there a correlation with regards to the dates.

Ensure your written part provides a platform on the logical thinking behind your analysis.

Please find the compressed RAR file. 

How do I code the following in c++?

Financial Calculator: You will develop a program for a bank that will allow it to process loans for customers. The user will enter information, such as interest rate, length of loan, amount borrowed, or desired payment, and the program will compute the missing information. It will also be able to display a report showing the amortization schedule for the loan. Customer data should be able to be saved and retrieved from a file or files.

Put the IPO chart, pseudocode, and test plan in the MS Visual Studio project folder, zip up the entire folder, and submit the compressed file. Use a flowchart for a simplified version of your program. Build a working version of it based on your flowchart. This should be a working program that accepts user input, does some calculation, and shows the results. It does not have to use conditional expressions, loops, and the like.

For a loan payment calculator, it asks for interest rate, length of loan, amount of loan, and it displays monthly payment.

Add at least one conditional expression to your program.

In the programming tutorial, you would add a tutorial on conditional expressions. You can then add simple multiple choice questions to test the user’s understanding of the concepts. Break the tutorial into sections, and use conditional expressions to ask the user which tutorial they wanted to see (i.e., variable declaration, input/output, conditional expressions, etc.).

Ask the user if he or she wants to solve for monthly payment, loan amount, length of loan, or interest rate. The program would then ask for the required information and solve for the remaining value.

Add loops to validate data. Add a menu to your program that allows users to use the various features or exit the program.

In the programming tutorial, add a tutorial on working with loops. Then use loops to validate user input and display an error message if they enter data outside the valid range. Use a main loop to allow the user to keep selecting different tutorials until they decide to exit the program.

Add arrays to your program to handle more data.

Add a tutorial on working with arrays. Then use arrays to store the answers to multiple questions so that you can compute a total score.

Make a hierarchy chart showing the logical components of your program. Modularize your code according to your chart using the practices learned this week. Your menu should now call individual modules to do the work of the program.

Add a tutorial on working with modules. Then modularize the code so that each tutorial and quiz is in a module.

Add the ability to save data to disk in one or more files. The menu(s) should give the user the option to save or retrieve data.

Add a tutorial on working with files. Then add the ability to save/retrieve user information or quiz results.

I have the source code to do the calculations and amortization schedule but I am stuck on creating loops, arrays, and building a tutorial and quiz.