Comp 100

Usage & Impact of Computers

Last Update: 14 December 2012 12:59:41 PM

Academic

Current Events

PowerPoint Take Home Exam

1. Capstone Exercise Chapter One -- pages 114-115

2. Capstone Exercise Chapter Two -- page 157

PowerPoint Student Data Files

Access Extra Credit

1. MyItLab Training, Practice Exams, & Grader Projects completion

2. Self-Selected Capstone Projects, i.e., some or all of the following:

a. Capstone Project 1 page 113

b. Capstone Project 2 page 181-182

c. Capstone Project 3 page 226-227

d. Capstone Project 4 page 293

Word Take Home Exam

Using the Exploring Word 2010 book

Complete both projects below by following the instructions provided in the text:

A. Capstone Exercise page 209 using file w03c1tulip.docx located on the DVD included in book

B. Repairing Tables (Table of Contents & Table of Figures) page 210 using file w03b3table.docx located on the DVD included in book

The path to the above referenced files is as follows:

DVD --► Assets --► student_data_files --► word --► word_03 --► w03c1tulip.docx & w03b3table.docx

If you do not have access to the book’s DVD, you can copy the files from my copy of the DVD during office hours

For all three applications, i.e., Powerpoint, Access or Word,

submit the resulting documents in hardcopy form to JD 4503

by 12 noon, Monday, 17 December 2012

Make sure you write your name each set of documents

Course Schedules

Friday pdf

Technology in Action

Overheads

Lecture Notes

TIA Quiz Site Guide

TIA Quizzes are assigned on the first day of class each week,

and are due on the first class day of the following week

Syllabus pdf html

Student Learning Outcomes pdf html

Standards for Student Conduct pdf

Cover Sheet for Submitted Documents pdf

Library Research Project Due Dates:

MW

TTh

Notice: Library Research Project WILL NOT be accepted after the due date!!

Library Website http://library.csun.edu/

Deep Web Information http://bit.ly/compsci100

Research Librarians: Danielle Skaggs Isabelle Ramos

818-677-6808

danielle.skaggs@csun.edu isabelle.ramos@csun.edu

Research Navigator (supplied by Pearson)

· try to login using your MyItLab login name & password

· it may or may not give you access

http://www.researchnavigator.com/index.asp

Quizzes

Quiz #1

Tools

· Overheads: provided by the textbook publisher; available for downloading and/or viewing. PowerPoint 2010 required!

· http://www.howstuffworks.com provides current information on all aspects of computer hardware, e.g., USB ports, serial ports, parallel ports, firewire ports, and keyboards.

· http://en.wikipedia.org/wiki/Names_of_large_numbers provides the names of large numbers.

Factoids

(1) Average number of readers per blog ≈ 1

(2) Powers of Two

i. Maximum number of times that a normal sheet of paper can be folded is seven!

ii. After seven folds, the number of sheets is 2⁷ = 128

iii. What is the smallest size of a sheet of paper that can be folded eight times?

(3) The edge of a safety razor blade is 5 nanometers.

(4) The width of a human hair is 50,000 nanometers.

(5) A human hair has the same hardness as a copper wire of the same diameter.

(6) Googol is the name for the number 10¹⁰⁰.

(7) Google is the name of a search engine.

(8) There are 3x10¹¹ (300,000,000,000 or 300 billion) stars in the Milky Way galaxy.

(9) There are 10¹¹ (100,000,000,000 or 100 billion) galaxies in the universe.

(10) Raw estimate: 3x10²² (30,000,000,000,000,000,000,000 or 300 sextillion) stars in the universe.

(11) The human brain contains 10¹¹ (100,000,000,000 or 100 billion) neurons.

(12) Each neuron makes 10,000 connections to other neurons.

(13) The human brain contains 10¹⁵ (1,000 trillion, i.e., one quadrillion) connections between neurons.

Administrative

http://www.myitlab.com

Archive

