Index

Alphabet system, 12

Android, 28

Arithmetic logic unit (ALU), 23

ASCII table, 13, 14

Auto parts inventory file, 35

Babbage’s machine, 15

Best4UCafeFlyer document, 81–82

Binary code, 13

Binary system, 12–13

Bit, 12

Business, 17–18

Byte, 13

Central processing unit (CPU), 22–24

Cloud computing client/server, 44

definition, 44

Gmail, 46–51

infrastructure as a service, 45

investment, 44–45

platform as a service, 45

software as a service, 45

Collapse Ribbon, 64

Column heading, 70

Computers

business, 17–18

central processing unit, 22–24

devices, 17–18

evolution, 15–16

file management, 30–31

firm, 16–17

generations timeline, 16

input and output devices, 24–25

input-process-output model, 10, 11

language, 12

peripheral devices, 22

software, 26–27

Windows 10, 28–30

writing system, 12

Cone Online Influence Trend Tracker survey, 53

Consumers shopping, 6

Cover letter, 83

Data, 7

Desktop background, 29

Desktop computer, 18

Digital native, 26

Disruptive technology, 43

Document Page, 64

Document Title, 63

Document Views, 64

Domain Name Servers (DNS), 43

Double alternatives syntax, 107

Entertainment, 7

Evolution of computers, 15–16

File Explorer, 30–31

Financial issues, 37

Gmail

account creation page, 46–47

file sharing, 51

Google Drive, 49–50

Netiquette, 48

New message form, 48

Google account creation page, 46–47

Google Docs, 60

Google Drive, 49–50

Graphic elements insertion, 67–69

Guidelines formulation slide, 87

Great Deal Real State (GDRS), 19–20

Hardware

central processing unit, 22–24

microprocessor, 23

random-access memory (RAM) chip, 24

read-only memory (ROM) chip, 24

Health care, 7

Information processing cycle (IPC), 10

Information technology, 17

Infrastructure as a service (IaaS), 45

Innovation, 6

Input and output devices, 24–25

Input-process-output (IPO) model, 10–12

Insertion Point, 64

Integrated development environment (IDE), 93

Internet

ARPANET, 41

Domain Name Servers, 43

evolution and importance, 43

history of humanity, 42

social networks, 43

World Wide Web (WWW), 42

IP address, 43

Iteration control structure, 105

Join.me software, 59, 60

Kaggle platform, 93–94, 126

Laptop, 18

LinkedIn Account, 51–52

Local area network (LAN), 40

macOS X, 28

Microprocessor, 23

Microsoft Cross-Tab survey, 53

Microsoft Excel, 126

applications, 70

careers, 70

cell and range, 70

chart creation, 75

column and row, 70

data insertion, 73–74

formatting, 74

formula, 70

interface, 71–72

purchase order, 83–84

shortcuts, 72

Student Grade Book, 84–85

workbook creation, 70, 73–74

Microsoft Office, 27

Microsoft Office 2019

communication, 58–59

contract, 58

Microsoft Excel, 69–75

Microsoft PowerPoint, 76–80

Microsoft Word, 61–69

package, 61

productivity, 59

vs. Microsoft Office 365, 59

Microsoft PowerPoint

data entering, 79

interface, 77–78

investment presentation, 85–89

new presentation, 77–78

transition and animation, 79–80

Microsoft Windows, 28

Microsoft Word

cover letter, 83

elements, 63–64

features, 61–62

flyer, 81–82

formatting, 66–67

graphic elements insertion, 67–69

interface, 61, 62

new document creation, 64–65

preview and printing, 69

resumes, 82

text insertion, 64–65

Moore’s Law, 17, 23

Motherboard, 22, 23

Navigation pane, 31

Netiquette, 48

Network

characteristics, 39

communication system, 39

digital packets, 41

IP address, 43

local area network, 40

network card, 40

packet traffic, 41

switch, 40

TCP/IP, 40–41

wireless connections, 40

Network card, 40

Networking, 37

Notebook, 18

Online reputation management, 53–54

Open Office, 60

Operating system (OS), 26–28

Orbi Voice, 3

Pandas, 126

algorithm, 121

DataFrame, 118–120

modules, 116

series, 117–118

syntax, 117

Payroll data management, 123

Peripheral devices, 22

Personal computer (PC), 17–18

Platform as a service (PaaS), 45

PowerPoint, 126

Punch-card based computers, 15

Purchase order, 83–84

Python program, 126

advantages, 91

algorithm, 96

class creation, 114–116

control structure

iteration, 105

selection, 104–105

sequence, 103–104

course notebook, 97

data type conversion, 99

data types, 97

finalGrade variable, 100

FOR statement, 109–110, 110–111

function creation, 112–114

IF statement

algorithm, 108

double alternatives syntax, 107

multiple alternatives syntax, 107–108

single alternative syntax, 106

input function, 100

installation, 93

integrated development environment, 93

Kaggle platform, 93–94

notebook creation, 94–95

operating systems, 93

operators and expressions, 101–103

Pandas

algorithm, 121

DataFrame, 118–120

modules, 116

series, 117–118

syntax, 117

payroll data management, 123

readability, 91–92

variable naming rules, 98–99

variables, 98

website partnerships, 92

Random-access memory (RAM) chip, 24

Read-only memory (ROM) chip, 24

Recycle bin, 29

Resume, 82

Ribbon, 63–64

Row heading, 70

Sammsoft company, 32–33

Schlage Encode, 4

Search box, 31

Selection control structure, 104–105

Sequence control structure, 103–104

Single alternative syntax, 106

Skype, 59, 60

SmartArt

financial evaluation slide, 87

invest consulting slide, 86

investment selection slide, 88

revision and report slide, 89

Smart Home, 3–4

Smartphones, 18

Social networks, 43

Software, 26–27

Software as a Service (SaaS), 45

Spreadsheet, 70

Start menu, 29

Status Bar, 64

Student Grade Book, 84–85

Switch network, 40

Syntax, 110, 113, 114

System utilities, 27

Tablet computers, 18

TK 85 personal computer, 1, 2

Transmission Control Protocol/ Internet Protocol (TCP/IP), 40–41

The Ruler, 64

Tungle.me, 60

Virtual reality (VR) headset, 25

Windows 10, 28–30, 34–35

Workforce, 7

Worksheet, 70

World Wide Web (WWW), 42

Zoom Slider, 64