>What about next year?
I'll admit that I'm not sure if this is a one year thing or the data will follow the student as they move to the next grade. I'm inclined to think that this will be for one year because there's a good possibility that each grade scores for different items (I've only seen the rubric for one other grade--3rd, which was similar, but not exactly the same). That's why I put the teacher in with the student.
>It sounds like you're trying to track ratings for performance in an English or Composing class. Are there other classes or subjects that might need to be tracked later?
This particular tool is based on a paper/pencil rubric for 1st grade students. This deals with how they are progressing with their writing abilities. The goal was to get away from the mess of paper/pencil tracking and the lack of ability to really analyze how things are going if it isn't in an electronic form, meaning a quick way to determine which students need extra help and in what specific areas or writing.
On Wednesday, December 3, 2014 9:46 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Jerry-
Close, but no cigar.
Why is Teacher in the Students table? Will the student have the same teacher all the time? What about next year?
It sounds like you're trying to track ratings for performance in an English or Composing class. Are there other classes or subjects that might need to be tracked later?
I would think you need a ScoringCategories table - initially to contain two rows, one each from Composing and Mechanics.
Then you also need a CategoryItems table with eight rows - four for Composing and four for Mechanics (the ID from the ScoringCategories table is a foreign key here).
Finally, you need a Grading table to contain StudentID, ScoringCategoryID, CategoryItemID, and Score.
Capiche?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Dec 3, 2014, at 3:10 PM, Jerry Mathers jerrymathersasthebeav@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
If you read my last question about too many Queries you'll know that I'm in a flat file rut and I'm hoping you can help me break through to the relational world. I've been asked to create a tool that will collect student data related to their writing abilities. I broke out good old Access to create this tool and when I started I realized I was, once again, just creating a "spreadsheet" in Access. So, maybe this is a good time to break free and build a better design and use this as my first attempt at getting better at doing it more efficiently. It is a fairly simple tool that also makes this a good one with which I can start my new life.
Here are the parameters/components I've been asked to include:
-Basic student information (Name, Grade, Student ID, Teacher).
-Two main categories for the various individual components to be tracked (Composing, Mechanics).
-Under the Composing category there are specific items to be tracked (Participation, Planning, Central Idea, Revising). Each item is scored as a 1, 2, 3 or 4.
-Under the Mechanics category there are specific items to be tracked (Letter Formation, Format, Punctuation, Capitalization). Each item is scored as a 1, 2, 3 or 4.
-There will be three times during the year when each of the specific items will be recorded (Fall, Winter, Spring).
I figure there should be:
I figure there should be:
-Four tables (Student_Info, Composing, Mechanics, Time_of_Year)
-The fields for each table will be what I listed above in each of the bulleted items (with name being split into First and Last).
-The primary key for the Student Info table will be StudentID.
-A foreign key in the other tables will be StudentID and the primary keys will be an auto number field.
-The relationships will be from the Student_Info table to each of the other three tables via the StudentID field.
So, in the end my question is, is this a normalized relational structure? Am I beginning to finally "get it"? (I have spent time over the last number of days reading and trying to understand as much as I could about the subject, including the videos and documents from Ms. Crystal.)
__._,_.___
Posted by: Jerry Mathers <jerrymathersasthebeav@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar