GOOGLE SHEETS

MASTERY

COURSE SUMMARY

ENROLL NOW

This course provides educators of all grade levels and teaching experiences a self-guided experience exploring useful features and teaching tools in Google Sheets. 

GOOGLE SHEETS MASTERY

COURSE DETAILS

COURSE NUMBER

IND 1268

COUrSE INSTRUCTOR

Paul gose

COUrSE DESCRIPTION

This course provides educators of all grade levels and teaching experiences a self-guided experience exploring useful features and teaching tools in Google Sheets. 

 

Email

(209) 380-5546

Correspondence will occur once every week until course requirements are met. Evidence of 15 hours per unit must be submitted. Locations will vary due to technology needs and be determined on an individual basis.

There will be 12.5 hours of instructional sessions per unit of credit during this course. The type of communication will be determined by the participant and Valley Teachers Group.

ENROLL NOW

PRIMARY LEARNING OBJECTIVES

  • Use Google Sheets to promote, support, and model creative thinking and inventiveness.
  • Demonstrate fluency in technology systems and engage all stakeholders using digital media to reinforce students’ innovative achievements.
  • Advance students’ knowledge by incorporating digital tools in the classroom to expand their content learning.
  • Design differentiated lessons that enable students to manage their own learning using digital resources.
  • Use Google Sheets to communicate relevant information and ideas effectively to students, parents, and peers.

COURSE REQUIREMENTS

Scholastic/academic time log must be submitted at completion of the course. 

The keeping of a time specific log documenting research, activity, and curriculum is required. Evidence of 15 clock hours per each unit of credit must be recorded to meet course requirement. These clock hours shall be comprised of 12.5 instructional hours and 2.5 independent practice. Included in these hours, you will include a narrative of the instructional sessions. Students wishing to obtain 2 units must complete the 25 hours of instructional sessions and 5 hours of independent practice. Students wishing 3 units must engage in 37.5 hours of instructional sessions and 7.5 hours of independent practice.

POLICY ON Plagiarism

All people participating in the educational process at Fresno Pacific University are expected to pursue honesty and integrity in all aspects of their academic work. Academic dishonesty, including plagiarism, will be handled according to the procedures set forth on page 8 of the Fresno Pacific University Catalogue.

COURSE MATERIALS

A variety of articles providing examples of the above applications.


ASSIGNMENTS

You must create a screencast in which you demonstrate your ability to utilize the Google Sheets features listed below. Post your Screencast online (Google Drive) and email the link to Valley Teachers Group.

Assignment One:
  • Show how to start a new Google Sheet and name it.
  • Demonstrate basic cell text editing to your spreadsheet (change font/size/color, merge, align text, wrapping, etc.).
  • Demonstrate that you can insert a row/column.
  • Add a new sheet to a created file.
  • Show that you can download as a PDF, Excel, or .CSV.
  • Convert an Excel or .CSV file into a Google Sheet.
  • If there are student names within your document, for confidentiality purposes, make sure that the names in your Sheet are blurred out in some fashion.
  • Please include your audio voiceover that guides the screencast of the criteria throughout your video.
  • Please use the naming convention <First and Last Name – Google Sheets 1 Badge> when titling your screencast video.
  • Post a shareable link of your created Google Sheet and your screencast. Please make sure that your video is set to be viewed by anyone as well.

Assignment Two:
  • Create a new Google Sheet or collect responses that auto-creates a Google Sheet (i.e. from Google Forms).
  • Capability to sort columns with a particular purpose (Alphabetizing…)
  • Within your screencast, describe how you plan to use your data to drive instruction/create a plan of action.
  • If there are student names within your document, for confidentiality purposes, make sure that the names on your Sheet are blurred out in some fashion.
  • Please include your audio voiceover that guides the screencast of the criteria throughout your video.
  • Please use the naming convention <First and Last Name – Google Sheets 2 Badge> when titling your screencast video.
  • Post a shareable link of your created Google Sheet and your screencast. Please make sure that your video is set to be viewed by anyone as well.

Assignment Three:
  • Create a new Google Sheet or collected responses auto-creates the Google Sheet (i.e. from Forms)
  • Capability to sort columns with a particular purpose (Alphabetizing…)
  • Find and install an Add-on (autoCrat, Flubaroo, (g)Math…).
  • Evidence of the product having used the Add-on (i.e email sent out to student/audience, results from running Flubaroo, etc…)
  • Describe the purpose in choosing this specific Add-on for your data.
  • If there are student names within your document, for confidentiality purposes, make sure that the names in your Sheet are blurred out in some fashion.
  • Please make sure you talk over your screencast so it guides the viewer through the criteria in your video.
  • Please use the naming convention <First and Last Name – Google Sheets 3 Badge> when titling your screencast video
  • Post a shareable link of your created Google Sheet and your screencast. Please make sure that your video is set to be viewed by anyone as well.

CLASSWORK EXAMPLE

COURSE SYLLABUS

EVALUATION CRITERIA FOR CREDIT

Grading Criteria:
Grades are Credit/No Credit (CR or NC). Credit is equivalent to a B grade or above. Letter grades are not issued.

Participants are evaluated based on successful completion and submission of:
  1. Time log narrative proving a minimum of 15 hours per unit of credit including the instructional sessions – 30%
  2. Response to each of the 34 MS Word tutorials – 40%
  3. Proper documentation and citation in all work for this course – 10%
  4. Participation in all agreed upon correspondence. – 20%

Completion of these items will result in a passing grade for the participant.

ENROLL NOW

POLICY STATEMENT

These courses are post-baccalaureate, professional development units that are not part of a degree program, but are designed in collaboration with school districts and other educational organizations to meet specific staff development needs. Students should seek approval of appropriate district or college officials before enrolling in these courses to satisfy any degree, state credential, or local school district requirements.