WorksheetsFinal Examination – COMP 1 – Advanced Computer Application 1
Total questions: 70
Worksheet time: 12hrs 40mins
You need to convert complex financial data into a clear visual story for non-technical stakeholders. Which tool and method combination is MOST appropriate?
MS Word + footnotes
PowerPoint + infographics and charts
Notepad + bullet points
Excel + long text tables
Which of the following best explains how GIS supports crime prevention strategies?
By storing crime records for legal evidence only
By mapping and analyzing spatial patterns to identify high-risk areas
By replacing manual record-keeping in police departments
By tracking social media activities of criminals
A website administrator discovers that someone has registered a domain name similar to a government agency and is using it to mislead users. Which ICT law violation BEST applies?
Illegal access
Computer-related forgery
Cybersquatting
System interference
A company wants to strengthen its employee data protection system. Which principle from the Data Privacy Act (RA 10173) should guide them MOST when designing policies?
Absolute public access to all records
Ensuring confidentiality, integrity, and availability of personal data
Free use of collected personal information
Permanent retention of sensitive data
A student edits someone’s photo, adds defamatory text, and posts it online to damage the person’s reputation. Which combination of laws would MOST apply?
RA 9995 + RA 10175 (Libel)
RA 10173 + RA 9775
RA 8792 + RA 4363
RA 10175 (Cybersex) + MCPIF
To promote youth safety online, a school tightens digital policies to prevent minors from exposure to inappropriate content. Which law MOST supports this initiative?
RA 9775 – Anti-Child Pornography Act
RA 8792 – E-Commerce Act
MCPIF
RA 4363 – Revised Penal Code on Defamation
A hacker did not alter or delete any files but secretly monitored and captured private data transmissions between employees. Which cybercrime classification BEST describes this?
Illegal access
Illegal interception
Data interference
Cybersex
A government office shifts to electronic filing and signing of documents to speed up transactions. What law LEGALLY supports this move?
RA 9775
RA 8792
A blogger exposes government corruption, but a powerful official falsely accuses them of libel to silence criticism. Which law provides digital rights that protect freedom of expression in such cases?
MCPIF
RA 10175 – Cybercrime Law
RA 9775 – Anti-Child Pornography
RA 8792 – E-Commerce Act
A teacher notices a viral video of a student taken inside a restroom without consent and shared online. Which law MOST directly protects the victim in this scenario?
RA 10173 – Data Privacy Act
RA 9995 – Anti-Photo and Video Voyeurism Act
RA 10175 – Cybercrime Prevention Act
RA 8792 – E-Commerce Act
Gloria receives an email that looks like it came from her bank. The email asks her to click a link and “verify her account information” to avoid being locked out. The website looks real, so she enters her username, password, and PIN. Later, she notices unauthorized withdrawals from her account.
Malware
Phishing / Identity theft
Ransomware
Cyberbullying
John downloads what he thinks is a free version of a photo-editing app from an unofficial website. After installation, his computer starts acting slow, and pop-up ads appear constantly. Later, his personal files are encrypted, and a message demands payment to unlock them.
Malware attack / Ransomware
Phishing/Identity theft
Scamming
Virus
Ella posts a picture of herself online. A few classmates start making fun of her appearance and share edited memes about her in a group chat. The messages spread quickly around the school, causing Ella emotional distress.
Online scam / E-commerce fraud
Identity Theft/Fraud
Cyberbullying / Online harassment
Spamming/Scamming
Someone creates a fake Facebook account using Carlo’s name and photos. The impersonator sends messages to Carlo’s friends asking for money, claiming he’s in an emergency.
Cyberbullying / Online harassment
Identity theft / Online fraud
Phishing
Scamming
Liza finds an online store selling branded shoes at a very low price. She pays through bank transfer but never receives the item. When she tries to contact the seller, the page has already been deleted.
Malware
Cyberbullying / Online harassment
Worm
A student from another school hacks into the school’s grading system to change his failing grades. He gains access by guessing the teacher’s weak password.
Hacking / Unauthorized access
Online scam / E-commerce fraud
Ransomware
Trojan worm
An individual creates a fake news post about a celebrity scandal and shares it on social media to gain followers and attention. Many people believe and share it, damaging the celebrity’s reputation.
Phishing
Cyber Libel
Fraud
Scam
Which scenario shows a violation of the Data Privacy Act's penalty on improper disposal of sensitive data?
Throwing shredded documents into a secure bin
Leaving printed medical records in a public cafeteria
Encrypting emails before sending
Backing up files to an external hard drive
A student deletes cookies and uses a VPN to protect online activity. This action mainly relates to reducing risks in which type of surveillance?
Social Media Surveillance
Computer Surveillance
Physical Surveillance
Financial Surveillance
Which scenario best illustrates the diffusive nature of information?
A private diary saved on a locked device
A press release emailed to a subscriber list
A rumor about a celebrity rapidly spreading online
An encrypted file shared between coworkers
Which of the following refers to observing people’s actions in public spaces using tools like CCTV cameras?
Biometric Surveillance
Physical Surveillance
Financial Surveillance
Computer Surveillance
Electronic surveillance mainly involves monitoring through:
Online banking records
Wearable tracking devices
GPS, audio devices, and communication signals
Behavioral analysis
Which surveillance type monitors online searches, browsing history, and cookies?
Social Media Surveillance
Biometric Surveillance
Computer Surveillance
Physical Surveillance
Which technology analyzes personal identifiers such as fingerprints and facial features?
Monitoring posts, comments, likes, and other online interactions is known as:
Computer Surveillance
Social Media Surveillance
Biometric Surveillance
Physical Surveillance
Which of the following is a legal framework relevant to surveillance?
Respect for privacy
Cybercrime laws
Transparency
Proportionality
Which BEST describes an ethical concern in surveillance technologies?
Ensuring accurate data collection
Loss of personal privacy
High cost of equipment
Network bandwidth issues
If a school installs fingerprint scanners for student attendance, which type of surveillance is being used?
Financial Surveillance
Biometric Surveillance
Electronic Surveillance
Social Media Surveillance
A bank flags unusual transactions on a customer’s account. This situation represents which surveillance type?
Computer Surveillance
Social Media Surveillance
Financial Surveillance
Physical Surveillance
When law enforcement uses heat maps to determine areas of high criminal activity, what cognitive process is being applied?
Classification
Analysis
Prediction
Memorization
A criminologist observes that theft incidents increase near bars and nightclubs. Which GIS analysis technique would best verify this relationship?
Cluster analysis
Proximity analysis
Predictive mapping
Choropleth mapping
Which situation demonstrates the integration of Excel and GIS for effective decision-making?
Using Excel to format text reports
Cleaning and summarizing crime data in Excel before mapping in GIS
Plotting maps directly in Excel without GIS
Using GIS to replace all Excel functions
If a criminologist wants to examine how crime incidents change over time, which analysis should they apply?
Financial analysis
Trend analysis
Cluster analysis
Proximity analysis
Why is data cleaning essential before importing a dataset into GIS?
To reduce the file size for faster uploads
To ensure data accuracy and consistency in mapping results
To remove all low-level crime records
To make maps visually appealing
A city police department uses GIS to forecast areas of potential crime based on historical data. What is this process called?
Predictive mapping
Cluster mapping
Choropleth visualization
Buffer zoning
What advantage does a choropleth map provide in crime analysis compared to a point map?
It shows the exact coordinates of each incident
It highlights the density or intensity of crime within geographic boundaries
It provides detailed information about individual victims
It focuses only on time-based data
If law enforcement reallocates patrol units based on GIS-identified hotspots, what kind of decision-making does this represent?
Reactive decision-making
Predictive decision-making
Randomized decision-making
Statistical decision-making
How can GIS and Excel together enhance policy-making in criminology?
By presenting visual and quantitative insights that support evidence-based strategies
By replacing the need for human analysis
By ensuring all crimes are automatically solved
By focusing solely on data collection
What is the primary purpose of word processing software?
To edit and format text-based documents
To calculate numbers
To create presentations
To design graphics
Which key deletes the character to the left of the insertion point?
Delete
Enter
Backspace
Shift
What is the feature that automatically moves text to the next line when it reaches the right margin?
AutoFit
Word Wrap
AutoCorrect
Text Align
What command do you use to save a document with a new name or in a different location?
Save
Save As
Save All
Save Copy
Which of the following is not a document view in Microsoft Word?
Draft view
Web Layout view
Slide Sorter view
Outline view
What orientation is wider than it is long?
Portrait
Landscape
Vertical
Default
Which toolbar contains commands like Save, Undo, and Redo?
Ribbon
Quick Access Toolbar
Status Bar
Menu Bar
To magnify or reduce your document on screen, which feature do you use?
Zoom slider
Page Layout
View buttons
Full Screen View
Where can you preview and print your document in Word 2010?
View tab
Review tab
Print tab in Backstage view
Layout tab
What should you do to exit Microsoft Word completely?
Press Esc
Click the File tab
Click the Close button in the upper-right corner
Click New
If a user repeatedly forgets to save their file and loses progress, which Word feature should they use to prevent data loss?
AutoRecover
Word Wrap
Print Preview
Zoom
Why might a writer choose Full Screen Reading view instead of Print Layout view?
To focus on text without distraction from menus and toolbars
To view page margins and layout clearly
To design the document’s structure
To check for spelling errors
When would it be more effective to use Landscape orientation instead of Portrait?
For letters and essays
For spreadsheets or wide tables
For poems
For short memos
A student accidentally deletes a paragraph. What is the best action to undo the change?
Reopen Word
Press Ctrl + Z
Use the Delete key again
Save the document immediately
How can organizing files into folders improve productivity in Word?
It helps Word run faster
It allows easier access and management of saved documents
It prevents the need for backups
It automatically corrects filenames
You are editing a document and need to view only the main points. Which view is most efficient?
Outline view
Web Layout view
Draft view
Full Screen Reading view
A teacher wants to display a report in class and ensure that the students can read the text from a distance. Which feature should they adjust?
Zoom level
Page orientation
File tab
Status bar
If a document looks different when printed than on screen, what step should you take before printing again?
Change to Full Screen Reading view
Use Print Preview to check layout and margins
Restart Word
Adjust Zoom to 100%
You’re asked to design a template that others can use for reports. Which action demonstrates application of knowledge in Word?
Creating and saving the template in .docx format
Typing the report manually each time
Deleting previous files
Printing an existing report
A student argues that using the keyboard is faster than the mouse for editing text. Which reasoning supports this claim?
Keyboard shortcuts reduce hand movement and save time
The mouse always causes errors
Word doesn’t allow editing with a mouse
The keyboard is used only for typing, not editing
You can show your slides by doing these, EXCEPT ____________________________.
Click the Slide Show tab and click “From Beginning”
Press F5 at the keyboard
Press Alt F4
Click the Start from the Beginning button in the quick access toolbar
It can be applied to text boxes, bullet points, and images so they move on the slide during a slide show.
Slide show
Transition
Animation
These are the motion effects that occur in Slide Show view when you move from one slide to the next during a presentation.
Slide transition
Animation
Design
Slide Show
It is a presentation-based program that uses graphics, videos, etc. to make a presentation more interactive and interesting.
MS Excel
MS PowerPoint
MS Word
MS Publisher
What is a native PowerPoint file format?
.doc
.ppt
.psd
.jpeg
Control keys for erasing doodles during slideshow.
Press E
Press W
Press B
Press M
What do we call the unique name of the cell that we can see in name box?
Active Cell
Cell Reference
Columns
Formula
It is a grid of rows and columns in which you enter text, numbers, and the results of calculations.
Spreadsheet
Worksheet
Workbook
Work
Rozy wants to see the cell reference or the name of the active cell she clicks. Where she can see it?
Active Cell
Name Box
Formula
Formula Bar
It is the intersection of a row and a column.
Rows
Columns
Cell
Sheets
It is the spreadsheet program in Microsoft Office.
Microsoft Excel
Microsoft Word
Microsoft PowerPoint
MS Publisher
It appears vertically and are identified by letters.
Rows
Columns
Cell
Sheets
