We are paired up because the simulation and the database are directly connected in our project, so it's important for each of us to understand each other's work.
Current Pseudo Code Reference for Simulation (IGNORE)
import random
deck = [{1:["hearts", "spades", etc.]}, {2:etc.}, {3:etc.}
player_hand = [] # contains player's cards
dealer_hand = [] # contains dealer's cards
# dictionaries for each type of card and the number of a certain suit remaining after pulls
def first_hand():
sel_one = random.randint(#range of indexes in deck, not yet determined due to joker)
sel_two = random.randint(0, 4) #accounts for the four suits
d_card = deck[sel_one][sel_two]
deck[sel_one].pop([sel_two])
# repeat for player
# cards are face up
Issue will be updated in issue comments for each update to work.
Week 1 Progress: Python Simulation and Lesson Outline
Drew
Click here for my blog with the Python simulation. Instead of the pseudocode above, I decided to represent cards and decks in separate Python classes.
Click here for the current lesson outline. Its formatting will be altered to match the structure adopted by the other trio.
Sreeja
Topic: Using SQLite libraries to create a database with simulation data
Lesson objectives:
how to get the simulation data
how to create a database
use an api to connect to the project
getting the simulation data into the database
being able to extract the simulation data from the database and use frontend code to protray it in a readable format.
Order of Events
Intro: Briefly introduce SQLite and its use cases and explain the importance of databases in managing large datasets. Provide an overview of the lesson plan and the lesson objectives.
Installing SQLite: Walk students through the process of installing SQLite on their computers, and make sure everyone has it working. They should have it from last trimester because of our work for databases.
Creating a Database: Demonstrate how to create a new database using SQLite commands. Explain the basic syntax of SQLite commands and how to use them. Have them create a new database using a template.
Designing Tables: Discuss the importance of designing tables to fit the data being stored.
Provide an example schema for the simulation data, and explain the design. Have students create a new table in their database according to the schema.
Inserting Data: Demonstrate how to insert data into a table using SQLite commands.
Provide sample data for students to insert into their own tables. We can show them how to add their own data.
Querying Data: Discuss how to query data from a table using SQLite commands.
Provide examples of simple queries, such as selecting all rows or filtering by a certain condition. Have them practice querying their own data and interpreting the results.
Conclusion: Review the skills learned and the importance of databases in managing large datasets. I plan to give them a digital worksheet for this. This is just an idea, depending on the amount of time it would take it fill out.
Pair Overview
We are paired up because the simulation and the database are directly connected in our project, so it's important for each of us to understand each other's work.
Current Pseudo Code Reference for Simulation (IGNORE)
Issue will be updated in issue comments for each update to work.
Week 1 Progress: Python Simulation and Lesson Outline
Drew
Click here for my blog with the Python simulation. Instead of the pseudocode above, I decided to represent cards and decks in separate Python classes.
Click here for the current lesson outline. Its formatting will be altered to match the structure adopted by the other trio.
Sreeja
Topic: Using SQLite libraries to create a database with simulation data
Lesson objectives:
Order of Events
Intro: Briefly introduce SQLite and its use cases and explain the importance of databases in managing large datasets. Provide an overview of the lesson plan and the lesson objectives.
Installing SQLite: Walk students through the process of installing SQLite on their computers, and make sure everyone has it working. They should have it from last trimester because of our work for databases.
Creating a Database: Demonstrate how to create a new database using SQLite commands. Explain the basic syntax of SQLite commands and how to use them. Have them create a new database using a template.
Designing Tables: Discuss the importance of designing tables to fit the data being stored. Provide an example schema for the simulation data, and explain the design. Have students create a new table in their database according to the schema.
Inserting Data: Demonstrate how to insert data into a table using SQLite commands. Provide sample data for students to insert into their own tables. We can show them how to add their own data.
Querying Data: Discuss how to query data from a table using SQLite commands. Provide examples of simple queries, such as selecting all rows or filtering by a certain condition. Have them practice querying their own data and interpreting the results.
Conclusion: Review the skills learned and the importance of databases in managing large datasets. I plan to give them a digital worksheet for this. This is just an idea, depending on the amount of time it would take it fill out.