m3d2

=Administrator Training Program Wiki: Day 2=

This page is meant to support Day 2 of the Administrator Training Program and contains links to resources mentioned by the presenters, the guest speaker, and the participants. Below are links to the official OCDE Administrator Training Program sites:
 * [|Administrator Training Program Official Site]
 * [|Practicum Hours Submission Form]
 * [|Original Binder] (PDFs in zip format for download)

Here is a new book that may be relevant to extending your learning on these topics:
 * [|What School Leaders Need to Know About Digital Technologies and Social Media] (2011, McLeod & Lehmann, eds.)

=Agenda (w/Links)=


 * Morning Segment:**

[|Day 2 Welcome Slides] (On Google Docs w/Discussion Feature) Welcome Activity

Data Quest - [|http://dq.cde.ca.gov] Ed-Data - http://www.ed-data.k12.ca.us/welcome.asp Just For The Kids, CA - [|http://www.jftk-ca.org] (How to pull up the Top 10 Comparable Schools data: http://screencast.com/t/YWQwNmFmNT )


 * Middle Segment:**

NEW: Updated [|Google Docs for Educators] workshop outline! EVEN NEWER: [|Google Drive]

[| Google Docs for Administrators] (This links to a separate Google Apps Education Edition workshop.) [|Google Docs for Personalized Learning] (This has more examples and templates for administrative and instructional purposes.)

[|Demo Presentation Chat]

Summary of Activities Docs Activity 1: How might Google Docs be useful to you as an administrator? Docs Activity 2: [|Who are we?] Docs Activity 3: Forms for Data Collection Docs Activity 4: Self-Grading Quiz! (BONUS - Time Permitting)

Key Tips [|Custom Walkthrough Forms]  (Demo Template with Individual Reports!) [|Quick and Easy Mail Merge Using Google Docs] [|Quick and Easy IF Formulas for Grading Google Forms]

Review of CIPA, COPPA, and FERPA UPDATED: [|Fall CUE 2011 Resources]

Overview of Copyright and Creative Commons


 * Afternoon Segment:**

Data Analysis with Spreadsheets: The M&M Activity with Google Docs Join our [|collaborative spreadsheet] here! And view [|the results]!

[|OUR FORMULA DEMO] Data Analysis with Spreadsheets: Top Formulas for Administrators > Google Functions:
 * [|SUM]
 * [|AVERAGE]
 * [|IF] See the [|Logical]category.
 * [|COUNTIF]
 * [|VLOOKUP]
 * [|TRANSPOSE]
 * Text Functions:
 * [|LEFT]
 * [|LOWER]
 * SPLIT
 * [|CONCATENATE]
 * SPLIT
 * [|GoogleTranslate]
 * [|GoogleLookup]

Data Presentation Review: Images, Impact, and Interaction: Presentations in Education Moving Your Presentation Online:
 * [|Google Docs] Presentations
 * [|Slideshare.net]

BONUS (Optional Topic): Current Mobile and 1:1 Solutions
 * [|Chromebooks]
 * [|iPads] (and iPod Touch)
 * Netbooks and more...

[|TechSETS] - Technical Resources for Schools (Including updates and free online help desk software.) Tech Sets Resources (eBinder Materials)
 * http://leadership.ocde.us/Assets/AB430/brochure.pdf.pdf
 * http://leadership.ocde.us/Assets/AB430/TechSETS+-+About.pdf.pdf
 * http://leadership.ocde.us/Assets/AB430/TechSETS.pdf.pdf

Don't miss these five resources we identified at TechSETS on April 13, 2010:
 * Tech Plan Builder - http://myctap.org/index.php/techplan/tpb
 * Partners: TICAL - http://www.portical.org
 * Partners: MyCTAP (lots of free online workshops) - http://www.myctap.org/index.php/professional-development
 * Partners: CLRN Digital Textbook Reviews - http://clrn.org/FDTI/index.cfm
 * [|Save Money by Leveraging Open Source Software] (PDF)

EdTech Profile
 * [|http://www.edtechprofile.org]
 * Video: [|How To Run A Proficiency Analysis Report For Your Site]

Practicum Hours
 * [|Practicum Hours Submission Form]
 * [[file:Practicum Guidelines.pdf]]

Reflection and Evaluation
 * How would your message from the future change after today's training?
 * [|Online Evaluation]

[|TICAL] - Day 1 - Administrative Resources for Schools [|TechSETS] - Day 2 - Technical Resources for Schools (Including updates and free online help desk software.) [|CLRN] - Day 3 - Instructional Resources for Schools (Search by standard!) [|EdTechProfile] - **All Days** (Self Assessment of Technology Proficiency)
 * SETS Projects**:

email Mark Wagner: mark@edtechteam.com