Portfolio > 1b > 2. Office Productivity > Time Log
Search this site

1. An effective teacher/instructor with skills in:
(b) Instructional management to accommodate individual variability

Time Log

1b2-1 EDUC756 Advanced Study: Office Productivity: WebCT, etc?

   Date Description Elapsed Time
  03-Jan-99 Began developing a database to hold name, email address, position, cohort, regional group for leadership participants 9:00   
  07-Feb-99 Started writing Visual Basic code for writing HTML for directory pages 9:00   
  04-Apr-99 Continued to refine the code to improve automation 9:00   
  06-Jun-99 Began work on automating maintenance of cohort and regional group listservs 9:00   
  09-May-00 Started working on "one-click" to post revised HTML directory pages for Cohorts and Regional Groups, post the text files for listserv updates, and execute Dan Bidwell's web link to refresh the cohort and regional group listservs 3:00   
  03-Sep-00 WebCT passwords are not being propagated. Work on the web and list update process to fix this. 2:30   
  03-Sep-00 WebCT passwords are not being propagated. Work on the web and list update process to fix this. 2:00   
  29-Oct-00 Automate writing of directory index include file 3:00   
  30-Oct-00 Automate writing forums.html 3:00   
  31-Oct-00 On creation of new Regional Group: . Send email to Lorena to create a new WebCT . Send email to Dan Bidwell to create a new listserv . Instruct operator to run Web & List Update . Create sub-directory for minutes 3:00   
  01-Nov-00 On creation of new Regional Group: . Send email to Lorena to create a new WebCT . Send email to Dan Bidwell to create a new listserv . Instruct operator to run Web & List Update . Create sub-directory for minutes 2:00   
  02-Nov-00 On creation of new Cohort: . Send email to Dan Bidwell to create a new listserv, and include it in LeadAll . Instruct operator to run Web && List Update 3:00   
  04-Nov-00 In copy htpasswd to \\goodloe..., check if present first, else copy to local drive 4:00   
  11-Nov-00 If a cohort or regional group has no members, still create the files and web 1:30   
  20-Nov-00 Develop a screen and code for editing or deleting minutes posted to the web 3:00   
  23-Nov-00 Develop a screen and code for editing or deleting minutes posted to the web 3:30   
Sub-section Total

69:30   

