DB/Table Design

[Guest]

I wonder if someone could help me with this design (Access 2003)

I want to track student standardized test scores. I need to track them by
student, when and/or how many times they took the test and what the score
was. Keep in mind that certain test (SAT) scores Math, Writing, Critical
Thinking, while (ACT) scores English, Reading, Math.

So far I have come up with the following:

Student Table TestAtemp Table Test Type Table
StudentID* AtempID* TypeID*
FristName Date Type
LastName TypeID
GradeYear StudentID

I get stuck when it comes to relating the test types with individual scores.

Any help would be appreaicated.

 

[Jason Lepack]

Students:
student_id, first_name, last_name, grade_year
1, Jason, Lepack, 5

Test_Types:
test_type_id, test_type
1, SAT
2, ACT

Attempts:
attempt_id, attempt_date, test_type_id, student_id
1, 1/1/2007, 1, 1
2, 2/2/2007, 1, 1
3, 3/3/2007, 2, 1

By individual scores, you mean Math, Writing, Critical, etc?
If so, then is Math on the SAT equivalent to Math on the ACT?

Cheers,
Jason Lepack

 

[Steve]

Years ago when I took the SAT, the score was in two parts; Math and Verbal.
Is it still the same? Or does one only get an overall SAT score now? Or does
one get a score in each subject? I never took the ACT. How is it scored
relative to my question about the SAT? Further, many students use to take
the SAT in both their junior year and senior year. Do they stoll do that? If
so, do you want to record each time a student takes the test?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Guest]

Students:
student_id, first_name, last_name, grade_year
1, Jason, Lepack, 5

Test_Types:
test_type_id, test_type
1, SAT
2, ACT

Attempts:
attempt_id, attempt_date, test_type_id, student_id
1, 1/1/2007, 1, 1
2, 2/2/2007, 1, 1
3, 3/3/2007, 2, 1

By individual scores, you mean Math, Writing, Critical, etc?
If so, then is Math on the SAT equivalent to Math on the ACT?

Cheers,
Jason Lepack




Math on SAT is Math on ACT, But ACT has a composite score and SAT doesn't. Each of the test may have different score categories.

 

[Jason Lepack]

Here is how I would store the data based on the information given. I
would then create logic in the application that would ensure that each
ttc would be represented in the results.

Students:
student_id, first_name, last_name, grade_year
1, Jason, Lepack, 5

Test_Types:
test_type_id, test_type
1, SAT
2, ACT

Attempts:
attempt_id, attempt_date, test_type_id, student_id
1, 1/1/2007, 1, 1
2, 2/2/2007, 1, 1
3, 3/3/2007, 2, 1

Categories:
category_id, category_name
1, Math
2, Writing
3, Critical Thinking
4, English
5, Reading

Test_Type_Categories:
ttc_id, category_id, test_type_id
1, 1, 1
2, 1, 2
3, 1, 3
4, 2, 4
5, 2, 5
6, 2, 1

Attempt_Results
attempt_id, ttc_id, score
1, 1, 5
1, 2, 6
1, 3, 4
2, 1, 7
2, 2, 8
2, 3, 10
3, 4, 5
3, 5, 9
3, 6, 8

Cheers,
Jason Lepack