Badge Point(s): 2 points
Embedded Files
GOOGLE SHEETS
GOOGLE SHEETS
Track student and instructional data more efficiently and easily using Google Sheets! With many extremely similar features as Microsoft Excel, users don't have much of a learning curve to get comfortable with for this versatile tool.
Track student and instructional data more efficiently and easily using Google Sheets! With many extremely similar features as Microsoft Excel, users don't have much of a learning curve to get comfortable with for this versatile tool.
- Incorporate Google sheets into your lesson to teach graphing of information.
- Demonstrate pie charts, bar charts, and line graphs.
- Organize student data and track progression.
- Arrange student information for quick and easy access.
- Possibilities are endless!
Created by E Bryan
The Tasks
The Tasks
Please watch the video to the right to become familiarized with Google Sheets features.
Open this sample spreadsheet for this task. It will force you to make a copy. Please add your name in the title of the document after your new copy is opened.
Change the color of the Major column to a highlighter color.
Insert a new Phone Number column into the spreadsheet. Enter a fake phone number for the first student on the list. Then, use the copy down method demonstrated in the video (for the purpose of familiarizing yourself with the function).
Sort the sheet by organizing the Class Level column in reverse alphabetical/numerical order.
Create four new sheets at the bottom of the main spreadsheet for each class level. Label them accordingly.
Copy/paste the information from the master sheet that applies to or matches each new sheet/tab along the bottom.
Configure the share settings on your spreadsheet to where "Anyone on the Internet can view" it. Get that shareable link and provide it in the Google Form below where prompted.
Submitting the Evidence
Submitting the Evidence
Click HERE to go back to Badging main page
Report abuse