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)

 

 

Course Material

Other Courses by Summera Kinat