(Information listed below may not be current nor applicable to your course; it is a collection of messages used in prior semesters. Rely on this material if it was presented to you earlier in the current semester and not repudiated by your instructor.)

Excel Exam Preparation – Study chapters 1, 2, 3 of the MSOffice Excel 2010 book with an emphasis on

· Hands-On Exercises

· Objectives Review (to identify the important concepts of the chapter)

· Practice Exercises

· Mid-Level Exercises

· Capstone Exercise

· Practice Exams for TIA 9th edition can be found by clicking "TIA 9th ed." icon in "View All Content"

· Each Chapter Quiz will contain 15 questions.

Required Material & Equipment

Required Textbook Bundle is available in Matador Book Store – go to the Comp 100 shelves &/or ask the bookstore personnel for help. The bundle contains five books, one each for MSWord, Excel, Access, PowerPoint & a book on Computer Technology; the bundle also contains a flat folder containing the access code for the MyITLab system. If you buy the books used, you will need to purchase a NEW access code; they CANNOT be reused! Do Not Purchase a Used Access Code! The access code allows the use of the MyItLab which is the system used for grading your work in this course. Since the bundle costs $154.75 at the Matador Bookstore and $134.75 at the A+ Textbook Store, do not pay more than $54.75 for the used books, otherwise you will be spending more on the used books “bundle” than on the new books. The bundle ISBN is 9781256163626. DO NOT PURCHASE THE BOOKS FROM AMAZON OR OTHER VENDORS ONLINE! The content of this set of books has been selected, i.e., assembled, according to guidelines established by the CSUN faculty. Textbooks purchased from other vendors may not contain the same material.

1. In order to work on the class material at home you will need a system that supports either the Windows 7 Operating System or else a Mac computer that can be modified as per item #3 below.

2. The Windows 7 system must have the Office 2010 Suite installed and supports the installation of the MyITLab system which comes with your textbook package. Neither MS Office 2003 nor MS Works is of any use for this class! The Office 2010 Suite can be purchased at http://www.microsoft.com/student/discounts/theultimatesteal-us/default.aspx

3. The current information on the use of MyITLab on the Mac is as follows:

a. Pearson offers a MyItLab simulator which works on most Mac systems; for a few Mac’s it will not install. Even if it installs, you cannot use one feature of the MyItLab and since Mac OS/X will not support Office 2010 for Windows, the use of a Mac in this instance is crippled.

b. If you have a new Mac which contains an Intel chip, you can implement the Bootcamp software which partitions your disk and allows the installation of the Windows 7 Operating System on one partition, you can then install Office 2010 and MyITLab on that same side. The Mac OS/X is still available. At startup time, you make the choice whether to run the Mac OS/X or the Windows 7 operating system. The major drawback with this solution is the technical installation of the Bootcamp software. It is probably not the path most of you want to undertake. This solution requires the purchase of Windows 7 operating system and Office 2010. But it also requires a technically trained person who is skilled in disk partitioning. It also takes a restart of the computer system to swap from one operating system to the other. In order to install Bootcamp, Windows and Office 2010 you need approximately 30GB of free space.

c. If you have a new Mac which contains an Intel chip, you can install VMware Fusion ($49.99) which is enables the installation of the Windows 7 Operating System to run on the Mac without partitioning the disk. Once VMware Fusion is installed, Windows 7, Office 2010 Suite and MyITLab can all be installed. By all current reports, MyItLab, installed in this manner, works without hindrance. It allows the swapping between Mac OS/X and Windows 7 with a simple key stroke; not by a restart of the computer system. This is probably the best solution for most of the class. This solution requires the purchase of VMware Fusion version 4.1, Windows 7 operating system and Office 2010. While it requires an additional cost for the VMware, it does not require disk partitioning, and has excellent support from the VMware and Microsoft staff. In order to install VMware Fusion, Windows and Office 2010 you need approximately 30GB of free space. https://www.vmware.com/vmwarestore/

