Year 11
Year 11
Work with CSV files
Link copied to clipboard
These resources will be removed by end of Summer Term 2025.
Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.
These resources were created for remote use during the pandemic and are not designed for classroom teaching.
Lesson details
Key learning points
- In this lesson, we will learn what CSV files are and how to use them. We will also learn how to read data into a list and a 2D list. Finally, we will complete a challenge working with the data.
Licence
This content is made available by Oak National Academy Limited and its partners and licensed under Oak’s terms & conditions (Collection 1), except where otherwise stated.
3 Questions
Q1.
True or False: You should always close a file once you have finished accessing and modifying it.
False
Q2.
True or False: Opening a file in write mode will always create a new file or overwrite an existing file.
False
Q3.
True or False: There is not a separate append method for text files.
False
3 Questions
Q1.
True or False: A CSV File is a text file
False
Q2.
What string method can you use to remove unwanted pieces of data?
delete()
remove()
string()
Q3.
True or False: The split() method splits the string where it finds a space " " and returns it in a list.
False