Newbie questions about data

[rreifs68]

Hello everyone,

I have extensive experience with Excel, but this new project appears to be too big for that. It was suggested that I look at Access for it.

I am a team leader for an online school. We have a SQL server that gives us current information for where our students are in the course (and a ton of other stuff). It is great as a snapshot of now, but it is hard to get a historical perspective. When I had my own class, I recorded a few data points every week, and was able to pull them up as needed. I am now working with well over a thousand kids data, and my old method is too cumbersome. To add to the complexity, we have open enrollment, so students are constantly adding in and going away.

What I would like to do is to take a weekly snapshot of every student. Let's say percent complete, current grade, number of assignments submitted this week, total number of assignments submitted so far, weeks active, and weeks behind. Ultimately, I would like to be able to use it to identify students that are not making adequate progress

Should each week's data be a separate table, or should they all go into the same table?

I am sure that I will have more questions later. Thank you in advance for your insight.



BobR

[ranman256]

the tables I use are:
tClassroom. (has list of all in the class by StudentID, )
tClassAssignments (all work assigned to students in the class)
tClassWork (each students result of the assignments)

for updates,
download the excel file by saving it the same place everytime, i.e.: c:\temp\File2Import.xls
overwriting it each time.


PREP:
link this as an external table. (done only once)
build an append query to import the data from the xl file.
put this query in a macro.

STEPS: then the steps are:
1. save the XL file,
2. run the macro.
done.

and all imports go into 1 table. The date will differentiate the records.

[rreifs68]

the tables I use are:
tClassroom. (has list of all in the class by StudentID, )
tClassAssignments (all work assigned to students in the class)
tClassWork (each students result of the assignments)

for updates,
download the excel file by saving it the same place everytime, i.e.: c:\temp\File2Import.xls
overwriting it each time.


PREP:
link this as an external table. (done only once)
build an append query to import the data from the xl file.
put this query in a macro.

STEPS: then the steps are:
1. save the XL file,
2. run the macro.
done.

and all imports go into 1 table. The date will differentiate the records.

OK, thank you!