in school suspension worksheet?

[Guest]

Hello,
I am trying to create something on Excel where I can enter in various
data for an In School Suspension program. What I would like to do is keep
information on each student and be able to present it...but I don't know how
to do this.

I want to record data such as student name, grade level, ethnicity, sex,
discipline issue why they were sent to my room, teacher who sent them, and
the date.

Can I, or how can I go about setting this up so I can take data out to show
which teacher sends the most students...which grade level has the most
attendance in ISS, the most common reason for being in ISS...etc. How can I
do that? I can't figure out how to do it.

Thanks
Ryan

 

[Tushar Mehta]

Start with an empty worksheet. In row 1 starting with column A put in the
desired titles such as Student Name, Grade Level, Ethnicity, Gender,...,
Date.

Save the file as whatever.

Now, enter data as needed using the first empty row. Save the file after
each time you enter data.

In the same workbook, in a seperate worksheet, create a PivotTable using the
table containing the details. You can analyze data by different fields.
Put one, say the Teacher's Name as the row field, and add the same item to
the data field. You'll immediately see the number of ISS instances by
teacher.

Put the student name as the row field and you'll see the same information by
student.

Or Grade, or gender, or ethnicity, or...

Of course, some may need further analysis. For example, just knowing the
number of instances by grade or gender or ethnicity would be meaningless
unless you also factor in the composition of the entire student body.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Ryan -

Make a table, with one column for each item you mention, and one row per
suspension. To get a nice analysis, select a cell within the table, and
choose Pivot Table Report from the Data menu. In the blank pivot table, drag
a given field (say, Grade Level) into the Row area, and drag the same field
into the data area. You will end up with a table with Grade in the first
column, and the number of items corresponding to that grade in the second.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Guest]

Thanks for your replies...Im still entering data...lots of typing and Im
trying to find time during the day to enter stuff when I can. When I creat
the pivot table...its asking me for three ranges of data...why? Id like to
just to compare two sets of data...such as seeing how many 9th graders are
sent up from the various members of staff...etc, but it always asks for
three. Ideas?

Thanks alot.

 

[Jon Peltier]

The pivot table doesn't "ask" for any data. It allows you to drag fields to
any of four areas for different views of the data. Why not describe what you
see and what you need to see.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Guest]

Good idea,
When I make a pivot table uncluding everything I want it to...it
creates the table and asks me to drag and drop from a window. The blank
pivot table includes an area that says: Drop row fields here, Drop column
fields here, drop data items here. Then in a seperate box above, there is a
place where I can Drop a page field.

What I have been doing are dropping the data I want to compare in the row
fields and column fields; but nothing happens until I place a third data item
into the 'drop data items here' box.

I figured that I should just be able to put, for example, grade level in one
area and teacher names in another and they would automatically
calculate...unless I am missing something.

Thanks for your help...I already have most of the students entered and Im
looking forward to seeing how it turns out.

 

[Tushar Mehta]

Putting something in the row field and something in the column field doesn't
tell XL what item it should include in the data field. One could pick any
column in the source table. In your case, use the teachers's name itself
and XL will include it as a 'Count of...' statistic.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[ziggystyles2]

Hello all,
Sorry its been so long. Hate to take advice and leave, but I
couldnt get on under my old name for some odd reason, pass didnt work,
tried emailing the admins...no luck there.

Anyways. I found out that all the work I was doing, i was dupicating
it as the schools #$#$#'ing computer program does the work for me and
can search for whatever information I want, compile it together and
export it into an excel file. lol...grr.

Anyways...I guess that is more acurate than what I was making anyways,
although the information looks the same pretty much...like the same
number of entries.

Now that I have compiled this into an excel file...how can I make
graphs out of it? The pivot tables are messing me up and I think excel
isnt understanding what I want it to do. I was hoping to make some
graphs, but when I try to, it doesnt resemble a graph or chart at all.

Any suggestions or ideas?

Thanks,
Ryan

 

[ziggystyles2]

Hello all,
Sorry its been so long. Hate to take advice and leave, but I
couldnt get on under my old name for some odd reason, pass didnt work,
tried emailing the admins...no luck there.

Anyways. I found out that all the work I was doing, i was dupicating
it as the schools #$#$#'ing computer program does the work for me and
can search for whatever information I want, compile it together and
export it into an excel file. lol...grr.

Anyways...I guess that is more acurate than what I was making anyways,
although the information looks the same pretty much...like the same
number of entries.

Now that I have compiled this into an excel file...how can I make
graphs out of it? The pivot tables are messing me up and I think excel
isnt understanding what I want it to do. I was hoping to make some
graphs, but when I try to, it doesnt resemble a graph or chart at all.

Any suggestions or ideas?

Thanks,
Ryan