1b2-2 EDUC756 Advanced Study: Office Productivity: Leadership Database

   Date Description Elapsed Time
  07-Mar-99 Developed routines to synchronize additions and changes in Debi's Paradox database over the network; continued developing HTML routines for directory pages 9:00   
  17-Apr-00 Split data away from forms, queries & reports, making 2 databases - one with data for web server, the other with user interface for Carol 2:30   
  24-Apr-00 Set up my Leadership Web & List database with user interface components on Carol's server; showed her what it can do; asked what else it needed to do 1:30   
  24-Apr-00 Imported address and program information from Paradox tables into tables in the Leadership Access database 3:00   
  25-Apr-00 Added "Switchboard" menu, and wrote and connected forms for table maintenance, reports, and data entry 2:00   
  26-Apr-00 Started writing participant cohort and regional group index reports 2:00   
  05-May-00 Finished additional reports for Carol 3:00   
  07-May-00 Write a 3-page form for maintaining personal details, details on status in the program, & web directory info 8:00   
  08-May-00 Program database to link to networked data if available, else local data, for offline development 2:00   
  10-May-00 Start writing Roundtable registration reports - number registered with number of banquet places, registrations in courses and seminars 1:30   
  11-May-00 Continue writing Roundtable registration reports - number registered with number of banquet places, registrations in courses and seminars 1:30   
  16-May-00 Print course and seminar registrations one student per page, include ID, so the printout can be taken directly to Records Office to register students 2:00   
  19-May-00 Report cleanup - adjust field placement, correct truncated fields 3:00   
  20-May-00 Allow number of credits to include decimal places, and widen credit fields in reports 2:00   
  17-Jun-00 Added report showing those NOT Registered for Roundtable 2:00   
  24-Jun-00 Added fields and tables for Course Plan, develop the queries, start writing Course Plan Report 2:30   
  26-Jun-00 Develop Word macros and routines to import Course Plans from WordPerfect; Import 1994 Cohort 2:00   
  27-Jun-00 Develop a Course Plan report out of Access 2:00   
  27-Jun-00 Import 1995, 1996 & 1997 Cohorts 2:00   
  28-Jun-00 Import 1998, 1999 and Detroit2000 Cohorts 3:00   
  30-Jun-00 Write form for requesting Course Plan from Access by student or cohort 1:30   
  30-Jun-00 Start on form for maintaining Course Plans from Access 0:30   
  30-Jun-00 Add fields for holding semester as well as quarter credits 2:00   
  01-Jul-00 Store a hidden password in database to protect access to grades 1:30   
  02-Jul-00 Populate the fields to hold semester credits and primary credit type 3:00   
  02-Jul-00 Finished form for maintaining and Course Plans, with semester and quarter credits 2:30   
  11-Jul-00 Default new Leadership entries to Regional Group "Unknown", as the Primary group; This gets around a problem where records are reported only when they are associated with a regional group. 3:00   
  22-Aug-00 Work on Access reports for general registration 3:00   
  23-Aug-00 Work on Access reports for general registration 2:00   
  24-Aug-00 Work on Access reports for general registration 2:00   
  25-Aug-00 Create a table and a form to maintain it to hold the current year and term that is open for registration 1:00   
  25-Aug-00 Work on Access reports for general registration 3:00   
  30-Aug-00 Design a query to support registering students directly from Access (Carol has been using the web interface to do this) 3:30   
  31-Aug-00 Write the Access form for registering students. 3:00   
  01-Sep-00 Write the Access form for registering students. 3:00   
  04-Sep-00 Work on Annual Review reports - AU Credits Completed 3:00   
  04-Sep-00 Work on Annual Review reports - AU Credits Completed 4:00   
  04-Sep-00 Work on Annual Review reports - AU Credits Completed 4:00   
  05-Sep-00 Work on Annual Review reports - AU Credits Completed 1:30   
  06-Sep-00 Work on Annual Review reports - AU Credits Completed 1:30   
  07-Sep-00 Work on Annual Review reports - IDP & Core Courses 3:00   
  08-Sep-00 Work on Annual Review reports - IDP & Core Courses 4:00   
  09-Sep-00 Work on Annual Review reports - IDP & Core Courses 1:45   
  10-Sep-00 Work on Annual Review reports - IDP & Core Courses 11:30   
  11-Sep-00 Work on Annual Review reports - IDP & Core Courses 3:00   
  12-Sep-00 Work on Annual Review reports - Dissertation Credits 1:30   
  13-Sep-00 Work on Annual Review reports - Dissertation Credits 1:30   
  14-Sep-00 On 11-Jun-00, the Regional Group was made to default to "Unknown". This has been overwriting the correct Regional Group, so I reversed that change. 0:30   
  14-Sep-00 Work on Annual Review reports - Dissertation Credits 3:00   
  15-Sep-00 Work on Annual Review reports - Regional Group Meeting Attendance 5:30   
  16-Sep-00 Work on Annual Review reports - Regional Group Meeting Attendance 1:45   
  17-Sep-00 Work on Annual Review reports - Regional Group Meeting Attendance 10:30   
  25-Oct-00 Make Regional Table maintenance screen requery to fill administrator dropdown 3:00   
  26-Oct-00 Add Save button to Personal Details 3:00   
  27-Oct-00 Add Save button to Course Plans 3:00   
  28-Oct-00 On Personal Details screen, ensure that a regional group is selected, and that one and only one is chosen as Primary 3:00   
  29-Oct-00 Allow WebCT administrator to be entered on the Personal Details screen 3:00   
  29-Oct-00 Make reestablishing links to backend database smarter 3:00   
  05-Nov-00 Detect presence of network backend database at startup, and set path variables globally for the session 3:00   
  12-Nov-00 Develop a screen for recording Regional Group meeting attendance. 5:45   
  12-Nov-00 Develop a screen for recording Regional Group meeting attendance. 3:00   
  13-Nov-00 Develop a screen for recording Regional Group meeting attendance. 2:30   
  14-Nov-00 If a script terminates with an error, the global path variables lose their values. Prior to using one of these global variables, test its value, and refresh it if necessary. 3:00   
  17-Nov-00 Develop a screen and code for recording attendance of a non-member at a Regional Group Meeting 2:30   
  18-Nov-00 Develop a screen and code for recording attendance of a non-member at a Regional Group Meeting 2:30   
  18-Nov-00 Develop a screen and code for posting minutes of Regional Group meetings to the appropriate web subdirectory - Research ways of pasting and posting unformatted and formatted text. 2:00   
  19-Nov-00 Develop a screen and code for posting minutes of Regional Group meetings to the appropriate web subdirectory - Research ways of pasting and posting unformatted and formatted text. 6:30   
  19-Nov-00 Develop a screen and code for posting minutes of Regional Group meetings to the appropriate web subdirectory. 3:00   
  25-Nov-00 Work on documenting the code, cleaning up test objects that don't need to be in the system 4:00   
  26-Nov-00 Work on system documentation 7:00   
  03-Dec-00 Work on System Documentation 3:30   
  07-Dec-00 Work on System Documentation 2:30   
  21-Feb-01 Preparation and presentation to Leadership Faculty on the Leadership Tracking Database 3:30   
