prof-rossetti / georgetown-opim-557-201710 Goto Github PK

A student sent this question via Slack:

Please follow-up on the difference of using Range("G72").Value = OptionButton1.Caption versus Range("G69") = OptionButton1.Caption. (i.e. using .Value versus not using it) Thanks!

Student(s) have reported a different semester end date than the one reflected in the schedule. The schedule should be updated to reflect accurate information.

A student sent this message via Slack:

FYI Project 1 Prerequisites link for 'Data Quality - Validations' is broken.

The link should be fixed before the class recap email gets sent later tonight or tomorrow morning.

We didn't make it to the Intro to Information Systems lecture, so it should be added to the agenda for next class.

The raw CSV files referenced within the "Web Requests" Exercise are proving problematic to parse. Specifically, splitting them on vbNewLine does not produce the desired results.

This problem was encountered in class today and also confirmed by a student's experience over the break.

This issue was unexpected because I had previously tested the exercise without difficulty, and we had also demonstrated the ability to properly parse one of the files during the previous class.

One possible cause is when I switched the file references from pre-merge (permalink) URLs to post-merge (master branch) URLs.

I need to investigate this issue and resolve it by either uploading replacement CSV files with different new-line characters, or switching URL references, or discovering which character is being used for breaking lines in the current files and providing students with guidance on how to split a string on that character.

I have received student requests for audiovisual recordings of all class sessions. I am reaching out to the tech center about this...

Last class a student asked about the virtues of Option Explicit and I'm not satisfied with the answer I provided. So I should post an explanation and/or links to online resources.

During class today a student asked if it was possible to style message box text. I took an action item to further investigate.

I received a request for an explicit cheat-sheet on Strings. My experience working with students in class today confirms that such a reference would be helpful. It should at least include information about string concatenation, including the ampersand operator. There should be examples which illustrate the need in many cases for space characters to be hard-coded into the beginning or end of concatenated strings.

The google calendar should be publicly accessible for it to provide value to students.

I received a request for an office-hours style student support session to help students who feel they need more time and/or attention. I will look into scheduling one for this upcoming weekend.

I have received a handful of requests to post more exact grading rubrics for the projects.

To help students better see the live in-class coding demonstrations, we need to find a way to enlarge or otherwise magnify the code as it is being written.

We looked for a built-in zoom functionality of the VBA code editor window, but didn't find one.

Perhaps there is a windows-based solution to enlarge whatever is on the screen at any given time.

Otherwise perhaps there is an acceptable alternative workflow in which I would write the code in some modern text editor (one with zoom capabilities) and copy-paste into the VBA editor, but this might be too process inefficient.