What's new
Apple iPad Forum 🍎

Welcome to the Apple iPad Forum, your one stop source for all things iPad. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

Generate dynamic lists from other tables in Numbers

Rwpreed

iPF Noob
Joined
Aug 2, 2012
Messages
1
Reaction score
0
How do I Generate dynamic lists from other tables in Numbers

I'm asking for help, not giving directions. I forgot the ?mark.

Hello
I'm a teacher, and I would like a table that looks up the grade achievement for my students, and sorts them into groups based on their scores. The idea is to save me time by generating the lists of students who need extra help with a particular skill or subject, rather than me having to go through a table of scores for 20 kids with marks in 20 different skill sets (math in particular) manually.

This is a very simplified example of what I'd like it to do.

Student scores
Student name - bob - mary - joe
Math score ------d------d------a
Reading score---a------b------a

Students grouped by grade level
Grade level------A--------B-------C---------D
Math groups----Joe-----none---none---bob, mary
Reading grp--bob,joe-- mary---none----none

I'd like to be able to do this so that all I have to do is change the data in table 1 and it will automatically update the lists in table two, so that if bob goes from d to c his name will move from the D column in math to the C column.

I was able to something like this with a column of checklists paired with list words that concatenated all the words that were left unchecked, but I needed 42 separate if statements, and it only dealt with t/f, but this new challenge obviously deals with 4 possible outcomes per student.

Hope you can help. Thanks in advance.

Roy
 
Last edited:

Most reactions

Latest posts

Top