Teacher's grade book (based on points) Teachers can track students' grades with this grade book template. Just enter each assignment, quiz, and test along with the. Go to Start > All Programs and open Microsoft Office Excel 2013, then, in. Here you are going to build a spreadsheet template to simulate an empty Grade book. In continuing to develop a student database based on the MS Students template in Access 2010, the next function to be developed is test score recording and Grade Point Average calculation. I would appreciate any advice and as specific direction as possible regarding how to implement this function. I have a spreadsheet that illustrates our desired functionality in great detail but did not see a way to attach to this question. Our non-profit school is a 16 week Food Service Training Academy. The 16 week classes typically start without out 50-60 students and graduate about 35 at the end of the 16 weeks. Each week there is a two part test, one part on Culinary and the 2nd about Baking. The weight of Culinary vs. Baking can vary from test to test. Similarly, the weight of each week's test on overall Grade Point Average (GPA) can vary from week to week. The tests and the weights will vary from class to class and might change during the 16 weeks. The objective is to require entry of only the Culinary and Baking scores each week and have Access compute the combined test score for the week as well as an updated GPA. The approach I've taken is to start with a spreadsheet to calculate the weekly weighting factors at the start of each 16 week class. These factors are then entered into a 'Class Parameter' table. Here are the fields for the Parameter table: Test # Description Weight Factor Cumulative Weighted Score Divisor (used for GPA Calculation) Culinary% (50%= Equal) to Baking If possible, entry of the Culinary and Baking scores each week for each student should be done in a table with a Culinary and Baking column for that week's test so that the instructor could just go down the list of students and enter the scores. Alternatively, calling up each student's record and entering is not so bad if much simpler, even if it required creating a new record for each student for each week's test. If there was a form or query or report for each student that displayed their test information, it might show the following: Test # Description% of Overall Grade Culinary Score Baking Score Culinary% Combined Score To Date/ GPA 1 Equipment I 2.22% 4 4 75.00% 4.00 4.00 2 Equipment II 2.22% 3 4 50.00% 3.50 3.75 3 Glossary I 10.00% 2 100.00% 2.00 2.54 Being new to Access and having just finished reading Access 2010 Step by Step, I am unsure of Access' capabilities to do calculations within forms and/or tables vs. Queries, or what might be the best way to do this. Some alternatives & questions I am thinking about are: Item Pros Cons Should the Test Parameter Table be 1 record for each class with sets of fields for each test, or 1 record for each test. 1 Record/Test The design information would be simpler and a form might not be necessary. 1 Record/Class Everything would be visible on a form. 1 Record/Test A query or report might be needed to calculate totals of weight factor and% entered from spreadsheet to validate correct entry. 1 Record/Class A form would need to be created. Where to store test results: In fields on the main student table. • Eliminates need for an additional table. • Might facilitate presenting a list of students for weekly test results entry. • Would require at least 32 additional fields per student record. • More limiting design. In a separate table, 1 record per student with sets of 16 test fields. • Saves space on main student record. • Might facilitate presenting a list of students for weekly test results entry. • Requires an additional table. In a separate table, 1 record per student per test. • As students drop out, no unnecessary records. • Simpler/less design information (fewer fields to define) and a datasheet might suffice. • How to display a list of all tests to-date with calculated information (see student test information table above) I am leaning to separate tables and separate records for each test for both the Test Parameters and Student Test Results. Some additional questions assuming the separate tables and records approach for both tables is taken: • Can a query present a list of students for each week's test results entry or how otherwise could that be done?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |