ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
INSTRUCTIONS
2
For each presentation/seminar, create a new sheet that's a copy of the template.
3
Change the name of each sheet to the name of the presentation, and add the same name to the "Presentation" column on the "summary" sheet.
4
Add the presenter's name to the "Presenter" column.
5
In each presentation sheet, fill out the scores of all the categories, and the comments given in the feedback. Each row represents feedback from one participant.
6
(If you used the feedback form template, the sheets should be easily copied from the feedback results spreadsheet and pasted here)
7
For readibility, you can remove the unused rows (they will be ignored if not deleted).
8
Once all the data is copied, the summary sheet will calculate the average scores for each presentation, rank the presenters according to average and show score annomalies.
9
(You can delete the examples at any point, or fill them with real data)
10
11
12
13
14
15
16
17
18
19
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