Assignment
Task: Encode this in a Google Form and have it answered by at least 20 students. Download the
result for we will use the data from Worksheet No. 3
Options
4 Strongly Agree
3 Agree
2 Disagree
1 Strongly Disagree
Statements
1. I am satisfied with my overall experience at Mahabang Dahilig Senior High School.
2. The quality of education provided at the school meets my expectations.
3. My teachers are approachable and supportive.
4. The learning environment (classrooms, facilities, etc.) is conducive to my learning.
5. There are enough opportunities for me to participate in extracurricular activities (e.g.,
sports, clubs).
6. I have positive interactions and relationships with my teachers.
7. My classmates are friendly and supportive.
8. I feel safe and secure within the school premises.
9. The school provides sufficient resources (textbooks, lab equipment, etc.) for my learning
needs.
10. I am happy with the overall support services provided by the school (e.g., guidance
counseling, and student support services).
Worksheet 3
Step-by-Step Guide to Create the Excel Worksheet
1. Open Excel:
o Open Microsoft Excel and create a new workbook.
2. Design the Worksheet Structure:
o Set up the worksheet to accommodate responses from at least 20 students.
3. Header Rows:
o In the first row, create headers for each question and additional columns for
statistical calculations.
Steps to Complete the Worksheet
1. Input Data:
o Each group should input the collected data from their Google Forms into the
worksheet. For example, input "4" for "Strongly Agree," "3" for "Agree," etc.
2. Calculate Sum:
o Use the formula =SUM(B2:K2) in the "Sum" column for each row to calculate the
total score.
3. Calculate Average:
o Use the formula =AVERAGE(B2:K2) in the "Average" column to find the mean
score for each student.
4. Calculate Standard Deviation:
o Use the formula =STDEV.P(B2:K2) (for the population) or =STDEV.S(B2:K2) (for
a sample) in the "Standard Deviation" column.
5. Rank Students:
o Use the formula =RANK(L2,$L$2:$L$21,0) in the "Rank" column to rank
students based on their total scores.
6. Download and Upload Results:
o After completing the worksheet, each group should download the file from
Google Forms, save their results, and then upload the completed Excel sheet to
the designated Google Drive folder.