Almentor Evaluation Submission 🤖

📝 Table of Contents

• About
• Getting Started
• Installation
• Usage
• Features
• Built With
• Configuration
• Troubleshooting
• Contributing
• License
• Acknowledgments

🧐 About

This script automates the process of submitting multiple responses to Microsoft Forms. Perfect for teachers/instructors who need to submit evaluations for multiple students efficiently. It handles email extraction, Excel sheet creation with validation rules, and automated form submissions.

🏁 Getting Started

Prerequisites

• Node.js (v14 or higher)
• npm (Node Package Manager)
• Chrome/Chromium browser
• Text editor (VS Code recommended)

🔧 Installation

1. Clone the repository

git clone https://github.com/AmirHaytham/almentor-evaluation-submission.git

2. Navigate to project directory

cd almentor-evaluation-submission

3. Install dependencies

npm install

🎈 Usage

1. Prepare Student Data

// In automation.js
const text = `
student1@example.com
student2@example.com
// Add more emails...
`;

2. Generate Excel Sheet

node automation.js

3. Fill Excel Data

Open form_responses.xlsx and fill:

• Student interaction (0-5)
• Commitment level (0-5)
• Behavior selection
• Feedback notes

4. Run Form Submission

node automation.js
# When prompted, type 'y' to confirm

✨ Features

• 📧 Email extraction from text
• 📊 Excel sheet generation with validation
• 🤖 Automated form submissions
• 🔄 Retry mechanism for failures
• 📝 Detailed error logging
• 📸 Error screenshots

🛠️ Built With

• Puppeteer - Web automation
• ExcelJS - Excel handling
• Node.js - Runtime environment

⚙️ Configuration

Excel Sheet Structure

Column	Description	Values
Student Email	Email address	Text
Teacher Code	Teacher identifier	ENTER YOUR ID
Interaction	Lecture interaction	0-5
Commitment	Session commitment	0-5
Behavior	Student behavior	Dropdown
Feedback	Additional notes	Text

💭 Troubleshooting

Common Issues

1. Excel Busy Error

Error: EBUSY: resource busy or locked
# Solution: Close Excel file

2. Navigation Timeout

Error: Navigation timeout exceeded
# Solution: Check internet connection

🤝 Contributing

1. Fork the repository
2. Create your feature branch

git checkout -b feature/AmazingFeature

3. Commit changes

git commit -m 'Add AmazingFeature'

4. Push to branch

git push origin feature/AmazingFeature

5. Open a Pull Request

👥 Contributors

Made with ❤️ by AmirHaytham

📝 License

This project is licensed under the MIT License - see the LICENSE file for details.