• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Using Excel for Middle School Classroom Management

robtking

robtking

New Member
Hey Everyone!
I am leading our school's initiative to bring Google Apps into the middle grades and had this great idea, but am getting hung up. Here is a bite of a backstory so you can see where I am coming from:
  • Each middle school 'team' has 4 sections of students. For example, mine are 609,610,611,612. We issue 'Conduct Marks' if a student acts out of conduct. The type of misconduct is irrelevant, 5 and you have a detention.
  • My Excel Document has 5 sheets, the first being a Master List, where all conduct marks are inputted by the teachers. The other 4 are for each section, as seen below:
    tyF7hd.png
My goal is for each of the section sheets to lookup the master sheet and if the section from the master list matches that sheet, copy the info over there, every occasion. Ideally, the section lists would alpha sort as well, so I could see all of little Johnny's misconducts at once if I wanted.

This might be a huge undertaking, I am not sure! I am thinking VLOOKUP might be used, but I am really hitting a wall here. Any insight is GREATLY appreciated!!

Cheers,
Robert
 
Hi Robert,

Can you upload a sample file with some data in all the sheets may be dummy data with fake names and also input the output required if user input some data.

Regards,
 
You must log in or register to reply here.
Back
Top