SFP_14_Introduction+to+Computer+Applications

= = = =

=MIS103: Introduction to Computer Applications=

Program:
SFP

Semester:
Fall 2014

Instructor:
Shama Siddiqui

** Credit Hours: **
3

Course Description:
The Course provides a fundamental understanding of basic theoretical concepts of computer, with major focus on practical applications. The core of this course lies in the basic Microsoft Office Applications (Microsoft Word, Excel, and PowerPoint).

Course Objectives:
The aim is to familiarize students with the Microsoft Office environment and to enable them to perform basic, intermediate and advanced word processing, spreadsheet, and presentation operations.

Web Resources:
Microsoft Office 2013 online manuals, tutorials can be used for assistance.

Grading Policy:
Mid-terms: 30 Marks Final: 40 Marks Quizzes: 10 Marks Class Participation: 10 Marks Project/Presentation: 10 Marks

||
 * ==**Topics Covered in the Course **== ||
 * S.No || Date of the lecture || Topic of Lecture || Reference Material ||
 * 1 || 23-12-14 || Basics of Computers || [[file:Computer-Basics--basic_comp_oper.ppt]][[file:Basic_Computer_for_Small_Business.ppt]] ||
 * ||  ||   || [[file:Computer-Basics--computer_basics2.pdf]] ||
 * 2 || 30-12-14 || Starting MS-Word || [[file:Word Exercise 1.docx]] [[file:Basics of MS Word.pdf]] ||
 * 3 || 1-1-15 || Newspaper Articles || [[file:Word Exercise 2.docx]] ||
 * 4 || 5-1-15 || Tables || [[file:Word Exercise 3.docx]] ||
 * 5 || 8-1-15 || Organizational Charts || [[file:Word Exercise 4.docx]] ||
 * 6 || 8-1-15 || Assignment 1 || [[file:Assignment 1.docx]] [[file:Newsletter.pdf]] ||
 * 7 ||  || Table of Contents and Index || [[file:Word Exercise 4.docx]] ||
 * 8 || 20-1-15 || Headers and Footers || [[file:Word Exercise 5.docx]] ||
 * 9 || 29-1-15 || The Practice File || [[file:Practice 4.docx]] ||
 * 10 || 3-2-15 || Invoice Exercise || [[file:Invoice Practice.docx]] ||
 * 12 || 10-2-15 || Headers and Footers || [[file:Word Exercise+6.docx]] ||
 * 13 || 11-2-15 || Salary Sheet || [[file:Excel+Exercise+1.docx]] ||
 * 14 || 11-2-15 || Practice 1 || [[file:Excel Practice 1.pdf]] ||
 * 15 || 11-12-15 || Practice 2 || [[file:Excel Practice 2.pdf]] ||
 * 16 || 19-2-15 || Grade Sheet || [[file:Excel Exercise+2.docx]] ||
 * 17 || 22-2-15 || Practice 3 || [[file:Excel Practice 3.pdf]] ||
 * 18 || 26-2-15 || Data Extraction || [[file:Excel+exercise+3a.docx]] ||
 * ||  ||   || [[file:Excel+Exercise+3b.docx]] ||
 * || 3-3-15 || Data Extraction || [[file:Excel+Exercise+4.docx]] ||
 * || 3-3-15 ||  || [[file:Excel+Exercise++5.docx]] ||
 * ||  ||   || [[file:Formula+Practice+Sheet1.xlsx]] ||
 * 19 || 3-3-15 || Assignment 2 || [[file:Assignment 2.docx]] ||
 * ||  ||   || [[file:Assignment 2.XLSX]] ||
 * 20 ||  || Practice 4 || [[file:Practice 4.xlsx]] ||
 * 21 ||  || Practice 5 || [[file:Practice 5.xlsx]] ||
 * 22 || 17-3-15 || Moving between Sheets || [[file:Excel+Exercise+6.docx]] ||
 * ||  ||   || [[file:Bonus Worksheet 2013.xlsx]] ||
 * ||  ||   || [[file:Income Statement 2013.xlsx]] ||
 * ||  ||   || [[file:Stillwater Restaurants 2013.xlsx]] ||
 * 23 || 17-3-15 || Charts in Excel || [[file:Excel Exercise 7.docx]] ||
 * 24 || 24-3-15 || Data Extraction (Filter) || [[file:EXCEL EXERCISE 8.docx]] ||
 * 25 || 24-3-15 || Quiz 3 File || [[file:Game_data.xlsx]] ||
 * 26 || 26-3-15 || Sorting Data || [[file:Excel+Exercise+9.docx]] ||
 * 27 || 2-4-15 || Creating and Formatting Presentation || [[file:PowerPoint+Exercise.docx]] ||
 * 28 || 2-4-15 || Assignment 3 || [[file:Assignment+3.docx]] ||
 * 29 || 7-4-15 || Practice 6 || [[file:smilechart.xls]] ||
 * 30 || 7-4-15 || Practice 7 || [[file:CHART1.XLSX]] ||
 * 31 || 7-4-15 || Practice 8 || [[file:CHART2.XLSX]] ||
 * 32 || 7-4-15 || Practice 9 || [[file:ADDSAL1.xlsx]] ||
 * 33 || 7-4-15 || Practice 10 || [[file:Practice with charts.docx]] ||
 * 34 || 9-4-15 || Exam 2 || [[file:Salesperson Data.xlsx]] ||
 * 35 || 9-4-15 ||  || [[file:Stationery Order.xls]] ||
 * 36 || 23-4-15 || Quiz 4 || [[file:Computer+Hardware.pptx]] ||
 * 37 || 14-5-2015 || Final exam || [[file:question2 sample.pdf]] ||
 * ||  ||   || [[file:Formula+Practice+Sheet.xlsx]] ||
 * ||  ||   || [[file:Introductiontocomputers.ppt]]