COPA Video Tutorials

1).Identify computer peripherals and internal components of a desktop computer.

2).Assemble components of desktop computer.

3).Practice on Windows interface and navigating windows.

4).Practice on managing files and folders using removable drives.

5).Customize the desktop

6).Settings and manage user accounts.

7).View system properties and control panel details.

8).Work with keyboard shortcut commands.

9).Print and scan document using different commands.

10).Burn data, video and audio files on CD/DVD using application software.

11).Use basic DOS commands for directory listing.

12).Manage files and folders using DOS commands.

13).Navigate within documents

14).Format documents

15).Save and share documents

16).Inspect documents for issues

17).Insert text and paragraphs.

18).Format text and paragraphs

19).Create and configure document sections

20).Create tables

21).Modify tables

22).Create and modify lists.

23).Create and manage reference elements

24).Create and manage reference tables

25).Insert illustrations and textboxes

26).Format illustrations and textboxes

27).Add text to graphic elements

28).Modify graphic elements

29).Add and manage comments

30).Manage change tracking

31).Perform mail merge

32).Open files in MS Excel

33).Import data

34).Navigate within workbooks

35).Format worksheets and workbooks

36).Customize options and views

37).Configure content for collaboration

38).Manipulate data

39).Format cells and ranges

40).Define and reference namedranges

41).Create and format tables

42).Manage tables and table data

43).Filter & Sorting in Excel

44).Insert references

45).Calculate and transform data

46).Format and modify text

47).Create Charts

48).Modify charts

49).Format charts

50).Create Pivot Tables

51).Open files in MS PowerPoint

52).Format PowerPoint Presentations

53).Modify slide masters, handoutmasters, and note masters

54).Change presentation options and views

55).Save and share PowerPointPresentations

56).Configure and present slideshows

57).Prepare presentation for collaboration

58).Insert text and paragraphs

59).Format text and paragraphs

60).Create and configure sections

61).Create tables

62).Simple select queries.

63).Create and modify bulleted text

64).Insert illustrations and textboxes

65).Format illustrations and textboxes

66).Add and modify text in graphic elements

67).Add Audio elements

68).Add Video elements

69).Add slide transitions

70).Add animations

71).Add and manage comments

72).Installation of MySQL.

73).Troubleshooting basicinstallation issues.

74).Creation and use of database.

75).Designing of tables.

76).Applying data integrity rules.

77).Using the DDL, DCL and DMLstatements.

78).Enforcing constraints, primarykey and foreign key.

79).Adding indices to Tables.

80).Simple select queries.

81).Insert and delete queries Update queries.

82).Using the Number, Date and Character functions. Joins and Functions

83).Joins, Group by, Having, Subquery.

84).Use the Internet

85).Create simple static web pages using CSS

86).Practicing the JavaScript increating dynamic HTML pages.

87).Embed JavaScript in HTML to Display Information in Web pages.

88).Use error handling techniques in JavaScript.

89).Use objects and classes in JavaScript.

90).Describe Animation and Multimedia using JavaScript.

91).Develop dynamic HTML pages using JavaScript.

92).Create and modify simple macros

93).Perform form controls and create simple data entry form with macros.

94).Look up data by using functions.

95).Use advanced date functions.

96).Create and modify advanced charts.

97).Create and modify Pivot Tables.

98).Demonstrate e-Commerce sites.

99).List features of e-commerce sites.

100).Use e-commerce sites to source an item.

101).Undertake transactions on an e-commerce site.

102).Add products to an ecommerce website.

103).Practice order processing.

104).Practice payment processing.

105).Identify common security issues.

106).Install, set up the environment & run Python.

107).Use Command Line and IDE tocreate and execute a python program.

108).Write and test a python program to demonstrate print statement, comments, and different types of variables.

109). Write and test a python program to perform data and data type operations, string operations, date,input and output, output formatting and operators.

110). Write and test a python program to perform data and data type operations, string operations, date,input and output, output formatting and operators.

111).Determine the sequence of execution based on operator precedence.

112).Construct and analyze code segments that use branching statements.

113).Construct and analyze code segments that use branching statements.

114).Construct and analyze code segments that perform iteration.

115).Construct and analyze code segments that perform iteration.

116).Document code segments using comments and documentation strings.

117). Construct and analyze code segments that include List comprehensions, tuple, set and Dictionary comprehensions.

118).Perform basic operations using built-in modules.

119).Solve complex computing problems by using built-in modules.