Syllabus

Pre-requisite CIS 118 **  //Benchmark Series Microsoft Office 2007, Windows XP Edition, //by Rutkosky/Rutkosky, © 2008 by Paradigm Publishing, Inc. Student Resources CD (provided with textbook and located on network) Internet Resource Center, [|www.emcp.net/BenchmarkOffice07XP]  USB flash drive or other storage medium  This course explores a complete array of database skills. It includes table, query, form, and report creation and modification. Other topics include application integration and automation of database tasks within the database.
 * [[image:access_key.gif width="66" height="75" align="left"]]BUSINESS TECHNOLOGIES **
 * CIS 145—Complete PC Database (Access) **
 * 
 * Credit Hours 3 post-secondary 0.25 high school **
 * Duration of Course 45 hours **
 * __Required Course Resources __**
 * __Course Description __****: **

<span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; msobidifontfamily: Symbol; msolist: Ignore; mso-fareast-font-family: Symbol; msofareastfontfamily: Symbol;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial;">Introduction to databases <span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; msobidifontfamily: Symbol; msolist: Ignore; mso-fareast-font-family: Symbol; msofareastfontfamily: Symbol;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial;">Designing a database <span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; msobidifontfamily: Symbol; msolist: Ignore; mso-fareast-font-family: Symbol; msofareastfontfamily: Symbol;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial;">Creating tables in a database <span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; msobidifontfamily: Symbol; msolist: Ignore; mso-fareast-font-family: Symbol; msofareastfontfamily: Symbol;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial;">Maintaining a database <span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; msobidifontfamily: Symbol; msolist: Ignore; mso-fareast-font-family: Symbol; msofareastfontfamily: Symbol;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial;">Querying a database <span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; msobidifontfamily: Symbol; msolist: Ignore; mso-fareast-font-family: Symbol; msofareastfontfamily: Symbol;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial;">Creating Forms and Reports <span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; msobidifontfamily: Symbol; msolist: Ignore; mso-fareast-font-family: Symbol; msofareastfontfamily: Symbol;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial;">Integrating a database with other application programs <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; text-decoration: none; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; msoasciithemefont: minor-latin; msohansithemefont: minor-latin; mso-bidi-font-family: Arial; msobidifontfamily: Arial;"> <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial;">The successful learner will be able to: <span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; msobidifontfamily: Symbol; msolist: Ignore; mso-fareast-font-family: Symbol; msofareastfontfamily: Symbol;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial;">Describe databases and database management systems. <span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; msobidifontfamily: Symbol; msolist: Ignore; mso-fareast-font-family: Symbol; msofareastfontfamily: Symbol;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial;">Design a database to eliminate data redundancy <span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; msobidifontfamily: Symbol; msolist: Ignore; mso-fareast-font-family: Symbol; msofareastfontfamily: Symbol;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial;">Create and modify database objects such as tables, queries, forms, and reports. <span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; msobidifontfamily: Symbol; msolist: Ignore; mso-fareast-font-family: Symbol; msofareastfontfamily: Symbol;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial;">Integrate Access with other application programs.
 * __<span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial;">Course Organization: __**
 * __<span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial;">Course Objectives: __**

<span style="font-family: 'Calibri','sans-serif';">Final Grades will be calculated as follows: Average of all Chapter Practice assignments 10% Average of Case Study assessments 30% Average of SNAP and ExamView Tests 30% Average of Unit Performance Assessments 30% <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; text-decoration: none; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; msoasciithemefont: minor-latin; msohansithemefont: minor-latin; mso-bidi-font-family: Arial; msobidifontfamily: Arial;"> <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial;">93 - 100 = A 82 - 92 = B 71 - 81 = C 60 - 70 = D 0 - 61 = F
 * __<span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial;">Grading: __**
 * __<span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial;">Grading Scale __**<span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; msoasciithemefont: minor-latin; msohansithemefont: minor-latin; msotabcount: 1; mso-bidi-font-family: Arial; msobidifontfamily: Arial;">