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.

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