d. Instead of installing VMware Fusion, there is a package called VirtualBox which is freely available as Open Source Software under the terms of the GNU General Public License (GPL) version 2. As is the protocol of Open Source Software Alliance, satisfied users are encouraged to contribute; Oracle ensures the product always meets professional quality criteria. Once again, the major drawback with this solution may be the level of technical knowledge &/or physical endurance required to weave through the installation procedures. Once installed, the performance should be compatible with the VMware Fusion software.

https://www.virtualbox.org/

https://www.virtualbox.org/wiki/Downloads

for Mac OS/X choose item listed as

· VirtualBox 4.1.8 for OS X hosts x86/amd64

e. If you have an old Mac which contains a Motorola chip, you will not be able to use it in this class.

4. The installation of MyITLab on your personal computers will be discussed in class; DO NOT attempt to do this until we discuss it in class.

5. If you manage your time, you can utilize the Comp 100 free lab time, see the lab schedules, to complete your work and thus complete the course without access to a system at home. You will not be able to complete the work during the scheduled class time. If you are later going to make an excuse that do not have a computer at home, please see me now!

6. Installation of VMware on Mac OS/X

7. http://www.vmware.com/products/fusion/overview.html

8.VMware Fusion Getting Started Manual

9. Comp 100 Installation Guide

Textbooks

Technology in Action, 9^th edition Evans, Martin, Poatsy

Exploring Series

Word 2010 Introductory Grauer, Hulett, Poatsy

Excel 2010 Introductory Grauer, Mulbery, Poatsy

PowerPoint 2010 Introductory Grauer, Krebs, Poatsy

Access 2010 Introductory Grauer, Mast, Poatsy

The packet may or may not contain the following material

GO! Series Integrated Projects

Introduction to WebApps

Notice Archive

10. Create a file entitled “Lost” on your USB Drive which includes your full name, your phone number, and your email address. This will enable the office staff to efficiently locate you and return your USB drives, perhaps before you even notice that it is gone!

11. For any work done outside of MyITLab, make sure that you save your work in at least two locations, e.g., on your memory stick, on your hard drive at home and on the U-drive available at CSUN. The U-drive is available by “Saving As” and choosing the U-drive option. Save all projects on your memory strip, your C-drive at home, and on the CSUN provided U-drive; this action will prevent loss of data and having to redo lost work!

12. Most of the homework and projects will be submitted via a new software tool; however the projects will require the submission of a paper document. DO NOT E-MAIL THOSE PROJECTS TO ME! Submit them to me during class time, or to the computer science office JD4503! Those projects must consist of a cover page (see the syllabus).

13. DO NOT E-MAIL HOMEWORK OR PROJECTS TO ME! SUBMIT THEM TO ME DURING CLASSTIME OR TO THE COMPUTER SCIENCE OFFICE JD4503 AT OTHER TIMES!

14. All projects must consist of a cover page (see the syllabus) and each case must be preceded by a subcover sheet (again see the syllabus); projects should be placed in the same order as they were assigned.

