CSC 110 - Intro to Computers

1. Create and edit spreadsheets
   1. Understand the basic terms of a spreadsheet application, including row, column, cell, cell reference, formula, formula bar, sort, filter, fill handle, merged cells, relative reference, and absolute reference
   2. Manipulate the text and numbers in a spreadsheet application by performing entrances, selections, editing, finds, copying, replacements, alterations, rearrangements, rotations, formatting, reviews, corrections, printing, and saves
   3. Work a range of cells in a worksheet, including selecting a range, copying a range, clearing a range, referencing a range, applying format changes, changing width or height, use Auto Calculate and applying other functions to calculate values
   4. Insert and delete rows and columns from a worksheet
   5. Enhance the spreadsheet with tables, hyperlinks, illustrations, format painter, and charts derived from data in the workbook
   6. Manage worksheets in the workbook by coloring and rearranging worksheet tabs, renaming tabs, and using page setup, formatting, scaling, backgrounds, breaks, borders, and titles
   7. Implement conditional formatting
   8. Employ commands available to review and correct the spreadsheet such as spell check, track changes, freeze and unfreeze rows or columns, add comments, and change workbook views
   9. Alter standard document properties
   10. Save a spreadsheet in multiple formats including the default format, PDF and as a Web page
   11. Print, publish, submit, or otherwise share a workbook
   12. Identify advanced features such as nested functions, formula audits, PivotTables, PivotCharts, retrieving external data, and Web integration
2. Apply functions and formulas in a spreadsheet
   1. Understand the formula ribbon
   2. Enter formulas using the keyboard and Point mode
   3. Incorporate absolute and relative cell references in a formula
   4. Verify formulas and the results of a formula
   5. Use math functions to calculate values
   6. Execute logical tests using the IF function
   7. Utilize date and time functions
   8. Manipulate text with functions
   9. Display the formulas in cells rather than the resulting value
   10. Perform What-if analysis and Goal Seek in a worksheet
   11. Import data from a Web source using a Web query
3. Demonstrate fundamental skills in a database management system
   1. Describe the features of the application windows
   2. Create, save, store, and retrieve a database and various database objects, including tables, queries, forms and reports
   3. Manipulate a table, open a table, close a table, update table design, edit field properties, change the primary key, add records, change records, delete records, search records, sort records, filter records, and print the contents of a table
   4. Understand the purpose and necessity of queries and querying a database
   5. Produce and save queries that provide accurate results when executed
   6. Construct various queries using parameters, joins, calculated fields, and compound criteria
   7. Change how the results of a query are displayed; filter, sort, group and omit duplicates
   8. Apply mass changes to a database using a query
   9. Create and use forms
   10. Develop and print a report
   11. Print, publish, submit, or otherwise share objects in the database
   12. Identify advanced uses such as integration features
4. Practice principals for effective database design and maintenance
   1. Explain databases and database management systems and related terms, including data, database, database object, table, datasheet, query, form, report, expression, filter, and controls
   2. Design a database to satisfy a collection of requirements
   3. Determine an appropriate storage location for the database
   4. Develop naming conventions to be used in database objects
   5. Identify the requirements of database tables including primary keys, fields, data types, table relationships, and steps that can be taken to reduce redundancy
   6. Establish relationships between tables
   7. Discern the best candidates for primary key and foreign key fields
   8. Specify and enforce referential integrity
   9. Create validation rules
   10. Use lookup fields and multi-valued look-up fields
   11. Alter standard database properties
   12. Try special database operations, including backup, recover, repair, compacting, and checking for dependent objects
5. Utilize a word processing application to display graphs and charts generated from spreadsheets and databases in a professionally formatted document
6. Develop a PowerPoint slideshow with presentation graphics software to display graphs and charts generated from spreadsheets and databases in a professionally formatted presentation
7. Demonstrate an Understanding of the Windows operating system.
   1. Start and use a Windows App
   2. Explain how to create folders and rename files
   3. Summarize how to modify and save documents
   4. Search help topics
8. Evaluate digital citizenship through class discussions
   1. Discuss Digital Literacy a World of Technology
   2. Describe Internet Searching, Sharing & Communicating
   3. Review Computers and Mobile Devices
   4. Summarize Digital Safety and Security
   5. Discuss Computer & Mobile Device Hardware
   6. Define Digital Device Input and Output
   7. Examine Operating Systems Resources
   8. Assess Communication & Networks
   9. Illustrate Information and Data Management