Using personal computers as effective problem solving tools for the present and the future. Effective use of spreadsheets to process, manipulate, and visualize numeric and textual information. Introduction to computer and network organization, digital information, HTML, and CSS. Algorithms underlying the functional components of web search engines and their influence on data access.
All announcements, questions, and answers are on Learn. Check the course's Learn website regularly to be kept up to date.
|Monday||11:00 am - 12:00 pm||1||Alicia|
|Tuesday||9:30 am - 10:30 am||1||Angie|
|Wednesday||3:00 pm - 4:00 pm||2||Michael|
|Friday||1:30 pm - 3:00 pm||3||Rina|
* Times subject to change
Note: Office hour appointments can be made with the ISAs or course instructor, via email.
Office hours are held in the Computer Science Tutorial Centre, in MC 4065. The specific
location within the centre, ISA's name, and office hour times can be found on a white board standing next to the
entrance to the centre.
Chat rooms may be accessed by clicking the Connect tab and navigating to the Chat link. Online chats are run through an instant messaging system on Learn that allow students to ask ISAs questions much like on-campus office hours would.
If you are not currently enrolled in the course, please direct all inquiries to the Instructional Support Coordinator, Barbara Daly (email@example.com)
All telephone extensions are for 519-888-4567
Please keep in mind that all dates expressed in this schedule are tentative and subject to change at any time.
|Week||Module||Activities and Assignments||Start Date (10:00 am)||Due Date (11:59 pm)||End Date (9:00 am)||Weight (%)|
|1||Module 0: Syllabus||Assignment 0||Wednesday, Sept 4, 2019||Monday, Sept 16, 2019||N/A||1 (bonus)|
|2||Module 1: Digital Information||Assignment 1||Monday, Sept 9, 2019||Monday, Sept 16, 2019||Friday, Sept 20, 2019||4.55|
|3||Module 2: Computer Organization||Assignment 2||Monday, Sept 16, 2019||Monday, Sept 23, 2019||Friday, Sept 27, 2019||4.55|
|4||Module 3: Network Organization||Assignment 3||Monday, Sept 23, 2019||Monday, Sept 30, 2019||Friday, Oct 4, 2019||4.55|
|5||Module 4: Introduction to Excel||Assignment 4||Monday, Sept 30, 2019||Monday, Oct 7, 2019||Friday, Oct 11, 2019||4.55|
|6||Module 5: Advanced Excel Functions||Assignment 5||Monday, Oct 7, 2019||Monday, Oct 21, 2019||Friday, Oct 25, 2019||4.55|
|7||Module 6: Displaying and Optimizing Data in Excel||Assignment 6||Monday, Oct 21, 2019||Monday, Oct 28, 2019||Friday, Nov 1, 2019||4.55|
|8||Module 7: HTML||Assignment 7||Monday, Oct 28, 2019||Monday, Nov 4, 2019||Friday, Nov 8, 2019||4.55|
|9||Module 8: Cascading Style Sheets (CSS)||Assignment 8||Monday, Nov 4, 2019||Monday, Nov 11, 2019||Friday, Nov 15, 2019||4.55|
|10||Module 9: Dynamic Web Pages||Assignment 9||Monday, Nov 11, 2019||Monday, Nov 18, 2019||Friday, Nov 22, 2019||4.55|
|11||Module 10: Search Engines||Assignment 10||Monday, Nov 18, 2019||Monday, Nov 25, 2019||Friday, Nov 29, 2019||4.55|
|12||Module 11: Security and Privacy||Assignment 11||Monday, Nov 25, 2019||Monday, Dec 2, 2019||<----------------------||4.55|
|Final Exam||You must pass the final exam with a minimum of 50% in order to pass the course. If you get less than 50%, the mark on your final exam will be your final grade.||50|
Please carefully review the information about final examinations for online courses, including dates, locations, how to make examination arrangements, writing with a proctor, and deadlines.
If you are taking any on-campus courses, you will automatically be scheduled to write your exam on campus. No action is required.
If you are taking only online courses, do one of the following:
Your online course exam schedule will be available in Quest approximately four weeks before your exam date(s). Instructions on how to find your schedule are posted on the Quest Help page.
University of Waterloo Senate-approved examination regulations and related matters can be found on the Registrar's website.
In order to complete Module 0, you must read the following pages, complete an online quiz on Learn and submit the Academic Integrity PDF to the Dropbox found on Learn.
Please go through the following sections:
Once these have been read, download the PDF found under Academic Integrity and submit it in a PDF format to the Dropbox labeled "Assignment 0 Dropbox".
Electronic submission of this document indicates that you understand UW policy, and will comply with it throughout the term.
The quiz for Module 0 can be found under Assessments > Quizzes > Assignment 0 Quiz
For future assignments, all instructions will be found under Course Material > Content > Assignments.
Assignment 0 must be completed and submitted (with a minimum of 75%) before any other assignments will be accepted. In order to receive the full 1% bonus for this assignment, you would have to complete and submit the assignment with a score of 100%. The bonus you get on the assignment is proportional to the score you achieve. For example, if you score 85% on the assignment, you would receive 0.85 from the 1.0 bonus. Remember, you have an unlimited number of attempts to complete this assignment.
If you have any questions, email your ISA's at firstname.lastname@example.org
|1.1: Integers and Real Numbers|
|1.3: Discrete vs. Continuous Quantities||Alternate Link||Transcript|
|1.4: Discretization||Alternate Link||Transcript|
|1.5: What Does "Digital" Mean?||Alternate Link||Transcript|
|1.6: Digitization (part two)||Alternate Link||Transcript|
|1.7: Why use Binary?||Alternate Link||Transcript|
|1.8: Bits and Bytes||Alternate Link||Transcript|
|1.9: How to Count (in different bases)||Alternate Link||Transcript|
|1.10: Converting to Decimal||Alternate Link||Transcript|
|1.11: Converting to Binary||Alternate Link||Transcript|
|1.12: Why Do People Use Hexadecimal?||Alternate Link||Transcript|
|1.13: ASCII||Alternate Link||Transcript|
|1.14: Unicode||Alternate Link||Transcript|
|1.15: Digital Colour||Alternate Link||Transcript|
|2.1: What is a Computer?|
|2.2: The Central Processing Unit (CPU)|
|2.3: Secondary Storage|
|2.4: Primary Memory|
|2.7: Operating Systems|
|2.8: Conclusions and Learning Goals|
|3.1: Network Organization||Alternate Link||Transcript|
|3.2: Physical Layer||Alternate Link||Transcript|
|3.3: TCP/IP (IP)||Alternate Link||Transcript|
|3.4: TCP/IP (TCP)||Alternate Link||Transcript|
|3.5: High Layers (HTTP and more)||Alternate Link||Transcript|
|4.1: Excel Layout||Alternate Link||Transcript|
|4.2: Values||Alternate Link||Transcript|
|4.3: Formulas and Expressions||Alternate Link||Transcript|
|4.4: Order of Operations||Alternate Link||Transcript|
|4.5: Functions||Alternate Link||Transcript|
|4.6: References and Ranges||Alternate Link||Transcript|
|4.7: PMT Example||Alternate Link||Transcript|
|4.8a: Copy and Paste||Alternate Link||Transcript|
|4.8b: Autofill||Alternate Link||Transcript|
|4.9: Absolute References||Alternate Link||Transcript|
|4.10: Named Ranges||Alternate Link||Transcript|
|5.1: Text & Labels||Alternate Link||Transcript|
|5.2: Multiple Worksheets||Alternate Link||Transcript|
|5.3: Boolean Logic||Alternate Link||Transcript|
|5.4: Boolean Logic Functions||Alternate Link||Transcript|
|5.5: Errors and Conditional Formatting||Alternate Link||Transcript|
|5.6: COUNTIF and AVERAGEIF||Alternate Link||Transcript|
|5.7: VLOOKUP||Alternate Link||Transcript|
|6.1: Charts||Alternate Link||Transcript|
|6.2: Filters||Alternate Link||Transcript|
|6.3: Pivot Tables and Pivot Charts||Alternate Link||Transcript|
|6.4: What If Analysis||Alternate Link||Transcript|
|7.1: First Example|
|7.2: WYSIWYG vs. Text Editors|
|7.4: First Complete HTML File|
|7.6: Optional Closing Tags|
|7.8: Special Characters|
|8.1: Our First Style Example|
|8.2: Style Sheets|
|8.6: Flow (span and div)|
|8.7: Cascading Behaviour|
|9.1: Dynamic Web - Terminology|
|9.2: Dynamic Web - Server-Side Dynamic Webpages|
|9.3: Dynamic Web - Client-Side Dynamic Webpages|
|9.4: Dynamic Web - Client + Server Applications|
|10.1: Understanding Search||Alternate Link||Transcript|
|10.2: Effective Google Searching||Alternate Link||Transcript|
The plan is that there will be a corresponding assignment for each module.
Protip: Although each assignment will be weighted the same, it is inevitable that some assignments will be harder and/or require more work than others.
Each module and its assignment will normally be available on the Monday of the corresponding week.
Each assignment will be due on the following Monday (or Tuesday if Monday is a University holiday) at 11:59 pm.
You must submit and pass Assignment 0 (with a minimum of 75%) before any other assignment will be accepted. You have an unlimited number of attempts to complete this assignment.
Assignments will include quizzes with multiple choice and/or short answer questions.
Some assignments may have more than one "quiz" in Learn.
Some assignments will also require you to submit files (and/or upload them to your website).
All questions for these parts of the assignment are found in the the Quizzes tab (under the Assessments drop down menu) on Learn (also known as Desire2Learn or D2L).
You may answer as few or as many questions as you wish each time you read those files. If you are not yet ready to submit your answers, click on Save Answers and exit the quiz (without submitting it). When you are ready to submit the quiz, hit the Go to Submit Quiz. You will be directed to a Quiz Submission Confirmation page. Ensure that you click Submit Quiz and that you are subsequently directed to your Submission View.
For a more detailed explanation of the Quizzes tool (with visuals), please visit Waterloo LEARN Help.
You are responsible for ensuring that you correctly follow all the steps for submitting quizzes.
Note: Quizzes may be submitted once only (Assignment 0 only can be submitted several times).
All questions for this part of an assignment can be found in the Content tab (under the Course Materials drop down menu).
Each file you create must be saved using the following naming format: the assignment number followed by the question number and ending with the appropriate extension for the type of file. For example, if question C1 on Assignment 1 asks you to submit a text file, you would create a file named A1C1.txt. Similarly, if question C2 on that assignment asks you to submit an image, you would create A1C2.jpg. Please note that for Assignment 0, you are not required to rename the file before submitting it.
Mac Users: Ensure that there is an extension at the end of your file name (e.g., A1C1.txt).
You must upload your file, using the following steps:
For a more detailed explanation of the Dropbox tool (with visuals), please visit Waterloo LEARN Help.
Note: Your instructor may provide feedback to your submission. Once it is available, you can view this feedback by returning to dropbox.
It is your responsibility to ensure that you submit the correct files on time and that they are, in fact, uploaded. Ensure that you save a copy of your email Confirmation Receipt.
Quizzes can be submitted once only for any assignment, except for Assignment 0, where multiple submissions are permitted.
You can resubmit your files to Dropbox as many times as you wish prior to the deadline. This is especially useful if you accidentally submit the wrong file or you wish to modify a submitted file for any reason. Follow the above steps each time you submit. The marker will grade your last submission only. Late days will be applied to the latest submission that is marked.
Assignment marks are eventually posted in the Gradebook. To view your grades, click on Grades in the navigation bar. General feedback will be made available in the assignment folder approximately one week after the assignment is due. Feedback for multiple choice and short answer questions will be available within your quiz submission (under Quizzes). Feedback for long answer (applications) can be found in the Dropbox unless instructed otherwise.
If you have a question about your mark or wish for your assignment to be remarked, please contact the ISAs at email@example.com. Remark requests must be submitted within two weeks from the date the mark was received. Any requests submitted after this time will not be processed.
Please note that if you email the instructor a question about your marks, the instructor will forward it to the ISAs. To get faster responses, email the ISAs directly at firstname.lastname@example.org.
Laboratories equipped with Macs running Mac OS X are located in MC2062, MC2063, MC3003, MC3004, MC 3005, and MC3027 are usually open 24 hours a day. You may use the machines at any time.
This system contains the memory, CPU, hard disk and the CD player in the main system unit. Your files will be stored on a centrally located file server on a network, which enables you to access your files from any of the computers in the lab. You can retrieve your files from any connected computer.
When using the UW lab, never save your files to the desktop as you risk losing your work because the desktop is not part of the shared, saved network. Always store your documents and folders under the Documents folder provided.
It is expected that each student will work in a responsible manner and exercise good judgment and common sense. If at any time you are not sure how to handle a particular situation, please ask your ISA, instructor, or ISC for advice.
Even if you use your own computer for this course, you still need access to some services provided by the University. For this purpose, a User ID has been created for you using the University of Waterloo standard of your initials (as shown on your student ID card), followed by your last name, with spaces, apostrophes, periods, and hyphens removed and with a maximum of 8 characters. To distinguish users who would otherwise have identical User IDs, digits may have been inserted after the first initial, producing a User ID such as j22smith. This is the "username" that you use for many university related functions, including signing on to Quest and D2L.
All students in CS 100 have been allocated computing resources for the course in the student.cs environment managed by the Cheriton School of Computer Science. You will use these facilities for storing Web pages and for working with the Wiki. You may also use the on-campus CS 100 Labs (Mac computers running Mac OS X). Access to the student.cs environment is also based on your User ID.
There is a Web interface at https://www.student.cs.uwaterloo.ca/password/ for setting or changing your password. You need to use that interface in order to set the password you will use when logging onto a Mac in the UW Lab.
Follow the instructions given on that site. You will first be presented with a screen asking you to enter your UW User ID and password in order to confirm your identity.
You will then be presented with a page in which you can enter the password you wish to use.
Although the same User ID is used for multiple systems, the password you use to sign onto the student.cs environment is not the same as the password you use to sign onto WatIAM, Learn, or Quest.
As explained on that page, there are several restrictions on valid passwords for the CS environment, and you might have to try several alternatives before one is acceptable. The purpose of these restrictions is to make it difficult for others to guess or "discover" your password and thereby access your personal property stored on the system.
As you type the password you wish to use, the system will respond with messages explaining what needs to be changed. For example, you might see one of the following:
Eventually you will see:
Type the same password into the confirmation box and then press save. Starting approximately five minutes later (the time needed to propagate your password to the various systems in the CS environment), you will be able to sign onto any Mac in the CS 100 lab.
It is important that either you logout or you close the browser when you are done, since your UW User ID and password will have been temporarily stored; if they are not deleted by closing the browser, the next student using the machine could access your grades or other personal information.
If the computer is not already on (for the Mac, either the desktop is visible on the screen or the white light under the screen is on), turn your Mac on by pressing the power key (located on the back of the iMac's monitor).
After a few seconds the screen will display a form allowing you to log in. You should see the cursor blinking in the box to the right of a User ID or see that the Name: box and any contents in it are highlighted. Use the keyboard to type in your UW User ID (the same as you use for D2L and WatIAM). Be careful: there are no spaces or periods in your User ID. Press the tab key to advance to the Password box and enter the password you set through the Web interface. To complete the login process, position the mouse over the button marked Log in and click with the left mouse button.
If the login window on your screen "shakes", it means there is an error with your User ID or your password.
First, verify your User ID. Check that the caps lock key is not on. If your User ID is typed correctly, highlight
the password line by clicking at the beginning of the password and dragging to the end, delete your password then
retype it. Once you have retyped the password, click the Log In button. If the login window "shakes" again, ask
an ISA for assistance, try another computer in the Lab, or reset your password using the Web interface.
At this point, you have completed the first process of logging into the computer system. Once you log in, your screen will display a desktop.
The Macintosh HD icon represents a hard disk physically located inside your computer. This disk contains all applications, preferences and information needed for the computer to run properly.
One advantage of using a network is that you can use any computer on the network to retrieve your files if they are stored in a central location. Several of the disk icons that appear on your screen do not reside physically on your computer. Instead, they are stored elsewhere by your computing service provider. A disk to which you have access but is not located on your computer is known as a virtual disk.
Much of the information on a networked computer applies to all users. Other data is specific to you the user, such as your User ID and password. In order to personalize your working environment, the computer uses preferences to store settings that are unique to you. Before you begin using applications on the computer, you need to personalize your environment.
In order to maintain a culture of academic integrity, members of the University of Waterloo community are expected to promote honesty, trust, fairness, respect and responsibility. Please take the time and go through the following:
To better understand the basic values of academic integrity and the consequences of academic misconduct please refer to Academic Integrity tutorial.
A student who believes that a decision affecting some aspect of his/her university life has been unfair or unreasonable may have grounds for initiating a grievance. Read Policy 70, Student Petitions and Grievances, Section 4. When in doubt please be certain to contact the department's administrative assistant who will provide further assistance.
A student is expected to know what constitutes academic integrity, to avoid committing an academic offence, and to take responsibility for his/her actions (see Academic Integrity Guidelines ). A student who is unsure whether an action constitutes an offence, or who needs help in learning how to avoid offences (e.g., plagiarism, cheating) or about 'rules' for group work/collaboration should seek guidance from the course instructor, academic advisor, or the undergraduate Associate Dean. For information on categories of offences and types of penalties, students should refer to Policy 71, Student Discipline. For typical penalties check Guidelines for the Assessment of Penalties
A decision made or penalty imposed under Policy 70 (Student Petitions and Grievances) (other than a petition) or Policy 71 (Student Discipline) may be appealed if there is a ground. A student who believes he/she has a ground for an appeal should refer to Policy 72 (Student Appeals)
In accordance with Policy 46, Appendix A - Access to and Release of Student Information, the Centre for Extended Learning does not release final examination grades or final course grades to students. Students must go to Quest to see all final grades. Any grades posted in Waterloo LEARN are unofficial.
AccessAbility Services, located in Needles Hall, Room 1401, collaborates with all academic departments to arrange appropriate accommodations for students with disabilities without compromising the academic integrity of the curriculum. If you require academic accommodations to lessen the impact of your disability, please register with them at the beginning of each academic term.
If you or anyone youknow experiences any academic stress, difficult lifeevents, or feelings like anxiety or depression, we strongly encourage you to seek support.
It is our intent that students from all diverse backgrounds and perspectives be well served by this course, and that students’learning needs be addressed both in and out of class. We recognize the immense value of the diversity in identities, perspectives, and contributions that students bring, and the benefit it has on our educational environment. Your suggestions are encouraged and appreciated. Please let us know ways to improve the effectiveness of the course for you personally or for other students or student groups. In particular:
All rights, including copyright, images, slides, audio, and video components, of the content of this course are owned by the course author, unless otherwise stated. These web pages are owned or controlled by the University of Waterloo, Centre for Extended Learning. By accessing the web pages, you agree that you may only download the content for your own personal, non-commercial use. You are not permitted to copy, broadcast, download, store (in any medium), transmit, show or play in public, adapt, or change in any way the content of these web pages for any other purpose whatsoever without the prior written permission of the course author and the University of Waterloo, Centre for Extended Learning.
Respect the copyright of others and abide by all copyright notices and regulations when using the computing facilities provided for your course of study by the University of Waterloo. No material on the Internet or World Wide Web may be reproduced or distributed in any material form or in any medium, without permission from copyright holders or their assignees. To support your course of study, the University of Waterloo has provided hypertext links to relevant websites, resources, and services on the web. These resources must be used in accordance with any registration requirements or conditions which may be specified. You must be aware that in providing such hypertext links, the University of Waterloo has not authorized any acts (including reproduction or distribution) which, if undertaken without permission of copyright owners or their assignees, may be infringement of copyright. Permission for such acts can only be granted by copyright owners or their assignees.
If there are any questions about this notice, please contact the University of Waterloo, Centre for Extended Learning, Waterloo, Ontario, Canada, N2L 3G1 or email@example.com