Computer Science Semester Bundle

Introduce students to Computer Discoveries with a comprehensive collection of ready-to-use computer science and technology activities designed for Middle and High School students (Grades 6–12).

This curriculum resource bundle explores digital citizenship, cybersecurity, computer hardware, software ethics, internet safety, programming fundamentals, Microsoft Excel, and real-world technology applications.

This Computer Discoveries Unit Planner & Activity Packet Bundle combines 30 individual activity sheet packet topics, 7 Microsoft Excel lessons with quizzes, topic-specific review sessions, basic 20-question tests, and an interactive Excel card game. Students develop foundational technology knowledge while strengthening digital literacy, critical thinking, problem-solving, and computer application skills.

Designed for flexible classroom instruction, these resources can be used independently, combined into instructional units, or incorporated into an existing computer science curriculum. Selected activity packets also include real-world case studies that encourage students to analyze technology-related situations and apply their knowledge.

This bundle provides a practical foundation for teaching Computer Discoveries, Computer Science, Digital Literacy, Technology Education, Cybersecurity, Computer Applications, Introduction to Programming, and CTE in middle and high school classrooms.

━━━━━━━━━━━━━━━━━━━━

WHAT'S INCLUDED

◆ 30 Individual Computer Discoveries Activity Sheet Packet Topics

◆ Vocabulary Activities for Every Activity Packet

◆ Open-Ended Questions for Every Activity Packet

◆ Topic-Specific Quizzes

◆ Real-World Case Studies with Selected Activity Packets

━━━━━━━━━━━━━━━━━━━━

◆ 12 Microsoft Excel PowerPoint Lessons

◆ 12 Microsoft Excel Lesson Quizzes

◆ Microsoft Excel Card Game

━━━━━━━━━━━━━━━━━━━━

◆ Topic-Specific Review Sessions

◆ Basic 20-Question Tests by Topic

◆ Flexible Middle & High School Instructional Resources

Topic Assessment Materials:

◆ Individual Topic Review Sessions covering essential vocabulary, concepts, and practical applications

◆ Basic 20-Question Topic Tests assessing foundational knowledge and understanding

◆ Topic-Specific Quizzes reinforcing key concepts from individual activity packets

Microsoft Excel Assessment Materials:

◆ 7 Microsoft Excel Lesson Quizzes

◆ Microsoft Excel Review Sessions by Topic

◆ Basic 20-Question Microsoft Excel Tests by Topic

◆ Microsoft Excel Card Game for reinforcing spreadsheet terminology and skills

Each Activity Sheet Packet Includes:

Vocabulary Activities • Open-Ended Questions • Topic-Specific Quiz • Key Concepts • Application-Based Practice

Additional Topic Resources:

Review Session • Basic 20-Question Test • Selected Real-World Case Studies

━━━━━━━━━━━━━━━━━━━━

LEARNING OBJECTIVES

◆ Identify common cybersecurity threats, including phishing, computer worms, and digital security vulnerabilities, while explaining how individuals can protect personal information and computing devices.

◆ Explain the importance of digital citizenship, online safety, email netiquette, and responsible technology use in educational, professional, and personal environments.

◆ Examine cyberbullying, inappropriate software use, digital piracy, licensing infringement, and copyright laws while evaluating legal and ethical responsibilities associated with technology.

◆ Analyze the positive and negative effects of social media on communication, education, relationships, personal privacy, and digital well-being.

◆ Identify internal and external computer components, including CPUs, motherboards, RAM, GPUs, power supply units, storage devices, ports, and cables.

◆ Explain how computer hardware components work together to process information, store data, display graphics, and support computer operations.

◆ Investigate workplace technology safety, computer ergonomics, and accident prevention while identifying practices that promote safe and productive computing environments.

◆ Develop foundational programming knowledge using Python and JavaScript concepts, including variables, strings, arrays, Boolean expressions, data types, and conditional statements.

◆ Apply basic Microsoft Excel skills to organize information, enter data, use spreadsheet features, and complete introductory spreadsheet tasks.

◆ Strengthen vocabulary comprehension, critical thinking, and problem-solving through educational activities, open-ended questions, quizzes, review sessions, and topic assessments.

━━━━━━━━━━━━━━━━━━━━

COMPUTER DISCOVERIES UNITS & TOPICS

UNIT 1: DIGITAL CITIZENSHIP, TECHNOLOGY ETHICS & ONLINE SAFETY

◆ Phishing — Explore deceptive emails, fraudulent messages, suspicious links, and social engineering techniques while learning how to recognize phishing attempts and protect personal information.

◆ Cyberbullying — Examine online harassment, harmful digital communication, reporting procedures, and responsible online behavior while identifying strategies for preventing and responding to cyberbullying.

