Merging Columns Across Classes

More
6 years 6 months ago #7155 by RJR
Merging Columns Across Classes was created by RJR
Hi,

I have followed the video for merging columns across classes successfully and I am now pulling data from three classes into a master class to track percentages in tests.

However, I cannot get it to collate the grades (A* - U), does this column merging not work with strings of data?

Help!

Please Log in or Create an account to join the conversation.

More
6 years 6 months ago - 6 years 6 months ago #7156 by bert
Replied by bert on topic Merging Columns Across Classes
It works with Text based grades but formulas take its value as a percentage.
A* is a 1.00 (or what you've configured) B is 0.7 and so on..
Last edit: 6 years 6 months ago by bert.

Please Log in or Create an account to join the conversation.

More
6 years 6 months ago #7157 by RJR
Replied by RJR on topic Merging Columns Across Classes
Is there anyway to pull text through as plain text

i.e.

Cell contents = A
or
Cell contents = Pass

Please Log in or Create an account to join the conversation.

More
6 years 6 months ago #7158 by bert
Replied by bert on topic Merging Columns Across Classes
On the Formula's header (double tap header) > Grade type > Select your grade type (A* - U)

Now add the function COLUMNRESULT (it is in the 'Legacy functions' list) wrapped around what you've typed now


COLUMNRESULT (COLUMN1)

or

COLUMNRESULT ( COLUMN1 + COLUMN2 + COLUMN 3)
The following user(s) said Thank You: RJR

Please Log in or Create an account to join the conversation.

More
6 years 6 months ago #7159 by RJR
Replied by RJR on topic Merging Columns Across Classes
It's pulling through 0.00 for all students instead of the A* - U grades :(

Please Log in or Create an account to join the conversation.

More
6 years 6 months ago #7160 by bert
Replied by bert on topic Merging Columns Across Classes
I'd need some screenshots RJR. What was it showing before the COLUMNRESULT function.
Send it to support@idoceo.net and I'll give it a look.

Please Log in or Create an account to join the conversation.

More
6 years 6 months ago #7161 by RJR
Replied by RJR on topic Merging Columns Across Classes
Its always displayed 0.00

I did manage to have it do a grade conversion when I had the original data set as numerical and then it changed it to a grade but it still showed the numerical value in the combined column.

Sent you an email with a link to a google drive folder :)

Thanks Bert

Please Log in or Create an account to join the conversation.

More
6 years 6 months ago #7162 by RJR
Replied by RJR on topic Merging Columns Across Classes
Cancel the above!!!!!

I used Column Score!

Points for idiot go to me :D

Please Log in or Create an account to join the conversation.

More
6 years 6 months ago #7163 by bert
Replied by bert on topic Merging Columns Across Classes
I know it is bit confusing but truth be told not many users made it this far into formulas!
If you miss anything else do not hesitate to post.

Please Log in or Create an account to join the conversation.

More
6 years 6 months ago #7164 by RJR
Replied by RJR on topic Merging Columns Across Classes
PowerUser :evil:

I'm your facebook admin ;)

Please Log in or Create an account to join the conversation.