Font size
WorksheetsSummative Test - Comp1
Total questions: 80
Worksheet time: 43mins
Based on the requirements for documents utilizing word processing tools, which font and size combination must typically be used to set up a professional report?
Arial, size 11
Calibri, size 12
Times New Roman, size 12
Times New Roman, size 14
To insert the required header, "NAGA COLLEGE FOUNDATION, INC. S/Y 2025-2026," which sequence of tabs must you click in MS Word?
Home → Layout → Header
Review → Insert → Header
Insert → Header
References → Insert → Header
In the preparation of a Crime Report, which textual element must be center-aligned according to common formatting instructions?
The NAGA COLLEGE FOUNDATION Header
The Owner's Name
The CRIME REPORT title
The Item Details table
When analyzing crime statistics, to compute the total number of incidents reported across all months, which Excel function should be correctly implemented?
=COUNT(range)
=AVERAGE(range)
=MAX(range)
=SUM(range)
To determine the value average of crime incidents over a specified range of cells, which fundamental Excel function is used?
=TOTAL(range)
=SUM(range) / Count(range)
=AVERAGE(range)
=COUNTIF(range)
The primary distinction between an Excel formula (e.g., =A1+A2+A3) and an Excel function (e.g., =SUM(A1:A3)) is that:
Formulas must start with an equal sign, but functions do not.
Functions can only operate on one cell at a time.
Functions are predefined formulas that eliminate laborious manual entry of calculations by using human-friendly names.
Formulas are only used for text-based data.
Why is it professional practice to make key words like "Case:", "Date:", and "Location:" bold in the body of a crime report?
To ensure the text size is increased.
To comply with the center-alignment requirement.
To emphasize key details and improve the document's readability
To automatically insert the correct date.
If a user fails to start an entry in an Excel spreadsheet with the required equal sign (=), what is the likely outcome?
The entry will automatically be converted into a function.
The cell will automatically correct the omission.
The formula will still run but produce an error code.
The entry will be treated as plain text or a label, as a formula must always start with an equal sign.
When creating a comprehensive report in MS Word, which sequence of clicks is necessary to add a citation or reference source?
Home → References → Insert Source
References → Insert Citation → Add New Source
Insert → References → Citation
Layout → References → Book
After typing the required text for the footer, "This report follows police procedures," what specific instruction must be followed regarding its placement and style?
Ensure it is left-aligned.
Ensure it is right-aligned.
Ensure that it is center-aligned
Apply bold formatting to the text.
What mandated step in MS Word serves as the primary mechanism for quality control, designed to ensure the document meets professional standards before submission?
Adding a Footer
Creating a Simple Table
Clicking Review → Spelling & Grammar
Changing the font to Times New Roman
To visualize the decline or rise of crime rates over a decade (e.g., 2015 to 2025), which data visualization tool is most appropriate to illustrate this trend?
Bar Graph
Pie Chart
Scatter Plot
Line Graph
Which visualization type is specifically used to show what percentage of total cases fall into categories such as drug-related crimes, violent crimes, or property crimes?
Bar Graph
Pie Chart
Line Graph
Scatter Plot
If you wanted to use a Bar Graph to analyze crime statistics, which type of data comparison is this chart best suited to illustrate?
The proportion of property crimes to violent crimes.
The total number of incidents reported annually.
The number of theft, assaults, and robberies reported in different months or by different departments.
The average severity of crimes.
If you wanted to quickly count how many cells in a specific column contain any value (text or number), which function must you use?
=COUNT
=SUM
=COUNTA
=MAX
The COUNT function in Excel is explicitly designed to count cells in a given range that contain which specific type of data?
Text values
Both text and numeric values
Only numeric values
Dates and times
If you needed to find the earliest recorded date or the lowest reported incident count within a column of crime statistics, which function should be utilized?
MIN
MAX
COUNT
SUM
Why is calculating the aggregated value, such as the SUM of incidents per month, necessary before creating a Line Graph of "Monthly total incidents trend"?
Because the Line Graph only accepts text data.
Because the Pie Chart requires this data.
To find the average number of incidents.
To determine the single aggregated value (total) for each point on the time axis.
Which criterion from a typical crime statistics analysis rubric assesses whether the formulas and functions were applied correctly to the proper cells?
Data Organization & Formatting
Graph Quality & Relevance
Interpretation & Analysis
Accuracy of Functions Used
What is the primary function of MS Excel in the context of advanced computer applications?
Creating documents for printing
Designing presentation slides
Storing, organizing, and analyzing information
Writing code for programs
A criminologist needs to classify suspects based on age. To create a new column 'Age Group' classifying suspects as 'Youth' (under 25), 'Adult' (under 40), or 'Senior' (40 and above), which nested function must be used?
=IF(E2<40,"Adult", "Senior")
=SUM(E2)
=IF(E2<25,"Youth",IF(E2<40,"Adult","Senior"))
=COUNTIF(E2<25)
During the data cleaning and preparation process, why is fixing inconsistent spellings (e.g., 'robbery' vs. 'robby') and removing duplicates is critical?
They allow the use of alternating colors in the table.
They ensure that categorization and counts (like crime type) are accurate and consistent.
They are only necessary for downloading the file as a .csv.
They help in preparing the presentation slides.
The importance of Standardizing Data Formats (e.g., ensuring all dates look consistent like 01/05/2023) is primarily justified because it:
Simplifies the sorting process by age.
Makes the file easier to download as a CSV.
Is crucial for accurate analysis, data comparison, and trend charting.
Prevents unauthorized access to the data.
When performing data manipulation in Excel, which procedure is specifically designed to remove repeated records from the dataset?
Applying a filter
Highlighting the Date column
Use Remove Duplicates (Data tab)
Using the AVERAGE function
The data manipulation technique that involves arranging data in a specific order (e.g., alphabetically A-Z, or chronologically oldest to newest) is known as:
Filtering
Sorting
Cleaning
Standardizing
If a criminologist wanted to focus exclusively on crime incidents that occurred in a "Market Area" using data handling techniques, what action must be taken?
Sort the Suspect_Age from youngest to oldest
Sort by Crime_Type
Filter by Location = "Market Area"
Remove Duplicates
Which characteristic is a fundamental limitation of using the CSV (Comma-Separated Values) file format for data storage and sharing?
It is not human-readable.
It does not support any text.
It cannot store formatting like colors or formulas, and cannot store multiple sheets.
It is not compatible with Google Sheets.
In the context of Geographic Information Systems (GIS) in Criminology, what is the primary purpose of this technology framework?
To protect systems from malware and other threats.
To maintain confidentiality, integrity, and availability of information.
To visualize crime patterns, identify hotspots, and support law enforcement decisions.
To detect and block cyber threats targeting user devices.
In GIS, which type of spatial data is best described as representing exact locations, such as individual crime incident sites?
Vector Data: Polygons
Raster Data
Vector Data: Lines
Vector Data: Points
Which technique uses color-coding to display crime rates across geographical regions or boundaries?
Crime Heat Maps (Kernel Density Estimation)
Buffer Analysis
Spatial-Temporal Analysis
Thematic Mapping
The use of CSV files in criminology is supported by the advantage that it is "Universal," meaning:
It supports complex data types.
It is supported by multiple platforms including Excel, Google Sheets, databases, and programming languages.
It can store multiple sheets.
It maintains complex formatting.
If a law enforcement agency uses GIS to examine correlations between crime rates and external factors such as poverty, lighting, or unemployment in a neighborhood, which spatial analysis technique are they employing?
Buffer Analysis
Thematic Mapping
Crime Heat Mapping
Regression Analysis
The process defined as "bridging data into Excel (from a text file, CSV, or database)" is known as:
Data Cleaning
Data Visualization
Data Import and Exploration
Data Standardization
Which of the following best describes the specific function of Buffer Analysis in crime mapping?
Tracking how crimes vary across different time periods.
Examining correlations between crime and social factors.
Studying the area immediately surrounding a specific crime hotspot (e.g., within 500m).
Using color-coding to display crime rates by region.
A key use case for the CSV file format in criminology is:
Creating large, formatted legal documents.
Storing survey data (e.g., age, gender, crime type).
Designing high-quality graphical presentations.
Running complex financial simulations.
What type of spatial data is composed of a grid of cells (pixels), and examples include Satellite imagery, land use maps, and Heat maps?
Vector Data: Polygons
Raster Data
Vector Data: Lines
Spatial-Temporal Data
Why is CSV considered "Human-readable"?
It supports complex data types.
It maintains colors and fonts.
You can open it easily with a basic text editor like Notepad.
It can store formulas.
Which analysis technique tracks how crimes vary by both time and location simultaneously?
Regression Analysis
Buffer Analysis
Spatial-Temporal Analysis
Thematic Mapping
The data handling technique that involves showing only the rows that meet specific criteria (e.g., only cases of “Theft”) is defined as:
Sorting
Standardization
Data Cleaning
Filtering
When designing visualizations (charts) for data analysis, what step is crucial for making the visualization clear and meaningful?
Creating only one chart type.
Using alternating colors in the raw data table.
Editing chart titles for clarity
Highlighting the entire dataset.
Which term describes malicious software designed to damage or exploit any programmable device, service, or network?
Ransomware
Phishing Attacks
Man-in-the-Middle (MitM)
Malware
When developing a personal cybersecurity plan using MS PowerPoint, which information is explicitly required to be included in the footer of the Master Slide design?
The total number of slides
The names of the 3 common cybercrimes
Your name, course, and date
The name of the instructor
In cybersecurity, why is "Lack of User Awareness" considered a significant vulnerability?
It blocks users from accessing a network.
It prevents the installation of antivirus programs.
Users are not being informed or trained about cybersecurity best practices, making them susceptible to social engineering or poor security habits.
It is an error or flaw in the code of a program.
The main goal of Network Security (securing computer networks with tools like intrusion detection systems and firewalls) is to:
Fix software bugs.
Maintain confidentiality, integrity, and availability of information.
Prevent unauthorized access or misuse of network resources.
Detects and blocks cyber threats targeting user devices.
Phishing involves deceptive emails prompting users for personal information. Which security strategy directly addresses this threat by enabling users to recognize and avoid scams?
Least privilege principle
Data Encryption
Security Training Awareness
Regular System and Software Updates
Why are passwords that are easy to guess or commonly used, such as "123456," categorized as a vulnerability?
They inherently contain malware.
They are Weak Passwords, compromising the verification of user identity, which is essential for strong authentication methods.
They specifically exploit software bugs.
They automatically activate Denial-of-Service attacks.
Which security strategy aims to fix known security weaknesses (vulnerabilities) promptly by keeping software up to date?
Multi-Factor Authentication (MFA)
Least privilege principle
Data Encryption
Regular System and Software Updates (Patching vulnerabilities)
According to the rubrics for creating a cybercrime awareness infographic (Activity 6), which criterion carries the highest point value (40 points) and assesses the content's alignment with criminal justice studies?
Organization & Explanation
Canva Design Quality
Relevance to Criminology
Use of limited text only
When creating the PowerPoint Infographic, what critical piece of content must be included regarding cybercrimes?
A short promise regarding strong passwords
Their effects on victims or society
A list of 10 cybercrime comments
The rubrics criteria
Information Security (or Data Security) focuses on maintaining which three key concepts regarding information?
Access, Monitoring, and Training
Network, Endpoint, and Cloud
Confidentiality, Integrity, and Availability
Hacking, Scams, and Identity Fraud
Why is the required use of the Master Slide design in MS PowerPoint a specific instructional step in the rubric?
It guarantees the submission is successful.
It helps define the content accuracy.
It ensures a professional, consistent layout and color theme is applied across all slides.
It is used to save the file correctly.
When designing a cybercrime awareness infographic, what specific instruction must be followed regarding the use of textual content?
Use 10-15 short comments.
Use 500 words minimum.
Use limited text only, relying on icons, warning signs, or brief phrases.
Ensure the text is center-aligned.
Man-in-the-Middle (MitM) attacks involve intercepting communication between two parties. What specific risk does this pose?
Blocking access to internet-based services.
Attackers intercepting login credentials, financial details, and other confidential data.
Taking control of a victim's files for ransom.
Exploiting outdated software.
A slide detailing how a user protects themselves online by creating and managing a strong password directly supports which security strategy?
Backup and Recovery Planning
Use Strong Authentication Methods
Network Security Practices
Least privilege principle
Which cybersecurity domain focuses on protecting data, applications, and infrastructures in environments often accessed via the internet, utilizing tools like multi-factor authentication and encryption?
The requirement to use SmartArt, icons, or shapes in the PowerPoint infographic supports the goal of:
Making the information complex and detailed.
Making the infographics visually clear, creative, and informative.
Ensuring compliance with the Data Privacy Act.
Setting up a data dashboard.
Which characteristic accurately describes Ransomware?
An attack that blocks users from accessing a machine or network.
An error or flaw in the code of a program.
A type of malware that takes control of a victim’s files or systems and asks for a ransom to regain access.
Deceptive emails that prompt users to enter personal information.
What must be the required title of the final slide in the Personal Cybersecurity Plan (Part 4)?
Infographic Quality
Submission Requirements
My Cybersecurity Commitment
Strong Password Management
What is the main security risk associated with using Unsecured Networks (like public Wi-Fi without passwords)?
Denial-of-Service attacks.
Unsecured networks are internet connections without proper protection, making them a vulnerability.
Forgetting system updates.
Incorrect use of formulas.
The Personal Cybersecurity Plan includes a slide on "How do you respond to suspicious messages or scams." This directly aligns with preventing victimization from which common threat?
Software Bugs
Unauthorized Access
Phishing Attacks
Outdated Hardware
Republic Act No. 10173, or the Data Privacy Act of 2012, was enacted primarily to protect what?
The physical infrastructure of government offices.
The intellectual property rights of software developers.
The jurisdiction of the National Privacy Commission.
The personal information of an individual collected and processed whether in the government or private sector.
According to the Data Privacy Act (DPA), which of the following is explicitly categorized as Sensitive Personal Information?
Full name
Address
Date of birth
Religious beliefs or political affiliations
Under what condition must foreign entities comply with the DPA's requirements, even if they are located outside the Philippines?
If they only process financial information.
If they are protected by the law of their foreign jurisdiction.
If they use equipment located in the Philippines or have an office, branch, or agency there.
Only if they violate the right to access.
What is the penalty for Concealment of Security Breaches involving sensitive personal information?
Imprisonment of six (6) months to two (2) years.
Fine not less than PHP 2,000,000.00.
Imprisonment of one (1) year and six (6) months to five (5) years and a fine of not less than PHP 500,000.00 but not more than PHP 1,000,000.00.
Imprisonment ranging from one (1) year to three (3) years.
Which persona involved in data processing is defined as the person or entity authorized to process personal data on behalf of a controller?
Data Subject
Data Owner
Personal Information Processor
Personal Information Controller
The DPA grants the Data Subject the Right to Object. This right allows the individual to:
Claim compensation for damages.
Receive personal information in a commonly used format.
Object to the processing of their personal information for certain purposes.
Request a copy of the personal information held about them.
In the context of data ethics in criminology research, why is the step "Secure storage and responsible sharing of criminological data" necessary?
To comply with the universal format of CSV files.
To ensure confidentiality, protect identities of victims/suspects, and comply with data protection laws.
To make sure all data is classified as property crime.
To automatically delete all duplicates.
Which penalty applies specifically to the act of knowingly or negligently disposing of personal information in an accessible area without safeguarding privacy?
Malicious Disclosure
Concealment of Security Breaches
Unauthorized Processing
Improper Disposal of Personal Information,
Which of the following personal information processing categories is explicitly listed as an exemption to the Data Privacy Act of 2012?
Biometric data
Location data
Financial information
Personal information processed for journalism, art, literature, or research purposes.
What is the key advantage of the CSV format described as "Human-readable"?
It supports complex data types.
You can open it easily with a basic text editor like Notepad.
It can store multiple sheets.
It maintains complex formatting like colors and fonts.
If a Data Subject finds inaccuracies in their personal information being processed, they are entitled to which specific right under the DPA?
Right to be informed
Right to erasure or blocking
Right to file a complaint
Right to rectify
Unauthorized Processing of Personal Information (Section 25) without consent is punishable by what range of imprisonment and fine?
Six (6) months to two (2) years, and a fine up to PHP 500,000.00.
One (1) year to three (3) years, and a fine from PHP 500,000.00 to PHP 2,000,000.00.
Three (3) years to six (6) years, and a fine up to PHP 5,000,000.00.
One (1) year and six (6) months to five (5) years, and a fine up to PHP 1,000,000.00.
What is the defined purpose of the Data Subject's Right to Data Portability?
To claim damages from a privacy violation.
To ensure compliance with ethical reviews.
To receive personal information in a commonly used format for easy transfer to another service provider.
To access a copy of the data.
The DPA defines Malicious Disclosure as disclosing false information about personal information with malice or bad faith. The penalty for this offense is imprisonment ranging from:
One (1) year to three (3) years.
One (1) year and six (6) months to five (5) years.
Six (6) months to two (2) years.
Three (3) years to six (6) years.
Which category of public authorities is explicitly listed as benefiting from an exemption regarding information needed for their functions under the DPA?
Banks and financial institutions for anti-money laundering compliance.
Residents of other countries.
Monetary authorities and law enforcement.
Individuals working under contract for government institutions.
Why is securing Biometric Data (like fingerprints or facial recognition data) highly prioritized and protected under the DPA?
It is exempt from the DPA.
It is classified as Sensitive Personal Information.
It is exclusively handled by a Personal Information Processor.
It is defined as Basic Personal Information.
Which file format is universally used in criminology for storing tabular data such as survey responses (age, gender, crime type) and recording case files, due to its simplicity and compatibility?
MS Word Document
MS PowerPoint Presentation
CSV (Comma-Separated Values)
Google Sheets
The DPA defines the Personal Information Controller (PIC) as:
An individual whose personal information is being processed.
A person or entity authorized to process data on behalf of a controller.
A person or organization that controls the collection, processing, or use of personal information.
The person responsible for securing storage of data.
According to the DPA, what right allows a data subject to know exactly how their personal information is being collected, processed, and used?
Right to access
Right to object,
Right to be informed
Right to file a complaint
What is the maximum penalty for a Combination or Series of Acts involving unlawful acts defined in Sections 25 to 32?
Imprisonment of one (1) year to three (3) years.
A maximum fine of PHP 1,000,000.00.
Imprisonment ranging from three (3) years to six (6) years and a fine of not more than PHP 5,000,000.00.
A maximum fine of PHP 2,000,000.00.
