Assignment #7- Google #4 Weekly Schedule

Today, you are going to create spreadsheet in Google Drive.  This spreadsheet will be a weekly schedule for next week starting with this Sunday (or it could be for our first week back to school after break).

Across the top of your spreadsheet you will type the 7 days of the week starting with Sunday (skip the first cell).
Down the first column (A) you will type every hour starting with 6:00 am through 2:00 am. (skip the first cell).  We will format the cells before we begin typing in the hours.

This schedule will have 147 cells to fill in.

You will color code the cells by changing the background color and the font color.

I will go over all the specifics in class.  It is important that you listen and follow along as I explain this assignment. 

Assignment #6- Google #3 Budget

Today we are doing one of the required parts of the applied skills portion of this class.  We will be creating a budget spreadsheet using Google.

You are going to create a monthly budget.

Starting with cell A1, then A2, then A3, etc. through A10, you will type in these 10 expenses:

Rent

Utilities

Cable

Cell Phone

Car Payment

Insurance

Gas

Food

Entertainment

Savings

In cell A11 you will type Total.

Then you will select cells B1 through B10 and then click the dollar sign button.  Then with the cells still selected click on the sum button found in the "Crazy E looking tool" at the end of the row of tools.

Now enter in dollar amounts in each of the cells.  The program will automatically add the dollar sign and total these dollar amounts.

Finally, select all of the cells (words and dollar amounts) except for the total cells at the bottom.

Then click on insert chart (There is a button for this or you can find it under the insert tab).

Select the pie chart, and choose one of the three different types of pie charts.

Position the chart so that it is to the right of the cells.

Assignment #5- Hour of Code

For this assignment, you are going to complete an "Hour of Code."  Click this link to begin.

After you finish the hour of code (it won't take an hour) you will download your certificate to your desktop.  Make sure you type your first and last name correctly on your certificate.  You will then do a blog post titled "Assignment #5- Hour of Code."  You will insert the image of your certificate and publish.

Assignment #4- Google Assignment #2

This is the second Google Drive assignment.

This assignment is a letter using the correct format (see example below).  You can choose to write a letter to a famous person (band) asking for an autographed picture or a letter to a company asking for free stuff.

1)  Go online and find the mailing address of a company (If you can also find the name of someone in that company, that's even better.) that you like or the mailing address of your favorite actor, singer, artist, etc.  

Make sure that you format this letter correctly.  Everything is left justified and there is a single open space between your address, date, the company's (person's) address, greeting, etc. until you get to the end. When you type the date type out the long version (March, 24, 2016).  Do not use only numbers (3/24/16).  When you finish the letter with "Sincerely yours," or "Respectfully yours," double-space before you type the "handwritten signature" and double-space again before you type the typed signature. Your name will be typed twice.  Then, we will change the font (to a handwritten looking font) of the first one to represent your signature.

In the body of the letter, write about how much you like the company, group, or person detailing the products that you use from the company or the things (albums, movies, etc.) that you like about them (at least 1 paragraph- 4 sentences).  

In the last paragraph, ask the company if they have any free stuff or coupons (or if it is a person you could ask for an autographed picture or something).

Assignment #3- Google Assignment #1

Today's assignment will be the same content as your "About Me" blog post.  It will be done as a document in Google Drive.

I will go over the specific procedures for working with Google Drive in class.

Assignment #2 My Favorite Hobby

This is a blog assignment.

Title the post "My Favorite Hobby."  Write at least 150 words about your favorite hobby (a school appropriate activity that you do for fun).  You can briefly summarize the hobby in a few sentences (no more than 3).  The majority of this blog post will be about your opinions of the hobby and why it is your favorite.

You will add a related link and 2 pictures to this blog post.

Example of a link.

When creating the link in your post.

1. Select a word that you have already typed (do not add any extra words to create the link).

2. Click on the "Link" button in the tool bar (Link).

3. Type in the website.

Adding pictures to blog posts

1.  The picture you want to add must already be downloaded to the computer.
2.  To the right of the Link button you will find the Insert image button.  Click on it.
3.  Select choose file (select the correct image.).
4.  After it is uploaded, click add selected image.

Minimum requirements

3 paragraphs

150 words

2 pictures

1 link (to a related website)

Assignment #1 About Me

This first assignment will be completed on your Blog. 

Write at least 3 paragraphs of at least 100 words about yourself.

We started this on day 1 of the class.