Microsoft Excel 2007 and beyond- The Logical If Function

 

Microsoft excel is a spread sheet application package designed mainly for statistical and mathematical computation. The built in function in Microsoft (MS) excel makes if uses simple and logical, hence relieving it user(s) of most common computational task like computation of student results, Salary payment sheet, pension sheet and more. This is only achievable by inputting logical formula into cell(s)

The logical If Function.

IF(logical_test, value_if_true, value_if_false,)

The major thing to note here is these three items between the round brackets of the word IF above. These are the arguments that the IF function needs. Here's what they mean respectively;

logical_test

The first argument is what you want to test for. Is the number in the cell equal to or greater than 80?

value_if_true

This is what you wish to see when the logical IF is true/yes. That is, if the answer to the first argument is YES. (Award an “A” grade if the referred cell value is >=70 for instance)

value_if_false

This is what you want to do if the answer to the first argument is false/NO.

Should the above explanation made no sense to you, open spreadsheet on your system by following this direction “Start>All programs>Microsoft office>Microsoft excel” for practical illustration and do the following:  

 Fig 1.0  

 

I.        Enter Fig. 1.0 data into the spreadsheet (MS Excel) you just opened. 

II. Place your cursor on cell D4, in the “Grade” column and input/type =IF(C4>=70,"A",IF(C4>=60,"B",IF(C4>=50,"C",IF(C4>=45,"D",IF(C4>=40,"E",IF(C4<=39,"F"))))))onlythe logical formula in red should be typed into cell D4. 

 III.        Hit the enter key on your keyboard to activate the command. If you have done it according, “B” will appear in that cell (D4). To have grade displayed in the rest of the cells in grade column, place your cursor on cell D4 where grade “B” is and copy the content of that cell painstakingly. Now, select the rest cells in the grade column which has no grade for scores and paste the content of D4 that you have just copied. If you have done it correctly, all the scores should have grades now accordingly.

Note; what you copied from cell D4 is not the displayed “B” but the formula that produced “B”

                        Fig 2.0

                                  IV.        The next task is to format the remark column so that each cell in that column can have either “pass” or “Fail” remark according to student score. In same manner, place your cursor on cell E4 and input/type =IF(C4<40,"Fail","Pass") then hit the enter key to activate the command. If you have typed it correctly, “pass” will be seen in that cell. Now, place your cursor on cell E4 with the remark “pass” and copy it content carefully. Select the rest cells in the remark column where there is no remark and past the copied information to have remark display against every score in the spreadsheet.

                                                  Fig 3.0

Note;Ensure you have all the commas, double quotes and bracket in the correct places, otherwise Excel will give you an error message. The right angle bracket “( >)” is known as Conditional Operator.

 

Summary

The whole grammar above means just three (3) things:-

I.              logical_test: Is the value in cell C4 greater than or equal 70?

II.            value_if_true: If the answer is Yes, display the grade "A” or if it is >=60, display grade “B” or if it is >=50, display grade “C” or if it is >=45, display grade “D” or if it is >=40, display grade “E” or if it is <=39, display grade “F” 

III.           value_if_false: This also draw response from II above.

All of the three (3) put together give IF(logical_test, value_if_true, value_if_false,)

You tell Excel what you want to check for in the cell, then what you want to do if the answer is YES, and finally what you want to do if the answer is NO. You separate each part with a comma, Proper double quote and close every opened bracket.

Keep in touch for update in the future.

Use your smartphone as a Wi-Fi hotspot: Tethering

The connection uncertainty among digital service provider over the years has strongly encouraged multiple phones for individual to minimize missing important calls experience. It is common today to see an individual with multiple smartphone with different service provider, the BIG question now is: Should this individual also pay for multiple internet services?  

It is of commonly knowledge that the entire mobile services provider now provide daily or weekly or monthly data plan to their subscribers depending on the choice of service by the subscriber. It will interest you to note that advancement in technology has unveiled us with the  possibility of sharing data plan of a smartphone among other smartphone, tablet or laptop via tethering by using one of the smartphone as wi-fi hotspot as outline below.

Guide to tethering in smartphone

What is Tethering?

