Project: Secure Email

 Link: http://www.processor.com/editorial/article.asp?article=articles%2Fp3017%2F13p17%2F13p17.asp

The Boston Medical Center in Boston Massachusetts needed to secure the emails that were sent out for being compliant with HIPAA regulations. The usability of the new system was the main concern. Many people worked there that weren't tech savvy or were too busy to learn a new system. They wanted to secure the emails that were sent out because they contained very personal information and they were not encrypted.
They ended up hiring Voltage security SecureMail because it didn't need training, infrastructure changes or help desk support.

Database Project

Thanks to this project i learned many things about databases. This was my first experience ever with databases. I learned some features of Microsoft Access, like creating queries, reports and forms! Maybe this was just basic stuff, but it's really useful if we want to start learning it now by ourselves!

For extending this database we could add more information to the Members Table. Also we could create a query in which we extract only the members who has not resigned, and then create a Report in which we show them by city so we could appreciate the situation TODAY.

Here i show you a little of what i did:

Good Bye!

Presentation Project

For this Presentation Project we had to choose a topic from the following:
-Entrepreneurial Idea
-A case from the Times100
-Non-Profit Organization
-Own Adventure

I chose the non profit organization topic, and decided to talk about a project i did with some friends in Chile for our Entrepreneurship class.
We had to help a city of Chile that was affected by the earthquake of February 27th, 2010.
For the presentation i tried to show the importance of this project and the impact it had( we involved more than 600 people).
My main problem with the presentation was my lack of english proficiency on speaking, but i still tried to do my best.
This presentation project was good for making me practice to speak more well in English and to practice on doing effective presentations.
Before this, i used to fill the slides with a lot of information, thinking that that was better, but now i know that not everyone is like me and many prefer more simple slides and just want to listen to the person who is speaking, and the text distracts them.

I must admit though that i dont like too much presentations, but its something that i will have to confront sooner or later, so it was better to deal with this now.

I used CamStudio for recording the video and audio of the presentation. Also i used Powerpoint, the most common presentation tool around the Windows environment.

I enojoyed watching the presentations of other people, some where really good i must say! From using the rubric i could focus on a topic and watch the presentation again, and you could realize some very itneresting things! For example when you just watch it for pleasure you arent as critique as if you are thinking how is he doing in a certain aspect. When i watched for the third time a presentation i could notice the stuttering and before i never noticed it!!
Criticizing the presentation of another peer helped me notice how superficial i watch lectures or presentations, never putting attention on the HOW they do it, its like before i was just a receiver now I'm an Analyzer.

All this will come handy if you get to work in an area where you need to do presentations. I hope when i get to work that i don't have to do so many presentations, they are tough!


Now i look forward for the Database Project!! I always wanted to learn about databases. Now im in programming courses ISM3254 and ISM3255. In ISM3255 we will also see something about databases so it will be a lot of fun.

GO GATORS!

My Presentation:
http://www.youtube.com/watch?v=KEJPKVR7FLs

Excel Project

This was the first Project i had to do for my ISM3004 Class. After watching several lectures introducing me to Excel and some of its advanced features i had to get my feet wet and experience a practical project. This project was about a Gymnasium that had measured and gathered information about its clients, specifically their age, gender and their heart rate. The owner of this Fitness Center hired us for helping her analyze the data mentioned.
The first part of this project was purely visual and very simple, we had to organize the data , bold some texts, center them and reshape them.
Later on we had to start using certain in built functions of Excel to do the task we were told to do. For example we were asked to search for the Highest Heart Rate of every customer. To do so, we used a very simple but powerful function named LARGE.
Moreover, we also had to use conditional statements in this project, the same that you use in programming. We had to use them for Printing out Yes or No in a cell depending if the client had accomplished the Target Heart Rate.
Furthermore, we could experience with relative and absolut addresing and mixing them both. We used this when we had to calculate the target Heart Rate using a constant percentage value of the Maximum Heart Rate.

Finally after gathering all that information we had to use the famous pivot tables to help us analize the data and count it all up. We had to do two pivot tables one which counted all the people by gender who could accomplish the target heart rate and the ones who did not. The other pivot table had to calculate the average heart rate increase from the beginning of the workout and when it finishes.


Here is a screen capture of my "AvgIncrease" Pivot Table:

GO GATORS!!