Why Engineering Core sectors ECE, EEE and Mech get fewer admissions in Bangalore Colleges?

 In Bangalore, the core sectors have failed because they didn't catch the tumbling point of the dot com era. This was the X extension of the file formats in Microsoft office suites. When microsoft added XML in 2010, for the compatibility to Office applications, the world moved ahead of the dot com era. All it's formats on save changed from .doc to .docx, .xls to .xlsx and so on. This is where Bangalore Engineering colleges were left clueless, the impact this had on their enrollment numbers. Carefully the developped countries changed their classroom models to online models, but Bangalore thought that time that Internet is for fascination and mobile phones need a ban due to misuse and copying in exams. Then in 2015, everything changed.  Nobody is getting job offers in ECE, EEE, Mech, Telecom, Civil and Aerospace Engg. Only CSE and IS scored to sore to heights. The reason I feel is everything that's got to do with automation. With numerous college projects done by lakhs of students not 1% were internally used on daily basis in these colleges. They did final year projects outside and got certificates to show in colleges. Otherwise, they took training and submitted somebody else's project for display on exam date. In few rare cases, college student did in-campus experiments and among that also very rarely they build consistent systems. I put fault in not automating their labs and drudgery of 3-hours of labs every alternate day for students were'nt simplified using embedded systems. Look at this Gemini AI query and result on how to accomplish all this using microsoft excel:

I was about ask if commands and controls in Excel speadsheets be written in VBA for buttons that give instructions to any hardware system connected to the same computer?

VB.Net

Sub SendCommand()
    ' Replace "COM1" with the correct port name
    Dim serialPort As Object
    Set serialPort = CreateObject("WScript.Shell")

    serialPort.Run "cmd /C mode COM1: baud=9600 parity=n data=8 stop=1"
    serialPort.SendKeys "YourCommand" ' Replace "YourCommand" with the actual command
End Sub

How about controlling Arduino uno via VBA in excel?

https://support.arduino.cc/hc/en-us/articles/360019833020-Download-and-install-Arduino-IDE

Yes, you can absolutely write VBA code for buttons in Excel spreadsheets to control hardware systems connected to the same computer.

VBA (Visual Basic for Applications) is a programming language built into Excel, and it can be used to create custom macros and automate tasks. You can write VBA code to:

• Send commands: Create buttons that, when clicked, send specific commands to the hardware system. For example, you could create a button that turns a motor on or off, adjusts a temperature setting, or triggers a specific action in a connected device.
• Retrieve data: Write VBA code to read data from the hardware system and display it in your Excel spreadsheet. This could be useful for monitoring sensors, collecting measurements, or analyzing data.
• Control hardware directly: In some cases, you might be able to directly control hardware devices from VBA using appropriate libraries or APIs. This would depend on the specific hardware and its compatibility with VBA.

To achieve this, you'll typically need:

• Hardware compatibility: Ensure that the hardware system can communicate with your computer and that there are appropriate drivers or libraries available for interacting with it.
• VBA knowledge: Learn the basics of VBA programming to write effective code for your specific tasks.
• Communication protocols: Understand the communication protocols (e.g., serial, parallel, USB, Bluetooth, Wi-Fi) used by the hardware system and use appropriate VBA functions or libraries to interact with it.

Here's a simplified example of VBA code that could send a command to a connected device:Sub SendCommand()

    ' Replace "COM1" with the correct port name

    Dim serialPort As Object

    Set serialPort = CreateObject("WScript.Shell")

    serialPort.Run "cmd /C mode COM1: baud=9600 parity=n data=8 stop=1"

    serialPort.SendKeys "YourCommand" ' Replace "YourCommand" with the actual command

End Sub

This code opens a serial port and sends a specified command to the connected device. Of course, the actual implementation will vary depending on the hardware system and its specific requirements.

By leveraging VBA's capabilities, you can create powerful Excel spreadsheets that interact with external hardware systems, automating tasks, collecting data, and performing various control functions.

Controlling Arduino Uno via VBA in Excel: A Step-by-Step Guide

Understanding the Components:

• Arduino Uno: A microcontroller board that can interact with the physical world through inputs and outputs.
• VBA (Visual Basic for Applications): A programming language built into Excel that can automate tasks and interact with external systems.
• Serial Communication: A method of transmitting data between devices, often used for Arduino and computers.

Steps Involved:

1. Arduino Setup:

