Thursday, July 18, 2013

Excel

Spreadsheets for charting, graphing, and data collection.


How did it work out?

What was your purpose for using it?

Hypothesize on how you could expand its use?

Respond to someone else who has used Excel or a similar spreadsheet program.

17 comments:

  1. I use Excel to log parent contacts that are made via telephone. I have one spreadsheet with separate pages for each student. I use three columns: date, who contacted, and conversation to track calls I make to parents and visa versa. Then at the end of the year, I can put each student’s page into their file on our server. It helps me remember when I visit with parents and what we discussed.
    As for students using Excel, they have all learned the program through the required computer technology course, but it doesn’t seem to fit a need they currently have.

    ReplyDelete
    Replies
    1. Nice use of keeping track of calling parents. It would help keep that information handy and can be easily shared.

      Delete
    2. I really like this idea, Jerrie! A good way to keep track of the information.

      Delete
    3. I've never used Excel to keep track of parent contacts, but I think I need to! The inside of my kids' files are just filled up with sticky notes, haha! I like your idea WAY better =)

      Delete
    4. What a great idea! I'm like Brittany...I use sticky notes all over the place (my computer, my notebook, student files, etc). :)

      Delete
  2. We have students sign up for different sites during the last 30 minutes of the day. Once the students sign up the lists are typed up using excel. I also use excel to keep track of inventory. For me every time I use it has worked out well. I think it would be a great way to keep track of data. I will have to try it out.

    ReplyDelete
  3. I don't use Excel very much during the school year. I do use it at the beginning of the year to make my schedules for the para's and students. I like that you can color code the columns!

    ReplyDelete
  4. I use Excel to make my para and student schedules at the beginning of the year. I too, love the color coding feature. I also use Excel to keep track of our food budget at the school. My students and para's use Excel when they complete their timesheets. Personally I use it to keep track of budgets/finances at home.

    ReplyDelete
    Replies
    1. I use it to keep track of home finances too! My fiancé thinks I'm a little crazy, a little obsessive/compulsive, and a little whatever else, but it sure comes in handy when we're trying to budget for stuff! P.S.~ I'll have to let him know I'm not the only 'crazy' person out there who does this, haha! ;-)

      Delete
  5. I use Excel to keep track of my initial and three year reevaluations for the school year, as well as transfer students.
    The column headings I use are: Reason/student name/town/grade/consent/routing/web/nom/stu.test/due/staff date/psych.medicaid log/ipad sent/web sent.
    I color code items completed then completely color the whole row when I am done with a particular student.

    It definitely keeps me in compliance with all the evals/transfers, etc.
    LeNnis Ward

    ReplyDelete
  6. Mary Schreck
    I use Excel to create my three week plot point charts for my IEP charting. These are created, printed off and given to the inclusive support staff as well as for my use in the resource room.
    They have the student name, and goal area(s) as well as the chart items (N / Y). These charts are collected at the end of the three week period for compilation and IEP updates.

    I also make my para schedule / student assignments at the beginning of the fall term.

    ReplyDelete
  7. I use exel for many things. we use it to track our students (as a whole school leadership team) to track where students are and how they move from tier to tier.

    I use it for a grade sheet with students before putting it in grade book easier to add and change grade with corrections

    I also use it to keep track of para and student schedules.

    ReplyDelete
  8. I use Excel for making a large schedule for my staff and myself. I also use it for keeping data like MLU for students who are working on social skills. Also using a check-list for letter recognition, letter sounds, and sight words to keep a running record.

    ReplyDelete
  9. I use the color coding conditional formatting option in Excel when preparing testing data for teachers. You can sort by high to low score in each area and color code needs in a couple clicks. It relatively easy too to line up one years data to the next and match student names so you can see individual progress and compare it to the rate of progress for peers.

    ReplyDelete
  10. I don’t use Excel too much, but I do make a chart at the beginning of every year so I can keep track of all of the evaluations I need to complete and any related, important dates (i.e. when they’re due, when the staffing was held, when parents received paperwork, etc.). Who KNOWS what would happen if I ever lost that!!! I’ll also use it occasionally to make graphs of students’ progress/testing results when I think it might be easier for parents, teachers, etc. to understand, rather than just rattling off a bunch of data.

    ReplyDelete
  11. I have used Excel in the past to make schedules and such, but I am much more comfortable making tables in Word. I can do basic things in Excel, like schedules and lists, but the really advanced "stuff", I'm just not that comfortable using Excel. I think that if I took the time to really learn all of the things it can do, I would love it! :)

    ReplyDelete