Skip to main content

Posts

Intro Java Lab 2

Question 1 - Simple Conditions  Create a console application that accepts two integer from the user and then displays if the values are equal or not equal. Question 2 - Equality and relational operators  Modify the above application so that application uses the following condition to display the outputs If the first value is equal to second value then the system displays "First value is equal to second value" If the first value is not equal to second value then the system displays "First value is not equal to second value" If the first value is greater than second value then the system displays "First value is greater than second value" If the first value is less than second value then the system displays "First value is less than second value" If the first value is greater or equal second value then the system displays "First value is greater than or equal to second value" If the first value is less than or equal to secon...

Intro Perl Lab 3

1. Create a perl program. Use a hash to store all Province Code and Province Name of Canada. Then print them.  Output should be as shown below:  PE-Prince Edward Island BC-British Columbia NB-New Brunswick ON-Ontario QC-Quebec MB-Manitoba NS-Nova Scotia 2.   Create a perl program that use a hash to store all Week day code and Week day. Then print them.  Output should be as shown below:  M - Monday  T - Tuesday W - Wednesday H - Thursday F - Friday S - Saturday U - Sunday 3.  Write a program that simulates rolling five dice. Assign values between 1 and 6 to five different variables and display all five on the screen as well as the sum of the five numbers.  Output should be as shown below.  Die 1 -- 5 Die 2 -- 3 Die 3 -- 1 Die 4 -- 1 Die 5 -- 6 Sum is 16.

Intro Perl Lab 2

Perl Lab 2 a) Write a perl program to create an array of 10 student name. b) Modify the program to create a second array to hold the marks of the 10 students in the above array. c) List student name and student marks as shown below:  Student Name       Student Marks Arshdeep                    80 Sukhdeep                   90 Prabdeep                    76 Sandeep                     56 Mandeep                     46 d) Modify the above program to add pass or fail as shown below: Student Name       Student Marks          Pass/Fail Arshdeep                    80     ...

Intro Perl Lab 1

Exercise 1 Create a perl program that stores your StudentID, First Name, Last Name, program Name, Course ID and CourseName in 6 variables and then creates the following output: Student ID: 99999999 Name: First_name Last_Name Program: Program Name course ID: Course ID Course Name: Course Name Exercise 2 Create an array that stores the days of the week and then print the days of the week to the console screen. Output should be as shown below Mon Tue Wed Thu Fri Sat Sun

Excel What-if Analysis - Goal Seek

  Excel Goal Seek is a tool that is available in most versions of Excel, including Excel 2010, Excel 2013, Excel 2016, and Excel 2019. Excel Goal Seek is a tool that allows users to find the input value required to achieve a desired output value. It is particularly useful when dealing with complex formulas that have multiple variables. Instead of manually adjusting the input value to achieve the desired output value, Goal Seek automates the process by doing the calculations for you. How to Use Excel Goal Seek Using Excel Goal Seek is a simple process that involves three steps: Set up your worksheet: Enter the formula that you want to use and set the cell containing the formula as the output cell. Then, identify the cell that contains the input value that you want to adjust. Open the Goal Seek dialog box: To do this, go to the Data tab in the Excel ribbon and click on the "What-If Analysis" button. From the dropdown menu, select "Goal Seek". Enter your values: In th...

Excel Lab - Creating Mortgage Calculate and Importing Data

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...

OOCpp Lab 1

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)