tag:blogger.com,1999:blog-3889219616765973387Fri, 17 Feb 2012 00:18:56 +0000blackboardtechnologyactive directorysms2003chartsmathematicaexchange2003log analysisrsyncchartingsecuritygroup policysharepointdiigobigipweb2.0sqlupsnetscreenoutagesnmpvaccinefirewallsasscriptspresentations<i>A bird does not sing because she has an answer. She sings because she has a song.</i>http://corinnalo.blogspot.com/noreply@blogger.com (Corinna Lo)Blogger53125tag:blogger.com,1999:blog-3889219616765973387.post-2503004806537371687Tue, 19 Jul 2011 04:14:00 +00002011-07-21T23:21:50.377-07:00sasI need to produce a report that contains historical data of some sort based it's Tuesday snapshots in the year 2009 and 2010.  Then I found this Intnx function to help.  For example: To get a list of Tuesdays starting Jan 6, 2010 into a dataset called tuesdays: %let start_date='06jan2009'd; data tuesdays ; do i = 0 to 103;     Tuesday=put(Intnx( 'Day' , &start_date ., i*7 ),date9.);     output;http://feedproxy.google.com/~r/Corinna/~3/FwiRqrnEjeQ/date-manipulation-in-sas.htmlnoreply@blogger.com (Corinna Lo)0<img src="http://feeds.feedburner.com/~r/Corinna/~4/FwiRqrnEjeQ" height="1" width="1"/>http://corinnalo.blogspot.com/2011/07/date-manipulation-in-sas.htmltag:blogger.com,1999:blog-3889219616765973387.post-998885070542826976Sat, 09 Jul 2011 04:33:00 +00002011-07-22T23:40:55.366-07:00sasFinally got my machine rebuilt to Windows 7 64-bit, and had SAS 9.2.3 64-bit loaded.  Then I started to have problems running some SAS code to read Excel and Access files.  Error message is: ERROR: Error trying to establish connection: Unable to create Data Source.: Class not        registered ERROR: Error in the LIBNAME statement.The original SAS code for reading Excel and Access files are ashttp://feedproxy.google.com/~r/Corinna/~3/K8zjgwQNGL0/reading-excel-and-access-files-on-sas.htmlnoreply@blogger.com (Corinna Lo)2<img src="http://feeds.feedburner.com/~r/Corinna/~4/K8zjgwQNGL0" height="1" width="1"/>http://corinnalo.blogspot.com/2011/07/reading-excel-and-access-files-on-sas.htmltag:blogger.com,1999:blog-3889219616765973387.post-705452308310109764Tue, 28 Jun 2011 05:27:00 +00002011-07-21T18:59:12.192-07:00sasSuppose you want to run a query to find all records containing the pattern "REQUIRED" in a certain column, the SQL where clause will look something as follows: where thetextfield like "%REQUIRED%"But if you use it inside SAS, SAS will interpret the %REQUIRED as a macro and throw an error.  Here is how you can escape the % character: %let pattern=%nrstr(%%)REQUIRED%str(%%); proc sql; create table http://feedproxy.google.com/~r/Corinna/~3/3VSr1AjksoU/to-escape-character-in-sas-proc-sql.htmlnoreply@blogger.com (Corinna Lo)0<img src="http://feeds.feedburner.com/~r/Corinna/~4/3VSr1AjksoU" height="1" width="1"/>http://corinnalo.blogspot.com/2011/06/to-escape-character-in-sas-proc-sql.htmltag:blogger.com,1999:blog-3889219616765973387.post-780971630081991133Sat, 26 Mar 2011 04:47:00 +00002011-07-21T23:27:57.207-07:00sasI am finally able to get cumulative percentages calculated when /across is used in PROC REPORT.  Basically I have to programmatically calculate it in the code, and put the resulting value into the columns directly (such as _c4_ for column 4, _c7_ for column 7).  I contacted SAS technical support on this, and confirmed there was no way around this hard-coding of column number.  How sad! Here is http://feedproxy.google.com/~r/Corinna/~3/Ft-gNgAVQlE/calculating-cumulative-percentage-in.htmlnoreply@blogger.com (Corinna Lo)0<img src="http://feeds.feedburner.com/~r/Corinna/~4/Ft-gNgAVQlE" height="1" width="1"/>http://corinnalo.blogspot.com/2011/07/calculating-cumulative-percentage-in.htmltag:blogger.com,1999:blog-3889219616765973387.post-7873243520040038544Thu, 28 Oct 2010 03:52:00 +00002011-07-21T23:47:42.679-07:00chartingmathematicaI am trying to find a visualization to describe the distribution of our assessement data.  With a box and whisker plot, I can show the five statistical summary (minimum, maximum, first quartile, median and third quartile) in one chart.  I can create a chart for each assessment dimension, and put them side by side together. It is surprisingly easy to do it programmatically in Mathematica,  http://feedproxy.google.com/~r/Corinna/~3/Mz1QTsOndu8/mathematica-box-and-whisker-plot.htmlnoreply@blogger.com (Corinna Lo)0<img src="http://feeds.feedburner.com/~r/Corinna/~4/Mz1QTsOndu8" height="1" width="1"/>http://corinnalo.blogspot.com/2010/10/mathematica-box-and-whisker-plot.htmltag:blogger.com,1999:blog-3889219616765973387.post-973009872464305056Tue, 26 Oct 2010 05:10:00 +00002011-07-21T23:48:35.038-07:00chartingmathematicaI was trying to show correlation between two dimensions visually in an assessment project.  I didn't feel the regular plot would do enough justice since the dots that overlap only count as 1.  So I experimented in using the bubble chart in Mathematica. Here is the code: ratingpairstally = Tally[ratingpairs]; bubbledata = {}; For[i = 1, i <= Length[ratingpairstally], i++,   AppendTo[bubbledata,http://feedproxy.google.com/~r/Corinna/~3/V1tlJTXt1KQ/mathematica-bubble-chart.htmlnoreply@blogger.com (Corinna Lo)0<img src="http://feeds.feedburner.com/~r/Corinna/~4/V1tlJTXt1KQ" height="1" width="1"/>http://corinnalo.blogspot.com/2010/10/mathematica-bubble-chart.htmltag:blogger.com,1999:blog-3889219616765973387.post-8905614827541893912Mon, 07 Dec 2009 22:16:00 +00002010-12-23T09:57:59.145-08:00chartingGoogle now requires all custom gadgets to be verified by them in order they can be viewed by collaborators. Refer to the Gadgets: Verifying Custom Gadget Google docs help page for more information. I had developed a Radar Chart Google Spreadsheet Gadget a while ago. And our department have been using it to visualize the assessment data. So I better submit it to Google for verification as soon http://feedproxy.google.com/~r/Corinna/~3/3je6fBAzZ_E/radar-chart-gadget-verified-by-google.htmlnoreply@blogger.com (Corinna Lo)5<img src="http://feeds.feedburner.com/~r/Corinna/~4/3je6fBAzZ_E" height="1" width="1"/>http://corinnalo.blogspot.com/2009/12/radar-chart-gadget-verified-by-google.htmltag:blogger.com,1999:blog-3889219616765973387.post-5388785689398767393Mon, 07 Dec 2009 19:09:00 +00002009-12-09T22:53:26.648-08:00scriptschartsJust found out my Radar Chart Google Spreadsheet Gadget did not work on all popular browsers.  Guess which one?! The error message was: window.G_vmlCanvasManager is null or not an Object I swear I had verified it working on Internet Explorer before. I swear I had not made any change since. and I swear... and I swear... Apparently, there was a problem loading excanvas.js (a javascript to enable http://feedproxy.google.com/~r/Corinna/~3/IxZoOkTwV3k/internet-explorer-strikes-again.htmlnoreply@blogger.com (Corinna Lo)0<img src="http://feeds.feedburner.com/~r/Corinna/~4/IxZoOkTwV3k" height="1" width="1"/>http://corinnalo.blogspot.com/2009/12/internet-explorer-strikes-again.htmltag:blogger.com,1999:blog-3889219616765973387.post-3569919681073218282Tue, 12 May 2009 21:42:00 +00002011-07-21T21:52:11.413-07:00chartingI believe I have finished the work on creating a Radar Chart Google Spreadsheet Gadget. Here are the changes since my previous release: Added the ability to toggle individual records on and off in the chart. This allows better visual comparison between different records and/or the overall average. Added the ability to toggle the competency line on and off. Also, if user does not input a http://feedproxy.google.com/~r/Corinna/~3/0xn5qWDFIrg/finished-radar-chart-google-spreadsheet.htmlnoreply@blogger.com (Corinna Lo)4<img src="http://feeds.feedburner.com/~r/Corinna/~4/0xn5qWDFIrg" height="1" width="1"/>http://corinnalo.blogspot.com/2009/05/finished-radar-chart-google-spreadsheet.htmltag:blogger.com,1999:blog-3889219616765973387.post-1400705796095148111Tue, 05 May 2009 18:11:00 +00002009-05-05T22:52:10.901-07:00chartingThe charts and gadgets in Google spreadsheet offer a number of interesting ways to help in visualizing our assessment data. Gadgets further offer a way to present the visualization information into a web page or one's iGoogle page. However, Google spreadsheet does not have a radar chart gadget by default which is an important piece in visualizing data harvested in our transformative assessment http://feedproxy.google.com/~r/Corinna/~3/TjGds57wlIA/my-first-radar-chart-google-spreadsheet.htmlnoreply@blogger.com (Corinna Lo)2<img src="http://feeds.feedburner.com/~r/Corinna/~4/TjGds57wlIA" height="1" width="1"/>http://corinnalo.blogspot.com/2009/05/my-first-radar-chart-google-spreadsheet.htmltag:blogger.com,1999:blog-3889219616765973387.post-555122981384090227Tue, 21 Apr 2009 03:05:00 +00002009-04-22T09:40:42.683-07:00sqlblackboardA Teaching Assistant (TA) deleted all the grades in an assignment in our online learning management system, eLearning (powered by Blackboard Learning System CE). What happened was a series of actions that leaded to this. Here is what was described to me (I'm yet to be able to successfully simulate it): The TA used the grade book tool to enter the grades of all students in a particular assignment http://feedproxy.google.com/~r/Corinna/~3/xcJ1W5Z2xJQ/sql-database-point-in-time-restore-of.htmlnoreply@blogger.com (Corinna Lo)0<img src="http://feeds.feedburner.com/~r/Corinna/~4/xcJ1W5Z2xJQ" height="1" width="1"/>http://corinnalo.blogspot.com/2009/04/sql-database-point-in-time-restore-of.htmltag:blogger.com,1999:blog-3889219616765973387.post-7969381461036019507Thu, 26 Mar 2009 20:19:00 +00002009-04-11T15:47:06.613-07:00upssnmpI just finished configuring IPSentry to monitor our APC UPS (via SNMP). Currently, IPSentry will send email alerts to us when the UPS batteries need replacing, etc. But if the main power is out and the battery run time remaining is under certain threshold, it will send us alerts to our cell phones instead. We also tested using it to call a script which automate the shutdown of our servers and it http://feedproxy.google.com/~r/Corinna/~3/9n_PBQJRO5U/apc-ups-monitoring-using-snmp.htmlnoreply@blogger.com (Corinna Lo)0<img src="http://feeds.feedburner.com/~r/Corinna/~4/9n_PBQJRO5U" height="1" width="1"/>http://corinnalo.blogspot.com/2009/03/apc-ups-monitoring-using-snmp.htmltag:blogger.com,1999:blog-3889219616765973387.post-5697660903666028504Tue, 24 Mar 2009 22:32:00 +00002009-04-12T15:03:22.911-07:00blackboardIn December 2007, I wrote a script to determine the user penetration rate of eLearning, our online Learning Management System (powered by Blackboard Learning System CE6). We have subsequently upgraded the system to CE8 with all the latest service packs. Fortunately, the script continues to work.Here are the numbers for the main Pullman campus:Semester Undergraduate Students Graduate Students http://feedproxy.google.com/~r/Corinna/~3/V7UKbeOhAXU/more-elearning-user-penetration-numbers.htmlnoreply@blogger.com (Corinna Lo)0<img src="http://feeds.feedburner.com/~r/Corinna/~4/V7UKbeOhAXU" height="1" width="1"/>http://corinnalo.blogspot.com/2009/03/more-elearning-user-penetration-numbers.htmltag:blogger.com,1999:blog-3889219616765973387.post-4765960346322606387Fri, 13 Mar 2009 18:04:00 +00002009-03-25T12:20:49.614-07:00scriptsrsyncI posted an article on an issue of SQL Memory Paged Out During Large File Copy last month, which documented my effort in finding a way to solve the issue. Yes, rsync (from Cygwin) is still our final choice. Today I'm going to post some tips on using rsync on Windows.To install rsync, run the Cygwin setup.exe installer and install rsync package. After that, I would recommend adding Cygwin's bin http://feedproxy.google.com/~r/Corinna/~3/mZWCNPhBypE/using-rsync-on-windows.htmlnoreply@blogger.com (Corinna Lo)0<img src="http://feeds.feedburner.com/~r/Corinna/~4/mZWCNPhBypE" height="1" width="1"/>http://corinnalo.blogspot.com/2009/03/using-rsync-on-windows.htmltag:blogger.com,1999:blog-3889219616765973387.post-1911868239918416684Sat, 21 Feb 2009 00:38:00 +00002009-03-13T14:03:56.112-07:00diigoDiigo has a feature where you can create a "List" of bookmarks. Inside the list, you can order the bookmarks in any sequence you want, and create a slide show from it.I just created a series called The Evolution of Harvesting Grade Book. It tells the story behind some of the transformative assessment projects our department has been working on - visualized through what is currently called the "http://feedproxy.google.com/~r/Corinna/~3/VtTJNwgdPUU/web-slides-on-harvesting-grade-book.htmlnoreply@blogger.com (Corinna Lo)0<img src="http://feeds.feedburner.com/~r/Corinna/~4/VtTJNwgdPUU" height="1" width="1"/>http://corinnalo.blogspot.com/2009/02/web-slides-on-harvesting-grade-book.htmltag:blogger.com,1999:blog-3889219616765973387.post-827133443003406962Sat, 14 Feb 2009 00:41:00 +00002009-03-13T14:10:03.527-07:00sqlrsyncWe currently use SQL server maintenance plan to generate full database backup files (nightly or weekly, depending on the application), differential and transaction log backup files throughout the day. We then run a script to robocopy (from Windows Server 2003 Resource Kit Tools) the generated backup files offsite.Ever since we migrated our databases from SQL server 32-bit to 64-bit, we started http://feedproxy.google.com/~r/Corinna/~3/YHi_x_YzQmc/sql-memory-paged-out-during-large-file.htmlnoreply@blogger.com (Corinna Lo)5<img src="http://feeds.feedburner.com/~r/Corinna/~4/YHi_x_YzQmc" height="1" width="1"/>http://corinnalo.blogspot.com/2009/02/sql-memory-paged-out-during-large-file.htmltag:blogger.com,1999:blog-3889219616765973387.post-6671776525497898865Thu, 12 Feb 2009 05:54:00 +00002011-07-21T22:04:07.810-07:00sql It's brilliant. http://feedproxy.google.com/~r/Corinna/~3/FBczYn1JtWE/sql-injection-exploit-of-mom.htmlnoreply@blogger.com (Corinna Lo)0<img src="http://feeds.feedburner.com/~r/Corinna/~4/FBczYn1JtWE" height="1" width="1"/>http://corinnalo.blogspot.com/2009/02/sql-injection-exploit-of-mom.htmltag:blogger.com,1999:blog-3889219616765973387.post-6446508725776731168Thu, 12 Feb 2009 05:52:00 +00002009-04-12T15:06:10.579-07:00sqlblackboardWe need to generate a list of all courses/ sections hosted in our Learning Management System (powered by Blackboard Learning System CE8, formerly known as WebCT).In Blackboard's terminology, all courses and sections are learning contexts. They are hierarchical and their parent-child relationships along with other information are stored in the database. So, the challenge here is to figure out how http://feedproxy.google.com/~r/Corinna/~3/VwnHYI9O6zE/sql-script-to-generate-list-of-sections.htmlnoreply@blogger.com (Corinna Lo)0<img src="http://feeds.feedburner.com/~r/Corinna/~4/VwnHYI9O6zE" height="1" width="1"/>http://corinnalo.blogspot.com/2009/02/sql-script-to-generate-list-of-sections.htmltag:blogger.com,1999:blog-3889219616765973387.post-2066363367540346437Sun, 08 Feb 2009 09:26:00 +00002011-07-21T22:05:57.552-07:00chartingOur department has been working on a transformative assessment approach to teaching and learning. One of the challenges of implementing the idea is to provide rich renderings to help in conceptualizing and communicating the assessment data, one of which is in a form of what we currently called the Harvesting Grade Book (See "Rich Assessment From A Harvesting Grade Book" for more information). http://feedproxy.google.com/~r/Corinna/~3/gVvcI6g8qhc/using-google-chart-api-to-implement.htmlnoreply@blogger.com (Corinna Lo)1<img src="http://feeds.feedburner.com/~r/Corinna/~4/gVvcI6g8qhc" height="1" width="1"/>http://corinnalo.blogspot.com/2009/02/using-google-chart-api-to-implement.htmltag:blogger.com,1999:blog-3889219616765973387.post-8876773723931765032Fri, 06 Feb 2009 00:39:00 +00002009-04-12T15:02:49.017-07:00sqlblackboardI just finished a SQL query to download all grade book data from Blackboard Learning System CE8. select LC2.name as Semester, GB.learning_context_name as Section, P.source_id as StudentID, GB.user_login_name, GB.given_name, GB.family_name, GB.column_name, GB.column_type, GB.original_value, GB.override, GB.max_points, GB.final_valuefrom rpt_ext_gradebook as GBinner join rpt_person ashttp://feedproxy.google.com/~r/Corinna/~3/iGrfhFLPWlY/sql-script-to-download-grades-from.htmlnoreply@blogger.com (Corinna Lo)1<img src="http://feeds.feedburner.com/~r/Corinna/~4/iGrfhFLPWlY" height="1" width="1"/>http://corinnalo.blogspot.com/2009/02/sql-script-to-download-grades-from.htmltag:blogger.com,1999:blog-3889219616765973387.post-4696973996121151431Sat, 10 Jan 2009 07:05:00 +00002009-01-10T18:51:37.497-08:00technologyI find this BBC news Google search finds missing child interesting.  A nine-year-old girl, allegedly kidnapped by her grandmother, has been found using a mobile phone signal and Google Street View.What a creative and brilliant way of using technology.http://feedproxy.google.com/~r/Corinna/~3/jUdWd9IkD8I/google-search-finds-missing-child.htmlnoreply@blogger.com (Corinna Lo)0<img src="http://feeds.feedburner.com/~r/Corinna/~4/jUdWd9IkD8I" height="1" width="1"/>http://corinnalo.blogspot.com/2009/01/google-search-finds-missing-child.htmltag:blogger.com,1999:blog-3889219616765973387.post-6051350542941114047Wed, 31 Dec 2008 06:13:00 +00002009-04-12T15:05:34.155-07:00blackboardWe upgraded our Blackboard Learning System CE8 to Service Pack 2 level on production yesterday afternoon. After the upgrade, the Scholar powerlink was no longer working.The error message was:An error occured in the communication between your Blackboard system and Scholar.The Blackboard system clock may be incorrect.If you continue to see this error, contact your Blackboard system http://feedproxy.google.com/~r/Corinna/~3/2HYkyVr96NI/blackbooard-ce-8-sp2-upgrade-and.htmlnoreply@blogger.com (Corinna Lo)0<img src="http://feeds.feedburner.com/~r/Corinna/~4/2HYkyVr96NI" height="1" width="1"/>http://corinnalo.blogspot.com/2008/12/blackbooard-ce-8-sp2-upgrade-and.htmltag:blogger.com,1999:blog-3889219616765973387.post-2464067101216761950Sun, 21 Dec 2008 06:01:00 +00002009-01-02T22:14:33.994-08:00vaccineA friend of mine asked me for advice on whether she should give her 1-year-old daughter the MMR vaccine since there has been so much controversy about this vaccine causing autism.  I have done a lot of readings a year ago about vaccine and have created my own spreadsheet to organize what I have learned.  But I'm glad that I decided to do more searching tonight to see if there was any new http://feedproxy.google.com/~r/Corinna/~3/TJ7APCeAww0/mmr-vaccine.htmlnoreply@blogger.com (Corinna Lo)0<img src="http://feeds.feedburner.com/~r/Corinna/~4/TJ7APCeAww0" height="1" width="1"/>http://corinnalo.blogspot.com/2008/12/mmr-vaccine.htmltag:blogger.com,1999:blog-3889219616765973387.post-1863022142381013451Sat, 20 Dec 2008 22:04:00 +00002009-01-10T12:14:03.013-08:00vaccineGiven so much controversy about vaccine safety, I decided I need to do my own reading, and come up with my own decision about the vaccine schedule for my baby.My rationales are how common, and how severe the disease is, what are the ingredients contained in the vaccine and their potential side effects, whether the vaccine contains live viruses.  Also, I would try to space out all the shots, and http://feedproxy.google.com/~r/Corinna/~3/3QwmRcjYtTk/vaccine-schedule.htmlnoreply@blogger.com (Corinna Lo)0<img src="http://feeds.feedburner.com/~r/Corinna/~4/3QwmRcjYtTk" height="1" width="1"/>http://corinnalo.blogspot.com/2009/01/vaccine-schedule.htmltag:blogger.com,1999:blog-3889219616765973387.post-4979045700897347401Fri, 07 Nov 2008 05:54:00 +00002009-02-23T15:01:52.885-08:00securityI recently found Google Alerts very useful as a quick way to detect whether any of our web sites are hosting spam.  (For those who do not know, Google Alerts gives you updates of the latest relevant Google results based on your choice of query or topic. They can be in the form of email, or news feed).What I did was, I defined several search terms such as the followings in Google Alerts.viagra http://feedproxy.google.com/~r/Corinna/~3/WIzO8MAdB3A/using-google-alert-to-check-your-web.htmlnoreply@blogger.com (Corinna Lo)0<img src="http://feeds.feedburner.com/~r/Corinna/~4/WIzO8MAdB3A" height="1" width="1"/>http://corinnalo.blogspot.com/2008/11/using-google-alert-to-check-your-web.html