student

Hi all, Uploaded a pic of what I would like help in accomplishing: http://imgur.com/9j5n7LZ Column a have teacher name, column b have student name. Each student can have more than 1 teacher. For example, adam have all 3 teacher so I list their name Mr Robinson, ms Martinez, mr orwell...

Can someone please help. I'm almost certain this code has worked fine in the past. I am a teacher and developed this tool to move students and their data from one class to another...... 'Moves a student from one set to another Sub MoveSet() DisableCalculation Application.ScreenUpdating =...

Guys, I need your help. I need a macros where I can input a value, and then will looking for a match within a sheet and when corresponding match is found, it will copy the value and it's entire row to another new sheet in which the sheets will be used for all other search. For example, there...

Good morning everyone! I have spread sheet with student grades. The grades range from 1 to 9. Each student is a group. There are 4 groups: Group 1, Group 2, Group 3 & Group 4. I have a summary sheet. I'm counting up each individual glade for each group. This works fine. Formula here...

Hi all, I have a sheet called 'Year 8'. In that sheet I have .... * 25 student names in the range B6:B107 ... each student has 4 rows allocated to them, example, student A has data from C6:AV9 * student results from C6:AV107 * Column Headings in the range B5:AV5 I'd like to have a single...

I have taken over a position for a colleague who used to do the following: One sheet has a list of examinations a student is signed up to take. Student A might have three rows for three different tests, Student B might have two rows for two different tests, Student C might have six rows for...

Hi All, I am trying to make a basic attendance for our school and would like to ask on how do I go about this; If I am to put "L" in a cell (which means Late), it will count or display it as 1 (meaning the student has incurred 1 Late). And if I am to put "LL" (meaning the student incurred two...

Hi friends I have really spend some time to come around my problem, with no succes so far. I got this data set (example) that I'd prefer not to fiddle with (all cells in row 2 is merged to 1 cell, as is row 5): <tbody> A B C D 1 Initial Name Program Admission 2 First year student...

Below I'm showing a sample of the spreadsheet I'm working with. I'm looking for a formula that answers the Answer 2 column. I've already successfully created a formula that answers Answer 1. In the Answer 1 column I capturing the column heading where the first "A" absence appears. The true...

Good Afternoon, My data is constantly updated (new rows) and i'd like to be able to average the last 3 scores (SCORE) for each Student (STUDENT) - in the example below Student A would show an average of 91, 71, 74. The issue arises when I add new data, I need this to update on the fly. This is...

Hi I have a cell that reads the student's average from another cell. I use =$B$70 and the average from the B70 cell appears here. Is there a way to have TEXT and this dynamic average appear in the same cell so the student name and THEIR average (which changes depending on how B70 changes)...

I have a sheet with student details across 7 columns and then in the 8th are their classes. The classes populate down for however many rows there are classes (different for groups of students). What I need to do is have the student details data repeated for every class they take up until the...

Hello, I was wondering if it is possible to create a macro to paste record from a form (Student ID, using Student ID Table), into a different table (main_data) and delete record? If so, how is this possible? Thank you

Lets say i have a data set with five columns with subject name for every student and need to create a program for exams. Mark A B C F Paul K C L A Jane B F D A George M N C E I need to find the best way to combine all letters so that no student has two exams the same...

Hi, Hope you can help, I've spent hours trying to figure this out! :-) I have a group students and their addresses with a postal code in one set of data. I'm trying to match them to get work experience at one of our stores based on proximity of location. BUT the students addresses wont exactly...

I am working on combining test data into one giant workbook. I have two sheets of data. I need to add the mastery values per standard for each student to my master sheet. What formula can I use to accomplish this? Any help much appreciated :) Master Sheet: <tbody> Student Name Student ID...

Hi everyone. I just registered to ask the gurus here for some help. I'm trying to make a system to record the attendance in some classes. These classes can either be in group (most common) or individual. When a student misses a individual class and attend one in a group (exceptional) in a way...

Hello All, Can any one please help me with this. Column J has the list of all students names In Column B we have to select the students name as it is data validation, list of J1 to J1000 Column C ( course name ) is the V look up so it gets auto populated column D we mention the semester number...

Hello, I have a list of c300 student IDs and 13 tutors. Please could you tell me how to randomly assign an equal (as far as possible) number of student IDs to tutors? Many thanks, Adam

I am wondering if there is a way to identify a cell in a formula by essentially calling it "the cell to the right of X" I have a table of multiple test scores from multiple people and the time it took to complete the test. For simplicity it looks like this A B C...