RE: student groups, random, create more than once
- From: Wayne-I-M <WayneIM@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 21 Oct 2008 23:36:00 -0700
Hi,
I think that sometimes (I do it myself) there is a hold-over from "this is
the way I do it" into "this is the new method". There are some things that
are good about this - familiarity, less to learn, etc - but there are also
draw backs - you may not use the new method to it's best as you are still
holding on to older methods.
Hope that makes sense.
As an example - your excel books at the moment have 30 children in a certain
number of classes. If you add another child or class this would mean
re-designing some of the work-flow.
Access does not (well it shouldn't) work like that. If you set up the basic
tables’ right you can add or delete children and classes as many times as you
need. You can also add to the application (with excel this is difficult) eg.
You may want to run a new report to show a new requirement, you may need to
add to the child/class types by adding in meals or parent details or after
school activities. With access this is not too difficult - with excel it
would mean a re-design and so may not be worth the hassle.
So
The 1st thing you need to do is work out the end result you are looking for
– I know back to front but that’s how it is. Think about a cake – you know
you want it to have cream layers and chocolate flowers on the top – so you
will get the right ingredients before you even start to cook (mind you I
don’t – it’s a guy thing – just start the cake and see what it comes out like
– Mrs Wayne-I-M thinks this is funny by the way)
So – you want to be able to produce reports (a report in access – to my
mind) is any thing that is printed or mailed (may be wrong about the by way).
You also want to be able to record bad behavior. You want to be able to
allocate children into classes randomly. There are other things but that’s a
good start.
Just for these 3 things you will need to store the data in 2 tables
Details of the children
Details of the classes
If each child went o one class and one class only this would be very simple
– one to one. But in this case many (some, all, etc) can go to many classes
(some, all, etc). So this is not a one to one relationship it is a many to
many.
You will need an extra table – to hold details of the child/class relations.
The 1st thing to do then is to create your 1st 4 tables
tblChildren
tblClasses
tblAttendance
tblProblems
I assume you already know about basic table design – Always have a unique
identifier (you may have children with the same name – so this will identify
each child) – only put one bit of information in each field (so break down
the address don’t just type the whole thing into one field) etc.
In tblchildren you could have
ChildID – Auto number
Child1stName - text
Child2ndName - text
ChildDateofBirth – date.time
ChildAddress1 - text
ChildAddress2 - text
ChildAddress3 - text
ChildAddress4 - text
ChildZipCode – text
ChildContact – text (maybe the name of the parent to contact in an emergency)
ChildContactNumber – text (telephone number are text)
Etc
Etc
Etc
tblProblems
ProblemID - auto number
ChildID – link this to tblChild
ProblemCode – Number
ProbleNote - memo
In tblClasses
ClassID - Auto number
ClassLocation – text
ClassTopic – Text
ClassStart - time
ClassEnd - time
ClassNote – memo
Etc
Etc
Etc
Not you need to link all this together in tblAttendance
AttendID
ChildID
ClassID
Plus other fields that relate to this specific child in this specific class
As an example you may want to link the tblProblem here so you can see
when/where the problem occurred (do certain children has more problems at
certain times – in certain classes etc)
Once you have built your tables – come back with more questions – I am sure
some one will be able to offer advice.
But the main thing to remember is that you MUST get the table structure and
relationships right or you will have problems later on.
Last but not least – educational database are quite complex – they also need
security to protect information – are you sure you want to build one from the
start. There are many templates available that you alter which would be
quick and simpler then creating your own bespoke application – just something
to think about.
http://office.microsoft.com/en-us/templates/CT101428361033.aspx
http://office.microsoft.com/en-us/templates/CT101426031033.aspx
good luck
--
Wayne
Manchester, England.
"gooba937" wrote:
Hello. I am a teacher. I have used Filemaker Pro in the past. I am.
beginning to work with access. I am looking to create two different
databases: I may eventually create them as one. However, right now I want
to start with two.
I want a behavior database. I want to use a lee canter style format. I
would want a list of 30 students... I have 12 classes. I would want to have
the students receive strikes for misbehavior (something that I would keep
track of myself). I would want to be able to attach a note to the problem.
I currently have the 12 classes as 12 workbooks in excel. Each workbook has
30 student names. Each row has a student name, O (stand for first
consequence), B(stands for second), P(stands for third)... I would like to be
able to give more than one O or B, based on week or class. I would like to
be able to look at one student's behavior at a time. Any ideas?
I want a partner choice database. Again, 12 classes and 30 students in each
class. I would like to be able to randomly group the 30 students in each
class. I might want groups of four this time. I might want groups of two
next time. I might want to group by student learning style. I might want to
have conditions (this kid can't work with this one or this kid must work with
this one). Any ideas?
I have looked online and haven't been able to find what I am looking for...
I have also purchased several gradebook programs, but many none that I have
seen have a partner choice or behavior database.
I would also really like to be able to use the database on my PC and
PocketPC....
- Follow-Ups:
- RE: student groups, random, create more than once
- From: gooba937
- RE: student groups, random, create more than once
- From: gooba937
- RE: student groups, random, create more than once
- References:
- student groups, random, create more than once
- From: gooba937
- student groups, random, create more than once
- Prev by Date: RE: Dealing with Inventory data
- Next by Date: Email message
- Previous by thread: student groups, random, create more than once
- Next by thread: RE: student groups, random, create more than once
- Index(es):
Relevant Pages
|
