Author |
Message |
![Top of page](http://www.badweatherbikers.com/buell/icons/mark_top.gif) ![Previous message](http://www.badweatherbikers.com/buell/icons/mark_up.gif) ![Next message](http://www.badweatherbikers.com/buell/icons/mark_down.gif) ![Link to this message](http://www.badweatherbikers.com/buell/icons/link-up.gif)
U4euh
| Posted on Tuesday, September 15, 2009 - 09:08 am: |
|
Well I just started my new job as the In School Suspension instructor at a local high school. One of my jobs is to look to look at the tardy list from the previous days and make note of when one student accums 3 tardy's. This early in the year it is not a problem, but later, I'll end up looking at hundreds of sheets comparing names. Is there a program that I can enter the names as I receive them and it will tell me how many times that name is listed and give the dates if I choose to pull that info up? Thanks for any advice |
![Top of page](http://www.badweatherbikers.com/buell/icons/mark_top.gif) ![Previous message](http://www.badweatherbikers.com/buell/icons/mark_up.gif) ![Next message](http://www.badweatherbikers.com/buell/icons/mark_down.gif) ![Link to this message](http://www.badweatherbikers.com/buell/icons/link-up.gif)
P_squared
| Posted on Tuesday, September 15, 2009 - 09:42 am: |
|
You can make something from MS Access or Excel. Really, any simple database should fit your needs. The hard/labor intensive part will be the initial setup, after that, it's just putting the info in there. |
![Top of page](http://www.badweatherbikers.com/buell/icons/mark_top.gif) ![Previous message](http://www.badweatherbikers.com/buell/icons/mark_up.gif) ![Next message](http://www.badweatherbikers.com/buell/icons/mark_down.gif) ![Link to this message](http://www.badweatherbikers.com/buell/icons/link-up.gif)
Bill0351
| Posted on Tuesday, September 15, 2009 - 09:44 am: |
|
What is your school's attendance program? We have PowerSchool and you can print attendance reports and rosters using all sorts of filters. |
![Top of page](http://www.badweatherbikers.com/buell/icons/mark_top.gif) ![Previous message](http://www.badweatherbikers.com/buell/icons/mark_up.gif) ![Next message](http://www.badweatherbikers.com/buell/icons/mark_down.gif) ![Link to this message](http://www.badweatherbikers.com/buell/icons/link-up.gif)
U4euh
| Posted on Tuesday, September 15, 2009 - 10:00 am: |
|
Tried the Excel, but I still end up with a bunch of names repeated over, unless there is something I don't know. Just contacted PowerSchool and asked them the same question, thanks for that info. |
![Top of page](http://www.badweatherbikers.com/buell/icons/mark_top.gif) ![Previous message](http://www.badweatherbikers.com/buell/icons/mark_up.gif) ![Next message](http://www.badweatherbikers.com/buell/icons/mark_down.gif) ![Link to this message](http://www.badweatherbikers.com/buell/icons/link-up.gif)
Ramm
| Posted on Tuesday, September 15, 2009 - 10:29 am: |
|
Excel bro, you can get rid of duplicates in excel. And if that doesn't work make a database in Access. Tons of tutorials out there on both programs. |
![Top of page](http://www.badweatherbikers.com/buell/icons/mark_top.gif) ![Previous message](http://www.badweatherbikers.com/buell/icons/mark_up.gif) ![Next message](http://www.badweatherbikers.com/buell/icons/mark_down.gif) ![Link to this message](http://www.badweatherbikers.com/buell/icons/link-up.gif)
Froggy
| Posted on Tuesday, September 15, 2009 - 11:15 am: |
|
Yea it shouldn't be hard at all. Make the first sort alphabetically with "lastname, firstname MI". Add other columns for anything else you need like student id number, which principal they have, etc. Then use the next column to mark the day, period, class missed. Next column for the next missed class, and so on. |
![Top of page](http://www.badweatherbikers.com/buell/icons/mark_top.gif) ![Previous message](http://www.badweatherbikers.com/buell/icons/mark_up.gif) ![Next message](http://www.badweatherbikers.com/buell/icons/mark_down.gif) ![Link to this message](http://www.badweatherbikers.com/buell/icons/link-up.gif)
Jpowell490
| Posted on Tuesday, September 15, 2009 - 11:35 am: |
|
You can do it a couple of different ways, you don't need duplicate names. You do a vlookup in Excel or there is another way in Excel as well. |
![Top of page](http://www.badweatherbikers.com/buell/icons/mark_top.gif) ![Previous message](http://www.badweatherbikers.com/buell/icons/mark_up.gif) ![Next message](http://www.badweatherbikers.com/buell/icons/mark_down.gif) ![Link to this message](http://www.badweatherbikers.com/buell/icons/link-up.gif)
Bill0351
| Posted on Tuesday, September 15, 2009 - 01:22 pm: |
|
If your district is on PowerSchool, I think you need to log in on an admin account. Then go to the reports tab and click class attendance audit. It will ask what students, and then you should be able to select the students you want. |
![Top of page](http://www.badweatherbikers.com/buell/icons/mark_top.gif) ![Previous message](http://www.badweatherbikers.com/buell/icons/mark_up.gif) ![Next message](http://www.badweatherbikers.com/buell/icons/mark_down.gif) ![Link to this message](http://www.badweatherbikers.com/buell/icons/link-up.gif)
Bads1
| Posted on Tuesday, September 15, 2009 - 01:34 pm: |
|
http://www.youtube.com/watch?v=JKnL_XhC1h0&feature =related |
![Top of page](http://www.badweatherbikers.com/buell/icons/mark_top.gif) ![Previous message](http://www.badweatherbikers.com/buell/icons/mark_up.gif) ![Next message](http://www.badweatherbikers.com/buell/icons/mark_down.gif) ![Link to this message](http://www.badweatherbikers.com/buell/icons/link-up.gif)
U4euh
| Posted on Wednesday, September 16, 2009 - 08:25 am: |
|
Were on the program NCWise not PowerSchool. I guess what I explained may have been a bit misleading. I want to be able to enter the names and the program pop up and say something like " This student already entered on lines 15, 87,....etc" I have no problem with entering the names and having them listed two or three times. As it stands I am getting 20-30 names a day. this being Wed. I now have 87 names to compare and see who all is a repeat tardy. Then I have to compare these 87 to last weeks 133 names. Now project out two months and you see what I'm looking at, 1000's! |
![Top of page](http://www.badweatherbikers.com/buell/icons/mark_top.gif) ![Previous message](http://www.badweatherbikers.com/buell/icons/mark_up.gif) ![Next message](http://www.badweatherbikers.com/buell/icons/mark_down.gif) ![Link to this message](http://www.badweatherbikers.com/buell/icons/link-up.gif)
Mr_grumpy
| Posted on Wednesday, September 16, 2009 - 09:08 am: |
|
How many students? |
![Top of page](http://www.badweatherbikers.com/buell/icons/mark_top.gif) ![Previous message](http://www.badweatherbikers.com/buell/icons/mark_up.gif) ![Next message](http://www.badweatherbikers.com/buell/icons/mark_down.gif) ![Link to this message](http://www.badweatherbikers.com/buell/icons/link-up.gif)
U4euh
| Posted on Wednesday, September 16, 2009 - 11:14 am: |
|
We have 619 students in the student body. The unknown is how many Tardy names you will get on a day to day basis. |
![Top of page](http://www.badweatherbikers.com/buell/icons/mark_top.gif) ![Previous message](http://www.badweatherbikers.com/buell/icons/mark_up.gif) ![Next message](http://www.badweatherbikers.com/buell/icons/mark_down.gif) ![Link to this message](http://www.badweatherbikers.com/buell/icons/link-up.gif)
Ulywife
| Posted on Wednesday, September 16, 2009 - 11:24 am: |
|
Jim - this is pretty basic, but you can enter names and then sort...just make sure you grab all columns when you sort.
|
![Top of page](http://www.badweatherbikers.com/buell/icons/mark_top.gif) ![Previous message](http://www.badweatherbikers.com/buell/icons/mark_up.gif) ![Next message](http://www.badweatherbikers.com/buell/icons/mark_down.gif) ![Link to this message](http://www.badweatherbikers.com/buell/icons/link-up.gif)
U4euh
| Posted on Wednesday, September 16, 2009 - 02:48 pm: |
|
Thats what I'm using now using the find and replace method but it still leaves me having to search through every day to actually see how many entries one single person has. |
|