Week 12/13 - Google Sheets Fundamentals & Data Formatting

CLASS OBJECTIVE

Learn how to navigate the basic structure of Google Sheets (cells, rows, and columns) to create a personal information table, and apply formatting techniques such as alignment, merging, borders, fill color, font styles, and number formats to make data clear and readable. 

INTRODUCTION

Have you ever seen a messy table that’s hard to read? we call this situation as a raw table because we have missing elements like header, format, colors or desing. 

Today, you’ll learn how to make your spreadsheet look professional using the very basic elements to make useful and complete the data in a table .

Anatomy of a Spreadsheet

Before modifying data, you must understand the five primary components of Google Sheets:

Cell: The individual box where a row and column intersect (e.g., A1, B2). It holds a single piece of data.

Row: The horizontal group of cells identified by numbers (1, 2, 3...).

Column: The vertical group of cells identified by letters (A, B, C...).

Data: The text, numbers, dates, or symbols entered into a cell.

Formula Bar: The bar at the top of the sheet used to view, enter, or edit data and formulas in the active cell.

CELL FORMATTING TOOLS 

Alignment: Controls the position of text inside a cell horizontally (Left, Center, Right) and vertically (Top, Middle, Bottom).

Merge Cells: Combines two or more adjacent cells into one larger cell (commonly used for main headers).

Wrap Text: Adjusts long text to wrap onto multiple lines inside a cell so it fits without overflowing into neighboring cells.

Borders: Adds visible lines around, inside, or between cells to define table structure.

Fill Color: Changes the background color of selected cells to emphasize key information or group columns.

FONT FORMATTING

Font Type: The style and family of the text (e.g., Arial, Roboto, Calibri).

Font Size: The scale of the text (larger sizes for main headers, standard size for table body).

Bold / Italic / Underline: Text decorations used to create visual hierarchy and highlight key labels.

Text Color: Changes the color of the characters inside the cell.

NUMBER FORMATTING

Currency ($): Formats values as monetary amounts with currency symbols and two decimal places.

Date Formats: Formats numeric entries into standardized calendar dates (MM/DD/YYYY or YYYY-MM-DD).

Percentage (%): Multiplies the cell value by 100 and appends a % sign.

Decimal Places: Increases or decreases the number of visible digits after the decimal point.

CLASS NOTES

Take notes and answer these questions in your notebook

Why is formatting important in a spreadsheet?

What does “merge cells” mean?

What is the difference between text format and number format?

How can color and borders help readers understand your data?

Week 11 - Spreadsheet Presentation / Exam Review

 OBJECTIVE OF THE CLASS

To learn the key elements and procedures in an electronic spreadsheet , learn what a spreadsheet is and identify its basic elements (cells, rows, columns, data types, toolbar, and formulas) in order to understand how spreadsheets can organize and analyze information easily.

BEFORE WE BEGIN...

Let’s review the results of your summative assessment together to identify what you have mastered, as well as the areas that (even though you may have encountered or worked on them) still require further attention. Let’s take a look at the results.

NOTE: REMEMBER TO CREATE A COVER PAGE FOR THE TERM, PLACING IT IMMEDIATELY AFTER YOUR GRADE BREAKDOWN.

WHAT IS AN ELECTRONIC SPREADSHEET?

It is a type of file organized as a grid, where various kinds of information (such as text, numbers, dates, and links) can be stored. Furthermore, as the name suggests, it allows for simple arithmetic calculations to be performed using operators or functions. It is also a tool that enables us to organize and locate information, as well as create various types of charts and graphs.

The primary elements of a spreadsheet are cells, columns, and rows. Each of these has a unique name that allows us to identify it. How do we determine the name of each of these elements?

📌 KEYWORDS

Spreadsheet: A digital table used to organize and calculate information.

Cell: The intersection of a row and column.

Row: A horizontal line of cells.

Column: A vertical line of cells.

Formula: A rule or operation used to calculate values.

Data: Information entered in the spreadsheet.

Toolbar: The area with icons and commands to edit the sheet.

