INFORMATION SCIENCE 172
LECTURES 9 - 15
, Page 1 of 42
Lathitha Sange France
Table of Contents
What Is Ethics? ................................................................................................................................ 4
The Academic Context .................................................................................................................... 4
Academic Integrity .......................................................................................................................... 4
The Rules and the Law .................................................................................................................... 4
YOU WILL BE CAUGHT ..................................................................................................................... 5
WHAT SHOULD YOU BE DOING? ..................................................................................................... 5
Turnitin Submission ........................................................................................................................ 5
Originality Report ............................................................................................................................ 7
Lecture 10: 1 MS Excel (User Interface) ............................................................................................ 8
Start Screen ..................................................................................................................................... 8
Few Basics ....................................................................................................................................... 9
Saving Your Document .................................................................................................................... 9
Lecture 10: 2 MS Excel (Basic Formatting) .................................................................................... 10
Fonts.............................................................................................................................................. 10
Alignment ...................................................................................................................................... 10
Background Colour........................................................................................................................ 10
Text orientation ............................................................................................................................ 11
Borders .......................................................................................................................................... 11
Cell Styles ...................................................................................................................................... 11
Number Formatting (Number)...................................................................................................... 12
Number Formatting (Currency) .................................................................................................... 12
Number Formatting (Advanced) ................................................................................................... 13
Wrap Text...................................................................................................................................... 15
Merge and Centre ......................................................................................................................... 15
Row Height .................................................................................................................................... 15
Column Width ............................................................................................................................... 16
Renaming Worksheets .................................................................................................................. 17
Lecture 10: MS Excel (Sort, Filter And Freeze Panes) ..................................................................... 17
Sorting Data .................................................................................................................................. 17
Sorting Data (Advanced) ............................................................................................................... 18
Filter Data...................................................................................................................................... 19
Filter Data (Remove Filter) ............................................................................................................ 19
, Page 2 of 42
Lathitha Sange France
Freese Panes (First Row) ............................................................................................................... 20
Freeze Panes (Advanced) .............................................................................................................. 20
Freeze Panes (Unfreeze) ............................................................................................................... 21
Lecture 12: 4 MS Excel (Functions) ................................................................................................. 21
Formula Fundamentals ................................................................................................................. 21
Calculations ................................................................................................................................... 21
Cell References in Formula ........................................................................................................... 22
Relative, Absolute and Mixed Cell References ............................................................................. 22
Relative Cell References ................................................................................................................... 23
Absolute Cell References .................................................................................................................. 23
Functions (HAVE TO KNOW FOR TEST) ..................................................................................... 24
Functions ........................................................................................................................................... 24
Functions – Insert Function .............................................................................................................. 24
Functions – Drop Down Menu ...................................................................................................... 25
Functions – Autocomplete ............................................................................................................ 26
Left ................................................................................................................................................ 26
Concat ........................................................................................................................................... 27
Average ......................................................................................................................................... 27
IF.................................................................................................................................................... 28
Vlookup ......................................................................................................................................... 29
Lecture 12: 5 MS Excel (Tables and Graphs) ................................................................................... 30
Creating Table ............................................................................................................................... 30
Add a Total Row to the Table ........................................................................................................ 30
Creating Chart ............................................................................................................................... 31
Chart Styles ................................................................................................................................... 32
Chart Layout .................................................................................................................................. 32
Chart additional elements............................................................................................................. 32
Data bars ....................................................................................................................................... 33
Sparklines ...................................................................................................................................... 33
Embed a chart in a word document.............................................................................................. 33
Lecture 14 MS PowerPoint (creating, deleting and layout) .............................................................. 34
Start screen ................................................................................................................................... 34
Overview ....................................................................................................................................... 35
Creating slides ............................................................................................................................... 35
Delete slides .................................................................................................................................. 36
, Page 3 of 42
Lathitha Sange France
Layout............................................................................................................................................ 36
Lecture 14: 2 MS PowerPoint (themes, transitions and animations) ................................................ 37
Theme ........................................................................................................................................... 37
Transition ...................................................................................................................................... 37
Animations .................................................................................................................................... 38
Lecture 14: 3 PowerPoint (views and Presentation) ......................................................................... 38
Slide sorter .................................................................................................................................... 38
LECTURES 9 - 15
, Page 1 of 42
Lathitha Sange France
Table of Contents
What Is Ethics? ................................................................................................................................ 4
The Academic Context .................................................................................................................... 4
Academic Integrity .......................................................................................................................... 4
The Rules and the Law .................................................................................................................... 4
YOU WILL BE CAUGHT ..................................................................................................................... 5
WHAT SHOULD YOU BE DOING? ..................................................................................................... 5
Turnitin Submission ........................................................................................................................ 5
Originality Report ............................................................................................................................ 7
Lecture 10: 1 MS Excel (User Interface) ............................................................................................ 8
Start Screen ..................................................................................................................................... 8
Few Basics ....................................................................................................................................... 9
Saving Your Document .................................................................................................................... 9
Lecture 10: 2 MS Excel (Basic Formatting) .................................................................................... 10
Fonts.............................................................................................................................................. 10
Alignment ...................................................................................................................................... 10
Background Colour........................................................................................................................ 10
Text orientation ............................................................................................................................ 11
Borders .......................................................................................................................................... 11
Cell Styles ...................................................................................................................................... 11
Number Formatting (Number)...................................................................................................... 12
Number Formatting (Currency) .................................................................................................... 12
Number Formatting (Advanced) ................................................................................................... 13
Wrap Text...................................................................................................................................... 15
Merge and Centre ......................................................................................................................... 15
Row Height .................................................................................................................................... 15
Column Width ............................................................................................................................... 16
Renaming Worksheets .................................................................................................................. 17
Lecture 10: MS Excel (Sort, Filter And Freeze Panes) ..................................................................... 17
Sorting Data .................................................................................................................................. 17
Sorting Data (Advanced) ............................................................................................................... 18
Filter Data...................................................................................................................................... 19
Filter Data (Remove Filter) ............................................................................................................ 19
, Page 2 of 42
Lathitha Sange France
Freese Panes (First Row) ............................................................................................................... 20
Freeze Panes (Advanced) .............................................................................................................. 20
Freeze Panes (Unfreeze) ............................................................................................................... 21
Lecture 12: 4 MS Excel (Functions) ................................................................................................. 21
Formula Fundamentals ................................................................................................................. 21
Calculations ................................................................................................................................... 21
Cell References in Formula ........................................................................................................... 22
Relative, Absolute and Mixed Cell References ............................................................................. 22
Relative Cell References ................................................................................................................... 23
Absolute Cell References .................................................................................................................. 23
Functions (HAVE TO KNOW FOR TEST) ..................................................................................... 24
Functions ........................................................................................................................................... 24
Functions – Insert Function .............................................................................................................. 24
Functions – Drop Down Menu ...................................................................................................... 25
Functions – Autocomplete ............................................................................................................ 26
Left ................................................................................................................................................ 26
Concat ........................................................................................................................................... 27
Average ......................................................................................................................................... 27
IF.................................................................................................................................................... 28
Vlookup ......................................................................................................................................... 29
Lecture 12: 5 MS Excel (Tables and Graphs) ................................................................................... 30
Creating Table ............................................................................................................................... 30
Add a Total Row to the Table ........................................................................................................ 30
Creating Chart ............................................................................................................................... 31
Chart Styles ................................................................................................................................... 32
Chart Layout .................................................................................................................................. 32
Chart additional elements............................................................................................................. 32
Data bars ....................................................................................................................................... 33
Sparklines ...................................................................................................................................... 33
Embed a chart in a word document.............................................................................................. 33
Lecture 14 MS PowerPoint (creating, deleting and layout) .............................................................. 34
Start screen ................................................................................................................................... 34
Overview ....................................................................................................................................... 35
Creating slides ............................................................................................................................... 35
Delete slides .................................................................................................................................. 36
, Page 3 of 42
Lathitha Sange France
Layout............................................................................................................................................ 36
Lecture 14: 2 MS PowerPoint (themes, transitions and animations) ................................................ 37
Theme ........................................................................................................................................... 37
Transition ...................................................................................................................................... 37
Animations .................................................................................................................................... 38
Lecture 14: 3 PowerPoint (views and Presentation) ......................................................................... 38
Slide sorter .................................................................................................................................... 38
