« Casino day game, posted late.Last project- a funky one »

Projects 2-6

  01/16/19 21:37, by Emery

These have been done for a bit, but I have not had the time to get them to the blog.

Project 2 and 3:

Throughout the quarter I have been working on expanding my knowledge of excel with John. We worked with different coding set to make the compilation and recording of data easier.

The first of these functions we looked at was the if, else function. This looked at a specific row or column and gave an answer depending on the given parameters. An example of this would be if I had three random numbers and I wanted the cell to show HI if the numbers were greater than 1. If they were less I want it to say GOODBYE. The code for the would be =(if E4<1, “HI”,“GOODBYE”). This would give the result I am looking for.

The next program we looked at is the OFFSET function. This tells the computer to go to a specific sheet and find a value in a specific cell. Let's say I have the value 37 written in cell G17 on sheet 3. The OFFSET function will go to that cell and return the value to the currently selected cell. The code would look like =OFFSET(‘sheet 3’!A1,17,7). The order of the code is the sheet the cell is one, then the starting point, the number of rows to go down, and how many columns to go over.

The OFFSET function can be modified by using the MATCH function. This can be used to get a value that you don’t know the location of. I don’t know what kind of example to give here so I will just write out a code and explain the components. A code could look like =MATCH(B19, ‘sheet 3’!H1:H1000,0). The B19 tell the computer the value it is searching for. The ‘sheet 3’ tells the sheet, H1 gives the start point for the search, and H1000 gives the end.

The last modifier we learned about was the $. If placed next to a letter or number in the MATCH or OFFSET functions it will anchor the row, column, or both.

The final program we looked at was macros. These copy your keystrokes and mouse click in the spreadsheet. Once you record a macro it can be run over and over by selecting it or entering in a shortcut. These can also be edited to include more cells or delete items for example. We did not cover the syntax or coding language for macros.    


Project 4:

My next project is much more on the simpler side. At the beginning of the class, we did coin flips and graphed them. I took a different approach to displaying my data. The x-axis is the # of Heads out of a set of 10. The y-axis is the # of times that same set of 10 was replicated out of 200 flips. It might be a bit confusing, but I felt like it was a different way of approaching the display of that data.


Project 5:

I read the opening chapters of the book Bringing Down the House by Ben Mezrich. The book is about a group of MIT students that start a BlackJack club to learn how to beat the casinos. The chapters switch between the adventures of Lewis and the author. It opens with Kevin Lewis (not his real name) playing BlackJack in a Las Vegas casino. He is getting signals from his spotter Jill. He is forced to bail when he is chased out by security. The book then switches to the author who is trying to smuggle $250,000 through airport security. Kevin has agreed to tell Mezrich about his experience with beating Sin City only if Mezrich experiences it for himself.  Back at school, Kevin is invited on a trip to Atlantic City by his roommates Fisher and Martinez. On this trip, Kevin learns about his roommate's incomes and gets a brief taste of card counting.

This book was a fun read and it lead me to pursue my final project, learning how to count cards.


Project 6:

After reading the opening of Bringing Down the House I wanted to learn how to count cards. This was much more intensive than I had pictured it being. The first part was to learn basic strategy. This is a system that says when hit, stay, double, split, or surrender. I have gotten nowhere close to memorizing this, but I am working on it. The majority of the strategies and tips I found were from a group called BlackJack Apprentice. They put out videos and articles teaching people how to count cards. After learning basic strategy I then moved to learn the common counting system. This gives cards a label 2-6 are +1, 7-9 are 0, and 10-A are -1. When the pairs are dealt you add up what's called the running count. The count changes as more cards are placed on the table. After each hand, you take your running count and divide it by the number of remaining decks. This is the true count and determines the amount being bet. The true count is recalculated with the updated running count after each hand. The running count is not reset until the deck(s) has been shuffled. To calculate you bet you take the true count and multiply it by the unit of betting you are using. If this true count becomes negative it is advised that I leave the table and return later.

After a few trials at home, I found this to be quite hard. Keeping the counts running was difficult. This is the one project I am going to pursue after this class is over.    





Comment from: [Member]

The blog is not allowing me to post my coin flip graph and Blackjack strategy chart so here they are.


Coin Flip

01/16/19 @ 21:39
Comment from: [Member]

Nice explanation of your excel knowledge!

project 2 and 3: 10/10

project 4: 8/10

project 5: 8/10

Project 6: 9/10

01/16/19 @ 22:01
Comment from: [Member]

Good job learning about excel, Emery. It seems like you enjoyed these programs.

Your coinflip project was interesting, pretty simple but not bad.

Nice job with the reading of Bringing Down the House! Since it is linked with your other project, I think it is adequate, but it would have been nice to see a bit more of a summary on it.

It’s fun seeing you play cards at lunch, and we had all better be prepared for Emery being able to rule using his card counting skills. I would like it if you could maybe do a short presentation of this in person, just to explain it to me more clearly.

01/16/19 @ 22:04
Comment from: [Member]

Also, when are you going to present about plagiarism?

01/16/19 @ 22:20
Comment from: [Member]

Project 2 and 3: 10/10

4: 7/10

#5: 9/10

#6: 10/10

01/16/19 @ 23:24
Comment from: [Member]

I give all of them,
#2 and #3 a 9/10,
#4 a 7/10,
#5 an 8/10, and
#6 a 9/10.

01/17/19 @ 09:25
Comment from: [Member]

8/10 for all

01/17/19 @ 09:31
Comment from: [Member]


01/17/19 @ 11:33
Comment from: [Member]

8/10 for all. These are all cool projects.

01/17/19 @ 14:16
Comment from: [Member]

8/10 for all. super cool!

01/17/19 @ 14:51
Comment from: [Member]

#2&3 - Really good summary. 9/10 .

#4 - 7/10

$5 - 7/10

#6 - Sounds really difficult but cool! 9/10.

01/17/19 @ 15:17
Comment from: [Member]

#2 and #3 - 9/10

#4 - 6/10

#5 - 8/10

#6 - 9/10

01/17/19 @ 16:28
Comment from: [Member]

#2&3- great job explaining this, 10/10
#4- 6/10
#5- 6/10
#6- 10/10. I know you have been interested in card counting for a while, good for you that you are learning it!

01/17/19 @ 20:09
Comment from: [Member]

#2+3: 10/10

#4: 6/10

#5: 7/10

#6: 9/10!

01/17/19 @ 22:59
Comment from: [Member]

2 and 3: 9/10

4: 7/10

5: 8/10

6: 9/10

01/17/19 @ 23:07
Comment from: [Member]

2 and 3: 10/10

4: 7/10

5: 9/10

01/17/19 @ 23:30
Comment from: [Member]

10/10 for all

01/18/19 @ 08:22

Form is loading...

August 2020
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31          


Random photo

Second Guesses

  XML Feeds

Social CMS engine

©2016 Laurel Charter School