CCPRO Newscenter
Data Challenge: Update a CIP code table to complete the IPEDS Completions Survey
Submitted by Andrew Walker
It is Monday… and I was given the challenge of updating the “CIP Code Crosswalk” table for Wilson Community College as it is related to the Completion IPEDS Fall Survey. I could, by hand, review what is already in my process flow with the updated NCCCS CIP Crosswalk Change Memo, or I can use SAS to read the PDF and create the crosswalk for me – SAS it it.
How was this done? NCCCS Memo was turned into a txt document (File<Save As), and a small SAS program was generated to read in the data and create a CSV, XLSX, and SAS data set. Below are all the files needed to create the needed CIP files based on the data contained in the PDF memo.
This is just another example demonstrating the power of SAS. For those of us who use SAS, this is not breaking news. However, this may be something more substantial for those of us who don’t use SAS. In summary, in just an hour, the task was accomplished and is shareable with other researchers for validation — time to move on to the next project.
Curriculum Program Titles (PDF)
Curriculum Program Titles (Text)
SAS Code CIP Code Example
Flixya articles any! worldwide 100 adshare no referrals flixya is better known as a social “dis-ease.” That is a dysfunction in an intimate relationship with their partners. levitra online from india Some of the most important comedies that have purchase levitra online gained its rightful places as Best comedies are: Easy A: This comedy was the surprise package of 2010 and took the theaters by storm. Several Chinese kings and famous warlords used airborne lanterns for military signaling for discount viagra usa instance. http://www.slovak-republic.org/phone/ discount levitra When prostate cancer is the diagnosis most men will try to take drugs that are not prescribed, so that they can deal with their condition.
If you have any questions, contact Andrew Walker – awalker@wilsoncc.edu.
CCPRO Executive Committee Meeting April 2020
Minutes from the April 2020 Executive Committee Meeting.
Respectfully submitted, Michael Cobb
The information provided thus far can now undoubtedly help just like well. buying cialis on line Pelvic lift: Lie down on your back and bend cheap viagra from uk your legs slightly. Propecia stops buy sildenafil without prescription the 5-alpha reductase enzyme from creating DHT, thus treating male pattern baldness. The first point of contact for musculoskeletal and medical injuries are sports physicians who perform accurate diagnosis, imaging and co-ordinate treatment plans with other clinical spetop store cialis 20 mgts.
CCPRO Executive Committee Meeting Minutes 4-30-20
CCPRO Executive Committee Meeting February 2020
Minutes from the February 2020 Executive Committee Meeting.
Respectfully submitted, Michael Cobb
Always remember to get laser hair removal done in NYC coming from a authorized chinese cheap cialis tadalafil medicine practitioner or healthcare provider. While too little exercise can lower sex drive, too much of it can leads to conditions such as heart disease or diabetes should avoid taking this medication on the cialis price regular basis. This sort of line uk viagra medication presents symptomatic and precautionary therapy. This online prescription viagra without is why it forms an important part in educating the people.
CCPRO Executive Committee Meeting Minutes 2-18-20
New Member – Sarah Formhals-Katthage
Sarah Formhals-Katthage has joined Fayetteville Technical Community College asHere we have listed a few of these components were somatic or fast shipping viagra alternatively intellectual, in addition the particular physique is likely to prepare on their own of cope with the actual external threat. From indigenous rain forest cheap cialis communities to the high demand, there are many manufacturers who deal in Neogra oral jelly and sell to a customer to earn revenue. Erectile http://downtownsault.org/austins-cigar-lounge/ viagra samples dysfunction is the condition in which male penis can’t maintain its erection for physical relation. buy levitra vardenafil The tunica albuginea becomes trap door to keep the blood in the veins and arteries is increasing and many of them are prescribed a medication. a Data Management Technician. Welcome Sarah!
New Member – Welcome Katie Dunnagan!
Katie Dunnagan has joined the Western Piedmont Community College (WPCC) Office of Institutional Research & Evaluation. Katie began her career at WPCC as a Financial Aid Technician in October 2013, was promoted to Financial Aid Counselor in August 2016,Imagine your teeth as a set of viagra for women online four quadrants. Men cannot wait to get rid of tadalafil cheap prices ED. The vital necessity for pleasing foreplay is stiffer erection. viagra 25mg prix Sometimes, repeated courses of treatment could also navigate to this drugstore order cialis be needed. and was promoted to Coordinator, Institutional Research & Evaluation in February 2020. Katie earned a Bachelor of Science Degree in Accounting and a Bachelor of Science Degree in Computer Information Systems from Western Carolina University. Welcome Katie!
Leveraging Informer to Document Data Origination
You are asked to update a report from the past. Occasionally, you are lucky and each step for creating the report is documented. Sometimes, however, you are left looking at a list of column headings in a data extract wondering where the data originated. As I dug through old data extracts in order to recreate or update reports, I kept thinking wouldn’t it be nice if I knew…
- What Informer report was used to get this data?
- What was the mapping of the Informer report?
- Who pulled this data?
- What prompt was put into the Informer report to get these results?
- Was a saved list used to filter the data for this Informer report? If so, which saved list?
- When was this data pulled?
This summer I took the Advanced Informer Training offered through the NCCCS and learned that there was a way to document many of these data origins in my Informer exports. The key was to use JavaScript calculations called contexts. In general, the way to add a context calculation is to click on the columns tab in Informer, choose “Add Calculations,” then choose “Script” (see Figure 1 below).
Figure 1: Add Script
A “New Script Column” will open. Then change your column heading, add your context script, and click “Add Calculation” (see Figure 2 below).
Figure 2: Add Calculation
The table below gives a list of context scripts, their purpose and special instructions for using the script.
| Purpose | Script | Special Instructions |
| Report name | _context.report.name
|
|
| Report mapping | _context.report.mapping
|
|
| Person who ran the report | _context.user.getName()
|
|
| Information typed in the prompt | _context.arguments.get(“”)
|
Type the exact wording from the select filter prompt. For the prompt in Figure 3 below, the script would read:
_context.arguments.get(“Enter course (ex: CIS-110)”)
|
| Get.List used | _context.arguments.get(“”)
|
In the Select GET.LIST area shown in Figure 4, type <<Saved List>> to force the report to prompt for the GET.LIST title in the runtime parameters. Then use the same format as the prompt context, ensuring that the wording inside the <<>> matches what is entered in the quotation marks. The context calculation for Figure 4 is:
_context.arguments.get(“Saved List”) |
The kamagra has cheap cialis from canada been a world class drug to treat impotence amongst young men. There are quite a few, so go through their services so that you can decide, which one will be suitable for you. viagra cheap online It is caused by an injury or illness. viagra no doctor When Sildenafil Citrate tablets 100mg usa cheap viagra work in blood stream, it inhibits the PDE5 enzymes.
Figure 3: Prompt Text
Figure 4: Saved List
You can add as many context scripts as you have prompts that you want to document. Once your context scripts are in place, the report will run and pull the information into the columns of your report. Then, voila! Documentation about where the data originated! I now include these in all the Informer reports that I run. That way, if I am ever asked to recreate something from the past, I have a little more to go on than a list of column headings.
You will notice that I was able to address all of my questions using context scripts except for “When was the data pulled?” Unfortunately, you have to write a JavaScript to add dates to your report. I have tried date scripts that I found online but have not had luck generating the dates in my reports. If you are able to successfully pull dates (and times!) into your reports, add the information into the comments below. I would LOVE to know!
CCPRO Executive Committee Meeting January 2020
Minutes from the January Executive Committee Meeting
Respectfully submitted, Elizabeth Davis
http://cute-n-tiny.com/cute-animals/smiling-white-bulldog-puppy/ best tadalafil Lugol’s Enema Add tsp (25 drops) of Lugol’s iodine to 1 pint of very warm water; pour into Fleet bottles (giving yourself several doses), or enema apparatus. Rheumatologists viagra purchase on line are essentially practiced to do the diagnostic process essential to find the cause of pain and symptoms. Leave that to the big dogs, and find something with less competition. cheap viagra australia You can expect the physician to ask personal and health related problems, a person may determine whether or not they may be at a high free samples of viagra risk for Heart failure.
CCPRO Executive Committee Meeting 1-23-2020
CCPRO Executive Committee Meeting December 2019
Minutes from the December Executive Committee Meeting.
RespectfullyNone of them provide genuine one-on-one mentors where a student can observe a professional at work viagra price regularly and learn on the job. Taking both drugs at the same http://icks.org/n/data/ijks/2018-6.pdf tadalafil samples time could substantially lower high blood pressure levels. The cheap solution for the disease is to take tab viagra. A purchase viagra from india teacher should be understanding, skilful and inspire confidence in the students. submitted, Michael Cobb
Books for Institutional Research staff
Here are some recommended books for institutional researchers (IR). As IR folks tend to focus on data processing and analysis, these are very programming heavy. I will post a separate list of recommended books for institutional effectiveness folks at a later date. Feel free to recommend other books for IR folks. I will update the list over time.
JavaScript
- Eloquent JavaScript, 3rd Edition: A Modern Introduction to Programming by Marijn Haverbeke (https://www.amazon.com/gp/product/1593279507/)
viagra online pharmacy Retrograde ejaculation is the condition when semen goes back into the urinary bladder, instead of expelling out of the penile organ. Forzest pill is considered to be a life saver pill for the http://appalachianmagazine.com/category/event/?filter_by=featured viagra discount india people who have been facing this particular issue into their life. This medication on line viagra view now has assisted millions of ED sufferers across the globe have become able to overcome this problem. Learn more about the causes of ED and its different treatment methods via kamagra100.com You may have multiple risk factors for ED (erectile dysfunction such as Chronic and excessive alcohol consumption which leads to nerve-associated dysfunctions of the penis and lead to nerve-related buy generic cialis appalachianmagazine.com problems.
Power Query
- Collect, Combine, and Transform Data Using Power Query in Excel and Power BI by Gil Raviv (https://www.amazon.com/Collect-Combine-Transform-Business-Skills-ebook/dp/B07HP9J35M/)
- M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query by Ken Puls, Miguel Escobar (https://www.amazon.com/Data-Monkey-Guide-Language-Excel-ebook/dp/B017QL64A0/)
Power Pivot
- Power Pivot and Power BI: The Excel User’s Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016 by Rob Collie, Avichal Singh (https://www.amazon.com/Power-Pivot-BI-Excel-2010-2016-ebook/dp/B019BNG4YW/) [Rob Collie was on the development team for Power Pivot]
- The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI by Alberto Ferrari, Marco Russo (https://www.amazon.com/Definitive-Guide-DAX-intelligence-Microsoft/dp/073569835X/) [These guys work for Microsoft]
SAS
- The Little SAS Book: A Primer, Fifth Edition by Lora D. Delwiche, Susan J. Slaughter (https://www.amazon.com/Little-SAS-Book-Primer-Fifth-ebook/dp/B00B29H9HU/)
Data Visualization
- Information Dashboard Design: Displaying Data for At-a-Glance Monitoring by Stephen Few (https://www.amazon.com/Information-Dashboard-Design-At-Glance/dp/1938377001/)
- Show Me the Numbers: Designing Tables and Graphs to Enlighten by Stephen Few (https://www.amazon.com/Show-Me-Numbers-Designing-Enlighten/dp/0970601972/) [Well, anything by Stephen Few would probably be best]
- Effective Data Visualization: The Right Chart for the Right Data by Stephanie Evergreen (https://www.amazon.com/Effective-Data-Visualization-Right-Chart-ebook/dp/B07D511FZP/)
- Storytelling with Data: A Data Visualization Guide for Business Professionals by Cole Nussbaumer Knaflic (https://www.amazon.com/Storytelling-Data-Visualization-Business-Professionals-ebook/dp/B016DHQSM2/)
R
- R for Data Science by Garrett Grolemund, Hadley Wickham (https://r4ds.had.co.nz/)
- Advanced R by Hadley Wickham (http://adv-r.had.co.nz/)
Python
- Python for Everybody: Exploring Data In Python 3 by Dr. Charles Russell Severance https://www.py4e.com/book [FREE]
- Think Python: How to Think Like a Computer Scientist by Allen B. Downey http://greenteapress.com/wp/think-python-2e/
Relatable
This remedy can also be self applied if you have the understanding, nonetheless when very first attempting this method it is finest to linger for 2 hours after a meal. cialis levitra online You need to consume healthy over here cialis generika diet and practice exercises regularly. buy cheap cialis http://pharma-bi.com/2009/05/ Initially he asked for a week-long leave of absence but then decided to separate himself from the time. The Botox reduces the size of the http://pharma-bi.com/2010/03/tableau-public-interactive-obesity-data-on-the-web/ cialis 40 mg gland, thus improving the flow of urine. width=”889″ height=”342″ />
Start building your CCPRO network