CICT-CSC Student Profiling via Google Forms, How-to
How to get a working copy of the existing Student Profiling Google Form from CICT
1. Open this link; Google Forms Editor link.
2. Make sure you are signed in to your Google Account, then click the Make a copy button.
Top-right corner, 3-dots
3. Name it with whatever filename you want (as it will appear in your Google Drive), then click Make a copy.
Customization
1. At the top right corner, press the Customize Theme button.
2. To change the header/banner image, click the Image Uploaded button below the Header.
3. You may upload your own header/banner image using the dialog as shown below.
4. Locate your file first and click the Browse button to browse for your file.
Post-editing Part
1. You may now send the form to the students using the Send button from the top-right corner. 
Send button
2. The send dialog will appear, switch to the “link” option to see the form’s URL.
You may also want to use the shortened URL using the option below.
Click the link icon besides the email icon.
Shortened URL
3. After sending it the students and after having them fill-up the forms, you may start to see the Respondents tab as it populates through the whole duration.
Responses tab as it populates
4. Click the Google Sheets icon to view responses on a separate sheet.
View responses in Sheets
5. You can see all the results / respondents in one sheet.
Google Sheet version of the Google Form
6. Click File > Download > Microsoft Excel to download it on your computer.
7. Open the download file in Excel and select the first row by clicking the 1 on the left side.
Downloaded File opened in Excel
8. Once highlighted, find the Editing section under Home then select Sort & Filter and Filter.
Filter option
9. You’ll see the first row with its dropdown menu.
10. Using similar options with the other columns, you can use this to filter out entries or apply your own criteria.
Filter Dropdown Menu under Program
11. Utilizing the Filter option, we can filter out entries and apply our own criteria.
After filtering
12. You may use CICT’s Criteria as shown below.
CICT-CSC Student Profiling Criteria
- ₱ 0-5k only
418 - 206 = 212
- 1st & 2nd Year only
212 - 56 = 156
- No scholarship/grant availed
156 - 18 = 138
- No Wi-Fi
138 - 25 = 113
- Mobile Phone or Laptop only
113 - 9 = 104
1st yr 2nd yr (after separating the two)
72 31
Number of Working Students
6 6
13. Finally, since every student now has the same base profile and background,
they were selected randomly via wheelofnames.com.
14. Profit!
