Grade 10 Computer Science
A variable learns to hold many values at once, and then to hold them under names of your choosing. Programs stop forgetting everything the moment they finish, and start saving what they know into files and reading it back. A spreadsheet learns to count and add only the rows that pass a test, and to look one table's answers up in another. Then the two things the whole subject has been circling — how a page actually reaches you, and how a hundred thousand records are kept so that any one of them can be found — get a term each of their own.
Print the whole term as one worksheet pack →Lists and Dictionaries
- Changing and growing a listLesson
Work out what a list holds after values have been added on the end, written over, or joined on from another list.
- Dictionaries and their keysLesson
Look a value up in a dictionary by its key, and work out what adding a key or writing over one leaves behind.
- Looping over a dictionaryLesson
Follow a loop that visits every key in a dictionary, looks each value up, and leaves a total or a count behind.
Programs that Keep Their Data
- Writing and reading a fileLesson
Follow a program that saves writing into a file and reads it back, and work out what the file holds at each point.
- Going through a file line by lineLesson
Follow a loop that visits every line of a file in turn, turns each line into a number where it needs to, and leaves a total or a count behind.
Spreadsheets at Depth
- Counting and adding with a conditionLesson
Work out what COUNTIF and SUMIF show for a sheet you are given, and read the test each of them is applying.
- Looking a value up in a tableLesson
Read a VLOOKUP: find the row its search value matches, and take the answer from the column its number names.
- Sorting and filtering a sheetLesson
Work out what a sheet looks like after its rows have been put in order by a column, or narrowed to the rows that pass a test.
How the Web Works
- What a page is made ofLesson
Work out how many separate files a browser has to fetch to show a page, and what changes when some of them are already stored.
- Asking and answering over the webLesson
Say what travels out in a request and what comes back in the answer, read the data an address carries, and follow what a browser does with the number it is answered with.