Posts

Computer Science Unit 1: Integrated Development Environment (IDE) | C Language | Lecture # 2

Image
 Integrated Development Environment (IDE) A software that provides a programming environment to facilitate programmers  in writing and executing computer programs is known as an Integrated   Development Environment (IDE). An IDE has a graphical user interface ( GUI , meaning that a user can interact with  using windows and buttons to provide input and get output. An IDE consists of  tools that help a programmer throughout the phases of writing, executing and  testing a computer program. This is achieved by combining text editors,  compilers and debuggers in a single interface.  Some of the many available IDEs  for C programming language are: 1) Visual Studio 2) Xcode 3) Code:Blocks 4) DevC++ Figure 1.1 main screen of Code::Blocks IDE Text Editor A text editor is a software that allows programmers to write ad edit computer programs. All IDEs have their own specific text editors. It is the main screen of Text editor Code::Blocks Figure 1.2: Text editor in Code::Blocks Figure

Change the case of text in excel | Using Formula | Using Macro | Skills4All

Image
Hi guys, today we will learn how we can change the case of text in excel sheet. Here we will discuss two methods to change the case of text: 1. by using formula and 2. by using macros .  First we can add formula to our Excel sheet to change case of text. To change the text to uppercase, we will use the upper function =UPPER(cell ref) and will give the reference of the cell in argument to whom we want to change the case.  Secondly, if you want to change the case of your text to lowercase then use the formula lower  =LOWER(cell ref)  and give the reference of cell as an argument.  Similarly if you want to change your text to proper case, means only 1st letter will be capitalized, just use proper formula =PROPER (cell ref)  and pass the cell reference as an argument.  And now you can see the case will be changed as you will press enter. you can use fill handle to copy the formula in lower cells as well. Important thing is that if you remove the data from the cells that you have given as a

Computer Science Unit 1: Introduction to Programming | C Language | Lecture # 1

Unit Introduction Computers have turned into a significant piece of our day to day routines. They can help us to solve several problems ranging from complex mathematical problems and searching on the internet to controlling and operating satellites and rocket launchers. In reality, computers are not very smart on their own. In order to perform all the tasks, they have to be fed a series of instructions by humans which tell them how to behave and perform when faced with a particular type of problem. These series of instructions are known as a computer program , software, and the process of feeding or storing these instructions in the  computer is known as computer programming.  The person who knows how to  write a computer program correctly is known as a programmer. Computers cannot understand English, Urdu or any other common language that humans use for interacting with each other. They have their own special languages, designed by computer scientists. Programmers write computer prog