{"id":823,"date":"2013-03-25T12:56:09","date_gmt":"2013-03-25T16:56:09","guid":{"rendered":"http:\/\/blog.uvm.edu\/ctl-projects\/?p=417"},"modified":"2013-03-25T12:56:09","modified_gmt":"2013-03-25T16:56:09","slug":"enrollment-reports","status":"publish","type":"post","link":"https:\/\/blog.uvm.edu\/waw\/2013\/03\/25\/enrollment-reports\/","title":{"rendered":"Enrollment Reports"},"content":{"rendered":"

On Jan 10, 2013, at 9:50 AM, Holly Parker <hbparker@uvm.edu<\/a>> wrote:<\/p>\n

<\/em><\/p>\n

Is there a way to pull the emails for the 100+ enrollment prof. this semester ?\u00a0I got the banner spreadsheet off the registrar page but no emails are provided there.<\/em><\/p><\/blockquote>\n

I reminded her that\u00a0The process employed last April was:<\/p>\n

1) Somebody sends me the excel file
\n2) I import into special mySQL database table
\n3) after import, list available athttp:\/\/www.uvm.edu\/ctl\/development\/enrollment\/<\/a><\/p>\n

Bu then On Mar 13, 2013, at 9:15 AM, Holly Parker <hbparker@uvm.edu<\/a>> wrote:<\/p>\n

Could you please modify this script one more time to include only folks who have 99+ ACTUAL ENROLLMENT, pretty please. \ud83d\ude42<\/em><\/p><\/blockquote>\n

OK, so I did that, too. And went further, eliminating step 1 and replacing it with a direct in script file upload of the CSV file. So now Holly should be self-sufficient.<\/p>\n

But wait: along comes Wendy, who \u00a0On Mar 20, 2013, at 11:48 AM \u00a0wrote:<\/p>\n

Hi Wes, can you please run a queries for Fall 2013 Course Enrollments\u00a0(http:\/\/giraffe.uvm.edu\/~rgweb\/batch\/curr_enroll_fall.html)<\/em><\/p>\n

We need faculty emails associated with the categories listed below. The emails will be imported into Constant\u00a0Contact, so we only need email addresses – \u00a0nothing else. Please information send to Nina. Thanks!!<\/em><\/p>\n

1. courses with a maximum enrollment is 100 and greater<\/em>
\n2. courses with a maximum enrollment is between 50 – 99<\/em>
\n3. courses held in rooms w. iclicker base stations\u00a0<\/em><\/p>\n

Angell B112<\/em>
\nAngell B106<\/em>
\n…<\/em><\/p><\/blockquote>\n

Back to drawing board…<\/p>\n

Hi Wes, can you please run a queries for Fall 2013 Course Enrollments (http:\/\/giraffe.uvm.edu\/~rgweb\/batch\/curr_enroll_fall.html<\/a>)<\/em><\/p><\/blockquote>\n

Step 1: Following that link leads us to<\/p>\n

http:\/\/giraffe.uvm.edu\/~rgweb\/batch\/curr_enroll_fall.txt<\/a><\/p>\n

Download this file, and then use script to upload and refresh database. Then you can generate as many reports as you like<\/p>\n

1. courses with a maximum enrollment is 100 and greater<\/em><\/p><\/blockquote>\n

Step 2: Set Min class size 100, Max class size 1000. For fall 2013 data reported today, use Max Enrollment; for Spring 2013, use Current Enrollment. Click Run Class Size Report<\/p>\n

2. courses with a maximum enrollment is between 50 – 99<\/em><\/p><\/blockquote>\n

Step 3: Set Min class size 50, Max class size 99. For fall 2013 data reported today, use Max Enrollment; for Spring 2013, use Current Enrollment. Click Run Class Size Report<\/p>\n

3. courses held in rooms w. iclicker base stations<\/em><\/p><\/blockquote>\n

Step 4: Review rooms list, click Run Clicker Rooms Report<\/p>\n

\"Screen<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

On Jan 10, 2013, at 9:50 AM, Holly Parker <hbparker@uvm.edu> wrote: Is there a way to pull the emails for the 100+ enrollment prof. this semester ?\u00a0I got the banner spreadsheet off the registrar page but no emails are provided … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41826],"tags":[42758,647],"class_list":["post-823","post","type-post","status-publish","format-standard","hentry","category-wes","tag-boffins","tag-php"],"_links":{"self":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts\/823","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/comments?post=823"}],"version-history":[{"count":0,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts\/823\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/media?parent=823"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/categories?post=823"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/tags?post=823"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}