Course Title: Computer Science
and Management Information Systems
Course Code: ___________
Instructor: R' Eric Levy (email@example.com)
Objectives, Outline, Incidentals
This introductory course in computer science and management information systems emphasizes both technical and practical computer applications, and the integral role of computer-based information systems in management and accounting environments.
Upon successful completion, students will have developed a fundamental understanding of computers and their various capacities, computer applications, and information technology as an integral tool in corporate environments.
The focus of this course is core concepts and practical application of computer science and information systems, including computer systems, networks and telecommunications, information system design and implementation, security and control, and the system development process
Introduction to Computer Systems, Hardware, Programming, and Networks
1. Charles Babbage, entry in Wikipedia, sub-sections: Design of computers, Difference engine, and Analytical engine.
2. On the ENIAC, read:
a. ENIAC, entry in Wikipedia, sub-sections: Introduction (first paragraph only) Description (first paragraph only), and Programmability.
b. http://www.seas.upenn.edu/~museum/. Follow the links to
i. The Interview with Presper Eckert from Computer World, and
ii. The Dawn of the Age of Information
3. Surely You're Joking, Mr. Feynman! (Adventures of a Curious Character), Richard P. Feynman, pp. 125-29. To access these pages, a) go to Amazon.com, b) search for the book, c) do a search inside, d) search for computers and select the entries on 125 and 127, and e) use the arrows to flip though the pages.
Intranet, Internet, and World Wide Web Infrastructure
Access to information, Drive Sharing
TCP/IP, IP addresses (Static and Dynamic)
Domain Name Servers
World Wide Web
Web Servers vs. Drive Sharing
Static and Active Server Pages
Worms, Trojan Horses, Malicious Code
"Circuit Switching," in Wikipedia
"How Web Servers Work," found at http://computer.howstuffworks.com/web-server.htm/printable, or
"How Routers Work," found at http://computer.howstuffworks.com/router.htm/printable, from the beginning of the article through "Transmitting Packets."
Popular Software Applications
1. Collaborative software:
Google Docs and Spreadsheets
Voip and Video conferencing
"Collaborative software" in Wikipedia
More Popular Software Applications
1. An introduction to Excel (using http://www.mechon-mamre.org/i/t/index.htm)
Basic data entry
Cell formatting, multiple cell formatting
Inserting and deleting
Files: Saving, deleting, worksheets
2. Microsoft Word, Microsoft PowerPoint
Excel in Depth
Height and width of cells; text formatting
Advanced formatting: grids, shades, colors, painting multiple cells
Excel in Depth:
Cell and Cell Range Names
Word in Depth
The danger of editing an attachment
Header and Footers
Bullets and Numbering
Tables (and columns)
Inserting Excel Objects
SpiScope and PipeDream
Pre Examination Practice using Word and Excel
Putting it all together: Using Word, Powerpoint, and Excel to ceate an executive summary based on this design.
Building a presentation
Giving a presentation
Laying out some business plan
More giving a presentation
The Microsoft FrontPage
Crate pages in front page, and using notepad to create and view files.
HTML and Microsoft FrontPage
Dissecting a URL to understand the component parts, including the transfer protocol, the server markers, the service name, the server name, the directory, and the page being requested. We also reviewed the idea of hyper-linking from page to page, and server to server in the web.
We then created pages in FrontPage; including a close look at the html tags and specifically the <a href=""></a> tag.
Designing in Microsoft FrontPage
We went through the insert menu in, which included text breaks, page dividers, inline frames, symbols, comments, symbols, pictures, forms and form elements. We also saw the page formatting menu among other formatting menus.
Tables in Microsoft FrontPage
We worked with tables and cells, and setting various properties in tables and cells. We also worked on inserting images into tables, and using the photo-gallery feature.
Creating a Web
Students work on porting their PowerPoint presentation to a web design.
Database design and theory using MS Access. Storing information, from fields to records to tables to databases.
How to create relations using Access. Connecting tables in one-to-many, and many-to-one relationships. How to use the SELECT statement to view desired information from one or more tables in a database.
Intranets vs. the Internet
Exam, Spreadsheet Attachment, Invitation Template Attachment
Instructional Method: This course is taught using conventional lecture delivery (80%) together with group discussion (20%).
Method of Evaluation: 2 Examinations; Midterm and Final
Criteria Used in Evaluation Students are assessed by examinations, designed to test the students ability to recall facts, apply concepts, and analyze and synthesize the information (comprised of one mid-term and one final examination worth 40% and 60% respectively).
Minimum Standards for A minimum score of 70% (grade of B-) constitutes
Successful Completion of successful completion of this course.
What happens if the student Course must be repeated.
Fails to meet the minimum
Name of Author of Course
Date of Initial Course September 04, 2007.