In the current vocational education system in China, there is an obvious articulation fault between secondary vocational education and higher education, and the traditional teaching mode is difficult to meet the demand for composite talents in the digital era. Industrial transformation and upgrading puts forward higher requirements for skilled talents, while the existing talent cultivation mode is still deficient in the combination of theory and practice, and school-enterprise collaborative education. This paper uses computational optimization method and new media assisted technology to construct a multivariate instructional design talent cultivation model for the articulation of secondary education and higher education. The study adopted the DBSCAN density clustering algorithm to analyze the talent training data, established the talent training quality evaluation index system by using principal component analysis, and collected 2649 valid samples through questionnaires for empirical research. The results show that in the correlation test between the existing problems of talent cultivation and the single direction of college graduates’ professional competence mastery, the Pearson’s chi-square value is 3.47, and the significance is 0.055; the principal component analysis extracts four key factors, and the cumulative variance contribution rate reaches 84.733%; the common degree of seven variables in the evaluation system of the faculty is more than 0.825, and the interpretable variance is controlled at 0.409 within 0.409; cluster analysis divided the 10 institutions into 3 categories, and the average score of the principal components of the first category of institutions was 15.1229. The study constructed a model of articulation of professional teaching resource library, and formed a framework of multidimensional instructional design based on the assistance of new media. The model effectively improves the articulation quality of middle and higher vocational education, provides theoretical basis and practical path for cultivating compound skilled talents adapted to the needs of the digital era, and is of great significance in promoting the high-quality development of vocational education.