COMPUTING AND BUSINESS APPLICATIONS WITH MICROCOMPUTERS

INSTRUCTORS:  INFO 130:11 J. Sullivan                Block B         Room NH 123
                                INFO 130:12 J. Sullivan                Block K         Room NH 123
                                INFO 130:13 R. J. MacKinnon     Block L         Room NH 123
                                INFO 130:14 J. Sullivan                Block TT       Room NH 123
                                INFO 130:15 C. MacDonald        Block D         Room NH 123
                                INFO 130:16 G. Hunter                Block H         Room NH 123
                                INFO 130:17 R. Palanisamy          Block UU       Room NH 123
                                INFO 130:19 R. Palanisamy          Block J          Room NH 123
                                INFO 130:20 Van Bommel/Yang   Block A         Room NH 019
                                INFO 130:21 E. Schuegraf             Block J         Room NH 122
                                INFO 130:22 L. Yang                    Block K         Room NH 016
                                INFO 130:23 L. Man                     Block WW     Room NH 118

TEXTS: Exploring Microsoft Office 97 Professional, by Grauer & Barber; Prentice Hall.
               Essentials of Microsoft Visual Basic, by Carlotta Eaton, Prentice Hall

DISKS: Four - 3.5 in. 1.44 MB High Density

FIRST TERM

Micro Hardware: CPU, RAM, ROM, floppy disks, hard disks, IBM compatible, PC, XT, AT, 386, 486, pentiums, micro selection (IBM vs MS-DOS; MS-DOS vs Macintosh), PC buying guide.

Micro Software: Application programs (word processors, spreadsheets, utilities, data base management systems), languages, operating systems, software selection, industry standard software.

Networks at St. F. X.: Access, file servers, printing and storage.

Windows 95 & NT: An introduction to Windows 95 & NT, and Microsoft Office 97.

Internet & e-mail: An Intro to Internet, using Netscape.

File Management Explorer, cut, copy, paste, move, drag & drop, delete files, mirror, compress, format.

Microsoft WORD: Save, retrieve, and print files. Editing and formatting documents. Enhancing a document.

Microsoft EXCEL: The EXCEL Environment
                                 The EXCEL Worksheet
                                 Operators and Functions
                                 Changing the Appearance of the Worksheet
                                 Print Command
                                 Copy and Move Commands
                                 Cell Reference
                                 Screen Graphics
                                 Data Computation Operations
                                 Data Selection Operations
                                 Advanced Worksheet and Range Operations.
                                 Workbooks and linking

 
SECOND TERM

Macros: Automating Repetitive Tasks: Introduction, the personal macro workbook, data management macros, creating additional macros, loops and decision making.

Microsoft ACCESS:
Introduction to file management and relational DBMS
Selection of DBMS, ratings of DBMS, industry standard DBMS
Previewing ACCESS
Creating a Database
Entering and Editing Data
Managing Your Files
Restructuring a Table
Asking for Specific Data
Creating Output: Reports.

Visual Basic: Chapters 1-4, programming & applications, first project, writing code, forms, controls & menus.

HTML: Basic HTML and creating home pages. Netscape Composer.

Introduction to Information Systems: System life cycle, systems analysis.

POWERPOINT: Creating a presentation: content, formatting and animation.

GRADING SCHEME:  Assignments 20%
                                        Quizzes 30%
                                        Exams 50%

COMMON EXAMS: All sections of INFO130 will have a common mid-term (Christmas) Exam on
Wednesday December 8th at 7 PM, and a common Final Exam at 7 PM on April. 22^nd

N.B. IF YOU HAVE A CONFLICT WITH THESE EXAM DATES YOU CANNOT TAKE THIS COURSE.

WARNING!!

If you take a course that overlaps with this course and which might have an exam at
the same time as INFO 130, you CANNOT take this course! There will be ONE common
Final Exam. There will NOT BE ADDITIONAL FINAL EXAMS made up for persons who
ignore this warning!! DO NOT make any travel arrangements before December 8 th!