If I Had a Million
Tech Integration Classroom Project
Subject: Social Studies
Grade Range: 6 - 8
Application: Google Sheets
The process for creating the example spreadsheet using Google™ Sheets is described below. The Completed Project Movie shows what the finished project might look like. The tutorial movies that follow demonstrate, step-by-step, how to construct the "If I Had a Million" spreadsheet using the sample data provided. This project can be easily modified or adapted for other projects where tracking resources might be useful. For a complete project description, including goals, objectives, and materials, see the Project Overview.
What's in a Project?
Each project provides:
- Project activity guide
- Copy of the completed project
- All the resources needed to recreate the example project
- Step-by-step tutorial movies that walk students through the project
- Assessment rubric
Example Project
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length | ||
|---|---|---|---|---|---|---|
| 1. | What the example project looks like : opens video player dialog | 123690 | ||||
|
|
||||||
| This section does not have any training resources. | ||||||
Information for Teachers
This project can be easily modified or adapted for other subject areas or other skill levels.
All example files, an assessment rubric, and information about adapting and extending the example project are included in the resource materials available for download with this project.
Creating Your Own Project
In this online technology project, we will begin by creating a new document in Google™ Docs. We will be learning how to enter, modify, and format data in spreadsheet cells and create formulas to solve routine calculations, as well as track diminishing resources. We’ll also learn how to create, modify, and format a pie chart that graphically illustrates where the resources have been used. Finally, we’ll learn how to print our spreadsheet and chart.
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length | ||
|---|---|---|---|---|---|---|
| 1. | What the example project looks like : opens video player dialog | 123690 | 01m:12s | |||
|
|
||||||
| This section does not have any training resources. | ||||||
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length | |
|---|---|---|---|---|---|
| 1. |  |
Creating a new sheet
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online. 
|
123691 | 00m:23s | |
| 2. | |
Adding a title to your sheet
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123692 | 00m:32s | |
| 3. | |
Creating a header
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123693 | 01m:10s | |
| 4. | |
Set row and column names
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123694 | 02m:20s | |
| 5. | |
Change column widths
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123695 | 00m:37s | |
| 6. | |
Add colors to rows and columns
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123696 | 01m:08s | |
| This section does not have any training resources. | |||||
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length | |
|---|---|---|---|---|---|
| 1. | |
Format font & size
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123697 | 01m:19s | |
| 2. | |
Set cell alignment
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123698 | 01m:28s | |
| 3. | |
Apply number formatting
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123699 | 01m:23s | |
| This section does not have any training resources. | |||||
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length | |
|---|---|---|---|---|---|
| 1. | |
Enter items & prices
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123700 | 01m:22s | |
| 2. | |
Insert a row
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123701 | 00m:43s | |
| 3. | |
Edit existing data
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123702 | 00m:32s | |
| This section does not have any training resources. | |||||
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length | |
|---|---|---|---|---|---|
| 1. | |
Enter a formula to subtotal each category
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123703 | 02m:23s | |
| 2. | |
Create a grand total formula
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123704 | 01m:52s | |
| 3. | |
Create a countdown formula
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123705 | 00m:52s | |
| 4. | |
Format the cells containing formulas
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123706 | 02m:16s | |
| This section does not have any training resources. | |||||
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length | |
|---|---|---|---|---|---|
| 1. | |
Select data
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123707 | 01m:51s | |
| 2. | |
Select a chart type and layout options
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123708 | 01m:27s | |
| 3. | |
Change a chart style
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123709 | 02m:56s | |
| 4. | |
Editing chart options
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123710 | 01m:25s | |
| 5. | |
Sharing a chart
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123711 | 01m:07s | |
| 6. | |
Print options
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
123712 | 01m:24s | |
| This section does not have any training resources. | |||||
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length | |
|---|---|---|---|---|---|
| 1. | |
Project Resources : opens dialog | 1791 | ||
| This section does not have any training resources. | |||||
Share Your Expertise
Have a passion for ed tech? Share it by becoming an eLearning Contributor!
