Generate dynamic lists from other tables in Numbers
This is a discussion on Generate dynamic lists from other tables in Numbers within the iWork Forum forums, part of the iPad App Store category; I'm asking for help, not giving directions. I forgot the ?mark.
I'm a teacher, and I would like a table that looks up the ...
How do I Generate dynamic lists from other tables in Numbers
I'm asking for help, not giving directions. I forgot the ?mark.
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 name - bob - mary - joe
Math score ------d------d------a
Students grouped by grade level
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.
Last edited by Rwpreed; 08-03-2012 at 09:05 PM.
08-02-2012 02:28 PM
By aframiller326 in forum iPad for Business and Education
Last Post: 05-16-2013, 07:36 AM
By hawtin in forum iPad at Work
Last Post: 04-08-2012, 04:57 AM
By rndoliveira in forum iPad General Discussions
Last Post: 01-02-2012, 06:39 PM
By daker in forum iWork Forum
Last Post: 08-21-2011, 12:55 AM
By rickjackson in forum iPad Development
Last Post: 04-07-2011, 01:34 AM
Search tags for this page
create a dynamic list in apple numbers
dynamic list data list apple ipad numbers
ipad numbers generate dynamic list from other tables
ipad numbers pivot table
iwork dynamic table
mac numbers dynamic table
numbers dynamic tables
pivot tables numbers ipad
Click on a term to search for related topics.