students

Hi I want to use the value of variable s in first sub and in the second sub. I do not want to ask user to enter number of students again in the second sub. I asked user to enter number of students in sub1 and assigned this value to "s". So if user enter s=10 then I need to use the same value...

Hello, I am trying to calculate the frequency how many of my students have responded in discussion boards. So first, I need to find a formula that will count the names excluding duplicates. I also want this formula to work if there are blank cells. Second, the students are all divided up between...

Hi I'm trying to put together a list of students with the worst punctuality. I couldn't find a formula so I thought I would try advanced filter. This worked great for values below 90, however, when I try to extract the top 15 with the worst punctuality the filter doesn't seem to happen. The...

The school where I teach has two Vice-Principals. All of our 7th grade students go to one or the other based on the first letter of the last name. Students with first letters of last names beginning with the range A-K go to one Vice-Principal, and the L-Z students goes to the other. How may I...

Hi, I have Data Sheet of a students, in which serial number and name of each student are given together in one cell. Is it possible to add only serial number of all? <tbody> ABC School Class VI Students 1 xxxx 2 xxxx 3 xxxx 4 xxxx 5 xxxx 6 xxxx 7 xxxx 8 xxxx 9...

So I have huge file of test data for a students from a program. The file has one column that has all of the most important data I need per student: <tbody> User_Meta <tbody>...

Hi all, I have the DOB off my students and need to work out their age on a specific date. So for example DOB: 01/01/2006 and I want to know how old they would be on 12/10/2018? Can this be done? As I have many students all different ages? Thanks

I have a worksheet that records Students and their progress through courses. Each course has some modules, each module has some Training objectives (TO), each TO has some Enabling Objectives (EO) and each EO has some Key Learning Points (KLPs). Each row starts with student name (col B), and...

Sorry if this post has been answered elsewhere, I searched but did not find the answer I need. Trying to average weighted scores. We have x1 number of students with a y1 GPA, plus x2 number of students with a y2 GPA. How do I manage to get the "total" (blended) average across the two groups...

Hello, I am trying to make excel make me a list of my students based on the day. For example: I want excel to check who is here on Monday and show me the names in a list on "F"

<tbody> <tbody> COLUMN A COLUMN B <tbody> START OF CLASSES 6-Aug-18 EMAIL OF LIST OF PROMOTED STUDENTS OR NEW STUDENTS 5-Aug-18 </tbody> </tbody> In the above example Cell...

Hi, I like to create a macro spreadsheet that can help me to automate the class allocation for my students. My tasks include the following:- 1. Open an excel file and save as another file (done) 2. Filter Group 1 students 3. Allocate them evenly in G,H,I classes 4. Filter Group 2 students with...

I have a roster of students that tracks their Group assignment (A, or B), and if they are Absent (a "Y" in the absent column). I would like to return a list of all students in Group "B" that are also Absent". I thought that the follown formula would work, but it does not. Thank you for your...

Hi everyone, I have a spreadsheet that keeps track of my students' weekly progress with an overall month summary at the end. every day they're graded on different things on a different scale. for example they're given 4 points every day for homework for a total of 20 per week or 80 a month...

I am using the following for a student roster to provide a short list of absent students. I want it to return all students that have a "Y" in the "Absent" column. How do I modify this? Thanks...

I'm trying to create a worksheet for my students to practice locating the position of a fraction on a number line I am using a scroll bar (Form control) for the students to drag the "marker" to the correct position under a number line I have a second scroll bar below that one that shows the...

Hello all, First and foremost I am not a excel wiz and just beginning. Background info: I recently have taken over an operations position of a militaryschool and I am trying to clean up the way some data is stored and presented. Currently I have been able to research and consolidate mostof the...

I'm at a loss as to what to do. I have two excel workbooks, one with a set of student identification numbers and another file with a set of student identification numbers (including the numbers from the first file, along with scores). What I would like to do is merge those two files together...

Hello, In my table of students/scores, I sometimes need to call a score from a certain date (column). For example, I use the following formula in a different (main) sheet: B2=VLOOKUP(A2,'18scores'!A:CN,50,FALSE) This works for most students, but some students don't have the entire range of...

Hello, I have a table that consists of one student per row, and the scores for each student in the same row. I'm wondering if it's possible to make a line graph such that it displays scores in time for the student in the active row. That way, I can just make one graph and visualize any...