How can I analyze data in Microsoft Access 2010?

Question

For work I am creating a database using Access 2010 to track college student progress and monitor trends (for instance, which classes are presenting the most difficulty and when). My data is organized into two tables: classes and students. In the students table academic performance is noted by check boxes. So if a student did poorly in ENG 101 and received a midterm warning letter I would check off the midterm warning box next to their name, and select ENG 101 from a drop-down list that has a relationship with the courses table. Make sense?

There is definitely a link between poor academic performance and poor student retention. I'm trying to use Access to show that link, but I'm a new user and having difficulty getting the message across. Various queries work alright. I've also tried reports, pivot charts, and pivot tables to no avail.

What is the best way to show causality between academic performance and retention rates?

Answer 1

Database purists would say you need more, but I would create a 3rd table called progress that, by the relationship, links the student and the class with a %



Student(Id Number, foreign key), Course(Id Number in other table, foreign key), GradePercentage



I believe with the current setup, you'll have duplicate student records causing you headaches.

Answer 2

Working in a school, I have been involved with our student information system development.



Modeling your design before you begin is very important.



Our database system has 65000 plus students, and a multitude of tables, and retrieval mechanisms.



If you already "work" in a school I would check to see if you could obtain data from the existing data system containing student information, this would save you a boatload of data entry.



As someone else mentioned your demographic information is fairly simple



Student Table

StudentID

Name

entrance year

grad year



Class Schedule

StudentID

ClassNumber



Gradebook

StudentID

ClassID

Grade



On ad naseum..



monitoring progress for us took 3 years of design and 5 years of development with tweaks still underway.



Check out "Blackboard", "Moodle" ..



There are open source products that might save you some time in your design where you could borrow table and relationship design.

Answer 3

once you've the domicile and student version, Microsoft workplace includes: word (a word processing application) Excel (a spreadsheet application) Powerpoint (a slideshow-sort presentation application) OneNote (I nonetheless do not understand what it really is reliable for) different applications contain extra classes. merely flow the starting up menu, pick classes, pick Microsoft workplace, and then %. this technique you want to apply.