College of the Siskiyous - CSCI 20 - Introduction to Computer Applications

Home

Syllabus

Calendar

Student Information Form

Online Classroom ~ Moodle

Education on the Internet

Instructor ~ David Donica

Prospective Students Current Students Faculty and Staff Alumni and Community
CSCI 20 ~ Introduction to Computer Applications ~ Spring 2008

This page will provide you with the most up to date class schedule and readings. Please bookmark this page and refer to it for assignment and quiz schedules.

Week	Date	Topic	Readings & Assignments
1	1/16/08	Introduction to the Course	No reading required
		Introductions Setup network accounts Overview of the course Using the COS network Using Windows XP
2	1/23/08	Browsing the Internet Using Internet Explorer 7.0	Introduction pages 41-48
		Using a web browser Review of Windows XP
3	1/30/08	Preparing Documents	Word Chapter 1 pages 7-34
		Open Microsoft Word Create, save, name, print, open, and close a Word document Exit Word and Windows Edit a document Move the insertion point within a document Scroll within a document Select text in a document Use the Undo and Redo buttons Check spelling and grammar in a document Use the Help feature	Fill out the Student Information Form Start Assessment 1 page 32 Assessment 2 page 32
4	2/6/08	Formatting Characters and Paragraphs	Word Chapter 2 pages 35-68
		Change the font and font effects Format selected text with buttons on the Mini toolbar Apply styles from Quick Styles sets Apply themes Change the alignment of text in paragraphs Indent text in paragraphs Increase and decrease spacing before and after paragraphs Repeat the last action Automate formatting with Format Painter Change line spacing in a document Reveal and compare formatting	Start Assessment 1 page 66 Assessment 3 page 67
5	2/13/08	Customizing Paragraphs	Word Chapter 3 pages 69-102
		Apply numbering and bulleting formatting to text Insert paragraph borders and shading Apply custom borders and shading Sort paragraph text Set, clear, and move tabs on the Ruler and at the Tabs dialog box Cut, copy, and paste text in a document Copy and paste text between documents	Start Assessment 1 pages 98-99 Assessment 3 pages 100-101
		Formatting Pages	Word Chapter 4 pages 103-144
		Change document views Navigate in a document with Document Map and Thumbnails Change margins, page orientation, and paper size in a document Format pages at the Page Setup dialog box Insert a page break, blank page, and cover page Insert page numbering Insert and edit predesigned headers and footers Insert a watermark, page color, and page border Find and replace text and formatting	Start Assessment 1 page 141 Assessment 3 page 142
6	2/20/08	Review and take the Word Quiz
		Review Chapters 1-4 Take the Word Quiz	Take the online quiz Take the in class skill assessment Turn in assigned assessments for Chapters 1-4
7	2/27/08	Preparing an Excel Workbook	Excel Chapter 1 pages 1-36
		Identify the various elements of an Excel workbook Create, save, and print a workbook Enter data in a workbook Edit data in a workbook Insert formula using the Sum button Apply predesigned formatting to cells in a workbook Use the Help feature	Start Assessments 1, 2, 3 & 4 - pgs 33, 34
8	3/5/08	Inserting Formulas in a Worksheet	Excel Chapter 2 pages 37-66
		Write formulas with mathematical operators Types a formula in the Formula bar Copy a formula Use the Insert Function feature to insert a formula in a cell Write formulas with the AVERAGE, MAX, MIN, COUNT, PMT, FV, DATE, NOW, and IF functions Create an absolute and mixed cell reference	Start Assessments 1, 2, 3 & 4 - pgs 62, 63
