Year 11

Work with CSV files

Year 11

Work with CSV files

warning

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.

Lesson details

Key learning points

  1. 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.

Loading...

3 Questions

Q1.
True or False: You should always close a file once you have finished accessing and modifying it.
False
Correct answer: True
Q2.
True or False: Opening a file in write mode will always create a new file or overwrite an existing file.
False
Correct answer: True
Q3.
True or False: There is not a separate append method for text files.
False
Correct answer: True

3 Questions

Q1.
True or False: A CSV File is a text file
False
Correct answer: True
Q2.
What string method can you use to remove unwanted pieces of data?
delete()
remove()
string()
Correct answer: strip()
Q3.
True or False: The split() method splits the string where it finds a space " " and returns it in a list.
False
Correct answer: True