🎬 Simple Russian Film Exercises
File: russian_films_simple.csv
Columns: Month, Year, Film, Genre, Rating, Budget, Income, Profit (empty)
📂 1. OPEN & SETUP
1
Open CSV File:
→ → Find file → Open
2
Complete Month Column:
• Type "January" in first empty cell
• Click small square at bottom-right of cell
• Drag down to fill all months
3
Complete Year Column:
• Type "2023" in first empty cell
• Drag down to fill all years
📋 2. CREATE DROPDOWN LISTS
4
Genre Dropdown:
• Select all cells in Genre column
• →
• Under "Allow": Choose
• Type:
Comedy,Drama,Action,Fantasy,War,Sci-Fi
• Click
Alt+D, V
Try it: Click any cell in Genre column → Arrow appears → Choose different genre
🔢 3. CALCULATE PROFIT WITH FORMULA
5
Profit Formula:
• Click first empty cell in Profit column (row 2)
• Type:
=IF(G2>F2,"TRUE","FALSE")
• Press Enter
G2 = Income, F2 = Budget (check your column letters!)
6
Copy Formula:
• Click cell with formula
• Click small square at bottom-right
• Drag down to fill all rows
Formula explanation: If Income > Budget, write "TRUE", else write "FALSE"
📊 4. CREATE BAR CHART
7
Select Data for Chart:
• Click and drag to select Film Titles (column C)
• Hold
CTRL key
• Click and drag to select Income (column G)
• Release CTRL key
8
Insert Chart:
• →
• Choose chart type
• Click two times
• Title: "Russian Film Income"
• Click
Your chart shows: Which films made the most money
🔍 5. FILTER & SORT
9
Add Filters:
• Click anywhere in your data
• →
• Small arrows appear in each column header
Ctrl+Shift+L
10
Try Filtering:
• Click arrow in Genre column
• Choose only "Comedy"
• Click arrow in Profit column
• Choose only "TRUE"
Now you see: Only Comedy films that made profit
💬 6. ADD COMMENTS
11
Add Comment to Favorite Film:
• Right-click on any film name
• Choose
• Type: "My favorite film!"
• Click outside the comment box
Ctrl+Alt+C
12
Add More Comments:
• Comment on film with highest rating
• Comment on film with biggest budget
• Comment on why a film didn't make profit
🎯 COMPLETE ALL 12 TASKS → SAVE FILE → SHOW TEACHER!
File → Save As → Type: .ods → Name: your_name_films.ods