Summary for Four Online Courses Week by Week • Start November 2015 • Nov 2 to Jan 23

 SCRATCH
Our shared doc
LESSON 1 Nov 2 & Jan 25
LESSON 2 Nov 16 & Feb 1
LESSON 3 Nov 30 & Feb 8
LESSON 4 Dec 13 & Feb 22
LESSON 5 Jan 4 2016 & Feb 29
​LESSON 6 Jan 18 & Mar 7
​
NOVEMBER 2016 CLASS
Ali • Ben • Kris
Kristen • Pam • Susan

JANUARY 2016 CLASS
Veronika HI • Alisha MD
​Jamie CA
Veronika: MrsDonavan
Alisha:carusoA
Jamie: JKSullivan

RESOURCES
Kinkaid Grade 6 Studio
Univ Sch Milwaukee Studio

Sample Project from Jeff Utz
Making a Square and Using the Interface
The Ink from the Back of the Cat's Neck
Arrow and Variable
Change Cat to Arrow
Size of Screen is 480 by 360
OPTIONAL
Screensnapshots on Mac or PC
The Color Wheel from 1 to 200

Colleen Lewis Scratch Videos
Asst Prof Harvey Mudd College CA
Hour of Code Suggestions
Porting Scratch Projects

SCRATCH4KIDS
Nov-Dec 2015
Our Online Class webpage
Lesson 1 Nov 2
Lesson 2 Nov 16
Lesson 3 Nov 30
Lesson 4 Dec 14

SCRATCH4KIDS
​JAN-MAR 2016
Our Online Class webpage at
http://tinyurl.com/online4kids2
Lesson 1 Jan 25
Lesson 2 Feb 8
Lesson 3 Feb 22
Lesson 4 Mar 7

  GD
Our shared doc
LESSON 1 Nov 2
LESSON 2 Nov 16
​LESSON 3 Nov 30
LESSON 4 Dec 13​
LESSON 5 Jan 4 2016​
​LESSON 6 Jan 18 2016
​
RESOURCES
Review Skills -- using tinyurl.com/GDreview33
Uploading Files into GD
Sharing with GD
Research Tool on GD
The Comment Feature on GD

OPTIONAL
Putting Contacts into Groups
Using TinyURL
TABs and Margin Markers in GD
TABs and Margin Markers in Microsoft Word
More WP features of GD


RIVER OAKS GOOGLE DRIVE AND GOOGLE CLASSROOM COURSE
​
LESSON 1 Jan 4
​LESSON 2 Jan 18
​LESSON 3 Feb 4
​LESSON 4 Feb 22
collaborative doc in Lesson 4
​LESSON 5 Mar 10
​LESSON 6 March 24

EXCEL
LESSON 1 Nov 2
LESSON 2 Nov 16
​LESSON 3 Nov 30
LESSON 4 Dec 13
LESSON 5 Jan 4 2016​
​​LESSON 6 Jan 18 2016

RESOURCES
L1_Excel_US Presidents
L2_Countries of the World
Lesson 4 Column Entry.xlsx
Lesson 4 Florida Schools
Lesson 4 Sample Scheduling
Lesson 5 WorksheetToDo.xlsx
Lesson 5 Challenge
Lesson 6 Worksheets.xls

Tips from the Spreadsheet Page
6 Tips: This isn't Excel it's Magic
100 Excel Tips from Chandoo.org
Swarthmore Tips for Mac Users
Tips for PC Users (U of Brighton)

Videos from spreadsheetsolving.com
More formulas: 
SUMSQ + MEDIAN + MODE

BONUS TIPS
You can force a carriage return by using ALT-ENTER on a PC or CTRL-OPTION-RETURN on a Mac 

Automatic Mean Standard Deviation Spreadsheet

IPAD
Our shared doc
LESSON 1 Nov 2 & Jan 25
LESSON 2 Nov 16 & Feb 1
LESSON 3 Nov 30 & Feb 8
LESSON 4 Dec 13 & Feb 22
LESSON 5 Jan 4 & Feb 29
​​LESSON 6 Jan 18 & Mar 7

RESOURCES
THE 33 SKILLS BELOW
1) The Six Buttons and Orientation
2) Minimize an App in 2 Way
3) Switch from 1 App to Another
4) Multitasking Tray
5) Spotlight Search
6) Read Text Aloud
7) Notifications
8) The Control Center
9) Settings and Camera
10) The App Store
11) Organize Your iPad
12) Important Numbers
13) Splitting and Undocking Your Keyboard
14) Save Images from Web
15) Take Screenshot
Typing Practice Challenge (optional)
Why Do We Love GD & Dropbox (opt)
16) Keyboard Shortcuts
17) Font Size for Notes
18) Selecting Text and using Cut/Copy/Paste
19)  Special Keys
20)  Dictate to your iPad 3 or 4    
21)  International Keyboards and the Globe
22) Email up to 5 pictures at once
23) GD (Google Drive/Docs)
24) Save Web Pages onto your Home Screen
25) Add Bookmarks in Safari
26) Auto Correct On or Off
27) One Space Between Sentences 
28) Reader Mode -- 3+ Horizontal Bars
29) Using Bookmarks with Google Chrome 
30) Cropping Pictures and Photo Alterations
31) Searching on a Website for a Specific Word    
32) Add or Change the Passcode
33) Making Slideshows

33 QUESTION HALL OF FAME