◆ Inappropriate Uses of Software — Investigate unethical and unauthorized software activities while learning how improper technology use can affect individuals, schools, and workplaces.

◆ Licensing Infringement — Explore software licensing agreements, unauthorized installations, and intellectual property rights while understanding the importance of following software usage requirements.

◆ Copyright Laws — Examine copyright protection, intellectual property ownership, fair use, and responsible digital content sharing while learning how copyright laws apply to technology.

◆ Work-Related Accidents — Identify common workplace technology hazards, unsafe equipment practices, and accident prevention strategies while exploring computer-related workplace safety.

◆ Computer Ergonomics — Investigate proper posture, workstation design, monitor placement, repetitive strain, and healthy computer habits while learning how ergonomics improves comfort and productivity.

◆ Digital Piracy — Examine illegal downloading, unauthorized distribution, software piracy, and digital ownership while evaluating the ethical and legal consequences of digital piracy.

◆ Negative Effects of Social Media — Analyze cyberbullying, misinformation, privacy concerns, excessive screen time, and other challenges associated with social media use.

◆ Positive Effects of Social Media — Explore communication, collaboration, educational opportunities, professional networking, and community engagement while evaluating the benefits of responsible social media use.

◆ Email Netiquette — Learn professional email communication, appropriate subject lines, respectful language, message organization, and responsible email practices.

UNIT 2: CYBERSECURITY & COMPUTER PROTECTION

◆ Encryption — Explore how encryption protects digital information, supports secure communication, and helps prevent unauthorized access to sensitive data.

◆ Computer Worms — Investigate computer worms, malware infections, network vulnerabilities, and security practices while learning how malicious programs spread between devices.

UNIT 3: COMPUTER HARDWARE & COMPONENTS

◆ Video Game Hardware — Explore gaming consoles, graphics processing, memory, storage, controllers, and other hardware components that support modern video games.

◆ Internal Computer Components — Identify essential components inside a computer and explain how hardware systems work together to process and store information.

◆ Central Processing Unit (CPU) — Examine the CPU's role in executing instructions, processing data, and coordinating computer operations.

◆ Motherboards — Investigate motherboard components, expansion slots, connectors, and communication pathways while learning how computer hardware connects.

◆ Random Access Memory (RAM) — Explore temporary memory, multitasking, computer performance, and the relationship between RAM and active applications.

◆ Storage Devices — Compare hard disk drives, solid-state drives, flash storage, and other storage technologies while examining capacity, speed, and data retention.

◆ External Computer Components — Identify monitors, keyboards, mice, printers, speakers, webcams, and other peripheral devices used for computer input and output.

◆ Graphics Processing Unit (GPU) — Examine graphics processing, image rendering, video games, and the role of GPUs in modern computing.

◆ Power Supply Unit (PSU) — Investigate how power supply units convert and distribute electrical power to computer components.

◆ Computer Ports & Cables — Identify common connection types, including USB, HDMI, Ethernet, and display connections, while explaining their functions.

UNIT 4: INTRODUCTION TO PYTHON & JAVASCRIPT PROGRAMMING

◆ JavaScript & Python Arrays — Explore arrays, lists, indexed data, and collections while learning how programming languages organize and access multiple values.

◆ JavaScript & Python Boolean Expressions — Investigate true and false values, comparison operators, and logical expressions while understanding how programs evaluate conditions.

◆ Defining Python — Introduce the Python programming language, its common applications, basic syntax, and role in software development.

◆ Python Data Types — Explore integers, floating-point numbers, strings, and Boolean values while learning how Python stores and processes different types of information.

◆ Python If Statements — Investigate conditional statements, decision-making, and program flow while learning how Python executes instructions based on specific conditions.

◆ Python Strings — Examine text-based data, string values, basic string operations, and how Python processes written information.

◆ Python Variables — Explore variable names, assignments, stored values, and basic programming operations while learning how Python manages information.

UNIT 5: MICROSOFT EXCEL & SPREADSHEET APPLICATIONS

This unit introduces students to foundational spreadsheet concepts through 7 Microsoft Excel lessons, individual quizzes, topic review sessions, basic 20-question tests, and a card game.

Suggested Microsoft Excel Lesson Topics:

◆ Lesson A: Introduction to Microsoft Excel — Explore the Excel interface, workbooks, worksheets, ribbons, and basic spreadsheet navigation.

◆ Lesson B: Cells, Rows & Columns — Identify spreadsheet cells, cell references, rows, columns, and ranges while practicing basic worksheet organization.

◆ Lesson C: Entering & Formatting Data — Practice entering text, numbers, and dates while applying formatting techniques to improve spreadsheet readability.

