Spreadsheets ks3. This game covers the features of a worksheet columns rows etc using functions and formulae organising data and presenting it accurately. For each task there is a link to a video tutorial which should help you to complete them successfully. Excel spreadsheets ks3 mr a glasgow.
Unsubscribe from mr a glasgow. General ks3 spreadsheet tests there is a class specific tests and 1 yr 10 test. To select a cell left click on it.
Once we have our information in a spreadsheet we can run powerful calculations make graphs and charts and analyse patterns. Spreadsheets the accounting programs are one of the most useful tools to be found on a computer and children in ks2 will become very familiar with them in ict. Spreadsheet game ks3 alternatively if you are in a computer suite the class can play against one another in pairs.
Columns rows and cells. The game below is just one of the thousands of games at what2learn. To enter data double click it.
The letter refers to the column and the number refers to the row. Spreadsheets are interactive computer accounting programs that are very versatile. Students need to create a school production spreadsheet which contains if statements charts vlookups macros.
Spreadsheet tasks for year 7. Every cell in a spreadsheet or worksheet has a unique cell reference which consists of a letter and a number. You should carry out each task using the task 2 houses spreadsheet link on the right.
They make storing organising and analysing data much easier than it once was. Spreadsheets are used to store information and data. Select one or more quizzes to assign to your students.
Students choose country and vehicle research data eg distances between towns and input into spreadsheet. General ks3 spreadsheet tests there is a class specific tests and 1 yr 10 test. The document below gives you a wide range of tasks to complete.