Computer Science Department

Loyola College

 

CS 111.01 – Introduction to Computers with Software Applications

 

                                                     

    

                        Instructor:       Roberta E. Sabin                                     

                             Office:             Donnelly Science 125E                      

                             Telephone:      (410) 617-2562

                             FAX :               (410) 617-2157

                             E-mail: res@loyola.edu

 

 

            BlackBoard Course Website:

                        http://www.loyola.edu/blackboard/index.html

      

                      Visit the CS Department WebSite: http://www.cs.loyola.edu

 

                                    Class Meets:  MWF 9-9:50 (in SH102)

 

Office Hours:      Monday, Wednesday, Friday:   10-11

                                                                  Other times by appointment or stop by.

                                    (I am usually here on MWF 8-8:50 and 12-12:50.  I am frequently in my office until 3 or 4 on MWF.)

 

 

One must learn by doing the thing, for though you think you know it, you have no certainty until you try,                   --Sophocles, 5th century B.C.

 

Man is still the most extraordinary computer of all.                                                                                                                           — John F. Kennedy

 

I think there is a world market for maybe five computers.                                                                          — Thomas Watson, chairman of IBM, 1945

 

Home computers are being called upon to perform many new functions, including the consumption of homework formerly eaten by the dog."
                                                                                                                                                                                                                      — Doug Larson

 

Computers in the future may weigh no more than 1.5 tons."                                                                                             — Popular Mechanics, 1949                                                                                                                                                                                                                        

Analytical Engine has no pretensions whatever to originate anything.  It can do whatever we know how to order it to perform.

                                                                                                                                                                                                 --Ada Augusta Byron, 1843

 

CS 111              Introduction to Computers with Software Applications                        3 credits

                                                                                                                                    Prerequisite: none

 

SYLLABUS

 

Catalog Description: This course is an introduction to computer science and software applications.  Students will be introduced to the design of computers, computer systems, and structured programming concepts.  The course includes experience in popular computer applications such as e-mail (GroupWise), word processing (Word), spreadsheets (Excel), database management (Access), presentation graphics (PowerPoint), Internet applications, and structured programming concepts.  This course incorporates extensive hans-on experience on a personal computer using the Windows operating system and Microsoft Office for computer applications.                                                                                                      

 

Texts: 

        Carey/Zimmerman/Shaffer/Adamski/Finnegan, New Perspectives on Microsoft Office 2003, Course Technology, 2006.

        Dale/Lewis, Computer Science Illuminated, Jones and Bartlett, 2004.

 

Software: Microsoft Office XP Suite, MS FrontPage, Internet Explorer, and Windows 2000 will be used.

 

Supplemental Websites: 

            Tutorials for CS Illuminated:  http://csilluminated.jbpub.com/index.cfm

New Perspectives Student Materials (data files, internet assignments, lab assignments, PPT slides):     

  http://www.course.com/downloads/newperspectives/Office2003/FirstCourse2e.cfm

 

 

Course Objectives:

  Upon successful completion of this course, the student should be able to:

1.     understand to some degree the major principles underlying computer science

2.     explain how information (text, numbers, and multimedia) is stored for computer use

3.     explain in broad terms the functioning of the Internet and the World Wide Web

4.     understand  and explain the major hardware and software components of a computer system

5.     understand and explain  the purpose and structure of software and the steps in the software lifecycle

6.     develop a simple Java program

7.     competently use a software package to create a webpage

8.     use a standard application to create a spreadsheet that incorporates the use of formulae and graphics

9.     understand the basic principles of database design and use a standard application to create a simple database

10. use a standard application to create a presentation

 

What you can expect of me: You can expect that I will come to class prepared and ready to help you learn.  You can expect me to be enthusiastic (easy--since I LOVE computer science and teaching!), be knowledgeable, and keep the class moving. You can expect me to be available during my office hours and at other times that you arrange to see me.  Expect me to return graded work promptly.  You can expect me to treat you respectfully.

 

What I expect of you:  I expect you to come to every class prepared to contribute to class—computing is an active sport.  You CANNOT learn it in the passive mode. This means that you should have completed the assignment, done the reading, and determined what you need help in understanding.  You contribute to class by intelligently questioning the instructor and offering further explanation to me and your classmates. I expect you to take responsibility for learning computer science—you won’t be sorry.  Further, I expect  you to treat every other member of the class (including me) with respect.

 

Course Outline of Class Activities:

 

            Notice that most days will involve activities aimed at 1) learning computer science concepts (usually lecture-based) and 2) learning to more effectively use application software (usually hands-on based).  Lecture-based computer science concepts topics are shown in italics below. The schedule below may be changed as need arises.

 

 

Class No.

Date

General & CS Topic

Reference[1]

App Topic

References[2]

1

1/17  W

Intro to the course

Internet and WWW

Syllabus

CI 16.1

survey of skills

 

 

2

1/19 F

HTML

CI 16.2

webpage construction with FrontPage

on-line

3

1/23 M

Binary numerals

CI 2.1-2.2

FrontPage

on-line

4

1/25 W

Number base conversion

CI 2.2

Using Search engines

on-line

5

1/27 F

Quiz

 

Organizing Files via Windows Explorer

FM 4-18

6

1/30 M

Data Representation:

Basics

CI 3.1

Spreadsheets: Excel

EX

7

2/1 W

Representing Text

CI 3.3

Excel

 

8

2/3 F

Quiz

 

Excel

 

9

2/6 M

Representing audio and graphics

CI 3.4,3.5

Excel

 

10

2/8 W

Representing video

CI 3.5,3.6

Excel

 

11

2/10 F

Quiz

 

Excel

 

12

2/13 M

Hardware: Basic components

CI 4.1

Excel

 

13

2/15 W

Circuits

CI 4.2

Excel

 

14

2/17 F

Quiz

 

Excel

 

15

2/20 M

Hardware: Higher-level

CI 5.1, 5.2

Presentation Software: Powerpoint

PPT

16

2/22 W

Hardware Devices

CI 5.2

Powerpoint

 

17

2/24 F

Quiz

Deciphering Ads