iDoceo 6 is now available!

We are updating the web with all the new features of iDoceo 6.
This is a manual update, please tap on this link if you wish to update on the App Store
Welcome, Guest
Username: Password: Remember me

TOPIC: Merging Columns Across Classes

Merging Columns Across Classes 2 years 1 month ago #7155

  • RJR
  • RJR's Avatar
  • OFFLINE
  • Junior Member
  • Posts: 6
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!
The administrator has disabled public write access.

Merging Columns Across Classes 2 years 1 month ago #7156

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 2973
  • Thank you received: 534
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..
Please take a moment to add or update your rating for iDoceo 5 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
itunes.apple.com/us/app/idoceo-teachers-...&action=write-review
Last Edit: 2 years 1 month ago by bert.
The administrator has disabled public write access.

Merging Columns Across Classes 2 years 1 month ago #7157

  • RJR
  • RJR's Avatar
  • OFFLINE
  • Junior Member
  • Posts: 6
Is there anyway to pull text through as plain text

i.e.

Cell contents = A
or
Cell contents = Pass
The administrator has disabled public write access.

Merging Columns Across Classes 2 years 1 month ago #7158

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 2973
  • Thank you received: 534
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)
Please take a moment to add or update your rating for iDoceo 5 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
itunes.apple.com/us/app/idoceo-teachers-...&action=write-review
The administrator has disabled public write access.
The following user(s) said Thank You: RJR

Merging Columns Across Classes 2 years 1 month ago #7159

  • RJR
  • RJR's Avatar
  • OFFLINE
  • Junior Member
  • Posts: 6
It's pulling through 0.00 for all students instead of the A* - U grades :(
The administrator has disabled public write access.

Merging Columns Across Classes 2 years 1 month ago #7160

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 2973
  • Thank you received: 534
I'd need some screenshots RJR. What was it showing before the COLUMNRESULT function.
Send it to This email address is being protected from spambots. You need JavaScript enabled to view it. and I'll give it a look.
Please take a moment to add or update your rating for iDoceo 5 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
itunes.apple.com/us/app/idoceo-teachers-...&action=write-review
The administrator has disabled public write access.

Merging Columns Across Classes 2 years 1 month ago #7161

  • RJR
  • RJR's Avatar
  • OFFLINE
  • Junior Member
  • Posts: 6
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
The administrator has disabled public write access.

Merging Columns Across Classes 2 years 1 month ago #7162

  • RJR
  • RJR's Avatar
  • OFFLINE
  • Junior Member
  • Posts: 6
Cancel the above!!!!!

I used Column Score!

Points for idiot go to me :D
The administrator has disabled public write access.

Merging Columns Across Classes 2 years 1 month ago #7163

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 2973
  • Thank you received: 534
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 take a moment to add or update your rating for iDoceo 5 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
itunes.apple.com/us/app/idoceo-teachers-...&action=write-review
The administrator has disabled public write access.

Merging Columns Across Classes 2 years 1 month ago #7164

  • RJR
  • RJR's Avatar
  • OFFLINE
  • Junior Member
  • Posts: 6
PowerUser :evil:

I'm your facebook admin ;)
The administrator has disabled public write access.
Time to create page: 0.114 seconds
9 DEC

iDoceo 6 is now available!

A huge update with tons of new features and a new interface

Read more

6 JUN

Create Multiple-choice tests with iDoceo Connect!

In addition to self-evaluation rubrics, your students can now fill exams online. Supports text and images - in answers and questions - and can easily be imported from an XLS template

Read more