Tethering is the use of smartphone to offer internet access to other Internet-enabled mobile device such as PDAs, Laptop, IPhones etc. In a simple term, Tethering is the process of sharing a smartphone internet access among others.   The connection is made either with a cable (USB or serial) or wirelessly through bluetooth or Wi-Fi or the good old days IrDA (infrared). Tethering enables users to go online from their laptops or PDAs in situations where there is no other means of Internet access: If you are already paying for data service on any of your smartphone and your service provider does not require any extra fees for using your cell phone as a modem for your laptop, tethering can also save you money, since you will not have to pay for separate mobile broadband service or buy additional hardware just to get your laptop connected to the internet. With tethering, you can share the data plan of your smartphone with other devices such as a tablet or laptop.

A smartphone's small screen is not in most cases convenient to be used for browsing as compare to that of tablet when it comes to web or streaming videos from the net. But tethering offers you the opportunity to use your smartphone as a portable Wi-Fi hotspot, and share its data connection with your Wi-Fi-only tablet. This setup is called tethering or internet sharing, and many smartphones provide this feature, including iPhones, BlackBerrys, Windows Phones and, of course, Android handsets.

General guide to tethering

To every smartphone (Android, iPhone, BlackBerry and Windows Phones) tethering means the same thing in all mobile operating system, but is the method of setting them up that differs. As pointed earlier, Tethering is when you turn your smartphone into a mobile Wi-Fi hotspot and share your phones 3G/4G data connection. Once you have turned tethering on, any device with a wireless connection can connect to the internet via your smartphone's connection and this is where security issue will be of importance.

It is important to note that is not all smartphones that support tethering, but most popular models do, including the iPhone, Samsung Galaxy S3, Nokia Lumia 920 and BlackBerry Z10. Tethering is not limited to the use of Wi-Fi to share your smartphone's internet connection: some now allow you to connect a laptop or tablet possibly through a universal serial bus (USB) cable. Alternatively, you might be able to use Bluetooth.

Regardless of the connection method, it's important to check whether your mobile tariff allows tethering before using your smartphone as a Wi-Fi hotspot. In some cases, the mobile operator can prevent the option from appearing on your handset if tethering is not part of the deal. iPhone owners can attest to this because Personal Hotspot does not show up in the General settings menu in most iphones.

Available alternative to tethering if one is denied by phone manufacturer.

First, and most obviously, you could switch to a different operator or tariff (or request a bolt-on to your current tariff) that allows you to use your smartphone as a Wi-Fi hotspot. That might mean paying more each month, but it's likely to work out cheaper than the alternatives.

If you haven't already bought a tablet, you might consider buying one with 3G or 4G support. You'd then have to get a data-only SIM card for it, and either pay monthly or pay as you go for this separate tariff.

How do I setup tethering on my device?

The process is straight forward that involves enabling the hotspot option on your phone and most importantly, configuring wireless security with a password to prevent other people wireless device into your connection, then connecting your tablet to the wireless network just as you would with any hotspot. If you have configured your device properly, tethering just work.

In some cases, You will have to enter the password once to connect, but on subsequent occasions, your tablet connect automatically.

Some major challenges of tethering

Some of the major problems in tethering (i.e using your phone as a portable Wi-Fi hotspot) are that your tablet will assume it is connected to a fixed data plan or broadband line and ignore all mobile data plan limitations thereby using the bandwidth extravagantly. The implication of this is that, it will use up your limited monthly data allowance very quickly. What your smartphone would have ignored during browsing normally on mobile data plan (downloading application updates and any other large data files) your tablet would assume its ok with tethering and download everything downloadable during access thereby consuming bandwidth in great amount. Hence, you are strongly advice in your own interest to either disable automatic updates or download. Better still, maintain a close attention on download behaviors and how much data is being used by looking in your phone's settings or through a dedicated application you may have installed earlier.

It will be wise decision to disable the hotspot running on your smartphone when you are no longer using to prolong your battery life.

