Sheet Names

• 1. Dashboard – A central overview with key performance indicators and visual summaries.
• 2. Study Assets Tracker – The primary table for recording, categorizing, and monitoring all study-related resources.
• 3. Study Schedule – A calendar-based view of your study sessions with task assignments and due dates.
• 4. Progress Log – Tracks completed topics, quiz results, and self-assessment scores over time.
• 5. Resources Library – A reference sheet containing links, file paths, and descriptions of external learning materials.

Table Structures and Data Types

Sheet 1: Dashboard (Overview)

A dynamic summary page with live data from other sheets. Key metrics include:

• Total number of study assets tracked
• Percentage of assets categorized as "Completed"
• Upcoming deadlines in the next 7 days
• Most-used study categories (e.g., Math, Biology)

Sheet 2: Study Assets Tracker (Core Table)

This is the central table for asset tracking. Each row represents a single educational resource or study item.

Sheet 3: Study Schedule

A calendar-style table with columns for dates, time blocks, and scheduled study topics. Allows users to plan sessions in advance.

Sheet 4: Progress Log

Records completed tasks, quiz scores (as percentages), and self-evaluation notes.

Sheet 5: Resources Library

A reference list of external links, file paths, or QR codes for learning materials.

Formulas Required

• Auto-increment Asset ID: =IF(A2="", MAX($A$1:$A$999)+1, A2)
• Status Color Indicator: Uses conditional formatting (see below).
• Days Until Due: =IF(Due_Date<>"", DATEDIF(TODAY(), Due_Date, "d"), "")
• Total Assets Count: =COUNTA(Study_Assets_Tracker!B:B) (in Dashboard)
• Completed Percentage: =COUNTIF(Status_Column, "Completed") / COUNTA(Status_Column) * 100
• Upcoming Deadlines: Uses a filter to show rows where Due Date is between TODAY() and TODAY()+7.

Conditional Formatting

• Status Column: Color-coding (Red for "To Do", Yellow for "In Progress", Green for "Completed").
• Due Date Column: Red text if due date is within 3 days; Orange if in 4–7 days.
• Priorities: High priority items highlighted in bold red.
• Last Accessed: Highlighted yellow if not accessed in the past month.

User Instructions

1. Open the file and enable editing if prompted.
2. Go to the "Study Assets Tracker" tab and begin entering your resources using the provided columns.
3. Use dropdowns for Type, Category, Status, and Priority to maintain consistency.
4. The Dashboard auto-updates with statistics. Refresh by pressing F9 if needed.
5. Use the "Study Schedule" tab to block out time for study sessions based on your available hours.
6. Update the "Progress Log" weekly with quiz results or completed topics.
7. To archive outdated assets, change their Status to "Archived".
8. Save a backup copy periodically (recommended: every 2 weeks).

Example Rows (Study Assets Tracker)

Recommended Charts and Dashboards

• Pie Chart (Dashboard): Distribution of assets by Subject/Category.
• Bar Chart: Number of completed vs. pending items per month.
• Gantt-style Timeline (from Study Schedule): Visualize study session progress across weeks.
• Status Heatmap: Use color gradients to show activity frequency by subject.

This template is designed for personal use, ensuring privacy and simplicity. No internet connection required. Fully customizable for any educational level or goal. Ideal for high school students, university learners, and professionals pursuing certifications.