1. Load and set up the spreadsheet program. (I) 2. Create a properly-formatted worksheet file. (II) 3. Organize a problem for solution with spreadsheet software. (III) 4. Apply the principles of effective worksheet and database layout in building a spreadsheet template, using labels, numbers, and formulas. (III) 5. Enter, delete, and alter spreadsheet data. (IV) 6. Save a spreadsheet to disk and retrieve it. (V) 7. Print a spreadsheet on the printer and on disk, using spreadsheet print capabilities to enhance printed output. (VI) 8. Sort a spreadsheet in a variety of ways. (VII) 9. Use spreadsheet functions to prepare and print graphs. (VIII) 10. Create and use complex spreadsheet macros. (IX) 11. Use the spreadsheet's database techniques to locate, link, extract, and combine data from multiple spreadsheets. (X) 12. Use built-in statistical analysis features of spreadsheet software. (XI) 13. Manipulate matrices with spreadsheet software. (XII) 14. Design and implement a spreadsheet project which includes multiple, integrated spreadsheets. (XIII) Scoring: Within the course content noted below, the following points can be earned: Start Here Activities 10 Complete the Here Activities” in Canvas. “Start Assignments - Chapters 1-8 2,000 Textbook Case Problem - 20 SAM 2013 Training 20 – SAM 2013 Project - 100 SAM 2013 Exam 100 – Canvas Discussion - 10 250 points x 8 chapters = 2,000 points End of Course Assignments 100 SAM 2013 Final Exam 50 points – Personal Spreadsheet - 50 points TOTAL 2,110 NOTE: The of 2,110 points includes 110 points of extra however your final grade will be based on 2,000 points, credit, on the percentage as calculated in Canvas. not Grading: Grading will be as follows: Points Earned Grade Earned 1,800 or more "A" 1,600 1,799 "B" –
1. Load and set up the spreadsheet program. (I) 2. Create a properly-formatted worksheet file. (II) 3. Organize a problem for solution with spreadsheet software. (III) 4. Apply the principles of effective worksheet and database layout in building a spreadsheet template, using labels, numbers, and formulas. (III) 5. Enter, delete, and alter spreadsheet data. (IV) 6. Save a spreadsheet to disk and retrieve it. (V) 7. Print a spreadsheet on the printer and on disk, using spreadsheet print capabilities to enhance printed output. (VI) 8. Sort a spreadsheet in a variety of ways. (VII) 9. Use spreadsheet functions to prepare and print graphs. (VIII) 10. Create and use complex spreadsheet macros. (IX) 11. Use the spreadsheet's database techniques to locate, link, extract, and combine data from multiple spreadsheets. (X) 12. Use built-in statistical analysis features of spreadsheet software. (XI) 13. Manipulate matrices with spreadsheet software. (XII) 14. Design and implement a spreadsheet project which includes multiple, integrated spreadsheets. (XIII) Scoring: Within the course content noted below, the following points can be earned: Start Here Activities Complete the “Start Here Activities” in Canvas. 10 Assignments - Chapters 1-8 Textbook Case Problem - 20 SAM 2013 Training – 20 SAM 2013 Project - 100 SAM 2013 Exam – 100 Canvas Discussion - 10 250 points x 8 chapters = 2,000 points 2,000 End of Course Assignments SAM 2013 Final Exam – 50 points Personal Spreadsheet - 50 points 100 TOTAL NOTE: The of 2,110 points includes 110 points of extra credit, however your final grade will be based on 2,000 points, not on the percentage as calculated in Canvas. 2,110 Grading: Grading will be as follows: Points Earned Grade Earned 1,800 or more "A" 1,600 – 1,799 "B"
2017_Spring_CIS_114DE_Syllabus.docx