• Connect the Arduino Uno to your computer using a USB cable.
• Install the Arduino IDE (Integrated Development Environment) from https://support.arduino.cc/hc/en-us/articles/360019833020-Download-and-install-Arduino-IDE.  
  1. github.com

  MIT

  github.com

• Write a simple Arduino sketch (program) that listens for serial data and responds accordingly. For example:
• void setup() {
•   Serial.begin(9600);
• }
• 
  
• void loop() {
•   if (Serial.available() > 0) {
•     int incomingByte = Serial.read();
•     if (incomingByte == '1') {
•       // Turn on LED
•     } else if (incomingByte == '0') {
•       // Turn off LED
•     }
•   }
• }
• 
  

VBA Setup:

• Open a new Excel workbook.
• Press Alt + F11 to open the VBA editor.
• Insert a new module.

Replace COM3 with the actual port number where your Arduino is connected.

Excel Interface:

• Create a button or other user interface element in your Excel workbook.
• Assign a macro to the element that calls the SendCommandToArduino function with the desired command (e.g., "1" to turn on an LED).

Additional Considerations:

• Error Handling: Implement error handling in your VBA code to catch potential exceptions, such as when the serial port is unavailable.
• Data Exchange: If you need to exchange more complex data between Excel and Arduino, consider using a more structured format like JSON or XML.
• Libraries: Explore libraries like Win32API or MSComm for more advanced serial communication features in VBA.
• Security: If you're dealing with sensitive data, ensure proper security measures are in place to protect your communication.

By following these steps, you can effectively control Arduino Uno devices from Excel spreadsheets using VBA, enabling a wide range of automation and interaction possibilities.

VBA Code:

• Write VBA code to establish serial communication with the Arduino and send commands. For example:
• Sub SendCommandToArduino(command As String)
•   Dim serialPort As Object
•   Set serialPort = CreateObject("WScript.Shell")
• 
  
•   serialPort.Run "cmd /C mode COM3: baud=9600 parity=n data=8 stop=1"
•   serialPort.SendKeys command
• End Sub

How about controlling an 8051 microcontroller AT89C52 via VBA in microsoft excel?

Controlling an 8051 Microcontroller (AT89C52) via VBA in Microsoft Excel

Understanding the Components:

• 8051 Microcontroller (AT89C52): A popular microcontroller with a rich feature set, including 8-bit CPU, internal ROM and RAM, and serial communication capabilities.
• VBA (Visual Basic for Applications): A programming language built into Excel that can automate tasks and interact with external systems.
• Serial Communication: A method of transmitting data between devices, often used for microcontrollers and computers.

Steps Involved:

1. 8051 Setup:

   • Connect the AT89C52 microcontroller to your computer using a USB-to-serial converter.
   • Write an 8051 assembly program that listens for serial data and responds accordingly. For example:

; Initialize serial port

MOV PCON,#0x80 ; Enable serial port

MOV SCON,#0x50 ; 8-bit data, variable baud rate

MOV TMOD,#0x20 ; Timer 1 in mode 2 for serial communication

MOV TH1,#0xFD ; Set baud rate (9600 baud)

MOV TR1,#1 ; Start timer 1

; Main loop

LOOP:

  JNB RI,LOOP ; Wait for receive interrupt

  MOV A,SBUF ; Read received data

  ; Process received data and send response

END:

  JMP LOOP

VBA Setup:

• Open a new Excel workbook.
• Press Alt + F11 to open the VBA editor.
• Insert a new module.

VBA Code:

• Write VBA code to establish serial communication with the 8051 and send commands. For example:

VB.NET

Sub SendCommandTo8051(command As String)

  Dim serialPort As Object

  Set serialPort = CreateObject("WScript.Shell")

  serialPort.Run "cmd /C mode COM3: baud=9600 parity=n data=8 stop=1"

  serialPort.SendKeys command

End Sub

1. Replace COM3 with the actual port number where your microcontroller is connected.

2. Excel Interface:

   • Create a button or other user interface element in your Excel workbook.
   • Assign a macro to the element that calls the SendCommandTo8051 function with the desired command.

Additional Considerations:

• Error Handling: Implement error handling in your VBA code to catch potential exceptions, such as when the serial port is unavailable.
• Data Exchange: For more complex data exchange between Excel and the 8051, consider using a structured format like JSON or XML.
• Libraries: Explore libraries like Win32API or MSComm for more advanced serial communication features in VBA.
• Security: If you're dealing with sensitive data, ensure proper security measures are in place to protect your communication.

By following these steps, you can effectively control an 8051 microcontroller (AT89C52) from Excel spreadsheets using VBA, enabling a wide range of automation and interaction possibilities.

