Skip to content
Playback Speed:

There are many ways to do research for a complex group project.

You might go to the school library, read a classroom textbook, or do an online search.

In this extension, you will use a spreadsheet to keep track of the research you do for a group project, so you can easily access it later and cite your sources properly.

To research and use relevant information and materials for your group project, you will use Google Search to find information about your group project.

The example here is teaching a topic to your class.

However, you can apply these skills to all sorts of group projects.

Then, you will use Google Sheets to add and organize links to the online resourcesand add and organize links to other important resources -- such as a document or a slideshow.

Adding links enables you to access a resource with just one click.

That way, you don’t have to perform the same search over and over again to find what you need.

Begin by opening your “Teaching a Class: Project Planning” spreadsheet.

Then, make a copy.

Next, add a column header at the far right for Links.

Then, open a new tab in your browser.

Keep both tabs open when you search for resources online.

That way, you can easily return to your spreadsheet whenever you find a useful website.

Search for resources that are relevant to your project and its goals.

For example, if you were teaching a class on the classic Greek story The Odyssey, you would search for articles, videos, podcasts, slideshows, tutorials, and any other helpful, educational information about the story.

You also might search for resources about teaching in general -- such as ways to make a lesson more interesting or what materials you could hand out.

Go to your new tab, and type search terms related to your topic into the search bar.

Click on some of the results to see what information might be useful for your topic.

When you find a website that you would like to reference, add a link to it in the Links column of your spreadsheet.

First, copy the URL of the website.

Then, return to your spreadsheet, and type in a description of the website.

Highlight the text, and insert a link by pasting the URL you just copied.

Continue your online research until you've added links to at least three websites.

For some project tasks, you may want to link other types of resources such as a document with speaker notes, or a slideshow your group created about your project topic.

Add those links as well.


Now you have links to online resource and other project materials that you can easily access anytime.

You can also insert links in a spreadsheet in order to have quick and easy access to a list of websites where you like to do online shopping; banking websites that help you keep track of your savings and checking accounts, and pay your monthly bills; or blogs, newspapers, or magazines that you enjoy reading frequently.

Choose an Extension
Add Links to Resources
Use a spreadsheet to keep track of the research you do for your group project so you can easily access it later and cite your sources properly.
Use Conditional Formatting to Show Task Status
Add conditional formatting to your group project spreadsheet.
Check Off Completed Tasks
Create a checklist by adding checkboxes to your project planning spreadsheet.
Invite Group Members to a Meeting
Schedule a meeting, invite people to your meeting, and share a document in your meeting invitation.
Ask for Feedback and Implement Suggestions
Share your project planning spreadsheet with a partner.
Filter Tasks by Owner
Create a filter view in order to clearly and easily see the tasks you own.
See more extensions
Next Lessons Dashboard
Choose one of the videos below to extend the lesson.