Ask a New Question
Menu

Database Creation Choice Board Portfolio



Directions for Creating a Database in Google Sheets

Choose a Topic: Pick one of the topics listed below.

Create a Database: Use Google Sheets to make your database.

Add Items: Include at least 3 items in your database. You can add more if you want!

Save Your File: Make sure to save your work.

Submit Your Work: Upload your saved file to the dropbox.



Assignment Title Assignment Description
Create a Video Game Database Use Google Sheets to list your favorite video games and their details.
Book Inventory Make a database of your favorite books, including titles, authors, and genres.
TV Show Tracker Create a sheet to track episodes of your favorite TV shows and their ratings.
Sports Team Roster Create a database of players on your favorite sports team with their positions.
Personal Interests List your hobbies and interests in a Google Sheets database with a short description for each.

1 answer

Here’s a guide on how to complete the assignment based on one of the topics provided. I’ll create an example for the Book Inventory option. You can adjust the format or details to fit your personal style or other options you might choose.

Example: Book Inventory Database in Google Sheets

Step 1: Choose Your Topic
For this example, we’ll create a database of your favorite books.

Step 2: Create a New Google Sheets Document

  1. Open Google Sheets.
  2. Click on the “Blank” option to create a new spreadsheet.

Step 3: Add Columns for Your Database
At the top of your sheet, create the following column headers in Row 1:

  • Title
  • Author
  • Genre
  • Publication Year
  • Rating (out of 5)

Step 4: Add Items to Your Database
Now, fill in your favorite books. Here’s an example of what your data might look like:

| Title | Author | Genre | Publication Year | Rating | |----------------------------|---------------------|-------------------|------------------|--------| | The Great Gatsby | F. Scott Fitzgerald | Fiction | 1925 | 4.5 | | To Kill a Mockingbird | Harper Lee | Fiction | 1960 | 5 | | 1984 | George Orwell | Dystopian Fiction | 1949 | 4 | | The Catcher in the Rye | J.D. Salinger | Fiction | 1951 | 4 | | The Hobbit | J.R.R. Tolkien | Fantasy | 1937 | 5 |

Step 5: Format Your Database
You can make your database more visually appealing by:

  • Using bold text for headers.
  • Changing the background color of the header row.
  • Adjusting the width of the columns for better readability.

Step 6: Save Your File

  • Click on the “File” menu, then select “Save” or simply rename your document by clicking on “Untitled spreadsheet” in the top left corner and entering a name (e.g., "Book Inventory").

Step 7: Submit Your Work

  • Ensure your work is complete and saved.
  • Go to “File” → “Download” → select “Microsoft Excel (.xlsx)” or “PDF Document (.pdf)” to save it to your device.
  • Upload the saved file to the designated dropbox for submission.

Additional Tips:

  • Feel free to add more items to your database as needed.
  • You can also include additional columns for more details like a short description or personal notes about why you like each book.

By following these steps, you’ll have a complete Book Inventory database ready for submission! If you decide to choose a different topic, just modify the headers and content accordingly.