student

Hi from Canada! I found some very helpful formulas thus far to help simplify a very data-filled admin job. I can not seem to figure out how to get the information that I want presented and hope that someone can help. I am not as fluent in Excel as I wish to be... I have a list of close to...

Hello, I have a table which tells me which class a student is in; <tbody> Student Group1 Group2 Group3 Group4 StudentA 2 3 4 6 StudentB 3 4 1 7 StudentC 6 5 4 2 StudentD 2 3 7 1 </tbody> I would like a VBA code which; Creates a list of students in each class from the table above...

Hello, I have a table which tells me which class a student is in <colgroup><col><col span="4"></colgroup><tbody> Student Group1 Group2 Group3 Group4 StudentA 2 3 4 6 StudentB 3 4 1 7 StudentC 6 5 4 2 StudentD 2 3 7 1 </tbody> I would like to change this into a list of students in...

Hi everyone, I have a query about copying data from one sheet to another based on a range of data in a certain column. I have created an assessment grades workbook which contains a number of sheets. Each sheet represents a module on the course, and also contains a stats sheet and a cohort...

Hi there. I'm trying to find a way to do something for teachers in my school district. They would like to see testing data from several different platforms aggregated by student. The issue I'm facing is getting the Pivot Table to aggregate the scores by Student ID but show only one instance...

Hello, I have a worksheet selection change event code which is basically the same code copied 21 times with the only difference being the row number. Each row on the worksheet is for a different student. I am getting a "procedure too large" error and need to shorten the codes. The code...

Hi, I have a VBA program to mark the application no which is generated sequentially. There are multiple worksheets for different types of application. The workbook is shared to be updated by a group of people. The sequential no is a counter stored in one of the worksheet, counting no of...

Hi Guys, I'm currently at college, and on my new course, we have started a module that goes over spreadsheets. As I am very new to using spreadsheets, would it be possible if anyone could give me any guidance on completing this task? I will attach a dropbox link for you to view the question...

Hello all. I have been using mail merge for some time now. However, I think I have been doing something wrong. You can see this simple table below. So when I do a mail merge, it take the information horizontally which is perfect. Here is the issue. The last column is students. I have a...

I’m trying to track cohort survival through a training program. One issue I am struggling with is the impact of the cohort size on how that displays in the data. The course is quite demanding so there are always going to be losses. for example: cohort 1 has 100 students and at a point, 1...

Hi, I've watched numerous youtube videos on this topic but can't get my head around it. I have a list of student ID numbers in .... 'Yr 9 Hw Data'!A4:A36 ... that's a maximum of 33 student ID numbers ... I can't envisage I'd ever have a class of more than 29. I'd like to have a code that...

Hi Everyone, I'm stuck and was wondering if anyone can help. I have the students name in Column A. In Columns B, C & D is the subject choice. The student will only have one subject choice in columns B, C or D. In column "E" I want to record the subject picked. Example: A...

I have a question which says: "Refer to the "Final Marks" column (Column N) and find the student with the highest mark. Display the student name (from Column D) into the cell Q2. Answer should be in the form of VBA codes." I have managed to do this using Excel function...

Hello there, I'm attempting to use SUMIFs with dynamic rows or columns, here is a sample dataset <tbody> Score 1 Score 2 Score 3 Score 4 Score 5 Student 1 8 2 5 3 6 Student 2 6 4 4 0 3 Student 3 4 2 3 3 5 Student 4 7 2 2 3 5 Student 5 6 0 2 2 3 Student 6 6 0 5 3 6 Student 7 7...

I have a worksheet comprised of columns A, B and C. Column A is the date, column B is the student initials (which are entered AFTER they read the comments), and column C is the instructor comments. The comments in column C for each date are normally at least 2 rows however, they can be as long...

I am trying to insert an and/or argument into countifs but can't get it to work. I tried SUMPRODUCT(ISNUMBER(MATCH,RANGE,CRITERIA,0))*ISNUMBER(ETC)) Can't figure out how to do it. For example <tbody> Student A GPA SAT ACT Student B 3.0 900 21 Student C 3.4 1200 Student D 3.0 1080 25...

I have a form titled "frmHomePage" which holds three subforms. ""frmReportsSubForm", frmStudentSchedule", and frmStudentBio". When I enter a new student in the "...Bio" subform I would like to go directly to the same student in the "...Schedule" subform. To this end I have a button which hold a...

Hey everyone! New here! I'm working on a student mental health dashboard project in excel and have a high-level question about adding new 'students' that the school wants to help. Schools can have up to 1000 students, so I don't know if it's reasonable to write VBA code to create a new sheet...

I'm a business professor and use Excel heavily in all my courses. I've written several custom workbooks that automatically grade assignments (using formulas, VBA, conditional formatting, etc.), but the process is clunky. Further, since there are 50 ways to accomplish a given task, there is...

I am a teacher, summarizing ACT results. I have over a hundred students who have each taken the ACT for four years, anywhere from one to four times each year. For example, I am trying to calculate an overall average Composite score for 2017 for the following data. <tbody> A B C D E 1 2017...