Class notes
Lecture 1-16 Notes
- Course
- Institution
These notes are really detailed and hold a lot of information. That will be useful for school and helping you study for the class.
[Show more]
Seller
Follow
Content preview
Google Workspace: SheetsCTE 1210
This lesson is designed for students to learn how to create & format spreadsheets using Google Sheets. In this
lesson, students will:
● Build, organize, and format spreadsheets
● Evaluate and interpret data
● Use filters, functions, and charts to organize data
What to do: Using this file, follow the steps below to complete the work. Add your responses directly to this doc
and submit this doc back to Blackboard when finished. Please make sure you are using your UCM Google
Account, not a personal account!
Step 1: Watch the following video and complete the tasks below: Introduction to Google Workspace: Sheets
1. Log into your UCM Google account
2. Make a copy of this starter file.
3. Rename your project using your last name and course section. Example: Gremaud_CTE 1210 online
Step 2: Watch the following video and complete the tasks below: Duplicating Sheets & Adding Data (4 points)
1. Duplicate the sheet in a new tab.
2. Rename the new tab and change the color.
3. Insert a row and add data to it. Highlight the row you inserted.
4. Why is it important to duplicate your original data?
a. Its important to duplicate the original data because you maybe accidentally delete it or
something happens and that way you wouldn’t lose all of the work you have done.
Step 3: Watch the following video and answer the questions below: Formatting & Organization (10 points)
1. Insert two rows above row 1 to create category headers.
2. Label and format the headers as the video shows. Be sure you:
a. Update cells and make them bold
b. Merge cells
3. Change the date format in Column A.
Step 4: Watch the following video and complete the tasks below: Formatting and Organizing ( 22 points)
1. Insert a new column to the left of Column A
2. Freeze the new column A
3. Title the new column. Make sure the formatting matches your other columns.
4. Number the rows.
5. Add borders between the columns and fill your title rows with color.
6. Make the borders in row 1 clear.
7. Add another title in Row 1 and format as you did your other title rows.
8. Resize your columns to fit your data.
9. Delete the columns that have no data.
10. Why would you want to freeze a row or column?
a. Well you would click on the column you want to freeze then go to view tab and click on the
freese button and click on 1 row or 1 column and it would freeze it
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller madelynhed2002. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
51292 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 15 years now