teacher

Dear friends . Im the HOD in a college having given the task of preparing an invigilation scheme for the forthcoming exams. i prepared a sheet and in cells A1 to A12 I insert the time. 8.15 - 9.00, 9.00-9.35,.. representing the invigilation schedule for each teacher. now in cells B1 to B7 I...

Hello I have a table similar to the one below: <tbody> English Teacher English Teacher Target English Teacher Assessment Maths Teacher Maths Teacher Target Maths Teacher Assessment Science Teacher Science Teacher Target Science Teacher Assessment a b b- e d d i s s+ b d b f s d+ j m m-...

Any help is much appreciated. I apologize if it's hard to follow. I initially wrote it up in an excel attachment, but it looks like I can't attach workbooks to the thread. :( Please let me know if I can clarify. Thank you! Data Collection: Three separate teachers each surveyed their 12...

My excel sheets has the schedule of all the students in my school. The schedule has the following fields. Please see the sample for one student below: <tbody> A B C D E G H I J K L M N O P 1 Counselor Grade Ident Student Name Period Course Title Teacher Room Ident Student Name Period Course...

It’s been 10 years since I’ve last used Access so I’m one of those folks hoping an experienced user can quickly build me the basic database and I can take it from there. My students have to do practical experiments. For each student, I have to record whether..... <tbody> Comp 1 Comp 2 Comp 3...

I have a set up data where I need to filter by teacher and get a count of scores above a certain threshold. Please help! I use the following formula for school data =COUNTIF(A2:A201,">9") I need to be able to get that same count when I filter by teacher A or B. COUNTIF is not allowed with...

Hi all. Just to say, before I seek your advice - I am completely self-taught on Excel and can handle the basic formulas etc, so please excuse me, if I'm not using the most appropriate process or formulas in devising my workbooks etc. I devised a spreadsheet for my wife, who works with...

I have a workbook which about 10 teachers will want to access, quite often at the same time. Currently, only one teacher can access the workbook at the one time. I've only just heard about 'shared workbooks', so here's my question ... If teacher A only needs to add data to rows (let's say) 6...

I'm a teacher, and I really enjoy finding efficient solutions for some of the tasks that my job requires. I had an idea about how I might be able to efficiently produce student reports, and need some help in working out how to do it. I'm relatively new to Excel, but am keen to learn. I'm...

I am trying to do something that I have no idea how to approach with Excel. I want to assign a value to a text string. Actually, i want to assign a formula to a text string, which will be used in another formula. If a student hands in a homework late, then I want to type an "L" as his grade...

I am a teacher and I set up a tool to take exported student test responses and turn them into a table with "offset". I have set up macros for everything but selecting the number of questions to copy. "Shift + arrow" takes me to the end of the record (of 50) but most test have less than that...

Hello, welcome and nice board you have here. i have used it a bit but this is the first time i needed to ask a question. my question: I have this formula: =(IF(SUM(G22:AG22),ROUND(SUM(G22:AG22)/$G$19,2),"")) which was made from a gradebook template that i am using for my girlfriend but the...