CSC 116 - Information Computing

1. Create and edit spreadsheets
   1. Describe the purpose of spreadsheets and their common components
   2. Identify the functionality available on the command ribbons and put them to proper use
   3. Manipulate text and numbers by entering, selecting, editing, finding, copying, and rearranging
   4. Format the contents of a spreadsheet and copy formatting and style from one item to another
   5. Implement conditional formatting
   6. Manage rows and columns by inserting, deleting, altering height, changing width and using autofit
   7. Enhance the workbook by coloring, rearranging and renaming worksheet tabs
   8. Utilize page setup, formatting, scaling, backgrounds, breaks, borders, and titles
   9. 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
   10. Alter standard document properties
   11. Save a spreadsheet in multiple formats including the default format, PDF and as a web page
   12. Print, publish, submit or otherwise share a workbook
2. Incorporate functions and formulas in a spreadsheet
   1. Demonstrate using the formula ribbon and differentiate  between automatic and manual calculation options
   2. Incorporate absolute, relative and 3D references in a formula
   3. Use math functions such as SUM, AVERAGE, COUNT, COUNTA, MIN, MAX
   4. Execute logical tests using functions such as IF, SUMIF, COUNTIF
   5. Utilize date and time functions
   6. Implement financial functions such as PMT, NPV
   7. Demonstrate the use of VLOOKUP, XLOOKUP function
   8. Verify formulas and the results of a formula
   9. Display the formulas in cells rather than the resulting value
3. Evaluate worksheet data and create reports
   1. Perform What-if analysis with tools such as scenarios, goal seek and data table
   2. Create and format column charts, line charts, and pie charts
   3. Implement chart components such as data labels, data point and data series
   4. Implement filters to display a subset of data
   5. Alter the chart type and style
   6. Summarize data with a pivot tables and pivot charts
   7. Import data into and export data from a spreadsheet
4. Examine fundamental concepts in a database management system (DBMS)
   1. Describe the features and components of a DBMS
   2. Define relational database terminology such as byte, field, record, table, data type, query and relationship
   3. Explain the purpose and necessity of queries and querying a database
   4. Summarize the basic concepts of SQL
   5. Introduce database software and provide an overview
5. Support principles of effective database design and maintenance
   1. Design a database to satisfy a collection of requirements
   2. Create tables in datasheet and design views
   3. Identify the requirements of database tables including fields, data types, format, input masks and steps that can be taken to reduce redundancy
   4. Establish relationships between tables
   5. Enforce referential integrity with primary key and foreign key fields
   6. Specify validation rules and default values
   7. Add, change and delete records in a table
   8. Update table design and edit field properties
   9. Use lookup fields and multi-valued look-up fields
   10. Create forms using wizards
   11. Produce reports using wizards
   12. Manage a database with operations such as backup, recovery, repair, compacting and checking for dependent objects
6. Produce queries that provide accurate results when executed
   1. Construct queries with relational and conditional operators (>, >=, <, <=, =, <>)
   2. Produce queries using logical operators (BETWEEN, OR, AND)
   3. Utilize the wildcard operator (*)
   4. Sort data in query results
   5. Form queries using aggregate functions and group by
   6. Develop cross-table queries
   7. Generate calculated fields
   8. Export, print, publish, submit or otherwise share query results
7. Utilize a word processing application for data display
   1. Use graphs in a professionally formatted document
   2. Use charts in a professionally formatted document
8. Develop a slideshow presentation to display data
   1. Construct graphs in a professionally formatted presentation
   2. Construct charts in a professionally formatted presentation
9. Demonstrate file management on a computer
   1. Make and save files
   2. Rename files
   3. Retrieve files
   4. Manage files
10. Appraise the principals and components of an Information System (IS)
    1. Differentiate the various types of information systems such as transaction processing, decision support, knowledge management, learning management, and database management
    2. Compare IS to Information Technology (IT)
    3. Describe methodologies used in the development and acquisition of IS
    4. Explain how information systems impact an organization’s operations and contribute to gaining a competitive advantage
    5. Identify the advantages and disadvantages of cloud-based information systems
    6. Summarize digital crime, digital security threats and security measures
11. Examine topics in technology
    1. Discuss digital literacy and digital citizenship
    2. Give examples of connecting and communicating online including types of websites and media
    3. Describe computer and mobile device hardware and software
    4. Identify programs, apps and tools
    5. Explain digital security risks and defenses