There are n number of students in student in sekolah menengah convent the scool principal would like to know the average weight is greater than 3 kilograms display “it is heavy” otherwise display “excellent”. draw a flowchart to display the average weight and suitable message

There are n number of students in student in sekolah menengah convent the scool principal would like to know the average weight is greater than 3 kilograms display “it is heavy” otherwise display “excellent”. draw a flowchart to display the average weight and suitable message

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter7: Developing An Excel Application

Section: Chapter Questions

Problem 10RA

See similar textbooks

Related questions

Q: Best Computers Store is a store that specializes in selling desktop computers and computer monitors.…

A: Here is the Flowchart:-

Q: “An application requires a user to enter two numbers. Once the user has entered the two numbers, the…

A: Algorithm: Step 1: Start Step 2: Input N1, N2 Step 3: Sum = 0 ; Avg = 0 Step 4: Calculate Sum = (N1…

Q: You are working as a teaching assistant at a local university, you gave your students a mathematics…

A: % Matlab script to determine the number of students who got grades greater % equal to 50 and number…

Q: A customer want to buy 6 items. He has only 50.50 OMR with him. The price of the products are…

A: Solution: Algorithm to check weather all the 6 products can be bought :…

Q: Mobile Service Provider Write a flowgorithm program that will calculate a person’s mobile phone…

A: Please find the answer in the following steps. Flowchart: => It is a picture of the separate…

Q: Create the following programming tasks: a. Flowchart that converts temperature (Fahrenheit to…

A: We have to draw the flowchart of the following programming task : a) Flowchart that converts…

Q: 1a. Please create the pseudocode that read three different integer number, then display the average…

A: To find the average of 3 numbers, we just divide the sum by 3 and store it in a new variable which…

Q: In the following flowchart, what value of SNUM will be printed? BEGIN NUM=6 SNUM=NUM²-1 NUM=NUM-1…

A: b. SNUM = 18

Q: When mailing a letter, the amount of postage is in question. You like to use this rule of thumb: use…

A: Step 1: take input of sheets. Step 2: Find out the stamp required by sheets/5. Step 3: Round off the…

Q: a) Based on the requirement given below, prepare a flowchart for a program develop for PaintsForYou…

A: The flow chart can be drawn for the specified program output. The program actually obtains the…

Q: Ahmed wants to gift his friend He has 82.300 OMR. He wants the following products Sport suite with…

A: 1)Start 2)Initialize cost of all items=0 3)Intialize amount =82.300 4)Now ,calculate cost of all…

Q: A customer want to buy five items. He has only 75.0 OMR with him. The price of the products are…

A: Define mouse←6.50, keyboard←10.50, webcam←15.00, flashDrive←5.25, headphone←7.50, pen←1.00 Define…

Q: Ahmed wants to gift his friend. He has 82.300 OMR. He wants the following products: Sport suite with…

A: Algorithm: Start Initialize amount=82.300 OMR Initialize sum=0 Initialize an array prices with…

Q: Afrah wants to gifts her friend. She has 160 OMR. She wants the following products: Books with 10.00…

A: Initialize amount to temp variable and counter for the array as 0, If the while loop traverse then…

Q: A customer want to buy 6 items. He has only 50.50 OMR with him. The price of the products are…

A: Algorithm: Start Declare and initialise variables…

Q: write flowchart and pseudo code for that: If the user chooses this option then the user needs to…

Q: A certain store sells softdrinks for P 6.00 and sandwiches for P 6.85. Draw the flowchart to input…

A: Flowchart: - It's just a visual description of stages while writing a program. It illustrates steps…

Q: A customer want to buy five items. He has only 75.0 OMR with him. The price of the products are…

A: Solution: We will keep a counter i for the while loop to traverse the array. We will keep a check…

Q: Create a flowchart that ask a user to input a student name, student number , four (4) periodical…

A: The flowchart is given below.

Q: A customer want to buy five items. He has only 75.0 OMR with him. The price of the products are…

A: No.of items = 6 Total_Cost = 0 items = 0 Total_OMR = 75 while items !=No.of Items Add…

Q: A customer want to buy five items. He has only 70.0 OMR with him. The price of the products are…

A: Flowchart and algorithm represent how a problem can be solved in several steps programmatically. A…

Q: The program will ask the user to enter weight in pounds and height in inches and displays the Body…

A: Code: To calculate and display BMI status, height in meters and weight in kgs #include…

Q: C++ use the flowchart to code, use the exact names and everythin

