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.

Week 4 - Google Forms: Types of question in a form

Class objective:

Identify different data collection tool (such as questionnaires, interviews, and digital forms) and recognize how to combine open-ended and closed-ended questions within them.

Class Agenda 

Let's talk a little about what we'll achieve today...

1. Introduction: “Have you ever answered an online quiz or survey? Did you enjoy it or was it boring?” 
2.  Short review: What is Google Forms?
1. Do you know what data collection means or how it can be carried out? 
2. What are the most common methods? 
3. Explanation: Open-ended vs. Closed-ended Questions.
1. Tips for writing good questions (clear, specific, avoid confusion).
2. Demonstration: How to insert question types in Google Forms (short answer, paragraph, multiple choice, checkboxes, dropdown).
4. Activity – "How Well Do You Know Me?"  (posted in Classroom).
5. Take notes in your notebook