Computer Science 12
Week 1
Saturday, January 28, 2012
- Course information
- General tutorials on Microsoft Word 2007
- Excel tutorials
- HTML tutorials
- Tutorials on miscellaneous topics covered this week
- Assignment 1 (preparing to write a paper; topic selection due Wednesday, February 8, 2012)
- Other important information, needed this week
- Jerry Waxman's course notes – available at the Copy Center under Gino’s Pizza, across Kissena Blvd from QC
- Exploring Microsoft Word by Grauer and Barber
- Exploring Microsoft Excel by Grauer and Barber
- Exploring Microsoft Access by Grauer and Barber
- Websites of other Computer Science 12 instructors: (1) Jerry Waxman and (2) Joe Svitak. The latter site includes Hands-on exercises (downloadable .exe file) and sample exams. (Note that this course, as taught by me, will be organized somewhat differently from the course as taught by other instructors.)
- Companion website for the Grauer and Barber textbooks (and the author's page)
The grading scheme will be flexible, giving you the best of a few possible formulas, but in general you can count on the following weights:
- Approximately 35% final exam
- Approximately 30% quizzes (dropping the lowest quiz)
- Approximately 25% homework (including paper drafts)
- Approximately 10% paper (final version)
- Up to 5% maximum extra credit for good class participation and/or assisting other students during the lab session
To all information for Week 1 | To all other important information
General tutorials on Microsoft Word 2007/2010
Below are some general tutorials on Microsoft Word, with an emphasis on matters relevant to writing academic papers:
- Microsoft Word 2007 FAQ - Indiana University of Pennsylvania
- Microsoft Word 2007/2008 - University of Wisconsin at Eau Claire
- Word 2007 Tutorial - Florida Gulf Coast University
- Complex Documents in Microsoft Word in Intermediate Users Guide to Microsoft Word by Charles Kyle Kenyon, with an emphasis on how to create legal documents, which are similar to academic papers in various ways
- Microsoft Word 2007 Tips, Tricks, and Tutorials - About.com
To all information for Week 1 | To all tutorials about Word
General tutorials on Excel 2007:
- Spreadsheets on About.com, including Basic Excel 2007 Spreadsheet Tutorial
- Microsoft Excel 2007 Tutorial by Denise Etheridge
- Excel tutorial - Vertex42
- Excel 2007 Tutorial - Florida Gulf Coast University
- Excel 2007 (Windows) Tutorial - Brown University
- Microsoft Excel 2007 Tips
On the use of formulas:
- Basic Excel 2007 Formula Tutorial on About.com
- Building Basic Formulas in Excel 2007 by Paul McFedries
- Combining arithmetic operators in the Microsoft Excel 2007 Course on the Home and Learn site.
- Calculation operators and precedence on Microsoft's site
On cell references, absolute vs. relative:
- Home & Learn: Absolute Cell References
- About.com: Absolute Cell Reference
- Karyn Stille: Relative and Absolute Cell References
- ozgrid: Excel cell references
- Pearson: Relative And Absolute References In Formulas
To all information for Week 1 | To all tutorials about Excel
Here are links to some HTML tutorials:
- W3schools.com HTML tutorial - includes lots of reference material
- Getting started with HTML on the website of the World Wide Web Consortium (the nearest thing to an official governing body deciding standards for the web - see W3C HTML Activities on W3Schools.com)
- The Pocket HTML Tutorial
- HTML tutorials - WebReference.com
- HTML for Beginners - HTML Primer
- Non-Technical Introduction and HTML 4.01 Tags on the HTML Goodies site
- HTML Tutorial - The Computer Technology Documentation Project
To all information for Week 1 | To all tutorials about HTML
Tutorials on miscellaneous topics covered this week
Editing HTML files using Windows Notepad:
- About.com: Writing HTML in Notepad
- Northern Virginia Community College: Notes on Using Notepad with HTML
Note: Editing files in Windows Notepad can be done reliably only when filename extensions are visible. See the pages below on how to make filename extensions visible in Windows 7.
Filename extensions in Windows:
- Microsoft: How to show or hide file name extensions in Windows Explorer and File names and file name extensions: frequently asked questions
- Windows 7 Forums: How to Hide or Show Known File Type Extensions in Windows 7
- Safari Books Online: Windows 7: The Missing Manual: Filename Extensions and File Associations
To all information for Week 1 | To all tutorials about miscellaneous topics
Assignment 1 (preparing to write a paper; topic selection due Wednesday, February 8, 2012)
Obtain Jerry Waxman's CS 12 lecture notes, available at the Copy Center under Gino’s Pizza, across Kissena Blvd from QC. During the next week and a half, skim through the first third of the notes (up to but not including the lectures on Excel) and choose a topic for the paper that you'll be asked to write. The paper may be on any of the computer-related topics mentioned in the notes EXCEPT the Microsoft products that we'll be teaching you about (Word, Excel, and Access).
Email me, by no later than Wednesday, February 8, about the topic you have chosen.
Then reasearch the paper using Jerry Waxman's notes plus at least one other printed (offline) source plus at least two websites. Send me email containing a list of your sources by no later than Wednesday, February 15.
The first draft of your paper must be submitted by no later than the beginning of class on Saturday, February 25. Submit it via Blackboard. You should also bring a copy of your first draft with you to class on that day (either on a flash drive or by emailing it to yourself). We will show you how to use various Microsoft Word 2007/2010 features to make the paper look nicer.
Your first draft, which must be finished before our class on February 25, should be at least three pages long and must include at least one quote from each of your four sources, and must have at least three sections with headings. We will then show you how to do citations, footnotes, bibliography, and table of contents, using Microsoft 2007/2010 features which make these chores very easy.
The final paper itself, which will be due later in the semester, should be six to eight pages long, double spaced, with a font size anywhere between 12 and 15. The final version of the paper must have a table of contents at the beginning, properly formatted footnotes (which will place themselves automatically at the bottom of the relavant page), citations (distinct from footnotes), a bibliography, and at least three other sections whose titles will appear in the automatically generated table of contents at the beginning. The paper must be an original paper, not plagiarized. (Warning: BlackBoard includes the ability to search automatically for possible plagiarism.)
Your first steps will be to choose the topic, gather sources, and tell me about the topic and the sources by emailing me at the following address (not any other email address of mine, please):
dnixon-cs12@nyclocal.net
To all information for Week 1 | To all homework assignments
Other important information, needed this week
- ADS account signup
- CUNY Portal, including access to Blackboard after you log in.
- Queens College student email
- Queens College main website. To find your way around, see the site map.
- Academic Calendars according to the Registrar's office
- Weekend College
- Queens College Computer Science Department
- Google (web search engine) - needed to find websites to cite in the paper you'll be writing
- Policies Governing Use of Queens College Information Technology
To all information for Week 1 | To all other important information