Hit Counter

Schools Website

 

Google Docs Videos

 

Description of Video and or lessons

List of GOOGLE
 Lessons

Google For Fun

Video - Folders - 1

 

Creating Folders & Uploading  and downloading documents

Two of many ways to place your lesson in the classroom folder.

PHOTOS OF CLASS

1. Click on the folder above the lesson your working on
2. Arrow on the left
3. click on Shared with me
4. Move to folder/
1. While you are in your document
2. Press "file"
3. Press the back arrow until you see the "Shared with me" folder
4. Select the top folder that says "Assignments Block #   Or your classroom folder.
All quizzes will be listed below with the date that the quiz was created and available for you to take
 
QUIZ 3 Sept 28                                  Join game                            CODE IS  439968
 
DRAWING
Video - Drawing

Lesson - 1 Video on Google drawing

1. Lesson  Inserting a picture

2. Lesson Picture with a story
 
Video - Printing Printing out your picture or other work    
       
    Links that may be used in your lessons
    1. Techniques for Photo Sketches  
    2. Create a Fake News Paper  
    3. FotoSketcher 3.30  
    4.  Fun with words  
WORD
Video -  Biography
 
Creating a document with your photo and a biography. 1. Lesson   Photo of you and your Biography  
  Thinking assignment 2. Lesson   Express how you feel.  We will produce a green screen video at a later time.  
Video on Creating A Story with Animation You are going to create a story with animation.  Make a book and also a video of the story. 3.  Lesson   Authoring a story with animation Website to design your story

Click on my story maker

Video on Papers written around the World Using word Office or docs find at least (3) news papers and type up information from around the world.  Would be beneficial if you could find a topic and compare. 4. Lesson  --  Newspaper  
Video on Merging Google Doc
Spreadsheet Data
This will be a simple lesson on merging Sheets with Google doc. Creating a paper with grades to be sent home 5.  Lesson

5a. Document      5b. Sheet
You will need to upload these two 5a & 5b into your folder called "MERGING INFORMATION" and open them up as Google docs.

 
Video on Creating Address Labels Creating address labels to for envelopes 6.  Lesson

6a.  Sheet   Upload to you drive

 
Lesson 7 Video Creating A Resume Using Google docs to create a Resume 7. Lesson

7a. Example Resume

Cover letter why needed

Example Cover letter

 
Lesson 8 Video Creating a Video Story Converting a PDF file with your story on it to a video 8. Lesson  
       
       
SPREAD SHEETS
Video - Art Museum Creating a spreadsheet sheet using Google sheets 1. Lesson  Art Museum Field Trip Placing the Spreadsheets in your Google Drive

1.Open up and slide the link to your desktop
2. Open up your Google sheet.
3. Click on File and open.
4.Click on Upload
5. Drag the spreadsheet from your desk to the area that says Drag a File here.  You file will then start to be uploaded.
6. Click open

Video about transferring files to Google sheets

Video My Budget Creating a spreadsheet for Budget 2. Lesson   My Budget

Video on Charts 

Creating a Spreadsheet with Charts 3. Lesson   Charts
Video on Logic Spreadsheets Creating a Spreadsheet with Logic problems 4. Lesson   Written Lesson on Spreadsheets
 
4a. Sheet   upload to your Drive

 

Video on Million - Billion - Trillion Analyzing a Spreadsheet to determine One Trillion in Time and Money 5. Lesson      Million  Billion  Trillion

5a. Sheet  upload to your Drive

Upload Sheet into your folder called SPREAD SHEETS

 

Video on Sorting Part 1 Part 1  Sorting in a Spreadsheet 6. Lesson     Sorting

6a. Sheet   needs to be upload to your Drive

Video about transferring files to Google sheets
Video on Amortization Monthly Amortization 7. Lesson - 7                      DATA SHEET

7. Answers

7C. Quiz

 

Video on Sorting with Filters Part 2 Part 2 Sorting in a Spreadsheet Lesson - 8
8a. Sheet   upload to your Drive
 
 
Video on Lesson 9 Amortization Monthly Amortization 9 Lesson - 9

9 Sheet  needs to be upload to your drive

 
Video on Lesson 10 Vertical Lookup  Table

Vertical Lookup Table

10  Lesson - 10

10a.  Sheet needs to be uploaded to your drive

 
Video on Lesson 11 Vertical Lookup Table Vertical Lookup Table 11. Lesson - 11

