I'm sorry. You were going to ask me to choose, right? Did you want to finish?

Zoe ,'War Stories'


Buffistechnology 3: "Press Some Buttons, See What Happens."

Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!


DCJensen - May 17, 2008 5:09:33 am PDT #6249 of 25501
All is well that ends in pizza.

The difference is that the one I bought has another connector, should I ever upgrade to a computer that uses the new Serial ATA hard drive controllers, and has an external port.

It can also handle a module that can swap that eSATA port out with a firewire connector.

In terms of actual storage? none.


omnis_audis - May 17, 2008 9:52:57 am PDT #6250 of 25501
omnis, pursue. That's an order from a shy woman who can use M-16. - Shir

silly question here. As I've started to clean & declutter my wee lil apartment, I've determined I have an awful lot of old computer stuff. Anyone interested in:

  • SCSI external Hard drives
    * SCSI cables & terminators
    * ADB mice, keyboards, trackballs, cables
    * Apple Quadra 650 in spiffy carry case
    * Apple 5300c PPC Laptop with backpack (the bag is too small for modern laptops)
    * PowerMax Apple Clone
    * Radius 81/110 Apple Clone

Doubt it, but couldn't hurt to ask. One never knows what one collects.

That said, I'll probably take them to the haz-waste recycle center. Shame, they still work


DCJensen - May 17, 2008 10:26:28 am PDT #6251 of 25501
All is well that ends in pizza.

Omnis,

I'd probably collect the 5300 if I were near you, if only to give my mom a laptop to write letters on.

However, I may be getting some carcuses of newer dead mac laptops from a couple of people here, maybe.

Hmmm.

If you can't find takers here, you could just put the whole shebang on Craigslist for free, perhaps?


omnis_audis - May 17, 2008 11:28:34 am PDT #6252 of 25501
omnis, pursue. That's an order from a shy woman who can use M-16. - Shir

Daniel, when i get home tonight, I'll see if it boots (its been years). If you pay shipping, I'm happy to give it to you. Would you want the yamaha 2x external burner with 2 gig drive?


Connie Neil - May 17, 2008 11:41:12 am PDT #6253 of 25501
brillig

I gave a gigantic old DOS-based suitcase computer to someone here a couple of years ago. Does anyone remember that, and if so, has it been of any use to you?


Gris - May 18, 2008 7:42:27 am PDT #6254 of 25501
Hey. New board.

Hi guys. I have a tech question for the database people in the class.

Next year, I'm going to be the Data Specialist for my school. My job consists of taking ALL the data we have on our students (biographical, transcript numbers, attendance data, grade data, assessment data (in-class and external), and so forth), analyzing it, looking for patterns, and making it available in useful forms for teachers so that they can use the data in the implementation of their curriculum. Data-driven instruction is a big push in the NYC board of ed right now, and I bow to that push.

The technological end: As a major part of this, I'd like to be able to create a database of my students, kind of a super-transcript, to which I can attach and organize any data we gather.

My needs:
1) It should be easy to add new data to the database, either one student at a time or by importing Excel files. I'm willing to create programs (or at least Excel VBA macros) to make this process simpler.
2) It should be easy to export data into Excel based on a variety of categories, so that I can easily do comparisons between arbitrary data points (Attendance for this month vs. Final Grades, for example, to blow up into a big chart and be all "Look! You should come to school!")
3) I would like most of the data to be accessible online for teachers to view. Built-in web access tools would be great, though I'm willing to do some significant web programming myself if need be.

For the desktop stuff, it seems obvious that I should use Access + Excel for everything, especially since I'm already comfortable with VBA and could easily create a large variety of templates, custom reports, and macros that worked across the two, which could then be passed on to future data specialists. The only thing I'm unsure about there would be the web side. Would I have to keep a separate MySQL database on a server somewhere with the same information, for web accessibility? If so, is it easy to sync data from Access to MySQL? If not, does it make more sense to make a server-side MySQL database the primary database, and use desktop tools to pull information from it for my Excel work? Is there already stuff out there that can make all of this a lot easier, so I don't have to reinvent the wheel?


le nubian - May 18, 2008 8:02:24 am PDT #6255 of 25501
"And to be clear, I am the hell. And the high water."

Gris,

I'm not sure if this answers your question, but I think you have essentially 2 groups of needs: a) need to do broad research on educational outcomes across the students in the school; b) what information is useful to teachers for their students.

For a, I would actually use SPSS, STATA or other related statistical software for research at the school level.

For b, what kinds of things do teachers need? They may just need an excel sheet of key indicators. Maybe what you need is for them to generate their own reports (e.g. give them a web interface that allows them to select particular students and particular data points and generate tables or charts).

SPSS/STATA data can be stored as excel (you can import data into these software program from excel) and then you can run more complicated analyses - regressions, etc.


Gris - May 18, 2008 8:10:22 am PDT #6256 of 25501
Hey. New board.

For part a, thanks, I'll definitely look into SPSS and STATA for any advanced statistical analysis stuff I do, for sure. I'm not sure how much of that I'll need - really, with a maximum student population of 300 across four grades, the sample sizes aren't usually so huge as to require complicated analysis.

For part b, that's exactly the sort of thing I'd love to offer.

I guess the main question I have is, what's the best way to STORE the information so that I can get it in and out in useful ways. It seems to me a database is the best bet, but should I go the simple route for me and use Access, or look into something else in order to make your part b work better?


Jon B. - May 18, 2008 8:12:08 am PDT #6257 of 25501
A turkey in every toilet -- only in America!

There's definitely a way for Access to uhh... access SQL tables stored elsewhere. My company does that sort of thing all the time. But that's the extent of my knowledge.


Deena - May 18, 2008 8:42:25 am PDT #6258 of 25501
How are you me? You need to stop that. Only I can be me. ~Kara

Gris, you might want to research Moodle. It's an online program that is database driven and written for schools. It can be used for everything from online classes, to appointment setting, to grade management, to collaborative work amongst teachers, to various kinds of reporting and is highly customizable.