A: Required:

Q: Write an algorithm/pseudocode for a movie rental company that wants to screen their customers from…

A: Pseudocode- DECLARE customerAge INPUT cutomerAge IF customerAge<18: PRINT "You are not allowed to…

Q: Ahmed wants to gift his friend. He has 82.300 OMR. He wants the following products: Sport suite with…

A: Ahmed wants to gift his friend. He has 82.300 OMR. He wants the following products: Sport suite with…

Q: Flowchart for this given task please and also please give a little explanation of how you did your…

A: ANSWER:-

Q: A customer want to buy five items. He has only 120.0 OMR with him. The price of the products are…

A: Algorithm: Let item be the items purchased by the customer let price be the price of each item…

Q: Question 4 Convert_24hours_time 1 2 3 4 567 7 Prompt for hours, minutes Get hours, minutes DOWHILE…

A: The above question is solved in step 2 :-

Q: A customer want to buy five items. He has only 120.0 OMR with him. The price of the products are…

Q: A software company sells a package that retails for $99. Quantity discounts are given according to…

A: #pseudeo_code Retail_price=99 Input : quantity= take number of package purchase if (quantity>=10…

Q: Create a flowchart that reads weight in pounds and output the weight in kilograms. Moreover, if the…

A: Please find the flowchart below step. Sample Program is written in java.

Q: Trainers at Tom's Athletic Club are encouraged to enroll new members. Write an application that…

A: Step 1 Algorithm Step 1 : Begin Step 2 : Declare an array of strings with size 25 and an array of…

Q: A customer want to buy five items. He has only 120.0 OMR with him. The price of the products are…

A: Start Initialize amount in hand to 120 If amount>=5.50 amount=amount-5.5 If amount>=25…

Q: • Draw a flowchart that obtains from the user, annual interest rate, the term of the loan (in years)…

A: - We need to create a flowchart for the given payment calculation. - We will divide the rate by 12…

Q: W XYZ Corporation pays its salespeople a commission based on the amount of their sales, as shown in…

A: x = 1 commission = 0 total_sales = 0 while(x<101): salesamount= int(input(f'\nEnter sales amount…

Q: A student took four quizzes in a term and would like to compute their average. He also would like to…

A: The creation of an algorithm, pseudocode, and flowchart are performed before starting coding a…

Q: 4. Ahmed wants to gift his friend. He has 82.300 OMR. He wants the following products: Sport suite…

A: Algorithm Step 1- Start Step 2- Amount=82.300,Sport_suit=15.700, Sport_shoes=32.00,…

Q: Afrah wants to gifts her friend. She has 160 OMR. She wants the following products: Books with 10.00…

A: Start Initialize amount to 160 If amount>=10 amount=amount-10 If amount>=60.10…

Q: Draw flowchart to input the letter and display the messages as given below: Letter Semesters F, f…

Q: Ahmed wants to gift his friend. He has 82.300 OMR. He wants the following products: Sport suite with…

A: Given : Ahmed wants to gift his friend. He has 82.300 OMR. He wants the following products:Sport…

Q: You are working as a teaching assistant at a local university, you gave your students a mathematics…

A: A required program is as follows, % define the vector of grades grades = [35, 50, 70, 63, 66, 90,…

Q: Create a flowchart that will ask the user for his/her age and will determine whether he/she is a…

A: Flowchart: Flowchart is diagrammatic representation of an algorithm. A flowchart is a visual…

Q: Y = a + 2b + 3c value for each of 50 (a, b, c) (integer a, b, c) value groups calculating. Y values…

A: Spark is a lightning-fast cluster computing designed for fast computation. It was built on top of…

Q: a) You need to complete a flowchart that determines whether a temperature is below or above the…

Q: A student took four quizzes in a term and would like to compute their average. He also would like to…

A: Algorithm (Narrative) 1. Input marks of 4 quiz 2. Add the marks of 4 quiz to get the total(tot) 3.…

Q: A customer want to buy 6 items. He has only 50.50 OMR with him. The price of the products are…

A: Algorithm: Start Initialize amount to 50.50 OMR Initialize prices array with given prices…

Q: Create a flowchart that will accept a students’ name and grade in his twenty (20) subjects. It will…

A: Flow chart: It is used to represent program steps in the pictorial representation. Using the flow…

Q: One large chemical company pays its salespeople on a commission basis. The salespeople receive $200…

A: Given data, One large chemical company pays its salespeople on a commission basis. The salespeople…

Q: You need to complete a flowchart that determines whether a temperature is below or above the…

A: Steps Order Start Read Temperature If Temprature > 0o C Yes ( Left Edge ) No (Righ Edge) Above…

Q: Afrah wants to gifts her friend. She has 160 OMR. She wants the following products: Books with 10.00…

A: 1) Create A Function BuyOrNot 2) Find The Total Cost Of Products = Cost Of Books + Cost Of Dress +…

