Office Ethics Project

In this assignment, I had to come up with a solution to a scenario in a regular office environment. In summary, the scenario talked about how there was a conflict in the workplace in which people were not doing their part in a project which would earn the company a 19 million dollar foundation. The scenario described how each person on my team worked, and what the main issues were within my team. Based on my own experiences as well as professionalism, I had to draw up a solution for this workplace-type conflict.

CLICK HERE to see the whole scenario.

Cats and Dogs + Dominant/Recessive Models

In this project, I made a slider bar for the amount of cats there were. With this, I set an absolute number of dogs that cannot be changed, as well as a cell that shows the total number of cats and dogs I have. The slider bar is used to change the number of cats, which would change the total at the end. Also, I made an equation to model the chance for getting a dominant or recessive gene, which essentially models 50/50 chances. With this, I compared the experimental and conditional probabilities of the two occurences and found out that as you execute the command/equation more, the conditional probability and experimental probability become about the same. In general, I modeled the likelihood of a child inheriting a dominant or recessive trait from their parents.

Square Root of x+7.316 + Diffusion Models

For this, I inserted a formula for the square root of the value in one cell plus 7.316, and the value that I refer to in the formula uses the value in the cell with the formula. Like this, I created a circular reference, so the values get closer and closer to each other as the formula is calculated more and more. Using this knowledge, I created a hot to cold diffusion model using conditional formatting, in which circular references were placed all over an area in the spreadsheet, and the formulas were calculated to make it seem like heat was diffusing from one side of the spreadsheet area to the other. I placed 50s on one side of the spreadsheet, which were affiliated with the color red, and 0s were everywhere else, which was the color blue. As the formula was repeatedly calculated, I could see the gradient of red to blue going from left to right on the spreadsheet.

Simple Population with Birth Rate Slider Model

This model shows the total population of a place. The population starts at 2 in the very beginning, and the user can control the birth rate with the slider given in the Excel model to increase or decrease the population over a period of time. Competition is also a factor in this model, as it limits the growth of the pouplation, so it does not continuously grow exponentially. This model is a direct representation of the equation "HAVE = HAD + CHANGE" because you can get the current population by changing what the population was before. Lastly, the change in the population per unit of time is proportional to the population itself.

Rabbits with Competition Model

This model, which shows the population of rabbits with the added factor of population, is very similar to the above model regarding simple population with the birth rate slider. With this model, you can control the birth fraction over a unit of time of the population of rabbits. Also you can adjust the amount of competition in the ecosystem that this certain rabbit population lives in, so the population does not exponentially grow forever. Lastly there is a graph included with this model which visually shows the population of rabbits over time, which is measured in months. Vensim is required to run this model. CLICK HERE to download Vensim.

Durham Population Model

This model shows the population of the city of Durhan, which is located in central North Carolina. In this model, the intial population starts at around 267,000 people. The user can adjust the amount of people moving per unit of time with the slider bar, which is located under the arrow under the rate hourglass, which is named "people moving". This model also models "HAVE = HAD + CHANGE" as we can find the current population of Durham by using what the population was before and adding in the change, which is the number of people moving into Durham. Lastly, there is a graph which visually shows the population of Durham over time. Vensim is required to run this model. CLICK HERE to download Vensim.

Temperature Model

This is a simple model which shows the change in temperature over a period of time, measured in hours. The initial temperature is 100 degrees Fahrenheit. The rate of temperature change can be varied with the slider bar under the variable "rate of temperature change". As the rate of change increases, the temperature decreases over a certain period of time. This model represents the equation "HAVE = HAD + CHANGE" because we can find the current temperature by using what the temperature was beforehand and applying the change in temperature. Vensim is required to run this model. CLICK HERE to download Vensim.

Fermium 252 Model

This is a model that shows the exponential decay of Fermium-252 over a period of time measured in hours. The rate of decay is fixed, resulting in the complete decay of Fermium-252 occuring in about 7 hours. This model represents "HAVE = HAD + CHANGE" because we can find the current amount of Fermium by using the amount of Fermium beforehand and applying any change in the amount. Vensim is required to run this model. CLICK HERE to download Vensim.

Rabbits Carrying Capacity Model

This is a model that shows the population of rabbits with the limiting factors of competition as well as carrying capacity. The carrying capacity and competition can be adjusted, as well as the birth fractions so the user can identify the carrying capacity in which the population will be equal to another population with competition. For example, a 500 carrying capacity with a 0.5 birth fraction would have the same graph and population as another rabbit population with a compeition with 0.002 and the same birth fraction. The competition graph is in blue while the carrying capacity graph is in red. Vensim is required to run this model. CLICK HERE to download Vensim.

AgentCubes Disease Model

This is a simple model of disease progression in a population. If a healthy person is next to a sick person, there is a percent chance that the healthy person changes into a sick person. Healthy people more randomly in the world. Sick people move randomly in the world, but slower. The doctor, controlled by the user, heals a sick person it is adjacent to. The doctor changes a sick person into a healthy person. The counter counts how many sick and healthy people there are in the world, and reproduces a line graph showing the changes in the populations.

Fast Food Project (Group Project 1)

This whole project shows all information related to any kind of Fast Food restaurant, including what goes on inside the restaurant, as well as what happens "behind the curtains" with all the wages, employees and food supply. The hypothesis was that if a restaurant is economically thriving, then there would be more people going through and eating food from the restaurant. We expected our system model to project a restaurant's economic stability over time, assuming that they make good business. We expected our agent model to do something slightly different, and simulate how the outside of a restaurant would function over a period of time, in terms of what goes on with customers and consumers. These models are extremely useful in seeing and projecting a fast food' restaurant's activity.