Submit a pseudocode or flow chart solution for finding $$concern$$ students in BIT $1400$ if all students and

their grades were written in an excel spreadsheet $($ie a big grid of students and their grades$).$

name A$1$ A$2$ L$1$ L$2$ L$3$ L$4$

David $2015$ false False true False

Jinay $8065$ True True false True

Alexis $7075$ True True false False

A student is considered a $$concern$$ student if:

$1.$ they didn$$t attend at least $2$ of the $4$ labs so far and

$2.$ they failed either assignment $1$ or assignment $2.$ A fail is $<50\%$

Accessing the Data:

$$ On each row of the spreadsheet is a student$$s information. Rows can be referenced by row

number. For example table$[3]$ is row $3$ in the table. Table$[3][4]$ would be the cell at row $3$

column $4($in yellow above$)$

$$ Columns in the table will be student name, assignment $1$ grade $(\%),$ assignment $2$ grade $(\%),$

and $4$ lab attendance grades $($listed as true$/$false$)$ in that order. This makes $7$ columns. A

particular column can be referenced by column $($student name$),$ column$[$L$1]$ or some other

unambiguous naming convention.

$$ You can write subroutines. For each subroutine, just refer to it and define it later. For example, if

you had a subroutine checkLabs, you might call checkLabs$($myTable$,2)$ to check the labs for row

$2$ of the table named myTable. You would then need to define the pseudocode for checkLabs.