INFO 101: Introduction to Information Systems - I

Year of Course:  First Year; Number of Credits: Three; Prerequisites:  Nil.

Ram Palanisamy

Office Location:  349 Gerald Schwartz School of Business

   Phone: (902)-867-2184 ; Email: rpalanis@stfx.ca

Office Hours (By Appointment): Tuesday - 9.45 -11A.M.; 12.45 - 2 P.M.; 3.45 - 5 P.M.

Thursday: 12.45 - 2 P.M.; 3.45 - 5 P.M.

Friday: 1.45 - 3 P.M.


   Course Description 

This course covers the organizational use of information technology. Topics include IS hardware, software, data; telecommunication networks; the Internet; and information technology infrastructure. Technical segment includes word processing; spreadsheets; presentation software; database management systems software; Internet search tools; and web page publishing. Applications of these tools and knowledge will be oriented towards business problems. Three credits.

Course Outline & Schedule

 

Week

Course Material

Comments

Sept. 7

 

 

Course Overview (Chapter 1) -  Intro. to IS & IT- IT’s Role in Business, IT Basics – StFX Network drives.

Sept. 12

 

 

Enabling the Organization (Chapter 9)- Decision Making – Transaction Processing Systems, DSS, ESS, AI, and Data Mining.

Sept. 19

 

 

 E-Business – Plug in B11- Accessing Internet Info- Intranet, Extranet, Portal, Kiosk; Providing Internet Info – ISP, OSP, ASP; Measuring E-Business Success – Metrics; Trends – Egov, Mobile Communication.

Sept. 26

 

 

 

 Designing Web pages – Plug in T9- WWW, Process of web design, HTML Basics, Web Graphics; creating web pages using HTML – Plug in T10- HTML, Creating, viewing HTML docs, Creating hyperlinks, and Displaying graphics.

Oct. 3

Online Store Website – Design – Assignment 1- Overview.

 

 
 

Oct. 10

Friday, Oct. 14 – Assignment 1 Due.

Hardware/ Software Basics – Plug in B3- Hardware Basics, CPU, Primary/ Secondary Storage, Input/ Output Devices, Communication Devices. Computer categories- Take apart a PC. Software Basics- Systems software, Application Software.

 

 
 

Oct. 17

Tuesday, Oct 18- Mid Term1

 

Networks and Telecommunications – Plug in B5. Network Basics- Architecture, Typology, Protocols, and Media.

Oct. 24

 Storing Organizational Information – Databases – Chapter 7- Storing organizational info, Relational databases, DBMS.

 

 

Oct. 31

Database Design – Assignment 2. – Explain.

Databases – Designing Database Applications- Plug in T5- Entities and Data Relationships, Documenting logical data relationships, relational data model.

 
 

Nov. 7

 

Basic Skills and Tools using Access 2007 – Plug in T6- Access Intro, Creating and modifying tables, Defining Relationships.

 

Friday, Nov. 11. - Remembrance day – No Class

Nov. 14

Tuesday, Nov 15- Mid Term2

 

Problem Solving using Access 2007 – Plug in T7- Simple queries creation, Advanced Queries.

Nov. 21

Tuesday, Nov. 22 Assignment 2 Due.

Decision Making with Access 2007 – Plug in T8- Forms – Reports, using the Report Wizard.

 

 

Nov. 28

Linking the Online store Website with Database. – Assignment 3. Explain.

 

 

Friday, Dec. 2 Assignment 3 Due.

Review and Slack

 

 

Class Schedule and Notes

 

   

Week

Topic

Class Notes

Class preparation

Sep 7

Introduction  

 

Friday

 

Sep 12

Business Driven Technology

 

Tuesday

Business Driven Technology - Chapter 1

Friday

Information System Basics

Sep 19

Enabling the Organization- Decision Making  

Tuesday

 Enabling the Organization-Decision Making Chapter 9

 Scenario Manager  Goal Seek

Friday

 

Sep 26

 E-Business – Plug in B11- Accessing/ Providing Internet Info; Measuring E-Business Success – Metrics; Trends . 

 

Tuesday

E-Business – Plug in B11

Friday

 

Oct 3

Designing Web pages – Plug in T9

Creating Web pages Using HTML  - Plug in T10

 

 Tuesday

Designing Web pages – Plug in T9

Plug in T9 Material

Web Design Assignment

 Friday

Creating Web pages Using HTML  - Plug in T10

Plug in T10 Material

 

Oct 10

Hardware/ Software Basics – Plug in B3 

 

 Tuesday

 Mid-Term Topics & Type of Questions

Hardware/ Software Basics – Plug in B3 

Friday

Friday, Oct. 14 – Assignment 1 Due by 5 P.M..

Oct 17

 Networks and Telecommunications – Plug in B5

 

 Tuesday

 Tuesday, Oct 18- Mid Term1

Friday

Networks and Telecommunications – Plug in B5

 

Oct 24

Storing Organizational Information – Databases – Chapter 7.  

Tuesday

Guest Lecture

Answers for midterm

Friday 

Databases – Chapter 7

 

Oct 31

Databases – Designing Database Applications- Plug in T5- Entities and Data Relationships, Documenting logical data relationships, relational data model.  

Tuesday 

Databases – Designing Database Applications- Plug in T5

Database Design – Assignment 2.

Friday

Coca-Cola Database - Queries- Reports

ERD Model for Coca-Cola

Nov 7

Basic Skills and Tools using Access 2007 – Plug in T6- Access Intro, Creating and modifying tables, Defining Relationships. 

 

Problem Solving using Access 2007 – Plug in T7- Simple queries creation, Advanced Queries.

 

Tuesday

 Mid-Term2 Topics

Answers

Basic Skills and Tools using Access 2007 – Plug in T6

Problem Solving using Access 2007 – Plug in T7

 

 

Friday

Nov. 11, Remembrance Day (No classes)

Nov 14

   

Tuesday

Tuesday, Nov 15- Mid Term2

 

Friday

 

Nov 21

 

Decision Making with Access 2007 – Plug in T8- Forms – Reports, using the Report Wizard.

 

Tuesday

 Tuesday, Nov. 22 Assignment 2 Due by 5 P.M..

Decision Making with Access 2007 – Plug in T8

SlopesideBikes_Data.mdb

Queries and Reports

Friday

 

Nov 28    

Tuesday

 Xmas Exam Details

Friday

Review

Friday, Dec. 2 Assignment 3 Due.