Jump to content

Jordyn Marr

From KNILT

Return to: ETAP_623_Spring_2021_(Byrne) | Jordyn Marr's Portfolio Page |Introduction to Google Sheets


About Me

Jordyn Marr
Jordyn Marr

I graduated from UAlbany in 2020 with a degree in Business and Sociology. Most of my work experience has been in HR, having two summer internships as an HR intern and one as a data management intern. I also substitute often for Shenendehowa CSD, my favorite role to be called in for is the self contained room for children with behavioral disorders. Although my background is not in education, I am excited to join the COLT program as it will assist in my goal of training adults in the workplace.

Currently I play lacrosse for the University at Albany. This is my final year of playing and I hope we get in a safe and healthy season. In the summer I love to be outdoors hiking, relaxing and boating on Saratoga Lake.

My Topic and Purpose

Topic: Google Sheets for Classroom Management!

Purpose: This page will provide guidance on simple formulas and uses for using Google Sheets in the classroom.

Scope of Learning Outcomes and Content

Learn

  • Formulas to create efficient Google Sheets
  • How to easily collect & analyze student data
  • How to use with other Google Suite products

Create

  • In/Out Tickets
  • Automatic feedback on assignments
  • Behavior Charts
  • And many more!

Understand

  • The simplicity of Google Sheets
  • The multiple uses of the program
  • The reasoning behind each formula to create custom formulas

Needs Assessment

The instructional problem: Google Suite is a common tool provided to educators, but Google Sheets is often underused due to lack of knowledge on the information and skills to utilize the platform to its full potential. As a tool, google Sheets can be extremely efficient.

A study done on Google forms highlights the need for efficiency in a teachers daily routine. “A common problem that often occurs for teachers at universities is the difficulty in organizing student tasks effectively and efficiently.” (Iqbal, et al., 2018).

Nature of what is to be learned: Instructors will learn how to maximize the potential efficiency’s of Google Sheets and supporting Google Suite products.

About the learners: The learners taking this mini-course are Kindergarten through High School teachers. The participants have all graduated from an undergraduate program and have either completed or are in progress to complete a masters degree in education. Instructional experience may vary, as well as experience with Google products, Microsoft Excel, Numbers, or other spreadsheet software. As this is a basic level course, prerequisite experience is not necessary. Access to Google Suite is, although skill sets are transferrable to prior stated spreadsheet software. The learners have voluntarily sought out this mini course, motivated to improve their technological skills and classroom efficiency.

Instructional content: This mini-course will be set up to introduce a new formula or feature, have self practice, and then present ways to implement the new skill into daily classroom management. Throughout the course they will be provided with templates follow along with and understand how to customize their own. This course will be provided for many years, therefore discussion board posts will be limited to posting resources found by peers.

The instructional content will include the use of Google Sheets, Google Forms, and Google Slides. Video content will be utilized through the Google for Education website, as well as YouTube. Quizzes will be provided by Google Forms, providing a realistic preview for learners to view their test data in Google Sheets. Activities are designed to be authentic and immediately put to use.

Analysis of the Learner and Context

Context for Instruction: This mini course will be provided online, therefore learners will need access to tablet, computer, or other internet connecting device with access to the Google Suite products.

Prerequisite Skills:

Essential Prerequisites:

  • Understanding concepts, procedures, and principles related to:
  • Google Suite products
  • Digital Learning
  • Component skills: computer proficiency, ability to access and navigate Google Sheets at a basic level, ability to navigate Wiki and supporting tools

Supporting Prerequisites:

  • Willingness to learn
  • Desire to create efficient classroom
  • Being open minded to change traditional methods of classroom management

Performance-Based Objectives

Learners will be able to do the following at the end of this mini course:

  • Build a Google Sheet for their classroom needs
  • Understand the process of implementing formulas
  • Become familiar with resources compatible with Google Sheets
  • Demonstrate the functional, organizational, and analytical sides of Google Sheets

Task Analysis

Course Learning Objectives:
By the end of this course students will be able to:

  1. Build a Google Sheet for their classroom need
  2. Understand and be able to implement resources compatible with Google Sheets
  3. Conduct a basic analysis of classroom data
  4. Understand the process of implementing templates
  5. Explain how Google Sheets creates efficiencies in the classroom

Unit 1: Introduction to Formulas
Upon completion of Unit 1, students will be proficient in the use of basic functions in Google Sheets and be able to successfully implement them in a custom spreadsheet.
By the end of the unit students will be able to:

  1. Navigate Google Sheets platform
  2. Execute basic functions for custom formulas (SUM, COUNT, LOOKUP, Shortcuts, text search functions)
  3. Create custom spreadsheet for classroom use

Unit 2: Utilizing Google Suite Products
Upon completion of Unit 2, students will understand how to utilize additional Google Suite products in combination with Google Sheets.
By the end of the unit students will be able to:

  1. Identify compatible products
  2. Explain selection of products
  3. Create activity using (2) or more Google products
  4. Implement functions from Unit 1

Unit 3: Collecting & Analyzing Data
Upon completion of Unit 3, students will understand and be able to execute the analytical capabilities of Google Sheets.
By the end of the unit students will be able to:

  1. Identify points for data collection
  2. Execute functions to organize data
  3. Demonstrate ability to analyze data
  4. Explain results of analysis

Curriculum Map


References and Resources

Google Sheets Training | Teacher Center. (2021). Google for Education. https://edu.google.com/teacher-center/products/sheets/?modal_active=none

Iqbal, M., Simarmata, J., Feriyansyah, F., Tambunan, A., Sihite, O., Gandamana, A., Eza, G.N., Kurniawan, F., Asiah, A., Rozi, F., Faisal, F., Manurung, I., Ihwani, M., Nathan, P.L.A., Sitanggang, N., Simbolon, N., Simanjuntak, E.B., & Limbong, T. (2018). Using Google form for student worksheet as learning material. International Journal of Engineering & Technology, 7(3.4), 321-324. https://www.researchgate.net/profile/Muhammad-Iqbal-104/publication/328234356_Using_Google_form_for_student_worksheet_as_learning_media/links/5bc59e2092851cae21a81b2a/Using-Google-form-for-student-worksheet-as-learning-media.pdf

Retrieved from "https://knilt.arcc.albany.edu/index.php?title=Jordyn_Marr&oldid=180715"