Copia di fabian nicolli - Esercizio per casa

	B	D	E	F	G	H	I	J	K	L	M	N
1
2		Italiano	Matematica	Inglese	Fisica	Informatica	Minimum grade	Maximum grade	Average	Serious deficiencies: 4	total shortcomings	Outcome
3		4	5	3	7	9	3	9	5,6	2	3	#ERROR!
4		5	5	5	6	7	5	7	5,6	0	3
5		5	3	4	4	6	3	6	4,4	3	4
6		5	6	6	5	6	5	6	5,6	0	2
7		5	8	6	3	9	3	9	6,2	1	2
8		5	7	4	5	10	4	10	6,2	1	3
9		5	5	8	7	8	5	8	6,6	0	2
10		7	7	7	8	9	7	9	7,6	0	0
11		7	6	6	9	8	6	9	7,2	0	0
12		4	6	8	3	8	3	8	5,8	2	2
13		6	5	6	4	9	3	9	6	1	2
14		6	6	5	8	7	5	8	6,4	0	1
15		7	5	8	3	7	3	8	6	1	2
16		5	6	7	5	8	5	8	6,2	0	2
17
18
19	If the total shortcomings = 0, then Return "Promoted" Otherwise, if the total fails > 3 or there are at least two grades = 4, then Return "Not Promoted" Otherwise, if the total of failings between 1 and 3 and there is at least one grade = 5, then Return "Promoted with deficiencies" Otherwise Return "Not Promoted" This flowchart represents the same conditions as the formula I gave you earlier to determine the outcome of the report card evaluation. The logic is as follows: If the total of the failings is equal to 0, the student is promoted; If the total of the failings is greater than 3 or if there are at least two marks equal to 4, the student is not promoted; If the total of the failings is between 1 and 3 and there is at least one mark equal to 5, the student is promoted with failings; In all other cases, the student is not promoted.
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100