VBA Reflection

NOTE: All of these are in my Z-drive

1. What macros did you create in VB?

With the time I had, I created a Months macro that enters the months of the year in a column (and edited it), a Message macro that makes a message box appear with the words “Hello World!”, a NameWorksheets macro that renames the first three worksheets in a workbook “2011”, “2012”, and “2013”, another naming macro that renames worksheets with the data in the A1 cell of every sheet (which I edited to include an If...Then condition to check if the value in cell A1 is empty, two comments that detail what’s going on, and a declaration for the variable I use to represent the worksheets), and a ChartExample macro that makes a chart appear with the data in a worksheet, and I also edited its style and type.

2. What challenges did you encounter?

This was refreshingly easy after a few increasingly challenging VB units, and the lessons were very simple to follow and well-paced. So instead of comprehension issues, most of my challenges came from technical problems, like when my first macro (Months) did not save correctly and kept calling up a workbook titled “Book1” instead of the correct “Sales.”    

3. How did you solve them?  Be specific

When it comes to solving technical problems, if the issue itself is not super clear (i.e. something is obviously misnamed or code was typed in incorrectly), it becomes a case of guess and check and trying different things. Going back to the Months issue I mentioned, I redid the entire macro, paying attention to saving everything correctly, and the second time around it worked fine.

Unit 8 Reflection

Creating one and two dimensional arrays

I only really got a chance to do one-dimensional arrays, and I think I got a good grasp of them.

Using array parameters

Simple, I definitely got this.

Passing array arguments

I think I understood this, but I’m not sure of the name of this concept so I may be thinking of something else.

Applying search arguments

Also understood this and could apply it to a program, if I had gotten that far.

Understanding dynamic arrays

Looking over this in the packet, I have a grasp of this concept.

Using structures and structure arrays

Understand this.

Declaring enumerated type

Don’t think we got to this?

Using control objects as array elements

Don’t think we got to this?

Unit 7 Reflection

Math Class(abs, sign, sqrt)  - This is super easy and the concept I feel most comfortable with from this unit.

IsNumeric - At first I was unsure about this, but now I’ve got it.

PMt - I understand this.

PV - I’m not sure what this is.

FV business functions  - I understand this.

formatting numeric output - This is quite simple, I get this.

sin(angle), cos(angle), tan(angle) - I did not get a chance to get to this, so I would have liked to learn more about it.

Unit 6 Reflection

1. Writing Sub procedures for specific tasks

I feel somewhat comfortable with this: I understand what this is used for and how to use sub procedures, the only thing that sometimes trips me up is the syntax and when you write ByVal versus ByRef.

2. Adding Images(Pet store)

Very comfortable with this- it’s not totally intuitive or user-friendly, but very simple once you get the hang of it.

3. Passing data to a procedure(Guessing Game)

Somewhat comfortable: I think this links back to my uncertainty with when data is passed by value and when it is passed by reference.

4. Using reference parameters(NumberBreakdown)

Very comfortable: Only at the end of the unit did this really click.

5. Creating event handlers to handle multiple events(Shell Game)

Not very comfortable: I am still uncertain about this.

6. Writing function procedures(Letter Grade)

Somewhat comfortable: I am confused by the difference between sub and function procedures, and why use one over the other, but I do understand how to use function procedures.

Day of Dialogue Reflection

What did you know about the issues discussed  prior to the assembly? What did you learn at the assembly(assemblies)Make sure you focus on the topic of our block but feel free to add to it with anything learned at other assemblies.  What surprised you?  Other thoughts? What can you do to help?  What can Mrs S do to help?

Having been to at least one Day of Dialogue assembly every year for the past three years, I generally already know a lot about the issues that are discussed, but in the case of the assembly we went to see, I went in a bit blind. I knew transgender and gay people face a lot of discrimination around the world, but it was extremely powerful to be able to hear about specific cases. The most surprising speaker was the man from Uganda, because I had never heard someone describe such horrifying experiences. In most cases, coming out stories end with acceptance, or an ongoing tension between someone and their family, not potential arrest. It really hit me that the speaker has not seen his daughter for years, simply because he is persecuted for his sexuality. I am very happy that the GSA club decided to include international perspectives, because I think we can often become close-minded within the Brookline/US bubble, not only in terms of LGBTQ issues, but issues of gender and race as well. Because this is such a touchy and personal issue, I don’t think teachers need to get particularly involved apart from making students feel accepted no matter what their sexuality or gender expression (for example: using proper pronouns).