LBEPS Lab@home

LBPS lab at home 10

Q.1Draw a flowchart and write the pseudocode to display the highest 

of three numbers entered by a user. Implement this functionality 

with the help of procedures.

Q.2The owner of the theater wants to educate the customers 

about the ticket booking process.Therefore, he has asked 

Jimmy to create an attractive diagram for this process. Help 

Jimmy toaccomplish the required task.Prerequisite: To perform 

this exercise, you need touse the Media.xlsx and Theater.jpg files. 

Forthis, you need to click theMedia_and_Theater.zip link and 

save file as Media_and_Theater.zip.
Further, unzip it and use the Media.xlsx and Theater.jpg files 

to complete your exercise.

Q.3 Create a flowchart and a pseudocode for accepting two 

numbers from a user and multiplying anddividing them. Define 

and use the procedures to accept, multiply, and divide the numbers.
Q.4Draw a flowchart and write a pseudocode to print the sum of 

first 10 natural numbers. 
Ans :-

• CLICK HERE

LBPS lab at home 9

Ans :-

• CLICK HERE

_________________________________________________________________________________

LBPS lab at home 8

1.Jimmy's instructor has asked him to create a Category 

wise summary report. This report should contain the 

total ticket cost incurred according to the Show Type 

filed values. All the information should be visible 

clearly. 

For this, Jimmy wants to use a pivot table. Help 

Jimmy to accomplish the
required task.
Prerequisite: To perform this exercise, you need to 

use the Media.xlsx file. For this, you need to click 

the Media.zip link and save file as Media.zip. Further, 

unzip it and use the Media.xlsx file to complete your 

exercise.

2.Create a flowchart and write a pseudocode to 

display the square of first 10 natural numbers.

3.Jimmy has created a pivot table and has shown 

it to the theater owner. However, the owner is not
able to understand this data. Therefore, to make 

this data understandable, Jimmy decides to
create a chart to represent the required information 

graphically. The theater owner wants to view the 

graph for each category separately. Instead of 

creating a graph for each category manually,
Jimmy decides to create a pivot chart. Help 

Jimmy to accomplish the required task.
Prerequisite: To perform this exercise, you need 

to use the Media.xlsx file. For this, you need to 

click the Media.zip link and save file as Media.zip. 

Further, 

unzip it and use the Media.xlsx file tocomplete 

your exercise.

Ans :-

• CLICK HERE

LBPS lab at home 7

1.Draw a flowchart and write the pseudocode to print the product of the 

first 10 even numbers.
2.The data in the Media.xlsx file is arranged according to the movie code. 

In order 

to speed up the process, Jimmy decides to arrange the data in the ascending

 order 

according to the category and the show type. Help Jimmy to accomplish

the required task.
Prerequisite: To perform this exercise, you need to use the Media.xlsx 

file. For this, 

you need to click the Media.zip link and save file as Media.zip. Further, 

unzip it 

and use the Media.xlsx file to complete your exercise.
3.Sam, who is the owner of a theater, has received an Excel sheet 

containing the 

profit details. However, he is not able to understand this data. 

Therefore, he asked 

Jimmy to represent this data in an understandable format. For this, 

Jimmy decides

 to represent the profit data graphically. In addition, he decides to 

create a column 

chart. To make the chart presentable, he wants to add the following 

features in it:
1. The chart title should be Profit of the Year: 2011.
2. The legends should be placed at the bottom of the chart.
3. The chart should be placed along with the data table.
4. The data label should be displayed in the center of each bar.
Help Jimmy to accomplish the required task.
Prerequisite: To perform this exercise, you need to use the Media.xlsx file. 

For this, you need to click the Media.zip link and save file as Media.zip. 

Further, unzip it and use the Media.xlsx file to complete your exercise.

Ans :-

• CLICK HERE

LBPS lab at home 6

1.Write a pseudocode to accept three numbers and 

display the largest number.

2.Write a pseudocode to accept a year and determine 

whether the year is a leap year.

3.Write a pseudocode to display the cost of a selected 

menu item from a restaurant menu card. The menu 

card should display the list of food items. The food 

items should be numbered. The last line of the 

menu should display the text, Enter the menu 

selection. The user should enter the
sequence number corresponding to the menu items 

in the menu card as input. Further, the cost of the 

selected item should be displayed. In addition, an 

error message, Wrong selection, should be 

displayed if a 

wrong option, which does not appear in the menu, 

is entered by the user.

4.Write a pseudocode to accept a direction from 

a menu containing the options, up, down, right, 

and left. The pseudocode should display the 

geographical direction corresponding to the 

selected option, such as North, South, East, or 

West as output on the screen.

5.Write a pseudocode to accept a number, 

and then find whether or not the number is 

divisible by five

6.Write a pseudocode to display a movies menu 

containing the numbered list of movies and 

display the playtime, name of actors, and 

name of director of 

the movie selected by the user. The last line 

of the 

menu should display the text, Enter your 

selection.

When the user enters the movie number, the 

corresponding information should be displayed. 

In addition, an error message, Enter a valid 

option, 

should be displayed if a wrong option, which 

does 

not appear in the menu, is entered by the user.

7.Write a pseudocode to accept the age of a 

candidate. 

If the age entered is 18 or above, the
message, You are eligible to vote, should be 

displayed. 

If the age entered is below 18, the
message, You are not eligible to vote, should be 

displayed.

8.Write a pseudocode to accept an item/product 

number from a displayed list of items, accept 

quantity from a user, and display the total price. 

The price of the items will be defined in 

thepseudocode.

Ans :-