◆ Lesson D: Basic Formulas & Calculations — Introduce formulas, mathematical operators, and basic calculations used in spreadsheets.

◆ Lesson E: Common Excel Functions — Explore introductory functions such as SUM, AVERAGE, MIN, MAX, and COUNT.

◆ Lesson F: Charts & Data Visualization — Create and interpret charts while learning how spreadsheets visually communicate information.

◆ Lesson G: Sorting, Filtering & Organizing Data — Practice organizing datasets, sorting information, applying filters, and identifying patterns.

◆ Lesson H: Conditional Formatting — Apply formatting rules to highlight important values, identify trends, and make spreadsheet data easier to analyze.

◆ Lesson I: Working with Tables — Create and format Excel tables, organize structured data, and explore table features.

◆ Lesson J: Advanced Formulas & Functions — Explore additional spreadsheet functions, cell references, and calculations for solving practical problems.

◆ Lesson K: Data Analysis & Spreadsheet Applications — Use spreadsheet tools to analyze information, compare results, and solve real-world problems.

◆ Lesson L: Practical Excel Projects & Applications — Apply spreadsheet knowledge to create, organize, and interpret worksheets for realistic tasks.

Microsoft Excel Card Game

◆ Reinforces introductory spreadsheet vocabulary, Excel functions, and essential computer application skills through an interactive classroom activity.

━━━━━━━━━━━━━━━━━━━━

TOPIC REVIEW SESSIONS & ASSESSMENTS

Individual Topic Review Sessions

◆ Each activity packet topic includes a clearly identified review session.

◆ Reviews focus on essential vocabulary, important definitions, key concepts, and basic technology applications.

◆ Students revisit major ideas through guided questions, terminology practice, and comprehension activities.

◆ Review sessions may be used independently, in small groups, or during whole-class instruction.

Basic 20-Question Tests by Topic

◆ Each activity packet topic includes a clearly identified basic 20-question test.

◆ Tests focus on essential vocabulary, foundational knowledge, conceptual understanding, and introductory application.

◆ Questions are designed to assess students' understanding of the individual topic rather than multiple unrelated topics.

◆ Topic-based assessments allow teachers to evaluate student learning without requiring a cumulative unit examination.

Topic-Specific Quizzes

◆ Individual quizzes reinforce the vocabulary and concepts presented in each activity packet.

◆ Quizzes provide additional opportunities to assess comprehension before the topic test.

◆ Teachers can use quizzes as classroom assignments, formative assessments, or independent practice.

Selected Case Studies

◆ Some activity packets include case studies involving realistic technology-related situations.

◆ Students analyze problems, identify relevant concepts, and explain possible solutions.

◆ Case studies connect classroom instruction to real-world technology use, digital citizenship, cybersecurity, and computer applications.

━━━━━━━━━━━━━━━━━━━━

TEACHING STANDARDS

Aligned with introductory computer science and digital literacy concepts reflected in the following standards:

◆ CSTA 2-CS-01: Recommend improvements to computing devices based on how users interact with the devices.

◆ CSTA 2-CS-02: Design projects that combine hardware and software components to collect and exchange data.

◆ CSTA 2-NI-04: Model the role of protocols in transmitting data across networks and the internet.

◆ CSTA 2-NI-05: Explain how physical and digital security measures protect electronic information.

◆ CSTA 2-DA-07: Represent and analyze data to support conclusions and informed decisions.

◆ CSTA 2-AP-12: Design and iteratively develop programs that combine control structures and use variables.

◆ CSTA 2-IC-06: Analyze how computing affects personal, ethical, social, economic, and cultural practices.

◆ CSTA 2-IC-07: Identify and evaluate tradeoffs associated with computing technologies and their effects.

◆ ISTE Empowered Learner: Use technology purposefully to support learning, productivity, and problem-solving.

◆ ISTE Digital Citizen: Demonstrate responsible, ethical, safe, and legal behavior when using digital technologies.

◆ ISTE Knowledge Constructor: Evaluate, organize, and use digital information to develop knowledge.

◆ ISTE Creative Communicator: Communicate ideas clearly and effectively using appropriate digital tools.

Standards connections are suggested; teachers should verify alignment with their state and grade-level requirements.

━━━━━━━━━━━━━━━━━━━━

PERFECT FOR

Computer Discoveries • Middle School Computer Science • High School Computer Science • Grades 6–12 • Digital Literacy • Technology Education • Computer Applications • Computer Hardware • Cybersecurity • Internet Safety • Digital Citizenship • Software Ethics • Computer Ergonomics • Python Programming • JavaScript Fundamentals • Microsoft Excel • Spreadsheet Applications • Introduction to Coding • CTE • Technology Electives • Independent Practice • Classroom Assessments • Substitute Teacher Activities • Homeschool Technology Education