21_century_google

Hit Counter

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 about transferring files to Google sheets*
Video on Sorting with Filters Part 2	Part 2 Sorting in a Spreadsheet	8 Lesson - 8 *8a. Sheet upload to your Drive*
*Video on Lesson 9 Amortization*	Monthly Amortization	9 Lesson - 9 9a 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.
	Spelling Kindergarten Coded Message	1. Lesson-1 2. Lesson-2 3. Lesson-3