Computer Science

Using computers safely effectively and responsibly

Skills

File management and organisation

• I can organise my files using appropriate folder structures and naming conventions (Y7)
• I can explain the importance of backing up data and know how to access backup systems (Y7)
• I can use common keyboard shortcuts to work efficiently (Y7)

Online safety and digital citizenship

• I can identify different types of online risks including cyberbullying, inappropriate content, and contact from strangers (Y7)
• I can explain where to seek help and report concerns when encountering problems online (Y7)
• I can describe strategies for protecting my online identity including the use of privacy settings (Y7)

Data security and passwords

• I can create and use strong, memorable passwords for different accounts (Y7)
• I can explain alternative security methods to passwords such as biometric authentication (Y7)
• I can identify phishing attempts and know how to respond appropriately (Y7)

Digital communication

• I can compose and send emails using appropriate language and etiquette (Y7)
• I can use email features effectively including attachments, CC/BCC, and subject lines (Y7)
• I can search and organise emails efficiently (Y7)

Information literacy

• I can use search engines effectively including advanced search techniques (Y7)
• I can evaluate the reliability and accuracy of online information (Y7)
• I can use bookmarks and browser history to manage web browsing (Y7)

Knowledge

• Create and manage an organised folder structure on the school network
• Use appropriate file naming conventions including dates and descriptive titles
• Understand and follow the school's Acceptable Use Policy (AUP)
• Demonstrate knowledge of common keyboard shortcuts for efficiency
• Recognise the key features of cyberbullying and know reporting procedures
• Identify strategies for staying safe when communicating online
• Create strong, memorable passwords using multiple random words
• Recognise and respond appropriately to phishing emails and spam
• Compose professional emails with proper formatting and attachments
• Use email search functions and understand CC/BCC functionality
• Apply effective search strategies using keywords and search operators
• Evaluate website credibility and identify potential misinformation
• Manage browser bookmarks and history for efficient web navigation
• Understand how search engines work including web spiders and indexing

Rationale

This foundational unit has been designed to ensure that students develop essential digital literacy skills before progressing to more advanced computing topics. It establishes critical knowledge about using school technology systems appropriately and safely.

The unit begins with practical file management skills that students will use throughout their education, teaching them to organise work systematically and understand the importance of data backup. Students then explore online safety concepts, learning to identify and respond to digital risks including cyberbullying, inappropriate content, and social engineering attempts.

The unit emphasises the development of strong digital citizenship through understanding password security, email etiquette, and responsible online communication. Students learn practical skills for effective web searching and information evaluation, preparing them to be critical consumers of digital information.

This unit serves as both an introduction to using school technology systems and a comprehensive foundation in digital safety that will support students throughout their secondary education and beyond.

Spreadsheet modelling

Skills

Spreadsheet basics

• I can reference cells using appropriate notation (e.g., A1, B5) (Y7)
• I can create simple formulas using basic mathematical operations (+, -, *, /) (Y7)
• I can use functions including SUM and AVERAGE effectively (Y7)
• I can copy formulas and understand how relative cell referencing works automatically (Y7)

Computer modelling concepts

• I can explain what computer models are and give examples of their real-world applications (Y7)
• I can understand that spreadsheets can be used to build financial models (Y7)
• I can identify the advantages and limitations of using computer models (Y7)
• I can use spreadsheets to represent and solve real-world problems (Y7)

Advanced spreadsheet functions

• I can use relative and absolute cell referencing appropriately (Y7)
• I can apply advanced functions including MAX, IF, and COUNTIF (Y7)
• I can sort and filter data effectively (Y7)
• I can perform "What-if" analysis to explore different scenarios (Y7)

Data validation and formatting

• I can apply conditional formatting to highlight important data patterns (Y7)
• I can use data validation techniques to ensure accurate data entry (Y7)
• I can format spreadsheets professionally for improved readability (Y7)
• I can create and customise appropriate charts to visualise data (Y7)

Automation and efficiency

• I can understand the purpose and benefits of macros (Y7)
• I can record simple macros to automate repetitive tasks (Y7)
• I can assign macros to buttons for easy access (Y7)
• I can select appropriate chart types for different data presentations (Y7)

• Create and format professional spreadsheets with appropriate layout and design
• Understand the difference between formulas and functions and when to use each
• Apply mathematical concepts in real-world business contexts (profit, revenue, costs)
• Use spreadsheet models to explore financial scenarios and make informed decisions
• Understand how computer models are used across different industries and applications
• Implement data validation rules to prevent errors and ensure data integrity
• Create visual representations of data through appropriate chart selection
• Understand the role of automation in improving efficiency and reducing errors
• Apply logical thinking to solve complex problems using spreadsheet tools
• Recognise the importance of accurate data modeling in business decision-making

This unit provides students with essential digital literacy skills through practical application of spreadsheet software, preparing them for both academic and professional contexts. The unit is carefully structured to build confidence and competence progressively, from basic cell referencing to advanced modeling techniques.

The unit begins with fundamental spreadsheet concepts, ensuring all students have a solid foundation regardless of prior experience. Students learn to navigate spreadsheet interfaces, understand cell referencing, and create basic formulas. This foundation is essential for more complex work in later lessons and prepares students for mathematical and scientific applications throughout their education.

The core focus on computer modeling introduces students to computational thinking and problem-solving approaches used across multiple disciplines. By creating a financial model for a television talent show, students engage with real-world business concepts while developing technical skills. This authentic context makes learning meaningful and demonstrates the practical value of spreadsheet skills in professional environments.

The unit emphasises the development of logical thinking and systematic approaches to problem-solving. Students learn to break down complex problems into manageable components, test different scenarios, and evaluate outcomes. These analytical skills transfer beyond computing to support learning in mathematics, science, and business studies.

Advanced features such as conditional formatting, data validation, and macros introduce students to automation and efficiency concepts that are increasingly important in digital workplaces. Students learn to create professional-quality outputs and understand how technology can be used to reduce errors and improve productivity.

This unit serves as a crucial foundation for further study in computing, mathematics, and business subjects, while providing immediately applicable skills for academic work across the curriculum and future professional development.