EduSarva

Excel Lab - Creating Mortgage Calculate and Importing Data Part A -  Excel PMT Function PMT function is very useful for calculating monthly payment required to payback a loan or mortgage at a fixed rate. This function require a minimum of three inputs, periodic rate, number of periods, present value or the loan amount. Here is a simple example. Home Loan: 350,000.00 Interest rate: 4.5% Number of years to repay the loan: 25 Note: To calculate monthly payment, we need to find the monthly rate and number of months as shown above. Then it is simply a matter of substituting the values into the payment function, as shown in the formula view below. Part B -  CUMIPMT and CUMPRINC function CUMIPMT Cumulative interest payment function allows you to calculate the interest paid for a loan or from an investment from period A to period B. When getting a loan, CUMIPMT function can be used to calculate the total amount of interest pa...

Part A Create a class called Clock. The clock class will have the following attributes and methods.  ____________________ Clock ____________________ int hour int min int sec ____________________ void setHour(int) void setMin(int) void setSec(int) void DisplayTime() ____________________ Part b In the main method, create two instance of the clock, IndiaTime and TorontoTime.  Get the input from the use to set the both clock and then display time in both clock.  Set India Time Set Hour: 6 Set Min: 30 Set Sec: 45 Set Toronto Time Set Hour: 16 Set Min: 10 Set Sec: 25 Toronto Time - 16:10:25 India Time - 6:30:45 Part C Add comments to your code. Make sure that your add the following comments Student ID Student Name Description of the program Inline comments for each line (Very important)

Excel is a great application to create your own personal budget. Given below is a screenshot of a sample budget. Task 1 : Create a worksheet as shown below Task 2: Create a 3D Pie Chart for expense as shown below Task 3 - Printing a Worksheet Task 4 - Autocalculate feature and Correcting Errors. 

Logical Modelling and decision tables Logical modelling involves modelling internal structure and functionality of a process. Decision tables are useful in logical modelling. Decision tables show logic inside a process, action(s) that needs to be taken when a condition or a set of conditions are satisfied. Use of decision tables used by developers to identify any discrepancies in business rules (Tarlinder 2016).   used for customer support in telecom industry to provide an optimal plan based on the customer's usage (Singh 2015). used in SAP HANA to specify business rules (Singh 2015) Used in Model based testing as inputs  (Kramer, Legeard, Bazzana, & Binder, 2016) . B usiness rules in decision table can be converted into arguments for parameterized testing  (Tarlinder 2016).  A Decision tables can be created using the following steps: Identify conditions  Identify actions that needs to be carried out when certain condition...

Agenda Task 1 - Introductions Task 2 - Course Outline Task 3 - Blackboard  Task 4 -  MyITLab   Task 5 - Introduction to Excel 2013 Task 6 - Agenda Task 7 - Quiz Lab 1 - Introduction to Spreadsheets Part 1     1.    Open Microsoft Excel and save the new workbook. 2.        Select Cell A1, type “OK Office Systems Pricing Information” and press enter. 3.        Select Cell A3, type “Item” and press enter. 4.        Type “Computer System” and press enter. 5.        Type “Desk Jet Printer” and press enter. 6.        Type “Filing Cabinet” and press enter. 7.        Type “Task Chair” and press enter. 8.        Type “Solid Wood Computer Table” and press enter. 9.      ...