Fill Template with student Grades

[EODAndy]

Hello,

I was wondering if it were possible to fill a template that I have with individual student grades. I have the template that gets hand written but is it possible to enter a students last name and the grades auto fill into the template one at a time for review? also is it possible to input grades and it fill in the appropriate area on my spreadsheet?

there are 8 tests (1 per row) that are taken with the template being date taken, attempt, version, and grade in respective columns A-D

 

[alansidman]

Simple answer is Yes. Without seeing what you have and the criteria you have set, no further help can be offered as your request is to general.

 

[EODAndy]

on the template; column A is labeled with the respective dates the tests were taken. B is the exam name, C is the Attempt # (only 2 per test), D is the version they took, and E is there grade.
each row has the spaces to input data for each attempt, row 2 has exam 1's first attempt followed by row 3 is the second attempt at exam 1. this is duplicated for the other 7 exams that they will take. there is admin data with the students name at the very bottom.

would I be able to enter a students name and there respective data populate? if I entered data would I be able recall the data at a later time?

 

[alansidman]

would I be able to enter a students name and there respective data populate? if I entered data would I be able recall the data at a later time?

Only if it is already stored in a sheet in your workbook. Then you could use formulas like Vlookup or Index/Match to retrieve the static data.

for tutorials on those go to www.techonthenet.com There is an index of formulas. Look for the those

 

[EODAndy]

I have a work book that I record passing grades in. the workbook has the first row labeled as such; name exam 1, exam 2, and so on. The followingrows after has the students with their grades under each exam. After adding thedate taken, attempt, version, and grade for each exam. How would I be able to specifya certain row to populate? Is it possible to populate data like a mail merge inword? Where I enter a students name in the admin data portion?

 

[alansidman]

If you are looking to fill in a form and then have Excel place it in the next row, you will either need to do with VBA and a customized form or use an Excel created form. If you are willing to use an Excel created form, then look at this link.

https://www.myexcelonline.com/blog/create-data-entry-form-excel/

If you require a VBA solution, then identify all the fields needed to complete the form. And so on is not a option here, we need to know the specific number of exams for this to work.

BTW: If i were to do this, I would normalize the data in this manner
Data Range[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]

Name​

[/TD]
[TD]

Date​

[/TD]
[TD]

Exam Nr​

[/TD]
[TD]

Grade​

[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

John​

[/TD]
[TD]

3/15/18​

[/TD]
[TD]

1​

[/TD]
[TD]

90​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

Jim​

[/TD]
[TD]

3/15/18​

[/TD]
[TD]

1​

[/TD]
[TD]

85​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

Mary​

[/TD]
[TD]

3/15/18​

[/TD]
[TD]

1​

[/TD]
[TD]

89​

[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]

John​

[/TD]
[TD]

4/10/18​

[/TD]
[TD]

2​

[/TD]
[TD]

95​

[/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]

Jim​

[/TD]
[TD]

4/10/18​

[/TD]
[TD]

2​

[/TD]
[TD]

95​

[/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD]

Mary​

[/TD]
[TD]

4/10/2018​

[/TD]
[TD]

2​

[/TD]
[TD]

85​

[/TD]
[/TR]
</tbody>[/TABLE]

In this manner, you can filter by date, or by student or do averages, etc.