I`m Watch

                                                                         

Italy has made history with creativity and style in our world of technological dispensation without compromise. Smartwatch has taken a new look and can now be worn on the wrist just as wrist watch with mind blowing, mouth-watering and head banging applications and functionalities. I’m Watch is the perfect combination of the most innovative Italian technology and a unique, unmistakable style. High-quality materials and excellent manufacturing standards make it comfortable, durable and attractive to see and to wear. I’m Watch is designed, engineered and built entirely in Italy. i’m Watch is much more than a watch. It is a latest generation device that makes the most of your smartphone. With i’m Watch, you can leave the phone in your pocket, in your purse, on your desk and what have you and connect to it via Bluetooth with full functionality on your wrist. It comes in different factory designed style to suite your distinct fashion and style in fact, the new smartwatch is like you: i'm Watch Color in aluminum is young, dynamic, Tech in titanium is durable and stylish and elegant in all dimension. This im watch technology is affordable Starting from $ 299.00 against the suppose $ 399.00 and can be purchase online though this available off is limited online store.  

Everything that could be achieve with modern smartphone (such as calls, sms, e-mails, music and Apps) is achieve also in the new Italy i`m watch that communicates with your smartphone with crystal clear and bright display. If you receive a call on i`m watch, you can see who calls, wherever you left your smartphone provide your smartphone is within Bluetooth distance (about 10M away). Not your usual store but a treasure trove of hundreds of apps ready to be downloaded and installed on your i’m Watch. Customize as you like and add many new functions: leisure, games, office, useful applications, music; there is no limit to the imagination of the developers who work for your i’m Watch world’s most advanced smartwatch operating system. The software that controls i’m Watch is a condensed form of the best technologies. With a single gesture, you open and close applications, receive social networking notifications and read e-mails. And even with all this power - and the compact dimensions of a watch - the battery goes on and on. I call this A small, BIG technological miracle in our modern day world of technology Be in touch of with your smartphone always to avoid miss calls. I’m Watch connects to your smartphone via Bluetooth, and thanks to the i’m android 2 operating system, it runs all the main functions. And if you want to use the Internet from i’m Watch, it goes through your smartphone, in “tethering” mode.
                                                     

 BELOW ARE THE SOME OF THE ATTRACTING FEATURES OF I`M WATCH  

                                                                        Calls

 If you receive a call, you can see who’s calling, wherever you left your smartphone. Make a call straight from your i’m Watch by dialing the number or selecting a contact from your Address book 

                                                                         SMS 

Receive and read all your texts directly on your i’m Watch display. Think later about how to reply.

                                                                        E-mail

  Don’t miss a single e-mail: Mail is perfect for managing your e-mail in any situation. Appointments Not just any old calendar but a complete management system for events and appointments.

 Waoo you may say, but we are not stopping here technologically because the best is yet to happen. 

                                                     

CARRER CHOICE IN COMPUTER SCIENCE

Computer Science usually abbreviated as CS is the science that practically deals with computation and its application. Computer science is one of today’s hottest/top majors, according to the Princeton Review. With new technological innovations driving up the demand for skilled scientists, computer science majors have a number of exciting career opportunities open to them, in anything from cloud computing to mobile application development. 

Furthermore, many computer science jobs have seen significant growth in recent time due to businesses and organizations increasing their reliance on technology to advertise their products and services and possibly trade electronically. Computer science is a wide field hence individuals who are interested in choosing a career in  the field can make a choice from the under listed.  

1. Software Engineer
2. Java Developer
3. System Analyst
4. .NET Developer
5. Software Developer
6. Web Developer
7.  Systems Administrator
8.  Project Manager
9. Network Engineer
10. Systems Engineer
11. Graphic Designer
12. Data Administrator
13. Computer Instructor/Lecturer

Employment opportunities for computer scientists are expected to increase 21% between 2012 - 2020. Computer science field is one field that is open to all irrespective of individual discipline which is one of the competitive factor also in computer science today. Caleb whom studied Agricultural science in the university diverted into networking and graphics design after graduation and become a good competitor to Ezinne who originally studied computer science. Read more

WHY PASSWORD SECURITY ON MY DEVICE?

Device could be any electronic machine where information is contained /stored. Some good examples of device are Mobile phone, PCs, USB Flash drive, Hard disk drive (HDD) and the like. Password is what protects your file/document or device from being access by others either on a network or directly on the system. When choosing a password, make sure your choice is not what can be easily guessed by people that know you. It is advice that you do not use your name, surname and date of birth as password since any of these could be easily guessed by pals or relations. There are different levels of password, these ranges from simple level to complex level. A given password is considered simple if it alphabetical phrase only like AROME or arome or numerical only like 12345 or 54321. It is obvious that any of this can be guessed by people that are close to you. When choosing a password, choose a complex level password which is the combination of numerical symbols, numerical symbols and even special symbols like %#Arome23 or 32#abc2&wa. It takes special software like Horse to reveal a complex password like this. You are strongly advice in your own interest to have a diary where your password can be written should it escape your mind otherwise you will be at some experts mercies.

In the wake of a couple of massive security breaches, security experts have advised that we have a password on every of our device containing information that we considered vital either on the network or directly on the system. Device manufacturers are aware of this that is why almost all the device that can be purchased today comes with password capacity to prevent unauthorized access to devices. By now you have probably heard the time-worn guidelines for creating strong passwords: Don’t use your name or other common words. Use different passwords for different sites. Change them often. Choose security questions that don’t involve information that everyone knows about you, or stuff that crooks can easily find on your social network like Facebook, Twitter etc.

