473,327 Members | 1,976 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Student Coursework - Grading System

Hi, I am a first time poster here. I have been given an assignment to do
from college and it is ot create a student gradebook. I have planned all the
tables etc. to what I believe to be correct. I have also set the
relationships etc.

I have three tables here that are causing the most problems. These are:

Students - contains information on students
Assignments - this is the actual work the students should be doing
Results - These are the results of the assignments (there are three fields:
result id, student and assignment)

The biggest problem I am having is trying to create a form that actually
looks like a teachers' gradebook. For example assignments aligned
horizontally across the top and the students names vertically aligned on
the left with the results matching in a gridlike section between. I hope
that make sense to you... I was thinking that the assignments FORM could
have a sub form on it which lists the students and one text box where I can
input the grade for that assignment. Is this possible?

Louis
Nov 13 '05 #1
1 6351
> input the grade for that assignment. Is this possible?

Yes, it is possible.

Access is not inherently 2-dimensional, like a spreadsheet,
so making forms with 2 data dimensions is more work.

Instead, Access is inherently list-oriented and multi-dimensional,
so it is easier to build systems with 3+ data dimensions. The
harder stuff is easier, but the easy stuff is harder, when compared
to a spreadsheet.

There is NO GOOD EASY WAY to do a general student gradebook in Access.

Three of the choices you have are: (1) Pretend it's a spreadsheet.
Create a table with Assignment ID as field names. (2) Use extensive
VBA to reformat a form to get the assignment and student ID's onto
a form that looks like a spreadsheet, and allows data entry, or
(3) Use a separate data entry form and data display form.

Since this is a student project, let's assume that you want method
(3), with minimum work. So: For data display, use a CROSSTAB QUERY.

For data entry, use an separate form, with no connection to the
display. Force the user to select student and assignment from a
drop down list, or some other method. Just write the data into
the results table.

(david)
"Louis" <lo***@NOSPAMplatt1985.fsnet.co.uk> wrote in message
news:c9**********@newsg1.svr.pol.co.uk...
Hi, I am a first time poster here. I have been given an assignment to do
from college and it is ot create a student gradebook. I have planned all the tables etc. to what I believe to be correct. I have also set the
relationships etc.

I have three tables here that are causing the most problems. These are:

Students - contains information on students
Assignments - this is the actual work the students should be doing
Results - These are the results of the assignments (there are three fields: result id, student and assignment)

The biggest problem I am having is trying to create a form that actually
looks like a teachers' gradebook. For example assignments aligned
horizontally across the top and the students names vertically aligned on
the left with the results matching in a gridlike section between. I hope
that make sense to you... I was thinking that the assignments FORM could
have a sub form on it which lists the students and one text box where I can input the grade for that assignment. Is this possible?

Louis

Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: C.E.O. Gargantua | last post by:
http://blog.seattlepi.nwsource.com/microsoft/ Featured in the blog: Grading Bill Gates Charles Cooper, CNet News.com executive editor, assesses the performance of Bill Gates as the company's...
8
by: ChrisMac | last post by:
Greetings, I have a database that keeps track of students grades (and lots of other info)for a non-profit training center. I have created an access database to track all of the student's...
0
by: chilli | last post by:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'load Dim objconn As New...
17
by: Brian Blais | last post by:
Hello, I have a couple of classes where I teach introductory programming using Python. What I would love to have is for the students to go through a lot of very small programs, to learn the...
15
by: MissHex | last post by:
Hello everyone, am building a housing system and i want to be able to seach the data base for empty rooms then assign no more than 2 students in each room i have a table Student that contains...
9
by: Grimmjow04 | last post by:
first of all, im a beginner with this thing.. turbo C,, my prof gave us a homework: we must do a grading system consist of: format>>> Grading System Enter your name:
31
by: Warly girl | last post by:
Hi i have a qustion plz help me to understand and solve it Phase One Problem description You are required to implement a student registration system. The system keeps information about the...
2
by: JKChan | last post by:
Hi, I'm an A2 ICT student in second year of college right now and I am working on my database project as my coursework. Its about a dance school with 4 tables Student, Class, Teacher and Enrolment. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.