276 lines
8.8 KiB
HTML
276 lines
8.8 KiB
HTML
<!DOCTYPE html>
|
|
<html lang="en">
|
|
<head>
|
|
<meta charset="UTF-8">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
|
<title>Simple Russian Film Exercises</title>
|
|
<style>
|
|
@page { size: A4; margin: 1cm; }
|
|
* { margin: 0; padding: 0; box-sizing: border-box; font-family: Arial, sans-serif; }
|
|
body { width: 21cm; height: 29.7cm; padding: 1.2cm; line-height: 1.3; font-size: 11pt; }
|
|
|
|
h1 {
|
|
color: #2c5aa0;
|
|
font-size: 16pt;
|
|
text-align: center;
|
|
margin-bottom: 10px;
|
|
border-bottom: 2px solid #2c5aa0;
|
|
padding-bottom: 8px;
|
|
}
|
|
|
|
.section-title {
|
|
color: #2c5aa0;
|
|
background: #e8f0fe;
|
|
padding: 6px 10px;
|
|
margin: 12px 0 8px 0;
|
|
border-radius: 4px;
|
|
font-size: 12pt;
|
|
}
|
|
|
|
.task {
|
|
background: #f9f9f9;
|
|
border-left: 4px solid #2c5aa0;
|
|
padding: 10px;
|
|
margin: 8px 0;
|
|
border-radius: 0 4px 4px 0;
|
|
break-inside: avoid;
|
|
}
|
|
|
|
.task-number {
|
|
display: inline-block;
|
|
background: #2c5aa0;
|
|
color: white;
|
|
width: 22px;
|
|
height: 22px;
|
|
text-align: center;
|
|
border-radius: 50%;
|
|
margin-right: 8px;
|
|
font-weight: bold;
|
|
line-height: 22px;
|
|
}
|
|
|
|
.menu-path {
|
|
background: #2c5aa0;
|
|
color: white;
|
|
padding: 3px 8px;
|
|
border-radius: 3px;
|
|
margin: 0 3px;
|
|
font-weight: bold;
|
|
font-size: 10pt;
|
|
}
|
|
|
|
.shortcut {
|
|
background: #e8f5e9;
|
|
border: 1px solid #4caf50;
|
|
padding: 3px 6px;
|
|
border-radius: 3px;
|
|
font-size: 9pt;
|
|
display: inline-block;
|
|
margin: 2px;
|
|
}
|
|
|
|
.example {
|
|
background: #fff3cd;
|
|
padding: 6px 8px;
|
|
margin: 6px 0;
|
|
border-left: 3px solid #ffc107;
|
|
font-size: 10pt;
|
|
border-radius: 0 3px 3px 0;
|
|
}
|
|
|
|
.formula {
|
|
background: #f5f5f5;
|
|
font-family: monospace;
|
|
padding: 5px 8px;
|
|
margin: 5px 0;
|
|
border: 1px solid #ddd;
|
|
border-radius: 3px;
|
|
font-size: 10pt;
|
|
}
|
|
|
|
.warning {
|
|
background: #ffeaa7;
|
|
border: 1px solid #f39c12;
|
|
padding: 6px 8px;
|
|
margin: 6px 0;
|
|
border-radius: 4px;
|
|
font-size: 10pt;
|
|
}
|
|
|
|
.columns {
|
|
display: flex;
|
|
gap: 12px;
|
|
margin: 10px 0;
|
|
}
|
|
|
|
.column {
|
|
flex: 1;
|
|
}
|
|
|
|
@media print {
|
|
body { padding: 1cm; }
|
|
.task { page-break-inside: avoid; }
|
|
.columns { gap: 8px; }
|
|
}
|
|
</style>
|
|
</head>
|
|
<body>
|
|
<h1>🎬 Simple Russian Film Exercises</h1>
|
|
|
|
<div class="example">
|
|
<strong>File:</strong> russian_films_simple.csv<br>
|
|
<strong>Columns:</strong> Month, Year, Film, Genre, Rating, Budget, Income, Profit (empty)
|
|
</div>
|
|
|
|
<div class="section-title">📂 1. OPEN & SETUP</div>
|
|
|
|
<div class="task">
|
|
<div class="task-number">1</div>
|
|
<strong>Open CSV File:</strong><br>
|
|
<span class="menu-path">File</span> → <span class="menu-path">Open</span> → Find file → Open
|
|
</div>
|
|
|
|
<div class="task">
|
|
<div class="task-number">2</div>
|
|
<strong>Complete Month Column:</strong><br>
|
|
• Type "January" in first empty cell<br>
|
|
• Click small square at bottom-right of cell<br>
|
|
• Drag down to fill all months
|
|
</div>
|
|
|
|
<div class="task">
|
|
<div class="task-number">3</div>
|
|
<strong>Complete Year Column:</strong><br>
|
|
• Type "2023" in first empty cell<br>
|
|
• Drag down to fill all years
|
|
</div>
|
|
|
|
<div class="section-title">📋 2. CREATE DROPDOWN LISTS</div>
|
|
|
|
<div class="task">
|
|
<div class="task-number">4</div>
|
|
<strong>Genre Dropdown:</strong><br>
|
|
• Select all cells in Genre column<br>
|
|
• <span class="menu-path">Data</span> → <span class="menu-path">Validity</span><br>
|
|
• Under "Allow": Choose <span class="menu-path">List</span><br>
|
|
• Type: <code>Comedy,Drama,Action,Fantasy,War,Sci-Fi</code><br>
|
|
• Click <span class="menu-path">OK</span>
|
|
<div class="shortcut">Alt+D, V</div>
|
|
</div>
|
|
|
|
<div class="example">
|
|
<strong>Try it:</strong> Click any cell in Genre column → Arrow appears → Choose different genre
|
|
</div>
|
|
|
|
<div class="section-title">🔢 3. CALCULATE PROFIT WITH FORMULA</div>
|
|
|
|
<div class="task">
|
|
<div class="task-number">5</div>
|
|
<strong>Profit Formula:</strong><br>
|
|
• Click first empty cell in Profit column (row 2)<br>
|
|
• Type: <span class="formula">=IF(G2>F2,"TRUE","FALSE")</span><br>
|
|
• Press Enter
|
|
<div class="warning">G2 = Income, F2 = Budget (check your column letters!)</div>
|
|
</div>
|
|
|
|
<div class="task">
|
|
<div class="task-number">6</div>
|
|
<strong>Copy Formula:</strong><br>
|
|
• Click cell with formula<br>
|
|
• Click small square at bottom-right<br>
|
|
• Drag down to fill all rows
|
|
</div>
|
|
|
|
<div class="example">
|
|
<strong>Formula explanation:</strong> If Income > Budget, write "TRUE", else write "FALSE"
|
|
</div>
|
|
|
|
<div class="section-title">📊 4. CREATE BAR CHART</div>
|
|
|
|
<div class="task">
|
|
<div class="task-number">7</div>
|
|
<strong>Select Data for Chart:</strong><br>
|
|
• Click and drag to select Film Titles (column C)<br>
|
|
• Hold <span class="shortcut">CTRL</span> key<br>
|
|
• Click and drag to select Income (column G)<br>
|
|
• Release CTRL key
|
|
</div>
|
|
|
|
<div class="task">
|
|
<div class="task-number">8</div>
|
|
<strong>Insert Chart:</strong><br>
|
|
• <span class="menu-path">Insert</span> → <span class="menu-path">Chart</span><br>
|
|
• Choose <span class="menu-path">Bar</span> chart type<br>
|
|
• Click <span class="menu-path">Next</span> two times<br>
|
|
• Title: "Russian Film Income"<br>
|
|
• Click <span class="menu-path">Finish</span>
|
|
</div>
|
|
|
|
<div class="example">
|
|
<strong>Your chart shows:</strong> Which films made the most money
|
|
</div>
|
|
|
|
<div class="section-title">🔍 5. FILTER & SORT</div>
|
|
|
|
<div class="task">
|
|
<div class="task-number">9</div>
|
|
<strong>Add Filters:</strong><br>
|
|
• Click anywhere in your data<br>
|
|
• <span class="menu-path">Data</span> → <span class="menu-path">AutoFilter</span><br>
|
|
• Small arrows appear in each column header
|
|
<div class="shortcut">Ctrl+Shift+L</div>
|
|
</div>
|
|
|
|
<div class="task">
|
|
<div class="task-number">10</div>
|
|
<strong>Try Filtering:</strong><br>
|
|
• Click arrow in Genre column<br>
|
|
• Choose only "Comedy"<br>
|
|
• Click arrow in Profit column<br>
|
|
• Choose only "TRUE"
|
|
</div>
|
|
|
|
<div class="example">
|
|
<strong>Now you see:</strong> Only Comedy films that made profit
|
|
</div>
|
|
|
|
<div class="section-title">💬 6. ADD COMMENTS</div>
|
|
|
|
<div class="task">
|
|
<div class="task-number">11</div>
|
|
<strong>Add Comment to Favorite Film:</strong><br>
|
|
• Right-click on any film name<br>
|
|
• Choose <span class="menu-path">Insert Comment</span><br>
|
|
• Type: "My favorite film!"<br>
|
|
• Click outside the comment box
|
|
<div class="shortcut">Ctrl+Alt+C</div>
|
|
</div>
|
|
|
|
<div class="task">
|
|
<div class="task-number">12</div>
|
|
<strong>Add More Comments:</strong><br>
|
|
• Comment on film with highest rating<br>
|
|
• Comment on film with biggest budget<br>
|
|
• Comment on why a film didn't make profit
|
|
</div>
|
|
|
|
<div class="warning" style="background: #e8f5e9; border-color: #4caf50; text-align: center; margin-top: 15px;">
|
|
<strong>🎯 COMPLETE ALL 12 TASKS → SAVE FILE → SHOW TEACHER!</strong><br>
|
|
File → Save As → Type: .ods → Name: your_name_films.ods
|
|
</div>
|
|
|
|
<script>
|
|
document.addEventListener('DOMContentLoaded', function() {
|
|
const style = document.createElement('style');
|
|
style.textContent = `
|
|
@media print {
|
|
@page { margin: 0.6cm; }
|
|
body { padding: 0.8cm; }
|
|
.task { border-left-width: 3px; }
|
|
}
|
|
`;
|
|
document.head.appendChild(style);
|
|
});
|
|
</script>
|
|
</body>
|
|
</html> |