IS TECHNOLOGY A RIGHT MOVE IN A GOOD DIRECTION?

The consistent growth of technology in our modern world today is gradually humbling the universe with diverse innovations of the brave mind. The world is rapidly changing that we wake up every day to realize what we knew yesterday is no longer relevant today thereby compiling us to be consistently update our knowledge base as to meet up with the unforeseen technological challenges. Before the advent of wireless digital mobile phone in Nigeria in 2001, communication was done on the then popular NITEL land line where callers and receivers journey to make and receive their calls respectively. This mobile phone was then mainly for certain individuals who were rated above the middle class but today, the story has a new song as even the beggar on the street is now a proud owner of smartphone having access to the entire world from a given geographical location, buying and selling without having a glimpse of how the manufacturers factories and store house look like. Individual now run their daily bank transaction using technology hence bringing the services of bank staff to minimal and this has cost many their jobs in recent time in the banking industries to be precise where mass retrenchment ensue periodically after technological advancement. The current cashless policy can attest to this fact where numbers of staff at the bank counter were drastically reduced thereby increasing the unemployment rate.  While many have come to believe that technology has brought positive results to the society because of the present improvement in the social well-being, some are still skeptical. Nevertheless if there were no technology, you wouldn’t have been able to read this post.
Technology has undoubtedly enhanced modern life in many ways to mention but a few are in communication, transportation and sciences. Before the invention of telegram and telephones, taking information from one place to another was quite challenging and unmanageable. If we look at it critically today, the revise is the case. Information can now be conveyed swiftly from one end to another within a twinkle of an eye. The global news networks had also aided people all over the world through information dissemination. For instance, news can be presented on website and social network (Facebook, tweeter, etc.) about what is happening on the other side of the world, weather forecast and natural disasters are foretold before they occur base on feasibility studies. click here for further piece

Life event can be viewed from distance as it happen crystal clear via remote computer/telecast, places can be monitored via CCTV-www.stencomm.com and record for playback with good visibility, employers can monitor the timing of his/her employee with time attendance register, fire out break can be monitored with fire alarm system and all of that. All of the aforementioned were in the time past human responsibilities and now that they are handled technologically and denying people of their jobs , the big question is “Is technology a right move in a good direction?

A wise man once said “In life, if you solved a problem you have only succeeded in creating more problems”. Technology were meant to add colour to life, relieving people of their daily stress by simplifying life, but in life, everything that has a good side also has a negative aspect in which technology is no exception.

Nissan launches Nismo smartwatch for drivers

 
The smartwatch aims to unite driver and car

A smartwatch that monitors the performance of a vehicle as well as the driver has been launched by car manufacturer Nissan.

Like many other smartwatches, the Nissan Nismo measures the user's heart rate, temperature and other biometrics.
But it also allows users to keep an eye on their car's performance - including average speeds and fuel consumption.
Experts say that the watch could be an important step towards greater connectivity in cars.
"Connectivity is the new battleground for car manufacturers," said Chas Hallett, editor-in-chief of What Car?
"In-car internet is coming and now with consumer electronics focusing on watch-based connections, Nissan is getting ahead of the game and joining the two together very cleverly."
The Nismo watch can be connected to the car's on-board computer system to allow users to monitor vehicle telematics and performance data. Users can also receive tailored messages from Nissan via the gadget.
It was unveiled ahead of the Frankfurt Motor Show, which runs until 22 September.
Concentration levels

Samsung has just released its first smartwatch - the Galaxy Gear

"Wearable technology is fast becoming the next big thing and we want to take advantage of this innovative technology," said Gareth Dunsmore, marketing communications general manager at Nissan, Europe.
A glut of smartwatches has hit the market recently, including Samsung's Galaxy Gear and Sony's Smartwatch 2.
Car-connected watches could be even more useful than those offered by consumer electronic firms, thinks Mr Hallett.
"Imagine if you could heat up your car on a cold day before you got into it or shut the roof of your convertible when it started raining and it was parked outside," he said.
The Nissan Leaf electric car already allows users to interact with it via their mobile phone, said Mr Dunsmore, and such functionality should be available in the firm's next-generation watches.
The current gadget is one of the first products to come out of its Nismo laboratory, which captures live biometric and telematics data from Nissan racing cars and their drivers.
The lab plans to use electrocardiograms (ECG) and electroencephalograms (EEG) in the future to capture a range of heart and brainwave data.
The eventual aim would be to create wearable technology for drivers that can spot fatigue, monitor drivers' levels of concentration and emotions and record hydration levels.
The Nismo, which comes in three colours and has a battery life of around a week, can be controlled by two buttons on the screen.