9	3/12/08	Formatting an Excel Worksheet	Excel Chapter 3 pages 67-108
		Change column widths Change row heights Insert row and columns in a worksheet Delete cells, rows, and columns in a worksheet Clear data in cells Apply formatting to data in cells Apply formatting to selected data using the Mini toolbar Preview a worksheet Apply a theme and customize the theme font and color Format numbers Repeat the last action Automate formatting with Format Painter Hide and unhide rows and columns	Start Assessments 1 & 3 - pgs 103, 105
		Enhancing a Worksheet	Excel Chapter 4 pages 109-147
		Change worksheet margins Center a worksheet horizontally and vertically on the page Insert a page break in a worksheet Print gridlines and row and column headings Set and clear a print area Insert headers and footers Customize print jobs Complete a spelling check on a worksheet Find and replace data and cell formatting in a worksheet Sort data in cells in ascending and descending order Filter a list using AutoFilter Plan and create a worksheet	Start Assessments 2 & 4 - pgs 143, 144
	3/19/08	Spring Break - No Class
10	3/26/08	Review and take the Excel Quiz
		Review Chapters 1-4 Take the Excel Quiz	Take the online quiz Take the in class skill assessment Turn in assigned assessments for Chapters 1-4
11	4/2/08	Creating Database Tables	Access Chapter 1 pages 1-34
		Open and close objects in a database Design a table Determine fields and assign data types in a table Enter data in a table Open, save, print, and close, a table Add and delete records in a table	Start Assessments 1, 2, & 3 - pgs 31-33
12	4/9/08	Creating Relationships between Tables	Access Chapter 2 pages 35-64
		Create a database table with a primary key and a foreign key Create a one-to-many relationship between tables Create a one-to-one relationship between tables Display related records in a subdatasheet	Start Assessments 1 & 2 - pgs 60-62
13	4/16/08	Review and take the Access Quiz
		Review Chapters 1-2 Take the Access Quiz	Take the online quiz Take the in class skill assessment Turn in assigned assessments for Chapters 1-2
14	4/23/08	Preparing a PowerPoint Presentation	PowerPoint Ch 1 pages 1-40
		Create a PowerPoint presentation with an installed template Open, save, run, print, close, and delete a presentation Plan a presentation Create a presentation using a theme template Insert slides, insert text in slides, and choose slide layouts Change presentation views Navigate and edit slides Create a presentation from an existing presentation Apply a design theme to slides in a presentation Prepare a presentation from a blank presentation Prepare a presentation in Slides/Outline pane Add transitions and sounds to a presentation	Start Assessments 1 & 2 - pgs 37-39
15	4/30/08	Modifying a Presentation and Using Help	PowerPoint Ch 2 pages 41-73
		Check spelling Insert and delete text in slides Find a replace text in slides Cut, copy, and paste text in slides Rearrange text in the Slides/Outline pane Size and rearrange placeholders Insert, delete, move, and copy slides Copy slides between presentations Duplicate slides Reuse slides Preview a presentation Use the Help feature	Start Assessments 1, 2, & 3 - pgs 70-72
		Formatting Slides	PowerPoint Ch 3 pages 75-118
		Apply font and paragraph formatting to text in slides Apply formatting with the Mini toolbar and Format Painter Customize bullets and numbers Modify them colors and fonts Change slide background Change page setup Create custom themes including custom theme colors and theme fonts Delete custom themes	Start Assessments 1 & 2 - pgs 114-116
16	5/7/08	Inserting Elements in Slides	PowerPoint Ch 4 pages 119-164
		Insert, format, select, and align a text box Set tabs in a text box Insert, format, and copy shapes Display rulers, gridlines, and guides Group and ungroup objects Insert, crop, size, move, and format a picture Insert a pictures as a slide background Insert, size, scale, rotate, and position a clip art image Create and format WordArt text Insert objects such as a header, footer, date, slide number, and symbol	Start Assessments 1 & 2 - pgs 155-162
17	5/14/08	Review and take the PowerPoint Quiz
		Review Chapters 1-4 Take the PowerPoint Quiz Review for Final	Take the online quiz Take the in class skill assessment Turn in assigned assessments for Chapters 1-3
18	5/21/08	Final
		The final will given online and using the programs you learned in this class. You will take the final exam in Greenshields Hall 3/4 at 6:00pm. Please notify the instructor in advance if you are unable to make the final exam. If you have any questions you can email the instructor at donica@siskiyous.edu or call 530.859.2854 Have a great summer break!	Take the Final The Final will be both an online exam and a skill assessment portion using the computer