Year 7
WA1
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.
WA2
Title of assessment:
Being an ICT Savvy User
Skills assessed:
Health and safety issues, e safety, online danger, search engine and portable technology.
Key learning:
Explaining health and safety when using computers
Understand the term e-safety.
Understand the risks online and to know how to keep yourself safe online.
Improve our search engine searches to return appropriate results
List the dangers that you could be faced when using portable technology; particularly mobile phones
WA3
Title of assessment:
Spreadsheet
Skills assessed:
Spreadsheet calculation
Key learning:
Identify the key parts of a spreadsheet and insert data into your model and apply suitable layout/formatting options to a spreadsheet model
Identify basic spreadsheet formula
Identify how the =IF function can be applied to spreadsheets and conditional formatting
Creation of graphs and charts with data labels and titles
Year 8
WA1
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
WA2
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
WA3
Title of assessment:
Graphics and Database
Skills assessed:
Graphics – Creating magazine cover using Fireworks skills such as crop, magic wand, polygon, rubber tool, layers and etc.
Database – Creating database, insert, delete and amend data, creating database relationship, queries, forms and report.
Key learning:
Graphics – Unit introduction/baseline assessment, Looking at the different types of graphic and the advantages and disadvantages of each. Identify the purpose of each graphic and the best use of each file type.
Introduction to Fireworks and create a graphic by using basic drawing tools to manipulate an image.
Learn features of good presentations and design
Self and peer assessment
Database – Introduction to database, record, field, data types and Microsoft Access.
Create a database using specific software.
Learn how to insert, delete and amend records in table, set up new fields in table and set up the data types and restrictions.
Be able to explain Database relationships and create relationship diagram of given database.
Design queries to display relevant information on to the screen
Take queries and create a report.
Change report to make it user friendly and include buttons.
LI6: Create a form for database tables. Include buttons on form to help users navigate around the database form.
Year 9
WA1
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
WA2
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.
WA3
Title of assessment:
Photoshop and Web Designing
Skills assessed:
Photoshop – Creating Hybridge animal using Photoshop skills such as layers, clone, magic wand, eraser, eye drop tool, select tool and etc.
Web Designing – HTML, Dream Viewer skills and fireworks skills to create banner, logo and buttons.
Key learning:
Photoshop – Be able to understand how image manipulation is used in real world and the consequences. Be aware of the some of the basic tools of image manipulation software and how they can be used
Be able to understand how bitmap graphics are representing inside computer and are able to manipulate image using image manipulation software to produce different outcome.
Begin to understand what copyright is and the consequences of breaking copyright law
Be able to critically evaluate your and other work and to suggest improvements.
Are able to refine their work to make it more professional.
Web Designing – Be able to create basic web page adding text, background colour, foreground colours, hyperlink, image using HTML coding
Identify the purpose and intend target audience of websites.
Use Firework skills to create buttons and animated banner
Use Dreamweaver to create website including home page and at least other 4 pages.
Evaluate website identifying WWW and EBI