8. ๐งช Mini Projects - rafageist/book-spreadsheet-basics GitHub Wiki
These mini projects are short but meaningful tasks that combine what you've learned so far. Each one is practical and helps reinforce your spreadsheet skills.
Choose one (or more) to complete before the final project.
๐ Project 1: Weekly Expense Tracker
Goal: Track your daily spending for one week.
What to include:
- Date and category columns (e.g. food, transport)
- Amount spent per day
- Total spending at the end of the week
- Bar chart comparing expenses by category
๐ Project 2: Study Progress Log
Goal: Monitor your own study time or learning progress.
What to include:
- Days of the week as rows
- Columns for subject/topic, hours studied, and notes
- Use
SUM()to get total weekly hours - Optional: Use conditional formatting to highlight low or high study time
๐ Project 3: Simple Event Planner
Goal: Organize a small event (e.g. birthday, class outing)
What to include:
- List of tasks with status (To Do, In Progress, Done)
- Budget estimates per task
- Pie chart showing how much of the total budget each task represents
๐ Deliverables
- Create the spreadsheet in your preferred tool
- Apply formatting and at least one chart or function
- Save and present your file or screenshot as instructed