11a.  Sheet needs to be uploaded to your drive.

 
Video on Lesson 12  Hlookup Horizontal Lookup Table 12. Lesson - 12

 

12a.  Sheet  needs to be uploaded to your drive

 
Video on Lesson 13 Hlookup Horizontal Lookup Table

No fill down

13.  Lesson - 13

13a.  Sheet  needs to be uploaded to your drive.

 
Video on Lesson 14 Hlookup

 

Horizontal Lookup Stem School Data Table 14. Lesson - 14

 

14a. Sheet upload to your drive

 
Video 15 on Car Leasing or Purchase Lesson  Lease a car or Purchase a car
Write the spreadsheet
15.  Lesson

 

 
Video 16 on using Functions You will be provided with a page of functions allowing you to become better acquainted. 16. Lesson

16a.  Sheet upload to your drive

 
  You have two different lessons on the same spreadsheet dealing with round average and time 17  Lesson

17a.  Sheet  upload to your drive

 
Video Lesson 18 on Forecasting This lesson will use a spreadsheet to forecast pricing changing to obtain the most money. 18. Lesson

 

18a. Sheet upload to your drive

 
Lesson 19 Video on 3 Different Levels Vlookup and 1 Hlookup Three levels of Vlookup 1 level of Hlookup 3 columns 19 Lesson

19a.  Sheet upload to your drive

 
VIDEO ROTH IRA  Roth IRA Savings 20. Lesson  
Video 21 on Payroll Part 1 Payroll for Part 1 and Part 2 21.  Lesson - Part - 1

a.  Sheet upload to your drive

 
Video 22 on Budget Part 2
 
This lesson will allow you to understand  budgeting your money 21 Lesson  Part - 2

a.  Sheet Blank to upload to your drive

b. Sheet with answers to upload

 

 
       
       
  NESTED IF LESSON 1 SHEET UPLOAD TO YOUR COMPUTER  

SLIDES

Video - Slides for Education Creating a number of slides that will assist in teaching 1. Lesson - 1   Slides   
Video on Creating a JPEG with a Quote Creating a photo with an Educational Quote. 2. Lesson -2   Slides for quotes   
Video on Nonlinear Slide Presentation Creating a Slide Presentation that is Interactive 3. Lesson   Slides Nonlinear  
Video on Non Linear Multiple Choice Slide Presentation Multiple Choice Side Presentation 4. Lesson   Slides Non liner

 

4a. Slides  Upload to your Google drive

 
Video on adding your voice to slides Adding voice to slides and PDF files 5. Lesson  
Video on Creating a Collage CREATING A COLLAGE USING SLIDES 6. Lesson

6a. Example in  PDF format

 
       
       
       
       

GOOGLE   FORMS

Video on Creating Google Forms Survey Creating Google Survey Form 1. Lesson  
Example Quiz Civil War  only 4 Questions    
Video on Creating Google Form Quiz Creating a Google Quiz 2. Lesson  
       

GOOGLE TOUR BUILDER

GOOGLE TOUR OUR BUILDER LINK

1. LESSON-1

This first lesson is designed to allow you the student to learn the basics before you create a sophisticated tour lesson.
Videos on how to create a Google Tour      
1.  VIDEO - 1      
2. VIDEO  - 2      
Google Tours Gallery      
       

MEME

Make an Animated Meme 

Directions  V 1)  Website for Categories  
   
2)  Website for Adding Text
 
       
       

3D PRINTER

3D PRINTER WEBSITE  DOWNLOAD IDEAS  
       
       
The lessons listed below are designed to be created and used for students in elementary school
Video

These lessons are used by Kindergarten students to teach math and spelling easily.  Use the same codes for both.

Addition Code Math 1. Lesson - Addition Blank Lesson Doc   
Lesson
PDF

Open up in blank Google Doc and copy the code to the blank sheet if you do not have office.

Design your own math lesson for Addition and subtraction.  You may place both in the same lesson.
Addition Code Math 2. Lesson - Addition
     
     
Subtraction Code Math 1. Lesson - Subtraction  
     
     
       
Spelling Kindergarten
Coded Message
1. Lesson-1
2. Lesson-2
3. Lesson-3
Open up in blank Google Doc and copy the code to the blank sheet if you do not have office. Design your own spelling lesson using any one of the three methods shown on the left. Make it easy because the lessons are for Kindergarten.