Formula E to use Qualcomm technologies in electric cars

Smartphone chipmaker Qualcomm has signed a sponsorship deal with the forthcoming Formula E championship.

The FIA international motorsports body plans to launch the electric-car competition next year as an alternative to Formula 1.
Qualcomm will provide wireless-charging and augmented-reality technology to help the teams taking part and the public watching the races.
It has also pledged an undisclosed sum of money as part of the five-year deal.
Both organisations said the intention of the championship was to both provide entertainment and to spur on electric-vehicle technologies.
One analyst said the events could help improve the public's perception of electric cars, but added there would need to be other developments if the tech was to go mainstream.
The FIA itself acknowledged change would not come overnight.
"We will make people more inclined to buy an electric car, but this will take time - five or 10 years," Formula E's chief executive Alejandro Agag told the BBC.
Wire-free recharges Among the products Qualcomm plans to offer is its wireless vehicle-charging tech, Halo.
The facility - which is being developed by the company's London-based lab - creates an electromagnetic field using a copper pad buried in the ground. This can be picked up by a coil built into a vehicle, which converts it into electricity to power-up a battery.
British Formula E team Drayson Racing Technologies has already tested a customised version of Halo as a way of charging its vehicles when they are stationary.

The FIA will unveil a Qualcomm-branded Formula E car later this week

However, the intention is to use the tech to recharge only the competition's safety vehicle during the first year of the championship before extending it to the competitors' cars in either year two or three.
In time, Qualcomm said, several pads could be built into the city centre roads used by the races to provide "dynamic charging" - the ability for the cars to top up their power on the go, helping them complete the race in quicker time.
South Korea has already pioneered something similar, using a locally developed variant of mobile recharging tech called OLEV to power buses on a set route.
However, such schemes are costly and the FIA said it recognised the competition would need to prove popular if it was to raise the sums necessary to pay for the installation of the many pads required.
Live updates Qualcomm also intends to help design the telemetrics system used by the race - the automated process that monitors the vehicles taking part.
"Tyre pressure, engine, fuel, brake fluid, speed, torque - all sorts of things will be monitored on a miniscule nanosecond by nanosecond basis," explained Anand Chandrasekher, Qualcomm's chief marketing officer.

Former F1 driver Lucas di Grassi was appointed Formula E's series test driver last year

"Those streams of data will be sent real-time to a central area where the teams will be able to get access to that information and use it with their own proprietary software to say, 'OK, what guidance should we provide the driver as to what he or she should be doing in real time?'"
He added the information would also be able to be accessed by the public through the planned roll-out of its Vuforia software.
The app promises to offer an "augmented reality" view of the race, allowing spectators to carry on watching the car of their choice even if buildings or other objects obstruct their view by holding up their smartphone or tablet to make the vehicle visible.
Mr Chandrasekher said the public would be able to bring up the same real-time performance data as the racers' support teams, using the progam.
'Psychological impact' Formula E is scheduled to commence in September 2014 in London, with races to follow in nine other cities including Beijing and Los Angeles.
Ten teams, each with two drivers, will compete against each other over the course of an hour.
Mr Agag said he believed the events would appeal to a younger audience than that typically attracted to Formula 1, and he hoped many of the fans would end up becoming electric car owners.
"We think Formula E can be a platform where companies can showcase and develop and improve technologies for electric road cars," he said.

The Spark-Renault SRT-01E will be one of the cars competing in the Formula E competition

"We will demonstrate that batteries will offer more performance and go longer. At the beginning [the drivers] will swap cars, but this will stop as the batteries improve, and people will see the cars go faster.
"This, we hope, will have a psychological impact and make people more inclined to buy an electric car."
One independent automobile expert agreed the competition could prove influential.
"There's a perception issue with electric vehicles - people worry about how far they will go and the cost of the batteries," said Prof David Bailey, from Coventry Business School.
"This could show people how well they work.
"But a lot of other things need to happen including changes in government policy if there's to be the necessary investment in wireless charging and other infrastructure beyond the racetracks."

How schools will boot up a new ICT curriculum by Jane Wakefield

