Recent Changes

Friday, November 21

  1. page home edited {VSS_B.jpg} [ {VSS_B.jpg} 2008 Virtual School Symposium Sunday, October 26, 2008 - Pre-Co…
    {VSS_B.jpg}[ {VSS_B.jpg}
    2008 Virtual School Symposium
    Sunday, October 26, 2008 - Pre-Conference
    (view changes)
    8:46 am

Tuesday, July 17

  1. page management edited ... Note from Kathleen Webb - Utah EHS During our discussion about how to get data out of a large…
    ...
    Note from Kathleen Webb - Utah EHS
    During our discussion about how to get data out of a large LMS systems, I talked about the 5 kinds of data that was not easy to get out our our LMS without paying money for custom solutions.
    ...
    server (7.1.467.28) andand that we're
    The SQL scripts are embedded in 5 perl scripts and generate comma-separated-values in a text file (.csv). NOTE: Our script writer had to figure out which tables and fields to use because Blackboard does not give out the schema for the tables we needed. (Their reporting tables did not contain all the information we need to make our daily decisions.) We run these five scripts each night and download the results each morning to process and make our decisions with.
    The five reports are:
    ehs_stu_act_det_rep.pl ehs_stu_act_det_rep.pl {ehs_stu_act_det_rep.pl}
    This generates a list of all enrollments in classes.
    user_id
    ...
    last_gradebook_date (manual overrides are not date stamped so these are not reflected in the data)
    total_points_in_gradebook (the number here is not always perfect because sometimes teachers use letters instead of points - but of use to track progress)
    ehs_gradebook.pl ehs_gradebook.pl ehs_gradebook.pl {ehs_gradebook.pl}
    This generates a list of entries in the gradebooks
    course_id
    ...
    attempt status (1=manual scored; 3=locked; 6=waiting for scoring; 7=auto-scored)
    attempt_date (may not be date-stamped)
    ehs_tch_act_sum_rep.pl ehs_tch_act_sum_rep.pl ehs_tch_act_sum_rep.pl {ehs_tch_act_sum_rep.pl}
    This generates a list of the past 2 weeks of log-ins by teachers
    course_name
    ...
    last_login_date
    previous_log-in dates for past 15 days
    ehs_tch_act_det_rep.pl ehs_tch_act_det_rep.pl ehs_tch_act_det_rep.pl {ehs_tch_act_det_rep.pl}
    This generates the enrollment counts for each course.
    course_name
    ...
    number of enrolled persons
    number who haven't been active for over 90 days
    ehs_stu_list_rep.pl ehs_stu_list_rep.pl {ehs_stu_list_rep.pl}
    This generates a list of all accounts
    user_id,
    last_login_date
    ...
    student_id field,
    student_email

    student_email
    field,
    our

    our
    custom school field,
    our custom district field,
    We import these files into custom Filemaker Pro database tables with relationships set up with other data files. From these tables we then can generate these kinds of action files:
    (view changes)
    11:04 am

Saturday, June 23

Sunday, March 4

Wednesday, July 13

Thursday, January 13

Friday, November 12

  1. page live edited ... -7 hours) Check the World Clock Monday, October 27, 2008 ... 4:15 – 5:15 pm Breakout S…
    ...
    -7 hours)
    Check the World Clock
    Monday, October 27, 2008
    ...
    4:15 – 5:15 pm Breakout Session #4
    Evaluation in K-12 Online Learning: Lessons from the Field - Tom Clark, Cathy Cavanaugh, Brian Lekender & Mickey Revenaugh
    ...
    Michael Barbour)
    Case Study: How Can a Small School District Finance an Online High School? - Rob Darrow
    Elluminate Recording of this workshop: - https://sas.elluminate.com/site/external/jwsdetect/playback.jnlp?psid=2008-10-27.1705.M.3B5E18E30853223653E862D06F3921.vcr (provided by Rob Darrow)
    (view changes)
    5:44 am

Wednesday, July 14

Friday, September 11

  1. 2:02 pm

More