### Computer Applications in Statistics (STAT-5103)

Introduction:

This course is an introduction to basic knowledge about computer and the use of basic software’s and applications. It involves parts of a computer, transformation of data, Introduction to Microsoft Office Word, Excel and PowerPoint. It focuses on documents printing, scanning, internet application and private networks. Threats to computer security and measures to protect computer security are also parts of the course.

Learning outcomes:

• Students will able to make writeup, presentation slides and data analysis of their thesis or dissertation and other purposes.
• Students will learn internet data searching, online data saving and computer Security.
• This course will not teach Statistics but will enable students to become familiar with a basic and widely-used program for data management and analysis.

Textbooks:

1. Norton, P. (2000). Peter Norton's introduction to computers. Glencoe/McGraw-Hill.
2. Lambert, J., & Frye, C. D. (2016). Microsoft Office 2016 Step by Step. Microsoft Press.
3. Gupta, V. (2002). Statistical analysis with Excel.
4. Triola, M. F. (2013). Elementary statistics using Excel. Pearson.

Course Plan:

 Week Topics and Readings Books 1 Introduction to computers and their uses Peter Norton's introduction to computers (1-4) 2 Parts of a computer Peter Norton's introduction to computers (5-12) 3 Introduction to Microsoft Office Word 2016, Document importing, saving, converting in other applications and printing Microsoft Office 2016 Step by Step (40-60) 4 Paragraph writing, Use of Short keys, Inserting a picture Microsoft Office 2016 Step by Step (69-79) 5 Drawing table, shapes and charts, Table of Contents Microsoft Office 2016 Step by Step (79-91) 6 Equation writing, Page setup, Page numbering Microsoft Office 2016 Step by Step (96-104) 7 Introduction to Microsoft Office PowerPoint 2016, Creating slides, Inserting graphics Microsoft Office 2016 Step by Step (313-375) 8 Designing of the slides with transitions and animation Microsoft Office 2016 Step by Step (385-418) 9 Introduction to Microsoft Office Excel 2016, Data entry Microsoft Office 2016 Step by Step (198-229) 10 Importing and preparing data, Data saving, converting in other applications and printing Microsoft Office 2016 Step by Step (239-255) 11 Graphical representation and Descriptive analysis with Excel Statistics using Excel (169-177) 12 Estimation and Testing of the hypothesis with Excel Statistics using Excel (183-210) 13 Regression analysis with Excel Statistics using Excel (211-228) 14 The internet and Web Peter Norton's introduction to computers (198-218) 15 Online data saving and Privacy Peter Norton's introduction to computers (286-298) 16 Computer Security Peter Norton's introduction to computers (267-285)

Assessment criteria:

Mid Exam:          30

Final exam:         50

Sessional (Assignment, Presentation, Participation, Attendance, Quizzes):             20

Time Table:

BS 3rd Reg:       Tuesday (10:00-11:00)      Wednesday(09:00-10:00)     Friday(08:00-09:00)

BS 3rd SS:       Wednesday (16:00-17:00)      Thursday(14:00-15:00)     Friday(15:00-16:00)