Sub-section Total

224:45   

1b2-3 EDUC756 Advanced Study: Office Productivity: Web Registration, Course Plan

   Date Description Elapsed Time
  16-Apr-00 Started learning about Microsoft web database application FrontPage 2000 and ASP Tutorial 9:00   
  18-Apr-00 Began extracting content for Roundtable Web from last year's WordPerfect program document; started on logon form 2:30   
  19-Apr-00 Continued learning ASP 2:30   
  20-Apr-00 Began writing entry forms in ASP, designing first in Word 2:00   
  21-Apr-00 Finished logon form and 1st data entry form - lodging, transportation, etc 3:00   
  21-Apr-00 Started design of second data entry form - courses and seminars 1:30   
  23-Apr-00 Write personal details form, and final screen for printing entered details 10:00   
  21-May-00 Revise ASP code for Registration web to work with changes in the data design 2:00   
  22-Jun-00 Add email confirmation after successful registration 2:30   
  25-Jun-00 Refined queries and data design, developed Course Plan report in Access 1:30   
  25-Jun-00 Designed report in HTML for web lookup 2:30   
  25-Jun-00 Started writing ASP code for web lookup of Course Plan 1:00   
  25-Jun-00 Finished ASP code for course lookup, started refining format 2:00   
  26-Jun-00 Further work on format and logic for Course Plan web lookup 2:00   
  29-Jun-00 Search for ways of providing improved security, to allow grades to be shown over the web 3:00   
  02-Jul-00 Search web for password methodologies, including UNIX encryption; add password checking to Course Plan Lookup 2:30   
  03-Jul-00 Worked with Dan Bidwell to get a copy of AU usernames; crypted passwords for all current leadership faculty and participants 2:30   
  03-Jul-00 Installed ASPCRYPT on my personal IIS web server, developed code to validate against UNIX passwords 3:00   
  04-Jul-00 Clean up HTML code written for on line course plan 2:30   
  05-Jul-00 Implement Course Plan with UNIX password check on SED server; ask Vaughan Nelson to install the ASPCRYPT DLL on the server 2:00   
  24-Jul-00 Extend database, queries, forms and reports to allow web registration for any term, not just Roundtable; Begin writing the web application to do this. 3:30   
  25-Jul-00 Work on ASP code for general web registration 3:00   
  26-Jul-00 Work on ASP code for general web registration 3:00   
  27-Jul-00 Work on ASP code for general web registration 3:00   
  29-Jul-00 Work on ASP code for general web registration 1:30   
Sub-section Total

73:30   

