SOLUTION: Expressions vs Equations | My Assignment Tutor

DHICTWeek 3Adapted by Dr Colin FuAre you in the right session?• Please check your Time-table that you are meant to be in this lesson?• Check your time• Check your tutor name• It is important that you are in the correct lesson!Expressions vs EquationsIn maths…In ExcelFormulasFormula DetailsFormula DetailsFormula DetailsExcel FormulaFor now, just to know…• We will gothrough allthese one-byone :Arithmetic OperationsIn ExcelArithmetic Operators• Tutor demonstrates the applications on Excel live during the sessionIn ExcelComparison operators• Tutor demonstrates the applications on Excel live during the sessionIn ExcelText Concatenation Operator• Tutor demonstrates the applications on Excel live during the sessionA Question for you…Solutions• Did you get the answer?• That is why data Analytics are important!So?•And about Data Analytics!Types of NumbersTypes of NumbersTypes of NumbersTypes of Numbers (a more complete picture)• Only for your information…Also… within the Integers• Even and odd numbers: An integer is even if it is a multiple of 2,and is odd otherwise.• Prime number: A positive integer with exactly twopositive divisors: can be divided by itself and 1. The primesform an infinite sequence 2, 3, 5, 7, 11, 13, 17, 19, 23, 29, 31, …• Composite number: A positive integer that can be factored intoa product of smaller positive integers, i.e. can be divided by atleast one integer apart from itself and 1. Every integer greaterthan one is either prime or composite.…and hence…Types of NumbersNumbering SystemArithmetic in Excel!• Tutors demonstrates Arithmetic applications on ExcelBIDMAS in Excel• You do the following on Excel…BIDMAS in Excel• You do the following on Excel… by adding across the row and columnsBIDMAS in Excel – AnswersBIDMAS in Excel• You do the following on Excel…BIDMAS in Excel• You do the following on Excel…BIDMAS in Excel• You do the following on Excel…BIDMAS in ExcelIn mathsBIDMAS in Excel• Repeat the following in ExcelBIDMAS in Excel• You do the following on ExcelDo you remember these?Guess which is the answer?Even in Excel, you have to know…In Excel…In Excel…Using Excel, you also needs to appreciatethat…Using Excel, you also needs to appreciatethat…Compare your answers…• Manual vs Excel calculations…Reference Operators (only in Excel)In ExcelReference Operators• Tutor demonstrates the applications on Excel live during the sessionThe Order of Operations in Excel (in FULL)Exercises• -10^2• 10^2• -(10^2)• (-10)^2Exercises• Do these in Excel:Exercises – AnswersAnomaly?• Compare the answers for the following in Excel:Anomaly!• You know why the answers are different?Anomaly!• As you can see, there are two different results because of the ‘left toright’ order that the multiply and divides are done.• The lesson …• Use brackets (or parentheses if you prefer) whenever you think extraclarity is necessary.• Unlike math teachers, Excel won’t deduct marks for unnecessary extra ()!Note 1: Always use cell referencesNote 2: Use brackets whenever necessaryCan you do all these in…EXCEL ?Important that you …• … you watch the videos before coming to the lesson, and practise allthe quizzes… if you want to do well…• This module is not easy…• Videos• Watch the this week videos? They are important.• You need to watch next week videos too before nextsession.• Quizzes• You attempted the quizzes?• Activities (Apply and Consolidate)• How about all other activities (Apply and Consolidate)?Have you?63 ICT• students doing ICT… who must be able to use ICT tofind information independently before asking• Note: It is for wo(man) too Important especially for …64 ICT• We are here to support you … most importantly be anindependent Expert!• Please always check the announcement, assessment pageetc. first before emailing• Have you used the discussion board for your peers toanswer you?• Note: It is wo(man)too Email65 ICTEVERYTHING• When email, please email your own tutor and mentionthe module and time you doing the ICT (we have around300 students)• Babatunde Adetayo Babatunde.Adetayo@uwl.ac.uk (Tuesday,Thursday)• Dr Suzzy Nsiegbe Suzzy.Nsiegbe@uwl.ac.uk (Tuesday)• Dr Elizabeth Scott Elizabeth.Scott@uwl.ac.uk (Thursday• We have around 100 students…• We will try to get back to you in 48 hours. If no reply after48 hours , please kindly email your tutor again copyingthe module leader, Dr Colin Fu, Colin.Fu@uwl.ac.ukEmail66 ICT