Concept explainers

Concept of flowchart

A flow chart diagram is a collection of symbols that represents the steps involved in a process. It is a generic tool that can be adapted for various purposes. It is one of the most common process analysis tools. It is used for the graphical analysis of an algorithm. It helps to represent the flow of the process from the input to output. A flowchart that represents the workflow of activities is known as an activity diagram.There are so many ways that can help people to understand computer technologies and their applications. One of them is a flowchart diagram.

Question

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

W XYZ Corporation pays its salespeople a commission based on the amount of their sales, as shown in the following table: Sales (RM) Commission Rate(%)Above 10,000 10.05,000 to 10,000 7.5Below 5,000 5.0 Design an algorithm and a flowchart that prompts 100 users to enter the sales amount and then calculate and display the appropriate commission
One large chemical company pays its salespeople on a commission basis. The salespeople receive $200 per week plus 9% of their gross sales for that week. For example, a salesperson who sells $5000 worth of chemicals in a week receives $200 plus 9% of $5000, or a total of $650. Draw a FLOWCHART that will input each salesperson’s gross sales for last week and will calculate and display that salesperson's earnings. Process one salesperson's figures at a time.
Create a flowchart that will accept a students’ name and grade in his twenty (20) subjects. It will compute and display the average of the student and ask if the user wants to input another name and grades
A company has 45 employers, 25 work as system developers (D) and (N) work as sales representer while (M) of them work as IT technicians. This company deals with 450 products. In the products table, each product has a name, price, size, and weight. A. Draw a flowchart to find the product that has very heavy weight B. Draw a flowchart to find how many numbers of the products have a Small size(s), where there are 3 product sizes (S, M, L).
Create a flowchart that will ask the user for his/her age and will determine whether he/she is aminor (0-17) or an adult.
Reads two values, determines the largest value and prints the largest value with an identifying message draw Flowchart
Trainers at Tom's Athletic Club are encouraged to enroll new members. Write an application that allows Tom to enter the names of each of his 25 trainers and the number of new members each trainer has enrolled this year. Output is the number of trainers who have enrolled 0 to 5 members, 6 to 12 members, 13 to 20 members, and more than 20 members. Answer need in pseudocode form and flowchart.
Ahmed wants to gift his friend. He has 82.300 OMR. He wants thefollowing products:Sport suite with 15.700 OMRSport shoes with 32.00 OMRSport water bottle with 4.50 OMRHeadphone with 8.25 OMRiPod with 9.88 OMRWrite an algorithm and draw a flowchart to check whether he can buy all the aboveitems. Display the total, and the remaining amount in OMR that Ahmed will haveif any
make a flowchart to display thankyou message.
Users insert coins into the vending machine and then enter the two character item code of their selection if the user has inserted enough money the vending machine will release the chosen item and output any change required. If the user enters an invalid item code then a suitable error message is displayed. Draw the vending machine algorithm in the part above as a flowchart.
Mobile Service Provider Write a flowgorithm program that will calculate a person’s mobile phone bill based on plan chosen and the data used. The program should perform the following: Ask for customer’s mobile plan Ask for the number of gigabytes of data used Display an error message if the plan choice is invalid or the gigabytes used is less than zero (0) Mobile data plans are: Plan A 19.99/month, with 4 gigabytes data, additional data $10/gigabyte Plan B 29.99/month, with 8 gigabytes data, additional data $5/gigabyte Plan C 39.99/month, unlimited data Remember the following: use clear prompts for your input label each output number or name use comment box for your name, lab name and date at the top of the flowgorithm use other comments where appropriate use appropriate constants
Flowchart for this given task please and also please give a little explanation of how you did your flowchart please. Thank you Task 3: Find the numbers that can be expressed as the product of two nonnegative integers in succession and print them in increasing order. For each number found the program should check whether the number is a multiple of 5 and indicate this in the output. (For example, 30 is such a number as it can be written as the product of 5 and 6 (30=5x6), which are two numbers in succession.) The user should specify how many such numbers they want to print.