1b2-4 EDUC756 Advanced Study: Office Productivity: Training on tools

   Date Description Elapsed Time
  20-Apr-00 Document entry instructions and email planning committee requesting testing and feedback 0:30   
  21-Apr-00 Onsite with Carol, explaining features of web entry, getting suggestions for improvement 1:00   
  12-May-00 Show reports to Carol - number registered with number of banquet places, registrations in courses and seminars 1:00   
  30-May-00 Instruct Carol in use of database 0:45   
  07-Jun-00 Complete updating from Carol's machine finally works; took her through the whole email address update to posting on the web 1:00   
  18-Jun-00 Wrote email to Carol noting 6 changes/additions; questions on some data; instructions on using new Other List feature; instructions on adding new lists & new cohorts 1:00   
  30-Jun-00 Show new features to Carol; get details on handling Semester Conversion 1:00   
  12-Jul-00 Set up Office PC for Jackie to work on, register necessary ActiveX controls; Jackie needs write access to the web directory which houses the database in order to enter/modify data 1:00   
  20-Jul-00 Show Carol, Robson & Jackie how to enter Course Plans in database 1:30   
  21-Jul-00 Write manual for Vacation Tracking Database 4:00   
  22-Jul-00 Write manual for Vacation Tracking Database 2:30   
  23-Jul-00 Write manual for Vacation Tracking Database 3:30   
  29-Aug-00 Show Carol the new reports for general web registration 1:00   
  05-Sep-00 Show Carol how to maintain current year and term, and to register students via Access form 1:30   
  18-Sep-00 Show Jackie the new Annual Review Reports, and how to enter Meeting Attendance 0:30   
  18-Sep-00 Help Anna in Graduate Office to add semester credits to her databases and compute them from quarter credits 0:45   
  09-Oct-00 Documentation - started compiling different pieces of documentation I had written 3:00   
  10-Oct-00 Documentation - started developing format style for the manual 2:00   
  11-Oct-00 Documentation - develop code for documenting Access tables, queries, reports 4:00   
  12-Oct-00 Documentation - develop code for documenting Access tables, queries, reports 4:00   
  13-Oct-00 Documentation - develop code for documenting Access tables, queries, reports 6:00   
  15-Oct-00 Documentation - write User Manual 4:00   
  16-Oct-00 Documentation - develop code for documenting Access tables, queries, reports 4:30   
  17-Oct-00 Documentation - develop Word macros for documenting Access code 4:30   
  18-Oct-00 Documentation - develop Word macros for documenting Access code 4:30   
  20-Oct-00 Documentation - incorporate generated documentation into System Manual 4:30   
  24-Oct-00 Documentation - write User Manual 2:00   
  24-Nov-00 Show Carol the User Manual, what is written so far, ask for comments. 1:00   
  27-Nov-00 Demonstrate new features to Carol. 1:00   
  30-Nov-00 Incorporate Carol's comments into User Manual. 3:00   
  06-Dec-00 Demonstrate features to Carol and to Hinsdale Bernard. 0:45   
  08-Dec-00 Show Carol the User Manual online. 0:30   
Sub-section Total

71:45   

1b2-5 Vacation Tracking Database

   Date Description Elapsed Time
  05-May-97 Develop vacation tracking spreadsheet for use in ITS. 8:00   
  25-May-98 Extend the spreadsheet to roll entitlements over into new years. 8:00   
  20-Jun-00 Convert spreadsheet to a database, because the spreadsheet is too difficult to teach someone else to use. 7:00   
  16-Jul-00 Modify Vacation Tracking Database to import data from Banner 7:00   
  17-Jul-00 Modify Vacation Tracking Database to import data from Banner 3:00   
  18-Jul-00 Modify Vacation Tracking Database to import data from Banner 3:30   
  19-Jul-00 Modify Vacation Tracking Database to import data from Banner 3:00   
  20-Jul-00 Modify Vacation Tracking Database to import data from Banner 3:00   
Sub-section Total

42:30   

Total Time Spent 482:00   


Last modified: 30-May-02 11:04:15 AM
Page created with Access Basic code (written 20-Jun-2000)