The sequences of steps can be used to identify the desired restaurant is 1,2 and 3
An algorithm is a method for performing calculations or finding solutions to issues. Algorithms perform as a detailed set of instructions that carry out predetermined operations sequentially in either hardware-based or software-based routines.. All aspects of information technology employ algorithms extensively.
Algorithms for C programming introduction. Describe an algorithm. An algorithm is a procedure or comprehensive instruction manual for solving a problem.
Based on data storage, sorting, and processing, algorithms are used to solve problems in the best way feasible. By doing this, they raise a program's effectiveness. In all branches of computing, algorithms are employed.
The complete question : A large spreadsheet contains the following information about local restaurants. A sample portion of the spreadsheet is shown below.
A Restaurant Name
B Price Range
C Number of Customer Ratings
D Average Customer Rating
E Accepts Credit Cards
1
Joey Calzone's Pizzeria
lo
182
3.5
false
2
78th Street Bistro
med
41
4.5
false
3
Seaside Taqueria
med
214
4.5
true
4
Delicious Sub Shop II
lo
202
4.0
false
5
Rustic Farm Tavern
hi
116
4.5
true
6
ABC Downtown Diner
med
0
-1.0
true
In column B, the price range represents the typical cost of a meal, where "lo" indicates under $10, "med" indicates $11 to $30, and "hi" indicates over $30.
In column D, the average customer rating is set to -1.0 for restaurants that have no customer ratings.
A student is developing an algorithm to determine which of the restaurants that accept credit cards has the greatest average customer rating. Restaurants that have not yet received any customer ratings and restaurants that do not accept credit card are to be ignored.
Once the algorithm is complete, the desired restaurant will appear in the first row of the spreadsheet. If there are multiple entries that fit the desired criteria, it does not matter which of them appears in the first row.
The student has the following actions available but is not sure of the order in which they should be executed.
Action
Explanation
Filter by number of ratings
Remove entries for restaurants with no customer ratings
Filter by payment type
Remove entries for restaurants that do not accept credit cards
Sort by rating
Sort the rows in the spreadsheet on column D from greatest to least
Assume that applying either of the filters will not change the relative order of the rows remaining in the spreadsheet.
Which of the following sequences of steps can be used to identify the desired restaurant?
Filter by number of ratings, then filter by payment type, then sort by rating
Filter by number of ratings, then sort by rating, then filter by payment type
Sort by rating, then filter by number of ratings, then filter by payment type
A
1 and 2 only
B
1 and 3 only
C
2 and 3 only
D
1, 2, and 3
To learn more about algorithm refer to :
https://brainly.com/question/13800096
#SPJ4
