Page 1 of 1

Creating a simple student grade database

Posted: Fri Oct 25, 2019 5:17 am
by dustinm
Hello
I am a new user of MyInfo. I am a teacher who currently uses Access to manage student grade information. I would like to explore ways I could possibly use Myinfo as a replacement for Access. My requirements as not that complex:

Student ID
Student Name
Assignment name
Assignment grade

I was thinking I could create a folder for each student which would function like a "form". I could create attributes/columns for things like student ID, student name.

I am not sure if I should enter grades as an attribute, or create a table in each folder to enter that info.

And then I need to figure out how to merge all the separate tables into one master list so that I can manipulate all the collected data in excel when necessary.

Does anyone have any suggestions?

Dustin

Re: Creating a simple student grade database

Posted: Mon Oct 28, 2019 5:16 pm
by Petko
If you want to be able to export the file to Excel (via CSV file), you need all this data as attributes.

Then you create a document for each student (with their ID and name in separate columns, one of which should be the Documents column).

For the grades, you need to create similar document, but with the assignment name and grade included. Then when dealing with the same student, you can just copy and paste the previous assignment document and edit the assignment part of it.

So, the tree will look like this:

Code: Select all

    Student ID | Student Name | Assignment name | Assignment grade 
[-] ID 1       | Name 1       | (empty)         | (empty)
    - ID 1     | Name 1       | Assignment 1    | Grade 1
    - ID 1     | Name 1       | Assignment 2    | Grade 2
    - ID 1     | Name 1       | Assignment 3    | Grade 3
[+] ID 2       | Name 2       | (empty)         | (empty)
...    
You can export this file using File > Export > CSV file (use the ; separator, so the Excel can open it easier).

Re: Creating a simple student grade database

Posted: Tue Oct 29, 2019 4:49 am
by dustinm
Would it be possible to lock a document from editing after entering the data? This would prevent accidental changing of data after it has bee n entered in this simple database.

Dustin

Re: Creating a simple student grade database

Posted: Tue Oct 29, 2019 5:18 am
by dustinm
Is there a way to import from excel in the reverse direction?

I have some student data already entered in excel. How could I import this into my Myinfo student grade database which I created according to your suggestions above?

Dustin

Re: Creating a simple student grade database

Posted: Tue Oct 29, 2019 2:32 pm
by Petko
dustinm wrote: Tue Oct 29, 2019 4:49 am Would it be possible to lock a document from editing after entering the data? This would prevent accidental changing of data after it has bee n entered in this simple database.
It will be possible in MyInfo 7. It is not possible currently in MyInfo 6.
dustinm wrote: Tue Oct 29, 2019 5:18 am Is there a way to import from excel in the reverse direction?

I have some student data already entered in excel. How could I import this into my Myinfo student grade database which I created according to your suggestions above?
You can import and export between MyInfo and Excel using the CSV import/export function.

However, in order to give you more details about how you can import the existing grades, I will need more information about that file structure. Could you send me a partial sample (without student personal information) at support@milenix.com?