Incorporating an RTOS into the AT89C52: A Guide

Understanding the Components:

• AT89C52: A popular 8-bit microcontroller with limited resources.
• RTOS (Real-Time Operating System): A software system that manages tasks in a real-time environment, prioritizing tasks based on their deadlines.

Challenges and Considerations:

• Limited Resources: The AT89C52 has limited memory and processing power, making it challenging to run a full-fledged RTOS.
• Real-Time Constraints: RTOSs often require precise timing and predictable task execution, which can be difficult to achieve on a microcontroller with limited resources.

Approaches:

1. Custom RTOS:

   • Tailored for the AT89C52: Develop a custom RTOS specifically designed for the AT89C52's limitations. This approach offers maximum control but requires significant development effort.
   • Prioritize Tasks: Implement a task scheduler that prioritizes tasks based on their deadlines and the available resources.
   • Optimize Code: Use assembly language or carefully optimized C code to minimize code size and execution time.

2. Tiny RTOS:

   • Lightweight RTOS: Use a tiny RTOS specifically designed for resource-constrained microcontrollers. These RTOSs often have limited features but can provide basic task management and scheduling capabilities.
   • Examples: FreeRTOS, ChibiOS, RTX-Tiny.
   • Integration: Follow the RTOS's specific integration guidelines and adapt your application code to work within the RTOS environment.

3. Task Scheduling Library:

   • Basic Task Management: Implement a task scheduling library without the full overhead of an RTOS. This approach offers more flexibility but requires careful management of task priorities and synchronization.
   • Custom Implementation: Develop your own task scheduling library based on your specific needs and the AT89C52's capabilities.

Key Considerations:

• Task Prioritization: Define clear task priorities based on their deadlines and importance.
• Synchronization: Implement mechanisms to prevent race conditions and ensure correct task execution.
• Interrupt Handling: Handle interrupts efficiently to avoid missing critical events.
• Memory Management: Optimize memory usage to avoid memory fragmentation and ensure sufficient resources for tasks.
• Testing and Debugging: Thoroughly test your RTOS implementation to identify and fix any issues before deploying your application.

Conclusion:

Incorporating an RTOS into the AT89C52 can be challenging due to its limited resources. However, by carefully considering the approaches outlined above and addressing the key challenges, it is possible to achieve real-time capabilities and improve the responsiveness of your application. The choice of approach will depend on your specific requirements, the available resources, and your development expertise.

what are the advantages of having RTOS in AT89C51 microcontrollers when employed in academic laboratories of 1) https://srmvalliammai.ac.in/wp-content/uploads/2022/11/1906305-analog-and-digital-electronics-laboratory-manual.pdf 2) https://www.azdocuments.in/2023/05/communication-laboratory-i-21ecl46.html 3) https://www.sircrrengg.ac.in/images/Others/ECE/AECLAB.pdf 4) https://sites.google.com/yit.edu.in/21ec581iotlab2023-24oddsem 5) https://bmsit.ac.in/public/assets/pdf/ece/studymaterial/18ECL38%20-%20Hamsavahini%20R.pdf 6) https://atria.edu/assets/ece/manuals/mc.pdf 7) https://www.vsmsrkit.edu.in/files/downloads/ec/4th_SEM_AC_LAB_Manual(18ECL48).pdf 8) https://atria.edu/assets/ece/manuals/hdl.pdf

Advantages of RTOS in AT89C51 microcontrollers:

• Improved modularity and code organization: RTOS enables you to break down your program into smaller, independent tasks that can be developed and tested separately. This improves code maintainability and reusability.
• Enhanced real-time performance: RTOS provides a mechanism for prioritizing tasks and ensuring they are executed within their deadlines. This is crucial for applications that require predictable timing behavior.
• Efficient resource management: RTOS helps manage resources like memory and peripherals efficiently, allowing you to make the most of the limited resources available on the AT89C51.
• Simplified multitasking: RTOS simplifies the development of multitasking applications by handling task scheduling, synchronization, and communication. This allows you to focus on the application logic rather than low-level scheduling details.
• Improved responsiveness: With an RTOS, your application can respond to events and interrupts more efficiently, leading to a more responsive user experience.

Overall, using an RTOS with the AT89C51 microcontroller can be beneficial for applications that require real-time performance, modularity, and efficient resource management, especially in an academic lab setting where students might be working on projects with these requirements.

If you'd like to learn more about specific RTOS options for the AT89C51, I can help you search for that information as well.

•