CPSC 100 - Introduction to Computers and Computer Applications

This introductory course provides a broad social and technical understanding of computers. It deals with questions such as: What are computers? How do they work? What can they do? How will they affect us now and in the future? CPSC 100 has both lecture and lab components. Lecture topics include history, hardware, software, networks, security, and programming. A major portion of the course is devoted to lab work on common computer applications, including word-processing, spreadsheets, database management, and presentations. Programming is introduced but not emphasized.


Credits:  3


Hours: 60 (Lecture Hours: 1.5;  Laboratory Hours: 2.5)


Total Weeks: 15





Non-Course Prerequisites:




Course Content:
Computers as a Social and Technical Phenomena
- The five parts of an information system
- System software and application software
- Operating system, Utilities, Device Drivers
- Basic applications and specialized applications
- Four types of computers
- Data, document, worksheet, database, and presentation files
- Computer connectivity, the wireless revolution, and the internet
Introduction to Graphic User Interface
- Graphic User Interface (GUI)
- Starting Windows and logging on
- Terminology related to GUI.
- Starting an application, working with files and folders.
- Creating a simple document and saving it in a proper directory.
- File management including copying, renaming, deleting.
- File extensions and their use
Basic Application Software
- Common features of most application software.
- Word processors and word processor features.
- Spreadsheets and spreadsheet features.
- Database management (DBM) system and DBM’s features.
- Presentation software and common features.
- Integrated packages and software suites
Introduction to Word Processing
- Starting the Word-2007 and entering text, spell check and word wrapping.
- Save document with a proper name in a proper folder.
- Formatting paragraphs and characters in a document
- Font types and sizes, including italic, underline, and bold.
- Bulleted lists and numbered lists.
- Change the style set, theme colors, and theme fonts.
- Insert a picture from a file or gallery.
- Resize the picture and move it.
- Format the picture including picture style, picture border and border color
- Enhancing the page including borders, spaces above and below paragraphs.
- Working with document properties, fixing errors, and printing.
Specialized Application Software
- Desktop publishing, image editors, image galleries and graphic suites
- Audio and video editing software.
- Web authoring, Web site design, and Web authoring programs.
- Virtual reality and VRML
- Robotics, industrial robots and mobile robots
Creating Formal Documents such as Research Papers and Reports
- Explain various documentation styles
- Adjusting line and paragraph spacing
- Working with headers and footers
- First-line indent and hanging indent
- Inserting a citation and creating its source
- Editing headers, footers, and citations.
- Working with footnotes and endnotes.
- Hard page breaks and soft page breaks.
- Creating an alphabetical reference of citations.
- Proofing and revising the research paper.
The System Unit
- System unit and its components
- Use of binary code to represent data in electronic form
- Microprocessors, and specialty co-processors
- Different types of memory, RAM, ROM, and Flash memory
- Expansion slots and boards and different types of expansion buses
- Standard ports and specialized ports
- Power supply for desktop and notebook computers
System Software
- The difference between system software and application software
- Operating system, utilities, device drivers, and language translators
- Basic functions and features of operating systems
- Windows, Mac OS, UNIX, and Linux operating systems
- Most essential utilities and Windows utility programs
- Device drivers and printer drivers
Introduction to Spreadsheets I
- Explain worksheet, workbook, formula bar, cell, and cell addresses.
- Start Excel and enter worksheet titles, column and row titles
- Differentiate numbers and texts
- Calculating a sum of numbers in columns or rows
- Using fill handle to copy a cell to other cells
- Formatting worksheet, including fonts, colors, and centering across
- Formatting numbers, automatic adjusting of column width and row height
- Adding a chart (graph) to a worksheet
- Changing document properties, saving, printing a worksheet, and quitting Excel
- Using Excel help
Input and Output
- Defining input and output
- Direct keyboard entry, pointing devices, and scanning devices
- Image capturing devices, digital camera, and digital video camera
- Audio input and output devices
- Monitors, printers, microphone and speakers
- Fax machines, multifunctional devices, and internet telephones
Introduction to Spreadsheets II
- Worksheet with formulas, functions, and web queries
- Entering formulas using keyboard, or using point mode
- Arithmetic operations, their precedence, and equations
- Using AVG, MAX, MIN, DATE, and other useful functions available in Excel
- Relative copying of formulas using fill handle
- Formatting worksheet, including theme, colors, and borders
- Manual adjusting of column width, and row height
- Accounting, percent, comma, and currency formatting of numbers
- Previewing and printing a worksheet, a section of worksheet
- Printing formula version of worksheet
- Importing data from a web source
- Changing a worksheet name
Secondary Storage
- Distinguishing between primary and secondary storage
- Internal and external hard disks
- Disk cashing, data compression and de-compression
- Floppy disks, flash memory, and USB drive
- Optical disks CD, CDR, CDRW, DVD, DVDR, DVDRW
- Internet drivers, mass storage devices, network storage
- Magnetic tape and backup
Introduction to database management I; Building a database
- Designing a database, naming tables and fields
- Identifying tables, determining primary keys
- Determining data types for the fields
- Creating a table structure and making changes required
- Adding records to the table and editing data if needed
- Saving and closing a table and database file
- Opening an existing file and adding new tables and new data
- Creating a report and using split form to view data
- Changing document properties and printing a table
Secondary Storage
- Distinguish between primary and secondary storage
- Internal and external hard disks
- Disk cashing, data compression and de-compression
- Floppy disks, flash memory, and USB drive
- Optical disks CD, CDR, CDRW, DVD, DVDR, DVDRW
- Internet drivers, mass storage devices, network storage
- Magnetic tape and backup.
Introduction to database management II; Querying a database
- How to create queries using query wizard
- Using a simple criterion, multiple criteria, and “and”, “or” criteria
- Creating a parameter, and number queries
- Using comparison operators and wildcard in queries
- Sorting data and omitting duplicates
- Simple sort and complex sort using multiple keys
- Saving reports, queries, and sorted database
- Joining tables to create reports or queries on multiple tables
- Establishing relationships between tables
- Using calculated fields in a query and calculating statistics
Communication and Networks
- Explain connectivity, wireless revolution, and communication systems
- Physical and wireless communication channels
- Dial-up, DSL, cable, satellite, and cellular services
- Factors affecting data transmission, including bandwidth and protocols
- Networks and key network terminologies
- LAN, MAN, and WAN networks
- Network architecture such as bus, ring, and star networks
- Intranet, extranet, internet, security and firewalls
Introduction to Presentation Software I
- Start MS-Power Point and select a theme
- Create a title slide, and text slides with single and multi-level bulleted lists
- Copy elements from one slide to another
- Save and close the program
- View a presentation in slide show view
- Open, display and print a presentation
- Changing document properties
- Use Power Point help
The Internet, the Web, and Electronic Commerce
- A history of the internet and the web
- Describe access, service providers, and browsers
- Internet communications, including email, instant messaging, and blogs
- Search engines, meta-search engines and specialized search engines
- Electronic commerce, including B2C, C2C, B2B, and security issues
- Web utilities such as FTP, plug-ins, filters, and security suites
Introduction to presentation software II
- Create slides from a blank presentation
- Change slide layout and add a background style
- Insert, move, and size clip art
- Insert a photo or music from a file
- Delete placeholders and apply quick styles to placeholders
- Select slide transitions
- Preview and print an outline and handout
- Automatic timing and presenting the slide show
Privacy and Security
- Privacy issues related to the presence of large databases, and private networks
- Control cookies, Web bugs, and spyware
- Security threats posed by computer criminals, hackers, and other hazards
- Ways to protect security as much as possible
- Physical and mental risks associated with computer use
- Ways to minimize the risks and protect yourself against these risks
Introduction to Programming I
- What is a computer program?
- High level and low level languages
- Language translators and compilers
- Examples of programming languages
- Text based programs and visual/graphic programs
Introduction to Programming I
- Explain IDE and typical programming software
- Use a C++ compiler and editor to write a simple program
- Explain source code and how it is converted into object code
- Debug the simple program “Hello World” to identify possible errors
- Fix the errors in order to have a successful compilation
- Compile to generate the object code
- Run the program and see the outcome
Introduction to Programming II
- Program design, including top-down and bottom-up designs
- Flow charts and algorithms
- Object oriented programming
- Platform insensitive programming languages
Introduction to Programming II
- Source files, object files, and executable files
- Write a simple program to add two numbers and output the result to the screen
- Debug this and correct errors to have a successful compilation
- Run the program and see the outcome


