Syllabus

 **BUSINESS TECHNOLOGIES ****CIS 155—PC Spreadsheet Concepts (Excel) **   //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 class exposes the student to a wide range of uses of the electronic spreadsheet with special emphasis on using it as a business tool. It includes fundamentals and terms, creating and saving workbooks, entering and using formulas, formatting, printing, multiple-page workbooks, creating charts, entering and using functions, managing lists, and simple macros.
 * Pre-requisite CIS 118 **
 * Credit Hours 3 post-secondary 0.25 high school **
 * Duration of Course 45 hours **
 * __Required Course Resources __**
 * __Course Description __****<span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-hansi-theme-font: minor-latin;">: **<span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-hansi-theme-font: minor-latin;">

The successful learner will be able to: <span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol; msobidifontfamily: Symbol; msofareastfontfamily: Symbol; msolist: Ignore;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-hansi-theme-font: minor-latin;">Work with cells <span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol; msobidifontfamily: Symbol; msofareastfontfamily: Symbol; msolist: Ignore;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-hansi-theme-font: minor-latin;">Edit, move, copy, delete cell contents <span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol; msobidifontfamily: Symbol; msofareastfontfamily: Symbol; msolist: Ignore;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-hansi-theme-font: minor-latin;">Work with AutoFill, AutoSum and AutoFormat features <span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol; msobidifontfamily: Symbol; msofareastfontfamily: Symbol; msolist: Ignore;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-hansi-theme-font: minor-latin;">Locate and open existing workbooks, save, create folders, and use templates <span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol; msobidifontfamily: Symbol; msofareastfontfamily: Symbol; msolist: Ignore;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-hansi-theme-font: minor-latin;">Apply formatting to worksheets <span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol; msobidifontfamily: Symbol; msofareastfontfamily: Symbol; msolist: Ignore;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-hansi-theme-font: minor-latin;">Insert and delete, hide and unhide, and freeze and unfreeze rows and columns <span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol; msobidifontfamily: Symbol; msofareastfontfamily: Symbol; msolist: Ignore;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-hansi-theme-font: minor-latin;">Use Paste Function and formula palette <span style="font-family: Symbol; letter-spacing: -0.15pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol; msobidifontfamily: Symbol; msofareastfontfamily: Symbol; msolist: Ignore;">· <span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-hansi-theme-font: minor-latin;">Use date and financial functions
 * __<span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-hansi-theme-font: minor-latin;">Course Competencies __****<span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-hansi-theme-font: minor-latin;">: **<span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-hansi-theme-font: minor-latin;">

<span style="font-family: 'Calibri','sans-serif';">Final Grades will be calculated as follows: Average of all Concepts Check assignments 10% Average of all Skills Check assignments 30% Average of all Case Study assignments 30% Average of all tests 30%
 * __<span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-bidi-font-family: Arial;">Grading __**

<span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-hansi-theme-font: minor-latin;">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-bidi-font-family: Arial; mso-hansi-theme-font: minor-latin;">Grading Scale __**<span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-hansi-theme-font: minor-latin; msoasciithemefont: minor-latin; msobidifontfamily: Arial; msohansithemefont: minor-latin; msotabcount: 1;">

||
 * **<span style="font-family: 'Calibri','sans-serif'; letter-spacing: -0.15pt; mso-bidi-font-family: Arial;">A letter grade of “C” or higher must be earned to have course applied to program certificate. **