• CLICK HERE

LBPS lab at home 5

1.Write a pseudocode that accepts a distance in 

kilometers, converts it into meters, and then,
displays the result.

2.Write a pseudocode to accept two numbers, 

divide the first number by the second, and display 

the quotient.

3.Write a pseudocode to accept five numbers and 

display the sum and average of the numbers.

4.Write a pseudocode to accept a user name as 

input, append the entered user name to the text,
Hello, and then display the appended output to 

the user. For example, Hello Mark should be 

displayed as the output if the user enters the name, 

Mark.

5.Jimmy has done some basic formatting in the 

Media.xlsx workbook. However, this Data sheet 

is not attractive. Therefore, Jimmy wants to 

make this 

sheet more attractive, and at the same time, he 

wants to draw the attention of his instructor 

towards the data stored in this sheet. For this, 

he decides to convert the data stored in the Data 

sheet into a table. This ensures that instead of 

basic formatting, the flexibility of formatting the 

tables 

provided by Excel is used. He wants to use the 

Table Style Medium 4 table style for this. Help 

Jimmy to accomplish the required task.
Prerequisite: To perform this exercise, you need 

to use the Media.xlsx file. For this, you need to 

click the 

Media.zip link and save file as Media.zip. Further, 

unzip it and use the Media.xlsx file to complete 

your exercise

if you want download solution u can download link:-

Ans :-

• CLICK HERE

LBPS Lab at home 4

1.Draw a flowchart that displays a list of prime 

numbers within a given range

2.Draw a flowchart to accept two numbers and 

any one of the following characters: +, -, *, or /.
Based on the character entered, the numbers 

should be added, subtracted, multiplied, or 

divided
and the result should be displayed.

3.Draw a flowchart that accepts a name and 

displays it 10 times on the screen.

4.Nicholas works with A-Star Ltd. as a marketing 

executive. To expand the business, A-Star Ltd. has
planned to start the website development work. 

For this, the manager, John Pinto, has prepared a
marketing proposal document. He wants to send 

this proposal to all the clients of the company. He
has given the hard copy of this proposal to Nicholas 

and asked him to send the same to all the
clients. The client details (the name and the address) 

are stored in an Excel file. Nicholas wants to
automate the task of generating a marketing proposal 

for each client, instead of preparing the
letter manually for each client. You need to help 

Nicholas to automate this task.
Prerequisite: To perform this exercise, you need to 

use the Marketing Proposal.docx and
ClientList.xlsx files. For this, you need to click the Marketing_Proposal_and_ClientList.zip link and
save file as Marketing_Proposal_and_ClientList.zip. 

Further, unzip it and use the Marketing
Proposal.docx and ClientList.xlsx files to complete 

your exercise.

5.Draw a flowchart that accepts the name of a 

student and the marks obtained by the student, and
then calculates the average marks of the student.

6.Draw a flowchart to enter a number from 1 to 7 

and to display the corresponding day of the week.

Ans :-

• CLICK HERE

lab at home 3

1.Jimmy has to update the company brochure with information related to brands 

and sales. His
manager has asked him to put this information in a table with two columns.
The following figure shows information related to brands and sales in a tabular 

format.

You need to help Jimmy to accomplish the required task.
Prerequisite: To perform this exercise, you need to use the 

Company_Brochure.docx file. 

For this,
you need to click the Company_Brochure.zip link and save file as 

Company_Brochure.zip.
Further, unzip it and use the Company_Brochure.docx file to complete 

your exercise.

2.Draw a flowchart that accepts two numbers and checks if the first number 

is divisible 

by the second number

3.Draw a flowchart to accept the radius and to calculate the area of a circle.

4.Draw a flowchart that accepts three numbers and displays the least of these 

numbers.

5.Maria is working with A-Star Ltd. as a technical writer. To create an official 

document, she needs
to implement the following settings:
        1. A company logo and address should be placed at the top left corner. 

The font should be Arial
and the font size should be 12.
        2. The document title should be bold, underlined, and centrally aligned. 

The font should be Arial
and the font size should be 14.
        3. The document text should be left aligned. The font should be Arial, 

and the font size needs to
be 12.
She wants to create a template to perform the task quickly and efficiently and to 

ensure that none
of the preceding settings is missed out. You need to help Maria in creating the 

required template.
Prerequisite: To perform this exercise, you need to use the Logo.jpg file. For this, 

you need to click
the Logo.zip link and save file as Logo.zip. Further, unzip it and use the Logo.jpg 

file to complete
your exercise.

if you want solution so you can download from link:-

Ans :-

• CLICK HERE

_________________________________________________________________________

LBPS Lab at home2

Q.1.Write an algorithm for accepting two numbers, divide the first 

number by the second, and display their quotient?

Q.2.Write an algorithm that accepts a distance in kilometers, 

converts the same into meters, and then displays the result.

Q.3.Write an algorithm that accepts a letter from the alphabet and 

determines whether it is a vowel or a consonant.

Q.4.Write an algorithm that accepts five numbers and displays the 

sum and average of the numbers.

Q.5.Write an algorithm that accepts the distance and speed values 

for a particular journey, calculates the time taken for the journey, 

and displays it.

Q.6.Write an algorithm that accepts the length of the side of a 

square and displays its area.

Q.7.Write an algorithm that accepts two numbers and displays 

the larger of the two.

Ans :-

• CLICK HERE

LBPS LAB AT HOME 1

Logic Building Problem solving(LBPS) Lab at home 1:-

If you want download (lbps) lab at home 1 so you can download here:-

Ans :- 

• CLICK HERE