Transformation
Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and simultaneously work with other people.
Objectives
Objectives
- Create a Google Spreadsheet or import and convert Excel, .csv, .txt and .ods formatted data to a Google Spreadsheet
- Export Excel, .csv, .txt and .ods formatted data, as well as PDF and HTML files
- Use formula editing to perform calculations on your data, and use formatting make it look the way you'd like
- Share your file with collaborators and viewers
- Evaluate Google Sheets as a cloud-based communication and collaboration tool
Student Responsibilities
Student Responsibilities
Please review the linked resources below, complete the tasks, and share your thoughts on Google Classroom.
- View: Google Sheets Overview--Upload and Convert, Create New, Functions and Formuli
- View: Google Sheets Overview--Add a Sheet, File Menu Options, Formatting and Add-ons, Share
- Read: Google Sheets Support (reference as needed)
- Read: Spreadsheet Activities for All Subjects
- View: Flippity--Easily turn Google Sheets into a set of online flashcards
- Read: Google Sheets Resources from Eric Curts
Tasks
Tasks
- Create a new Google Spreadsheet or import and convert Excel, .csv, .txt and .ods formatted data to a Google spreadsheet
- Invite your classmates and the instructor to collaborate on a spreadsheet with you, giving them editing privileges
- Use formula editing to perform calculations on your data, and use formatting make it look the way you'd like
- Download your spreadsheet as Excel, .csv, .txt and .ods formatted data, PDF or HTML
- Transform a lesson plan that integrates Google Sheets in meaningful ways
Discuss
Discuss
Complete the following on Google Classroom.
- Share the link to your Google Sheet (Make sure your privacy settings allow anyone with the link to view your document).
- Evaluate Google Sheets as a teaching and learning tool.
- Share your thoughts on how you might use this with students or colleagues.
- Feel free to comment on at least one other student's note.