Module 7.3 - ANALYST Option 3: Google Sheets
Google Sheets
In this module, participants learn how to use Google Sheets to enter, organize, and analyze data, including student assessment data.
ISTE Standard: Analyst
To meet this standard, educators understand and use data to drive their instruction and support students in achieving their learning goals. Educators:
7a. Provide alternative ways for students to demonstrate competency and reflect on their learning using technology.
7b. Use technology to design and implement a variety of formative and summative assessments that accommodate learner needs, provide timely feedback to students and inform instruction.
7c. Use assessment data to guide progress and communicate with students, parents and education stakeholders to build student self-direction.
Teachers who effectively use Google Sheets are Analysts because they are more able to work with data sets in ways that allow them to "provide timely feedback to students and inform instruction." They are able to collaborate with teaching teams as they "use assessment data to guide progress and communicate with students, parents and education stakeholders to build student self-direction."
Learning Intentions
- I can create a Google Sheet or upload and convert a Microsoft Excel file to Google Sheets format.
- I can edit and format text and numerical data in Google Sheets.
- I can share and collaborate in Google Sheets.
- I can use basic and advanced formulas to calculate new data and text in Google Sheets.
- I can sort, filter, and freeze columns and rows and format a Google Sheet for printing.
Success Criteria
- View all pages and content
- Complete assignments, quizzes, discussions, and reflections:
- Google Sheets Cumulative Assignment
- Google Sheets Quiz