iDoceo 7 for macOS and iPadOS now available!

You will find all the details explained here
Welcome, Guest
Username: Password: Remember me

TOPIC: Copying rows of data

Copying rows of data 3 months 1 week ago #8984

I need to be able to copy a student, and their grade book data, into new classes. Kids get mixed up into new classes so although the columns stay the same for each class, the individual kids within the classes change and I’d like to be able to see their historical data and grades from last year in this year’s class. I can’t just copy and paste a column or tab as the data would then be next to a different kids name. I hope this makes sense! Is this possible?
The administrator has disabled public write access.

Copying rows of data 3 months 1 week ago #8992

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3265
  • Thank you received: 617
Hello emilyokeeffe,
If you copy a column from one class to another and enable the 'copy cells option' shown in the image it will only transfer data that belongs to the same student. They won't be mixed up. It is a - moderately - smart copy.

IMG_1622.jpg



You should also keep in mind that the student's sheet > Summary section will let you see the historical data of each student (on any class/year) that he is or was attending.

Find attached below a sample screenshot

IMG_A17E70793D2A-1_2020-08-20.jpeg
Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
The administrator has disabled public write access.

Copying rows of data 3 months 1 week ago #8996

This is great - thank you so much! One more question: is there a way to workaround the duplication of columns this creates? Eg if I have students from 4 different classes merging in to one, can I also merge the data into one column rather than have 4 duplicated ones?
The administrator has disabled public write access.

Copying rows of data 3 months 1 week ago #8998

  • tomka
  • tomka's Avatar
  • OFFLINE
  • Skilled member
  • Posts: 35
  • Thank you received: 7
I think you could create another column and calculate the average of the 4 columns. Since there is only one value, the average is equal to the column that holds the value. If you want you can hide the 4 "source-columns".
The administrator has disabled public write access.
The following user(s) said Thank You: bert

Copying rows of data 3 months 1 week ago #8999

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3265
  • Thank you received: 617
@emilyokeeffe, what tomka states is perfectly valid. You could easily add a folder/category that would do that for you. Just set the calculation as average.
If we had these two columns shown in the image:

IMG_1623.jpg



It would look like this (and you can close the folder to see only the results)

IMG_1625.jpg


IMG_1624.jpg
Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
The administrator has disabled public write access.

Copying rows of data 3 months 1 week ago #9000

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3265
  • Thank you received: 617
There is however a slightly better solution if cells do not overlap, like in our example.
If we have this


IMG_1627.jpg


and tap on Tools > Columns > Select both Homework A and HomeWorkB and then tap on Merge


IMG_1629.jpg



it would look like this


IMG_1628.jpg
Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
Last Edit: 3 months 1 week ago by bert.
The administrator has disabled public write access.

Copying rows of data 3 months 1 week ago #9001

Yes! That’s amazing - thank you!!!!
The administrator has disabled public write access.
Time to create page: 0.115 seconds
21 AUG

iDoceo 7 for iPad and Mac 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

Cookies policy

This website uses cookies to make it easier for you to use the forum. We do not track you for any kind of advertising or statistics. Cookies are only used to keep you logged in the forum in case you would like to post and to keep your language selection in case you use the automatic translation offered by Google. If you continue to use our offer and have activated this technology in your browser, you consent to the use of cookies.