Will children return after the summer holidays to radically different ICT lessons? 
What is your wish for your child(ren) towards the rapidly technological growth in our world today? If you think learning is the best way then the piece below by Jane Wakefield will impress you.

As the schools in England close for the summer holidays, the planning of lessons in September is probably not top of teachers' to-do lists.

But information and communications technology (ICT) specialists could find they have to grapple with the issue sooner than their colleagues, as the government aims to overhaul the way the subject is taught.
Education Secretary Michael Gove kick-started the process back in January by saying current ICT lessons were "demotivating and dull' and needed radical reform.
Schools, he said, needed to ditch lessons on how to use Powerpoint in favour of getting the kids designing apps and learning to code.
The speech took ICT teachers by surprise and many are still no clearer about what is expected of them when schools return for a new academic year.
"The framework for ICT and the exams changed without any warning or training," said Carol Dawkins, an IT teacher at Toynbee School in Chandlers Ford.
"There has been no preparation or consultation with teachers."
Peter Mapstone, head of IT at King Edward V1, an independent school in Hampshire, said: "It is the right idea, but it has been done very quickly."
"There has been some confusion and there is still a question of, 'What do we do?'"
Following Mr Gove's speech, the government made two important changes for ICT.
It has scrapped the programme of work that dictated what teachers taught in the first three years of secondary school.
And children wishing to take ICT to exam level will have fewer choices, with more emphasis on computer science.
For Mr Mapstone there is one glaring problem with the government's desire to see more teaching about how computers actually work.
"There aren't enough skilled teachers to deliver computer programming," he said.
According to government statistics only 35% of ICT teachers are specialists, compared with more than 80% for core subjects such as maths and English.
What exam?

The government wants to see more coding in the classroom

Prof Matthew Harrison, director of education at the Royal Academy of Engineering, agrees there could be a shortage.
"A degree in computer science is very lucrative on the open market," he said.
"Graduates go and get a job in computing and earn a lot of money."
But he thinks that the changes were necessary.
"Some ICT lessons had become pedestrian," he said.
"There were many different qualifications and different options within them. Many were about digital literacy, which is not going set people up for progression in computing beyond the age of 16."
The academy has prepared a guide, breaking down the qualifications now recognised by government into three distinct categories - digital literacy, IT and computer science - to help schools decide which ones to offer.
Ms Dawkins says a narrow computer-science-based curriculum could have unintended consequences.
"As a result of the government's new policy, there is a question mark over which exams are acceptable," she said.
"Now government wants us to go down a more academic route, it has narrowed down the qualifications that are recognised, which may mean we get even less people choosing it."
The Department for Education is clear that schools must take the initiative when it comes to teaching ICT.
"The current ICT curriculum is weak and outdated," a spokeswoman told the BBC.
"We must give teachers freedom over what and how to teach - so pupils can access up-to-date and relevant ICT and computer science resources, rather than an invalid and prescriptive curriculum."
The government was "expecting schools to take the lead and come up with innovative ways to teach ICT," she added.
Google teachers

 

The Google teachers will be equipped with devices such as the Raspberry Pi

Some believe the debate about the state of ICT teaching in the UK was kick-started by Google chairman Eric Schmidt who, in a speech last August, said the UK was throwing away its computing heritage and lacked trained specialists.
Computer science education, he said, was in a "sorry state".
In May, Google unveiled a plan to invest in computer science teachers via the Teach First charity, which puts "exceptional" graduates on a six-week training programme before deploying them to schools where they teach for a two-year period. It aims to train 100 such graduates over the next three years.
Each will have a bursary to buy equipment, such as Raspberry Pi or Arduino computer kits.
Partnerships with industry are just one of many innovative ways that ICT can be taught, according to Prof Harrison.
"You can bring in volunteers from industry to buddy with teachers," he said.
"We have already seen that happen in design and technology, where engineers were deployed alongside teachers."
ICT, he says, needs a campaign similar to the London Evening Standard newspaper's recent literacy campaign, which called for volunteers to spend an hour a week in classrooms helping primary school children learn to read.
There is also a lot of scope for crowd-sourcing expertise. Computing At Schools is a grass-roots group that aims to share expertise among like-minded teachers.
But these are only short-term quick fixes and a more long-term vision is also necessary, according to Prof Harrison.
"If, like I do, you believe that computing is vital component of the UK economy going forward then you have to invest and plan for it," he said.
"You have to recruit specialists and deploy them widely in schools. Computing needs to be seen as an important part of the education landscape, on a par with maths and physics."