Information Computing - IT Assignment Help

Assignment Task

Course Description:

This course presents the basic concepts of information systems and computer literacy. The course incorporates theory as well as hands-on practice which focuses on spreadsheets and database management systems (DBMS).

Course Competencies

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.

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.

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.

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.

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.

This IT Assignment Help has been solved by our IT Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.