Sheet tab: The name and section of each spreadsheet inside a file.

AutoSum: A tool that automatically adds selected numbers.

Remember that columns are vertical sets of cells identified by letters, while rows are horizontal sets identified by numbers.

Week 9 - Period 1 Final Review

OBJECTIVE OF THE CLASS

Consolidate knowledge of creating, organizing, and configuring Google Forms by practicing all previously learned skills in different short challenges and a final integrated project.

FINAL REVIEW GOOGLE FORM

It’s time to review all the topics and activities covered and put what you have learned into practice by creating a form using the skills you have acquired. For this activity, you are free to choose the topic of your form. It could be a short horror story, a “Guess the Character” quiz, or any other topic you enjoy, as long as you meet all the requirements specified in the activity.

WHAT SHOULD I PUT IN MY REVIEW FORM?

You can use AI to help you come up with a short horror story idea to create sections in a Google Form using a “Choice and Consequence” format, also you can create a game like a "Guess Who?" mode.

WHAT MY FORM MUST INCLUDE (What you need to practice)

Take the list of this activity in your class room as a guide, Good luck!!!

Week 7-8 Sections, Responses and Final configurations

OBJECTIVE OF THE CLASS

Create and organize the sections of a form, as well as its submission, using Google Forms to develop technical skills in designing clear and functional forms, understanding the importance of structuring information logically and efficiently.

HOW TO ADD SECTIONS IN GOOGLE FORMS (Organize questions in my form)

To create a section in your form, click the Add section icon, which looks like an equal sign, from the question menu.

 

When you activate a section in a form you can add a name at the beginning to identify that it is another part of your form.

 You can also add new questions and drag them between sections, if necessary. This is handy because it allows you to write your questions first and worry about sorting them into the appropriate sections later.

As you create the form, every section will appear together on one page for easier editing.

If you want certain people to see only certain sections of your form, you can. The simplest way to do this is by creating a multiple-choice question, then setting rules based on the answer provided.

 

In class we are going to create an example together.

Class Notes

Now is the time to recall the process by answering in your own words and drawing on your class experiences:

1. In your opinion, what is the main function of creating sections in a form?
2. What is the process for creating sections? (write your process step by step)
3. Now that I have sections in a form, how can I direct the user to a specific section or control which section they go to based on their answer?
4. What is response validation, and what is it used for?

Week 5-6 Google Forms – Form Settings and Responses

CLASS OBJECTIVE

Learn how to access and analyze responses in Google Forms and configure settings such as response limits, editing permissions, and quiz options in order to make forms more efficient and secure.




CLASS AGENDA:

• Introduction: “Have you ever sent a form and then realized people could answer it multiple times or edit their answers?”

1. Short Review: How to create Sections creating a survey with checkbox,  options , list and other examples from last class.

2. Explanation:

• How to view and analyze responses (summary, individual, spreadsheet)
• How to configure settings:
• Limit to one response per person.
• Allow or prevent editing answer.
• Activate quiz mode (optional).
• Why settings matter for surveys, quizzes, or registration forms.

3. Demonstration:

• How to open the responses tab and adjust settings step by step.
• Made a short example with your teacher.

4. Activity – “SOCIAL MEDIA RISKS” (posted in Classroom).

5. Take notes in your notebook.





📓 NOTES IN YOUR NOTEBOOK

• Answer these questions in your notebook:

1. How can response settings make a survey more reliable?
2. When would you use “limit to one response”?
3. How could response data help in real school projects?
4. Why is it important to control how people answer a form?

📌 KEYWORDS

• Responses: The answers collected from people who complete your form.
• Summary View: A visual display of all collected answers.
• Individual View: Shows one respondent’s answers at a time.
• Spreadsheet: A linked Google Sheet that stores all responses.
• Settings: Options that define how your form behaves and how users can respond.
• Limit to one response: Restricts users from submitting more than once.
• Edit after submit: Allows users to modify their answers after submission.
• Quiz mode: Turns your form into an automatic quiz with points.
• Permissions: Rules that define who can access, answer, or edit your form.