Violations of academic integrity will be dealt with by imposing appropriate sanctions. Sanctions for acts of academic dishonesty could include the resubmission of an assignment, failure of the test/exam, failure in the course, probation, suspension from the College, and even expulsion from the College. Student Code of Conduct: All students are expected to conduct themselves as responsible and considerate adults who respect the rights of others. Disruptive behavior will not be tolerated. All students are also expected to attend and be on time all class meetings. No cell phones or similar electronic devices are permitted in class. Please refer to the Essex County College student handbook, Lifeline, for more specific information about the College’s Code of Conduct and attendance requirements. based on the text Course Content Outline: The Pearson Custom Program for CIS Advanced Micro Computer Database custom Essex County College edition with IT LAB’ Access Code, by Robert T ‘MY Grauer; published by Pearson; ISBN #: 978-0-558-08986-3 Class Meeting (80 minutes) Chapter/Topics 1 Introduction to the online software and creation of student accounts Chapter 1 2 Create a PivotTable 3 4 View Select an appropriate chart type, edit a PivotChart – 5 6 Identify a chart type, create calculations in a PivotTable – 7 Test 1 on Chapter 1 Chapter 2 8 9 Macros in Access – 10 11 Assign macros to events, Visual Basic for Applications (VBA) – 12 14 Manage data using SQL, review for the Midterm Exam – 15 Midterm Exam on Chapters 1 & 2 Chapter 3 16 18 Password protect a database, save databases as ACCDE files – 19 20 Analyze database table structures and relationships, move data to new database – files 21 Create usable switchboards 22 Test 2 on Chapter 3 Chapter 4 23 24 Create a hyperlinked field, attach files and graphics to records – 25 Export database objects as HTML files 26 27 Share XML data, share data with Excel, manage e-mail data – 28 Research Project due, Review for the Final Exam 29 Review for the Final Exam (continued)
Violations of academic integrity will be dealt with by imposing appropriate sanctions. Sanctions for acts of academic dishonesty could include the resubmission of an assignment, failure of the test/exam, failure in the course, probation, suspension from the College, and even expulsion from the College. Student Code of Conduct: All students are expected to conduct themselves as responsible and considerate adults who respect the rights of others. Disruptive behavior will not be tolerated. All students are also expected to attend and be on time all class meetings. No cell phones or similar electronic devices are permitted in class. Please refer to the Essex County College student handbook, Lifeline, for more specific information about the College’s Code of Conduct and attendance requirements. Course Content Outline: based on the text The Pearson Custom Program for CIS Advanced Micro Computer Database custom Essex County College edition with ‘MY IT LAB’ Access Code, by Robert T Grauer; published by Pearson; ISBN #: 978-0-558-08986-3 Class Meeting (80 minutes) Chapter/Topics 1 Introduction to the online software and creation of student accounts Chapter 1 2 Create a PivotTable 3 – 4 View Select an appropriate chart type, edit a PivotChart 5 – 6 Identify a chart type, create calculations in a PivotTable 7 Test 1 on Chapter 1 Chapter 2 8 – 9 Macros in Access 10 – 11 Assign macros to events, Visual Basic for Applications (VBA) 12 – 14 Manage data using SQL, review for the Midterm Exam 15 Midterm Exam on Chapters 1 & 2 Chapter 3 16 – 18 Password protect a database, save databases as ACCDE files 19 – 20 Analyze database table structures and relationships, move data to new database files 21 Create usable switchboards 22 Test 2 on Chapter 3 Chapter 4 23 – 24 Create a hyperlinked field, attach files and graphics to records 25 Export database objects as HTML files 26 – 27 Share XML data, share data with Excel, manage e-mail data 28 Research Project due, Review for the Final Exam 29 Review for the Final Exam (continued)
cis.237.outline.f2010.docx