In this late beginner to an intermediate level project, students really learn how to use some cool text manipulation functions to expedite their work and minimize typing.
The idea is that students work at a medium sized t-shirt manufacturing company called “Tim’s Tees”. The company accepts online orders, then designs and sends t-shirts to customers. The company has grown rapidly and has had to hire a bunch of new employees. Unfortunately, the only information on employees is contained in a poorly organized Excel spreadsheet that is full of errors and needs updating. The mistakes include names not being capitalized, extra spaces, and a lack of information. The "boss" wants students to move the spreadsheet from Excel to Google Sheets. He also wants them to “clean up the data”. In other words, remove spaces and make sure capitalization is on point.
Students are expected to split the names into first and last names, to add company email addresses, usernames and passwords for the company computer network, employee numbers, start dates, department names, and also to add a field which determines if the employees are eligible for bonuses or not.
Since the "boss" needs this done in an afternoon students need to act fast. They need shortcuts, and they will use some functions in Google Sheets, as well as an add-on, to speed things up.
Students learn to quickly use alternating rows of color to give their data tables organization and a punch of color. On the main sheet, students make use of a drop-down list for gender. This drop-down list exposes the students to the concept of data validation, the idea of minimizing typos and human error when possible.
The instructions come in the form of an interactive .pdf file, which allows students to navigate throughout the document by clicking buttons, click on a linked up Table of Contents, and toggle between full-screen mode and normal viewing mode. Students enjoy this measure of control over how they get around the instructions, and they are quickly and easily able to backtrack and review information using the Table of Contents.
Google Sheets is basically like an online version of Excel. It is a great alternative to Excel in that it allows for student collaboration and for students to access their work wherever they have an internet connection!
Please feel free to contact me with questions or comments regarding this assignment! I hope that you find it useful and I look forward to hearing from you.
Included in this package:
- a .pdf teacher instruction file with plenty of screenshots and clear instructions.
- a text document which includes links to the answer files
- an excel document which includes the names to be imported into Google Sheets
- Take the time to do this activity yourself prior to presenting to the students so you are familiar with the steps.
Others you might like:
Google Sheets Bundle - 10 Great Lessons for Beginners
Google Sheets - School Grades Math Lesson
Google Docs Lesson Bundle - 4 Essential lessons for beginners
Excel 2010 Beginner Lesson Bundle