Title of assessment:
Becoming a Digital Citizen
Skills assessed:
Folder structure, emails, types of computer hardware and different type of computer software.
Key learning:
To know the importance of a good folder structure
To investigate how email works and why we use it every day.
To understand what hardware is and be able identify a range of pieces of hardware.
explain the difference between system and application software and explanations to why and in what situation we would use these.
Title of assessment:
Advanced spreadsheet
Skills assessed:
Spreadsheet calculations, data valuation, charts and V look up
Key learning:
Understand what spreadsheets are and what they are used for in the outside world.
Spreadsheets contains formatted data and multiple formulae used to calculate totals of our holiday items
Spreadsheet contains more advanced functions to work out averages, minimum and maximum numbers of our items total costs
Add advanced functions into your model. Apply data validation independently and create hyperlinked buttons.
To create IF statements on famous faces spreadsheet, to apply conditional formatting to your if statement cells
Create a number of charts using data from our model. We will format our chart with clear labels
Create a V Looks up function in our model Create a summary worksheet on it will contain hyperlinked buttons to print our model in a variety of ways
Title of assessment:
Computer Science
Skills assessed:
Binary conversion, binary calculation, image manipulation, binary logic gates, IPO system, computer networks,
Key learning:
Be able to explain binary and Looks at hexadecimal independently
Be able to convert binary numbers to denary numbers
Develop an understanding of how images are represented using binary and how storage space differs depending on your images.
Use our knowledge of computational thinking to develop electronic circuits for a range of binary Logic gates.
Develop and understanding of how computers work: inputting data, processing data and outputting information.
Look at three types of computer network,
Discuss the advantages and the disadvantages of each network
Title of assessment:
Problem Solving
Skills assessed:
Algorithm, flowchart, pseudocode and computation thinking.
Key learning:
Looking at what an algorithm is, Appreciating the importance of algorithms in computer science and writing and interpreting algorithms
Understand the purpose of a flowcharts. Know how to construct a flow chart using the required symbols.
Understand the purpose of pseudocode and write pseudocode for the given scenario
Learning to use condition and iteration in algorithm
Learning to use nested if statement and nested Loop in the algorithm.
Learning what computational thinking is.
Defining decomposition and abstraction. Decomposing problems. Bringing together a range of skills to complete a problem
Skills assessed:
Python programing, variable, integer and string, if statement, loop and list.
Key learning:
Looking at the basics of Python and the Python shell.
Student will then go on to Looks at algorithms, variables and inputs
Looking at integers and strings and Looking at how to convert integers to strings
Looking at if statements in Python, what if statements are and why we use them; Nested if statements.
Implement “While Loop” in Python
Looking at what a for Loop is, discuss the difference between for and while Loop. Attempting some for Loop tasks.
Looking at what a list is;
And use different methods to printing a list on the screen.