SpellSizzle

Welcome to SpellSizzle, a web-based edutainment platform developed by the development team of ICT Society of Ananda College for the Web Development competition organized by the ICT Society of Musaeus College. The platform is designed to help students improve their vocabulary and spelling skills in a fun and engaging way.

SpellSizzle offers a range of features such as real-time leaderboards, practice quizzes, and audio pronunciation guides. Users can create an account and start playing immediately, and the platform offers unlimited word sets to practice.

Platform Walckthrough

Technologies & Tools We Used

• PHP
• MySQL
• HTML
• CSS
• JavaScript
• AWS LightSail (Used to host the project)

Additionally, we have used the matthewreagan/WebstersEnglishDictionary to fetch words randomly in the JSON format.

How to play the game?

Note: The web application is mobile responsive and works well in the mobile browsers too

• First go to http://43.205.223.158/SpellSizzle/ where we hosted our application
• Then go to the play page and create an account or login if you have already registered in the platform
• Once you login, you will be redirected to the play page where you will be prompted enter the correct spelling of a word randomly selected from matthewreagan/WebstersEnglishDictionary
• You can listen to the pronunciation of the word by clicking on the speak button
• Also, you can listen to the meaning of the word by clicking on the dictionary button
• If you want to skip the word, you can click on the skip button. If you are confident that you know the spelling of the word, enter the word in the input section and click on the submit button
• If your submission was correct, 5 points will be added to your rating. Otherwise, 5 will be deducted from your rating.

How to run the project locally?

Since this project fetches data from matthewreagan/WebstersEnglishDictionary, you need to connect the device to an active internet connection.

For windows devices

1. First install the XAMPP server in your machine
2. Then head overto PHPMyAdmin in the localhost and create a Database named as 'spellsizzle'. Next import the SpellSizzle/sql/users.sql file in to the database
3. Next clone the repository in to C:/xampp/htdocs

   cd C:/xampp/htdocs && git clone https://github.com/shakyapeiris/SpellSizzle.git

4. Then go to the localhost/SpellSizzle and you should see the served web application

For linux devices

1. First install the XAMPP server in your machine
2. Next start the MySQL server
3. Then head overto PHPMyAdmin in the localhost and create a Database named as 'spellsizzle'. Next import the SpellSizzle/sql/users.sql file in to the database
4. Install Apache, PHP and PHP-MySQL

   sudo apt-get install apache2 php php-mysql

5. Install git

   sudo apt-get install git

6. Clone the project from github and navigate to the root directory of the project

   git clone https://github.com/shakyapeiris/SpellSizzle.git && cd SpellSizzle

7. Serve the PHP project

   php -S 0.0.0.0:3000

What we learned by building this project

• Backend development using PHP and MySQL
• How to host a PHP and MySQL server on an AWS lightsail instance
• How to use Databse service on AWS LightSail

Future Plans

• Open the project for public contributions
• Implement a level based gameplay depending on the length of the word
• Give more control to the user over automated voices