Is there any Windows software available which monitors the CPU usage of the system & records it (keep logs of the monitoring)?
This is a little open with regards to detail. You have set little to no requirements such as free\paid, open source etc. so I will answer this the best I can. Yes - there are a number of tools you can use.
Option 1 - DIY
Through an elevated command prompt you can run the following:
typeperf "\processor(_total)\% processor time" && wmic cpu get loadpercentage
Then simply output the data to a csv or text file. Using
>>Output.txt would be sufficient.
Option 2 - Open Hardware monitor
Monitoring of CPU and outputting data can be performed via: Open hardware monitor. This is a good option for a free monitoring solution to a PC. If you want to know more about what it monitors before downloading check here.
Option 3 - CPU ID
CPU ID is probably the more well known tool. This software can monitor your PC and export it into a csv file per monitor - i.e. CPU_Core1_Thread1_Heat or CPU_Core1_Usage.
This tool is free for use and can be downloaded here.
Lastly do some research and review the tools in this here.
If there is any particular feature you're chasing let me know and I will investigate for you. If you feel as though I have answered this, mark it so.