15. To install and use MyITLab from home, you MUST use Internet Explorer, not Firefox, nor any other browser! Use the Installation Wizard; be sure to print and follow the Installation Instructions. If you have problems, please record all relevant information (if not sure what is relevant, try highlighting everything and then press the Ctrl key and while depressing that key, press the letter “c”. Open MSWord, depress the Ctrl key and while depressing that key, press the letter “v”. Print the MSWord document and bring to an office hour.

Now is the time to prepare for the Technology Final Exam by constructing a 3”x3” note card with all the material that you think that you might need to pass the exam. The preparation of the card will help you remember the information that you need. Remember to use all the study tools supplied in the textbook and the associated website!

Library Project 10%

MyITLab Exams (Word, Excel, Access, PP) 50%

Technology Midterm Examination (Concepts) 10%

Technology Final Examination (Concepts) 30%

100%

Access Preparation (How to Study Access)

1. Read Tech in Action chapter 11 with emphasis on pages 526-539.

2. Read the MSOffice Access 2010 book chapter 1; complete the

a. Hands-On Exercises (yellow pages)

b. Practice Exercise: Ch 1 Custom Coffee pages 108-110

3. After you complete the Custom Coffee project then complete the following MyItLab Access tasks

a. Skill-Based Training

b. Skill-Based Exam

c. Grader Project [Homework]

4. Read the MSOffice Access 2010 book chapter 2; complete the

a. Hands-On Exercises (yellow pages)

b. Practice Exercise: Ch 2 Davis Insurance Company pages 175-177

5. After you complete the Davis Insurance Company project then complete the following MyItLab Access tasks

a. Skill-Based Training

b. Skill-Based Exam

c. Grader Project [Homework]

Remember to bring your flash drive to EVERY class! Flash drives are easy to leave behind in the computer at the end of class; if you have lost your flash drive in this room, see me!

Finding answers to questions and obtaining immediate information on MS Office products

· Google, e.g., Sample 1

· UTube, e.g., http://www.youtube.com/watch?v=eke-t_Fmx-8

Student Data Files necessary to complete the exercises in the Excel, Word, Access, & PowerPoint books, are

· available on the CD-ROM in the back of each individual book

· located in the lower left corner of the monitors in JD 1105 & 1107; they should be copied to a flash drive

for use in other locations which support MSOffice 2010 in a Windows environment.

Open Labs:

MyITLab access is available in

· JD1105, JD1107 and JD1600 when classes are not in session:

see the following schedules for open hours

http://python.ecs.csun.edu/compsci/labhours/1105.pdf

http://python.ecs.csun.edu/compsci/labhours/1107.pdf

http://python.ecs.csun.edu/compsci/labhours/1600.pdf

(access to MyItLab in JD 1600 requires additional information which will be made available in the near future)

· Oviatt Library’s Collaboratory Computing Lab

see the following for location & open hours

http://library.csun.edu/Services/OpenLabs

Final Exam Protocol

You MUST

1. be able to show your Student Identification Card in order to take the Final Examination

2. take your examination with the class for which you registered unless you have been given prior permission by the instructor to attend a different class session during the term

3. arrive within a few minutes of the scheduled exam time; late admissions will not be tolerated

You may bring your Access and PowerPoint books to the exam.

§ Excel 2010

o Office Fundamentals (Windows 7), pages 1-66, if necessary

o Excel Chapter 1 Introduction to Excel, pages 67-128 (while reading, it is a good idea to do the keystroke exercises to develop muscle memory)

· document “e01h1markup_LastnameFirstname” is created on page 74

· “e01h1markup_LastnameFirstname” is modified to “e01h2markup_LastnameFirstname” on page 81

· Make sure that you replace “LastnameFirstname” with your actual name, e.g., in my case: “e01h1markup_PutnamCharles”

· When working the exercises, keep a trail of all previous documents, i.e., do not rename a file but save the old file under a new name, thus preserving both the old and the new copy

o Excel Chapter 2 Formulas & Functions, pages 129-176 NOTICE: page 133 file “e02h1loans” is located in your student DVD

Please notice the important changes made to the Course Schedule!

If you have completed the MyItLab Excel 4 segment,

I will give you extra credit for your effort to learn the package.

If you have completed the MyItLab Excel 3 segment, but not the 4^th segment, please move on to Word.

The Excel exam will cover only Chapters 1, 2, & 3; it will NOT cover Chapter 4.

PLEASE ARRIVE TO CLASS ON TIME NEXT FRIDAY, 19 OCTOBER 2012;

YOU WILL BE GIVEN THE ENTIRE TIME TO TAKE THE EXCEL EXAM.

IF I DEEM YOUR LATE ARRIVE TO BE DISRUPTIVE OF THE CLASS,

YOU WILL BE DENIED ENTRY TO THE CLASSROOM AND WILL NOT BE ALLOWED TO TAKE THE EXAM.