Internet Safety 2 days left! Alice programming introduction

There are 2 days left to work on (in class) your Internet Safety project.  Tomorrow is the last day you will be allowed to work on it and it should be done by the end of the hour.

If you are done you are going to begin working on Alice - an Educational software program that teaches you computer programming in a 3D environment.  To use Alice, go to Finder on your computer.  Next, double click on the Alice folder.  Then, double click on the icon labeled Alice - you will need to agree to any user agreements.

Once you have opened Alice come back here and go to the following video and watch an introduction on how you will interact with the Alice interface.

Alice introductory video

Once you have watched that video you will begin working in Alice with Oracle Academy.  You will work through a series of Lessons that will help you to better understand how Alice works and how to manipulate the Alice programming environment.  Here is where you need to go:

Oracle Academy

Once at that website, click on "Get Started with Alice 3" under the red rectangle on the left side of the page (the red rectangle says "Self Study: Getting started with Java using Alice").  Work through each of the sections of that lesson - if you complete all of the sections move to the next lesson ("Add and Position Objects"); if you complete the different sections of that lesson move on the next lesson, and so on.

We will be using Alice often in the last quarter - you will be getting a head start on learning the software.

Read More..

Learn Z and colon left shift R4 vocab definitions due tonight!

If you have not completed FA1 and emailed it to me then you need to get that done ASAP at the beginning of class.  If you have already completed FA1 and it has been emailed to me then you need to go to the Free Typing Game website and complete a couple of the speed tests.  Choose test #8.  These do not need to be written on the poster on the wall - just practice to see how well you can do.

Today we will learn the last letter (yay!) on the keyboard - the Z (L4); in addition we will also be learning the colon (Left Shift + R4).

Just a quick reminder for those who are responsible for vocab definitions for week 3 - your definitions must be posted to the Wikispaces page by tonight.

Read More..

Modem video review learn left shift and period

We have a couple of housekeeping items to begin with today:

1. Make up times for classwork include: before school (except Wednesdays when I have morning duty), lunch recess, Study Hall (for those not in Band or Choir), or after school (until 3:30).  Plan accordingly if you need to use one of these times.
2. Assessments - if you tell me when you come in the room it makes leaving for the assessment much less a distraction.  Then, when it is time for you to leave you can just quietly get up and go, and Ill know why you are leaving (you wont have to raise your hand and interrupt whatever were doing - you can just go).

The below video will help to explain what a modem is (a modem is one of the vocab words for this week...if its your vocab word and you think you need to change the definition after watching the video then you can change it when you get home tonight).

We will start with a review of all the keys weve learned, but todays review will be a little different from what weve done in the past.  Youll need to think of a word that has at least 4 letters in it that we can type from all the letters we know on the keyboard - Ill explain the rest in class.

When we get done with this we will learn the left shift key (L4) and the period (R3).

Read More..

Vocabulary Google reminders new seating chart Learn Left Shift Key and period

At the beginning of the hour we will move to our new seats.

Once at your new seats you can log into your Google account.  We are going to look at how the vocabulary for class works.  This involves using information that is on the class blog and setting up reminders in your Google account (Ill show you how to do this today).  We have our first vocab quiz next week, so some of you will need to get definitions right away.  The only thing we wont be able to go over today is how to use Wikispaces, the website we will use to post definitions on.  We will cover how to do that tomorrow.

After going through the vocabulary information we will learn 2 new keys; however, todays keys are not letters.  Instead we will learn the Left Shift key (L4) and the period (R3).

Read More..

Wikispaces account Learn Left Shift key and period

Today we will cover how to use your Wikispaces account.  This will be how you post your vocab definitions online.  Any online wiki allows users to change the content of the website; for our class wiki the only people who can change the content are the people in the class - no one else will have access to the wiki.  It is for this reason that using Wikipedia should be used with caution - you can never be sure that the person who edited the website is an expert in the area they posted about online.

After covering how to use the Wikispaces website we will learn the Left Shift key (L4) and the period (R3).

Read More..

Difference between LEFT and RIGHT OUTER Joins in SQL MySQL Join example

There are two kinds of OUTER joins in SQL, LEFT OUTER join and RIGHT OUTER join. Main difference between RIGHT OUTER join and LEFT OUTER join, as there name suggest, is inclusion of non matched rows. Sine INNER join only include matching rows, where value of joining column is same, in final result set, but OUTER join extends that functionality and also include unmatched rows in final result. LEFT outer join includes unmatched rows from table written on left of join predicate. On the other hand RIGHT OUTER join, along with all matching rows, includes unmatched rows from right side of table. In short result of LEFT outer join is INNER JOIN + unmatched rows from LEFT table and RIGHT OUTER join is INNER JOIN + unmatched rows from right hand side table. Similar to difference between INNER join and OUTER join, difference between LEFT and RIGHT OUTER JOIN can be better understand by a simple example, which we will see in next section. By the way joins are very popular in SQL interviews, and along with classic questions like finding second highest salary of employee,Inner join vs outer join or left outer join vs right outer join is commonly asked.

Read more »

Read More..