Today was the final day of my third block of the summer. In the morning today I worked on my dice roller database project and set it so that the results of the dice rolls, along with the position and the roller's id, would be sent to the database in Sequel Pro. I also updated the aesthetics of my website so that it looks and functions better. At 11:00, the three apprentices for whom this is the last block (Chris, Gustavo, and Divya) gave presentations on their favorite projects from the past blocks. They all did wonderful jobs. After lunch, a guest speaker came. When he finished, I continued to work on my website and updated the HTML and CSS of my portfolio page to match the look of my home page. I also began to work through my dynamic blog page and update the aesthetics to match my home page as well. I didn't completely finish with this but it looks more cohesive as a whole already.
Today in the afternoon Rene Daughtry, the Lead Project Manager at Cisco, came to speak to us. His presentation lasted an hour and a half and covered a variety of topics related to the professional environment and work at Cisco. He began by talking briefly about a number of network-related terms and concepts and how the internet has evolved over the decades from simple routers connecting two nodes over a limited region to a vast IoT, or Internet of Things. He then expanded on information about the professional environment and ways that we can present ourselves to make sure that we come off well to potential employers. He had a question and answer session where he discussed the technical definition of a robot, a summer volunteer program offered with Cisco, and how schools or potential employers will look into your web profiles, among a variety of other topics.
In the morning today I reviewed the video recorded on Tuesday of last week where Ernie went over how to use inner joins to display information from multiple tables in conjunction in Sequel Pro, using the relational database I built yesterday. I then completed the second day of my MySQL Syntax Guide, which was the end of the project, using the relational database. I worked on my dice roller database project, which uses PHP to load user inputs into SQL. I went through the W3Schools tutorial on incorporating SQL into PHP. I made this work smoothly with my dice roller project to the point where it uploaded the first name, last name, favorite color, and shoe size that a user input to my database, and displayed the information on the screen. After lunch, I worked on my website for my first block project, and finished both the agent model and system model section. I also made updates to my Vensim model for that project. I had to leave at 3:00 today for an appointment.
In the morning today I reviewed the video recorded on Tuesday of last week where Ernie went over how to use Atom to write SQL for the table creation of the relational database that he previously showed us how to create. I followed along with this and built a relational database in Sequel Pro that linked the 'id' field from one table to different fields on other tables. In the afternoon, I revisited one of the projects from the first block, the main project where we had to build a webpage to showcase two models that we had built to simulate a scenario of our choice. During the first block, due to only coming for half of the day, I was unable to finish my website. I worked on it today and am planning to build a dynamic webpage using PHP for it. I also created a dynamic webpage for my blogs that utilizes PHP to load different sections of my blogs.
I was feeling much better today, luckily, and was able to return to Shodor and make it through a full day. In the morning, I began working on my MySQL syntax guide, and finished the first section of it. I worked with a People table generated from information about Shodor staff, interns, and apprentices, including first name, last name, favorite color, shoe size, and the results of a coin flip. Using this table, I learned about the operation of MySQL and how to retrieve, count, sum, and average values from a table using it. In the afternoon, I reviewed the video recorded on the first day of last week where Ernie went over how to create an E-R diagram, and created one for my dice roll database project.
Today was the first day of my third block of the summer. I was unable to attend last week, the first week of this block, due to a prior commitment, but I will be attending this week and both weeks of the last block. In the morning today I reviewed the video recorded on the first day of last week where Ernie went over databases and MySQL and began to work on the Sequel Pro work. I left at 11:30 today because I came down with something earlier this week and felt very tired today. I hope to be able to sleep it off tonight and return tomorrow and be fully functional for the rest of the week.