Creating a simple student grade database

Discuss MyInfo and get help here
Post Reply
dustinm
Posts: 12
Joined: Fri Oct 25, 2019 5:04 am

Creating a simple student grade database

Post by dustinm » Fri Oct 25, 2019 5:17 am

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

Petko
MyInfo Support
Posts: 2371
Joined: Sun Jul 25, 2004 4:33 pm
Contact:

Post by Petko » Mon Oct 28, 2019 5:16 pm

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).

dustinm
Posts: 12
Joined: Fri Oct 25, 2019 5:04 am

Post by dustinm » 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.

Dustin

dustinm
Posts: 12
Joined: Fri Oct 25, 2019 5:04 am

Post by dustinm » 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?

Dustin

Petko
MyInfo Support
Posts: 2371
Joined: Sun Jul 25, 2004 4:33 pm
Contact:

Post by Petko » Tue Oct 29, 2019 2:32 pm

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?

Post Reply