Learning Outcomes:
Students who successfully complete CPSC 100 will be able to:
- Explain the five parts of an information system
- Distinguish between system software and application software
- Define Operating system, Utilities, Device Drivers
- Distinguish basic applications from specialized applications
- Identify four types of computers
- Describe data, document, worksheet, database, and presentation files
- Use word processing, spreadsheet, database management, presentation programs
- Set up security priorities in Windows
- Identify communication channels, network topology, and network security
- Use a word processor to create a flyer, resume, and research paper
- Use a spreadsheet with numbers, texts, charts, formulas and equations
- Use databases to create data tables, queries, reports, and relational tables
- Make a presentation file with pictures, audios, and automatic slide show

- Write, compile, and run a simple C++ program


Grading System:  Letters


Passing Grade:  D (50%)


Percentage of Individual Work:  90


Percentage of Group Work:  10


Additional Course Comments:
- Attendance: Regular attendance is expected. Students who do not regularly attend class will likely jeopardize their ability to meet assignment criteria.
- Due-Dates: Assignments are due on scheduled due-dates, by scheduled times. Normally, half a letter grade per day will be deducted from late assignments; however, this deduction may be modified or waived where sufficient cause for lateness is presented.
- Plagiarism: Plagiarism is regarded as a form of academic dishonesty and occurs when writers do not adequately acknowledge their sources. The consequences for plagiarism can be serious, including failure on an assignment, failure in a course, and/or expulsion from the college. In this class, assignments that involve plagiarism will receive a zero. Depending on individual circumstances, additional action may be taken. To avoid plagiarism, pay careful attention to discussions and readings about strategies for attribution.
- Multiple Submission: There are diverse views on the appropriateness of handing in essentially the same work for more than one course, a practice sometimes referred to as “multiple submission” or “double submission.” Accordingly, college policy states that students are expected to obtain permission from instructors before submitting basically the same work for more than one course. This policy extends to courses in different semesters and courses at different institutions. Multiple submission is not permitted in CPSC 100.
- Please be aware that each term the Registrar’s Office sets a “last day for withdrawal without academic penalty.” If you rarely attend class and submit very little or no work, it would be advisable to withdraw from the course on or before the last date for withdrawal. Students who submit little or no work throughout the term and do not withdraw by the withdrawal date will receive an “F” unless evidence is provided of exceptional, unforeseen reasons for non-completion.

- Assignments: For each lab included in the weekly course outline, there will be one assignment which will include two or more appropriate projects to be completed by students and presented to instructor for marking at the beginning of the next lab. This would make a total of at least 8 assignments for the whole term. It is expected that each assignment will take two or three hours and will be completed outside the class time.


Textbooks are subject to change. Please contact the bookstore at your local campus for current book lists.