Summary for Four Online Courses Week by Week • Spring 2015 • Mar 30 to May 8

SCRATCH
Our shared doc

LESSON 1 Mar 30
LESSON 2 Apr 6
LESSON 3 Apr 13
LESSON 4 Apr 20
LESSON 5 Apr 27
LESSON 6 May 4

Scratch Libraries of 4 people
Craig * Jeannie * Ka'ala * Margaret

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 at Harvey Mudd College in Calfornia


Porting Scratch Projects

GD
Our shared doc

LESSON 1 Mar 30
LESSON 2 Apr 6
LESSON 3 Apr 13
LESSON 4 Apr 20
LESSON 5 Apr 27
LESSON 6 May 4

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

EXCEL
Our shared doc

LESSON 1 Mar 30
LESSON 2 Apr 6
LESSON 3 Apr 13
LESSON 4 Apr 20
LESSON 5 Apr 27
LESSON 6 May 4

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 Mar 30
LESSON 2 Apr 6
LESSON 3 Apr 13
LESSON 4 Apr 20
LESSON 5 Apr 27
LESSON 6 May 4

FINAL PROJECTS
Kelsey

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