Class+Workspace

=Class Workspace= This is where the work for each class will be posted online!

Semester 1 Class Workspace

We're moving on! Today, we will: 0. Read through this Bitesize and take the test: @http://www.bbc.co.uk/schools/gcsebitesize/ict/databases/0datainforev1.shtml 1. Discuss - "What is data?" 2. Review what you know about spreadsheets - [] 3. Discuss spreadsheets together as a class 4. Start our first Spreadsheet Assignment!
 * January 17, 2013 **

**January 21, 2013**
0. You have 5 minutes to read the Bitesize about Spreadsheets (you do not have to do the activity). 1. We will take a vote as to whether to play Jeopardy or take the Test Bite. 2. We will work on the Spreadsheet Schedule Assignment!

January 23, 2013
1. We will start the Spreadsheet Schedule Assignment! 2. If you finish, you may start Formulas, formulas.

January 31, 2013
1. Work on Formulas, formulas. 2. Work on the [|Salary Assignment]

February 6, 2013
1. We will start with the M&M's assignment. 2. When you are done recording your own data and making a graph for your data, keep working on Formulas, formulas. If you are not done, it is homework. 3. Work on the Salary Assignment. 4. If you are done, you need to practice typing as we will have a typing test coming soon!

February 8, 2013
1. We will start by going over Formulas, formulas together. 2. We will finish up the M&M's activity by working with the data. Milk chocolate here and peanuts here. 3. If you are finished with the M&M's data activity, you need to complete the [|Salary Assignment]. 4. If you are done the salary assignment, you may work on the Data Management and Spreadsheets activity

February 18, 2013
1. We started with typing practice. 2. You need to work on the Data Management and Spreadsheets activity.

February 20, 2013
1. We will start with a typing test on either typingtest.com and logos.typingclub.com. Record your results at bit.ly/logos-typing 2. Work on the Data Management and Spreadsheets activity. 3. Done? Work on the Exploring Data assignment.

March 4, 2013
1. Practice Quiz. 2. Finish questions about Reflections in a Digital Mirror. 3. Try @http://color.method.ac

March 6, 2013
1. Quiz. 2. You need to find the answers to these questions: -Visit the website @http://www.operationworld.org/ -What is Operation World? -Pick a country and take a look at it's page. What kinds of information can you find on that page? -Why do you think a resource like Operation World is important for supporting prayer ministries around the world? 3. Take a look at: @http://www.bbc.co.uk/schools/gcsebitesize/ict/databases/2databasesrev1.shtml Yep, we're going to learn about Databases! You need to make notes (in Google Docs) about the following terms: -table -record -field -key Then try the Test Bite (after the last page).

March 13, 2013
1. We will talk about Operation World and make up some questions to ask our guest interviewee! 2. We will work through the BiteSize questions from above. 3. It's pretty common that in international schools kids move on at the end of the year. It would be great to be able to have a database of all of your contacts - friends and teachers from school and other places in Cambodia (or maybe other places in the world). Make a simple table to keep track of people you know (don't worry, you don't have to record all of the people you know!) Make at least 5 tuples (records). You should be able to answer these questions: The fields are ... (list the fields) Here is an example of one tuple... I could link this to another table containing information about...

March 15, 2013 1. Submit your questions about OW here: @https://docs.google.com/forms/d/1N9rOAfi3F9aa_SO2nZX7MX3BDVp4wonoCQVar4JHJeo/viewform 2. We will talk about databases. 3. We will finish up by updating our friend databases.

March 18, 2013 1. We will take up the quiz on spreadsheets. 2. We will talk about Relational Databases. 3. We will look at @http://sv001/phpmyadmin/

March 21, 2013

1. Submit your ridiculous medical condition: @https://docs.google.com/forms/d/1ioV3jwu3nCOtkDWDaWsXhZeP64j36KJp-YDisW2fQuE/viewform 2. Head over to @http://sv001/phpmyadmin/ First, try to answer these questions (make a Google Document) 1. How many Koreans are there in the student database? 2. Is there anyone who's birthday is on Christmas? 3. Who is the youngest student in the database? 4. How many Kim's are there in the database? 5. What is the most popular language spoken at home (according to the database)? 6. What are the different types of data in the student table? (This may take some poking around to discover).

3. Read about SQL here: @http://www.w3schools.com/sql/default.asp (this is also a good tutorial as we go along) We will do some queries together as a class. There is a query builder in phpMyAdmin under Search.

March 25, 2013 1. We'll talk about types of data in fields 2. Finish answer these questions just using phpMyAdmin @http://sv001/phpmyadmin/ 1. How many Koreans are there in the student database? 2. Is there anyone who's birthday is on Christmas? 3. Who is the youngest student in the database? 4. How many Kim's are there in the database? 5. What is the most popular language spoken at home (according to the database)? 6. What are the different types of data in the student table? (This may take some poking around to discover).

3. Try this quiz about Google: [] (It's a bit old, but you can still try it out!) 4. Done? Practice typing until others finish the questions. We will watch a piece of Inside the Mind of Google if everyone finishes.

March 27, 2013 1. We will start by working on a Blockly Turtle picture for a few minutes. 2. We will watch a bit more of the Mind of Google.

April 8, 2013 1. We will finish up SQL part 1. When you are done, try this: [] 2. We will work on SQL Part 2. This is probably where we will finish off!

April 10, 2013 1. We will review SQL Part 1. You should be done by now. 2. Try: [] 3. We will work on SQL Part 2. This is probably where we will finish off SQL. 4. If you are done, try something new: @http://www.codecademy.com/tracks/web (You can sign in with your Google account.)