F5F Stay Refreshed Software Operating Systems Need assistance assessing votes for the project day?

Need assistance assessing votes for the project day?

Need assistance assessing votes for the project day?

S
SuperScout345
Member
217
07-12-2016, 05:36 AM
#1
Hi, for the project day you have 8 groups with a maximum of 20 students each. Each student receives 4 votes—two for primary and two if a group is full. You’re considering using Excel but need help organizing the data. A possible layout could be a table with columns like Name, Firstname, Class, Vote1, Vote2, Vote3, Vote4. To meet your needs, you’d want to structure it so each project gets its own color and students are distributed across two projects, ensuring no more than 20 per group.
S
SuperScout345
07-12-2016, 05:36 AM #1

Hi, for the project day you have 8 groups with a maximum of 20 students each. Each student receives 4 votes—two for primary and two if a group is full. You’re considering using Excel but need help organizing the data. A possible layout could be a table with columns like Name, Firstname, Class, Vote1, Vote2, Vote3, Vote4. To meet your needs, you’d want to structure it so each project gets its own color and students are distributed across two projects, ensuring no more than 20 per group.

G
Grimzagh
Member
57
07-12-2016, 05:50 AM
#2
I'll organize the results alphabetically by letter and apply manual coloring as requested.
G
Grimzagh
07-12-2016, 05:50 AM #2

I'll organize the results alphabetically by letter and apply manual coloring as requested.