Using Scorm & xAPIs
Tools: Scorm Cloud, Google Sheets, ChatGPT
My Role: Instructional Designer, eLearning Developer
Time: 10 hours
Client: Prospective client
Solution
This project showcases my ability to design a Chrome extension that captures website URLs and stores them in Google Sheets and a Learning Management System (LMS). The extension allows users to easily collect URLs with a single click, automatically logging the User ID, Date Added, and URL in real-time. This solution is ideal for teams and businesses building curated website databases for content creation, research, or strategic purposes, eliminating manual entry and boosting productivity.
Result:
Chrome Extension that easily captures website URLs with a single click.
Automatic Integration with Google Sheets to store User ID, Date Added, and URL.
User-Friendly: Simple for users to install and operate, making it an accessible tool for any team.
Automated 24-Hour Updates: Scheduled task updates the sheet with new URLs every 24 hours using cron jobs, ensuring your data is always current.
Scalable: Designed to handle increasing volumes of data and users, perfect for businesses looking to expand their database over time.
SCORM Integration: Optionally integrates with SCORM Cloud, allowing the URLs to be stored within a Learning Management System (LMS) for educational or training purposes
Pros
Efficient Data Collection: Automates the URL capture process, saving time and reducing errors associated with manual entry.
Real-Time Tracking: Once a URL is captured, it's instantly added to Google Sheets, providing immediate visibility and control.
Easy to Use: No complicated setup required—install the extension and start capturing URLs.
Cost-Effective: Relies on free tools like Google Sheets for storing data, making it an affordable solution for teams of any size.
Scalable and Flexible: Suitable for individual users as well as large teams; easily integrates with existing workflows.
Customizable: The system can be tailored to capture additional data fields or integrate with other systems as needed.
Cons
Chrome-Specific: This extension is currently designed for Google Chrome, limiting its use to users of this browser.
Manual Set-Up: While the process is automated after installation, the initial setup may require basic technical knowledge.
No Preview Functionality: At this stage, the tool doesn't provide a thumbnail or website preview, which could enhance the user experience.
Data Privacy: While user data is anonymized, there are potential concerns regarding the handling of personally identifiable information in sensitive contexts.
Limited Database Features: While Google Sheets is a robust tool, it may not be ideal for managing very large datasets or advanced data queries.
Reflection
During the development process, I encountered lengthy troubleshooting due to initial challenges in properly prompting and configuring the integration between the Chrome extension, Google Sheets, and LMS. These issues were resolved through iterative problem-solving, fine-tuning the code, and leveraging resources like ChatGPT to identify and address bugs, ultimately ensuring the extension functions as intended.